Forums

Hello I am spanish i don't write very well english, please excuseme.

I have joomla 2.5 and chronoforms v4.

How to make one form to send the data to vtiger? I see this post http://www.digitalbuz.com/2010/02/04/joomla-vtiger-crm-integration-using-chronoforms/ But I can't make to work.

Please I need help.

Thank's all and sorry for my english. Saludos!

Hi v116,

ChronoForm v4 is a little different from v3 but most of this article should still work OK.

What are the settings that you have in your cURL action?

Bob

Hello, i make the form with the wizard, in the drag and drop mode i insert the curl on submit action.
In the tarjet url https://mydomain.com/vtigercrm/modules/Webforms/post.php but dont work.

When write in the general page in the "Submit URL" the url https://mydomain.com/vtigercrm/modules/Webforms/post.php i recibe the mesage from vtiger "No se ha podido añadir la entrada en vtiger CRM.
Código Error: ACCESS_DENIED
Mensaje Error: Permission to perform the operation is denied for name"

I thing what the problem is in the "moduleName=Leads" or "AppKey=9898fasdfa798" parametrer. I don´t how pass this parametrer.


Thank very much you for your help and sorry for my english.

Hi v116,

What are the settings that you have in your cURL action?

The standard CURL action will only accept $form->data array names as values for the name=data pairs. For example, if $form->data['xxx'] is set then you can use var_name=xxx

This means that static values like Leads have o be put into the $from->data array using a Custom Code action before the CURL action:

<form->data['moduleName'] = 'Leads';

then you can put this in the CURL action

moduleName=moduleName

Bob

PS If you use my cURL [GH] action then you can use either static or dynamic values and avoid this extra step:

moduleName=Leads
AppKey=9898fasdfa798
userName={user_name}

Hello bob.

In window "Drop"->"Events"->"onsubmit"->"Check Captcha"->"onsuccess"->"Custom-code":
Settings:
Mode -> Controller
Action Label -> moduleName=Leads
Code -> <form->data['moduleName'] = 'Leads';

In the same window "Drop"->"Events"->"onsubmit"->"Check Captcha"->"onsuccess"-> "Curl":
Tarjet url -> https://mydomain.com/vtigercrm/modules/Webforms/post.php
Header in response ? -> No
Params/Fields map -> moduleName=moduleName

This is ok? I don't work... Please Help!!!! thanks very much

Hi v116,

I think that

<form->data['moduleName'] = 'Leads';

should be

$form->data['moduleName'] = 'Leads';

and I recommend that you do not put actions in the On Success events of other actions. Put them in sequence after the Check Captcha action. it's tidier and sometimes more reliable.

Bob

where I put this parameter? I don't understand you, sorry.

Hi v116,

I copied that from your post

In window "Drop"->"Events"->"onsubmit"->"Check Captcha"->"onsuccess"->"Custom-code":
Settings:
Mode -> Controller
Action Label -> moduleName=Leads
Code -> <form->data['moduleName'] = 'Leads';

Bob

Hello bob, thanks for your help, but my form for vtiger don't work. The email with data rules, but curl not. I probe a module form for joomla (I don like this module) and works correctly.

Please, help me. thanks

Hi v116,

Please see this post. Not much else I can suggest without the information I asked for there.

Bob

Hi v116,

Please see this post. Not much else I can suggest without the information I asked for there.

Bob

Hello bob, thanks for your help but I am not a developer and I don't know very english, I dont understand your indications. I need one easy solution.

I make the form with the indications of this post http://www.digitalbuz.com/2010/02/04/joomla-vtiger-crm-integration-using-chronoforms/ but this is the version 3 of chronoforms and I use he version 4. I need know only what are the indications for version 4.

Very thanks for your help.

Hi v116,

I understand that you are copying a v3 article and it probably won't work directly with CFv4.

To repeat again: What are the settings that you have in your cURL action?

If you can’t find these then you will need help from someone with some more techical knowledge.

Bob

Hi v116,

I understand that you are copying a v3 article and it probably won't work directly with CFv4.

To repeat again: What are the settings that you have in your cURL action?

If you can’t find these then you will need help from someone with some more techical knowledge.

Bob

Hello Bob, I use the wizard, and the settings In the curl action are :

In the tarjet url : https://mydomain.com/vtigercrm/modules/ ... s/post.php
Header in response ? -> No
Params/Fields map -> moduleName=moduleName

:-)

Hi v116,

But that is not enough. The article says

In the list of fields, you need to map your Joomla form field names to the vTiger field names. The left side shows all the fields you created in Chronoforms. The right side needs to contain the corresponding field name in vTiger. Again, for any field that is not standard inside the vTiger "Leads" table, you'll need to add it to vTiger as a custom field (see steps above).

Bob

Hi v116,

But that is not enough. The article says

In the list of fields, you need to map your Joomla form field names to the vTiger field names. The left side shows all the fields you created in Chronoforms. The right side needs to contain the corresponding field name in vTiger. Again, for any field that is not standard inside the vTiger "Leads" table, you'll need to add it to vTiger as a custom field (see steps above).

Bob

Yes Bob, my problem is recibe the mesage from vtiger:

"No se ha podido añadir la entrada en vtiger CRM. Código Error: ACCESS_DENIED
Mensaje Error: Permission to perform the operation is denied for name"

I thing what the problem is in the "moduleName=Leads" or "AppKey=9898fasdfa798" parametrer. I don´t how pass this parametrer in the chronoforms v4.

Please one solution to conect joomla to vtiger with a form of chronoforms v4!!!!!

Por favor, necesito ayuda para crear un formulario que remita datos de contacto a vtiger, estoy usando chronoforms v4 y joomla 2.5

He visto tutoriales para la version 3, ¿algún how to para la version 4 ??



Muchas gracias!

Hi v116,

Please read the article and do as it says. You need a full set of variables in the fields/params box.
So far you have only entered one as far as I can tell.

Bob

Hi v116,

Please read the article and do as it says. You need a full set of variables in the fields/params box.
So far you have only entered one as far as I can tell.

Bob

Hello Bob, in the fields/params what are the variables?

The leads of form?one example : input_text_1=vt_firstname
input_text_2=vt_lastname
input_text_5=vt_company

And what happens with the message of vtiger " Acces Denied"?

Thanks Bob
Un saludo y muchas gracias por tu tiempo y ayuda.

Hi v116,

From the help on the cURL action

Multi line format of the fields names:
e.g:curl_param_name=form_field_name

Bob

:cry:

Hi v116,

I hope that you are feeling better now.

Please just read the article and the posts here and do as they say. It is very difficult to help you when all you can say is 'it doesn't work'.

Bob

Sigo muy interesado en solventar el problema y poder crear un formulario para pasar datos de contacto a Vtiger desde Joomla.

Por favor, si alguien sabe como hacerlo o lo ha realizado con chronoforms v4 que deje un enlace a información o de las indicaciones clave para llevarlo a cabo.


Muchas gracias

Hi v116,

Por favor, acabo de leer el artículo y los mensajes aquí y hacer lo que dicen. Es muy difícil para ayudarle cuando lo único que puedo decir es 'no funciona'.

Si desea ayuda, por favor, pruebe las cosas que sugerimos y proporcionar la información que se solicita. Si usted no hace que los desechos de su tiempo y el mío.

Bob

Please just read the article and the posts here and do as they say. It is very difficult to help you when all you can say is 'it doesn't work'.

If you want help then please try the things that we suggest and provide the information that is asked for. If you don't do that it wastes your time and mine.

I am not buy you a beer.

I make a form with chornoforms v4 in joomla and send the data to vtiger pre-contact.

I use in the "forms manager" the "Submit URL" with the url of vtiger, ej:http://localhost/modules/Webforms/post.php

and in the "Form tag attachment" i put this :<input type="hidden" name="moduleName" value="Leads" />

For example in the textbox of the form use the "Fieldname" firstname this is a value of lead of vtiger, other leads are:

leadsource=leadsource
firstname=firstname
lastname=lastname
company=company
website=website
phone=phone
fax=fax
mobile=mobile
email=email
country=country
state=state
city=city
code=code
pobox=pobox
lane=lane
industry=industry
description=description

The data send to vtiger but the funcions of chronoforms captcha and send to email don't work simultaneosly.

Please help, thanks

I make a form with chornoforms v4 in joomla and send the data to vtiger pre-contact.

I use in the "forms manager" the "Submit URL" with the url of vtiger, ej:http://localhost/modules/Webforms/post.php

and in the "Form tag attachment" i put this :<input type="hidden" name="moduleName" value="Leads" />

For example in the textbox of the form use the "Fieldname" firstname this is a value of lead of vtiger, other leads are:

leadsource=leadsource
firstname=firstname
lastname=lastname
company=company
website=website
phone=phone
fax=fax
mobile=mobile
email=email
country=country
state=state
city=city
code=code
pobox=pobox
lane=lane
industry=industry
description=description

The data send to vtiger but the funcions of chronoforms captcha and send to email don't work simultaneosly.

Please help, thanks

Ahhh sorry, in the config archive vtiger "Webforms.config.php" set the value $enableAppKeyValidation = '';

And sorry for my english i am spanish

Please, help me with the captcha and email submit, thank you very much

Hi v116,

If you use a Submit URL then, as the message says, "Adding a submit URL will disable all the form "on submit" event functions." The form data is sent directly to the Submit URL, ChronoForms never sees it and so can do nothing with it.

and in the "Form tag attachment" i put this :<input type="hidden" name="moduleName" value="Leads" />

This makes no sense at all. Please remove it. To add a Hidden input to your form put it in the Preview box (or not at all in this case).

Please try these changes and see what messages you get from VTiger.

Bob

With this config, vtiger recibe the leads from form and works correct, when remove <input type="hidden" name="moduleName" value="Leads" /> don't work.

Hi v116,

That still sounds wrong to me. Please take a Form Backup using the icon in the Forms Manager and post it here (as a zipped file) or PM or email it to me and I'll take a closer look.

Bob

this is the form code:

<div class="ccms_form_element cfdiv_header multiline_start multiline_add" id="autoID-8c10086c305625cd13703196572117a5_container_div"><h1 style="text-align: center;">Formulario de solicitud de información</h1>
<p style="text-align: left;"> </p>
<hr />
<p> </p>
<p style="text-align: left;">     Por favor rellene el siguiente formulario, nos pondremos en contacto con usted lo antes posible.</p>
<p style="text-align: left;"><img style="float: left;" src="images/formulario-protect.jpg" alt="formulario-protect" width="310" /></p>
<p style="text-align: left;"> </p>
<h4 style="margin-left: 330px; text-align: justify;">Sus datos personales los enviara en una conexión segura cifrada (SSL) y no serán vistos ni compartidos con terceros, consulte el apartado de <a href="index.php?option=com_content&view=article&id=17:politica-de-privacidad&catid=25:v-services&Itemid=353" target="_blank">protección de datos</a> para mas información.</h4>
<p> </p>
<h4 style="margin-left: 330px; text-align: justify;">Muchas gracias.</h4>
<p> </p>
<p> </p>
<hr />
<p> </p><div class="clear"></div></div><div class="ccms_form_element cfdiv_text" id="firstname_container_div"><label for="firstname">Nombre :</label><input id="firstname" maxlength="150" size="30" class=" validate['required','alpha']" title="" type="text" value="" name="firstname" />
<div class="clear"></div><div id="error-message-firstname"></div></div><div class="ccms_form_element cfdiv_text" id="lastname_container_div"><label for="lastname">Apellidos :</label><input id="lastname" maxlength="150" size="30" class=" validate['required','alpha']" title="" type="text" value="" name="lastname" />
<div class="clear"></div><div id="error-message-lastname"></div></div><div class="ccms_form_element cfdiv_text" id="email_container_div"><label for="email">Email :</label><input id="email" maxlength="150" size="30" class=" validate['required','email']" title="" type="text" value="" name="email" />
<div title="Email :" rel="Introduzca una dirección de correo electrónico para ponernos en contacto con usted." class="tooltipimg"><a href="#">?</a></div><div class="small-message">Dirección de correo electrónico.</div><div class="clear"></div><div id="error-message-email"></div></div><div class="ccms_form_element cfdiv_text" id="country_container_div"><label for="country">País : </label><input id="country" maxlength="150" size="30" class="" title="" type="text" value="" name="country" />
<div class="clear"></div><div id="error-message-country"></div></div><div class="ccms_form_element cfdiv_text" id="city_container_div"><label for="city">Población :</label><input id="city" maxlength="150" size="30" class=" validate['required']" title="" type="text" value="" name="city" />
<div class="clear"></div><div id="error-message-city"></div></div><div class="ccms_form_element cfdiv_text" id="state_container_div"><label for="state">Provincia :</label><input id="state" maxlength="150" size="30" class=" validate['required','alpha']" title="" type="text" value="" name="state" />
<div class="clear"></div><div id="error-message-state"></div></div><div class="ccms_form_element cfdiv_text" id="code_container_div"><label for="code">Código Postal :</label><input id="code" maxlength="150" size="30" class="" title="" type="text" value="" name="code" />
<div class="clear"></div><div id="error-message-code"></div></div><div class="ccms_form_element cfdiv_text" id="mobile_container_div"><label for="mobile">Teléfono móvil:</label><input id="mobile" maxlength="150" size="30" class=" validate['phone']" title="" type="text" value="" name="mobile" />
<div class="clear"></div><div id="error-message-mobile"></div></div><div class="ccms_form_element cfdiv_header" id="autoID-5127027407336eef20294ca1efd05ab7_container_div"><hr />
</h1>
<h3 style="margin-left: 30px; text-align: justify;">Por favor, si su consulta la realiza para una empresa rellene el siguiente apartado, de esta forma podremos atendenderle más eficientemente.</h3>
<p>
<hr /><div class="clear"></div></div><div class="ccms_form_element cfdiv_text" id="company_container_div"><label for="company">Empresa :</label><input id="company" maxlength="150" size="30" class="" title="" type="text" value="" name="company" />
<div class="clear"></div><div id="error-message-company"></div></div><div class="ccms_form_element cfdiv_text" id="website_container_div"><label for="website">Sitio web :</label><input id="website" maxlength="150" size="30" class=" validate['url']" title="" type="text" value="" name="website" />
<div class="clear"></div><div id="error-message-website"></div></div><div class="ccms_form_element cfdiv_text" id="lane_container_div"><label for="lane">Dirección :</label><input id="lane" maxlength="150" size="30" class=" validate['alphanum']" title="" type="text" value="" name="lane" />
<div title="Dirección :" rel="Escriba aquí su dirección." class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-lane"></div></div><div class="ccms_form_element cfdiv_text" id="pobox_container_div"><label for="pobox">Apartado de Correos</label><input id="pobox" maxlength="50" size="30" class="" title="" type="text" value="" name="pobox" />
<div title="Apartado de Correos" rel="Escriba aquí su apartado de correos :" class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-pobox"></div></div><div class="ccms_form_element cfdiv_select" id="industry_container_div"><label for="industry">Actividad :</label><select size="" id="industry" class="" title="" name="industry">
<option value="">   ( seleccione )</option>
<option value="Apparel">Ropa/Lencería</option>
<option value="Banking">Banca</option>
<option value="Biotechnology">Biotecnología</option>
<option value="Chemicals">Químicas</option>
<option value="Communications">Comunicaciones</option>
<option value="Construction">Construcción</option>
<option value="Consulting">Consultoría</option>
<option value="Education">Educación</option>
<option value="Electronics">Electrónica</option>
<option value="Energy">Energía</option>
<option value="Engineering">Ingeniería</option>
<option value="Entertainment">Entretenimiento</option>
<option value="Environmental">Medio Ambiente</option>
<option value="Finance">Finanzas</option>
<option value="Food & Beverage">Restauración</option>
<option value="Government">Gobierno</option>
<option value="Healthcare">Salud</option>
<option value="Hospitality">Hospital</option>
<option value="Insurance">Seguros</option>
<option value="Machinery">Maquinaria</option>
<option value="Manufacturing">Fabricación</option>
<option value="Media">Medios</option>
<option value="Not For Profit">ONG</option>
<option value="Recreation">Ocio</option>
<option value="Retail">Venta al por menor</option>
<option value="Shipping">Logística</option>
<option value="Technology">Tecnología</option>
<option value="Telecommunications">Telecomunicaciones</option>
<option value="Transportation">Transportes</option>
<option value="Utilities">Utilidades</option>
<option value="Other">Otros</option>
</select>
<div title="Actividad :" rel="Por favor seleccione una actividad empresarial, si no encuentra su sector seleccione "otros"" class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-industry"></div></div><div class="ccms_form_element cfdiv_text" id="phone_container_div"><label for="phone">Teléfono :</label><input id="phone" maxlength="150" size="30" class=" validate['phone']" title="" type="text" value="" name="phone" />
<div title="Teléfono :" rel="Teléfono de contacto." class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-phone"></div></div><div class="ccms_form_element cfdiv_text" id="fax_container_div"><label for="fax">Numero de Fax :</label><input id="fax" maxlength="150" size="30" class=" validate['phone']" title="" type="text" value="" name="fax" />
<div class="clear"></div><div id="error-message-fax"></div></div><div class="ccms_form_element cfdiv_textarea" id="description_container_div"><label for="description">Escriba aquí su consulta :</label><textarea id="description" cols="45" rows="12" class=" validate['required']" title="" name="description"></textarea>
<div title="Escriba aquí su consulta :" rel="Puede escribir su consulta o duda." class="tooltipimg"><a href="#">?</a></div><div class="clear"></div><div id="error-message-description"></div></div><div class="ccms_form_element cfdiv_text" id="autoID-74b060b5e6ae7c8e66aeb649cbd385ce_container_div"><label>Introduzca el código de verificación :</label><input maxlength="5" size="5" class="chrono_captcha_input validate['required']" title="" type="text" value="" name="chrono_verification" />
{chronocaptcha_img}<div title="Introduzca el código de verificación :" rel="Verificación de seguridad introduzca el código." class="tooltipimg"><a href="#">?</a></div><div class="small-message">Comprobación de que usted no es spam.</div><div class="clear"></div><div id="error-message-chrono_verification"></div></div><div class="ccms_form_element cfdiv_submit" id="autoID-17620c0f75f468591c1dfe4fb08a46d0_container_div"><input name="input_submit_9" class="" value="Enviar formulario" type="submit" />
<div class="clear"></div><div id="error-message-input_submit_9"></div></div><input id="leadsource" type="hidden" value="Web Site" name="leadsource" />

Hi vii6,

Thanks, but not what I was looking for. Please take a Form Backup using the icon in the Forms Manager and post it here (as a zipped file) or PM or email it to mek.

Bob

I make a form with Curl and works!!!! vtiger receibe the form data!!!! all works!!! captcha, email sending... all!!!!

Only change the fields of:

"Submit URL" with the url of vtiger, ej:http://localhost/modules/Webforms/post.php to
In actions mode "on submit" insert curl action and set:

Target URL : http://localhost/modules/Webforms/post.php

Header in response ? : NO

Params/Fields map :
moduleName=moduleName
leadsource=leadsource
firstname=firstname
lastname=lastname
company=company
website=website
phone=phone
fax=fax
mobile=mobile
email=email
country=country
state=state
city=city
code=code
pobox=pobox
lane=lane
industry=industry
description=description

And in the form manager "Form tag attachment" and "submint url" don't set because use Curl action.
And in the form wizard ad one "hiden box" with the value:
Field Name = moduleName
Field Id = moduleName
Field default value = Leads

And work!!! chronoforms v4 form to vtiger 5.2 pre-contacs


:-) I am a machine !!!! Sorry for my english espero que estas lineas puedan ayudar a mas gente que necesita tener un formulario web y que sus datos se añadan a su CRM vtiger.

Un saludo a todo el mundo!

Hello Bob, my problem is solved, thanks for your time and help.

Un saludo!

Resumen en español.

Para hacer un formulario con chronoforms v4 que envie los datos a vtiger se puede hacer con "form Wizard"

Añadimos los campos del formulario, por ejemplo un "textbox" configurado de la siguiente manera:
En la pestaña "General" por ejemplo:

Field Name: firstname
Field ID : firstname

ponemos añadir cualquiera de estas "etiquetas"

leadsource=leadsource
firstname=firstname
lastname=lastname
company=company
website=website
phone=phone
fax=fax
mobile=mobile
email=email
country=country
state=state
city=city
code=code
pobox=pobox
lane=lane
industry=industry
description=description

También es necesario añadir 1 campo oculto "hidden box" con los siguientes valores:

Field Name = moduleName
Field Id = moduleName
Field default value = Leads

Una vez hecho el cuerpo del formulario con los datos que necesitamos para nuestro propósito, le damos a la pestaña "actions" y añadimos en la zona verde "On Submit" la acción Curl de las herramientas "Redirect/remote Submit" y configuramos la acción Curl de la siguiente forma:

Target URL :

http://IPoURL_de_vtiger/modules/Webforms/post.php

Header in response ? : NO

Y en "Params/Fields map" añadimos los campos del wizard de la siguiente manera :

moduleName=moduleName
leadsource=leadsource
firstname=firstname
lastname=lastname
company=company
website=web ... etc todos los campos del wizard

Y por ultimo, para que vtiger acepte los datos modificamos el archivo de vtiger Webforms.config.php
y lo dejamos así:

<?php
/*+**********************************************************************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance with the License
 * The Original Code is:  vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 ************************************************************************************/

$enableAppKeyValidation = '';        <--- importante ni "true" ni "false" dejarlo así ""
$defaultUserName = 'vipuser';
$defaultUserAccessKey = 'f5Ykfbz..........';

$defaultOwner = 'standarduser';
$successURL = 'http://IP/solicitud-de-informacion-enviada.html';
$failureURL = '';

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

$defaultSuccessMessage = 'LBL_SUCCESS';

?>

Y funciona, no se si será muy seguro o no, por que no se especifica el appKey, pero ir va.

Un saludo a todos.

And in Google translated English for other readers:

To make a form with ChronoForms v4 to send data to vtiger can be done with "form Wizard"

We add the form fields, such as a "textbox" configured as follows:
On the "General" for example:

Field Name: firstname
Field ID: firstname

we add any of these "tags"

leadsource = leadsource
firstname = firstname
lastname = lastname
company = company
website = website
phone = phone
fax = fax
mobile = mobile
email = email
country = country
state = state
city ​​= city
code = code
pobox pobox =
lane = lane
industry = industry
description = description 

It is also necessary to add a hidden field "hidden box" with the following values:

Field Name = moduleName
Field Id = moduleName
Leads Field default value = 

Once the body of the form with the data we need for our purpose, we give the tab "actions" and add in the green "On Submit" Curl action tools "Redirect / remote Submit" and configure the action Curl as follows:

Target URL:

http://IPoURL_de_vtiger/modules/Webforms/post.php

Header in response? : NO

And in "Params / Fields map" wizard add the fields as follows:

moduleName = moduleName
leadsource = leadsource
firstname = firstname
lastname = lastname
company = company
= web site ... etc all fields of the wizard 

And finally, to accept the data vtiger modify the file vtiger Webforms.config.php
and leave it like this:

<?php
/* + *********************************************** ***********************************
 * The contents of this file are subject to the vtiger CRM Public License Version 1.0
 * ("License"); You may not use this file except in compliance With The License
 * The Original Code is: vtiger CRM Open Source
 * The Initial Developer of the Original Code is vtiger.
 * Portions created by vtiger are Copyright (C) vtiger.
 * All Rights Reserved.
 ************************************************** **********************************/

$ EnableAppKeyValidation =''; <--- important or "true" or "false" leave it ""
$ DefaultUserName = 'vipuser';
$ DefaultUserAccessKey = 'f5Ykfbz ..........';

$ DefaultOwner = 'standarduser';
$ SuccessURL = 'http://IP/solicitud-de-informacion-enviada.html';
$ FailureURL ='';

/**
 * JSON or HTML. success and failure incase if URL is NOT specified.
 */
$ DefaultSuccessAction = 'HTML';
$ DefaultSuccessMessage = 'LBL_SUCCESS';
?>

And it works, not quite sure whether it will or not, that is not specified appKey but will go.

Greetings to all.