Very strange issue when loading leads

[tybrenis]

Hi,

I recently installed GoAutoDial and seem to have it working fine with test calls. However, when I go to upload actual leads, it ONLY uploads my existing 5 test leads! For example, if I upload a list of 10,000 numbers, it says success, then asks me to map the 5 fields that are present in the basic test list - phone number, first name, last name, address 1, etc.

I have the leads all ready formatted standard for vicidial, and they work fine on a regular vicibox. They have the full 23 fields - vendor id, etc., but none of these fields are available when I upload them to be mapped!

When I map the 5 fields and press submit, it re-uploads my 5 test numbers and adds them to the list, even though the list being uploaded is NOT a test list and contains over 10k!

This is very frustrating, of course. I have tried in CSV, tab delimitted, comma delimited, txt files, everything.

Any ideas?

Thanks!!

[viciflash]

i ran into this as well, 15k leads didnt go thru. here are the things i did per column. again, per column. i use excel on this one and save it as csv.

1. remove double quote - replace it with ** (double asterisk)
2. remove single quote - replace it with * or ^ (single asterisk or caret)
3. remove comma - replace it with - (dash/hyphen)

hope this helps.

[tybrenis]

I gave that I shot, not positive I did it the right way, but it still uploaded the original 5 leads. I have the option to export in a number of formats - csv, tab, etc. Is there a proper way to export the leads?

[williamconley]

from my experience two possibilities: (in no particular order of likelihood!)

1) permission issue for the generated sql file. (ie: the system may no longer be able to modify the file that was already written to disk, change its permission to 777 to allow full access)

2) change to tab delimited, press the ? button and get the 23 fields and load your leads into these 23 fields before saving them as tab delimited. then do NO use the "custom" lead loader, use "standard" (as these files are now pre-mapped, the map routine will not run, it will merely begin uploading when you press submit)

[tybrenis]

Thanks, that sounds like great advice. How do I change the mySQL permissions via a shell?

Thanks for the help!

[williamconley]

NOT a mysql permissions issue. this is all happening in a script prior to executing the mysql import function. (the lead loader script!)

It has to copy the file to a local drive, then parse the file (looking for field to map), then show the fields to you and await your input. If during this process it cannot write the file ... crash and burn.

It may be possible to use the "standard" instead of the "custom" and thus use a different part of the script to bypass theproblem. It may also be possible to change the permission of the .txt file it writes to allow read/write access to ALL (temporarily, as a test) and perhaps get the job done.

[tybrenis]

Thanks for the continued help! I tried loading them using the standard function and received the same error. If I want to change the permissions, how will I go about doing that? I am an absolutely newbie to this. Thanks so much!

Tyler

[williamconley]

in the vicidial web root:

Code: Select all

chmod 777 listloader_stmts.txt

remember, though, that if this works ... your install has a flaw. what other flaws are there? how did this happen?

a reinstall now may save you a lot of issues.

and if it happens the same way, consider vicibox redux (you'll lose the pretty agent screen but you'll gain the ability to use the latest SVN release of Vicidial and you'll be on a platform supported by The Vicidial Group, the owners of this software and this site). Vicibox.com

[tybrenis]

Hi,

Sorry to drag a thread up from the graveyard, but I have a new install of GoAutoDial and I am having this problem again! Last time it was finally fixed by a master vicidial IT guy that I used to have to work for us. Unfortunately, I can't get a hold of him.

Last time, he went in and fixed this within ten minutes, saying it was a "permissions issue". What could it be, and how can I fix it? It sounds like you were saying something along those lines before, William, and it might be the same thing again. In very basic language, assuming I know very little about this, how can I fix the problem? I checked to make sure all the perl modules were installed and up to date.

Thank you so much for your help! Our business is now down and relying on this being fixed.

[williamconley]

in the vicidial web root:

Code: Select all

chmod 777 listloader_stmts.txt

remember, though, that if this works ... your install has a flaw. what other flaws are there? how did this happen?

[tybrenis]

Thanks,

I tried that but still having the issue. Thanks William and Striker.

I did:

cd /var/www/html/vicidial
chmod 777 listloader_stmts.txt

Still having the issue. We are going crazy over here!

[tybrenis]

I'm getting:

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

[williamconley]

of course, since i don't have the statement that caused the error, hard to guess.

[tybrenis]

of course, since i don't have the statement that caused the error, hard to guess.

How can I get this for you?

[williamconley]

I'm getting:

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

"getting"? when? where? what was the URL? Custom lead loader? standard? custom fields? format of file uploaded?

press the (?) next to the "browse" command when uploading leads. in there you will find a list of 23 fields. create a tab delimited text file (ends in ".txt" when properly exported from excel) with those 23 fields in that exact order.

[gardo]

Are you using GoAutoDial CE 2.1? If not I'd recommend an upgrade or a clean reinstall.

[tybrenis]

Are you using GoAutoDial CE 2.1? If not I'd recommend an upgrade or a clean reinstall.

YES I am on 2.0. How can I upgrade?

[gardo]

You can check here:

http://goautodial.org/projects/goautodialce/wiki/HowTos