Announcement

Collapse
No announcement yet.

Database build question

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Database build question

    How come the music database doesn't pull in alphabetical order? When I observe the files being pulled into the database when I build it in Media Engine, it goes in alphabetical order for a bunch of folders and then does it again for another bunch. So I have a few areas in my music database when I Browse All Music that are A-Z, A-Z, A-Z. I want just one A-Z database.

  • #2
    I believe it is in alphabetical order, but not the way that you want. It is in order by full path name. I don't use ME, so I don't know if there is a way to change it. I remember this being talked about a few months ago, so do a search to see if there is a way to change this.
    ________________
    ______ILL.1______

    Comment


    • #3
      I think they go by date, not name... It's just a coincedent that your letters are almost in order with dates.

      Of course, I'm not the one that program this, best chance is to ask him that question.

      Comment


      • #4
        Yeah it seems the be by date, but I wonder which date.. I used a program that changes the Created, Modified and Accessed dates on a file all to be the same date and it still puts it in a weird order. I'll keep searching

        Comment


        • #5
          Err that'd be a bug

          I'm glad i caught this thread - I just looked and that particular SQL query is missing ordering clauses which will cause the records to be returned in stupid orders. Fixing....

          Grab 2.2.0 when we release it (sorry no eta) and your ordering should make more sense.
          '01 Chevy Xtreme Stepside (pics)

          FIC K7MNF-64 / Athlon 3200 | 256 DDR | 120 GB 7.2k WD
          WinXP Pro | MediaEngine | 12.1 VGA TFT Touch|Creative CIMR-100
          350w Vector | 320w mATX PS | Hellroaring BIC95150 | ButterflySDC

          Comment


          • #6
            great news!! I can't wait!

            Just to verify, how are the mp3s ordered in the database? Date then folder then file name?

            Comment


            • #7
              They're ordered however window's FindFile API returns them to us. On an NTFS filesystem this will be in alpha order, but on the FATs it will be by timestamp. To see it how we get it fed to us do a 'dir /s' from a command prompt and you should see the same ordering. This generally makes no difference to the end user because all of the queries we use to extract info from the database later on use ordering clauses (of course, save this one that you located). For example when you browse in the folders, there's an option to have it sort by filename (which is how I prefer) or by artist-title. Then when you browse by artist then album, it will sort by track number (drawn from the id3 tag). I've found that most ppl have problems understanding why records sort in strange ways, and then they look at their database in access and find out that 80% of their media is incorrectly or incompletely tagged. One of my pet peeves is that 99% of what I listen to gets tagged by some schmuck as genre: 'Rock'. Who on this planet who appreciates their music enough to post the album to freedb would categorize Tool as genre: 'Rock'? But I digress...

              http://www.freedb.org/freedb_search_...ck&id=b712040f
              '01 Chevy Xtreme Stepside (pics)

              FIC K7MNF-64 / Athlon 3200 | 256 DDR | 120 GB 7.2k WD
              WinXP Pro | MediaEngine | 12.1 VGA TFT Touch|Creative CIMR-100
              350w Vector | 320w mATX PS | Hellroaring BIC95150 | ButterflySDC

              Comment


              • #8
                Umm... will you add a button that brings to the top of the list? I know the very top of the list is the back to upper folder, but when I'm down a few 100 pages, going back up to switch tree takes forever. Anyway to implement it?

                Comment

                Working...
                X