Preparing Rate Chart for Uploading
There are some thumb rules for creating a good *.CSV file.
i. The file must not contain any header row or any extra space
ii. Columns of the file must need to be aligned as following with specific type of data.
iii. Latter beside item denotes the number of column, i.e. Rate Per minute must need to put in the 1st column of the file.
A. Rate per minute: cost per minute with your currency, we need to put this data in number format in the file.
B. Rate per call: cost per call, we need to put this data in number format in the file.
C. Currency ID: Saved ID for your currency in the database of your switch. You can check it from the switch web interface where currency list is available, for example, 1 for USD. We need to put this data in number format in the file.
D. Grace: It is grace second you want to set. Numeric Value starting from 0, we need to put this data in number format in the file.
E. Minimum duration: We need to put this data in number format in the file.
F. Pulse: We need to put this data in number format in the file.
G. Starting time: It needs to be set like “HH:MM:SS” i.e. “00:00:00”. We need to put this data in text format in the file.
H. Ending time: It needs to be set like “HH:MM:SS” i.e. “23:59:59”. We need to put this data in text format in the file.
I. Day of the week: It needs to be set like “SUN, MON, TUE, WED, THU, FRI, and SAT”. We need to put this data in text format in the file.
J. Second per minute: Numeric Value; by default it is 60 (Number Format)
K. Destination name: Name of the Destination like “Mexico Mobile” (Text Format)
L. Destination code: Code Number of the Destination (Number Format)
Sample CSV File:
Sample CSV File:
 |