OpenALPR Advice?

When you say beanstalked data, are you just referring to the local db file? Or what specifically?
 
NM, apparently it requires a license key as well, it didn't say that in the application, it says it online.....seems the CSV is the work around for free....
 
Yes, I was in the same boat, having to manually pull the csv file every day, and it became tedious to do. With the help of a whizz here in the forum, now the whole process is automated for the download and import into a SQL database. I am hoping he will get the code shared soon.
 
  • Like
Reactions: nhs128
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
 
  • Like
Reactions: nhs128
NM, apparently it requires a license key as well, it didn't say that in the application, it says it online.....seems the CSV is the work around for free....

The open source version on github does exactly this. Granted it’s all Linux based. It has a script that scrapes the beanstalk data every minute and dumps to an SQL database. That’s what I am running. Then I have a PHP front-end that displays the plates.

I haven’t set up any alerting or anything yet.. that’s what I want to do but haven’t had time to tinker.


Sent from my iPhone using Tapatalk
 
The open source version on github does exactly this. Granted it’s all Linux based. It has a script that scrapes the beanstalk data every minute and dumps to an SQL database. That’s what I am running. Then I have a PHP front-end that displays the plates.

I haven’t set up any alerting or anything yet.. that’s what I want to do but haven’t had time to tinker.


Sent from my iPhone using Tapatalk
Did it come with the php front end or is that something that you wrote? I haven't looked at the open source script yet.
 
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
If you are using sqlite3, check out the .import command :)
 
Did it come with the php front end or is that something that you wrote? I haven't looked at the open source script yet.

If I remember correctly it came with a basic front-end but I rolled my own to incorporate a list of known plates and such. Still very much a work in progress.


Sent from my iPhone using Tapatalk
 
  • Like
Reactions: nhs128
I may look at this option as well, if anything just to play around. I haven't tried to set it up locally yet.
 
I try to avoid cloud-based solutions so the open source option appealed to me. There is a setup guide on here that I believe someone linked to earlier.

Edit: note that you have to use Ubuntu 16.04 as specified in the guide. I did the upgrade to 18 and it broke a lot of things that I couldn’t get working so I wiped the computer and started over a couple weeks ago. Apparently a bunch of components are new/upgraded in 18 and the open source ALPR hasn’t been updated to work with them, at least that’s what my google searching was finding.


Sent from my iPhone using Tapatalk
 
I will give that a try..probably just play with a VM for now and see if I can get it running. I'll look for the guide as well.
 
Yes, I was in the same boat, having to manually pull the csv file every day, and it became tedious to do. With the help of a whizz here in the forum, now the whole process is automated for the download and import into a SQL database. I am hoping he will get the code shared soon.
Any updates on sharing the code for what you all have put together?
 
Soon and very soon . . .
 
  • Like
Reactions: JNDATHP
Sorry guys, delay here was on me. Got busy with life and then came back to some computer issues on the machine I used as my primary machine (the one that actually has monitors!)
New thread created with links to all of the code and hopefully enough instruction that someone familiar with coding can follow.
 
I just use wget on a crontab , and pull the file, and have it with DATE and TIME stamp into a folder, that is where most of my "programing" ends, so I am hoping for the rest of pulling the CSV files into a workable DB and program lol
Could you please share your wget command? I am trying to automate the download of the csv data from openalpr.com.
 
Could you please share your wget command? I am trying to automate the download of the csv data from openalpr.com.
The command has my cookie information in it. But when I get home Monday I can share what I used so you can imitate it
 
I used CLIGET in firefox to get the command, then tweaked it to add the "date/time" at the end, however, now that I am using OpenALPR/LPRDownloader/LPRViewer, etc, I do not download them anymore.
 
I used CLIGET in firefox to get the command, then tweaked it to add the "date/time" at the end, however, now that I am using OpenALPR/LPRDownloader/LPRViewer, etc, I do not download them anymore.
Thanks for the hint about CLIGET. I forgot I had that extension installed. I now have a functioning automated script for downloading the csv files and importing them into my database. I tried to install LPRDownloader/LPRViewer on my laptop before I installed it on my Blue Iris PC but I couldn't get it to work. So, I just rolled my own setup with mysql, php and apache on my media server. This also allows me to view the LPR info from any device with a web browser.
 
  • Like
Reactions: th182
@DLONG2 Have you tried running OpenALPR locally instead of using the cloud service?

The OpenALPR is open source and available on Github:
openalpr/openalpr

There is an older thread where people are running OpenALPR locally: LPR Walk Through / Tutorial

If you run it locally, there are no limits to data retention, plus, you are not sending data to an external cloud service.
Never ever trust any cloud service if you care about your privacy.
It is possible that any cloud service will misuse your data by accident (poor internal processes/management) or intentionally, and without your knowledge.

Example: Ring reportedly gave employees access to customer video feeds

Yes I know this is an old thread but I am thinking of trying to use the source on Github. I am also thinking of purchasing an NVR that is running Linux. Do you happen to know in general if I could run OpenALPR on a NVR running Linux or should I just setup a different machine?