Ok, I get it. The data filter plugins are only activated with the Enterprise version. Sorry for the misunderstanding.

How do I activate the parser, is this seperate from activating the program itself?

I would like to know if it's possible to change the parsing of data based on a certain character appearing in the data.

I have the following setting which will contain a letter and based on the letter I want to parse the line of data differently;

Thank you in advance.

P.S I also have an unrelated question with regards to the plug ins I have installed the aggreation, deadband, expressions and script execute data filter modules but they are all greyed out. Is that something to do with my version not being compatible? Please advise of how I can get the plug-ins working.

Hi,

As I am not familiar with the correct terminology I am having some trouble using the expressions plugin and I was hoping to get some help.

This is what I am trying to achieve.

I want to show true or false if the following Variable is met.

Conditional: IIF
Variable: TYPE
Operator: =

in this case IIF(`TYPE`='N',true,'false')

I have also tried it like this;

IIF(TYPE=N,true,false)

But can't seem to get it to work. If you can please provide an example with my variables above so I can get this working...

Hi Arthur, thanks for your help. I still had some problems after changing the table names in mySQL and also the SQL query table in the data logger program...not sure why this is?

Any how I added a new parser with a different name and changed the SQL parser to match and it is now working as expected.

Thanks again for your help. This software is working very well. As you know I have tried almost every export plugin available and considering that from a technical perspective my programming knowledge is very limited so if I could get it to work I'm sure any user could also.

By the way I've said this before but your responses to my questions on this forum have been exceptional. I appreciate all your help.

I know how this must sound by my feedback is genuine I DO NOT have any affiliation with this software or employee's.

So let me get this straight...

Do I leave the data parsing settings as is?

I'm just a little confused...can you give me an example?

Thank you in advance.

Do you mean to change the table names in mySQL, I don't quite understand?

Would I need to change any of these settings on the data logger software?

I have tried various different ways to fix this problem with no success...it's seems very odd that the only field effected is the type field. It always returns a value 4 no matter what I do???

It doesn't seem to have anything to do with the order or variables of the parser items, SQL queries. I have also tried to change the database table names but the data wouldn't export into mySQL at all.

I would be happy to provide the raw data prior to parsing so that you can see if this problem can be resolved.

Regards,
suprsnipes

Hi Arthur,

I have attached a copy of the program settings (backupofsettings.txt). I realized that I had not configured the SQL queue correctly and have made some progress. I am now able to make a connection to mySQL database.

The data is exporting into mySQL except for one problem, a column, the 'type' column should show a value of either 'A', 'B', or 'S'. After attempting to re-configure the settings a number of times I am having the same problem. I keep getting a value of '4' instead, all the remaining columns are working fine. (I have attached a .jpg copy of the mySQL data sample).

I'm not sure if mentioning the following will help but the DDE server doesn't seem to have a problem with this (see DDE .jpg attached). I have using the same information to export the data into mySQL. There are no other queries running at this stage.

I can get a connection to mySQL. But I receive this error message.

"Data have been processed but with errors".

I've set up the database in mySQL with a data table that corresponds to the data parser settings. I've never done this before so I'm not quite sure where I have gone wrong.

Appreciate the help.

That's great.

"Tested Successfully".

Appreciate the help, again...

I am having difficulty trying to use the SQL Database Professional Plugin.

I have installed the plugin and read the documentation but I am still having trouble getting a connection.

In the connection parameters window when testing the connection I receive the following error message;

Database accessing error[Unable to connect to a database [Error loading library 'libmysql.dll'].].

I have mySQL installed and have a local database already created yet I still get this message.

Appreciate your help.

I hope this ok.

Please see attached.

Do you need data before or after it has been parsed?

By the way I have changed the IP and Port settings for security.

There also seems to be a problem with the program hanging up when opening when the DDE Link and Direct Excel connection export options are selected.

It opens Excel but as explained previously there is no data exported. I have to close Excel, then the program commences again. After which I have tried to go to the export options and selecting setup for the Direct Excel connection which opens Excel again, but no data is exported, yet the program doesn't freeze on this occasion.

I have got the DDE Excel export feature to work, by that I mean it can send the whole data packet without a problem after parsing (besides the fact that I haven't learned how I to have the current data move down a row each time new data comes in, but that's another problem).

Preferably I would like to use the Direct Excel Connection and I have looked at the tutorial about sending data via this method. So far I believe I have set this up correctly but the data simply won't fill in Excel using this method.

I have attached a screen shot of the DDE server's active items to show you where I am at. The names of the active items I want to use are the SYMBOL, DATE, TIME, TYPE, PRICE and SIZE.

I have set up Bindings to reflect this also (screen shot attached). The odd thing is when I add the 'FULL_DATA_PACKET' to the Bindings it works as expected.

I'm so close to getting this to work.

Thanks for your help.