OpenALPR Tool - Save and Query CSV Exports

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
Okay, Figured it out why it was not saving the CSV. It turns out It is absolute necessary to have the backslash at the end as well.. The moment I added that It started saving the file to the following location..

1584033830513.png

All should be good from here on.. Thank you !!
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
HI Everyone ! So I really love the program which @Gymratz & @DLONG2 has given us. I really am thankful to both specially for making it work so well. I wanted to kind of give something back to community so currently working with another programmer I hired to add print functionality for running reports on individual plates so it can give us the history.

I will be sharing the code here soon so you guys can use and maybe even make it even better in future or add more to it.. Let me share it with @DLONG2 and @Gymratz for testing and once we make sure it works will be sharing it here..

This is what it looks like.

1584318893607.png


So basically choose your date range and search the plate you are after. Select a custom logo of your choice, put the name who is printing. and hit print.. :D

You will then get a report which will look like this..

In the pic the logo is lttle out of place but it be fixed soon :D it is basically side by side.
1584318642628.png
 

djmt99

Young grasshopper
Joined
Oct 13, 2015
Messages
82
Reaction score
12
Fair warning: This is my first go at with coding. If I need to edit something, somewhere, somehow, please point me to which program I should be using, and how to go about. :thumb:

What do the values of imported/skipped in the downloader show? Plates? At least 100 plates have gone into ALPR since I've finished this. Is something wrong?

Might that explain why I have no data in the viewer?

Lastly, I'm assuming the downloader has to be running at all times for this all to work? If I put it in my startup folder, is there a way to start auto downloads?
 

Attachments

djmt99

Young grasshopper
Joined
Oct 13, 2015
Messages
82
Reaction score
12
I just went through all the steps again (Thanks @tech101), deleting last night's LPR database and starting new... Still having issues.

I have changed the code to show "int".

See screenshots.

If anyone would like to assist and fix through Teamviewer, I wouldn't mind throwing a few bucks for the learning process!

alpr421.PNG
alpr422.PNG
alpr423.PNG
 

djmt99

Young grasshopper
Joined
Oct 13, 2015
Messages
82
Reaction score
12
Ok, two things.
1. I screwed up something right before pushing the code!
if (Constants.pushToken != "" && Constants.pushUser != "")
{
Alert_Push("Watched Plate", "You may be interested in this plate that just went by the house...", "Blah");
}

(Add the part in red, comma "Blah") to get rid of the compiler error.

Because of the != "" -- if you leave the config section blank, it won't try to push, so you don't need an account. The compiler error is just a mistake I made. I'll fix and push to git for the next people...
Was this fixed in the latest downloads from Git? Or do I need to do this now? If the latter, where should I be looking?

I'm asking because I'm still having issues with this. I've repeated the install/build process two times on one machine, and a fresh install on a different machine. I'm getting errors when opening the viewer, and grey boxes, no tables.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
Code:
Version=1

EventType=CLR20r3

EventTime=132319044360212504

ReportType=2

Consent=1

UploadTime=132319044380685429

ReportStatus=268435456

ReportIdentifier=064dd9df-8b7c-41cd-bec4-9c51e09e4928

IntegratorReportIdentifier=51d42033-8561-45f5-9be1-133c976ddbca

Wow64Host=34404

Wow64Guest=332

NsAppName=LPR_Downloader.exe

OriginalFilename=LPR_Downloader.exe

AppSessionGuid=00003794-0001-005b-5e59-89b98915d601

TargetAppId=W:0006f089f851ed8a924da69e7f70a0517c6600000000!0000fd3261d2efa4ab744fc9195fa1643074c48436e2!LPR_Downloader.exe

TargetAppVer=2056/06/11:01:39:48!0!LPR_Downloader.exe

BootId=4294967295

ServiceSplit=1994457088

TargetAsId=306

IsFatal=1

EtwNonCollectReason=4

Response.BucketId=72ccdeeabc2a6f4530e1d1e3fb63b8fe

Response.BucketTable=5

Response.LegacyBucketId=1216484151472142590

Response.type=4

Sig[0].Name=Problem Signature 01

Sig[0].Value=LPR_Downloader.exe

Sig[1].Name=Problem Signature 02

Sig[1].Value=1.0.0.0

Sig[2].Name=Problem Signature 03

Sig[2].Value=a298a6e4

Sig[3].Name=Problem Signature 04

Sig[3].Value=System.Data

Sig[4].Name=Problem Signature 05

Sig[4].Value=4.8.4121.0

Sig[5].Name=Problem Signature 06

Sig[5].Value=5deacf0a

Sig[6].Name=Problem Signature 07

Sig[6].Value=2a2b

Sig[7].Name=Problem Signature 08

Sig[7].Value=0

Sig[8].Name=Problem Signature 09

Sig[8].Value=System.InvalidOperationException

DynamicSig[1].Name=OS Version

DynamicSig[1].Value=10.0.18363.2.0.0.256.48

DynamicSig[2].Name=Locale ID

DynamicSig[2].Value=1033

DynamicSig[22].Name=Additional Information 1

DynamicSig[22].Value=2beb

DynamicSig[23].Name=Additional Information 2

DynamicSig[23].Value=2beba6fb4680d73a8c78ca7c24ccdb46

DynamicSig[24].Name=Additional Information 3

DynamicSig[24].Value=9e66

DynamicSig[25].Name=Additional Information 4

DynamicSig[25].Value=9e66d0b07564bd5b934c1974771457cc

UI[2]=C:\Users\hiddenuser\Desktop\bin\LPR_Downloader.exe

LoadedModule[0]=C:\Users\hiddenuser\Desktop\bin\LPR_Downloader.exe

LoadedModule[1]=C:\WINDOWS\SYSTEM32\ntdll.dll

LoadedModule[2]=C:\WINDOWS\SYSTEM32\MSCOREE.DLL

LoadedModule[3]=C:\WINDOWS\System32\KERNEL32.dll

LoadedModule[4]=C:\WINDOWS\System32\KERNELBASE.dll

LoadedModule[5]=C:\WINDOWS\System32\ADVAPI32.dll

LoadedModule[6]=C:\WINDOWS\System32\msvcrt.dll

LoadedModule[7]=C:\WINDOWS\System32\sechost.dll

LoadedModule[8]=C:\WINDOWS\System32\RPCRT4.dll

LoadedModule[9]=C:\WINDOWS\System32\SspiCli.dll

LoadedModule[10]=C:\WINDOWS\System32\CRYPTBASE.dll

LoadedModule[11]=C:\WINDOWS\System32\bcryptPrimitives.dll

LoadedModule[12]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscoreei.dll

LoadedModule[13]=C:\WINDOWS\System32\SHLWAPI.dll

LoadedModule[14]=C:\WINDOWS\System32\combase.dll

LoadedModule[15]=C:\WINDOWS\System32\ucrtbase.dll

LoadedModule[16]=C:\WINDOWS\System32\GDI32.dll

LoadedModule[17]=C:\WINDOWS\System32\win32u.dll

LoadedModule[18]=C:\WINDOWS\System32\gdi32full.dll

LoadedModule[19]=C:\WINDOWS\System32\msvcp_win.dll

LoadedModule[20]=C:\WINDOWS\System32\USER32.dll

LoadedModule[21]=C:\WINDOWS\System32\IMM32.DLL

LoadedModule[22]=C:\WINDOWS\System32\kernel.appcore.dll

LoadedModule[23]=C:\WINDOWS\SYSTEM32\VERSION.dll

LoadedModule[24]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\clr.dll

LoadedModule[25]=C:\WINDOWS\SYSTEM32\ucrtbase_clr0400.dll

LoadedModule[26]=C:\WINDOWS\SYSTEM32\VCRUNTIME140_CLR0400.dll

LoadedModule[27]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\mscorlib\46c6217a2d77a20d9fff301af2e1d67e\mscorlib.ni.dll

LoadedModule[28]=C:\WINDOWS\System32\ole32.dll

LoadedModule[29]=C:\WINDOWS\system32\uxtheme.dll

LoadedModule[30]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\clrjit.dll

LoadedModule[31]=C:\WINDOWS\System32\OLEAUT32.dll

LoadedModule[32]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System\f3efcabd0ee45af4d0d9146029f0f860\System.ni.dll

LoadedModule[33]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Drawing\ab90ddf3011305b543d184172990f13c\System.Drawing.ni.dll

LoadedModule[34]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Windows.Forms\3ec32c6321c16870e73110ebc87cfdaf\System.Windows.Forms.ni.dll

LoadedModule[35]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Core\f364e4396f858010442117cd31789bd4\System.Core.ni.dll

LoadedModule[36]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Data\50c74485f35dbafacf245bb2d6b3d01c\System.Data.ni.dll

LoadedModule[37]=C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll

LoadedModule[38]=C:\WINDOWS\System32\WS2_32.dll

LoadedModule[39]=C:\WINDOWS\System32\CRYPT32.dll

LoadedModule[40]=C:\WINDOWS\System32\MSASN1.dll

LoadedModule[41]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Configuration\9398c2f6376963ae3affb4ff4239440f\System.Configuration.ni.dll

LoadedModule[42]=C:\WINDOWS\System32\shell32.dll

LoadedModule[43]=C:\WINDOWS\System32\cfgmgr32.dll

LoadedModule[44]=C:\WINDOWS\System32\shcore.dll

LoadedModule[45]=C:\WINDOWS\System32\windows.storage.dll

LoadedModule[46]=C:\WINDOWS\System32\profapi.dll

LoadedModule[47]=C:\WINDOWS\System32\powrprof.dll

LoadedModule[48]=C:\WINDOWS\System32\UMPDC.dll

LoadedModule[49]=C:\WINDOWS\System32\cryptsp.dll

LoadedModule[50]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Xml\5407bfb5d52030da64364c70b536739b\System.Xml.ni.dll

LoadedModule[51]=C:\WINDOWS\System32\bcrypt.dll

LoadedModule[52]=C:\WINDOWS\system32\rsaenh.dll

LoadedModule[53]=C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_5.82.18362.778_none_71d70b7d5ae4146f\comctl32.dll

LoadedModule[54]=C:\WINDOWS\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.18362.778_none_5f5ee11d821bf28c\gdiplus.dll

LoadedModule[55]=C:\WINDOWS\SYSTEM32\DWrite.dll

LoadedModule[56]=C:\WINDOWS\System32\MSCTF.dll

LoadedModule[57]=C:\WINDOWS\System32\clbcatq.dll

LoadedModule[58]=C:\Windows\System32\ieframe.dll

LoadedModule[59]=C:\Windows\System32\USERENV.dll

LoadedModule[60]=C:\Windows\System32\NETAPI32.dll

LoadedModule[61]=C:\Windows\System32\iertutil.dll

LoadedModule[62]=C:\Windows\System32\WINHTTP.dll

LoadedModule[63]=C:\Windows\System32\WKSCLI.DLL

LoadedModule[64]=C:\Windows\System32\NETUTILS.DLL

LoadedModule[65]=C:\WINDOWS\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.18362.778_none_2e73ee38278978be\comctl32.dll

LoadedModule[66]=C:\WINDOWS\SYSTEM32\msIso.dll

LoadedModule[67]=C:\WINDOWS\SYSTEM32\sxs.dll

LoadedModule[68]=C:\WINDOWS\system32\dataexchange.dll

LoadedModule[69]=C:\WINDOWS\system32\d3d11.dll

LoadedModule[70]=C:\WINDOWS\system32\dcomp.dll

LoadedModule[71]=C:\WINDOWS\system32\dxgi.dll

LoadedModule[72]=C:\WINDOWS\SYSTEM32\dxcore.dll

LoadedModule[73]=C:\WINDOWS\system32\twinapi.appcore.dll

LoadedModule[74]=C:\WINDOWS\system32\RMCLIENT.dll

LoadedModule[75]=C:\WINDOWS\SYSTEM32\PROPSYS.dll

LoadedModule[76]=C:\WINDOWS\SYSTEM32\urlmon.dll

LoadedModule[77]=C:\WINDOWS\SYSTEM32\WININET.dll

LoadedModule[78]=C:\WINDOWS\SYSTEM32\ondemandconnroutehelper.dll

LoadedModule[79]=C:\WINDOWS\system32\mswsock.dll

LoadedModule[80]=C:\WINDOWS\SYSTEM32\IPHLPAPI.DLL

LoadedModule[81]=C:\WINDOWS\System32\NSI.dll

LoadedModule[82]=C:\WINDOWS\SYSTEM32\WINNSI.DLL

LoadedModule[83]=C:\WINDOWS\SYSTEM32\MSHTML.dll

LoadedModule[84]=C:\WINDOWS\SYSTEM32\DNSAPI.dll

LoadedModule[85]=C:\Windows\System32\rasadhlp.dll

LoadedModule[86]=C:\WINDOWS\System32\TextInputFramework.dll

LoadedModule[87]=C:\WINDOWS\System32\CoreMessaging.dll

LoadedModule[88]=C:\WINDOWS\System32\CoreUIComponents.dll

LoadedModule[89]=C:\WINDOWS\SYSTEM32\wintypes.dll

LoadedModule[90]=C:\WINDOWS\SYSTEM32\ntmarta.dll

LoadedModule[91]=C:\WINDOWS\System32\fwpuclnt.dll

LoadedModule[92]=C:\WINDOWS\System32\schannel.dll

LoadedModule[93]=C:\WINDOWS\SYSTEM32\mskeyprotect.dll

LoadedModule[94]=C:\WINDOWS\SYSTEM32\ncrypt.dll

LoadedModule[95]=C:\WINDOWS\SYSTEM32\NTASN1.dll

LoadedModule[96]=C:\WINDOWS\System32\DPAPI.DLL

LoadedModule[97]=C:\WINDOWS\System32\WINTRUST.dll

LoadedModule[98]=C:\Windows\System32\cryptnet.dll

LoadedModule[99]=C:\WINDOWS\system32\ncryptsslp.dll

LoadedModule[100]=C:\WINDOWS\SYSTEM32\srpapi.dll

LoadedModule[101]=C:\WINDOWS\SYSTEM32\Secur32.dll

LoadedModule[102]=C:\WINDOWS\SYSTEM32\MLANG.dll

LoadedModule[103]=C:\WINDOWS\SYSTEM32\WLDP.DLL

LoadedModule[104]=C:\WINDOWS\SYSTEM32\ieapfltr.dll

LoadedModule[105]=C:\Windows\System32\jscript9.dll

LoadedModule[106]=C:\WINDOWS\system32\msimtf.dll

LoadedModule[107]=C:\WINDOWS\SYSTEM32\d2d1.dll

LoadedModule[108]=C:\WINDOWS\SYSTEM32\d3d10warp.dll

LoadedModule[109]=C:\WINDOWS\system32\windowscodecs.dll

LoadedModule[110]=C:\WINDOWS\SYSTEM32\T2EMBED.DLL

LoadedModule[111]=C:\WINDOWS\SYSTEM32\XmlLite.dll

LoadedModule[112]=C:\WINDOWS\System32\psapi.dll

LoadedModule[113]=C:\WINDOWS\SYSTEM32\rasapi32.dll

LoadedModule[114]=C:\WINDOWS\SYSTEM32\rasman.dll

LoadedModule[115]=C:\WINDOWS\SYSTEM32\rtutils.dll

LoadedModule[116]=C:\WINDOWS\SYSTEM32\dhcpcsvc6.DLL

LoadedModule[117]=C:\WINDOWS\SYSTEM32\dhcpcsvc.DLL

LoadedModule[118]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Numerics\7f278bb3b502c72d621e72a188eb31b5\System.Numerics.ni.dll

LoadedModule[119]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Transactions\a97d6abe519d13994589c21240226416\System.Transactions.ni.dll

LoadedModule[120]=C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll

LoadedModule[121]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Ente96d83b35#\f9a0b047213e27ffdc756bc8538be655\System.EnterpriseServices.ni.dll

LoadedModule[122]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Ente96d83b35#\f9a0b047213e27ffdc756bc8538be655\System.EnterpriseServices.Wrapper.dll

LoadedModule[123]=C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll

LoadedModule[124]=C:\WINDOWS\system32\security.dll

LoadedModule[125]=C:\WINDOWS\System32\Kerberos.DLL

LoadedModule[126]=C:\WINDOWS\System32\msv1_0.DLL

LoadedModule[127]=C:\WINDOWS\SYSTEM32\NtlmShared.dll

LoadedModule[128]=C:\WINDOWS\SYSTEM32\cryptdll.dll

LoadedModule[129]=C:\WINDOWS\system32\ntdsapi.dll

LoadedModule[130]=C:\WINDOWS\SYSTEM32\DSPARSE.DLL

LoadedModule[131]=C:\Windows\System32\LOGONCLI.DLL

LoadedModule[132]=C:\WINDOWS\assembly\NativeImages_v4.0.30319_32\System.Runt19c51595#\f7801247c092432de125bc74cce6d51e\System.Runtime.Caching.ni.dll

LoadedModule[133]=C:\WINDOWS\SYSTEM32\WINMM.dll

LoadedModule[134]=C:\WINDOWS\SYSTEM32\winmmbase.dll

LoadedModule[135]=C:\Windows\System32\webio.dll

LoadedModule[136]=C:\WINDOWS\System32\UIAnimation.dll

LoadedModule[137]=C:\Windows\Microsoft.NET\Framework\v4.0.30319\diasymreader.dll

State[0].Key=Transport.DoneStage1

State[0].Value=1

OsInfo[0].Key=vermaj

OsInfo[0].Value=10

OsInfo[1].Key=vermin

OsInfo[1].Value=0

OsInfo[2].Key=verbld

OsInfo[2].Value=18363

OsInfo[3].Key=ubr

OsInfo[3].Value=778

OsInfo[4].Key=versp

OsInfo[4].Value=0

OsInfo[5].Key=arch

OsInfo[5].Value=9

OsInfo[6].Key=lcid

OsInfo[6].Value=1033

OsInfo[7].Key=geoid

OsInfo[7].Value=244

OsInfo[8].Key=sku

OsInfo[8].Value=48

OsInfo[9].Key=domain

OsInfo[9].Value=0

OsInfo[10].Key=prodsuite

OsInfo[10].Value=256

OsInfo[11].Key=ntprodtype

OsInfo[11].Value=1

OsInfo[12].Key=platid

OsInfo[12].Value=10

OsInfo[13].Key=sr

OsInfo[13].Value=0

OsInfo[14].Key=tmsi

OsInfo[14].Value=467968

OsInfo[15].Key=osinsty

OsInfo[15].Value=3

OsInfo[16].Key=iever

OsInfo[16].Value=11.778.18362.0-11.0.185

OsInfo[17].Key=portos

OsInfo[17].Value=0

OsInfo[18].Key=ram

OsInfo[18].Value=16047

OsInfo[19].Key=svolsz

OsInfo[19].Value=475

OsInfo[20].Key=wimbt

OsInfo[20].Value=0

OsInfo[21].Key=blddt

OsInfo[21].Value=190318

OsInfo[22].Key=bldtm

OsInfo[22].Value=1202

OsInfo[23].Key=bldbrch

OsInfo[23].Value=19h1_release

OsInfo[24].Key=bldchk

OsInfo[24].Value=0

OsInfo[25].Key=wpvermaj

OsInfo[25].Value=0

OsInfo[26].Key=wpvermin

OsInfo[26].Value=0

OsInfo[27].Key=wpbuildmaj

OsInfo[27].Value=0

OsInfo[28].Key=wpbuildmin

OsInfo[28].Value=0

OsInfo[29].Key=osver

OsInfo[29].Value=10.0.18362.778.amd64fre.19h1_release.190318-1202

OsInfo[30].Key=buildflightid

OsInfo[30].Value=2ABBFE8A-57A7-4ECE-870E-2008A39B7D9D.1

OsInfo[31].Key=edition

OsInfo[31].Value=Professional

OsInfo[32].Key=ring

OsInfo[33].Key=expid

OsInfo[34].Key=containerid

OsInfo[35].Key=containertype

OsInfo[36].Key=edu

OsInfo[36].Value=0

FriendlyEventName=Stopped working

ConsentKey=CLR20r3

AppName=LPR_Downloader

AppPath=C:\Users\hiddenuser\Desktop\bin\LPR_Downloader.exe

NsPartner=windows

NsGroup=windows8

ApplicationIdentity=51B69E4BE6102D0850B09922608F95E1

MetadataHash=-440534339
Hi, While the software downloader works fine, I have noticed every couple of days it crashes and closes and I have to restart the software again. I have now pulled the event viewer up and reviewing the logs..


Any idea on why this could be happening the log has the following entry.

Also Application error code are as following

Code:
Faulting application name: LPR_Downloader.exe, version: 1.0.0.0, time stamp: 0xa298a6e4
Faulting module name: KERNELBASE.dll, version: 10.0.18362.778, time stamp: 0x692cf0ab
Exception code: 0xe0434352
Fault offset: 0x00114192
Faulting process id: 0x3794
Faulting application start time: 0x01d61589b989595e
Faulting application path: C:\Users\hiddenuser\Desktop\bin\LPR_Downloader.exe
Faulting module path: C:\WINDOWS\System32\KERNELBASE.dll
Report Id: 51d42033-8561-45f5-9be1-133c976ddbca
Faulting package full name: 
Faulting package-relative application ID:
 

wittaj

IPCT Contributor
Joined
Apr 28, 2019
Messages
13,457
Reaction score
25,104
Location
USA
Just checking in - seems like some issues and then the chatter stopped - is everything now working ok if you follow the guide that @tech101 put together.

I have been on the fence for awhile jumping into all this and am getting close to follow the great guide put together here or plate recognizer, but this one is cheaper lol and appears folks here have figured out a way to run local and save a file that can be used in excel for search queries.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
My application for me has been working fine. If you do end up trying those set of instructions let me know if everything works out or not would be interested to see if something has changed since I have put it together.. or not .. Or if it does work. Anyhow for me its been working great I cannot think of a complete system without this. Thanks to Devs of this app for this gift to the ipcamtalk community. It is really useful/functional :D
 

nhs128

Young grasshopper
Joined
Jul 8, 2017
Messages
65
Reaction score
13
Quick question as I am not very knowledgeable with this language, but does anyone know how to auto sort by local time? I would like this to be descending. I've made minor changes to what I have so far, but can't seem to figure that one out. TIA.
 

DLONG2

Known around here
Joined
May 17, 2017
Messages
694
Reaction score
405
Quick question as I am not very knowledgeable with this language, but does anyone know how to auto sort by local time? I would like this to be descending. I've made minor changes to what I have so far, but can't seem to figure that one out. TIA.
Hi nhs.

Once the data resides in the DataGridView container then you can click on the column header at the top to sort ascending or descending. Otherwise the query would need to be altered in the code.
 

DsineR

Getting comfortable
Joined
Mar 25, 2018
Messages
356
Reaction score
434
Location
FL
My application for me has been working fine. If you do end up trying those set of instructions let me know if everything works out or not would be interested to see if something has changed since I have put it together.. or not .. Or if it does work. Anyhow for me its been working great I cannot think of a complete system without this. Thanks to Devs of this app for this gift to the ipcamtalk community. It is really useful/functional :D
2020-07-11_9-41-18.jpg
As others have stated, stuck on the downloader not populating. Followed your guide, plus added all tweaks from the gurus on this thread without luck.
Server, SQL Connection info, ALPR creds, Path settings all good.
Loaded question - any other undocumented settings to check?
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
View attachment 66156
As others have stated, stuck on the downloader not populating. Followed your guide, plus added all tweaks from the gurus on this thread without luck.
Server, SQL Connection info, ALPR creds, Path settings all good.
Loaded question - any other undocumented settings to check?
Is it downloading the CSV file on the drive ? Or no Also if it is downloading the csv file have you try to manually upload the file ?
 

DsineR

Getting comfortable
Joined
Mar 25, 2018
Messages
356
Reaction score
434
Location
FL
No, program is not downloading the CVS file. And no luck manually uploading the retrieved CVS file.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
No, program is not downloading the CVS file. And no luck manually uploading the retrieved CVS file.

When you are Logged in thru the downloader do you see your account logged in and your data showing in the screen below ?

1594500196560.png
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
Also Please verify the Sql Managment can connect to data and your tables are showing correctly and name of the database and server is correct Like in my case it is..

1594500896800.png
And then in my Downloader Setting my string is ...

1594500807473.png
 

DsineR

Getting comfortable
Joined
Mar 25, 2018
Messages
356
Reaction score
434
Location
FL
Yes, logged in successfully. And confirmed, all tables & settings are identical to my config.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
For me I remember it was the Camera_ID which was I think set to smallint and the number was bigger than the 2 bytes limit so it was not working.

That is something maybe happening in your case one way to test it is maybe try with One plate and Start Testing the data by manually uploading Or even filling each column in the database and see which one errors out.. That is How I troubleshooted my particular issue.

Like mine is set to this currently..

1594515540588.png

That is what I had to change to get mine to work. Again yours maybe something along those lines which could be the reason.. Good Luck !!
 

DsineR

Getting comfortable
Joined
Mar 25, 2018
Messages
356
Reaction score
434
Location
FL
Up n runn'n - thx tech101 for your help! Also have to call out d.lux for noticing the company change from 'smallint' to 'int'.
So both 'camera_id' & 'company' values were changed in 05 LPR_PlateHits.sql file prior to compiling.

lpr.jpg
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
Awesome !! Glad to see You up and running ! I think That is how some accounts csv are coming with higherner number which is fine. for me I have to change camera_id and sounds like for you it was also company. Thank you Dlong2 also. So guide was working sounds like it was just for you that company setting also needed to be changed apart from camera_id.
 

tech101

Known around here
Joined
Mar 30, 2015
Messages
1,360
Reaction score
1,765
Location
SF BayArea, USA
I just noticed this morning at 6:24am seems like OPENALPR changed something my downloader stopped working.. I think its the time start and end they change. Can someone confirm if they are also being affected by this and do we have a resolution so far if yes ?


Starting to feel its the very first field they changed PK.. it is a bit higher number ..

New 847495806
in the past 846129788

I feel like that is what I need to change maybe from int to big int ? Question how do i do this on a running db ?
 
Last edited:
Top