Support and General Use > Audio Playback, Database and Playlists
Database Building and Album Track Number Sorting Issue
bennor:
Installed Rockbox current build version ee1f54c-120226 on to 4GB Clip+ with 16GB microSD card. I am having trouble with multi CD audiobooks with more than 10 media files not listing in numerical order when viewing them via the Database/Album/<media collection name>. With the Sansa firmware these files would order properly. It would appear the "track" field and or the "disc number" fields are being incorrectly ordered in the database album page. The files are sorted 1-10, then 100-109, then 11 then 110-119, and so on. I've search through the forum for this issue and while there are some posts, http://forums.rockbox.org/index.php/topic,8611.0.html, http://forums.rockbox.org/index.php/topic,22853.0.html, that are similar to the issue I am experiencing, there doesn't seem to be a solution to the issue. I've tried to use the tagnavi_custom.config file with either of the following lines of code which has no affect on the file/track order.
%format "fmt_title" "%03d. %s" tracknum title ? tracknum > "0"
or
%format "fmt_title" "%02d.%03d. %s" discnum tracknum title ? discnum > "0"
Is there a special trick to get the Database/Album/<collection name> page to order lists of songs/audio book files that number more than 10 files correctly? Or do the ID3 tags for the files need to be changed and if so what entries are used by the Database to sort the files/tracks correctly?
The other issue I have is when initializing the database it hangs with the message "Building database... 6255 found(OFF to return)". It appears the database has trouble with the media (MP3) files on the microSD card since with the card removed I can initialize the database. Is there a limit to the number of files the database can sort through? Can the ID3 tags cause the database sorting to hang?
saratoga:
The hang sounds like a bad file crashing the parser. If you could find and upload the file, it would be helpful to us in fixing that bug. If you go into System -> Debug there is a metadata log. This will make a txt file in the root of the player with a list of each file the database parsed. If it crashes, the last item listed there is probably the one that crashed it.
As for sorting, I think changing the tagnavi file should fix it, and that we should probably update the default order to handle this. That said I don't use the database, so I'm not too sure what to change.
bennor:
Did the System -> Debug -> Metadata log step and while that yielded a rather large log file the last file listed each time was the last file in different sub folders on the microSD card. I'm probably going to have to experiment by moving one audiobook folder over at a time, or in groups, to see which one might be causing the trouble. I have some 5,620 files contained in 77 folders in the Audiobook folder on the microSD card with 192 files in 21 folders in the Music folder, and 6 files in the Podcast folder on the Sansa 4GB Clip+ player.
I appear to have fixed the problem with the sorting when having disc numbers in double digits and track numbers that span three digits by using a tagnavi_custom.config file. On a side note, there doesn't appear to be clear directions on editing this file on the Rockbox site, it took reading several other posts in the forum, and their trials and tribulations with editing the tagnavi_custom.config file along with some trial and error to figure out what to edit in my tagnavi_custom.config file. Here is the steps and code changes that appears to work for me.
Copied the file tagnavi.config and renamed it tagnavi_custom.config. Used Notepad (in Windows) to edit the tagnavi_custom.config file and commented out the line %include "/.rockbox/tagnavi_custom.config" with a "#". Or one can delete this line.
Next, and this is a key point to this fix, did a search and replace to renamed the entry "fmt_title" to "fmt_title_custom". Note: Failure to rename this entry in the tagnavi_custom.config causes updated code for the disc and track numbers to not work (at least for me). Next, since both the disc number (discnum) and track number (tracknum) values were causing the sorting problems, edited the following lines to change the two values. Note: I also updated, and renamed, the entry fmt_best_tracks to fmt_best_tracks_custom since tracknum is used in that entry.
From:
--- Code: ---%format "fmt_title" "%d.%02d. %s - %02d:%02d" discnum tracknum title Lm Ls ? discnum > "0"
%format "fmt_title" "%02d. %s - %02d:%02d" tracknum title Lm Ls ? tracknum > "0"
%format "fmt_best_tracks" "%02d. %s (%3d)" tracknum title autoscore
--- End code ---
To:
--- Code: ---%format "fmt_title_custom" "%02d.%03d. %s - %02d:%02d" discnum tracknum title Lm Ls ? discnum > "0"
%format "fmt_title_custom" "%03d. %s - %02d:%02d" tracknum title Lm Ls ? tracknum > "0"
%format "fmt_best_tracks_custom" "%03d. %s (%3d)" tracknum title autoscore
--- End code ---
With these changes media with two digit disc numbers and three digit track numbers should now sort correctly in Rockbox Database --> Album --> <content name> page.
The only downside to this edit to fix the sorting is all track numbers will now be displayed as 3 digits rather than 2.
Hopefully this information will help others who experience the track and disc number sorting issues that I experienced.
bennor:
For some reason more than half of my audio book folders contain at least one file that causes the Rockbox database generation to fail. Many of the audiobook files were ripped from audio cd's with iTunes, version 10.5.3.3.
I've included a link to one MP3 file in zipped format that breaks the database generation all by itself. The audio file appears to play without issue.
http://tinyurl.com/7eun86a
saratoga:
--- Quote from: bennor on February 28, 2012, 05:54:05 PM ---I've included a link to one MP3 file in zipped format that breaks the database generation all by itself. The audio file appears to play without issue.
http://tinyurl.com/7eun86a
--- End quote ---
That file is built into the database without issue on my Clip+ and in the UI simulator. Not sure why its causing issues for your player. Have you tried checking the file system for errors? Perhaps your copy of the file was corrupted.
Navigation
[0] Message Index
[#] Next page
Go to full version