MYSQL Pro Plugin data backup file adding extra quotes.

Started by microman3000, November 29, 2022, 11:00:00 AM

Previous topic - Next topic

microman3000

Hi Arthur :)

Using the regex expressions you gave me for the Log Monitor & Export software I have the data pouring in to my database. Thanks!

I was disconnected from the network and the SQL pro plugin started saving data to its backup file. Perfect! However, when it started restoring the data, I noticed that in my database all the data values had quotes around them. Looking at the backup file each of the fields where in quotes. It seems like when the plugin resends the data it includes those quotes. This messes things up a bit, especially date fields.

Any thoughts?

Arthur Grasin

If you like my work, please take a few seconds and add feedback about our site or our software [here]

Arthur Grasin

If you like my work, please take a few seconds and add feedback about our site or our software [here]

microman3000

#3
Thanks Arthur,

I'll give it a try now.

UPDATE:- Working fine, thanks!  ;D

microman3000

Hi Arthur,

I have updated the Logmonitor program to the newest version 5.5.2 build 119

There is now a new message I see in the logs

"File interface. Data export queue is full (63). Skipping file."

Could you explain what this is. I hope that I am not losing any data!

Arthur Grasin

#5
This message means that the program reading data from the file faster than the parser and/or data export plugin can process it. You may ignore this message.
If you like my work, please take a few seconds and add feedback about our site or our software [here]