TNG rates

[yolandea]

ECN TNG RATES.CSV

Hi belinda

find attached my spreadsheet and below the logs:

2013-10-21 12:13:16:285 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2879@from-queue-9f67;2[10]UniqueID: 1382336964.46472[10]DialStatus: ANSWER[10]
2013-10-21 12:13:16:285 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:12:38:110 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2878@from-queue-4c73;2[10]UniqueID: 1382336964.46467[10]DialStatus: CONGESTION[10]
2013-10-21 12:12:38:110 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:12:04:954 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2879@from-queue-abd4;2[10]UniqueID: 1382336951.46449[10]DialStatus: CANCEL[10]
2013-10-21 12:12:04:954 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:10:51:630 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2878@from-queue-934c;2[10]UniqueID: 1382336951.46444[10]DialStatus: CONGESTION[10]
2013-10-21 12:10:51:630 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:10:15:457 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2879@from-queue-02a4;2[10]UniqueID: 1382336948.46435[10]DialStatus: CONGESTION[10]
2013-10-21 12:10:15:457 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:09:54:360 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2878@from-queue-834c;2[10]UniqueID: 1382336948.46430[10]DialStatus: CONGESTION[10]
2013-10-21 12:09:54:360 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:09:14:163 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2879@from-queue-8943;2[10]UniqueID: 1382336946.46421[10]DialStatus: CONGESTION[10]
2013-10-21 12:09:14:162 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:09:04:114 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/1002@from-queue-ebe6;2[10]UniqueID: 1382336925.46312[10]DialStatus: ANSWER[10]
2013-10-21 12:09:04:114 [1.1.1.11] - AMI Exception:ProcessAMIEvent: ProcessDial 3: Access violation at address 0818C466, accessing address 000000A9
2013-10-21 12:08:57:729 [1.1.1.11] - RateBook : ecn Loaded [ver 2007.06.12.01]
2013-10-21 12:08:57:725 [1.1.1.11] - Loading Ratebook: /opt/datatex/tng/rates/ecn.so
2013-10-21 12:08:42:001 [1.1.1.11] - AMI Exception:Event: Dial[10]Privilege: call,all[10]SubEvent: End[10]Channel: Local/2878@from-queue-d6e2;2[10]UniqueID: 1382336946.46416[10]DialStatus: CONGESTION[10]

[Belinda Frick]

The TNG Simple All Custom rates options is currently only available for Windows. This is why your testing on TNG for Asterisk shows zero costing.

I had an issue on my PC yesterday, once I have it sorted I will complete the testing of your rates in TNGLive (Windows).

My apologies for the delay.

As far as the Asterisk AMI errors, please check with your technician if he managed to make the changes as per telephone conversation - refer to forum post:
TNG4* Custom CSV is correct format but not logging calls

I would also suggest checking the size of the master.csv file. If it did not import it might be huge. Try to move it away to a backup location and see if the new file that is created is imported into TNG.

[Belinda Frick]

I tested the All_Custom_Simple custom ratebook feature with TNGLive Windows (with buffer) version 1.1.1.11.

I exported your Excel file as Comma Delimited CSV and renamed to .txt file extension.

I then added the entries to the all_custom_simple.ini as described in the configuration:
TNG - Simple Custom Rate

My rates picked up a costing:

20131024-tng-all_custom_simple.jpg

If your testing was done on a TNGLive for Asterisk, then that is the issue. On Linux the .dll file is replaced with a .so file. We have not released one for Linux yet.

[Leon van Heerden]

TheLinux version of the Simple Custom Rates is now available too.

[Belinda Frick]

TNG does not have a ratebook for ECN and all the ECN prefixes was not part of the exchange file.

For ECN you must enter for example a Telkom number for your area on install under Area Information and select the ratebook for the number you used - not the ECN switchboard number. This will ensure the Exchange file is buildt correct.

You can then setup your custom ratebook using the Simple Custom option as discussed. This will apply for any Provider TNG does not have a ratebook for. Once you have configure your ratebook you can select it as your default ratebook.

The latest version of TNG now has the ECN number range - refer to forum post:TNG Update 1.1.1.12
NOTE: You still need to follow the same process to setup your own custom rates.

[yolandea]

Hi Belinda

i am still struggling to get the ecn per second billing to cost correctly, i renamed the exchange file but it is still out.

see below screen shot and attached my rate file.

[yolandea]

good day

find attached screen shot of the call calculator.

Yolande