LPR database/archival software

[Mark_M]

Is there software to take CSV files, parse them and store in a proper database?
I'm wanting to keep archival of all LPR detections in a year (about 1,000 detections per day).
This is not for live LPR recognition. This is only storing the exported CSV from my LPR camera.

 

[PeteJ]

How to Import a CSV File to a MySQL Database

Effortlessly import CSV files into MySQL: Discover time-saving techniques and learn how to seamlessly work with CSV data in MySQL in our article.

learnsql.com

 

[VideoDad]

Do you have a snapshot image too, or just plate and timestamp?

 

[wittaj]

If it is coming from OpenALPR, we have this (I haven't tried importing CSV from another source):

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

Feb 29, 2020

The LPR_Viewer and LPR_Downloader are free Windows programs designed by @Gymratz & @DLONG2 which allow you to automatically collect, store, view and manage plate data from your IP cameras. It does require a $5 a month subscription to the 'Watchman' plan available at OpenALPR.com.

Also there is another function built into the LPR Viewer which can pull Make, Model, Year, VIN of the vehicle which requires another $25 / month subscription details below As of this Writing (10/25/2021).

Please see Original Gymratz Viewer & Download Post Here.

If. Someone is doing Fresh...

• tech101
• Replies: 173
• Forum: LPR

• 

 

[Mark_M]

Do you have a snapshot image too, or just plate and timestamp?

Just a timestamp. I don't think I need to be saving 1,000 images per day.

Here's the data from the camera's exported CSV files (in order):

Time	Licence Plate	Plate Type	Speed	Direction	Country/Region	Detection Region	Plate Color	Vehicle Type	Vehicle Color
21/01/2025 00:21:41	ABC123	Visitor	29km/h	Approach	-	2	White	Car	Black
21/01/2025 00:39:16	BCD456	Blacklisted	36km/h	Away	-	2	White	Truck	White
21/01/2025 17:52:08	EFG789	Whitelisted	6km/h	Approach	-	2	White	Car	Blue

I've been naughty for the past 10 months.... I have been downloading and adding into one Excel spreadsheet. Excel is handing it fine but I know Excel ain't a database to do this!!
What I have saved historically (and wish to continue) is:

Date	Time	Licence Plate	Plate Type	Speed	Direction	Vehicle Type	Vehicle Color
21/01/2025	00:21:41	ABC123	Visitor	29	Approach	Car	Black
21/01/2025	00:39:16	BCD456	Blacklisted	36	Away	Truck	White
21/01/2025	17:52:08	EFG789	Whitelisted	6	Approach	Car	Blue

---

If it is coming from OpenALPR, we have this (I haven't tried importing CSV from another source):

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

Feb 29, 2020

The LPR_Viewer and LPR_Downloader are free Windows programs designed by @Gymratz & @DLONG2 which allow you to automatically collect, store, view and manage plate data from your IP cameras. It does require a $5 a month subscription to the 'Watchman' plan available at OpenALPR.com.

Also there is another function built into the LPR Viewer which can pull Make, Model, Year, VIN of the vehicle which requires another $25 / month subscription details below As of this Writing (10/25/2021).

Please see Original Gymratz Viewer & Download Post Here.

If. Someone is doing Fresh...

• tech101
• Replies: 173
• Forum: LPR

• 

I love the look of that OpenLPR database!
I'll try and get it running.

 

[trempa92]

What i would do is next:

Check if camera support API for such data. Fetch data, parse it and push to database,

If it doesnt, i suppose since you can download from browser csv, that you can also replicate this request hence you get automated downloading and storing.

I would do either a windows or linux service that does that for me at certain times.

Cheers

 

[Mark_M]

What i would do is next:

Check if camera support API for such data. Fetch data, parse it and push to database,

If it doesnt, i suppose since you can download from browser csv, that you can also replicate this request hence you get automated downloading and storing.

I would do either a windows or linux service that does that for me at certain times.

Cheers

That is effectively what I am doing now.
Getting the CSV file for the past 9 days and adding it to one big excel spreadsheet.
2024 had 238,633 records, 16,554 unique plates.

Here's 2025 so far in Excel.

 

[trempa92]

Ok so, there shouldn't be any problem creating a simple service that parse columns and insert into DB that is consisted of all the columns in csv with addition of ID column which is autoincrement.

Perhaps only thing i would split is, having passages in 1 table and statistics in different table.

So the information pullback is faster

 

[Sevian1s]

A simple way to log and manage all the captured plates is by using Excel Books. It makes it easy to filter, sort, and even run some basic analysis without needing extra software.