[Music] Adding Composer to the Music DB (1 Viewer)

hwahrmann

Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    Now that 1.0.2 is out, i'm starting to extend the music database.

    will add Composer and Conductor, and maybe other tags fields, that are worth to be searched for.
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    United Kingdom United Kingdom
    Country flag
    Now that 1.0.2 is out, i'm starting to extend the music database.

    will add Composer and Conductor, and maybe other tags fields, that are worth to be searched for.
    While you are under the hood could you please add one extra little thing which would be godsend for me?

    A field in the database which is stores when the track was first added to the database would be fantastic. If this could be exposed to the views it would allow sorting based on how long the music has been in the system and things like latest 10 albums.

    Presumably the actual field could be added without any coding as you would just need to add the column to the database and set it with a default value of the current date (I am 99% this is possible with SQLite). Not sure how you then expose to the view but this would be the final thing to make MP my dream setup :D
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    This field already exists as dateAdded and is filled automaticaly by a database trigger, when the song is inserted.

    in addtion to that there's already a default view named "recently added" with a restriction of 7, which shows all songs added in the last 7 days.
    does this fulfill your needs?
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    United Kingdom United Kingdom
    Country flag
    This field already exists as dateAdded and is filled automaticaly by a database trigger, when the song is inserted.

    in addtion to that there's already a default view named "recently added" with a restriction of 7, which shows all songs added in the last 7 days.
    does this fulfill your needs?
    Not sure now.... I am sure there was a reason why this did not work for me???

    I have a feeling it was because you either could not add this as a view column or you could not sort by it? I will check when I get home tonght but could just be me being stupid :(
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    Changes are completed.
    2 new fields added for Composer and Cnductor.
    Tagreader reads those fields and populates the database.

    Both Composer and Conductor can be used to build Views. I have not included default Views fo that, since the majority of the user won't need it.
    I'm sure, you guys don't need any help anyhow to create a view.
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    United Kingdom United Kingdom
    Country flag
    This field already exists as dateAdded and is filled automaticaly by a database trigger, when the song is inserted.

    in addtion to that there's already a default view named "recently added" with a restriction of 7, which shows all songs added in the last 7 days.
    does this fulfill your needs?
    Not sure now.... I am sure there was a reason why this did not work for me???

    I have a feeling it was because you either could not add this as a view column or you could not sort by it? I will check when I get home tonght but could just be me being stupid :(
    Got home and looked but I am not clear what is what any more...

    The recently added view is based on a recently added flag?
    Is the Date field in the sort column the dateAdded database field or is it not there?
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    nope, recently added view is based on a date.
    whenever a song is inserted the first time, i'm adding the timestamp.

    the restriction "7" in the recently added view mean it lists all songs whose insert date is Current Date - 7 days.
     

    jameson_uk

    Retired Team Member
  • Premium Supporter
  • January 27, 2005
    7,258
    2,528
    Birmingham
    United Kingdom United Kingdom
    Country flag
    nope, recently added view is based on a date.
    whenever a song is inserted the first time, i'm adding the timestamp.

    the restriction "7" in the recently added view mean it lists all songs whose insert date is Current Date - 7 days.
    So if I wanted to list all albums added in the last three months I can not see a way to do this. I can not add a sort on this column can I ?
     

    Users Who Are Viewing This Thread (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    DHosein Adding Custom Artwork? My TVSeries 3
    raffe [TV] Option for adding IPTV channels without checking Improvement Suggestions 2
    Rob Hexenmeister Navigation problems adding menu buttons to EPG General Support 1
    BrownGhost MP-TVSeries, Failed to save xml to cache, and not adding any info to tvseries from tvdb My TVSeries 4
    G How best to get cover art for tracks to show up on the Audio Menu (Latest Added, Unplayed)? General 9
    Neoculture "Recently Added" option My TVSeries 8
    doskabouter No guide info added due to a MYSQL deadlock Electronic Program Guide 1
    morpheus_xx [WiP] Adding 64 bit support to MP2 MediaPortal 2 31
    Hawkeye Changes to last added view Feature Requests 0
    P Media portal not adding all TV series General 2
    B some music videos stutter Watch / Listen Media 0
    horned_reaper [solved] When playing music Fanart does not shuffle Fanart Handler 20
    horned_reaper [solved] When playing music Fanart does not appear immediately after downloading Fanart Handler 272
    horned_reaper [Music] 5012: Start current music track from the beginning Improvement Suggestions 37
    horned_reaper [solved] 5012: Restart current music track General Support 13
    atlantic How to use Spotify inside Mediaportal? Listen Music 18
    horned_reaper [solved] Music playback hangs General Support 58
    globaldonkey Music Database Error Listen Music 1
    joecrow Music on Headphones Listen Music 8
    2BitSculptor MP 1.23.. music stops playing General Support 6
    Sarxas What Music Are You Listening To? OffTopic 0
    Edwardfc [solved] Mp 2.2.1 Configuration Issues - Goes to Sleep while playing Music General 6
    G [fixed] [MP2-786] Party Music Player can only play playlists with less than 1000 items 2.2 Archive 7
    KlausWirn Music crash Bass crash no change to play music Installation, configuration support 2
    BlueMax1916 [confirm] Music: Every 2nd track skipped MediaPortal 2 30
    Similar threads

























    Top Bottom