leads uploading problem...

All installation and configuration problems and questions

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

leads uploading problem...

Postby paladugu_sujith » Wed Apr 23, 2008 10:38 am

i am trying to upload the leads in csv format..
there are 10,000 leads with a file size of 666kb.

when i upload it says tht all leads r uploaded

GOOD:10000 BAD:0

but only 600 of them are getting uploaded...

i tried to make my web directory writable.. by chmod 777 /var/www/html/vicidial/ but of no use..

my php.conf says


file upload=on
upload_max_filesize=10M

i am using astguiclient version 2.03 with asterisk 1.2.24
mysql 4.1.11
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby mflorell » Wed Apr 23, 2008 11:27 am

try upgrading to 2.0.4, there were a couple fixes for lead importing in there from the previous version.
mflorell
Site Admin
 
Posts: 18342
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby paladugu_sujith » Wed Apr 23, 2008 11:40 am

thnx for the reply mr florell..

can i have any other alternative other than upgradiing it to 2.04?
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby mflorell » Wed Apr 23, 2008 12:26 pm

Try reformatting your leads to the native VICIDIAL format and try the web form again. If you still have problems, then try using the command-line lead importer.
mflorell
Site Admin
 
Posts: 18342
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby paladugu_sujith » Fri Apr 25, 2008 10:37 am

where can i find the command line lead importer?

thnx
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby ramindia » Fri Apr 25, 2008 12:16 pm

the tools are located in the source of Vicidial

ram
Kindly post your feedback, if this solution works.
so its very usefull for others who join later as a NEWBIE.
ramindia
 
Posts: 688
Joined: Wed Oct 11, 2006 4:06 am
Location: India

Postby pylinuxian » Fri Apr 25, 2008 1:59 pm

/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl
pylinuxian
 
Posts: 147
Joined: Tue Feb 26, 2008 2:21 pm

Postby paladugu_sujith » Sat Apr 26, 2008 6:59 pm

thnx a lot...i will try resolving the problem...

is it not possible tht i will be able to upload the leads using super list loader...

wht can be the problem tht i am facing??

SUJITH
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby pylinuxian » Sat Apr 26, 2008 7:07 pm

my friend you need to read the manual or the scratch install ... then prepare a list of numbers ... put it in /usr/share/astguiclient/INLEADS i guess then use the script
/usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl name_of_file
& it should load the list to the database ... if you can't follow these simple instructions then you need to hire someone to it for you.
pylinuxian
 
Posts: 147
Joined: Tue Feb 26, 2008 2:21 pm

Postby paladugu_sujith » Mon May 05, 2008 9:34 am

hello

i am sorry ...bt still i am not able to upload the leads...

even from the command line lead uploader..

i chkd with all the cpan modules ..they r perfectly installed... and i made my web directory writable as chmod 777 /var/www/html/vicidial/

hindly sort it out....

thnx
SUJITH
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby gardo » Mon May 05, 2008 10:23 am

Instead of using coma (,) as field delimiter, try using pipe (|) and save the file as csv. Better yet, do it with Openoffice using a linux workstation.
http://goautodial.com
Empowering the next generation contact centers
gardo
 
Posts: 1926
Joined: Fri Sep 15, 2006 10:24 am
Location: Manila, 1004

Postby paladugu_sujith » Mon May 05, 2008 1:56 pm

sorry...still the same problem...only some of the leads r getting uploaded..not all of them
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Postby Op3r » Mon May 05, 2008 10:20 pm

Then you need to remove the special characters like ( ) -

and please read the Manager's Manual.
Get paid for US outbound Toll Free calls. PM me.
Op3r
 
Posts: 1424
Joined: Wed Jun 07, 2006 7:53 pm
Location: Manila

Postby pylinuxian » Tue May 06, 2008 8:31 am

i personaly never seen a correct file half uploaded.
so you hast have an error in your file.
look at the last number uploaded, search in the file for that line & see whats in the next line (you will find an error)
hint : some names come with ` or ' characters in them.
also you can try converting the file using iconv, example :
iconv -f utf-8 -t latin1 file.txt
then retry upload.
pylinuxian
 
Posts: 147
Joined: Tue Feb 26, 2008 2:21 pm

Postby paladugu_sujith » Tue May 06, 2008 8:56 am

hurray...

the post worked... i am able to upload leads...

thnx a lot....


CHEERS

SUJITH
paladugu_sujith
 
Posts: 62
Joined: Wed Jan 02, 2008 1:42 pm

Also not able to load the leads

Postby teto114 » Tue Jun 03, 2008 6:45 pm

I'm using 2.0.4 version, also having trouble loading lists,

this is part of the leads not loading:
Source,Code,List,CONTACT_NAME,COMPANY_NAME,PRIMARY_ADDRESS,PRIMARY_CITY,PRIMARY_STATE,PRIMARY_ZIP_CODE,PHONE
Verizon,Alex,105,,Xerox Fairfield Cty Ofce,555 White Plains Rd,Tarrytown,NY,10591,2039781863
Verizon,Alex,105,Sharon Filler,Metro A/C,4 E 28th St,New York,NY,10016,2122023257
Verizon,Alex,105,Stuart Sokloff PE,Cts Group,1140 Franklin Ave,Garden City,NY,11530,2122060304
Verizon,Alex,105,John Alters,What's the Score Johnny,8 Little West 12th St,New York,NY,10014,2122061234

Do you guys see anything weird there?

Thanks a lot
teto114
 
Posts: 15
Joined: Tue Jun 03, 2008 6:28 pm

hello

Postby eliasferreyra » Wed Jun 04, 2008 8:43 pm

try using that one

file_uploads = On
upload_tmp_dir = "/tmp"
upload_max_filesize = 100M
post_max_size = 16M
memory_limit = 128M
max_input_time = 180
max_execution_time = 300
eliasferreyra
 
Posts: 367
Joined: Wed Jul 18, 2007 3:27 pm


Return to Support

Who is online

Users browsing this forum: No registered users and 131 guests