VTiger form for lead generation

S27TOVA4U578

Today I had the problem of having to create a form for leads for my website. Using the native functions of VTiger the form was saved correctly, but the fields were not present. I have installed the version 6.4
Searching the net I found the solution to this link:

In practice operate in this way:

1.

CREATE TABLE `vtiger_webforms_field` ( `id` int(19) NOT NULL AUTO_INCREMENT, `webformid` int(19) NOT NULL, `fieldname` varchar(50) NOT NULL, `neutralizedfield` varchar(50) NOT NULL, `defaultvalue` varchar(200) DEFAULT NULL, `required` int(10) NOT NULL DEFAULT ‘0’, `captcha` int(1) NOT NULL DEFAULT ‘0’, `roundrobin` int(1) NOT NULL DEFAULT ‘0’, `roundrobin_userid` varchar(256) DEFAULT NULL, `roundrobin_logic` int(11) NOT NULL DEFAULT ‘0’, PRIMARY KEY (`id`), KEY `webforms_webforms_field_idx` (`id`), KEY `fk_1_vtiger_webforms_field` (`webformid`), KEY `fk_2_vtiger_webforms_field` (`fieldname`), CONSTRAINT `fk_1_vtiger_webforms_field` FOREIGN KEY (`webformid`) REFERENCES `vtiger_webforms` (`id`) ON DELETE CASCADE, CONSTRAINT `fk_3_vtiger_webforms_field` FOREIGN KEY (`fieldname`) REFERENCES `vtiger_field` (`fieldname`) ON DELETE CASCADE )

2.

ALTER TABLE `vtiger_webforms_field` ADD `sequence` INT NULL DEFAULT NULL AFTER `required` , ADD `hidden` INT NULL DEFAULT NULL AFTER `sequence`

CAUTION:
to me it worked but before I made a backup of the database

This information DATES ARE WITHOUT ANY WARRANTY OF SAFETY AND IF THEY WORK ON OTHER VERSIONS VTiger

Posted in Uncategorized | Leave a comment

Vtiger Customer Portal

S27TOVA4U578 Today I had to set up the Customer Portal module of VTiger on my website, in the part related to crm, but did not know where to begin.

Searching the net I found this interesting link which explains how to set the Customer Portal and services associated with it step by step:

https://www.vtexperts.com/how-to-install-setup-and-configure-vtiger-customer-portal-module-2/

I hope to help other people with my same problem.

Posted in Uncategorized | Leave a comment

Show query result in more rows

mysql Every time we execute a mysql query in a table with mor fields or a query with few join, we have the problem to show the result because it appears in one single line and it is difficult to read the data quickly.

Searching in google I have found the solution to show the query result as each field per row. The syntax is very simple, you must add \G at the end of the query like this:

select * from students where country=’Italy’\G;

and the result will be something like to:

*************************** 1. row ***************************
id: 1
name: giak
surname: camp
city: Ancona
state: AN
country: Italy
modifiedtime: 2015-19-11 11:52:32
modifiedby: 1
*************************** 2. row ***************************
id: 2
name: micky
surname: mouse
city: Pesaro
state: PU
country: Italy
modifiedtime: 2015-12-11 08:11:45
modifiedby: 1
*************************** 3. row ***************************
…..

 

 

Posted in Uncategorized | Leave a comment

Include js file into another js file

In the last days I had a big problem: how I can include a javascript file into another javascript file without use the tag script?
Searching on Google I have found the answer to my problem with this simple javascript function:

function addJavascript(jsname,pos) {
     var th = document.getElementsByTagName(pos)[0];
     var s = document.createElement(‘script’);
     s.setAttribute(‘type’,’text/javascript’);
     s.setAttribute(‘src’,jsname);
     th.appendChild(s);
}

the variable jsname is the name of the javascript file
the variable pos is the tag where you want to add the file

An example of usage:
addJavascript(‘newExternal.js’,’body’);
addJavascript(‘newExternal2.js’,’head’);

It works for me, I hope for you too!

[ the original news ]

Posted in javascript | Leave a comment

Php tools

imagesLast days I searched on the web a place where I find simple help to common problems with php tools. The search game me this site: apptools.com.

Here you can find more information and example about php and Apache. It was very useful for me.

 

Posted in Php | Tagged , , , , , , | Leave a comment

Enable usb devices on VirtualBox

linux_poweredLast days I had  big problem: active the usb on VirtulBox un Ubuntu 10.04. The first idea was to recompile the kernel, but my friend ( a very strong linux system administrator, here his linkedin profile) suggest me to use this command before start VirtualBox:

mount –bind /dev/bus /proc/bus

I tried the command on latest version of VirtualBox: 4.2.6

Posted in linux | Tagged , , , , , | 1 Comment

Align list item to the left in unordered list

cssDuring last days I need to find a solution to align the unsorted list <ul> to align to left. In all browsers the problem is you see space in the left side of the list, so I need a solution for this problem for a jQuery accordion menu.

My solution is to add this property padding-left: 0pt to the ul block.

You must use the rule in this way:

ul {

float: left;

width: 215px;

margin: 15px 0;

padding: 0pt;

background: #ececec;

}

This property is supported by all browsers. I hope this tip could help other developers.

Posted in css | Tagged , , , , , , , , | 1 Comment