My Music - need your thoughts on how to improve and enhance | Page 55

Discussion in 'Listen Music' started by SteveV, December 13, 2005.

Thread Status:
Not open for further replies.
  1. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,494
    Likes Received:
    1,635
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,260 / 1
    Home Country:
    Austria Austria
    Ok, commited some changes to the SVN.

    To group your Artists / Albums / Genres / Song, do the following.

    In Configuration -> Music -> Music Views define a new view, or modify an existing one.



    As Operator select "group"
    In Restriction enter for how many characters you want to group.
    1=The first character, typically used for a Base / Main index.
    2=grouoing is done on 2 characters, etc.

    As an example an Artist View:

    Selection Operator Restriction
    ----------- ----------- -------------
    artist group 1
    artist
    album
    title


    This would show:
    A
    B
    C
    .
    .

    selecting A would then show all artists names, that begin with "A", then show all albums of the selected artist and show all songs of the selected album.

    Another example of a Song View:

    Selection Operator Restriction
    ----------- ----------- -------------
    title group 1
    title group 2
    title


    Selecting this view shows first the main index, like:
    0
    1
    A
    B
    C
    .
    .

    Selecting "A" shows the next index / group level, grouped by all songs starting with an "A" and further 2 characters, as set in the restriction of the second line:
    ABA ------> Abacab from Genesis
    Abagqobhi from Maskandi
    ABO ------> About a girl from Nirvana
    About a boy from Patti Smith

    I've got very good performance, compared to listing everything.
    Please let me know, what you think.

    thanks,

    Helmut
     
  2. Google AdSense Guest Advertisement



    to hide all adverts.
  3. zag2me

    zag2me Portal Pro

    Joined:
    April 11, 2006
    Messages:
    216
    Likes Received:
    35
    Ratings:
    +39 / 0
    Home Country:
    England England
  4. GoldenEye
    • Premium Supporter

    GoldenEye MP Donator

    Joined:
    October 26, 2005
    Messages:
    300
    Likes Received:
    21
    Location:
    Switzerland
    Ratings:
    +26 / 0
    Home Country:
    Switzerland Switzerland
    Show System Specs
    Helmut

    Great idea - I like it :)

    However, the feature does not work on my test system with the latest CVS. My album view, which should show A, B etc. does not show anything - just the icon to get back to the genre level. The error.log shows the following entry:

    Code (Text):
    1. 08.09.2006 07:57:09 780 [ERROR] SQL:MusicDatabaseV7.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "'1'": syntax error query:select distinct artist.* from song,album,genre,artist,path where song.idPath=path.idPath and song.idAlbum=album.idAlbum and song.idGenre=genre.idGenre and song.idArtist=artist.idArtist  and  genre.idGenre='20' and  artist.strArtist group '1'  order by strArtist asc
    2. 08.09.2006 07:57:10 109 [ERROR] musicdatabase exception err:SQL:MusicDatabaseV7.db3 cmd:sqlite3_prepare16:pvm=null err:ERROR detailed:near "'1'": syntax error query:select distinct artist.* from song,album,genre,artist,path where song.idPath=path.idPath and song.idAlbum=album.idAlbum and song.idGenre=genre.idGenre and song.idArtist=artist.idArtist  and  genre.idGenre='20' and  artist.strArtist group '1'  order by strArtist asc stack:   bei SQLite.NET.SQLiteClient.ThrowError(String statement, String sqlQuery, SqliteError err)
    3.    bei SQLite.NET.SQLiteClient.Execute(String query)
    4.    bei MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String sql, List`1& songs, Boolean artistTable, Boolean albumTable, Boolean songTable, Boolean genreTable)

    G.
     
  5. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,494
    Likes Received:
    1,635
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,260 / 1
    Home Country:
    Austria Austria
    Ok, with the lastest changes, you will now also see thumbs in the index few.
    Just create files A.jpg, B.jpg, etc. in your thumbs\music\artist, thumbs\music\album and thumbs\music\genre folder and they will be displayed. The thumbs when grouping songs by title, will be the one from album.

    we could create that automatically on a db import from existing coverart, but with the manual method you'd have a way to choose the image you like most for every character and you can "set and forget it".
     
  6. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,494
    Likes Received:
    1,635
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,260 / 1
    Home Country:
    Austria Austria
    Golden Eye,

    could you PM me how your view is set up?
    just tell me what levels you have.
    i.e.
    album group 1
    album
    title

    The SQL in the error is indeed wrong and shouldn't be created that way.
     
  7. garion

    garion Portal Member

    Joined:
    January 20, 2006
    Messages:
    32
    Likes Received:
    0
    Location:
    Bavaria
    Ratings:
    +0 / 0
    Home Country:
    Germany Germany
    Hi

    Works like a charm here.

    But is it posible to bring the number section together?

    Would shorten the list, and i think there are not that many entries in each one.

    Greets
    Garion
     
  8. onkl

    onkl Portal Pro

    Joined:
    February 18, 2005
    Messages:
    341
    Likes Received:
    0
    Occupation:
    economist
    Location:
    Wageningen
    Ratings:
    +0 / 0
    Home Country:
    Netherlands Netherlands
    Maybe also include the odd artistnames starting with obscurities like !@~<{[ etc., So a search like (pseudoSQL) where 1st symbol <A or >z.
     
  9. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,494
    Likes Received:
    1,635
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,260 / 1
    Home Country:
    Austria Austria
    Indices starting with Numbers or special characters are now located in "#"
     
  10. hwahrmann
    • Team MediaPortal

    hwahrmann Development Group

    Joined:
    September 15, 2004
    Messages:
    4,494
    Likes Received:
    1,635
    Gender:
    Male
    Location:
    Vienna, Austria
    Ratings:
    +2,260 / 1
    Home Country:
    Austria Austria
    Golgen Eye,

    just sent you a PM, telling you, why your view won't work.

    regards,

    Helmut
     
  11. onkl

    onkl Portal Pro

    Joined:
    February 18, 2005
    Messages:
    341
    Likes Received:
    0
    Occupation:
    economist
    Location:
    Wageningen
    Ratings:
    +0 / 0
    Home Country:
    Netherlands Netherlands
    Request (at least my addition) -> Update in under 3 hours. Striving for a new world record? ;)
     
Loading...
Thread Status:
Not open for further replies.

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!