Unable to import Dial List

[torpedotim]

I'm trying to import a dial list, but I seem to be getting stuck..
I 'think' the problem is how I export the list.
My numbers are in this format
"+1 555-237-1234"
When I try an import that, it keeps coming up with 'Bad Number'
I've tried making a template, but I don't see any way to use that format.

Unfortunately, that's the ONLY way the numbers can be exported. It support multiple countries, so the country code is always at the beginning.

Any ideas on a template that would allow me to import numbers in this format ? "+1 555-123-1234"

Thanks

[MJCoate]

Hello,

- How are you trying to load your leads? Please give the EXACT steps that your'e taking. Also, please post your version and build of VICIdial.

- You shouldn't import the country code with the number into the "phone_number" field. That should instead go into the phone_code field. If you have A LOT of different countries, you need to use the command line list loader. If it's only a hand full, you can simply break them into their own files and use the appropriate phone code override through the web-based lead loader..... But, if you HAVE to load them from a single list, you could get away with putting the country code and phone number together as long as your dialplan is setup to work with different countries. You'd also need to tell the campaign to omit the phone code when dialing.

- The "+" shouldn't be imported into the list. In fact, VICIdial will strip it out along with anything else that isn't a number. If you have to send your calls with a leading "+", this should be done in the dialplan (well; if it can be at all. The "+" sign actually has a function in Asterisk so I'm not sure how you'd tell it to add it).

[torpedotim]

I'm running 2.9.441e
Build : 140612-1628

I choose to load leads from File, choose my .csv file
Created a custom template, assigned the 'phone' field from the CSV file to phone, and when I try and import I get this.

record 2 BAD- PHONE: ROW: |Open| INV(INVALID PHONE NUMBER LENGTH):
record 3 BAD- PHONE: ROW: |Open| INV(INVALID PHONE NUMBER LENGTH):

[roger.milligan]

Hi Tim

Please post the first few lines of your CSV file - it would be helpful to see the exact data.

The load code gives that error if the phone number is not between 6 and 16 digits long - after it strips out anything that is not a digit. In your case your numbers should be 11 digits once stripped.
(strlen($phone_number)<6) || (strlen($phone_number)>16)

Could you be linking the wrong column in your CSV to Phone Number?