Uploading leads via CSV format results in ERROR message -New

General and Support topics relating to ViciDialNow and GoAutoDial ISO installers

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

Uploading leads via CSV format results in ERROR message -New

Postby vccsdotca » Thu Jan 15, 2009 1:15 pm

I have searched all related posts in the forum already, no real solution was found yet.
When uploading in CSV I get

"ERROR: The file does not have the required number of fields to process it."

I have checked formatting continuously, using both the included templates and custom made via the instructions from the help link. All fields are there. The only way I am able to import is with a Tab or Pipe delimitted format, however, this is not convenient for end users.
Would really appreciate some help on this, thank you in advance.

vicidialNOW1.1
LIST LOADER- VERSION: 2.0.4-25 BUILD: 80514-1030
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby mflorell » Thu Jan 15, 2009 1:43 pm

Please post one record from your file.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby vccsdotca » Thu Jan 15, 2009 1:46 pm

this is direct from csv. I renamed the file to txt to pull data.

100001,10001,100,1,xxxxxxxxxx,MR,I,P,FREELY01,249 MUNDON ROAD,,na,na,MALDON,FL,none,33709,USA,M,01/01/1970,7275551212,test@test.com,nothing,COMMENTS

I have noticed a double comma after address1 but this has persisted throughout.

Thanks Matt
Last edited by vccsdotca on Thu Jan 15, 2009 6:08 pm, edited 1 time in total.
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby mflorell » Thu Jan 15, 2009 1:56 pm

Have you tried the XLS file format to import?

Do you have all of the Perl modules loaded as per SCRATCH_INSTALL doc?
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby vccsdotca » Thu Jan 15, 2009 3:13 pm

I used vicidialNOW but I referred back to the scratch and went through the Perl installs again from start, made sure super list loader needed's were there too. XLS format results in same error message.
php.ini is also allowing uploads with acceptable sizes.

thx
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby mflorell » Thu Jan 15, 2009 5:14 pm

Please check the file permissions of the vicidial web directory to ensure that it allows writing. You could also try changing the system setting to not allow writable web directory.
mflorell
Site Admin
 
Posts: 18384
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby vccsdotca » Thu Jan 15, 2009 6:07 pm

Thanks for trying to help Matt.

/var/www/html = drwxr-xr-x
/var/www/html/vicidial = 777

I tried also with web writeable=no

Some further testing, hitting the Submit button without loading a local file results in the same ERROR message. So I loaded a csv and then an xls and to verify I looked in the vicidial folder and we do get a "vicidial_temp_file.txt" (-rw-r--r--) with data inside. Here is the output of the temp after csv upload. (2 records)

100001,10001,100,1,xxxxxxxxxx,MR,I,P,FREELY01,249 MUNDON ROAD,,na,na,MALDON,FL,none,33709,USA,M,01/01/1970,7275551212,test@test.com,nothing,COMMENTS
100002,10002,100,1,xxxxxxxxxx,MR,I,P,FREELY02,249 MUNDON ROAD,,na,na,MALDON,FL,none,33709,USA,M,01/01/1970,3125551212,test@test.com,nothing,COMMENTS
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby williamconley » Thu Jan 15, 2009 7:24 pm

have you considered a tab-delimited file to see if that will work (i never actually use anything but tab-delimited). at least as a troubleshooter. and then try it again with one more and one less field just to see if there's a simple glitch in the number of fields you or it are expecting somewhere?
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby vccsdotca » Fri Jan 16, 2009 6:10 am

Thanks for the suggestion. Actually I have made a tab file directly from the csv and it imports without any problems.

thx
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby vccsdotca » Thu Jan 22, 2009 6:27 am

Just to update. Although vicidialnow should have all packages installed, I tried re-installing perl modules from CPAN. I used the alternative switch to "make" as I was always getting "make: *** No rule to make target `Y'. Stop". If you are re-installing packages be sure to use "-force install 'module' " to bypass the already installed message.
Results;

This fixed the CSV view of agent reports (no data diplayed before) how ever, I am still unable to upload leads in CSV or XLS format. Only Tab versions are working.

Will update any progress but I'm no coder so hold your breath...

Matthew Martin
"Voipo Experto"
www.vccs.ca
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby vccsdotca » Thu Jan 22, 2009 10:16 pm

Allright well needless to say I am very ****ed off because after digging & digging I ran into a post http://eflo.net/VICIDIALforum/viewtopic.php?t=6969 and another about Firefox 3 from 2007..anyway , it is a Firefox issue and it works no problems with IE6, IE7.

Hope this helps someone as a first place to test uploading leads.

Matt Martin
VCCS.ca
vccsdotca
 
Posts: 116
Joined: Mon Sep 15, 2008 5:42 pm
Location: Montreal, QC Canada

Postby dspaan » Tue Dec 21, 2010 2:40 pm

I have this exact same problem. I tried with Firefox 3.6, IE8 and Chrome.

I can only import leads Standard format automatic mode when the list is in tab delimited format.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Postby williamconley » Tue Dec 21, 2010 3:08 pm

you'll need to specify the "exact" problem. what error do you receive on what page? what symptoms do you have? (obviously you don't have the exact problem, as that one was resolved by using ie, and you have used ie and it didn't work ...)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: Uploading leads via CSV format results in ERROR message

Postby dspaan » Tue Dec 21, 2010 3:19 pm

vccsdotca wrote:
"ERROR: The file does not have the required number of fields to process it."

I have checked formatting continuously, using both the included templates and custom made via the instructions from the help link. All fields are there. The only way I am able to import is with a Tab or Pipe delimitted format, however, this is not convenient for end users.


There must be a difference but i have this same error message. I also tried with different field names.

When importing leads the custom way with old lead loader I see some fields are different from the manual:

(old – new)
Source Code – Source ID
Address Line 1, 2, 3 – Address1, Address2, Address3
Country code – Country
Alternate Phone Number – Alt Phone
Email Address - Email

But i noticed it doesn't matter if they have the old name or the new name because when i used tab delimited they both imported fine.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Postby williamconley » Tue Dec 21, 2010 6:18 pm

Are you continually trying this with the same non-working data, or have you set up a "test import" with things like single word headers, no blank headers, perhaps an older format of xl ... etc
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Postby dspaan » Tue Dec 21, 2010 7:57 pm

There were some blank columns in my testdata. I just filled every line with testdata and made single word headers. I tried both xls and xlsx.

Like i said i can import tab delimited fine. Only difference i can think of is that the other person in this thread might have used an older version of IE.

This is not a major issue since tab delimited works, but would be nice if xls would work.
Regards, Dennis

Vicibox 9.0.1
Version: 2.14b0.5
SVN Version: 3199
DB Schema Version: 1588
Build: 200310-1801
dspaan
 
Posts: 1377
Joined: Fri Aug 21, 2009 1:40 pm
Location: The Netherlands

Postby williamconley » Tue Dec 21, 2010 8:40 pm

and possibly an older version of excel as well. have you tried saving in previous versions
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20256
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)


Return to ViciDialNow - GoAutoDial

Who is online

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