Radarspotting

Mode-S Software => PlanePlotter => Topic started by: mezoo on April 06, 2016, 10:55:58 PM

Title: PP Reports - Time and Date
Post by: mezoo on April 06, 2016, 10:55:58 PM
Hello,

I'm sure this issue has been discussed somewhere but I just cant find it.

I am using Python scripts to transferring my PP report files (txt and sqb) to a MySQL database.
All is fine except the date/time issue.

The SQB files containing the first/last database contain a UNIX timestamp  - this I can convert into a SQL timestamp.

However the data in the report files (txt) only contain the UTC time, but no date field.
The date is part of the file name.
It seems to me that the PC clock is used for the filename e.g. 20160406xx.txt

Around midnight this gves a problem
With DST the local time in Germany is now 2 hours ahead of UTC.

What happens to the data stored between 22:00 to 24:00 UTC  (00:00 to 02:00 local) ?
Into which report file does PP put the data ?
     - into the one of todays files      e.g 20160406xx i.e. based on PC clock
     - or into one of tomorrows files  e.g.20160407yy i.e. based on UTC

Looking into the report files I see that the data for this time period is out of sequence and is usually found in the first daily report file for the interval 00:00 to 06:00.
I have set up PP to rename the report files every 6 hours - so everyday I get three report files each day.
(My hope is that in this way less data is lost if PP stops working compared to a daily file.)

Regards
mezoo