Channel editor for MECOOL KT1?

In my spare time, I figured out how to change the channel list on my computer.

I am using this program https://sqlitebrowser.org/ to

fix channel name with vsdtv_tif.sqlite3 file when backing up LiveTV

Quote from coikutebmt

In my spare time, I figured out how to change the channel list on my computer.

I am using this program https://sqlitebrowser.org/ to

fix channel name with vsdtv_tif.sqlite3 file when backing up LiveTV

Which table contains the channel names ?

How coikutebmt says, you can edit database channels list from a backup. This works with Mecool KA1 as well and probably other similar models like Magicsee with Android TV and Live Channels app.

Here the steps:

- Go to Live TV / DVB Channel Search / Settings / Backup User Data (you will need a USB pen drive connected to make the backup)

- Then, in your computer download DB Browser for SQLite and open the database stored in /DigitalTV/backup/vsdtv_tif.sqlite3

- In t6_service table edit lcn values to order it as you want.

- Finally save and restore from from Live TV app.

Other way, more advanced and complex, which you will can even place logos to channel list modifying the com.android.providers.tv

- With ADB backup application backup providers.tv. It's necessary approve from Android TV

adb backup com.android.providers.tv -f backup.adb

- Second, unpack the backup with Android Backup Extractor (java app)

java -jar abe.jar unpack backup.adb backup.tar

- Third, edit the tv.db from SQLite browser editor. In the channels table, "display_number" and "logos" columns if you want. You can embed png logos directly on the database. Save the database.

- Repack the backup with Backup Extractor:

java -jar abe.jar pack backup.tar backup.adb

- Lastly, restore the workaround backup:

adb restore backup.adb

IMPORTANT: if you open DVB Channel Search to search new channels, organize or modify some channel, the modified database probably will return to original configuration and you would have to restore or modify your database.

Hi,

When i open the db, there are 2 colums as

-allocated lcn

-original lcn

I am assuming that i have to edit the allocated lcn value. Can you please confirm?

Thanks

Quote from momosan

How coikutebmt says, you can edit database channels list from a backup. This works with Mecool KA1 as well and probably other similar models like Magicsee with Android TV and Live Channels app.

Here the steps:

- Go to Live TV / DVB Channel Search / Settings / Backup User Data (you will need a USB pen drive connected to make the backup)

- Then, in your computer download DB Browser for SQLite and open the database stored in /DigitalTV/backup/vsdtv_tif.sqlite3

- In t6_service table edit lcn values to order it as you want.

- Finally save and restore from from Live TV app.

Display More