Do you know has anyone written directions how to use CodeProject.AI to create this SQL database solution?
There are many ways to do this and it all depends on what you want to achieve and whether it's all in the same environment. For example, I have created a PHP API that BlueIris calls with the plate dats and a Base64 encoded image. The API then writes the plate data to the database and compresses and resizes the image for storage. I them have a dashboard system where I can search for plates etc. This works best for me, but others have gone a different route and grabbed the plates directly from BI, as their solution was on the same machine (or even network)... mine is on the internet.
Thank you, my main goal would be to create a local database on the same machine that I have BI and CPAI. I'm currently not running HA but can setup if it is needed as part of the solution. I would like to be able to query and run different SQL's to find how many times or timeframe a specific plate might have been picked up on the camera. Looking at the screenshot from Vettester it seems those columns along with the image he is showing is the same thing I would want to capture in my database. Saying all that I am open to do it online or anyother solution if that seems a bit easier.
The easiest way of doing that is just to log a row to the datbase every time you see a plate, then you can query the database based on date/times to give you the counts. I have a "risk factor" on my solution based on how many times the plate has been seen in the past month, as well as an alerting system based on known plates. Hot really sure why HA would be needed but I guess you could use it if you weren't familiar with coding.
I'm using @Alan_F 's node-red dashboard.
Thank you I will give that a try.I'm using @Alan_F 's node-red dashboard.
Node Red Dashboard for Blue Iris ALPR
@Alan_F I am confused here; Create a separate folder to store the images where ALPR detected a tag (outside Blue Iris) The original images are deleted when Blue Iris deletes the clip/alert. Copying them elsewhere allows you to keep them as long as you want This folder should be local to the...ipcamtalk.com
Post a screenshot of you camera's AI settings.
DO you have DayPlate and NightPlate in Mark as vehicle?
I think the issue you are having is you have spaces after each comma. Remove all the spaces after the commas in all the settings.
Thank you. I will try that.
Out if interest, how many pigs do you see on your ALPR cam? Or are you training it to spot Police cars, lol!?
On the same token, I have been going thru all the posts and I can not find a place that would describe how to use immediate action or alerts with MQTT, could anyone show me how to do that? Do you need to put your plate number in the box or will trigger for every plate found?
FWIW, the world of programming is very unforgiving of such mistakes. There are many languages that don't care much about "white space", but generally when copy/pasting modern code/settings from online, white space is very important!
