I am logging data and then exporting to sql, for some reason i get two rows of data with ‘undefined’ which stops the sql from importing the data into the table.
how do i stop this from happening or isit possible to delete individual data rows?
I am logging data and then exporting to sql, for some reason i get two rows of data with ‘undefined’ which stops the sql from importing the data into the table.
how do i stop this from happening or isit possible to delete individual data rows?
This is because you have historical logging enabled for a tag, but are not getting data at that time, so it’s going to read undefined. Are these deadband logged tags?
yes they are. It only occurs at the start of a new log. is it possible to delete rows of data.
No. The Ewon can’t delete rows of data unfortunately. You may want to create a case at support.hms-networks.com to see if your local support group has any other suggestions to help you get around this.
The topic has been widely discussed on the forum before: Search results for 'flexy undefined' - hms.how
It’s also been discussed on the developer forum: Ewon Technical Forum - Search Results