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

[anonymoosed]

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()
}

 

[tech101]

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.

 

[anonymoosed]

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.

No dice - Connection string is correct. I started again with the lpr viewer build and had forgot that I got this screen.

 

[tech101]

Have you try installing the .net framework ?

 

[anonymoosed]

.net framework it was targeting installed. Still no dice - same issue as before,

 

[tech101]

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'

 

[anonymoosed]

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'

I see the latest plate in the downloader. I think you're on the something. This is the result of the sql query

 

[tech101]

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



SELECT *
FROM LPR_PlateHits

 

[anonymoosed]

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



SELECT *
FROM LPR_PlateHits

 

[anonymoosed]

which is weird the downloader is working and connection string is correct.

 

[tech101]

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 ?

 

[anonymoosed]

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 ?

from the downloader - Manual upload didnt work. Should that be .\SQLEXPRESS\LPR?

 

[tech101]

Close your downloader.

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

<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?

 

[anonymoosed]

Close your downloader.

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

<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?

no error or anything in event viewer


Not sure on local import but this is from the webserver. Its pulling the files.

 

[wittaj]

no error or anything in event viewer
View attachment 184416

Not sure on local import but this is from the webserver. Its pulling the files.

View attachment 184417

OMFG that car is beat up and looks like running on slicks - doesn't look like any tread on that tire LOL.

 

[anonymoosed]

OMFG that car is beat up and looks like running on slicks - doesn't look like any tread on that tire LOL.

hahahah! I figured yall would enjoy that.

 

[anonymoosed]

I did notice on the lpr downloader when I hit start the timer nothing happens

 

[anonymoosed]

tech101 got me fixed up!

 

[tech101]

Glad it worked out Don't forget to Configure pushalerts.

 

[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.