OpenALPR Tool - Save and Query CSV Exports

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Okay, I am on 2.7.102 Now Lets see if this works :D Funny now the LPR is fixed but the downloader seem to have broken grey screen on side..

1583202193086.png
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Anyone else with similar issue after updating the agent .. Even though I made sure.. the agent is running local webserver just fine..

1583205199802.png

Both downloader and viewer seem to have an issue now.

LPR Viewer - 1583205233867.png as well is saying this

Downloader like I reported earlier still grey window but manual upload from old downloaded csv brings back the screen

1583205389703.png
Not sure whats going on..
 

Attachments

b0bthebuilder

Getting the hang of it
Joined
Dec 7, 2017
Messages
101
Reaction score
62
So in addition to over charging me, they then forced me to upgrade Agent; the old one just stopped uploading to cloud, no warning, no notification...

The new Agent initially was rubbish, missing most plates, however after re-booting the PC it is back to catching 100 percent of plates.

They do not make the upgrade process easy (no option or link from within the software... you have to manually download, install, re-enter username and password.

https://deb.openalpr.com/windows-agent/openalpr-agent-latest.exe
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
So in addition to over charging me, they then forced me to upgrade Agent; the old one just stopped uploading to cloud, no warning, no notification...

The new Agent initially was rubbish, missing most plates, however after re-booting the PC it is back to catching 100 percent of plates.

They do not make the upgrade process easy (no option or link from within the software... you have to manually download, install, re-enter username and password.

https://deb.openalpr.com/windows-agent/openalpr-agent-latest.exe
So is the tool working for you the downloaded and viewer for me those broke and they stopped working after the update.

Thank you to @DLONG2 he may have a potential fix for it soon.
 

b0bthebuilder

Getting the hang of it
Joined
Dec 7, 2017
Messages
101
Reaction score
62
So is the tool working for you the downloaded and viewer for me those broke and they stopped working after the update.

Thank you to @DLONG2 he may have a potential fix for it soon.
nope, LPR downloader / viewer not working - was going to re-build it but will wait to see if DLONG2 find a solution
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
nope, LPR downloader / viewer not working - was going to re-build it but will wait to see if DLONG2 find a solution
Hi Thanks for reporting that, Yes I did already try to re-build the app and everything else have not got it to work back again with this update. I really really do love the app Kind of missing it already even though I barely had it working for a day..

Cant wait until @DLONG2 gets it fixed for all of us. Thank you so much @DLONG2 and @Gymratz for looking into this.
 

b0bthebuilder

Getting the hang of it
Joined
Dec 7, 2017
Messages
101
Reaction score
62
Hi Thanks for reporting that, Yes I did already try to re-build the app and everything else have not got it to work back again with this update. I really really do love the app Kind of missing it already even though I barely had it working for a day..

Cant wait until @DLONG2 gets it fixed for all of us. Thank you so much @DLONG2 and @Gymratz for looking into this.
another little annoyance... since being forced to upgrade the Agent, there is now a glitch with the time-stamp when checking plate images via the cloud interface - it is 1 hour out of sync (i.e. check an image that the cloud interface says was taken at 10am today and the "image time stamp" (the actual time the image was captured) is 9am, not 10am)... not helpful.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
another little annoyance... since being forced to upgrade the Agent, there is now a glitch with the time-stamp when checking plate images via the cloud interface - it is 1 hour out of sync (i.e. check an image that the cloud interface says was taken at 10am today and the "image time stamp" (the actual time the image was captured) is 9am, not 10am)... not helpful.

Agree not only OPENALPR is charging they made did a force update with breaking some of the tools which we were using and yes the time stamps.. I wish we could just keep our old agent for openalpr :(
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
First off, I'll try my best to get a fix in place for the Downloader/Viewer, but the C# isn't a language I am comfortable in.

I was concerned hearing about the loss of plate images which were captured in the previous agent, and wrote to them. The reply was:

"Hello,

There should be no change to your ability to view your local data.

You can find the release notes here:
Release Notes — openalpr 2.7.102 documentation

Best, "


So I just finished installing the new client, and can confirm that all previous saved plate images are still being served by the new client. After I can collect some more CSV files I'll see if the date time pattern continues or changes.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Thank you @DLONG2 for looking into this. Interesting that your plates sounds like were still working but not sure if that is after some fix that you are trying in the code for viewer as things are my viewer and downloader both are not working.. I am also on the same version seems like..

Thank you so much for working on a fix anyways. !!
1583389300186.png
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
Well, I mean that within the viewer I can still go back weeks or months, and the local stored images are still present and can be shown, at least in my own version of the viewer. Still waiting on a fresh plate to cross the camera so as to investigate the CSV files.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Well, I mean that within the viewer I can still go back weeks or months, and the local stored images are still present and can be shown, at least in my own version of the viewer. Still waiting on a fresh plate to cross the camera so as to investigate the CSV files.
Nice, That does sound promising. I know for me and another member We lost the data right after update.. like we could see the entries and not the images .. So not sure why we were hit.. Well I am not too worried about old data since I was only running this for a day or two.. Cant wait for your fix to bring this tool back to life. It is really an very very useful tool.

Also does make sense rite now why my viewer is not working. Since there is no data it is probably saying this for todays date.

1583436332085.png

When trying to view plates from earlier since my data was lost.. somehow during the update of the application it cannot find that Image file so hence remote server giving 404...

1583436407166.png

With that said I think You are absolutely right once we have the downloader working again the viewer should just work since it will start finding the data needed for it to work. :D
 
Last edited:

DLONG2

Known around here
Joined
May 17, 2017
Messages
763
Reaction score
454
I confirmed that there was no change in the structure of the database, or anything which obstructed the local server from supplying past images.

tech101 and I have been looking at Gymrat's code. We'd previously looked to fix the date picker bug, and with the new client it was odd that the code ran well on my machine, but was crashing on his. Turns out the database table "LPR_PlateHits" has a field named "camera_id". This field was set as a small integer, which has a limited range of numbers, and tech101 discovered that his camera_id had changed, and exceeded the capacity of that field. He changed it to an integer type, and all is well.

So if you are currently using these LPR apps and if you are experiencing crashes or no downloads then please continue to manually save the CSV files until the fixes can be fully tested and documented.
 

hndymann

n3wb
Joined
Aug 21, 2018
Messages
8
Reaction score
6
Location
Helena AL
I confirmed that there was no change in the structure of the database, or anything which obstructed the local server from supplying past images.

tech101 and I have been looking at Gymrat's code. We'd previously looked to fix the date picker bug, and with the new client it was odd that the code ran well on my machine, but was crashing on his. Turns out the database table "LPR_PlateHits" has a field named "camera_id". This field was set as a small integer, which has a limited range of numbers, and tech101 discovered that his camera_id had changed, and exceeded the capacity of that field. He changed it to an integer type, and all is well.

So if you are currently using these LPR apps and if you are experiencing crashes or no downloads then please continue to manually save the CSV files until the fixes can be fully tested and documented.
Thanks DLONG2, this fixed the problem. Once I changed the data type, the downloader instantly began retrieving plates from the openalpr website.

A simple script can be run in Microsoft SQL Management Studio with 2 lines of code

Open the program, click new query, insert the two lines of code below and press execute.

ALTER TABLE dbo.LPR_Platehits
ALTER COLUMN camera_id int
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
Thanks DLONG2, this fixed the problem. Once I changed the data type, the downloader instantly began retrieving plates from the openalpr website.

A simple script can be run in Microsoft SQL Management Studio with 2 lines of code

Open the program, click new query, insert the two lines of code below and press execute.

ALTER TABLE dbo.LPR_Platehits
ALTER COLUMN camera_id int

Can you verify if your csv are just importing into database and not saving on the drive specified location ?.. or are they saving on the specified location for you ?
 

hndymann

n3wb
Joined
Aug 21, 2018
Messages
8
Reaction score
6
Location
Helena AL
Can you verify if your csv are just importing into database and not saving on the drive specified location ?.. or are they saving on the specified location for you ?
I'm not quite sure I understand. I did nothing to the OpenALPR agent. I went back to look at settings of the agent and I don't have it saving anything locally on my computer other than the plateimages database. The LPR Downloader imports the csv along with the images and the LPR is pulling those images/information.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
I'm not quite sure I understand. I did nothing to the OpenALPR agent. I went back to look at settings of the agent and I don't have it saving anything locally on my computer other than the plateimages database. The LPR Downloader imports the csv along with the images and the LPR is pulling those images/information.
Hi hndymann, So in the downloader there is a section to save CSV to a specified location 1583595431090.png In my case it is D:\OpenALPR\Archived However what is happening is the import into the sql is working just fine, but the location where CSV are suppose to be dumped which is the D Drive folder locaiton is not working.. I do not see any new CSV files there.. I was wondering if you have this option on and do you see those or not ?
 

hndymann

n3wb
Joined
Aug 21, 2018
Messages
8
Reaction score
6
Location
Helena AL
Hi hndymann, So in the downloader there is a section to save CSV to a specified location View attachment 56907 In my case it is D:\OpenALPR\Archived However what is happening is the import into the sql is working just fine, but the location where CSV are suppose to be dumped which is the D Drive folder locaiton is not working.. I do not see any new CSV files there.. I was wondering if you have this option on and do you see those or not ?
I see that now. I never had a need for the csv so I left it blank. Do you need those files?
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,472
Reaction score
2,125
Location
SF BayArea, USA
It be still nice to have those files. But i know what you mean.. We can just backup the database itself even say if we need to move pc or drives..
 
Top