Receiving extra record in Historical Logging Table

Hi,

I am logging data to a historical Logging Table. At the end of the day I am pulling the data from the Log and sending it by email. The email script

works fine, and I am getting the email. But the problem is that the first record in the attached file doesn’t exist and it doesn’t matter for the
requested time period the system always put the first line. /marked bold underline bellow/

This is the email script I am using:

SENDMAIL “[email redacted]”, “”,“RFID Bags loaded for the day”, “&[$dtHT $ftT $st_h10 $et_m0 $tlA $fnDailyReport.txt]”

This is the attached file data I am receiving by Email:

“TimeInt”;“TimeStr”;“a_Prefix”;“b_Bag_Type”;“c_RFID”

1593057914;“25/06/2020 04:05:14”;2019;12;749

1593074470;“25/06/2020 08:41:10”;2019;12;2832

1593074480;“25/06/2020 08:41:20”;2019;12;749

And this is the data I have when print the Historical Log. The period is bigger than the previous file to show the first record in attached file not

exist here.

“TimeInt”;“TimeStr”;“a_Prefix”;“b_Bag_Type”;“c_RFID”

1592992385;“24/06/2020 09:53:05”;2019;12;2832

1592992395;“24/06/2020 09:53:15”;2019;12;749

1593074470;“25/06/2020 08:41:10”;2019;12;2832

1593074480;“25/06/2020 08:41:20”;2019;12;749

As you see the first record in the mail file /bold underlined/ doesn’t exist. My question is how can eliminate this fake record in the attached file?

Thank you.

Hi Svilen,

I just saw you had posted on the forum as well as the PM, let me know when you’re available to look at the logs this afternoon.

-Tim

Hi Tim,

I update the firmware, but still have this problem. I just did the test again and I am attaching the two files. The first one is the whole HLT and the second file is the one I am getting by email for HLT just for 1 hour
from now. And the first record in the email file does not exist in the whole Historical Logging Table file. Just to note the time is set to Pacific time.

This record is extra in a DailyReport file:

1593147834;“26/06/2020 05:03:54”;2019;12;749

Svilen.

DailyReport_26_6_2020.txt (193 Bytes)

EDBTable (1).txt (385 Bytes)

Can you send me a backup.tar file of your device so I can see if I can replicate this?

Ewon backup with included support files.

Hi Tim,

I am just following up if you have any updates on this problem.

Thanks,

Svilen

Hi Svilen,

Sorry about that, so far I haven’t been able to replicate this, I’m going to escalate this with the team over in Belgium and see if I can find out anymore info

1 Like

Could you make us a temporary user on your account and dm me that information so that my colleague could take a look at this?

We are doing some wiring on the panel and no plc connected at the moment. Ewon will be online. There are some records in the Historical table we made between July 25 and July 29

I forgot to give you the account name : [redacted]
I will try to keep the ewon connected online today.

Thanks ,

Svilen

Hi Tim,

Did anybody have a chance to look at this?

I’m still talking this over with my colleague in Belgium, he’s trying to get it to include the extra record but hasn’t been able to do it yet. I sent him over the EBD call that you were making and he was going to try it again and get back to me

&[$dtHT $ftT $st_h10 $et_m0 $tlA $fnDailyReport.txt]

Hi @Svilen_Staykov,

Is the user that you made for us on that account still active? I wanted to log on and check something that my colleague recommended but I wasn’t able to get into the account.

-Tim

I reactivated it now. Can you please let me know when you are done? They are working on the wiring now in the shop and I need to shutoff the power when you finish.

Thanks,

Svilen

I just finished taking a look and I’m sending it to my colleague now

It seems to be working now, if you only request data from a valid time range then it should show the correct values, but if you’re requesting data from before data was available it will still show those undefined errors.

Ok. I will need the data only from the previous day and I am not deleting the log file. I will try later because the panel is disconnected now.

Thanks,

Svilen

Ok sounds good, if you’re still getting some undefined values can you let me know the EBD call that you’re making?

Yes, I will.