My Music - need your thoughts on how to improve and enhance (2 Viewers)

Status
Not open for further replies.

hwahrmann

Development Group
  • Team MediaPortal
  • September 15, 2004
    4,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    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
    Switzerland Switzerland
    Country flag
    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,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    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,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    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
    50
    Bavaria
    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
    44
    Wageningen
    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,542
    2,333
    Vienna, Austria
    Austria Austria
    Country flag
    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 (Users: 0, Guests: 1)

    OP Similar threads Forum Replies Date
    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
    N Music player help Listen Music 4
    N How to shuffle all my music, and how to sort by album artist General 4
    R MP 2.2 client spielt audio-titel kurz an und springt dann zum nächten Allgemeines Support- und Diskussionsforum 9
    joecrow Music: Fade Out not working 1.20 Pre Release 0
    M Music playback stops after certain files 1.19 0
    X [solved] Display needs to be turned on for TV services to function General 1
    J IPTV Sweden, need help with m3u list MediaPortal 1 Plugins 14
    N Play a TV recording needs a double selection - twice ok on remote Television (MyTV frontend and TV-Server) 2
    L [solved] Why does Mediaportal 2 need access to my webcam? General 2
    U [solved] Beginner needs help recording live TV General 19
    Similar threads

























    Top Bottom