Rate table update on MySQL backed database
The concepts in this guide apply for the DB2 version of the rating engine.
Data Fromat
product_code_call,description,cost,call_type
Data Upload
For the MySQL back-end, use phpMyAdmin to upload the data:
- Log in to phpMyAdmin
- Select the
rate table- Click the
import tab- Select the file that has the comma delimited values (CSV)
- Set the number of lines to skip to 1
- Select CSV radio button
- Set the delimiter to “,”
- Check the
replace data with file box- Click Go
Upon successful import, a message diplaying the number of values imported, for example:
Import has been successfully finished, 1578 queries executed.