IPTV useername

[jrockow]

My IPTV provider changed my username.

I previously spent a lot of time cleaning up channels and switching over my EPG to Schedules Direct.
Must I redo all that work now or is there some way (DB change perhaps) I can just insert my new username?

[mvallevand]

IPTV is not a particularly stable environment so you should expect extra work, TANSTAAFL. In any case you should consider researching the sqlite replace command

UPDATE channel_mapping
SET tuning = replace( tuning, 'old', 'new' )

making sure that oldpassword replaces exactly what you want and isn't repeated. If you can use =old, =new or &old &new even better.

Martin

[jrockow]

martin,

thanx for your response.
I tried your suggestion earlier without success.

then I loaded up a spare PC with NEXTPVR and did an import of the IPTV channels using the new username.
turns out some of the channel_OID and channel_source_numbers are different from my original setup.
who determines these numbers; NEXTPVR or my IPTV reseller?

I'm using the same VADERS service, but it appears that my reseller has changed, hence the new username.

I'm beginning to think my best move forward would be to delete my IPTV channels in my original setup and re-import all the channels.
Besides all the unwanted channels I deleted, I assigned the remaining channels EPG using Schedules Direct; a whole lot of work.
I get that's on me, I just wanted confirmation.

As you said, TANSTAAFL!

[mvallevand]

Channel mapping changes in the m3u file and the EPG are big issues for sure. Much harder to deal with in SQL the simple change.

Martin

[sub]

turns out some of the channel_OID and channel_source_numbers are different from my original setup.
who determines these numbers; NEXTPVR or my IPTV reseller?

CHANNEL_MAPPING.channel_source_numbers isn't used for IPTV channels. They're probably just some incrementing number. If the numbers are slightly different, it'll likely be because the IPTV provider has changed the channel list since you originally imported it. channel_source_numbers is only really used with analog and HDPVR style devices (for sending to the channel blaster)

The actual channel numbers are often just an incrementing number with IPTV too, unless their m3u providers an "tvg-chno". (most don't)

[jrockow]

So then do concur with Martin that all I need change is the username in the tuning field and it should have worked? It didn't.

[sub]

If that was all that changed about their url, then yes, that's likely all that needed to change. Hard to guess why without logs etc.

[pBS]

you'll have to replace the token= string in sql, then go in settings, then 'channels' then 'bulkmap' then 'ok' out of that screen and nextpvr will reread database changes.
[or just restart recording service]
i do it all the time.. instead of mapping all of the 30 sports channels my game may land on, i just wait to find out which one it'll be on, and then run batch file to update new url,[same area as username] then go into settings/bulkmap and i can watch channel..

wish there were a cmdline to reread tuning strings, but not a huge deal as most of procedure is manual anyways.

Code:

sqlite3.exe npvr.db3 "UPDATE channel_mapping SET tuning = REPLACE(tuning, 'token=oldstring', 'token=newstring');"

if you look in your .m3u8 that is imported, just replace old token= string with new one and you're set..