Hi Arthur

Is there any documentation that explains any or all the error and warning messages generated in the program protocol log file.

For example I am using the Advanced TCP/IP Logger with the SQL Pro plugin. I am seeing the following error message and would like to know if I need to do anything about it:

Connection aborted (#10053)

Thanks.

Ok, thanks.

Hello, its me again 

Two part question please. (1) Is there a way to format parsed data into XML format and (2) send this on to a webserver URL.

For example I have a php script running on my web server waiting for a connection to accept an xml string (form GET). I'd like the log monitor to parse the data from a text file, format it as xml and then send it on to my web server.

is it possible?

LOL, short and to the point!!

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!

Not so much a feature request but a question.

Have you, are you, or will you, at some stage, write linux versions of your software. It would be fantastic to have a these tools on a linux platform.

Thanks Arthur,

I'll give it a try now.

UPDATE:- Working fine, thanks!  

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?

Thanks Arthur, you are a very smart chap! Thanks

Do I have to use the smiley faces? lol

Hi

I am trying to parse the following line from a text log file using Log monitor & export.

ID:34343434#09DEVICE:Device101#09DATETIME:2013-01-17 09:45:05#0D#0A

I need to extract the value of the three items ID, DEVICE and DATETIME to separate fields and send them on to a database.

The ID field can vary in length as can the DEVICE field so I can't use "fixed length" in the parser.
Because there is a hex #09 after each field I can't use #09 as the delimiter as it parses the name AND the value. I can't use ":" as a delimiter as it does a similar thing and also the time field uses ":" so it tries the break that apart too.

I then tried using a regex to do the job but your regex evaluator seems to be limited in the expressions it can use.

For example (?<=ID:)(\d{8,12}?) doesn''t work on your system as the evaluator doesn't accept the "(?<=) lookbehind" operator. Neither does it accept the "(?=) lookahead"

Do you have any suggestions. It is such a simple string but I am stumped

Thanks

Brilliant! Didn't think of that. Newbie duh!

Thanks very much

I am trying to get SQL pro plugin to check the value of a field in a MYSQL table. If the value of the field matches then update the row with the new data. If the value in the field doesn't exist then create a new row.

Basically - IF EXISTS THEN UPDATE ELSE INSERT

I am tearing my hair out try to do this. Does anyone have a suggestion?

Thanks.