OpenALPR Tool - Save and Query CSV Exports
- Thread starter Gymratz
- Start date
And just like that seems to have started working again.
I have hits during that time on the openalpr website, but even a manual download doesn't make them appear in viewer.
Ok so I worked it out and the fix was simple. All of the data was there, it was just out of order. Clicking the sort by local time button put everything back into the correct order. Beyond me what I did to suddenly have data appearing out of order. I suspected I had accidentally clicked on one of the other sort by buttons but everything else was in the right order, just that patch of time was missing and in another part of the table. Hey @Gymratz I don't want to steal your thunder here. Would you mind if I set up a new troubleshooting thread to compile the fixes to any issues that pop up in the one place? There's a bunch of good info in the existing threads but I would like to put it into a single post to help others.
Go for it! Just like tech did with a guide - worked out well.
Hey @Gymratz I'm going to be building a new server and migrating my data over, things I plan on doing:
Backup LPR tables on the current server
Install SQL Server on new server and restore LPR tables
Install OpenAPLR, configure the settings and restore the database files
I assume I won't have to compile a new LPR downloader/viewer since the settings are the same, but I will still install Visual Studio for future updates.
Does this sound like I'm missing anything?
Backup LPR tables on the current server
Install SQL Server on new server and restore LPR tables
Install OpenAPLR, configure the settings and restore the database files
I assume I won't have to compile a new LPR downloader/viewer since the settings are the same, but I will still install Visual Studio for future updates.
Does this sound like I'm missing anything?
tech101
Known around here
I am trying to understand I just did a new install. When My plates are being imported it does not show correctly on downloader even though they have been imported.. Not sure why this is?
Looks like a similar glitch to mine.
With a similar effect.
In theory, should be able to use SSMS to back-up on previous server and restore onto new server.
I haven't walked through moving OpenALPR database files - if you do that successfully, posting the steps here for others would be nice.
What I notice in yours is that you have entries for every minute, except for 9:57am - which is when the import likely happened (then the one after they were dupes). Why it doesn't show the entry for 9:57, I'm unsure. My guess, there's an error in the code right before the part that saves the success log - perhaps your archival or alerting had an error, causing it to dump out of that function before it logged the success. The entire "UploadStream" function is wrapped in a try - so any errors would just continue - and the line that saves that success count is at the end of that function.
Do you have other successful imports that are logging correctly?
What's different about them? Did this one contain a license that should have alerted?
tech101
Known around here
Nope not one shows imported whats more interesting is it seems like skips sometimes. I just did re compile downloader same results..
Here is the section that adds the records.
Check above it, I bet it is erroring out.
Considering you're getting the import, it tells me it has to be one of these three items.
So, either the error is with the alerting (which since that is in a new thread, I don't think that's it)
The error is in the archive location (very possible - check that)
Or the error is in the CleanUpDB function - which is also fairly short, you could try running the command directly in SQL and make sure it works.
So... Without being on your system, I feel like the most likely place for the issue is in the saving of the archive. If you have it set to save to a location that doesn't exist, perhaps.
Check above it, I bet it is erroring out.
Considering you're getting the import, it tells me it has to be one of these three items.
So, either the error is with the alerting (which since that is in a new thread, I don't think that's it)
The error is in the archive location (very possible - check that)
Or the error is in the CleanUpDB function - which is also fairly short, you could try running the command directly in SQL and make sure it works.
So... Without being on your system, I feel like the most likely place for the issue is in the saving of the archive. If you have it set to save to a location that doesn't exist, perhaps.
tech101
Known around here
I am going thru it now.. I think I May have found the source not sure yet.. Doing the test waiting for another car folder where it was trying to save was Misspelled. I think that could have caused it not sure.. Waiting for a plate to show up.
tech101
Known around here
tech101
Known around here
Feature request, would it be possible to set plates to ignore? For example FedEx/UPS trucks have decal numbers on the side that OpenALPR pick up on that I would like to just ignore completely rather than have to manually delete it from the database.
DLONG2
Known around here
- May 17, 2017
- 772
- 461
Another commonly captured plate is "UHAUL". I used to try to correct all the wrong plates but gave up, as there's just too many partials and DOT numbers, advertising lettering, etc. I wonder if a new category could be created, such as "Ignore" and then tag the errors as needed, and then filter from view.