Chronoforms to Vtiger

b.a.j.koopman 07 Sep, 2010
He guys I'v been trying to get my (test)form as a lead in Vtiger but i can't get it working.

I started with the toturial: http://forums.vtiger.com/download.php?id=4286

Have my Webforms.config.php set up with:

*********/

$enableAppKeyValidation = 'false';
$defaultUserName = 'bedrijfs';
$defaultUserAccessKey = 'dblyv6hNqlVzG4I';

$defaultOwner = 'bedrijfs';
$successURL = '';
$failureURL = '';

/**
 * JSON or HTML. if incase success and failure URL is NOT specified.
 */
$defaultSuccessAction = 'HTML';

$defaultSuccessMessage = 'LBL_SUCCESS';

?>


Curl plugin is up -- showing green

and the php code in the chornoform extension:

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">First Name</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="First Name" id="firstname" name="firstname" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Last Name</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="Last Name" id="lastname" name="lastname" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Company</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="Company" id="company" name="company" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_textbox">
    <label class="cf_label" style="width: 150px;">Phone</label>
    <input class="cf_inputbox" maxlength="150" size="30" title="Phone" id="text_3" name="phone" type="text" />
  
  </div>
  <div class="cfclear"> </div>
</div>

<div class="form_item">
  <div class="form_element cf_button">
    <input value="Submit" name="submit" type="submit" />
  </div>
  <div class="cfclear"> </div>
</div>


Curl gives the following code:

CURL OK : the CURL function was found on this server.
$params: JParameter Object ( [_raw] => debugging=0 target_url=http:// header_in_response=0 onsubmit=before_email [_xml] => [_elements] => Array ( ) [_elementPath] => Array ( [0] => /mnt/weba/23/91/52273691/htdocs/libraries/joomla/html/parameter/element ) [_defaultNameSpace] => _default [_registry] => Array ( [_default] => Array ( [data] => stdClass Object ( [debugging] => 1 [target_url] => http://67.15.172.10/~bedrijfs/vtiger/modules/Webforms/post.php [header_in_response] => 0 [onsubmit] => before_email ) ) ) [_errors] => Array ( ) )

I've given the field names the correct field names of the Vtiger database which were shown in the sql table. (exported it to a pdf). Also I've included in 'Extra field data':"moduleName=Leads and leadsource=Web Site".

I'm out of ideas now and hope someone has a suggestion!

The strange thing is i've set debugging mode to yes but i don't get any feedback from the form. It just shows a blank page within the website (Template style from website included)

Thank you

Bart
b.a.j.koopman 07 Sep, 2010
Ok guys i get the debugging mode. I was expecting something different. Probably looked over it as i'm a bit sleepy. But CURL gives [_errors] => Array ( ) ). I do not realy know what it means but I think it means it doesn't know where to place the data. Am I correct?
b.a.j.koopman 07 Sep, 2010
The form debug mode shows the following:

1. Form passed first SPAM check OK
2. Form passed the submissions limit (if enabled) OK
3. Form passed the Image verification (if enabled) OK
4. Form passed the server side validation (if enabled) OK
5. $_POST Array: Array ( [moduleName] => Leads [firstname] => Bart [lastname] => van Schuitbescui [company] => Corpsnetto B.V. [phone] => 010-00000000 [submit] => Submit [34ad578dff921d16365ed07291d9349e] => 1 [1cf1] => e873f832fa33ed352a1138fb51585a61 [chronoformname] => contactform )
6. $_FILES Array: Array ( )
7. Form passed the plugins step (if enabled) OK
8. Debug End

GreyHead 08 Sep, 2010
Hi b.a.j.koopman ,

Sorry, I overlooked this post.

I don't see any debug output from the cURL plug-in so wonder if you have it enabled on the Form Plug-ins tab?

Have you read this thread?

Bob
b.a.j.koopman 08 Sep, 2010
yes I did but after a while i didn't know what to do any more. Looks a bit the same. Going to follow this. Still I don't get the debug from curl after submit as shown in this threat. And I don't have a redirect url. It is really annoying I don't know what is happening.
b.a.j.koopman 08 Sep, 2010
ok. I dont know what happend but i turned CURL on. Saved it. closed it. Look again and CURL was turned of. Reapeatedly turnining it on finaly did the trick. Now I get the following. I didn't look at it before I post this because I was so excited!

externalrequest=1
cf_CURL debug info
$curl_values: firstname=Berrie&lastname=van+Schuitbescui&phone=010-00000000&company=Corpsnetto+B.V.&submit=Submit&moduleName=Leads&leadsource=Web+Site&appKey=e90908bafd82a5c434d2c19d637e3e79
$params->target_url: http://clev9.com/~bedrijfs/vtiger/modules/Webforms/post.php
$ch: Resource id #110
CURL response: HTTP/1.1 200 OK Date: Wed, 08 Sep 2010 09:36:14 GMT Server: Apache/1.3.41 (Unix) mod_gzip/1.3.26.1a mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_ssl/2.8.31 OpenSSL/0.9.8e-fips-rhel5 PHP-CGI/0.5 FrontPage/5.0.2.2635.SR1.2 X-Powered-By: PHP/5.2.9 Connection: close Transfer-Encoding: chunked Content-Type: text/html

Record you are trying to access is not found. Go Back.

GreyHead 08 Sep, 2010
Hi b.a.j.koopman,

That's looking much better.

Bob
b.a.j.koopman 08 Sep, 2010
wat does

$ch: Resource id #110



mean?

I think the problem lies in Vtiger. I'm going to post a topic in the Vtiger Help Forum. I still could use some suggestions from you guys. It was a small thing I needed to change but it made a big difference. Now I'm going a step forward.
b.a.j.koopman 08 Sep, 2010
Ok now we are getting somewhere. I've made a mistake with adding moduleName=Leads instead of ModuleName=Leads

Now I get the following CURL debug info:

cf_CURL debug info
$curl_values: firstname=Berrie&lastname=van+Schuitbescui&phone=010-00000000&company=Corpsnetto+B.V.&submit=Submit&ModuleName=Leads&leadsource=Web+Site&appKey=e90908bafd82a5c434d2c19d637e3e79
$params->target_url: http://clev9.com/~bedrijfs/vtiger/modules/Webforms/post.php
$ch: Resource id #110
CURL response:
vtiger logo
Failed to add entry in to vtiger CRM.
Error Code: ACCESS_DENIED
Error Message: Permission to perform the operation is denied for name

b.a.j.koopman 08 Sep, 2010
I'v followed almost every lead on this problem. Bob, the link you showed. Configured the webforms.config.php several times with diverent approaches.

My question now is. Witch name does the debug mode mean?
GreyHead 08 Sep, 2010
Hi b.a.j.koopman,

The "$ch: Resource id #110" is just connection identifier, technical stuff. You are connecting to vTiger OK but there is some mismatch with the info vTiger is expecting to receive. Basically I think it's saying that you aren't providing the right info to sign in correctly.

Hmmm . . . I just read the vTiger tutorial which I hadn't seen before and that suggests the error message is more generic than that.

I'm afraid that I don't know what else to suggest.

Bob
GreyHead 08 Sep, 2010
Hi b.a.j.koopman ,

The one from the vTiger forums you linked to - it mentions that error message right at the end.

Bob
b.a.j.koopman 08 Sep, 2010
above I concluded I had made a mistake by using moduleName instead of ModuleName but as described in the Vtiger tut in the picture on page 6 the correct one should be moduleName.

Than we're back to the error message:

Record you are trying to access is not found.



Which record tries the form to acces? I've looked in several php files but can't realy see what's hapening. (cause I'm not that experienced with php)
b.a.j.koopman 09 Sep, 2010
The problem seems to be with Vtiger in the Database (STRIK_TRANS_TABLE). When I succeed I will give you an update.
This topic is locked and no more replies can be posted.