Click Here To Visit SIP Broker  

Go Back   Voxalot / SIP Broker Support Forums > Voxalot Forums > Voxalot Support

Voxalot Support Support for the Voxalot service.

Thread Tools Display Modes
Unread 06-22-2009, 10:05 PM   #1
Senior Member
Join Date: Jan 2007
Posts: 222
Thanks: 44
Thanked 23 Times in 22 Posts
tomblandford is on a distinguished road
Send a message via Skype™ to tomblandford
Default Export WebCallBack - leading zero lost

I tried to export my webcallbacks so that I could change my home number on about half of the entries in one go. The leading zero was lost on all my UK numbers but the US ones which start with the area code were of course not affected. When I reimport the zeros are gone so the calls do not get routed properly. I have to manually go down the list and edit them all to fix it.

Is it possilbe to modify the export funtion so that a ' is placed before each number in excel? That will retain the zero up front. This ' is ignored by default in excel, so will not appear in Voxalot when the import is done.
tomblandford is offline   Reply With Quote
Unread 06-23-2009, 08:08 AM   #2
Senior Member
Join Date: May 2008
Location: Portugal and Brazil
Posts: 107
Thanks: 7
Thanked 26 Times in 21 Posts
carlosalbffgomes is on a distinguished road
Default The problem is with excel

The problem you report happens because excel and not because Voxalot export functions. When you open the file exported by Voxalot with excel, all numbers are imported as numbers and not as text, so the leading zero plays no meaning.
As Voxalot export as a CSV file (a text file in which each value is separated by commas in a line), you should edit this file as a pure text file, maintaining it's format. In windows, you should open it with Notepad and edit it as text. In this way, the problem you report will no longer appear.
carlosalbffgomes is offline   Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
WebCallBack Down jimfla Voxalot Support 3 04-16-2009 01:19 AM
Using Suretelecom with Webcallback juancarlos Voxalot Support 1 06-30-2008 06:14 AM
WebCallBack not working with ENUM / my Voxalot number tomblandford Voxalot Support 1 08-31-2007 12:59 PM
WebCallBack suggession? majo Voxalot General 0 07-05-2007 11:00 AM
Webcallback anomaly Sempron Voxalot Support 2 05-04-2007 08:02 PM

All times are GMT. The time now is 04:53 PM.

Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.