|
Voxalot Support Support for the Voxalot service. |
Thread Tools | Display Modes |
06-22-2009, 10:05 PM | #1 |
Senior Member
|
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.
__________________
http://www.planina.co.uk/contact.htm |
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 |
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. Regards. |
|
|
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 |