Uploading New Rate Chart From File
Creating rate charts that contains thousands of rate entry may be huge time consuming if we want to do it using system's web interface. SyncSwitch provides tools for importing rate charts from comma separated value file (*.csv) which can save a lot of time. Using this option you can add multiple rates in a rate chart instantly. All destinations available in the uploaded rate chart will be added to destination list as well.
|
Preparing the File
|
For uploading a rate chart, we will need some sort of preparation. We will need to prepare a spreadsheet (from any software vendor i.e. Microsoft Excel, Apple iWork Numbers, Open Office Spreadsheet etc). Destination code is the unique key here. So, destination code can not be duplicated, remember again, no destination code can be duplicated into the file. If the uploader took gets any duplicate entry on the file, it will stop processing the file then and there.However, it will upload all destinations and rate items before it gets the duplicate entry.
Following table explains in which column you need to enter which value.Please follow this strictly. No spaces are allowed into the file.
|
Column Number
|
Value
|
Explanation
|
Example
|
|
A
|
Rate Per Minute
|
Please refer to the section “Adding Rates To The Rate Chart"
|
0.10
|
|
|
Rate Per Call
|
Please refer to the section “Adding Rates To The Rate Chart”
|
0.00
|
|
C
|
Currency ID
|
Every Currency have an id in database. USD is by default added to the database and its id is 1. If you want to use USD, use 1 as your currency id.
|
1
|
|
D
|
Grace
|
Please refer to the section “Adding Rates To The Rate Chart"
|
5
|
|
E
|
Minimum Duration
|
Please refer to the section “Adding Rates To The Rate Chart"
|
30
|
|
F
|
Pulse
|
Please refer to the section “Adding Rates To The Rate Chart"
|
6
|
|
G
|
Starting Time
|
Please refer to the section “Adding Rates To The Rate Chart"
|
00:00:00
|
|
H
|
Ending Time
|
Please refer to the section “Adding Rates To The Rate Chart"
|
23:59:59
|
|
I
|
Days of Week
|
Please refer to the section “Adding Rates To The Rate Chart"
|
SAT,SUN,MON,
TUE,WED,THU,FRI |
|
J
|
Seconds per minute
|
Please refer to the section “Adding Rates To The Rate Chart"
|
60
|
|
K
|
Destination Name
|
Please refer to the section “Adding Rates To The Rate Chart"
|
Bangladesh Mobile
|
|
L
|
Destination Code
|
Please refer to the section “Adding Rates To The Rate Chart"
|
8801
|
Since, we have the file prepared for uploading, we can upload the rate chart now. But for that, make sure that you have already created a rate chart. For your information, you can upload a rate chart in such a rate chart which is already created into the web interface and that already have some rate items under it.This will not be any problem. But in such cases, you need to remember to delete existing rate items (destination code and corresponding data) from the file. Otherwise it will show duplicate entry and your rates will not be uploaded.
Now that we have created a rate chart into the web panel and we have the file prepared for uploading, you can upload the rate chart by following steps below.
- Go to Rates >> All rate charts
- Click on the desired rate chart name from the list
- Now click on the Upload Rate tab
- Click on Browse button to and locate the .csv file saved on your computer
hard disk - After selecting the file, click on Open
- Click on Upload Rates button; SyncSwitch will add all rates from that file to
your selected rate chart.
If you have any error on the file such as wrong type of data in wrong column, insufficient data or duplicate entries, space into any field, any header row, SyncSwitch will show you that, in that case you will need to come back to the file again and fix errors and try for uploading again.
Here, one thing to be noted that, for example if you have a duplicate entry in 11th row. First 10 row data will be inserted and from 11th, no data will be inserted. So, for next attempt for uploading, first 10 row will be duplicate entry since they are already inserted, you will need to delete them from the file.
For any kind of help and support , please send email to synccare@synchronousict.net and schedule training. Someone from our team will be online with Windows Live, Yahoo or Gmail account to help you live. Enjoy the quality services of SyncSwitch and best of luck!!