wiki:contributed/Billing2DB
Last modified 7 years ago Last modified on 11/03/10 19:08:01

A tool to fill the billing DB from the text log files provided by Pablo Fernandez.

"The script accepts a filename as parameter (a billing-YYYY.MM.DD file). When you run it, it will emit the [SQL on stdout that you] have to inject (is safe to run it many times; the code to inject the SQL is [in the script], but commented out) and, at the end, the number of lines of every type it detects. Errors are the lines it didn't recognize, the rest are fine.

Also, don't expect the database to be 100% perfect, simply because the information in the billing files IS NOT exactly the same you find in the database. Anyway, it was good enough for me. Good luck!" Pablo

billing2db.tar (20.0KB)