Origination rates upload failure

Hi,
Version 6 ASTPP

Import Origination rates. Regardless of increment, the import fails with Initial Increment is not Valid
Well the increment is exactly the same as the Origination Rate Sample CSV. Tried shorting the cost/minute to 2 digits i.e. 0.00 where is was 5 digits. Made no difference.

2-row example:

Code Destination Connection Cost (USD) Grace Time Cost / Min (USD) Initial Increment Increment
7840 Abkhazia Fixed 0 0 0.47 30 60
649 New Zealand Fixed - Auckland 0 0 0.021145133 30 30

Downloaded ERROR CSV displays:

Code Destination Connection Cost (CAD) Grace Time Cost / Min (CAD) Initial Increment Increment Error
7840 Abkhazia Fixed 0 0 0.351008215 22.40477969 60 Initial Increment is not Valid
649 New Zealand Fixed - Auckland 0 0 0.01493652 22.40477969 30 Initial Increment is not Valid

The other very strange this is, the CSV file imported for Origination has exactly this:

Code Destination Connection Cost (USD) Grace Time Cost / Min (USD) Initial Increment Increment
7840 Abkhazia Fixed 0 0 0.47 30 60
649 New Zealand Fixed - Auckland 0 0 0.02 30 30

And the failure shows the initial increment as 22.40477969
Where is it getting the number from?

The downloaded EXAMPLE of the Origination CSV has:

Code Destination Connection Cost (USD) Grace Time Cost / Min (USD) Initial Increment Increment
1 USA 0 0 0.01 30 60
44 UK 0 0 0.05 30 30

So how can we get this to work?
Thanks.

Hello @Mr.Smith ,
Do you have any rates in sheet like 22.40477969 ?
Also please share your csv file here.
Thanks.

Hi Palak,
This is an abstract of what is contained in our rate sheet in CVS format

9173900 India Mobile - AirTel 0 0 0.0411 30 60
9173908 India Mobile - AirTel 0 0 0.0411 30 60
9173909 India Mobile - AirTel 0 0 0.0411 30 60
9173920 India Mobile - AirTel 0 0 0.0411 30 60
9173928 India Mobile - AirTel 0 0 0.0411 30 60
9173929 India Mobile - AirTel 0 0 0.0411 30 60
9173930 India Mobile - AirTel 0 0 0.0411 30 60
9173938 India Mobile - AirTel 0 0 0.0411 30 60

Importing the above from test_rate_sheet.csv

Click IMPORT button and it displays:

Origination Rates Preview
Code Destination Connection Cost (CAD) Grace Time Cost / Min (CAD) Initial Increment Increment
9173908 India Mobile - AirTel 0 0 0.0411 30 60
9173909 India Mobile - AirTel 0 0 0.0411 30 60
9173920 India Mobile - AirTel 0 0 0.0411 30 60
9173928 India Mobile - AirTel 0 0 0.0411 30 60
9173929 India Mobile - AirTel 0 0 0.0411 30 60
9173930 India Mobile - AirTel 0 0 0.0411 30 60
9173938 India Mobile - AirTel 0 0 0.0411 30 60

Now click PROCESS…

Error In CSV File

Records Imported Successfully: 0
Records Not Imported : 7

Code Destination Connection Cost (CAD) Grace Time Cost / Min (CAD) Initial Increment Increment Error
9173908 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173909 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173920 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173928 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173929 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173930 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid
9173938 India Mobile - AirTel 0 0 0.030694548 22.40477969 60 Initial Increment is not Valid

ASTPP is putting that 22.40477969 number

Hello @Mr.Smith
We tried our side and it seems to work fine.
Can you please provide your rate sheet (test_rate_sheet.csv sheet) for more investigation?
Also please share Admin currency and system currency as well.

How can I share the .csv file? This portal doesnt support it.

This whole system is not what I call good. My old system works perfectly. Even the fixer key doesn’t work so currencies cannot be updated.
Example, Fixer Key *
Thank you for your business with us! You can immediately start using the Exchange Rates Data API now. You will also receive an email confirmation with details.

Your API Key

Use this API key for each request. Please check docs for more information.
92qY8OapAQkgNWJkEdGuskJjxVHRdmSb

Click update currencies…
currency exchange rates not updated successfully for this reason invalid_access_key please check from fixer side.

So far this system is USELESS!
Even your Quick Start is out of order.

Your guide says:

Origination Configuration

**Create Rate Group. Tariff -> Rate Groups**

** Select Trunk in Rate Group**
** Add Origination Rates. Tariff → Origination rates (Pattern example : 1, 235)**
That is WRONG!. You need to have gateway and trunk created FIRST. I presume this incorrect info is due to the fact you want people to buy the enterprise version.

I thought this astpp billing could replace what we use but it cannot.

Not heard of sites like pastebin, Drop Box, Google Drive, OneDrive, etc?