Import Usage Data from SQL Database

[wellconnit]

Hi All,

I use WHMCS to bill some customers for internet services, because there is no API from the ISP to get the usage values I can't directly API into their systems from WHMCS; however I can get a text file with all of the information - service ID, upload/download usage, last updated, etc, etc.

Just wondering the best way to get WHMCS to read this so that I can display the usage details(similar to the way that the disk space/bandwidth consumption is show for cPanel accounts).

The internet service will have a custom field that will have the service ID in it, so that WHMCS can just do a simple read from the SQL DB for the values.

I'm writing the script myself to take it from the text file to the SQL database so I can customise the data going in as needed.

Any ideas?

[brian!]

thanks for sending the PM about this - i'll answer the question in there.