Thirdlane.com logo

DID BulkUpload

Posted by adrianellis on Wed, 01/18/2012
Forums
Thirdlane platform General Questions

Hi Guys,

We use number format of 10 digits. All start with '0'. If we do a bulk upload of numbers (eg:0123456789 to 0129876543) the first loaded DID has it's leading '0' but the rest all are 9 digits and start with 12.

Please can someone assit with this?

Thanks,
A

Submitted by eeman on Fri, 01/20/2012 Permalink

im sorry but thats simply a problem of mathematics, no number really starts with zero. Any time you assign a number with a leading zero to an integer defined variable, its always going to ignore the zero valued place holder. The TN's you input are integers and the nature of an integer in programming is going to strip that zero off there. This seems to only be a problem in europe where some group of countries decided this was a good way to present TNs starting with zeros. Have you considered, instead, making all your DID in true E.164 format? +33123456789 ?

Submitted by douglas.ross on Wed, 05/09/2012 Permalink

Hi,

To change our format to E.164 would mean changing our data in our database and the database format. We have to keep it in the 012- format.

Submitted by eeman on Thu, 05/10/2012 Permalink

then it sounds like you've got the unfortunate answer.. input them manually versus relying on programming mathematics and automated loops. I know it sucks, but there's absolutely nothing that can be done to change the underlying behavior of Perl, C, and C++

just for shits and grins.. has anyone attempted the process of prepending? Take the previous example..

(eg:0123456789 to 0129876543)

have you tried putting this in the boxes..

123456789 Through 129876543 Prepend 0

i know when I want to add a range of E.164 I put the + in the prepend box and leave the numbers for the range.

Submitted by adrian.ellis on Thu, 05/10/2012 Permalink

Hi, Thanks for this. This is a mysql issue.

We are not yet ready to move to the E.164 platform. We have a SBC that does all the number modifications for us. Most of our clients have their own Asterisk boxes and are also not yet prepared for the change over. So we just accept what they are sending to the SBC and modify according to the E.164.

So for now i will have to manually insert the numbers, or insert the bulk upload and run a mysql query to fix them.

Thx
Adrian