IP Cam Talk

Welcome to the new IPCT! If you are having an issue logging in, please clear your cookies / cache.

OpenALPR Advice?

nhs128

n3wb
Joined
Jul 8, 2017
Messages
26
Reaction score
7
When you say beanstalked data, are you just referring to the local db file? Or what specifically?
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
105
Reaction score
18
Location
92679
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....
 

DLONG2

Getting comfortable
Joined
May 17, 2017
Messages
392
Reaction score
107
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.
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
105
Reaction score
18
Location
92679
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
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
149
Reaction score
141
Location
Minnesota
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
 

nhs128

n3wb
Joined
Jul 8, 2017
Messages
26
Reaction score
7
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.
 

usaf_pride

Pulling my weight
Joined
Mar 10, 2017
Messages
198
Reaction score
123
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 :)
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
149
Reaction score
141
Location
Minnesota
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
 

nhs128

n3wb
Joined
Jul 8, 2017
Messages
26
Reaction score
7
I may look at this option as well, if anything just to play around. I haven't tried to set it up locally yet.
 

th182

BIT Beta Team
Joined
Sep 11, 2018
Messages
149
Reaction score
141
Location
Minnesota
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
 

nhs128

n3wb
Joined
Jul 8, 2017
Messages
26
Reaction score
7
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.
 

nhs128

n3wb
Joined
Jul 8, 2017
Messages
26
Reaction score
7
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?
 

Gymratz

Getting the hang of it
Joined
Jun 24, 2017
Messages
57
Reaction score
27
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.
 

Fubduck

Young grasshopper
Joined
Jul 10, 2018
Messages
35
Reaction score
21
Location
colorado
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.
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
105
Reaction score
18
Location
92679
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
 

Nyghthawk

Getting the hang of it
Joined
May 29, 2018
Messages
105
Reaction score
18
Location
92679
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.
 

Fubduck

Young grasshopper
Joined
Jul 10, 2018
Messages
35
Reaction score
21
Location
colorado
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.
 
Top