It is currently Fri Jun 23, 2017 2:58 pm


All times are UTC [ DST ]




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Change sequence of albums
PostPosted: Wed Mar 29, 2017 2:04 pm 

Joined: Wed Mar 29, 2017 1:55 pm
Posts: 2
I have added the release years of all albums to have them sorted. That works fine as long as the years are different. But when two or more albums are released in the same year, the sorting is done alphabetically by title within the year. How can I change that sequence in the right chronological way?


Top
Offline Profile  
 
 Post subject: Re: Change sequence of albums
PostPosted: Sat Apr 01, 2017 11:20 am 

Joined: Fri Apr 01, 2005 7:16 am
Posts: 77
Location: Birmingham England
RockArt wrote:
I have added the release years of all albums to have them sorted. That works fine as long as the years are different. But when two or more albums are released in the same year, the sorting is done alphabetically by title within the year. How can I change that sequence in the right chronological way?


The way around that is to not only put the release year to the album but the time of the year it was actually released such as the day and the month as well. I even add the record label and it's catalogue number to mine as well. Now you can generally find this information on sites such as Wikipedia/Rate Your Music and Discogs But if you cannot find the day or the month on some of the albums that were released in the same year. What I do is look at which album came out first in that year and roughly guess the day and the month.

Hope that helps.


Top
Offline Profile  
 
 Post subject: Re: Change sequence of albums
PostPosted: Thu Apr 06, 2017 4:35 pm 

Joined: Wed Mar 29, 2017 1:55 pm
Posts: 2
Thanks Lee!

In the mean time I have found out that it is possible to edit the database with Microsoft Access and apply a sequence number in the release date field after the "." which is probably reserved for the time of day.

<ReleaseDate>25934.000001</ReleaseDate>
<ReleaseDate>25934.000002</ReleaseDate>

In this case only the year will be shown but the albums are displayed in the right sequence.


Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ]  Moderators: Jan, xblkx, Peter van der Burg

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Theme created StylerBB.net