IP Cam Talk

Welcome to the new IPCT! If you are having an issue logging in, please clear your cookies / cache.

Change in the OpenALPR CSV Export

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
This morning, the format of the exported OpenALPR CSV file has changed. There are a 14 new fields added to the export:

crop_location
gps_latitude
gps_longitude
img_height
img_width
plate_x1
plate_x2
plate_x3
plate_x4
plate_y1
plate_y2
plate_y3
plate_y4
processing_time_ms

This will require a bit or rework on the import-to-database process . . .
 

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
Another change is the format of the 'epoch_time_end' and 'epoch_time_start' strings. The newer format looks much easier to parse:

Old:
2019-04-29T11:37:10.672Z,2019-04-29T11:37:03.866Z,

New:
2019-05-02 03:55:23.909000-07:00,2019-05-02 03:55:17.707000-07:00,
 

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
Another change is the date time stamps as shown above are no longer in universal time, but local time.
 

tech101

Pulling my weight
Joined
Mar 30, 2015
Messages
209
Reaction score
237
Location
SF BayArea (East Bay)
Hi is there a script or a third party solution to download csv and process every 48 hours so we can retain data say in excel file ?
 

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
Hi is there a script or a third party solution to download csv and process every 48 hours so we can retain data say in excel file ?
I wish I knew. My Windows application mostly automates by a one-click event using SendKeys in Visual Basic to effect the download from the website and import into my database, but wish there were a way to fully automate it and forget it.
 

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
And of course the 'epoch_time_end' and 'start' fields have reverted back to UTC time rather than local time.
 
Top