Quick Sign In:  

Forum: VirtualDJ Technical Support

Topic: First seen column only showing time for a lot of tracks
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?
 

Posted Fri 04 Nov 22 @ 6:02 pm
locoDogPRO InfinityModeratorMember since 2013
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.
 

Posted Fri 04 Nov 22 @ 6:13 pm
That would make sense, but tracks that were loaded weeks ago are showing a time only
 

Posted 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
 

Posted Tue 08 Nov 22 @ 5:24 am