How to Import Ratecard from XLS File ?

Mutaherul · **Joined:** Sun Apr 29, 2007 4:08 am **Posts:** 14

I want to make a option on Import Rate Card where can I import
rate card from XLS file.

Can anybody have any Idia .
may be it's the change on tab separator parsing.

Thanks in advance

devplan · **Joined:** Sat Apr 07, 2007 5:01 pm **Posts:** 48

Hi Mutaherul

You will need to first make a CVS (comma separated) file, i.e.
save your table in Excel as .CVS
Then replace all commas with semicolons (fx Wordpad)

After it should look like this: (sample)

Code:

dialprefix;destination;rate initial;buyrate;buyrateiniblock;buyrateincrement;initblock;billingblock;connectcharge
0093;Afghanistan;1.44;1.34;60;60;60;60;0.25
009370;Afghanistan - Mobile;1.52;1.42;60;60;60;60;0.25
009379;Afghanistan - Mobile;1.52;1.42;60;60;60;60;0.25
00355;Albania;0.55;0.45;60;60;60;60;0.25
0035568;Albania - Mobile;1.14;1.04;60;60;60;60;0.25
0035569;Albania - Mobile;1.14;1.04;60;60;60;60;0.25

rgds, devplan

Mutaherul · **Joined:** Sun Apr 29, 2007 4:08 am **Posts:** 14

Hi devplan

Actually I want a change on a2billing code ,so that from a2b web interface i can directlly browse a XLS file and then it can import Rates from there.

Now ,without CSV, no other file can imported.

Thanks for your response.

provided by Star2Billing S.L.

How to Import Ratecard from XLS File ?

Who is online