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

[tech101]

Also for now you can always RDP into the system if you are in internal network.. And fire up the viewer

 

[Sprite]

Also for now you can always RDP into the system if you are in internal network.. And fire up the viewer

Ooh that's a good idea, thanks!

 

[Gymratz]

Ooh that's a good idea, thanks!

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.

 

[tech101]

Guide has been updated for both New user and users who are updating from an old version. Enjoy !

 

[Sprite]

Guide has been updated for both New user and users who are updating from an old version. Enjoy !

Awesome! I'll give it a try tonight!

 

[tech101]

Awesome! I'll give it a try tonight!

Correcting few things now in the guide.. Just wait for a new version.. Will be updating some minor changes here shortly.

 

[tech101]

Done updated one more time. If someone follow the new guide for anything let me know if something is off..

 

[Sprite]

Done updated one more time. If someone follow the new guide for anything let me know if something is off..

Just updated, everything works! Plate forensics is freaking cool.

The only suggestion I have (if you want to make it more idiot proof) on page 47 when closing out of the yellow window (and the other 3 files) it does ask if I want to save the window. I figured since it was already executed and imported into the SQL database I clicked no. Some people might not be sure if they should save or not.

Would you happen to know how to backup the database to hard drive/cloud?

Thanks for updating the guide

 

[tech101]

I will get that updated.. To not save.. Good point someone might think it is time to save.

 

[tech101]

Done Guide Updated with the note.

 

[tech101]

You can take the database backup by doing the following.




Also you will have to take the backup of the images being stored by openalpr.. Yet even better what you can do is you can also setup Windows backup in control panel for the entire machine.

Below is the guide from Microsoft on backup / restore.

Backup and Restore in Windows - Microsoft Support

Learn how to restore files with backup and restore or file history in Windows.

support.microsoft.com

 

[Mike4030]

Instead of updating my downloader I just started from scratch.I got it working. Set up the viewer from scratch also. Thats working kind of. Im only able to view plates from few days back. I still have all the csv files in the archived folder, and i can manually upload the older ones and then they show up in the viewer. However there are THOUSANDS of files to upload and I can only do one at a time. Is there a way to batch upload all the files?

 

[Gymratz]

Instead of updating my downloader I just started from scratch.I got it working. Set up the viewer from scratch also. Thats working kind of. Im only able to view plates from few days back. I still have all the csv files in the archived folder, and i can manually upload the older ones and then they show up in the viewer. However there are THOUSANDS of files to upload and I can only do one at a time. Is there a way to batch upload all the files?

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 single file, single import.

 

[Mike4030]

I still have the files in the recycle bin. Thanks ill give it a shot.

 

[SyconsciousAu]

Also you will have to take the backup of the images being stored by openalpr..

What is the path for those?

 

[tech101]

What is the path for those?

You can see where its being stored by looking up Under advance settings in openalpr

 

[Sprite]

Updated using your instructions, all working thanks!

 

[Sprite]

Thanks for the guide on how to move the database. I did a dry run the other night on a spare computer I have and it seems to work. I also downloaded a program called SQL Backup Master so I can start doing cloud backups of my database every night.

 

[tech101]

Thanks for the guide on how to move the database. I did a dry run the other night on a spare computer I have and it seems to work. I also downloaded a program called SQL Backup Master so I can start doing cloud backups of my database every night.

Aha, SQL Backup Master is that a free solution ? I will look into it sounds interesting

 

[Sprite]

Aha, SQL Backup Master is that a free solution ? I will look into it sounds interesting

There's a paid solution, but if you use Dropbox it's free or a local backup is also free. I think if you wanted to backup to Google drive you need premium.