JeffreyGaydos / music-database-generator

An idea to help organize your music with extra metadata using a SQL Server Database. This repository searches through a folder and gathers metadata already in mp3 files to add to a database
2 stars 1 forks source link

Tracks Repeatedly Ingest #35

Closed JeffreyGaydos closed 2 months ago

JeffreyGaydos commented 6 months ago

Certain tracks, in my case the Portal 1 & 2 soundtracks, repeatedly get ingested during each run even though no changes are found with them. Investigate why this is happening and fix it. I would guess it has to do with not setting the update timestamp properly.

JeffreyGaydos commented 2 months ago

Based on some work with the Playlist Transfer tool, it's likely that we need to set the update date to a couple seconds after the modified date of the file, as sometimes Microsoft rounds these date times in one area but not the other.

Essentially, the update date in the database is 4PM, but the update date on the file itself is 4:00.001 PM or something similar, so it always appears to have been updated since the last run, but inserts a rounded/truncated value of 4PM as the update date.