Switch from TS to HLS without re-importing playlist et al?

[markn62]

Is there an easy way to switch the source from ...type=m3u&output=ts" to ...type=m3u&output=m3u8" (TS to HLS) without re-importing the nearly matching URL so it doesn't blow out all scheduling, epg, mapping, etc?  The playlist and db should remain the same switching url's since the source,user/pw remains the same.  I don't see the source url in the config.xml file.  It's a few hours of work to switch starting from scratch via the UI.

[sub]

The urls for each station are in the npvr.db3 database file, in the CHANNEL_MAPPING.tuning table. You could probably do some sort of sql replace if there is a predictable part of the url that can be replaced.

[markn62]

The urls for each station are in the npvr.db3 database file, in the CHANNEL_MAPPING.tuning table. You could probably do some sort of sql replace if there is a predictable part of the url that can be replaced.

Thanks sub.  Would this be the only table where the url would need to be edited?  I find the url in tables CAPTURE_SOURCE, CHANNEL, & IPTV_RECORDER as well.  Or will the url propogate to these three add'l tables once the process is started?

[sub]

Technically you only need to change CHANNEL_MAPPING.tuning to change the type of stream you're watching. You can change those other spots as well, to make it look like it is entirely right (and so things like the 'update m3u' button work as expected)

[markn62]

Don't want anything unexpected. Ran the script below and it did the trick. Saves me a lot of time, thanks.

UPDATE main.CAPTURE_SOURCE
SET name = REPLACE(name, 'output=ts', 'output=m3u8');
UPDATE main.CHANNEL_MAPPING
SET tuning = REPLACE(tuning, 'output=ts', 'output=m3u8');
UPDATE main.IPTV_RECORDER
SET m3u_url = REPLACE(m3u_url, 'output=ts', 'output=m3u8')

[sub]

Great!