V3.031 - Date Sort issue - Created date + Sorting by day of month only

From V3.031 Change Log - The sort by date added has been fixed. It will now list movies by the nfo creation date. This date will be reset by creation, editing, saving, or rescraping

I selected a recently added movie of mine but noticed it wasn't listed at the top of the list....so I then rescraped the movie using the editor & change movie function. The file was still not at the top (or bottom...)

A restart of MC also made no difference...

When you say the creation date of the .nfo, do you mean the actual creation date reported to the operating system of the nfo file?

In my case that didn't change form the day I first scraped the movie but the 'Modified Date' did.

My NAS uses an Ntfs filesystem if thats relavent.

I've done a little more research... looks like MC is sorting my movies by the day of the month....rather than the complete date...

i.e. when i choose date added, the list is in order by the day of the month.. i.e. 1,2,3,4,....28,29,30,31 irrelavent of the actual month in the date....


The issue re the nfo creation date is still relavent however as it is not changed with a rewrite of the nfo...

Thanks

MC uses a single object when a nfo file is loaded. After editing, scraping or even just changing the watched status the whole object is saved, overwriting the old nfo. This means that the creation date is the one to be using.

As for the date used.

Code:

Dim filecreation As New FileInfo(path)
Dim myDate As Date = filecreation.CreationTime
movie.filedate = Format(myDate, "ddMMyyyyhhmmss")

It is stored and sorted as an integer and this is what is causing the issue.
22nd of July 2008 12:25:30 will be listed as 22072008122530
the problem is that
23rd of July 2007 12:25:30 will be listed as 23072009122530 which is a higher number and therefor the order is wrong.

Since I have rescraped all 1000+ of my movies over the last few days for testing purposes it seemed to be working.

I am having a bit of a mental block over this, just can't get my head around it.

Actually, I think i've sussed it: "yyyyMMddhhmmss" should work

Yes yyyyMMddhhmmss will work... (edit: just tried 3.032 & it looks like its sorting OK)

Re the creation Date on the NFO's, it is definately not changing for me....


I check the properties of the nfo thru explorer before hand, most have the same creation & modified dates since they haven't been edited since thier creation.

In MC I change the watched status & then recheck the dates again. The file modified date is today, but the creation is still the old one..... Opening the file confirms that the playcount value has changed.
I Have repeated the test on my NAS & locally on my computer, the result is the same....

Do you specifically delete the old nfo, or just overwrite it?

Thanks

I'm glad its finally working

I just overwrite it.

As in the code segmant below it gets the CreationTime

If the sort works, as it does for me and apparently you, then surely that suggests that the creation time must have changed.

I mean the sort works, but the creation time is not changed....its is sorting correctly now by the creation date but my creation dates do not change....


I have repeated the test on a second machine with the same result....


I installed MC in C:\Media Companion
I created a folder called C:\Media Companion\Movies

In that folder I created a text document & renamed it Star Trek (2009).avi

I ran MC
I added the movie folder to the preferences
I then performed a media search

The movie was scraped OK

I opened up the C:\Media Companion\Movies folder & viewed the properties of the Star Trek(2009).nfo

The reported creation date, modified date & accessed date are all the same as you would expect.

In MC I click on the unwatched button to change it to watched

I reopen the properties of the nfo file & the creation date is still the original date, the modified date & accessed date are newer i.e. a time that was few seconds ago when unwatched button was hit.

Both systems are XP SP3, is this the behaviour that you get on your system?

Thanks

I noticed that I forgot to update the date data when movies are first scraped, i've just fixed this.

In my version, editing, saving or altering the watched status, will move the movie to the top of the list when sorting by date. Are you not experiencing this?

No this doesn't happen either.....Um generally....

I just added a second movie & the first time I pushed the unwatched it moved to the other position (sorry can't remember now if I had invert order on or off) , but I suspecting it was due to the issue of the date not being updated after the initial scan...

However after that it doesn't matter which movie I choose & change the watched status, neither moves to the top. They are fixed by the creation date which isn't being changed.

I'm wondering if deleting the nfo & then rewriting it will address this issue, perhaps the file handle is still open & the OS assumes it is an append rather than a recreation?

Im using Vista 64 Ultimate and the behaviour is different, when the file is overwritten Vista resets the creation time, the behaviour of XP must be different.

Either way, I will set MC to use the last modified date. This should resolve the issue.

OK thanks Billy.