Page 1 of 1

Error importing leads from csv...

PostPosted: Mon Jan 21, 2019 8:13 am
by 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 ?

Re: Error importing leads from csv...

PostPosted: Mon Jan 21, 2019 8:20 am
by paok1926
my import settings are like this...

Image

Re: Error importing leads from csv...

PostPosted: Mon Jan 21, 2019 1:21 pm
by 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 :)

Re: Error importing leads from csv...

PostPosted: Mon Jan 21, 2019 5:49 pm
by geek_kaushal
paok1926 wrote:my import settings are like this...

Image


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..