Updating the Rate Sheet in the COGEXO Rating Engine

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.

Interested? Click here to contact us for a free consultation →