My Music - need your thoughts on how to improve and enhance (1 Viewer)

Status
Not open for further replies.

hwahrmann

Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    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
     

    GoldenEye

    MP Donator
  • Premium Supporter
  • October 26, 2005
    300
    26
    Switzerland
    Home Country
    Switzerland Switzerland
    Ok, commited some changes to the SVN.

    Please let me know, what you think.
    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:
    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
    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)
       bei SQLite.NET.SQLiteClient.Execute(String query)
       bei MediaPortal.Music.Database.MusicDatabase.GetSongsByFilter(String sql, List`1& songs, Boolean artistTable, Boolean albumTable, Boolean songTable, Boolean genreTable)


    G.
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    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".
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    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.
     

    garion

    Portal Member
    January 20, 2006
    32
    0
    53
    Bavaria
    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
     

    onkl

    Portal Pro
    February 18, 2005
    341
    0
    47
    Wageningen
    Home Country
    Netherlands Netherlands
    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
    Maybe also include the odd artistnames starting with obscurities like !@~<{[ etc., So a search like (pseudoSQL) where 1st symbol <A or >z.
     

    hwahrmann

    Development Group
  • Team MediaPortal
  • September 15, 2004
    4,633
    2,457
    Vienna, Austria
    Home Country
    Austria Austria
    Golgen Eye,

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

    regards,

    Helmut
     
    Status
    Not open for further replies.

    Users who are viewing this thread

    Top Bottom