
Champion
•
5.5K Messages
•
97.2K Points
Sat, Jul 30, 2011 10:45 PM
Solved
Lightroom: Inconsistent dates for files missing date/time metadata
If an image or video is missing metadata date/time fields, then LR 3.4.1 uses the file's date-modified for filtering, sorting, and pre-populating the Metadata > Edit Capture Time dialog, but it uses the file's date-created to display in the grid view. It should use date-modified consistently for all of those. (When Windows copies or restores a file, the date-modified is preserved, but date-created is usually set to "now".)
This problem trips up people managing scanned images and videos, since scanners typically don't add any metadata and LR doesn't understand much video metadata.
See these threads for examples and details:
http://forums.adobe.com/message/37343...
http://forums.adobe.com/message/38293...
This problem trips up people managing scanned images and videos, since scanners typically don't add any metadata and LR doesn't understand much video metadata.
See these threads for examples and details:
http://forums.adobe.com/message/37343...
http://forums.adobe.com/message/38293...
Problems
•
Updated
6 years ago
25
26
Helpful Widget
How can we improve?
Tags
No tags available
Responses
Official Solution
benjamin_warde
Employee
•
477 Messages
•
10.7K Points
7 years ago
Thanks,
Ben
0
benjamin_warde
Employee
•
477 Messages
•
10.7K Points
9 years ago
I've been investigating issues similar to this. Can you post a file that illustrates the problem? There are a whole lot of different possible date/time fields within a file's metadata so generic descriptors like "date/time" or "date-modified" unfortunately aren't very helpful.
Thanks,
Ben
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
9 years ago
To reproduce LR's inconsistent use of Windows date-modified and date-created:
1. Download test1.jpg and test2.jpg:
Test1.jpg has EXIF:DateTimeOriginal set to 1/1/2010, and Test2.jpg has no metadata at all.
2.Using the free utility BulkFileChanger (from Download.com), open test2.jpg and change its Date Modified to 1/1/2009 and its Date Created to 1/1/2011. (The date-modified and date-created fields won't be set properly when you first download the file.) These file dates could happen if a file was originally created by a scanner or camera video on 1/1/2009, but then the user copied the files on 1/1/2011 (Windows copy by default preserves Date Modified but sets Date Created to now).
3. Import both files into a fresh LR catalog.
4. Verify in Metadata > EXIF that test1.jpg has Date Time Original is 1/1/2010 and test2.jpg has no Date Time Original:
5. In Library mode, select All Photographs, sort by ascending Capture Time, and open the Date Column in the Library Filter. Here's a screen shot:
6. Observe in the grid view that test2.jpg has the date 1/1/2011 displayed under it, the Windows date-created.
7. Observe in the Library Filter Date column that the dates 2009-01-01 and 2010-01-01 are shown. LR is using the Windows date-modified for test2.jpg here.
8. Observe in the grid view that test2.jpg comes before test1.jpg, even though sort-by-capture-time-ascending is selected and the date shown under the thumbnail for test2.jpg (1/1/2011) comes after the date shown under the thumbnail for test1.jpg (1/1/2010). LR is displaying the Windows date-created under the thumbnail but using Windows date-modified for the actual sorting.
9. Select test2.jpg and do Metadata > Edit Capture Time. Observe that the Corrected Time is prepopulated with the Windows date-modified, 1/1/2009:
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
9 years ago
0
0
dilip_2475276
6 Messages
•
132 Points
9 years ago
0
0
londonyank
6 Messages
•
124 Points
9 years ago
When I view them in Grid view in Lightroom 4, sorted by Capture Time, then some of the videos show up in odd places. As in, many of the videos appear out of sequence, alongside pictures from 1 hour before, even though according to Lightroom 4 the capture time is correct. So you will see a video from 11:56AM right next to a photo from 10:56AM. Capture times are displayed correctly but the video is shown out of sequence in the initial view. You can see this in the screenshot I have attached.
UPDATE: Looking again, I noticed that all of my displayed Capture Times were 1 hour off as I had not changed my camera's clock to daylight savings time. I made a capture time adjustment to all files - photos and video - and now the videos display in their expected position within the photo timeline. HOWEVER, the issue still stands, as initially imported. I think there is still a bug with some part of the import or grid sorting in Lightroom 4 as evidenced by the behaviour I observed on the initial import.
This reply was created from a merged topic originally titled
Lightroom 4: Videos are showing up in the wrong place according to their timestamp..
0
0
miroslaw_lawczys
18 Messages
•
396 Points
9 years ago
This reply was created from a merged topic originally titled
Problem with Lightroom catalog sorting of movie files.
0
0
daniel_arbeeny
47 Messages
•
592 Points
9 years ago
I am struggling with this because after importing ~37k files from PSE I am LOST. The new Vids i create are off also.
0
0
peter_schmollen
1 Message
•
60 Points
8 years ago
0
0
paolo_avezzano
58 Messages
•
828 Points
8 years ago
As you can see from the screenshot below (photos removed), I have a group of nine time-contiguous movies from 20:32 to 21:08 which are placed before the rest of movies/photos which start at 19:20.
It seems that, despite being everything correct on the metadata side, those 9 movies have being ingested as if they were shot two hours earlier, so 18:32 to 19:08.
Note that I didn't change any date/time setting on the camera nor in Lightroom for none of the movies/photos.
They have been imported all together.
No need to add that the current sort order is "Sort: Capture Time".
Checking with exiftool, all the date/tim metadata is OK.
This reply was created from a merged topic originally titled
Fuji X10 movies wrongly sorted by Capture Time.
6
0
morgan_bergkvist
1 Message
•
60 Points
8 years ago
I'm evaluating Lightroom 4.1 and it is not useful for organize movie clip since all of the clips gets wrong "Capture Time". This also affects the import which I've set to rename the files based on the "Capture Time". I'm using a Canon S100. By the way the GPS data isn't read correctly either.
I've been using exiftool, which can read those fields, for renaming but I had expected Lightroom to be able to handle this as well.
0
0
hhheflin
22 Messages
•
426 Points
8 years ago
Lightroom4 R2
System Information"Operating System new – server roles
System Model - White Box
Windows 7 Ultimate (x64) Service Pack 1 (build 7601)
Install Language: English (United States)
System Locale: English (United States)
Installed: 9/7/2011 1:50:04 PM No details available
Processor a Main Circuit Board b
3.00 gigahertz AMD Athlon II X4 640
512 kilobyte primary memory cache
2048 kilobyte secondary memory cache
64-bit ready
Multi-core (4 total)
Not hyper-threaded Board: ASUSTeK Computer INC. M5A88-V EVO Rev X.0x
Serial Number: MF70B6G08900555
Bus Clock: 200 megahertz
BIOS: American Megatrends Inc. 0402 04/18/2011
new USB Storage Use in past 30 Days (mouse over last used for details) new Hosted Virtual Machines (mouse over name for details)
Last Used
Maxtor Basics Desktop -- drive 3, s/n 2HBE66XP, rev 0125 4/30/2012 6:08:28 AM
Generic Flash Disk, s/n E150C44B, rev 8.07 4/23/2012 11:46:24 AM*
2.0 Flash Disk, s/n 216418592346, rev 4.00 4/19/2012 4:16:30 PM*
Maxtor OneTouch II, s/n B60EFY2H, rev 023d 4/16/2012 5:28:27 PM*
* Possibly used again before the reboot following this time.
None discovered
Drives new – drive encryption Memory Modules c,d
1230.17 Gigabytes Usable Hard Drive Capacity
630.57 Gigabytes Hard Drive Free Space
_NEC DVD_RW ND-3520A ATA Device [Optical drive]
ASUS DRW-24B3LT ATA Device [Optical drive]
Maxtor Basics Desktop USB Device [Hard drive] (750.15 GB) -- drive 3, s/n 2HBE66XP
ST3320413AS [Hard drive] (320.07 GB) -- drive 0, s/n 6VMW7WH3, rev JC45, SMART Status: Healthy
ST380011A [Hard drive] (80.03 GB) -- drive 2, s/n 4JV58LC8, rev 8.01, SMART Status: Healthy
ST380811AS [Hard drive] (80.03 GB) -- drive 1, s/n 9PS00AVH, rev 3.AAE, SMART Status: Healthy 12288 Megabytes Usable Installed Memory
Slot 'DIMM0' has 4096 MB
Slot 'DIMM1' has 4096 MB
Slot 'DIMM2' has 4096 MB
Slot 'DIMM3' is Empty
Local Drive Volumes new – volume encryption
c: (NTFS on drive 0) * 319.97 GB 236.73 GB free
d: (NTFS on drive 2) 80.02 GB 58.59 GB free
e: (NTFS on drive 1) 80.02 GB 65.66 GB free
h: (NTFS on drive 3) 750.15 GB 269.58 GB free
Situation/Condition:
Fully imported all photos on my photo drive.
Photo drive contains the Catalog and Cache Folders/Files
Folders arranged by shoot year/date
Files named by various useful names for me.
Year folders 2006 through 2012
Lightroom Library with Grid Mode
Sort by A-Z and Capture Date
Folders for years 2006 through 2011 all show in the grid as I would expect with the images sorted by Capture Date
Highlight the 2012 Folder with grid view order is miscellaneously sorted with the fires image in the upper left corner of the grid being
Select/Higliight the 20120102 Folder and all of the image files are properly sorted as expected by Created Date.
I deleted the Catalog and recreated/imported the image folders and files a second time creating a "new and clean" catalog with the same results. While I'm not the most experienced LR user; this does not seem to be O.K.
Hope you can solve the issue prior to full release.
Cordially,
Howard H. Heflin
This reply was created from a merged topic originally titled
Lightroom 4 RC2: Library Sort Issue.
0
0
daniel_arbeeny
47 Messages
•
592 Points
8 years ago
What is up? This is trivial because it works on my images perfectly and should do the same for videos.
0
0
jon_morrow_5010438
45 Messages
•
936 Points
8 years ago
See attached screenshot. The image shown was captured (by a cellphone camera, alas, but with a correctly set clock) on Nov. 17 at 18:46, as correctly shown in the metadata. But the label in the grid shows the date as Nov. 23 at 00:54, which is the time I uploaded the image from the phone to my computer -- even though the Grid View option is Capture Date/Time, not Creation Date/Time. However, when sorting the Library Grid by Capture Time, the image correctly sorts in its time slot on Nov. 17. The sort order is correct, but the label is wrong.
The Edit Capture Time dialog also shows the "Original Time" (=capture time) correctly as Nov. 17 at 18:46 (actually, it shows Nov. 17 at 06:46, presumably because the image was taken 12 time zones away from my current location) and also gives the Creation Date as Nov. 23 at 00:54.
Interestingly, pictures taken with my real cameras have the correct Capture time showing in the grid. I see this incorrect behavior only with my cellphone camera. Clearly the phone is doing something wrong with its metadata, but the odd thing is that LR is reporting the Capture time correctly in the Metadata panel but incorrectly in the grid label. Shouldn't these be the same?
Until this gets fixed in LR, any ideas of external tools I might use on the metadata to trick LR to label the file correctly?
This reply was created from a merged topic originally titled
Lightroom: File creation time/date mistaken for Capture time/date in Library label.
0
0
John_R_Ellis
Champion
•
5.5K Messages
•
97.2K Points
8 years ago
It's also curious that LR decides to show EXIF:ModifyDate as the capture date, even though that's not what's recommended by the standards. It's doubly curious that it shows the file's modified time under the thumbnail in the grid view. But this is a symptom of a general problem that LR has when a file is missing DateTimeOriginal.
1
0