Error importing leads from csv...

[paok1926]

hello all,

my .csv file is like this..

Code: Select all

"phone_number"   "first_name"   "last_name"
6944420303   "George"   "Michalopoulos-1"
6932420303   "George"   "Michalopoulos-2"
2311114800   "George"   "Michalopoulos-3"
2311110181   "George"   "Michalopoulos-4"
2310920499   "Dinos"   "Itskos"
2310242429   "Figura"   "Body"
2310277737   "Figura"   "Soul"


i created a template, where i assign first name, last name and numbers to the appropriate fields,
but when i try to import leads i get this message:

Code: Select all

Processing CSV: Comma Separated Values file using template 1001... (2|0)
LIST ID OVERRIDE FOR THIS FILE: 5000

PHONE CODE OVERRIDE FOR THIS FILE: 30

record 0 BAD- PHONE: ROW:|phone_number| INV:
record 1 BAD- PHONE: ROW:|6944420303| INV:
record 2 BAD- PHONE: ROW:|6932420303| INV:
record 3 BAD- PHONE: ROW:|2311114800| INV:
record 4 BAD- PHONE: ROW:|2311110181| INV:
record 5 BAD- PHONE: ROW:|2310920499| INV:
record 6 BAD- PHONE: ROW:|2310242429| INV:
record 7 BAD- PHONE: ROW:|2310277737| INV:

Done GOOD: 0       BAD: 8       TOTAL: 8


any suggestions ?

[paok1926]

my import settings are like this...

[paok1926]

if you are a newbie like me, this is the answer..

add a lead to one list.
export this list to your computer.
open it with excel, libre office, whatever..
under the phone number, add your leads.. (supposedly its a cold list, without names).
export as .csv, TAB DELIMITED...
import to vicidial, select custom layout.. it will ask you to assign field names..
you are ok

[geek_kaushal]

my import settings are like this...

You can have any layout in csv or xls. When you are on ad leads page, selected custom layout.

It will give you the options to map the vicidial fields with the columns in your file. Easy way to go..