Channel list editing.

[mame]

I edited the channel list modifying some #, now I see it modified both in setting and in NextPVR but the npvr.db3 does not highlight the changes.
Where are they registered?

[mvallevand]

They are absolutely in the database but multiple tables are involved.

Martin

[mame]

They are absolutely in the database but multiple tables are involved.

Martin

Yes, I know and I export CHANNEL and CHANNEL_MAPPING to get the data that interest me, but the changes (present using NextPVR) are not present in these two tables, are they elsewhere?

[sub]

I'm not sure I follow you.

The channel names, and channel numbers are in the CHANNEL table. This is what is shown in the Settings->Channels page. They're not stored elsewhere.

[mame]

I'm not sure I follow you.

The channel names, and channel numbers are in the CHANNEL table. This is what is shown in the Settings->Channels page. They're not stored elsewhere.

I have identified the source of the problem: in some cases the field "<readable_source> xxx: xxxx: xxx </readable_source>" is omitted.
For example:
11376, LA7,7, DVB / ATSC EPG, "<epg>
   <source> DVB / ATSC EPG </source>
   <Capture_source> 21 </ capture_source>
   <readable_source> 711: 263: 8572 LA7 </readable_source>
   <Mapping> 711: 263: 8572 </ mapping>
</ EPG>
"0
11377, TELENORD, 13, DVB / ATSC EPG, "<epg>
   <source> DVB / ATSC EPG </source>
   <Capture_source> 21 </ capture_source>
   <Mapping> 1: 17002: 8572 </ mapping>
</ EPG>
"0

Why?

[sub]

in some cases the field "<readable_source> xxx: xxxx: xxx </readable_source>" is omitted.
For example:

<readable_source> isn't a database field. It's just a string the API makes from various bits of information, to display some tuning information for the user in the UI. The type of information it uses in here varies depending on the type of channel.

What do you need it for?

[mame]

in some cases the field "<readable_source> xxx: xxxx: xxx </readable_source>" is omitted.
For example:

<readable_source> isn't a database field. It's just a string the API makes from various bits of information, to display some tuning information for the user in the UI. The type of information it uses in here varies depending on the type of channel.

What do you need it for?

In recent days I have exported the database several times for the note checks and that string has always been present in all the scanned channels.
Now, for the first time, I observe that it is missing in some channels and I find it an anomalous and unusual fact.
Why do I need it? Nothing in particular, I used that string only to extract the serid:tsid:onid data to be included in my reports used in the previous posts.
I can also get those data from the <Mapping> string, but I can't explain the absence of that string, never missing before.

[sub]

It's never in the database, so I'm not sure where you think it should be.

[mame]

What is never in the database?
Here two reports exported from the databases and opened with excel
in the past the string <readable_source> was always there for all the channels, in the last npvr some channels have not it
(look, for an example only, at the channels TELENORD and Telecittà, currently without the previous string).

===  csv exported from npvr.db3 on 22/05/2020:

oid,name,number,epg_source,epg_mapping,minor
……
11376,LA7,7,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>711:263:8572 LA7</readable_source>
  <mapping>711:263:8572</mapping>
</epg>
",0
11377,TELENORD,9,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>1:17002:8572 TELENORD</readable_source>
  <mapping>1:17002:8572</mapping>
</epg>
",0
11378,Primocanale,10,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>1:16515:8572 Primocanale</readable_source>
  <mapping>1:16515:8572</mapping>
</epg>
",0
11379,TelecittΩ,11,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>2:16515:8572 TelecittΩ</readable_source>
  <mapping>2:16515:8572</mapping>
</epg>
",0
11380,E'TV LIGURIA,12,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>5:16515:8572 E&apos;TV LIGURIA</readable_source>
  <mapping>5:16515:8572</mapping>
</epg>
",0


===  csv exported from npvr.db3 on 02/06/2020:

oid,name,number,epg_source,epg_mapping,minor
………..
11376,LA7,7,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>711:263:8572 LA7</readable_source>
  <mapping>711:263:8572</mapping>
</epg>
",0
11377,TELENORD,13,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <mapping>1:17002:8572</mapping>
</epg>
",0
11378,Primocanale,10,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>1:16515:8572 Primocanale</readable_source>
  <mapping>1:16515:8572</mapping>
</epg>
",0
11379,Telecittà,11,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <mapping>2:16515:8572</mapping>
</epg>
",0
11380,E'TV LIGURIA,12,DVB/ATSC EPG,"<epg>
  <source>DVB/ATSC EPG</source>
  <capture_source>21</capture_source>
  <readable_source>5:16515:8572 E&apos;TV LIGURIA</readable_source>
  <mapping>5:16515:8572</mapping>
</epg>
",0

[mvallevand]

You asked about the fields for "Channel Editing" for ediitng the name and number. You are looking at unrelated EPG data.

Martin