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