Page 1 of 1

[SOLVED] Corrupting phone list when importing

PostPosted: Tue May 02, 2017 11:50 am
by c20xh2
Hi,

Since last week, when we try to import a new list containing more than 500 leads in it, the system add the 3 digits from the address column to the phone number.

Example:

This List:

819XXXYYYY Mr1 ZZZ BOUL SAINT-RENE E GATINEAU
819XXXYYYY Mr2 ZZZ RUE P.-LABINE GATINEAU
8191234567 Mr3 890 RUE P.-LABINE GATINEAU

Become this:

819XXXYYYYZZZ Mr1 ZZZ BOUL SAINT-RENE E GATINEAU
819XXXYYYYZZZ Mr2 ZZZ RUE P.-LABINE GATINEAU
8191234567890 Mr3 890 RUE P.-LABINE GATINEAU

List come from the same place as usual, same delimiter as usual and we loaded bigger list before.
Hard disk are around 20% full, really nothing unusual nowhere.
No error logs in any mysql errors logs.
Did a reset of everything in the right order.


Specs :

1) Version of VICIDIAL

VERSION: 2.14-588a
BUILD: 170211-1041

2) loadavg

top - 02:36:24 up 2 days, 10:35, 2 users, load average: 0.09, 0.12, 0.10
Tasks: 109 total, 2 running, 107 sleeping, 0 stopped, 0 zombie

3) Server Specs

Cluster, Asterisk is running with 100gig HDD and 4 gig ram

4) Codecs used

Not sure right now , dtmfmode=rfc4733

5) VOIP or PSTN

VOIP

6) OS

PRETTY_NAME="openSUSE Leap 42.1 (x86_64)"


Any ideas ?

Re: Corrupting phone list when importing

PostPosted: Tue May 02, 2017 12:04 pm
by mflorell
I haven't seen that before. How exactly are you loading the leads?

Re: Corrupting phone list when importing

PostPosted: Tue May 02, 2017 12:27 pm
by c20xh2
Hi mflorell,

1. Create a list

listloader :
Image

2. Set custom layout

Custom load-out :
Image


Exemple from the list :

list :
Image

Re: Corrupting phone list when importing

PostPosted: Tue May 02, 2017 12:30 pm
by mflorell
I might suggest converting your file to tab-delimited .txt file and see if you get the same results.

Re: Corrupting phone list when importing

PostPosted: Tue May 02, 2017 12:32 pm
by williamconley
Also try it with just ONE record (one that screwed up) and see if the screwup is identical and happens again.

Re: Corrupting phone list when importing

PostPosted: Tue May 02, 2017 12:44 pm
by c20xh2
Converting to tab-delimited did the trick. A big thank you for your quick response