double entries in XBMC with ImageGrabLite .nfo files.

[kricker]

I just tried again, just doing one episode and it worked. When I tried doing it with the whole database it didn't work.

I was doing this:

Code:

sqlite3 c:\users\public\npvr\npvr.db3 < igall.sql

Which created a "iglout.bat" file. I then ran that .bat file but the nfo was never created for any of the Tom & Jerry episodes. Interestingly enough, none of the Tom & Jerry recordings are in that "iglout.bat" file. Is there a chance they are getting skipped for some reason?

end of iglout.bat file:

Code:

"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11030    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11090    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11419    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11462    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11492    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11573    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11583    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11584    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11598    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11627    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11665    
"D:\HTPC\NPVR\imageGrabLite" --nfo --oid     11674

oids for Tom & Jerry recordings from the npvr.db3:

Code:

11349
11430
11563
11610
11702
11703
11704
11705
11706
11707
11708
11709
11710

Some of these are missing the actual filenames, so that may be why those don't show up, but the one that worked when I just did the one was oid 11702.

[mvallevand]

The example igall.sql I wrote filtered files with .S. in them

Martin

[kricker]

Oh yeah, that explains most of them but the one in question was named "Tom & Jerry_20130711_11590300.ts" and it still did not get in that .bat file.

BTW, thanks for the support and general helpfulness.

[mvallevand]

I had to hunt the sample maybe status is not 2

Martin

[kricker]

I think I recall it had a status of 1 whatever that means.

[mvallevand]

When you look at it in NextPVR it might tell you. If it is 1 my select didn't pick it up.

Martin

[kricker]

Okay. Good to know. I can always edit the DB in the future. For now I just need some new recordings and see if it all works.

[mvallevand]

I expect sub will be releasing the next version of NextPVR well before the new fall season begins which will need an update to IGL. Until then I can't provide any updates, but if you have any suggestions let me know.

Martin