Hello - For some reason, on most of the tracks in my Beatport playlist, Virtual DJ is showing the "First Seen" column as only a time, without a date. So I have hundreds of songs that just say "12:25 PM", "10:12 PM", etc ..
Some tracks are reporting the full date/time, but not many. Is there a setting somewhere for this?
Some tracks are reporting the full date/time, but not many. Is there a setting somewhere for this?
Inviato Fri 04 Nov 22 @ 6:02 pm
just time means it was today, I think date & time is up to 6months ago, and over 6 months ago you just get a date.
Inviato Fri 04 Nov 22 @ 6:13 pm
That would make sense, but tracks that were loaded weeks ago are showing a time only
Inviato Tue 08 Nov 22 @ 3:31 am
Do you mean downloaded or added to the VDJ database?
You can check the added to the VDJ database -part (which is the important one) by looking in the database.xml file. Then you get something like this for each track
<Song FilePath="C:\privat\iPod\New\Taylor Swift - Anti-Hero.mp3" FileSize="8114184">
<Tags Author="Taylor Swift" Title="Anti-Hero" Genre="Pop" Album="Midnights (3am Edition)" Composer="Taylor Swift & Jack Antonoff" TrackNumber="3/20" Year="2022" Flag="2" />
<Infos SongLength="200.751020" LastModified="1666437810" FirstSeen="1666437768" Bitrate="320" />
<Scan Version="801" Bpm="0.618866" AltBpm="0.464206" Volume="1.163329" Key="C#m" Flag="32768" />
... plus a lot of POIs
So in this example FirstSeen="1666437768". That is a unix date, which is "Number of seconds that have elapsed since 00:00:00 UTC on 1 January 1970, excluding leap seconds"
Luckily converters have been made, like this one:
https://www.epochconverter.com/
So that gives us:
So that is a quick way to test if the song was added today, within the last few months, or a long time ago, which should indeed decide the format in the column
You can check the added to the VDJ database -part (which is the important one) by looking in the database.xml file. Then you get something like this for each track
<Song FilePath="C:\privat\iPod\New\Taylor Swift - Anti-Hero.mp3" FileSize="8114184">
<Tags Author="Taylor Swift" Title="Anti-Hero" Genre="Pop" Album="Midnights (3am Edition)" Composer="Taylor Swift & Jack Antonoff" TrackNumber="3/20" Year="2022" Flag="2" />
<Infos SongLength="200.751020" LastModified="1666437810" FirstSeen="1666437768" Bitrate="320" />
<Scan Version="801" Bpm="0.618866" AltBpm="0.464206" Volume="1.163329" Key="C#m" Flag="32768" />
... plus a lot of POIs
So in this example FirstSeen="1666437768". That is a unix date, which is "Number of seconds that have elapsed since 00:00:00 UTC on 1 January 1970, excluding leap seconds"
Luckily converters have been made, like this one:
https://www.epochconverter.com/
So that gives us:
So that is a quick way to test if the song was added today, within the last few months, or a long time ago, which should indeed decide the format in the column
Inviato Tue 08 Nov 22 @ 5:24 am