Upgrading realtime queue_log from 1.6 to 1.8

[trymes]

Has anyone come up with a good method to upgrade the realtime queue_log table from 1.6 to the 1.8 format?

I believe that QM is ready to go with Realtime Queue Log and Asterisk 1.8, but my table is not!

Many thanks,

Tom

[QueueMetrics]

From http://dev.mysql.com/doc/refman/5.0/en/string-functions.html :

"MySQL does not include a function to split a delimited string. "

So you would need some string black magic to separate the data field in its parts - or export to SQL and edit the SQL script using a macro or something.....