Error importing leads from csv...

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Error importing leads from csv...

Postby paok1926 » Mon Jan 21, 2019 8:13 am

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 ?
Vicibox from ViciBox_v8_1.x86_64-8.1.2.iso | Asterisk 11.25.3-vici
VERSION: 2.14-695a - BUILD: 181116-1133
No Extra Software and Hardware | VM with 8 cores & 16Gb Ram
~8000-9000 calls per day
paok1926
 
Posts: 40
Joined: Mon Jan 07, 2019 6:45 pm

Re: Error importing leads from csv...

Postby paok1926 » Mon Jan 21, 2019 8:20 am

my import settings are like this...

Image
Vicibox from ViciBox_v8_1.x86_64-8.1.2.iso | Asterisk 11.25.3-vici
VERSION: 2.14-695a - BUILD: 181116-1133
No Extra Software and Hardware | VM with 8 cores & 16Gb Ram
~8000-9000 calls per day
paok1926
 
Posts: 40
Joined: Mon Jan 07, 2019 6:45 pm

Re: Error importing leads from csv...

Postby paok1926 » Mon Jan 21, 2019 1:21 pm

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 :)
Vicibox from ViciBox_v8_1.x86_64-8.1.2.iso | Asterisk 11.25.3-vici
VERSION: 2.14-695a - BUILD: 181116-1133
No Extra Software and Hardware | VM with 8 cores & 16Gb Ram
~8000-9000 calls per day
paok1926
 
Posts: 40
Joined: Mon Jan 07, 2019 6:45 pm

Re: Error importing leads from csv...

Postby geek_kaushal » Mon Jan 21, 2019 5:49 pm

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..
geek_kaushal
 
Posts: 3
Joined: Mon May 01, 2017 12:44 pm


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 77 guests