Results 1 to 5 of 5

Thread: Album sorting

  1. #1
    Newbie
    Join Date
    Sep 2006
    Posts
    46

    Album sorting

    I have recently started using WMP11 on my desktop pc and really like the way the albums are sorted. When selecting albums it shows the art however instead of the albums in alphabetical order they are catagorized with the first letter of the band name and then in alphabetical order by album name. Would it be possible to set up centrafuse the same way, I know we can search by Artist however I have several albums with various artists and it lists each artist individually instead of showing the entire album.

  2. #2
    VENDOR - Centrafuse veetid's Avatar
    Join Date
    Apr 2004
    Posts
    5,040
    Quote Originally Posted by TSXPC View Post
    I have recently started using WMP11 on my desktop pc and really like the way the albums are sorted. When selecting albums it shows the art however instead of the albums in alphabetical order they are catagorized with the first letter of the band name and then in alphabetical order by album name. Would it be possible to set up centrafuse the same way, I know we can search by Artist however I have several albums with various artists and it lists each artist individually instead of showing the entire album.
    if you know Access this would be very easy to change... I do not recommend this for anyone that doesn't know what they are doing because they will break the application...

    All queries are done with SP's in the Access database main.dat, if you open it and go to the Queries section, find the Album Queries, change their order by statements...

    david
    __________________
    CENTRAFUSE http://www.centrafuse.com
    01 Jeep Cherokee Sport 4x4 Installed
    M10000/512Mb/20GB, Lilliput 7", Holux GM-210

  3. #3
    Raw Wave justintime's Avatar
    Join Date
    Apr 2005
    Posts
    2,705
    INSTRUCTIONS

    1) BACKUP YOUR MAIN.DAT FILE.

    2) Open the main.dat file with Microsoft Access, and then click on QUERIES icon. Locate the query called GetAlbums, and right-click->DesignView.

    3) Make sure it now displays the SQL view by going to VIEW menu, and selecting SQL View.

    4) Now paste this:

    SELECT Left([artist],1)+" - "+[album] AS Expr2, Min(id3.filename) AS MinOffilename, [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album]) AS Expr1
    FROM id3
    GROUP BY Left([artist],1)+" - "+[album], [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album])
    ORDER BY [artist]+" "+IIf((LCase(Left([album],4))='the '),Mid([album],5,Len([album])-4),[album]);


    5)Save and exit.
    2002 Honda CR-V
    Carputer progress: 90% [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ -]
    Spent so far: $1105.90


    Download the NEXUS Skin for Centrafuse
    ...or even Listen to my music

  4. #4
    Newbie
    Join Date
    Sep 2006
    Posts
    46
    Thanks justintime the albums are sorting the way I like them now however when you select an album no songs are showing up in the playlist? Any idea what is happening there?

  5. #5
    Raw Wave justintime's Avatar
    Join Date
    Apr 2005
    Posts
    2,705
    Sorry, have not looked ito it or tested it myself

    Hopefully you followed step 1 above, and then you can just revert things back. Right?
    2002 Honda CR-V
    Carputer progress: 90% [▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ -]
    Spent so far: $1105.90


    Download the NEXUS Skin for Centrafuse
    ...or even Listen to my music

Similar Threads

  1. ID3 Tag Issues - Album Art
    By Jdot in forum Centrafuse
    Replies: 4
    Last Post: 10-27-2006, 11:27 AM
  2. Album art downloader
    By hijinks21 in forum Software & Software Development
    Replies: 105
    Last Post: 07-20-2006, 10:56 AM
  3. Replies: 18
    Last Post: 03-12-2006, 06:56 PM
  4. Select album to play via album art
    By xGumbyx in forum Mobile Impact
    Replies: 21
    Last Post: 01-25-2006, 08:46 PM
  5. Album art browse bugs?
    By froop in forum RR Bug Tracker
    Replies: 0
    Last Post: 12-11-2005, 01:02 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •