Fields for Leads/Lists

[konextu]

Ok so I've been told by the floor manager that some of our data can have up to 10 numbers for a single account. Any idea how to combat that? If an account with 10 numbers ends up in the campaign it will have to dial through all 10 accounts before we can tell the client we successfully attempted contact. Unless of course we get a solid hit/call before the 10th number.

Any ideas? I've flipped through the managers manual (which might i add was an excellent buy, great job matt!) and have not seen anything to that. I do remember seeing somewhere (lord if i remember) that VICIDIAL can handle up to 10 numbers per lead?

Thanks guys.

KG

[mflorell]

The SVN trunk version of VICIDIAL can actually handle 65,000 phone numbers per lead. You have to load them through either the NON-AGENT API or using the Command-line lead loader though.

One you do that you can use the Auto-Alt-Dial feature to go though all numbers until you get a connect.

If you haven't guessed, we built that for a collections client of ours.

[konextu]

Matt, that is awesome, as you know we do collections . Thanks brother.

[konextu]

matt one more question on this, will it dial the auto-alt numbers in sync? Like if it dials the main number for account TEST and its no good will it move right on to the auto number or will the dialer move on to another account and come back to it?

Thanks again

[konextu]

Any documentation on the command line loader?

[mflorell]

Yes it will dial the numbers in order. For more information read the ALTERNATE_NUMBER_DIALING.txt document in the docs directory in the SVN trunk codebase.

And as always, for documentation on the command line lead loader just run it with the "--help" flag:

root@VICIDIAL:~# /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --help
allowed run time options:
[-q] = quiet
[-t] = test
[--forcegmt] = forces gmt value of column after comments column
[--debug] = debug output
[--format=standard] = ability to define a format, standard is default, formats allowed shown in examples
[--forcelistid=1234] = overrides the listID given in the file with the 1234
[--forcephonecode=44] = overrides the phone_code given in the lead with the 44
[--duplicate-check] = checks for the same phone number in the same list id before inserting lead
[--duplicate-campaign-check] = checks for the same phone number in the same campaign before inserting lead
[--duplicate-system-check] = checks for the same phone number in the entire system before inserting lead
[--postal-code-gmt] = checks for the time zone based on the postal code given where available
[--ftp-pull] = grabs lead files from a remote FTP server, uses REPORTS FTP login information
[--ftp-dir=leads_in] = remote FTP server directory to grab files from, should have a DONE sub-directory
[--email-list=test.com:test2.com] = send email results for each file to these addresses
[--email-sender=vicidial] = sender for the email results
[-h] = this help screen


This script takes in lead files in the following order when they are placed in the /usr/share/astguiclient/LEADS_IN directory to be imported into the vicidial_list table (examples):

standard:
vendor_lead_code|source_code|list_id|phone_code|phone_number|title|first_name|middle|last_name|address1|address2|address3|city|state|province|postal_code|country|gender|date_of_birth|alt_phone|email|security_phrase|COMMENTS|called_count|status|entry_date|multi-alt-entries
3857822|31022|105|01144|1625551212|MRS|B||BURTON|249 MUNDON ROAD|MALDON|ESSEX||||CM9 6PW|UK||||||COMMENTS|2|B|2007-08-09 00:00:00|7275551212_1_work!7275551213_61_sister house!7275551214_44_neighbor

minicsv:
address1,city,name,phone_number,state,postal_code
"105 Fifth St","Steinhatchee","Frank Smith","3525556601","FL","32359"

[konextu]

Matt, many thanks my friend. In the end i'm going to have to create some kind of program that exchanges data between what are system's are capable of outputting and formatting it and running it through the API or this. I'll keep everyone posted.

As always thanks!

KG

[konextu]

Someone let me know if i'm even thinking in the right direction, could i build a small app that would import leads directly into the DB for these large entries?

[mflorell]

Yes you could, and we have several clients that have. You just need to make sure that you are putting the information into the system cleanly(like no non-digit characters in the phone_number field), also the current lead loaders will time zone code the leads as they go in which is something you should account for. While that can be done in-batch by the adjust GMT script, you would not want to be running in production and load leads then because you may call some areas outside of their time zone.

[konextu]

That sounds agreeable. Thanks for the heads up.

[konextu]

oh one last thing, on the minicsv layout show by the help file on the command line loader, it does show where the extra phone numbers go, i'm assuming after the last data?

[mflorell]

minicsv doesn't allow for multi-alt phone numbers, only the standard format accepts them.

[gardo]

Umm.. how do you load the minicsv via command line leads loader again?

I'm getting this message: /usr/share/astguiclient/VICIDIAL_IN_new_leads_file.pl --forcelistid=801

----- FORCE LISTID OVERRIDE: 801 -----

test.csv 70
test.csv 70

BAD Home_Phone: |

TOTALS FOR test.csv:
Transactions sent:1
INSERTED: 0
INSERT STATEMENTS:0
ERROR: 1

The content of my test.csv is exactly the same as the example:

"105 Fifth St","Steinhatchee","Frank Smith","3525556601","FL","32359"

Using Astguiclient 2.0.4.1rc5.

[mflorell]

You forgot "--format=minicsv"

[gardo]

Thanks Matt. Worked like a charm.