OpenALPR Tool - Save and Query CSV Exports

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
 
System.Net.WebException: The remote server returned an error: (404) Not Found.

1583202306502.png
 
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

  • 1583205365167.png
    1583205365167.png
    22.6 KB · Views: 3
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
 
b0bthebuilder said:
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
Click to expand...
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.
 
tech101 said:
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.
Click to expand...

nope, LPR downloader / viewer not working - was going to re-build it but will wait to see if DLONG2 find a solution
 
  • Like
Reactions: tech101
b0bthebuilder said:
nope, LPR downloader / viewer not working - was going to re-build it but will wait to see if DLONG2 find a solution
Click to expand...

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.
 
tech101 said:
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.
Click to expand...

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.
 
  • Like
Reactions: tech101
b0bthebuilder said:
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.
Click to expand...


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 :(
 
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.
 
  • Like
Reactions: tech101 and b0bthebuilder
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
 
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.
 
  • Like
Reactions: tech101
DLONG2 said:
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.
Click to expand...
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:
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.
 
  • Like
Reactions: tech101
DLONG2 said:
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.
Click to expand...

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
 
  • Like
Reactions: b0bthebuilder and DLONG2
hndymann said:
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
Click to expand...


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 ?
 
tech101 said:
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 ?
Click to expand...
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.
 
  • Like
Reactions: tech101
hndymann said:
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.
Click to expand...
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 ?
 
tech101 said:
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 ?
Click to expand...
I see that now. I never had a need for the csv so I left it blank. Do you need those files?
 
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..
 
You must log in or register to reply here.
Top Bottom