vicidial help needed
Posted: Sat Jan 12, 2008 2:19 am
i am having a big problem i am confuse i really dont know what the next step to use i am stuck at
import leads in the basic text pipe-delimited or tab-delimited format, a CSV file or a simple Excel
spreadsheet. For this tutorial we will use the default tab-delimited text file.
NOTE: For the web-based lead loader, a tab-delimited or pipe delimited text file must end with “.txt”, a
CSV(Comma Separated Values) file must end with “.csv” and an Excel file must end with “.xls”.
9. The format of this lead file is:
1. Vendor Lead Code - shows up in the Vendor ID field of the GUI
2. Source Code - internal use only for system and database administrators
3. List ID - the list number that these leads will show up under
4. Phone Code - the country code prefix - 1 for US, 44 for UK, 61 for AUS,etc
5. Phone Number - at least 8 digits long and no more than 11 digits long.
6. Title - title of the customer - Mr. Ms. Mrs, etc...
7. First Name
8. Middle Initial
9. Last Name
10. Address Line 1
11. Address Line 2
12. Address Line 3
13. City
14. State - limited to 2 characters
15. Province
16. Postal Code
17. Country
18. Gender
19. Date of Birth
20. Alternate Phone Number
21. Email Address
22. Security Phrase
23. Comments
can you help please
import leads in the basic text pipe-delimited or tab-delimited format, a CSV file or a simple Excel
spreadsheet. For this tutorial we will use the default tab-delimited text file.
NOTE: For the web-based lead loader, a tab-delimited or pipe delimited text file must end with “.txt”, a
CSV(Comma Separated Values) file must end with “.csv” and an Excel file must end with “.xls”.
9. The format of this lead file is:
1. Vendor Lead Code - shows up in the Vendor ID field of the GUI
2. Source Code - internal use only for system and database administrators
3. List ID - the list number that these leads will show up under
4. Phone Code - the country code prefix - 1 for US, 44 for UK, 61 for AUS,etc
5. Phone Number - at least 8 digits long and no more than 11 digits long.
6. Title - title of the customer - Mr. Ms. Mrs, etc...
7. First Name
8. Middle Initial
9. Last Name
10. Address Line 1
11. Address Line 2
12. Address Line 3
13. City
14. State - limited to 2 characters
15. Province
16. Postal Code
17. Country
18. Gender
19. Date of Birth
20. Alternate Phone Number
21. Email Address
22. Security Phrase
23. Comments
can you help please