Page 1 of 1

"null" values in Data Logger Database during each power ON

Posted: Sat Jun 30, 2012 12:16 pm
by vinit_patil
Hi,
I am using Qterm A12 Panel with iX Develope 1.31.
I have to log the data using a "Log on Tag Change" event
Though i have initialized value of the TAG used for log on tag event to "0" during power on there are "null" values found during each Power ON.

I have created settable timer to change the TAG value fro log on Tag event.
timer1 = new Timer();
timer1.Tick += new EventHandler(TimeOut1);
timer1.Interval = Globals.Tags.SamplingInterval.Value*1000;
timer1.Enabled = false;
SamplingInterval tag checked fro NonVolatile memory
timer1 will only start whent START LOG button is pressed.
Once the Timer 1 satrts Tag value assigned to log on Tag event will incremented by 1 & data will get recorded accordingly.
that means @ power up condition TAG value is "0" so no data should not get recorded in data logger then why there are "null" values getting recorded?

Re: "null" values in Data Logger Database during each power

Posted: Mon Jul 02, 2012 9:02 am
by mark.monroe
This is by the design. The trend viewer uses the null values to determine
if there should be a gap in the trend curves. When the TrendViewer finds
null values there will be a gap between the null values (time stamp) and
the next sample in the table.
pic17035.gif
pic17035.gif (11.7 KiB) Viewed 10576 times
pic26299.gif
pic26299.gif (5.88 KiB) Viewed 10576 times

Re: "null" values in Data Logger Database during each power

Posted: Tue Jul 03, 2012 4:23 am
by vinit_patil
It is Ok in the case of Trend Database.
But i have used the data base logger to log the values in database table.
For which TAG used is initialized to "0" value at power up.
According to documentation if TAG value change other than "0" then only database logs the data.
Why there should be any "null" values recorded when we use the DATABASE LOGGER to log the values.

Re: "null" values in Data Logger Database during each power

Posted: Tue Jul 03, 2012 11:07 am
by mark.monroe
In iX 2.0 the trend viewer uses a datalogger to log data. Since the datalogger doesn't know whether it is being used in a TrendViewer or not, it logs null values for the reasons mention previously. Because the data is in a database, you can always write a SQL query and only pull out non-null rows.

Re: "null" values in Data Logger Database during each power

Posted: Mon Oct 29, 2012 4:13 am
by jcjelektro
Hello Mark

Is it possible to remove the function there makes the "Null" Values?

- Emil

Re: "null" values in Data Logger Database during each power

Posted: Mon Oct 29, 2012 8:47 am
by mark.monroe
No you can not get iX to stop inserting null values into the data stream. You can remove any null lines by using a data analysis or text processing program.