I, too, see where the data coming from the OpenALPR had changed around 8 AM PST today. What I see is there are some fields with a value of "-" instead of "0".
Okay, Figured it out why it was not saving the CSV. It turns out It is absolute necessary to have the backslash at the end as well.. The moment I added that It started saving the file to the following location.. All should be good from here on.. Thank you !!
While I work on getting this working, if I continue to manually download the CSV file from the open alpr website and save to my computer will I then be able to import those files into the downloader?
While I work on getting this working, if I continue to manually download the CSV file from the open alpr website and save to my computer will I then be able to import those files into the downloader?
The Sql Database has to be configured/running correctly once it is it should able to download automatically and import. You can try to manually upload file also
But sql like I said has to be configured/running correctly to begin with..
Okay its importing now. Thank you.
Now I'm working on the viewer.
I edited the data source to SQLEXPRESS. Then when I double click on The dashboard, the window in the bottom right corner where I need to fix the date doesn't show up.
Okay its importing now. Thank you.
Now I'm working on the viewer.
I edited the data source to SQLEXPRESS. Then when I double click on The dashboard, the window in the bottom right corner where I need to fix the date doesn't show up.
Not sure sounds like to me you are referring to the dashboard when editing the code. If, yes then when you click on those dates once. it should show up to edit..
Interesting - another novel use! My mind had gone to the opposite - hiding certain people (known cars) to see only the unknown.
I'll look into that another day - done at the PC for tonight.
Warning though - it will take slightly more to update. That change will require a change to one or more SQL Queries as well. I've also made some other minor changes to the viewer for my needs over the past year that may or may not have impacted the Tables and/or Stored Procedures.
I'll circle back some other night - thanks for the ideas on this!
I got the downloader working and the viewer working. Thank you Tech101 for the guide and helping.
Question with the viewer. In the window under "search license plate data" it shows date and time. But mine is off by 3 hrs.
Anything I did wrong?
I got the downloader working and the viewer working. Thank you Tech101 for the guide and helping.
Question with the viewer. In the window under "search license plate data" it shows date and time. But mine is off by 3 hrs.View attachment 72664
Anything I did wrong?
This was the instructions I think Gymratz provided me to fix mine a while ago.
MAKE SURE BEFORE YOU TRY Save Your Current Code Somewhere else so that way if it does not work you can still.. Fall back.. Until we figure it out. I think this worked for me..
Try this..
Ok, this is in code.
Search for this in dashboard.cs: Exec sp_LPR_AllPlates
You will find it in two places.
First place is private void Load_Plates() near the top. This one is correct, it passes in more items.
Lower down there is Set_Plate_Details -- in this one, I call the same Stored Procedure, but I fail to set all of the same values.
Update this lower section to ensure you're passing in @CurrentOffset. (I just went ahead and passed in everything to be the same - made it easier - couple of copy/paste).
Now looks like this.
I believe that will do it for you.
On other note Wow you just got it to work and have 46 thousand plates record it on a highway lol
Lol, yea I got about 6-7 thousands plates a day. Busy road.
The png pictures you posted aren't showing.
Since i'm changing the code I might as well change the downloader to "auto start downloads" also.
Do you have the code you changed to do that?
The Auto Downloading (and a couple other small fixes) were uploaded to Git - you can pull down the newest code for LPR_Downloader to get all of that.
The LPR_Viewer is currently in progress of getting some quality of life updates. The previous updates (e.g. the time fix) it appears I never uploaded to Git - but will be included in the next upload along with everything else.
Lol, yea I got about 6-7 thousands plates a day. Busy road.
The png pictures you posted aren't showing.
Since i'm changing the code I might as well change the downloader to "auto start downloads" also.
Do you have the code you changed to do that?
I am not sure why The images not showing it is definitely visible anyways. I know there is some work in progress for viewer you may wanna wait for it. .since it will be super cool with like Gymratz said some quality stuff..
On other note for plate records, For sure that seems like a very busy road lol I only have like 60k plates and I been doing since March.. Anyhow cool though. Let us know how the performance become since your data is going to be huge. Also your plate images data is gonna grow really quick as well. So keep an eye on the Gb you set for that on side.
The Auto Downloading (and a couple other small fixes) were uploaded to Git - you can pull down the newest code for LPR_Downloader to get all of that.
The LPR_Viewer is currently in progress of getting some quality of life updates. The previous updates (e.g. the time fix) it appears I never uploaded to Git - but will be included in the next upload along with everything else.
Record removal is effectively there, it's the "Duplicate" button.
I think the viewer would work from any machine, in theory. As long as you have your ALPR Webserver set to accept remote connections, and your SQL server set to accept remote connections. I have no reason to believe it wouldn't work... Will test at some point. Working on smoothing out issues in current update.
Darn, I take that back.
While SQL would be the first stopper (you'd have to allow remote connections, update the config to point to remote server, and likely update "Integrated authentication" to be SQL Authentication and create an account (unless you're on a domain)
I think you'll also have to update ALPR webserver to allow remote connections (not sure if that is allowed by default).
But, also my code to do the images has the webserver hardcoded - so I'd have to get that as a variable.
Not on the list for things right now. Even if I updated that to be a variable - it would take someone a fair amount of knowledge to do the first portions. If the person can figure out the first portions, they could also find/replace 127.0.0.1 with the remote address in code. I will keep this in mind though for the future / might think of another way to make the connection easy without the manual effort.
