[beeswax]

I'm suffering from this problem too. I like both TV and Movies to be arranged by date added to my collection i.e. file create/modify date. This worked fine for movies in Gotham but not for TV shows. Unable to upgrade to Helix back then due to lack of PVR support in my favourite skin, I had to get around this in Gotham.

I have now made the leap to Helix only to find all date related sorting has broken somewhere along the line, what happened?

edit: I'm also on win32 and 14.0 RC3

[pkscout]

I don't think it's an intentional change of behavior. From what I can tell it only affects Windows (my OS X machine doesn't exhibit the behavior). And for me it only occurs if I rename a file. If I don't rename a file and change it's creation and modification date, it seems to work fine.

[beeswax]

Sorry, I didn't mean to suggest it was an intentional change.

I've encountered the problem when moving files from one drive to another. I have to do this once in a while for housekeeping but I always use Attribute Changer to put all file/folder dates back to the original creation date of the movie file so as not to mess up the sorting, this always worked fine in Gotham (and I'm sure early betas of Helix). With the latest Helix RC's however, even if I make sure the file dates are fixed before updating the library all those old movies that have been moved jump to the top of my list.

[echo]

I've encountered the problem when moving files from one drive to another. I have to do this once in a while for housekeeping but I always use Attribute Changer to put all file/folder dates back to the original creation date of the movie file so as not to mess up the sorting, this always worked fine in Gotham (and I'm sure early betas of Helix). With the latest Helix RC's however, even if I make sure the file dates are fixed before updating the library all those old movies that have been moved jump to the top of my list.

Yep, that's exactly what I was doing as well... hopefully it's not a complicated problem for the devs to figure out. Though I REALLY can't understand why this bug would crop up all of a sudden... reading filesystem date/time doesn't sound like a function that would be affected by other development..

[pkscout]

hopefully it's not a complicated problem for the devs to figure out. Though I REALLY can't understand why this bug would crop up all of a sudden... reading filesystem date/time doesn't sound like a function that would be affected by other development..

As a recovering software developer, I can say with some confidence that the one thing you are 100% sure won't affect anything else is the one thing that will absolutely affect everything.

[jsunshine]

Hello folks!
Not sure if this is the same problem but I recently upgraded from Gotham to Helix and i'm having issues with the dates as well...

Short version... KODI RC3 is getting its dateadded dates from the date of the folder the movie is contained in and not from the file itself or from the nfo.

I started with a Windows 8.1 machine as a server running Gotham 13.2 and MySQL... I exported all database as individual files and then formatted the OS partition and installed Windows Server 2012 R2. Reinstalled MySQL and then KODI Helix RC3.

I have all my movies over 3 drives in individual folders (IE F:\Movies\Batman (1989)\Batman (1989).avi ) and somewhere along the way, the date modified times for all the movies in particular folder got set to todays date but the files themselves have the same date. Not sure how that happened... Anyway... the date modified for the folder is 2015, the date modified for the file is 2010, the date added tag inside the NFO is also 2010. But the movie gets set to the top of the recently added movies list. In another folder, the dates of the movies folders haven't changed and they remain the same.

It appears to have done the same thing for all my tv episodes as well since they are just listed alphabetically now.

I've tried importing using the same scraper I always use, importing using local nfo only and then just rescraping them entirely off the internet and it is still sticking the date of the FOLDER...

So lemme know if you need anymore info, i'm sure I can work out how to do debug logs etc.

Thank you. And sorry first post ever is me whinging.

[beeswax]

KODI RC3 is getting its dateadded dates from the date of the folder the movie is contained in

No, that's not it. After moving a load of old movie files, I'm correcting the folder and file created/modified dates back to their original values before re-scanning the library. Kodi seems to be just using the current date/time at the moment the scan is performed rather than another date from the files/folders.

[jsunshine]

Not on mine- I just checked. When I sort the movies in the library by date added, all the movies on the drive where the movie folders dates did not change (which is exFat btw) are listed at the bottom of the list with all various dates over the past 4 or 5 years. But from the other drives, ( ntfs ), they are all listed from 2 days ago in alphabetical order.

[beeswax]

I'm not sure that proves your point and you're not explaining very clearly. You need to open up your MySQL database with something like HeidiSQL to confirm your theory - check the dateadded value in the actual database. You're saying your folder dates are somewhere in 2015, if your theory is correct, your dateAdded column will have values of 2015 for the NTFS movies.

Sounds to me like all your movies on the NTFS drive have been given the current date and time at the point they were scanned in and as the scan would have gone through in alphabetical order, that's how they appear.

[tphoenix]

Windows 7 here, getting the same issue. I use a program that changes my shows mtime to its original air date, and I have advancedsettings set to use mtime, but when I scan my TV shows they are not being sorted this way. Just thought I'd let you know it's affecting me too.

EDIT: After some testing it looks to me like Kodi is using the accessed date, instead of the modified date, when importing files to the library.

EDIT 2: Strike that. I added some movies from a test folder and they ended up with date added of 5/11/2014. This date is no where to be found in the folder or files anywhere...

[beeswax]

This isn't fixed in the final release. I've just had chance to do some more testing and Kodi is simply using the current date and time for the dateAdded value in MySQL regardless of the <dateadded> setting in advancedsettings.xml. Even though after moving a file and using Attribute Changer to change every single file and folder date back to, say, 2009, Kodi slaps the current date and time into the dateAdded SQL column.

I tried moving 3 movies, one at a time, closing and re-opening Kodi between each and changing the <dateadded> setting in advancedsettings.xml. Whether it's 0,1 or 2 it does the same thing.

I don't know if it's worth mentioning that before doing this test, I didn't even have the <dateadded> setting in advancedsettings.xml configured as the default of 1 should (and has in Gothem -> Early Helix betas) work fine. So it's broken whether the option is configured or not.

[echo]

Hopefully Montellese will have time to look into this bug now that Helix is released... he mentioned that it's on his todo list and that he implemented the dateadded for videos..

This bug is the only thing stopping me from migrating to Helix. It just messes up my library too much to ignore.

[scott967]

I did some testing. this is on files on a local NTFS file system (Win 7 x64). I compared "date added" in the SQLite database for Kodi 14.0 and XBMC 13.2. I used a utility "SetMACE64.exe" to dump the timestamp data of a movie in the database:

Code:

Starting SetMace by Joakim Schicht
Version 1.0.0.16

Target filename: DASBOO~1.MKV
Target fileref: 235273
Target MFT record offset: 0x000000495803C400
Parent filename: DASBOO~1
Parent fileref: 234999
Parent MFT record offset: 0x0000004957FF7C00

Start reading timestamps from disk

Header SequenceNo: 17
Header HardLinkCount: 2

$STANDARD_INFORMATION
CreationTime: 2014-11-17 21:30:36:083:5908
LastWriteTime: 2013-06-17 02:58:06:456:5234
ChangeTime(MFT): 2014-11-17 21:31:45:661:5704
LastAccessTime: 2014-11-17 21:30:36:083:5908

$FILE_NAME 1
FileName: Das Boot.mkv
ParentReferenceNo: 234999
CreationTime: 2014-11-17 21:30:36:083:5908
LastWriteTime: 2014-11-17 21:30:36:083:5908
ChangeTime(MFT): 2014-11-17 21:30:36:083:5908
LastAccessTime: 2014-11-17 21:30:36:083:5908

$FILE_NAME 2
FileName: DASBOO~1.MKV
ParentReferenceNo: 234999
CreationTime: 2014-11-17 21:30:36:083:5908
LastWriteTime: 2014-11-17 21:30:36:083:5908
ChangeTime(MFT): 2014-11-17 21:30:36:083:5908
LastAccessTime: 2014-11-17 21:30:36:083:5908

Timestamps from INDX of parent (indexed $STANDARD_INFORMATION):
FileName: Das Boot.mkv
Header ReferenceNo: 235273
Header ParentReferenceNo: 234999
CreationTime: 2014-11-17 21:30:36:083:5908
LastWriteTime: 2013-06-17 02:58:06:456:5234
ChangeTime(MFT): 2014-11-17 21:31:45:661:5704
LastAccessTime: 2014-11-17 21:30:36:083:5908

FileName: DASBOO~1.MKV
Header ReferenceNo: 235273
Header ParentReferenceNo: 234999
CreationTime: 2014-11-17 21:30:36:083:5908
LastWriteTime: 2013-06-17 02:58:06:456:5234
ChangeTime(MFT): 2014-11-17 21:31:45:661:5704
LastAccessTime: 2014-11-17 21:30:36:083:5908

Finished reading timestamps from disk


Job took 1.37 seconds

Note that Windows NTFS stores the timestamps in UTC (actually integer number of 100 nanosecond intervals from 1/1/1601) but when you check your file properties in the OS it will be converted to your local system time (i.e., using time zone and DST corrections).

What I found was this:

Both Gotham and Helix store the UTC uncorrected times.

Gotham stores
$STANDARD_INFORMATION LastWriteTime

Helix stores
$STANDARD_INFORMATION ChangeTime(MFT)

which I think is not what is wanted. I have to leave for a bit so can't do more testing to confirm until later but you might want to check this out.

scott s.
.

[jubilex]

I'm using Windows 8.1 and Helix 14.0. Running in portable mode, if that matters.

I'm having the issue as well. Recently Added, as well as my own playlist that sorts by Date Added, are hopelessly out of whack. Movies from years ago are above movies from yesterday or sandwiched between two movies from a month ago.

None of my movie files or folders have been moved, renamed, or altered in any way since I had it all working in Gotham.

I can't for the life of me figure out where the order Kodi is using is coming from. The created/modified/access dates on the files and the folders they're in are exactly what they should be and exactly what they have always been. I exported the XML from Kodi and the <dateadded> for the first movie I noticed in the wrong place did not correspond to today's date, the date I added my library, or any of the created/modified/accessed dates for the mkv, the nfo, or the folder.

I've tried with and without the various <datedadded> options in advancedsettings.xml. I've also tried with and without "Local Information Only" in the content chooser.

[jubilex]

So to be clear, none of the <dateadded> options in advancedsettings will use the correct create/modified date of the file, the nfo, or the folder; nor will Kodi import the <createdate> in the NFO (as generated by Media Companion or whatever). So there is currently no way to import an existing library into Kodi and have it be correctly sorted by date.