OpenALPR Tool - Save and Query CSV Exports

tech101 · Mar 14, 2022

riluxg said:
I tried fix entry and it changed all my 29,595 plates to the reg i tryed to fix any idea how to get my plate info back

That is interesting not sure how you changed all the records, Hoping you have the sql database backup. You can just restore to the old database backup before you made this change.

The program does take backup daily of the database if its configured when you were setting it up.

Nyghthawk · Mar 23, 2022

Before I pull my hair out trying to figure this out and start from scratch the 3rd time.

Does this work in any way capacity form or whatnot, withOUT having an active/paid subscription to REKTOR licensing, while still using the OLD OpenALPR Agent?

I only ask, because I cannot get the LPR Downloader to "connect" to the webserver (or even start) and the CSV files are obviously not going to be pulled from the cloud without paying.

tech101 · Mar 23, 2022

No this require an active subscription of Rekor as far as I know.

Nyghthawk · Mar 24, 2022

tech101 said:
No this require an active subscription of Rekor as far as I know.

thank you, i know it used to work with the free version that has since gone. I thought it was my setup. thanks for the clarification

tech101 · Mar 24, 2022

Nyghthawk said:
thank you, i know it used to work with the free version that has since gone. I thought it was my setup. thanks for the clarification

Correct, That was a while back when OpenALPR was not taken over by Rekor, However after the acquisition the plan became $5 and now $8 per cam /month.

Nyghthawk · Mar 24, 2022

tech101 said:
Correct, That was a while back when OpenALPR was not taken over by Rekor, However after the acquisition the plan became $5 and now $8 per cam /month.

maybe you can help with this then....got the payment through, cannot START the timer on LPRDownloader for the local webserver imports, keep clicking start, nothing starts

EDIT: seems like just a restart of the agent, worked and allowed connections to the webserver. Think we are golden.

Nyghthawk · Mar 24, 2022

Stupid Nitpick

in the following

The "tab" goes
Vin-> Edit button -> Year -> Make -> Model > Color
When I think it should tab
Vin -> Edit Button -> Year -> Color -> Make -> Model
Left To Right to Down

DLONG2 · Mar 24, 2022

Hi Nyght. Changing the tab order is really easy to do. You would look at the form within the Visual Studio designer. Click on to highlight a control, such as the VIN textbox. Look in the Properties window for the "TabIndex" property, and make it "0" or zero. Then click onto the Year textbox, and again make it's TabIndex property a zero, and do likewise through the other controls. By making each property a zero, it will force the previously selected controls with a "1" and a "2" etc. In other words, it auto-orders the tab stops. Just make sure to do the zero property in reverse order to how you want the tab stop to work, so that the most important control has the 0. Hope this is clear. Then just re-build the EXE and try it out.

DLONG2 · Mar 24, 2022

So in your case, make the Model a 0, then the Make a 0, then the Color a 0, then the Year a 0, then the Edit button a 0, and lastly, the VIN a 0.

This will make the VIN a 0, the Edit Button a 1, the Year a 2, the Color a 3, the Make a 4, the Model a 5.

Nyghthawk · Mar 26, 2022

Also, I am working on manually changing the license plate data (dot com) look up to a different site (that might be free?). It says 0.05 per lookup, but I have done lookups without incurring a charge or adding any payment information.

it seems to just be a bit of a change of the "string' search change to match the original API req, and then ensuring that the returned data matches.

My Question is, is there a way to "test" this without messing anything up?

here is the api string

https://api.licensesearch.org/license-plate-search?plate=[PLATEDATA]&state=[2LETTERSTATE]&format=json&request_type=web&access_token=[APIKEYGOESHERE]

I will EDIT this later with some of the "code" edit to ensure it still works. I am unsure right now of some of the 'return string errors' since I am unsure the strings are the same, but the look up can be the same.

Error message =
{
"status": "error",
"message": "No data found"
}

wittaj · Mar 26, 2022

Nyghthawk said:
Also, I am working on manually changing the license plate data (dot com) look up to a different site (that might be free?). It says 0.05 per lookup, but I have done lookups without incurring a charge or adding any payment information.

it seems to just be a bit of a change of the "string' search change to match the original API req, and then ensuring that the returned data matches.

My Question is, is there a way to "test" this without messing anything up?

here is the api string

https://api.licensesearch.org/license-plate-search?plate=[PLATEDATA]&state=[2LETTERSTATE]&format=json&request_type=web&access_token=[APIKEYGOESHERE]

I will EDIT this later with some of the "code" edit to ensure it still works. I am unsure right now of some of the 'return string errors' since I am unsure the strings are the same, but the look up can be the same.

Originally we had a free site, but then they started to charge. we scoured for another free site and couldn't find one, and the one we settled on was the cheapest out there.

But that doesn't mean that a new one didn't pop up. Looking at the one you provided, it appears they offer a trial so you might be on a trial right now that will then charge 5 cents per lookup, which will add up quick

Let us do some more digging on that one.

As far as testing it, yeah go in and change it. But first make a backup of your DB in case it goes south. If it goes south, just rebuild the original solution.

Nyghthawk · Mar 26, 2022

wittaj said:
Originally we had a free site, but then they started to charge. we scoured for another free site and couldn't find one, and the one we settled on was the cheapest out there.

But that doesn't mean that a new one didn't pop up. Looking at the one you provided, it appears they offer a trial so you might be on a trial right now that will then charge 5 cents per lookup, which will add up quick

Let us do some more digging on that one.

As far as testing it, yeah go in and change it. But first make a backup of your DB in case it goes south. If it goes south, just rebuild the original solution.

Thanks maybe I should find out if I am on a trial before doing all this work lol!

wittaj · Mar 26, 2022

Please let us know specifics - I am looking at it and I do not see a price. It just mentions a free trial - did it specify a length of time or # of lookups as part of the trial?

It would be great if you found a new site that does offer this free. But I suspect once their API gets hit at the frequency this tool would hit it, they would shut it down quick.

That is what has happened to us the past two search engines LOL. The first engine lasted over a year. The second one was like a week LOL.

DLONG2 · Mar 26, 2022

Looking briefly at the licensesearch.org website, what I do notice is that on the account signup page, one must first check the box that you have read and agree to the terms and conditions, but when you click on the link for the terms and conditions, one first needs an account in order to then read the terms and conditions. This sort of shrouded transparency is a red flag.

LicencePlateData.com, which the viewer currently uses, allows for 5,000 look-ups per month, which at 5 cents per lookup would be $250.00 while they only charge $16.00 a month. My street doesn't get near 5,000 look-ups per month. I might get 10 to 15 look-ups per day, which would cost me $15 to $22 a month with this other service.

Still, it's great that the LPR hobbyist community is active in looking for good resources.

Nyghthawk · Mar 26, 2022

So I haven't entered any payment information, so if it does start incurring, no way to charge, will just return errors.

Also used fake information to signup for it, with fake/spam email as well so we shall see. Trying to lookup where they pull their data from and pull it into the json files.I found quite a few websites that are 100% free, but do NOT have an API. So I am trying to see if we can query those sites, and return the data to json, and possibly not have to use an API string search and just use a separate program (possibly in python) to just pull this data when our LPR viewer queries, or just have it batch data overnight.

wittaj · Mar 26, 2022

Yeah, we tried the data scrapping from a website like that and didn't get very far, but maybe you have the skill set to do so? We would love to get to a free solution again LOL.

Yeah, as long as all you entered was fake, then I guess you will find out quickly if they block it after a certain period.

Nyghthawk · Mar 26, 2022

wittaj said:
Yeah, we tried the data scrapping from a website like that and didn't get very far, but maybe you have the skill set to do so? We would love to get to a free solution again LOL.

Yeah, as long as all you entered was fake, then I guess you will find out quickly if they block it after a certain period.

came fast just by testing out the strings to get the code working
Message: Your account balance is insufficient for this request.

wittaj · Mar 26, 2022

Well bummer. Was worth a try!

Nyghthawk · Mar 26, 2022

So I am currently in process of doing something with these two items.

www.findbyplate.com

which seems to have unlimited free HTML lookups

and was able to use this program (free) parsehub.com to extract the data to a json file/status. (verified)

However, so far the PARSEHUB program only looks at specific webpages, not sure how to get it to dynamically "change" while still looking for the same data. I believe I can create "templates" so that when it does look up a different site, it can pull the same "data".

PARSEHUB also has an API request to utilize your projects that you create against websites. so I am seeing if there is a way to apply the API to the project site with "input" to pull back the License plate data, dynamically, and upon request.

All Free so far. (I think 200/day requests)

wittaj · Mar 26, 2022

Sweet! I hope you can make it work!

Search

OpenALPR Tool - Save and Query CSV Exports

tech101

Known around here

Nyghthawk

Getting the hang of it

tech101

Known around here

Nyghthawk

Getting the hang of it

tech101

Known around here

Nyghthawk

Getting the hang of it

Nyghthawk

Getting the hang of it

DLONG2

Known around here

DLONG2

Known around here

Nyghthawk

Getting the hang of it

wittaj

Nyghthawk

Getting the hang of it

wittaj

DLONG2

Known around here

Nyghthawk

Getting the hang of it

wittaj

Nyghthawk

Getting the hang of it

wittaj

Nyghthawk

Getting the hang of it

wittaj