Just for purposes of operating the automatic downloads from the openALPR cloud and importing into the database and then viewing the records, just fill out:
"SQLCon" connection string (You would need to have created the LPR database and tables already)
"Webserver" value
"alprUser" value
"alprPassword" value
"csvArchiveLocation" value
Note the way Gymratz's App.config's sample values are typed, surrounded by quotation marks. Just be sure to follow the same syntax. The coding editor will let you know if there's any coding errors.
And leave the rest of the values for later, as they're just alerts you can have sent out later on, once the basic process is working.
And I believe filling out this very handy App.config file is all the programming you need to do within Visual Studio, except:
Fix the DateTimePicker unhandled error in the viewer program (if it still occurs)
Total newbie on all this and have read and reread this thread and debating if I wanna jump into this or keep searching for other alternatives. If @tech101 gets it going easily then maybe I will try too - it just seems like most that have implemented this has some programming background.
I am sure you all have looked at or tried these, but I did a simple search on GitHub and lots of different plate recognizing threads pop up. Maybe some of the code is worked in yours or yours is better - I really do not know.
I am completely naive to this programming stuff, so I don't know if these things are legit or smoke and mirrors, but like this one for example looks like it can take images or video and extract out plates and dump to CSV file: marcbelmont/deep-license-plate-recognition
I believe Gymratz designed a couple or few .sql files. Running these .sql files within the SQL Server management application will automaticaly create the needed database and tables and fields. I believe you might have to provide the name of the database. Once created, the SQL Server will have a 'connection string' to this new database. You would copy that value into the App.config file.
Here's a quick basic overview of the process to acquire, store and view plates. Technically, the LPR Viewer shows the plate images via the webserver, running on the OpenALPR client.
Easy. Right-click on that top-most SQLEXPRESS node, and select 'Properties'. Then you will see the connection string to copy. Once copied you would paste it into the App.config file's SQLcon value.
Yes, Finally I got the String OMG !! I got it using the method from the video now I compiled the EXe will I keep seeing a grey window until the next platE ? or something ?
Isn't that 'SQL Connection Information' box supposed to show your connection string? Try pasting the connection string into that box, and then click Save.
Isn't that 'SQL Connection Information' box supposed to show your connection string? Try pasting the connection string into that box, and then click Save.
Hi Everyone, I wanted to update everyone on this. So As I Stated in my previous post I have ZERO experience in Programming. However I still wanted this software so bad.. Since @Gymratz & @DLONG2 Made it so nice and useful. I cannot thank them enough Specially to @DLONG2 He helped me get thru a lot of issues I was running into most of it was my learning curve as well @DLONG2 Never gave up on me. Thank you thank you thank you !!!
Okay I will be soon putting up a guide on how to go about this from start to finish or at-least what I did to get it to work.. So take it with grain of salt once I have it.
Right now I am working on an active issue which Might break things again tomorrow since I am running into some date range issue on the viewer.. will see Once I have all that sorted out a guide will be coming
I don't think the csv file structure has changed, there is just no vehicle data anymore from openALPR. The csv downloads now show "0" in the columns where that vehicle data had been written.
WOW.. but but I dont think I got the SQL Right..
