Curl - Sugarcrm

Hello

I'm having an issue with getting data to sugar. I have an old site with an old version of Chronoforms and this curl still works. But I can't make it work with the new version of Chronoforms 4.3.3

I did a screenshot of the curl setup
[attachment=1]Curl----chrono4.3.3.png[/attachment]

and a screenshot of the debug data
[attachment=0]DEbug-chrono.png[/attachment]

Is there something wrong?

Hi marcielo,

The standard* cURL action in CFV4 only accepts dynamic actions - that is, whatever is after the = sign will be replaced by an entry in the $form->data array.

And whatever is before the = sign is the parameter name that will be used to send the data.

So, I suspect that your first entry for input_text_3 is backwards; and the other two will fail because there is no value for $form->data['WebToLeadCapture'].

To send a fixed value you have to use a Custom code action to place it into the $form->data array e.g.

<?php
$form->data['WebToLeadCapture'] = 'WebToLeadCapture';
?>

then this value will work as you expect.

Bob

* My custom cURL [GH} action will accept either static or dynamic values - with the dynamic values in {}

Hi Bob

I installed the GH cURL action
The email field from chrono 'input_text_3' is dynamic and I want it to enter in the email field from sugar 'webtolead_email1'

I have the following in my GH cURL action:

input_text_3={webtolead_email1}
entryPoint=WebToLeadCapture
campaign_id=c7b57f2d-0000-3b17-0000-4bc30f0a0000

I did turn on the 'header in response' but I get nothing
I added the 'debugger' but no info from the curl action

I didn't add a costume code box cause as I understand it is only needed if I use the standard cURL action

Hi Marcielo,

That looks OK.

You should see the Debugger output OK :-(

By all means email or PM me the site URL and a SuperAdmin login and I'll take a quick look.

Bob

Hi Bob

OK, I managed to get the debug and the 'header response' to work. But it doesn't seem to tell anything of use (not to me anyways):

Data Array:

Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => test
    [event] => submit
    [Itemid] => 
    [input_text_3] => my@mail.com
    [submit] => submit now
    [734f4fb999b0ebfe30b871f17152bb59] => 1
    [curl_gh] => HTTP/1.1 200 OK
Date: Mon, 18 Jun 2012 14:42:56 GMT
Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
X-Powered-By: PHP/5.2.17
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: PHPSESSID=db175642927fea85c4d659d134f78412; path=/
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8
Thank you for your information (The thanks message I entered).
)

Validation Errors:

Array
(
)

Debug Data

    email
        2
            Result An email has been SENT successfully from (mysiste.com)my@site.com to test@mail.com
            Body 

phew I got it working


Hi Bill

Sorry to bug you I know you must be a pretty busy man.
Did you get a chance to take a look at it? I sent you a PM a week ago.
If you want I can also grant you access to a site where the curl works with the old version of chronoform.

I did some more test and I am getting more info from the debug then before, but the issue still remains:

Data Array:

Array
(
    [option] => com_chronoforms
    [tmpl] => component
    [chronoform] => test-Copy
    [event] => submit
    [Itemid] => 
    [name] => mr test
    [lastname] => test
    [input_text_3] => my@mail.com
    [submit] => submit
    [fd1702f62a9720b8af7b4c5cf5a116fe] => 1
    [curl_gh] => HTTP/1.1 200 OK
Date: Tue, 26 Jun 2012 09:15:44 GMT
Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4
X-Powered-By: PHP/5.2.17
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0
Pragma: no-cache
Set-Cookie: PHPSESSID=772dc8d4734cac8d5485d85ee8c44ce2; path=/
Transfer-Encoding: chunked
Content-Type: text/html; charset=UTF-8
Thanks for the info.
)

Validation Errors:

Array
(
)

Debug Data

    cURL [GH]
        cURL OK : the cURL function was found on this server.
        cURL Target URL: http://mysite.com/index.php
        Names + values (urldecoded)
            name :
            lastname :
            input_text_3 :
            entryPoint : WebToLeadCapture
            campaign_id : c7b57f2d-a244-3b17-7fd9-4bc30f0a5825
        cURL Values: name=&lastname=&input_text_3=&entryPoint=WebToLeadCapture&campaign_id=c7b57f2d-a244-3b17-7fd9-4bc30f0a5825
        cURL:Resource id #110
        cURL info: Array ( [url] => http://mysite.com/index.php [content_type] => text/html; charset=UTF-8 [http_code] => 200 [header_size] => 440 [request_size] => 248 [filetime] => -1 [ssl_verify_result] => 0 [redirect_count] => 0 [total_time] => 0.547582 [namelookup_time] => 0.009547 [connect_time] => 0.009623 [pretransfer_time] => 0.012824 [size_upload] => 110 [size_download] => 25 [speed_download] => 45 [speed_upload] => 200 [download_content_length] => -1 [upload_content_length] => 110 [starttransfer_time] => 0.542067 [redirect_time] => 0 )
        Response: HTTP/1.1 200 OK Date: Tue, 26 Jun 2012 09:15:44 GMT Server: Apache/2.2.22 (Unix) mod_ssl/2.2.22 OpenSSL/0.9.8e-fips-rhel5 mod_bwlimited/1.4 X-Powered-By: PHP/5.2.17 Expires: Thu, 19 Nov 1981 08:52:00 GMT Cache-Control: no-store, no-cache, must-revalidate, post-check=0, pre-check=0 Pragma: no-cache Set-Cookie: PHPSESSID=772dc8d4734cac8d5485d85ee8c44ce2; path=/ Transfer-Encoding: chunked Content-Type: text/html; charset=UTF-8 Thanks for the info.

Regards
Marcelo

Hi marcielo,

I just tried to login but got the "Username and password do not match or you do not have an account yet." error message.

The debug looks better but you aren't sending any data so that may be a problem? What are the required inputs for SugarCRM?

Bob

The error was on my side.

For other souls:
I had a very simple lead form with the following fields: Name, phone and email.
Sugar has a required field, the lastname field. If the last name field is not used in the curl, the curl won't work (mine was pointing to the first name field)

For my purpose I installed the GH cURL action (http://greyhead.net/how-to-docs/cfv4-curl-gh-action)

In the Params/Fields map - box I have the following:

last_name={name}
phonenr_c={phone}
webtolead_email1={email}
entryPoint=WebToLeadCapture
campaign_id=cbb7b44f2d-a114-1b12-1f39-3ec30a0a5825

In the 'On Submit' I have a 'Redirect User' action. This action needs to be last otherwise the curl won't work.

I think that sums it up.