SageTV Import Utility

[Beefstew83]

No, I was using the June 2013 version. Thanks for the heads up. The db3 file looks much better now, viewing it in Notepad. I haven't gotten sqlite yet. Would it be a good idea to use sqlite to merge the db3 files or would cutting and pasting in notepad be good enough, given that I think I can see where the channels leave off and the imported recordings begin?

[ACTCMS]

I definitely wouldn't try to edit it with notepad or anything else other than a proper DB editor - you'll be sure to screw up the DB's internal pointers.

Alex

[Beefstew83]

Yeah, I was looking at it in sqlite3 and it seemed like I just need to copy records from certain tables into the db3 file from NPVR. I just need to figure out how to copy records from one database to another. I am more familiar with mySQL than sqlite. Are there any other editors that are compatible with the db3 files?

It seems there are at least 4 or 5 tables that would need to be copied over; but I haven't looked in any of them yet.

[mvallevand]

Give me a link to your separate db3 files and I'll right a sqlite script for it,

Martin

[Beefstew83]

Here's the sage import db3:

https://www.dropbox.com/s/xggb28rz3f4uvww/npvr_sage.db3

Here's the NPVR db3:

https://www.dropbox.com/s/5cpl39evfqlryto/npvr.db3

Thanks much Martin!!

[mvallevand]

Save this as copy.sql with your two files

Code:

ATTACH DATABASE 'npvr_sage.db3' AS 'npvr_sage';
INSERT INTO scheduled_recording
(name,filename,status,start_time,end_time,capture_source_oid,channel_oid,recurrence_oid,channel_name,
event_details,failure_reason,pre_padding,post_padding,quality)
SELECT name,filename,status,start_time,end_time,capture_source_oid,channel_oid,recurrence_oid,channel_name,
event_details,failure_reason,pre_padding,post_padding,quality
FROM npvr_sage.scheduled_recording;

Launch the sqlite3 shell

sqlite3 npvr.db3

then run the script
.read copy.sql
and exit
.quit

Martin

[Beefstew83]

That worked great, Martin, Thanks!!!

Now I have to figure out how to squeeze down all these recordings I'm making in NPVR. I have ImageGrabLite renaming them--just got to transcode them as well.

[Skirge01]

I'm attempting to get this working (using the exe from reply #72), but I'm receiving an Internal Server Error 500 message using the default sage/frey credentials. I can access my sagex api over http without issue and without any credentials at all. If I put in the https password I have set up, then I get an authentication issue (which I expected). I also tried the exe from the first post, but that seems broken entirely.

Any ideas?

[mvallevand]

I'm attempting to get this working (using the exe from reply #72), but I'm receiving an Internal Server Error 500 message using the default sage/frey credentials. I can access my sagex api over http without issue and without any credentials at all. If I put in the https password I have set up, then I get an authentication issue (which I expected). I also tried the exe from the first post, but that seems broken entirely.

Any ideas?

It's been a long time but did you install the sagex-services too?

Martin

[Skirge01]

It's been a long time but did you install the sagex-services too?

Martin

Sure did.