What filename stores info assigning channel frequencies to channel names (QAM)?

[Scanjo]

I'm using ver 2.5.5 with current patches on Win7 in USA. My cable company can't seem to make up their mind what channel frequencies will be from one month to the next. I finally got things setup and working again. When assigning channels, some of them aren't there anymore (the guide side of things). I'd like to be able to look through the old file, get the guide info I need, and copy and paste into the new file with the new frequencies for the channel. I know you fine folks can help me out with that. I hope I have explained it well enough but if not, please get back to me and I'll try to clarify.

Thanks in advance for the help.

Scott

[sub]

It's not so easy, but the tuning information is stored in the npvr.db3 file, which is a SQLite database file. Its stored in the CHANNEL_MAPPING table's 'tuning' column.

[Scanjo]

<sigh> It couldn't be a simple XML file now could it... Ok. Thanks. Hope it's similar to MySQL.

[sub]

I'm guessing you wont feel any better when I tell you it's inside a bit of xml inside that database.

Thankfully there is plenty of free tools for viewing/editing SQLite database files. Its a very commonly used database.

[Scanjo]

Ya. Figured that out. Spent the last few hours finding sqlite commands (not the same syntax as MySQL) and then poring over the info trying to figure it all out. Gaining on it but had another thought in the middle of it all. My main problem is that some of the channels didn't show up in the list when I was setting up the channels (channel details).

Ok...now this is bizarre. I just went into the settings so I could be sure I was describing things right. Now there are a BUNCH more channels to map to. No idea what happened but I guess I just needed to be patient with it. Hmmm... Problem solved. I just need to go in and remap the channels that weren't there last night. <shaking head>

Thanks for your help. Through my stubbornness I gained a bit more knowledge (not much but a bit).

I am curious why NPVR waited so long to give me all the info to work with. Any ideas??? QAM channels using XMLTV for the guide info.

Thanks so much for your quick responses. I really appreciate your help.

Scott

[sub]

I am curious why NPVR waited so long to give me all the info to work with. Any ideas???

It wouldn't have added any channels except when scanning, so I dont know.

[whurlston]

If you were using SQLite Administrator to browse the database, I've found that you need to select the table AFTER clicking on the "Edit Data" tab to show the data. This has caught me off guard more than once because I ussually select the table first.

[Reddwarf]

SQLite Manager (a plugin to Mozilla Firefox) is an easy to use tool for manipulating the npvr database.

[Scanjo]

Ok. Things are definitely working now. No idea why it took so long but it did... I accept that I will likely never know why. As long as it works, I'm good with it.

It wouldn't have added any channels except when scanning, so I dont know.

Sub: The number of channels more than doubled over night. I tried updating the guide more than once and rebooted multiple times the night I was working on it. <shrug> I give up. Lets go with the theory that you fixed it with the power of your mind.

If you were using SQLite Administrator to browse

whurlston: I was using a shell program, which is why it took so long to figure out commands. Wasn't expecting it to be so involved since I have worked with MySQL. Commands are different and syntax as well. All is well with NPVR now so I'll do my best to forget SQLite at least for now so it doesn't confuse me with MySQL on the web site...

SQLite Manager (a plugin to Mozilla Firefox) is an easy to use tool for manipulating the npvr database.

Reddwarf: Good to know if I end up in a situation like this somewhere down the road. Thanks.

I think we can consider this thread closed. Thanks all.

Scott