vtiger lead file?

[Op3r]

Im reading up on vtiger as we have a requirement for this.

I saw this one.

(the vicidial_list.vendor_lead_code field[=vtiger_accounts.accountid] is used as a key between systems)
- put properly formatted CSV file into /usr/share/astguiclient/VTIGER_IN/


does anyone have a properly formatted lead file than can show me?

Thanks

[mflorell]

Not sure I ever made a sample for that one, have you looked at the code to see what it accepts?

[Op3r]

Yep, found it.

Here's the output.

[root@vici astguiclient]# ./Vtiger_IN_new_accounts_file.pl --help
allowed run time options:
[-q] = quiet
[-t] = test
[--debug] = debug output
[--format=standard] = ability to define a format, standard is default, formats allowed shown in examples
[--duplicate-system-check] = checks for the same phone number in the entire system before inserting lead
[--duplicate-system-siccode] = checks for the same SIC code in the entire system before inserting lead
[--duplicate-system-website] = checks for the same website in the entire system before inserting lead
[--ftp-pull] = grabs lead files from a remote FTP server, uses REPORTS FTP login information
[--ftp-dir=leads_in] = remote FTP server directory to grab files from, should have a DONE sub-directory
[--email-list=test.com:test2.com] = send email results for each file to these addresses
[--email-sender=vicidial] = sender for the email results
[-h] = this help screen


This script takes in account CSV files in the following order when they are placed in the /usr/share/astguiclient/VTIGER_IN directory to be imported into the vtiger system (examples):

standard:
employees,ticker_symbol,sic_code,revenue,account_name,address,po_box,city,state,post_code,phone_number,ownership,fax,email,other_phone,other_email,website
4,C03IMM001,39207955,2,ST MARK CHURCH,1710 W COLLEGE AVE,,CHICAGO,IL,61555,3095551111,PAUL SMITH,3095551212,TEST.NET,7775553333,test.com,bigsite.com

minicsv:
business,contact,phone_number,address1,city,state,postal_code
"CHURCH","Bob Smith","3525556601","105 Fifth St","Steinhatchee","FL","32359"

[mflorell]

Wow, that's not bad

I don't remember doing all of that, but it was 9 months ago.