OpenALPR Tool - Save and Query CSV Exports

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.
 
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.
 
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
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.
 
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.
 
Last edited:
  • Like
Reactions: tech101
Stupid Nitpick

in the following
93tibnF.png


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
 
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.
 
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.
 
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


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"
}
 
  • Like
Reactions: DLONG2
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


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.
 
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!
 
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.
 
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.
 
  • Like
Reactions: Nyghthawk
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.
 
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.
 
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.
 
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)
 
  • Like
Reactions: tech101