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

RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1
http://forum.asterisk2billing.org/viewtopic.php?f=22&t=7064
Page 1 of 1

Author:  striderec [ Wed Feb 10, 2010 1:44 am ]
Post subject:  RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Hello,

I currently am using A2B 1.5.1 and I added a new voice provider today. I tried to import the new rates linked to a new ratecard but the script is only importing the 3 mandatory fields (dialprefix, destination, selling rate).

My CSV import files also have the buy rate, the sell rate minimum duration and the sell rate billing block. The format of the file is correct, fields are separated by commas and the decimal symbol is the period (.).

I am using Mozilla Firefox 3.5.x by the way. I know IE 8.x has issues with the import process.

What can I do? I need to import the other fields too.

Best Regards,

Paul

Author:  jroper [ Wed Feb 10, 2010 8:59 am ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Hi

The separator is usually a semi-colon (;)

In Europe, the , is often used as the decimal point, while the . is used as a 000's separator, hence the reason for using a ;

Joe

Author:  manugmedia [ Wed Feb 10, 2010 1:39 pm ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Hi Paul,
Have you managed to import rates in 1.5.1, i have tried every combination until i have given up, all i get is

Code:
ERROR:

    * file type is not allowed: application/octet-stream
          o .html, .php, .txt, .inc (etc) (text/plain)
          o .csv (text/x-comma-separated-values)
          o .csv (text/comma-separated-values)
          o .csv (text/csv)
          o .csv (text/x-csv)
          o .xls (application/vnd.ms-excel)


If you have what is your format
Even a simple, 1, US, 0.70 returns the same error.
I wonder if this is a bug

Rgds
Eamonn

Author:  jroper [ Wed Feb 10, 2010 1:42 pm ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Hi

I've seen this behaviour in older verions of firefox,

My solution was to remove the file extension, and use IE

Joe

Author:  manugmedia [ Wed Feb 10, 2010 1:45 pm ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Ahh Got it,

The import rates doesn't work under Mozilla, it works with Opera and IE 8.

Rgds
Eamonn

Author:  jroper [ Wed Feb 10, 2010 1:52 pm ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Hi

Quote:
The import rates doesn't work under Mozilla


More accurately

Quote:
The import rates doesn't always work under Mozilla


Joe

Author:  striderec [ Thu Feb 11, 2010 7:05 pm ]
Post subject:  Re: RATE IMPORT PROCESS DOES NOT WORK WELL IN A2B 1.5.1

Thank you, my problem was solved by using the latest version of firefox.

Best Regards,

Paul

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