QueueMetrics forum

QueueMetrics => General Asterisk configuration => Topic started by: trymes on February 27, 2012, 18:02:24

Title: Upgrading realtime queue_log from 1.6 to 1.8
Post by: trymes on February 27, 2012, 18:02:24

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

Title: Re: Upgrading realtime queue_log from 1.6 to 1.8
Post by: QueueMetrics on March 02, 2012, 09:00:56

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.....