[Music] - Adding Composer to the Music DB | Page 4

Discussion in 'Improvement Suggestions' started by GoldenEye, February 18, 2007.

  1. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    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.
     
    • Like Like x 3
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. Helios61
    • Premium Supporter

    Helios61 Retired Team Member

    Joined:
    January 30, 2008
    Messages:
    4,587
    Likes Received:
    584
    Gender:
    Male
    Location:
    NRW
    Ratings:
    +897 / 4
    Home Country:
    Germany Germany
    Show System Specs
  4. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    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
     
  5. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    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?
     
  6. mortstar
    • Premium Supporter

    mortstar MP Donator

    Joined:
    January 30, 2008
    Messages:
    415
    Likes Received:
    41
    Ratings:
    +41 / 0
    Home Country:
    England England
  7. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    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 :(
     
  8. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    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.
     
  9. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    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?
     
  10. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,497
    Likes Received:
    1,639
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,266 / 1
    Home Country:
    Austria Austria
    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.
     
    • Like Like x 1
  11. jameson_uk
    • Premium Supporter

    jameson_uk Retired Team Member

    Joined:
    January 27, 2005
    Messages:
    7,258
    Likes Received:
    2,228
    Gender:
    Male
    Occupation:
    Data Warehousing Consultant
    Location:
    Birmingham
    Ratings:
    +2,405 / 0
    Home Country:
    United Kingdom United Kingdom
    Show System Specs
    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 ?
     
Loading...

Users Viewing Thread (Users: 0, Guests: 0)

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice
  • About The Project

    The vision of the MediaPortal project is to create a free open source media centre application, which supports all advanced media centre functions, and is accessible to all Windows users.

    In reaching this goal we are working every day to make sure our software is one of the best.

             

  • Support MediaPortal!

    The team works very hard to make sure the community is running the best HTPC-software. We give away MediaPortal for free but hosting and software is not for us.

    Care to support our work with a few bucks? We'd really appreciate it!