Skip to main content ↑ ↓

Notice

Please note that most of the software linked on this forum is likely to be safe to use. If you are unsure, feel free to ask in the relevant topics, or send a private message to an administrator or moderator. To help curb the problems of false positives, or in the event that you do find actual malware, you can contribute through the article linked here.
Topic: PlaybackList Stastics Questions (2) (Read 965 times) previous topic - next topic
0 Members and 1 Guest are viewing this topic.

PlaybackList Stastics Questions (2)

In using the Playback Statistics component, the Date Column reflects the date of when a song or a folder was added.
Question 1) when sorting this column, it sorts the entire column by Month, Day and Year. Thus if songs were added on 5/1/20, 5/1/22 and 5/1/24 the column sorts these songs by May 1, xxxx rather than the actual date added. Wondering if there is a script or fix for this.

Question 2) I loaded a few LP rips that were created recently. For some reason the date shows: 12/7/2018 when in fact the actual date should be 9/22/2024

Open to any thoughts as presently this column is unhelpful.
Using Foobar 2.2 from 9-11-2024 and Playback Statistics component is version 3.15
Thanks

Re: PlaybackList Stastics Questions (2)

Reply #2 –
Good question as it's been a long time since I'd looked at this and may have gotten this code by another user. 

Under Default User Interface | Playlist View | Date Added  I found this code: 
$month(%added%)/$day_of_month(%added%)/$year(%added%).

I can tried your code below an in the column under Date Added it now shows
"YYYY-MM-DD HH:MM:SS"

- obviously I'm entering your recommendation in the incorrect place or perhaps I need to re-adjust the current script or eliminate and start elsewhere
Thank you

Re: PlaybackList Stastics Questions (2)

Reply #3 –
Tried swapping the code around and the column formats correctly and sorts correctly.
$year(%added%)/$month(%added%)/$day_of_month(%added%)

Just not clear then on Question 2 where a file that was created on 9-28-24 shows up as a date from 12/7/2018. Open to recommendations..thanks

Re: PlaybackList Stastics Questions (2)

Reply #4 –
Well Playback Statistics is database based so your files are not touched and it does this by a combination of various tags in the file:

https://wiki.hydrogenaud.io/index.php?title=Foobar2000:Components/Playback_Statistics_v3.x_(foo_playcount)#New_playback_statistics_data_pinning_scheme_introduced_in_version_3.0

Quote
Playback statistics are now pinned to a combination of artist + album + disc number + track number + track title information, contrary to pre-3.0 versions which would pin data to file paths.

For this old date to show, you must have another copy of the album added at some point in the past??

Re: PlaybackList Stastics Questions (2)

Reply #5 –
Yes in fact a few different versions of the same LP.  

You're right likely using a database entry. Here's a copy and paste from the URL : 
%added% Date/time at which the song was added to the Media Library.

This doesn't help at all when adding updated additional or replacement files and in fact is erroneous as it's clearly "not" the Date Added. 
Wish there was a way to avoid using "the date first added to the Database" but rather the Date that the file or folder was "actually" added.