Multiple genres in npvr.db3

[bgowland]

I'm working on exporting the EPG_GENRES table for the next version of nDroid and noticed the following...

Code:

<epggenre>
    <epg_color>00000000</epg_color>
    <name>Leisure / Hobbies</name>
    <oid>27</oid>
  </epggenre>
  <epggenre>
    <epg_color>00000000</epg_color>
    <name>News / Current Affairs</name>
    <oid>28</oid>
  </epggenre>
  <epggenre>
    <epg_color>00000000</epg_color>
    <name>Music / Ballet / Dance</name>
    <oid>29</oid>
  </epggenre>

The XML format is my own but the question is about the "name" field. For example "Leisure / Hobbies"...did NextPVR do that by concatenating multiple genres? I only ask because I haven't been keeping track of what metabroadcast have been doing since they took over the Radio Times feed. I also can't find any of those multiple genre entries in my current XMLTV file.

Cheers,
Brian

[sub]

NextPVR encodes multiple genres into the one database field to simplify the required database design. Having separate genre table and genre mappings was major hassle in GBPVR and I was keen to avoid the problem in NextPVR.

However, that's not what you're seeing here....

Code:

<epggenre>
    <epg_color>00000000</epg_color>
    <name>News / Current Affairs</name>
    <oid>28</oid>
  </epggenre>

When NextPVR encodes multiple genres into the field it semi-colon separates the various genres. In this case you're just seeing a single genre called "News / Current Affairs".

[ACTCMS]

I also can't find any of those multiple genre entries in my current XMLTV file.

You'll see genres like that in the UK Freeview broadcast EPG.

Alex

[bgowland]

When NextPVR encodes multiple genres into the field it semi-colon separates the various genres. In this case you're just seeing a single genre called "News / Current Affairs".

Thanks I had a feeling that was the case.

I remember asking a question some time back about the "genres" field of the EPG_EVENT table and you'd said it was delimited with semi-colons which is why I thought the "name" field from the EPG_GENRE table looked odd with forward-slash delimiters - obviously metabroadcast doing their own thing...I'm starting to dislike those guys.

Cheers,
Brian

[bgowland]

You'll see genres like that in the UK Freeview broadcast EPG.

Alex

Hmm, OK. Not something I've ever noticed but I don't use the DVB EPG and it's a while since I trawled it with TSReader. Just having a bad code day...old dog, with too many new tricks. Perhaps I need a beer.

Cheers,
Brian

[ACTCMS]

Perhaps I need a beer.

Cheers,
Brian

Always works for me...

Alex