Sort collection by file creation date or touch "Added" field

Takkat
Posts: 6
Joined: Mon Nov 14, 2011 11:53 am

Sort collection by file creation date or touch "Added" field

Post by Takkat » Mon Nov 14, 2011 12:17 pm

It happened to me more than once that I had to rescan my library/collection - last time after updating to recent SVN 0.3.4-1692, before that on every OS upgrade and fresh install of Guayadeque. By doing so all information on the date when a music file was added gets entirely lost (e.g .my collection is now set to all files added on 2011/11/13). There is no way to find out what files have been added recently.

As I often browse my collection for recently added files it would be extremely helpful to have a feature that either allows sorting by file creation date or, even cooler to be able to optionally touch the collection "Added" data field with the file creation date for any or all music files on my drive. Browsing with the File Browser is not an option because of the so many directories and subdirectories my files are in.

rawdlite
Posts: 27
Joined: Tue Feb 22, 2011 9:13 am

Sort collection by file creation date or touch "Added" field

Post by rawdlite » Thu Jan 05, 2012 7:11 pm

Have you considered the find command? (man find)

Also you could write a little skript that writes the files creation date as "added" into the sqlite db.
HTH

rawdlite
Posts: 27
Joined: Tue Feb 22, 2011 9:13 am

Sort collection by file creation date or touch "Added" field

Post by rawdlite » Thu Jan 05, 2012 7:36 pm

I just understood, what you mean with File Browser.
Sorry, forget the find command.

The "added" date is saved in the songs_addedtime column of the songs table as an integer.
I already wrote a skript that moves multiple genres to labels accessing the db.
Next time i work on that, i could add the touch creation time.

Takkat
Posts: 6
Joined: Mon Nov 14, 2011 11:53 am

Sort collection by file creation date or touch "Added" field

Post by Takkat » Fri Jan 06, 2012 2:50 am

Good to see some love for my suggestion. Yeah, finding files by creation date from the OS is not a problem. Nevertheless it would be cool to touch library "songs_addedtime" with these data (e.g. by a script - looking forward to it).

User avatar
anonbeat
Posts: 1960
Joined: Thu Sep 16, 2010 9:47 pm

Sort collection by file creation date or touch "Added" field

Post by anonbeat » Wed Jan 11, 2012 12:27 am

Takkat wrote:It happened to me more than once that I had to rescan my library/collection - last time after updating to recent SVN 0.3.4-1692, before that on every OS upgrade and fresh install of Guayadeque. By doing so all information on the date when a music file was added gets entirely lost (e.g .my collection is now set to all files added on 2011/11/13). There is no way to find out what files have been added recently.

As I often browse my collection for recently added files it would be extremely helpful to have a feature that either allows sorting by file creation date or, even cooler to be able to optionally touch the collection "Added" data field with the file creation date for any or all music files on my drive. Browsing with the File Browser is not an option because of the so many directories and subdirectories my files are in.
I will try to set the added date to the file modified date. Indeed I think its a good idea.

Thank you very much for your help

tamalet
Posts: 490
Joined: Fri Sep 24, 2010 4:34 am

Sort collection by file creation date or touch "Added" field

Post by tamalet » Wed Jan 11, 2012 5:33 am

This seems to be implemented in r1738
r1738 | anonbeat | 2012-01-11 04:48:46 -0300 (Wed, 11 Jan 2012) | 1 line
Use file date as added date when creating tracks

Should I mark http://sourceforge.net/apps/ideatorrent ... /idea/107/ as implemented?

User avatar
anonbeat
Posts: 1960
Joined: Thu Sep 16, 2010 9:47 pm

Sort collection by file creation date or touch "Added" field

Post by anonbeat » Wed Jan 11, 2012 6:29 am

Yes that is implemented.

Takkat
Posts: 6
Joined: Mon Nov 14, 2011 11:53 am

Sort collection by file creation date or touch "Added" field

Post by Takkat » Wed Jan 11, 2012 12:25 pm

That really is the best birthday present for me today. Such great news!

Thank you for making Guayadeque better and even better again.

tamalet
Posts: 490
Joined: Fri Sep 24, 2010 4:34 am

Sort collection by file creation date or touch "Added" field

Post by tamalet » Wed Jan 11, 2012 3:13 pm

Happy birthday!

mekanix
Posts: 210
Joined: Wed Sep 29, 2010 11:20 pm

Sort collection by file creation date or touch "Added" field

Post by mekanix » Thu Jan 12, 2012 12:18 am

anonbeat wrote: I will try to set the added date to the file modified date. Indeed I think its a good idea.

Thank you very much for your help
Hi anonbeat I'm having some problem with this, all my files have import date between 60s and 70s :)
Is there anyone having such a problem?

Post Reply