Media Companion

Discussion and development board for the program Media Companion.
 
HomeHome  SearchSearch  RegisterRegister  Log inLog in  

 

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

Go down 
AuthorMessage
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeMon Jul 06, 2009 12:36 pm

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.


Last edited by StormyKnight on Mon Jul 06, 2009 1:01 pm; edited 1 time in total
Back to top Go down
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeMon Jul 06, 2009 1:00 pm

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
Back to top Go down
billyad2000
Admin
billyad2000

Posts : 1326
Join date : 2008-09-20

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeMon Jul 06, 2009 1:59 pm

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

_________________
Do you have a problem with Media Companion, before posting a bug then please check you have the very latest version of Media Companion http://billyad2000.darkbb.com/announcements-f1/
Back to top Go down
http://billyad2000.co.uk
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeTue Jul 07, 2009 9:47 am

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
Back to top Go down
billyad2000
Admin
billyad2000

Posts : 1326
Join date : 2008-09-20

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeTue Jul 07, 2009 11:42 am

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.

_________________
Do you have a problem with Media Companion, before posting a bug then please check you have the very latest version of Media Companion http://billyad2000.darkbb.com/announcements-f1/
Back to top Go down
http://billyad2000.co.uk
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeWed Jul 08, 2009 3:01 am

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


Last edited by StormyKnight on Wed Jul 08, 2009 3:28 am; edited 1 time in total
Back to top Go down
billyad2000
Admin
billyad2000

Posts : 1326
Join date : 2008-09-20

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeWed Jul 08, 2009 3:19 am

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?

_________________
Do you have a problem with Media Companion, before posting a bug then please check you have the very latest version of Media Companion http://billyad2000.darkbb.com/announcements-f1/
Back to top Go down
http://billyad2000.co.uk
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeWed Jul 08, 2009 3:41 am

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?
Back to top Go down
billyad2000
Admin
billyad2000

Posts : 1326
Join date : 2008-09-20

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeWed Jul 08, 2009 11:25 am

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.

_________________
Do you have a problem with Media Companion, before posting a bug then please check you have the very latest version of Media Companion http://billyad2000.darkbb.com/announcements-f1/
Back to top Go down
http://billyad2000.co.uk
StormyKnight
VIP
VIP


Posts : 556
Join date : 2008-10-08
Location : Australia

V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitimeThu Jul 09, 2009 7:20 am

OK thanks Billy.
Back to top Go down
Sponsored content




V3.031 - Date Sort issue - Created date + Sorting by day of month only Empty
PostSubject: Re: V3.031 - Date Sort issue - Created date + Sorting by day of month only   V3.031 - Date Sort issue - Created date + Sorting by day of month only Icon_minitime

Back to top Go down
 
V3.031 - Date Sort issue - Created date + Sorting by day of month only
Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
Media Companion :: Media Companion :: Bug Discussion-
Jump to: