Vtiger CRM 6.2.0 Chrono form integration not working after upgrading Vtiger 5.4 to 6.2.0

I am using Joomla 2.5.27 and chrono form 4.0. Vtiger integration was working fine before upgrade.
But now (6.2.0) after submitting form data is not viewed in 'Lead Source'. I am not getting any error after submitting the form
Can you please let me know whats going wrong??

cURL [GH]

cURL OK : the cURL function was found on this server.
cURL Target URL: http://122.182.28.64/modules/Webforms/post.php
Names + values (urldecoded)
appKey : dc66d1a8b837fd5771a6ce148834c0a6
moduleName : Leads
cf_687 : Prospect
cf_692 : Mithi to contact me
lastname : Abhijit Joshi
company : d
mobile : 4444
email : abhi@mithi.com
leadsource : Conference
description : ,,,,,,,,,,Subscribe to the Mithi Newsletter---------------------------------------------------das
assigned_user_id :
cURL Values: appKey=dc66d1a8b837fd5771a6ce148834c0a6&moduleName=Leads&cf_687=Prospect&cf_692=Mithi to contact me&lastname=Abhijit Joshi&company=d&mobile=4444&email=abhi@mithi.com&leadsource=Conference&description=,,,,,,,,,,Subscribe to the Mithi Newsletter---------------------------------------------------das&assigned_user_id=
cURL:Resource id #119
cURL info: Array ( [url] => http://122.182.28.64/modules/Webforms/post.php [content_type] => [http_code] => 0 [header_size] => 0 [request_size] => 0 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0 [namelookup_time] => 0.000265 [connect_time] => 0 [pretransfer_time] => 0 [size_upload] => 0 [size_download] => 0 [speed_download] => 0 [speed_upload] => 0 [download_content_length] => -1 [upload_content_length] => -1 [starttransfer_time] => 0 [redirect_time] => 0 [certinfo] => Array ( ) )
Response:

Hi abhijitjoshi,

I have no idea - I guess that something must have changed in the way vTiger handles the WebForm submissions - do they have any documents explaining what is different in the new version?

Bob

Hi there,
Vtiger 6.2.0 has indeed a new way of handling forms, I'm not a programmer, but looking at their docs https://wiki.vtiger.com/vtiger6/index.php/Webforms I inferred that they are using an extra field to identify the form in their systems. There is an explanation for using wordpress cforms, they ask to included "publicid" among the form fields. That got me thinking.

This is what I'm doing:

First you have to create a webform in Vtiger, then you can use the post url and publicid value created by this action. No need to use the form html from Vtiger, we want to use chronoforms, don't we?

The trick is to use the post url from vtiger as the target url in Chronoforms CURL (GH) and to include a field publicid in the params/field map equalling the publicid value generated from the Vtiger form.
It works for me.
Cheers,
Antonio
ps: worth a cup of coffee?

Hi Antonio,

Thank you - I've quoted you in the vTiger FAQ

Bob

Hello,
I followed the steps mentioned by Antonio. But I am getting following error message

 [curl] => {"success":false,"error":{"message":"cf_687 does not have a value"}}

============================================================================

Here is log

Array
(
    [chronoform] => freetrial-freedomain
    [event] => submit
    [tvout] => ajax
    [publicid] => b99c78142a676e5deefed762a448a86a
    [Type_of_Lead] => Prospect
    [lastname] => Abhijit
    [company] => Mithi
    [email] => a@mithi.com
    [mobile] => 98989899
    [requirements] => TEST
    [captcha] => 
    [subscribe_checkbox] => Subscribe to the Mithi Newsletter
    [websitesource] => http://192.168.0.75/
    [submit6] => SUBMIT
    [freetrial-freedomain] => 
    [curl] => {"success":false,"error":{"message":"cf_687 does not have a value"}}
)

Array
(
)

Errors

Array
(
)

Debug Info

Array
(
    [29] => Array
        (
            [Curl] => Array
                (
                    [0] => CURL OK : the CURL function was found on this server.
                    [1] => $curl_values: publicid=b99c78142a676e5deefed762a448a86a&Type_of_Lead=Prospect&lastname=Abhijit&company=Mithi&email=a%40mithi.com&mobile=98989899
                    [2] => curl_target_url: http://122.182.28.64/modules/Webforms/capture.php
                    [3] => curl_errors: 
                    [4] => curl_info: Array
(
    [url] => http://122.182.28.64/modules/Webforms/capture.php
    [content_type] => text/html; charset=UTF-8
    [http_code] => 200
    [header_size] => 192
    [request_size] => 281
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.258068
    [namelookup_time] => 8.4E-5
    [connect_time] => 0.002393
    [pretransfer_time] => 0.002394
    [size_upload] => 130
    [size_download] => 68
    [speed_download] => 263
    [speed_upload] => 503
    [download_content_length] => 68
    [upload_content_length] => 0
    [starttransfer_time] => 0.257921
    [redirect_time] => 0
    [redirect_url] => 
    [primary_ip] => 122.182.28.64
    [certinfo] => Array
        (
        )

)

                )

        )

)

- Abhijit

Hi abhijitjoshi,

Are you sure that you are passing all the necessary values to vTiger - I notice that in your earlier post you had values that are not in the current one - these include cf_687.

old parameters

appKey=dc66d1a8b837fd5771a6ce148834c0a6
moduleName=Leads
cf_687=Prospect
cf_692=Mithi to contact me
lastname=Abhijit Joshi
company=d
mobile=4444
email=abhi @[at] mithi [dot] 

New parameters

publicid=b99c78142a676e5deefed762a448a86a
Type_of_Lead=Prospect
lastname=Abhijit
company=Mithi
email=a%40mithi.com
mobile=98989899

Bob

Hello,

I tried replacing the capture.php from http://trac.vtiger.com/cgi-bin/trac.cgi/ticket/7902
and now it is showing following error message :
[curl] => {"success":false,"error":{"message":"Required fields not filled"}}

Can you please check this link : https://discussions.vtiger.com/index.php?p=/discussion/166691/bug-fix-vtiger-6-webforms-fields-not-saving/p1
I am not sure about deleting & creating table vtiger_webforms_field

Log details :

Array
(
    [chronoform] => freetrial-freedomain
    [event] => submit
    [tvout] => ajax
    [publicid] => cc6fa12932e4b6bd906d84f8a46d90e8
    [Type_of_Lead] => Prospect
    [lastname] => a
    [company] => a
    [email] => a@mithi.com
    [mobile] => 1234567890
    [requirements] => s
    [captcha] => 
    [subscribe_checkbox] => Subscribe to the Mithi Newsletter
    [websitesource] => http://192.168.0.75/
    [submit6] => SUBMIT
    [freetrial-freedomain] => 
    [curl] => {"success":false,"error":{"message":"Required fields not filled"}}
)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [29] => Array
        (
            [Curl] => Array
                (
                    [0] => CURL OK : the CURL function was found on this server.
                    [1] => $curl_values: publicid=cc6fa12932e4b6bd906d84f8a46d90e8&cf_687=Prospect&lastname=a&company=a&email=a%40mithi.com&mobile=1234567890&description=s
                    [2] => curl_target_url: http://122.182.28.64/modules/Webforms/capture.php
                    [3] => curl_errors: 
                    [4] => curl_info: Array
(
    [url] => http://122.182.28.64/modules/Webforms/capture.php
    [content_type] => text/html; charset=UTF-8
    [http_code] => 200
    [header_size] => 192
    [request_size] => 281
    [filetime] => -1
    [ssl_verify_result] => 0
    [redirect_count] => 0
    [total_time] => 0.532131
    [namelookup_time] => 0.000167
    [connect_time] => 0.002327
    [pretransfer_time] => 0.002328
    [size_upload] => 130
    [size_download] => 66
    [speed_download] => 124
    [speed_upload] => 244
    [download_content_length] => 66
    [upload_content_length] => 0
    [starttransfer_time] => 0.532077
    [redirect_time] => 0
    [redirect_url] => 
    [primary_ip] => 122.182.28.64
    [certinfo] => Array
        (
        )

)

                )

        )

)

-Abhijit

Hi Abhijit,

Sorry, I don't know much about vTiger and haven't used v6. Given the message I would check first to see exactly what fields are required in vTiger.

Bob