asterisk2billing.org
http://forum.asterisk2billing.org/

A2billing 1.6 rate importing CSV creates duplicate entries
http://forum.asterisk2billing.org/viewtopic.php?f=33&t=7216
Page 1 of 1

Author:  chrisxiao [ Mon Mar 01, 2010 6:14 pm ]
Post subject:  A2billing 1.6 rate importing CSV creates duplicate entries

I create a DOS CSV file. Here is a sample entry with fields dialprefix,destination,selling rate, and tag:
_011612XXXXXXXX,Australia,0.01,Australia-L-SYD
_011613XXXXXXXX,Australia,0.01,Australia-L-MEL

After the import,
1) I get two rates for each of the above entry and I have to manually delete the duplicate.
2) The imported rate will have blank for destination. I tried to change 'Australia' in CSV to 61, and import, no improvement.

_011612XXXXXXXX,61,0.01,Australia-L-SYD
_011613XXXXXXXX,61,0.01,Australia-L-MEL

Author:  bruce [ Mon Mar 01, 2010 6:19 pm ]
Post subject:  Re: A2billing 1.6 rate importing CSV creates duplicate entries

Why do you have dialprefix starting with _ and having xxx in it?

If you simply put it like this it should work:

61;Australia;0.01;Australia-L-SYD

OR (in case you don'g remove international prefix in call plan)

01161;Australia;0.01;Australia-L-SYD

-Bruce

Page 1 of 1 All times are UTC
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/