SageTV Import Utility

[avandeputte]

I too had the big ugly error until the recompiled version from a couple posts ago. Now it runs. Or it seems to, I do get a SageImport folder, with 4 files, but the npvr.db3 file has an old timestamp and doesn't appear to contain much of anything. I attached the content of the folder in a zip.

Any clues? I am a bit late to the Sage --> NextPVR conversion, such a relief to see this utility existed!

The NextSage.log has this (and only this):

[...startup]
2013-12-30 21:58:45.079 [DEBUG][1] Exception has been thrown by the target of an invocation.
2013-12-30 21:58:45.094 [DEBUG][1] Exception has been thrown by the target of an invocation.
2013-12-30 21:58:45.106 [DEBUG][1] Exception has been thrown by the target of an invocation.

[mvallevand]

The NextSage.log has this (and only this):

It worked for me as an offline import. My wife is working here way through the same House Hunters marathon. Did you install it in the NPVR Program Directory?

Here's a version I used I recompiled it just in case I changed something.

Edit: Also I noticed that I was able to add OriginalAirDate and Genres to the Recordings data in case any skin uses them ever.

Martin

[avandeputte]

Great! No crashes/errors with this version, and I see the db3 file with the same timestamp as the other 3 files - so I think it worked.

Just curious though, what do you mean when you said you exported them offline? Unfortunately I already configured nextPVR before I discovered this utility, I am not looking forward to start over with a new db3...

Happy new year!

[mvallevand]

Great! No crashes/errors with this version, and I see the db3 file with the same timestamp as the other 3 files - so I think it worked.

Great

Just curious though, what do you mean when you said you exported them offline? Unfortunately I already configured nextPVR before I discovered this utility, I am not looking forward to start over with a new db3...

If you empty the EPG and compress and upload your db3 file, I'll see what I can do.

Martin

[avandeputte]

Confirmed - your utility works like a charm.... It's a thing of beauty. This utility is going to make the switch a no brainer for me. But I may have to run it over and over because I want to keep testing and customizing before I make the switch final (let's just say my wife is not very understanding of my little experiments, so I better get it right )

Your mention about adding original air date to the skin got my thinking... How do you do that?

I tried adding Text text="@originalairdate" visible="@isItem" location="2.32,66.28" size="93.03,63.17" font="DefaultSmall" align="left" wrap="true"/>
to my already customized skin, it doesn't work. How do you reference these fields from a skin?

Thanks again - I am having lots of fun with npvr so far.

[mvallevand]

Sub might not even expose it, on the Recordings screen or Event popup.

Martin

[Beefstew83]

Martin,

Thanks for all your hard work on this utility. I also am a bit late to the SageTV Import game and would like to keep my existing NPVR configuration. Can the .db3 file be opened in SQLite or is it Dbase III? I figure I might be able to merge the imported recordings into the existing .db3 file. Who knows, it might just be easier to redo the channels over.

[mvallevand]

sqlite. It is possible to open/merge two different db3 file's tables.

Martin

[Beefstew83]

Martin,

I ran the import utility and the resulting db3 file was very small(31kb). There were no recordings in that file. There was a SageIn.xml that was 3mb and had all the recordings in it. I didn't notice any reference to the SageIn.xml in the db3 file. Is this normal? The regular db3 was huge by comparison and there are no NPVR recordings currently.

[mvallevand]

Martin,

I ran the import utility and the resulting db3 file was very small(31kb). There were no recordings in that file. There was a SageIn.xml that was 3mb and had all the recordings in it. I didn't notice any reference to the SageIn.xml in the db3 file. Is this normal? The regular db3 was huge by comparison and there are no NPVR recordings currently.

Did you use this version http://forums.nextpvr.com/showthread.php...post468985

Martin