submit Joomla form data to VTiger

ef

effemeer 08 Apr, 2014

[attachment=0]2014-04-08_192924.jpg[/attachment]

I built a form works fine with the first line like

<form name="New Lead" action="https://oms2.od1.vtiger.com/modules/Webforms/capture.php" method="post" accept-charset="utf-8" enctype="multipart/form-data">

but that overrides the Captcha checking and subsequent mails I'd like to send. It ends with a blank page with {"success":true,"result":"ok"} written on top,

The sequence I want to realise is:

1 Fill in the form,
2 press submit,
3 check captcha
4 on success send form to VTiger
5 check that transmission is sucessfull
6 send confirmation emails

How can I do this?

ca

calculus00 08 Apr, 2014

Hello effemeer,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
My form data isn't saving to the database correctly
How do I save form data to a database table?
How can I send form data to vTiger?
P.S: I'm just an automated service😉

ef

effemeer 09 Apr, 2014

Thanks Calculus00,

As a matter of fact I can save form data to VTiger, but it ends up with a success message from the server. By no means can I follow this up with an email, the display of a message or saving into a database.

I can't get Curl working neither.Always ends up with "Webform not found".

Max_admin 09 Apr, 2014

Hi effemeer,

How do you save the data to VTiger if the CURL doesn't work then ?

Please add a "debugger" action after the curl and check the displayed info.

Regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

ef

effemeer 09 Apr, 2014

I save the data with a Chronoforms form : <form id= "myform" action="https://oms2.od1.vtiger.com/modules/Webforms/capture.php" method="POST"> and using the Submit button.

The set I tried to submit with Curl was as follows (name = the name of the webform)

publicid=737a112ef5xxx927e32749f
name=name
firstname=First Name
lastname=Last Name
company=Company
email=Email
phone=Phone
designation=Title
fax=Fax
label:VAT_nr.=VAT nr.
label:CoC_/_KvK=CoC / KvK
lane=Street
code=Postal Code
city=City
country=Country
state=County
description=Description

I also tried the same set with curly brackets:

publicid=737a112ef5xxx927e32749f
name={name}
firstname={First Name}
lastname={Last Name}
company={Company}

I'll give it a new try followed by Debugger and keep you posted.

ef

effemeer 09 Apr, 2014

Here is the debugger code

[code]Data Array
Array
(
[option] => com_chronoforms5
[view] => form
[Itemid] => 160
[chronoform] => OMS
[event] => submit
[publicid] => 737a112ef56af7xxxa927e32749f
[name] => New Lead
[designation] => Dr.
[firstname] => Francis
[lastname] => Franck
[company] => Private
[email] => xxxx@multiwebxx.nl
[phone] => 3*********27
[fax] =>
[label:VAT_nr_] =>
[label:CoC_/_KvK] =>
[lane] => xx

 => 18xxxxxGV
    [city] => Bergen
    [country] => Netherlands
    [state] => --
    [description] => 1340
    [leadsource] => Web Site
    [captcha] => hg6tz
    [submit6] => Submit
    [curl] => HTTP/1.1 200 OK
Date: Wed, 09 Apr 2014 11:40:19 GMT
Server: Apache/2.2.22 (Ubuntu)
X-Powered-By: PHP/5.3.10-1ubuntu3.11
Cache-Control: max-age=2592000
Expires: Fri, 09 May 2014 11:40:19 GMT
Vary: Accept-Encoding
Content-Length: 58
Content-Type: text/html

{"success":false,"error":{"message":"Webform not found."}}
)
______________________________________

Array
(
    [23] => Array
        (
            [Curl] => Array
                (
                    [0] => CURL OK : the CURL function was found on this server.
                    [1] => $curl_values: 
                    [2] => curl_target_url: https://oms2.od1.vtiger.com/modules/Webforms/capture.php
                    [3] => curl_errors: 
                    [4] => curl_info: Array
(
    [url] => https://oms2.od1.vtiger.com/modules/Webforms/capture.php
    [content_type] => text/html
    [http_code] => 200
    [header_size] => 266
    [request_size] => 155
    [filetime] => -1
    [ssl_verify_result] => 20
    [redirect_count] => 0
    [total_time] => 0.930056
    [namelookup_time] => 0.193461
    [connect_time] => 0.355858
    [pretransfer_time] => 0.702414
    [size_upload] => 0
    [size_download] => 58
    [speed_download] => 62
    [speed_upload] => 0
    [download_content_length] => 58
    [upload_content_length] => 0
    [starttransfer_time] => 0.930015
    [redirect_time] => 0
    [certinfo] => Array
        (
        )

    [redirect_url] => 
)

                )

        )

)

Max_admin 09 Apr, 2014

Answer

Your first example would work but that would not process any CF actions because you have changed the action url!

The CURL config you have is wrong because you should use it in this format:
post_field_name=form_field_name

So, in order to post the "publicid" to VTiger, you must do 1 of 2 things:
#1- either have a field with this value in your form and use: publicid=field_name
#2- OR inject the field value before the CURL using a "Custom code" action (this method is more secure):

<?php
$form->data["publicid"] = "737a112ef5xxx927e32749f";
?>

then use:

publicid=publicid

The 2nd rule should be applied to all fields which don't exist in the form.

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

ef

effemeer 09 Apr, 2014

Thank you for your assistance. Super!
Curl works fine now and I get my email messages.

Forums

submit Joomla form data to VTiger