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

I am not sure what is wrong. LPR downloader is working, I also know the connection string is correct I verified with this script


# Define the connection string
$connectionString = "Data Source=.\SQLEXPRESS;Initial Catalog=LPR;Persist Security Info=True;Integrated Security=true"

# Create a new instance of SqlConnection
$connection = New-Object System.Data.SqlClient.SqlConnection $connectionString

try {
# Attempt to open the connection
$connection.Open()

# If the connection state is Open, the test is successful
if ($connection.State -eq "Open") {
Write-Host "Connection test successful."
}
}
catch {
# Catch and display exception if the connection fails
Write-Error "Connection test failed: $_"
}
# Ensure the connection is closed if it was opened, within the try or catch block as needed
if ($connection.State -eq "Open") {
$connection.Close()
}



1706365273709.png


1706364938850.png
1706364974525.png

1706365011828.png
 
Please ensure that the Viewer Connection String is set to "Data Source=.\SQLEXPRESS;Initial Catalog=LPR;Persist Security Info=True;Integrated Security=true." Additionally, click on "All" Under date range and then Click "search for license plate data" This is to verify if the range of the imported plates are from different day or something.
 
tech101 said:
Please ensure that the Viewer Connection String is set to "Data Source=.\SQLEXPRESS;Initial Catalog=LPR;Persist Security Info=True;Integrated Security=true." Additionally, click on "All" Under date range and then Click "search for license plate data" This is to verify if the range of the imported plates are from different day or something.
Click to expand...
No dice - Connection string is correct. I started again with the lpr viewer build and had forgot that I got this screen.

1706377608996.png
 
Have you try installing the .net framework ?
 
Is downloader still Updating automatically ? In the background ?

Do you know what is the latest plate ? Which came thru ?

If. Yes Can you see that plate in SQL table ?


Or maybe try to run this query and see if any results shows up..

SELECT * FROM LPR_PlateHits WHERE CONVERT(DATE, epoch_time_start) >= '2024-01-27'
 
tech101 said:
Is downloader still Updating automatically ? In the background ?

Do you know what is the latest plate ? Which came thru ?

If. Yes Can you see that plate in SQL table ?


Or maybe try to run this query and see if any results shows up..

SELECT * FROM LPR_PlateHits WHERE CONVERT(DATE, epoch_time_start) >= '2024-01-27'
Click to expand...
I see the latest plate in the downloader. I think you're on the something. This is the result of the sql query

1706379628456.png
 
Aaha, So yeah you have no Entries for those dates.. Lets try this.



SELECT * FROM LPR_PlateHits
 
You have no entries, that is why Blank On the Viewer. Well try to download the CSV from Rekor and than try to upload CSV file manually. Want to see if than any entries shows up. Also does the Downloader has the right database "LPR" ? Also your local Webserver imports imports on the downloader timer says not running can you start that as well ?
 
tech101 said:
You have no entries, that is why Blank On the Viewer. Well try to download the CSV from Rekor and than try to upload CSV file manually. Want to see if than any entries shows up. Also does the Downloader has the right database "LPR" ? Also your local Webserver imports imports on the downloader timer says not running can you start that as well ?
Click to expand...
from the downloader - Manual upload didnt work. Should that be .\SQLEXPRESS\LPR?
1706380545261.png
 
Close your downloader.

Under your build file folder there is a config file. Make sure that is

Code: 
<add key="SqlCon" value="Data Source=.\SQLEXPRESS;Initial Catalog=LPR;Persist Security Info=True;Integrated Security=true" />

For the connection string for downloader. Start the downloader.

Also when you say Manual upload didn't work Any error ? Check also on the Event Viewer if that throws any error there.

Does Local WebServer Import work?
 
tech101 said:
Close your downloader.

Under your build file folder there is a config file. Make sure that is

Code: 
<add key="SqlCon" value="Data Source=.\SQLEXPRESS;Initial Catalog=LPR;Persist Security Info=True;Integrated Security=true" />

For the connection string for downloader. Start the downloader.

Also when you say Manual upload didn't work Any error ? Check also on the Event Viewer if that throws any error there.

Does Local WebServer Import work?
Click to expand...
no error or anything in event viewer


Not sure on local import but this is from the webserver. Its pulling the files.
1706381382071.png
1706381136009.png
 
Glad it worked out Don't forget to Configure pushalerts.
 
  • Like
Reactions: Cape Fear and anonymoosed
Push alerts and NSSM installed. For those reading the issue I was having showed up in event viewer. Two of the field IDs needed to change. PK & Site_ID. They had the wrong field type set in the default run me script.
 
You must log in or register to reply here.
Top Bottom