Search results

  1. G

    New to LPR? Considerations Before You Begin

    For what it's worth, I think there have only been breaking changes two or three times in 18 months. You are correct though, the time could come that a change is made that either can't be fixed (e.g. they prevent the CSV downloads) or don't have time to fix. Good news - if you do want to try it...
  2. G

    New to LPR? Considerations Before You Begin

    My primary cameras are to cover my house - they get other houses, but I'm not going to trigger alerts, etc. When there is a theft in the neighborhood, the first thing I do is look at the LPs that passed that night. Sort by the ones seen the fewest number of times. I then have the exact time to...
  3. G

    OpenALPR Tool - Save and Query CSV Exports

    Seems we've narrowed it down to the datetime format in some way. I think you have two tools to use to fix it, depending on how much time you want to spend. Use the Hammer - bust a hole: Set the download range to be large (e.g. 2 days) every time the ticker goes off. This will be more intensive...
  4. G

    OpenALPR Tool - Save and Query CSV Exports

    Good News: My daily "Restart" of the internals in the downloader is working! You can download manually and import, good. It does the daily catchup, good. Though, that might actually help identify the issue. That "Daily Catchup" is supposed to be a 48 hour lookback. Considering it had "zero...
  5. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    If you kept a copy of the old database, you could export from old platehits table and import into the new one. If you didn't save that - my thought would be too Google for a way to merge all files into one. I'm sure something exists - even if it's just VBA code to execute. Once merged into a...
  6. G

    OpenALPR Tool - Save and Query CSV Exports

    @Sprite and/or @tech101 - how many total "Directions" can cars be going in your setup? The direction is stored simply as a degrees value - I'm thinking the easiest way to do this would be three values. Value_1 -- Description_1 Value_2 -- Description_2 Description_3 If travel_degrees <= Value_1...
  7. G

    OpenALPR Tool - Save and Query CSV Exports

    Always open to suggestions, @Sprite - what I do will be at least partially guided by "Would I use this" -- if I wouldn't use it myself, it will have to be a lost easier/faster to implement to be worth it! Direction The direction is already being saved in the database as...
  8. G

    Any limits on the autocheck.com api?

    That is exactly what the updated version if my app does. Well, slight tweak on the timing - but same effect. Just released it this weekend. Sent from my SM-N975U using Tapatalk
  9. G

    Any limits on the autocheck.com api?

    Currently - hopefully it stays that way!
  10. G

    OpenALPR Tool - Save and Query CSV Exports

    One More Update Automation added to allow automated Forensic backlog entry & daily report. Check the appropriate boxes. Use "Simulate Midnight Tasks" to run ad-hoc update & e-mail to simulate what will happen at Midnight. Before you enable this, please be sure you've: Tested individual...
  11. G

    OpenALPR Tool - Save and Query CSV Exports

    New Updates After you pull down the updates from Git - run the (TWO) SQL file dated today to create a new table (needed for some new functionality / storage). -- New Table && Updated Query Settings Page now had a setting for the Web Server to allow easier remote configuration. The setup will...
  12. G

    Any limits on the autocheck.com api?

    If there is a limit, it's quite high. I'm running a backlog of 10k distinct plates through it right now. Hit nearly 2k and it's still going at a few per second.
  13. G

    OpenALPR Tool - Save and Query CSV Exports

    Tech may do something fancier... Pull in the updated code from GIT. In addition to pulling in the code updates, you'll need to execute the two SQL commands in the "Update Instructions" folder - just open both up in SSMS and execute them - it has updates to a query that will be needed before you...
  14. G

    OpenALPR Tool - Save and Query CSV Exports

    Awesome man - glad all worked well. Some additional updates as well to both Downloader and Viewer. Comments on such added to first post.
  15. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    Heh, that's the only way I get to it. My two different camera systems are boxes hidden away in the house where they couldn't easily be stolen. All remote access.
  16. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    Darn, I take that back. While SQL would be the first stopper (you'd have to allow remote connections, update the config to point to remote server, and likely update "Integrated authentication" to be SQL Authentication and create an account (unless you're on a domain) I think you'll also have to...
  17. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    Record removal is effectively there, it's the "Duplicate" button. I think the viewer would work from any machine, in theory. As long as you have your ALPR Webserver set to accept remote connections, and your SQL server set to accept remote connections. I have no reason to believe it wouldn't...
  18. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    The Auto Downloading (and a couple other small fixes) were uploaded to Git - you can pull down the newest code for LPR_Downloader to get all of that. The LPR_Viewer is currently in progress of getting some quality of life updates. The previous updates (e.g. the time fix) it appears I never...
  19. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    Interesting - another novel use! My mind had gone to the opposite - hiding certain people (known cars) to see only the unknown. I'll look into that another day - done at the PC for tonight. Warning though - it will take slightly more to update. That change will require a change to one or more...
  20. G

    OpenALPR Tool - Save and Query CSV Exports Steps I took To Get Mine Working. ZERO Programming Experience.

    First of all. Thanks for taking on all this documentation and helping people! Second, partial searches work. Use a % as wildcard. Abc123 %bc123 Abc1% %c12% All would find it.
  21. G

    OpenALPR Tool - Save and Query CSV Exports

    Setting to allow Auto Download on Startup = Works Updated login code = Works Updated "Start Auto Downloads" saves the Timer Value Validated by setting to 2 minutes & auto start, closing app, opening, set to 2 minutes and did the 2-day download right away. Of course, this involved changing a...
  22. G

    OpenALPR Tool - Save and Query CSV Exports

    Most settings are remembered (everything on the "Settings" page), but the minutes one I can add in too. It is supposed to auto log you in. I've had issues twice in the past few months where it hasn't for me - not sure if a change to the webpage caused that. Next time it happens, if I'm able to...
  23. G

    OpenALPR Tool - Save and Query CSV Exports

    Honestly, I never really considered there would be a desire for anything other than every minute! Hah - I'll take a look at this.
  24. G

    OpenALPR Tool - Save and Query CSV Exports

    Can you stop / start so it does the full download? See what is picked up? Can you check the ALPR service - are the hits showing up there? I've recently been having issues with the ALPR service not recognizing plates - I've actually got that service restarting daily for the last few weeks -...
  25. G

    OpenALPR Tool - Save and Query CSV Exports

    That would actually be beneficial... I'll look into adding that.
  26. G

    OpenALPR Tool - Save and Query CSV Exports

    I'm quite happy that BI did eventually build it in. I may even give it a try myself at some point. I built the other tool because there was no other option at the time (without paying a very large amount of money). Definitely not an easy project - more of a template for others to work off of...
  27. G

    OpenALPR Tool - Save and Query CSV Exports

    @DLONG2 identified the issues, four fields are no longer sending numeric (float) values, but now send a character. If anyone wants to solve it more elegantly than I have, great. I took the easy way out though. Edit the DB Table and change the four values from Float to nvarchar(50). It...
  28. G

    OpenALPR Tool - Save and Query CSV Exports

    Perfect. That is exactly what the published code is supposed to do (and does for me). This is exactly why this isn't for someone afraid of code. It isn't a refined masterpiece lol! Go in and make edits to work as works for you.
  29. G

    OpenALPR Tool - Save and Query CSV Exports

    @Nyghthawk re: Timeout connecting (post 39) - I believe this is happening because I spin some of that off in another thread, if it was still importing in that thread when you tried to do a second one it would cause an error. Obviously not perfect programming, just not something for me to fix...
  30. G

    OpenALPR Tool - Save and Query CSV Exports

    I don't get video at all, I assumed I either had something setup wrong or it wasn't included in the free service. If you can point me to getting the information from the local DB then maybe adding it into this app won't be a big deal.
Top Bottom