title
Products            Buy            Support Forum            Professional            About            Codec Central
 

Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Anna_Blume
    • Nov 2015
    • 14

    Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

    Hi,

    I´m using dBpoweramp for ripping, PerfectTunes for editing tags and AssetUPnP as Music Server. I´m using multi-value tags when ripping classical music, unfortunately only the first entry is shown both in PerfectTunes and Asset.

    Here is an example of what I´m typing in, e.g.:
    Artist: Sviatoslav Richter; Dietrich Fischer-Dieskau
    Artist Sort: Richter, Sviatoslav; Fischer-Dieskau, Dietrich

    The MediaDatabaseFieldsv5.txt (and the IDTagDatabaseFields.txt for PerfectTunes) looks as follows:
    title,0,NVARCHAR(150)
    t_artist,3,INTEGER
    t_artist_sort,3,INTEGER
    t_album artist,3,INTEGER
    t_album artist_sort,3,INTEGER
    t_album,0,INTEGER
    t_genre,3,INTEGER
    year,0,INTEGER
    track,0,NVARCHAR(10)
    disc,0,NVARCHAR(10)
    t_composer,3,INTEGER
    t_composer_sort,3,INTEGER
    t_conductor,3,INTEGER
    t_conductor_sort,3,INTEGER
    compilation,0,INTEGER
    t_style,3,INTEGER
    Opus,3,INTEGER
    t_orchestra,3,INTEGER
    t_chorus,3,INTEGER
    t_soloists,3,INTEGER
    t_soloists_sort,3,INTEGER
    Label,3,INTEGER
    Instrument,3,INTEGER

    Does anybody have a clue why only the first of the multi-value entries is shown in the generated lists of Asset and/or PerfectTunes? Am I using a wrong syntax of the fields?
    Thanks
  • Spoon
    Administrator
    • Apr 2002
    • 43893

    #2
    Re: Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

    This is by default in asset, only the main artist is shown. You can change that by selecting (in the configuration 'Contributing artists with Main Artists')
    Spoon
    www.dbpoweramp.com

    Comment

    • Anna_Blume
      • Nov 2015
      • 14

      #3
      Re: Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

      Hi Spoon,
      thank you for instant reply.
      I've set the checkbox in asset config as suggested, now it workes. Although I get two entries for Artist: Dietrich Fischer Dieskau, one containing 2 albums, the other one the rest (10+CDs), no album shown in both. I`ll investigate further, maybe some inconsistency with naming in the sort fields.

      Re impact of the check box 'Contributing artists with Main Artists': Does this mean, all entries in the fields 'Album Artist', 'Artist', 'Soloists' are merged? Are there any other fields that are merged into 'Artist'?

      As I posted initially under PerfectTunes: Any chance to get multi-entries shown in PerfectTunes (at least the first 4)?

      Thanks

      Comment

      • Spoon
        Administrator
        • Apr 2002
        • 43893

        #4
        Re: Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

        Perecttunes will only browse by the main artist of the track.

        Asset does not merge 'Album Artist', 'Artist', 'Soloists' to artist, only multi artists.
        Spoon
        www.dbpoweramp.com

        Comment

        • Anna_Blume
          • Nov 2015
          • 14

          #5
          Re: Proper syntax of multi-value fields in MediaDatabaseFieldsv5.txt

          Hi Spoon,
          understood.
          Re PerfetcTunes: this explains why multi-entries are overwritten entirely when single suggestions/recommendations are accepted, e.g. in the 'Sort Tags' window. I would like to put multi-entry functionality on the wishlist for PerfectTunes!
          Cheers

          Comment

          Working...

          ]]>