I’m confused

Lightroom: Import: Wrong folder names organizing by date around midnight when using camera USB

When importing from a camera connected to USB (at least for a Canon EOS 40D Firmware 1.1.1 in my case), lightroom generates wrong folder names when organizing folders by date, at least for the "2011/2011-07-22" format (I guess it's the same for the other formats).

I use Lightroom 3.4.1 on Windows XP 32 Bit SP 3 and my time zone is CET+DST (Paris, Berlin). I shot six photos an hour apart around midnight CET+DST from 21:30 on Thursday to 02:30 on friday (I changed the camera's time for that) and got the following folder/file structure using a USB connection to the camera:

2011\2011-07-21\20110721-213022-IMG_0314.CR2
2011\2011-07-22\20110721-223033-IMG_0315.CR2 <<< wrong folder
2011\2011-07-22\20110721-233041-IMG_0316.CR2 <<< wrong folder
2011\2011-07-22\20110722-003049-IMG_0317.CR2
2011\2011-07-22\20110722-013055-IMG_0318.CR2
2011\2011-07-22\20110722-023102-IMG_0319.CR2

Clearly, the two marked files are in the wrong folder. Note that the file naming itself (date and time) is absolutely correct!

When I import the same six photos using a card reader from the CF card, I get the correct structure:

2011\2011-07-21\20110721-213022-IMG_0314.CR2
2011\2011-07-21\20110721-223033-IMG_0315.CR2 <<< now correct folder
2011\2011-07-21\20110721-233041-IMG_0316.CR2 <<< now correct folder
2011\2011-07-22\20110722-003049-IMG_0317.CR2
2011\2011-07-22\20110722-013055-IMG_0318.CR2
2011\2011-07-22\20110722-023102-IMG_0319.CR2

This seems to be some "time zone / daylight savings time bug" affecting all photos made from two hours before midnight until just before midnight (my local time is UTC plus two hours) - but why only for camera USB and not for card reader? I didn't test it for a date that has no DST, but I would bet that it would affect photos from *one* hour before midnight, then.

P.S. The wrong folder structure also already shows in the folder preview in the import dialog. Here is the wrong structure using USB to camera:

...and the correct one using a card reader:
13 people have
this problem
+1
Reply
  • Quoting LrUser24: "Note that the file naming itself (date and time) is absolutely correct! "

    Seems safe to say Lightroom is using a different source for time when naming the files versus the folders.

    My WAG: Lightroom uses file-created date for folders and exif info for file-naming, and when camera is emulating disk via USB it reports a different file-created date.

    I think Lightroom's handling of date-time needs to be "robustified" in this case, and a few others... More specifically to this case: use date-time-original in exif metadata for both folder name and file-name.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Seems safe to say Lightroom is using a different source for time when naming the files versus the folders.

    My WAG: Lightroom uses file-created date for folders and exif info for file-naming, and when camera is emulating disk via USB it reports a different file-created date. This is just a guess...

    I think Lightroom's handling of date-time needs to be "robustified" in this case, and a few others... More specifically to this case: use date-time-original in exif metadata for both folder name and file-name.

    But also, I've seen Lightroom name the same files differently upon import too. Once with local time and another with UTC, so my WAG may be completely bogus...
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • This particular issue appears to be a variation of the original 'time-zone' bug which occurred in 3.0, but now it only affects date-based folder names when importing directly from camera. File naming is not affected.

    Caveat: on Win7 64bit, LR3.4.1, Canon 5D MkII, USB2 connection. Other combinations may produce different results, I have not tested, though I think Geoff Walker was going to try with a Nikon/MAC combination.

    The problem is that in this specific import scenario, Lightroom will ADD the system time-zone UTC offset to the DTO of the files being imported when it determines the destination folder name for the date-based schemes that include DD. For example, if you live in a UTC+12 time-zone, ALL shots taken after mid-day local time with camera also set to local time will produce a folder date of the following day, as +12 is added to the local hour value in the DTO.

    Apologies, meant to report it when we first came across it a month or so ago.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • BTW, thought it'd be a good idea to check what happens in a negative UTC zone and found consistent behaviour, i.e. set UTC to -12, local time in camera to before midday, take a picture, and subsequent import folder name shows previous day.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I am able to reproduce this problem, and have entered the issue in our bug database.

    Incidentally, time zone and DST settings on the camera don't seem to make a difference. I also tested with Nikon and had the same problem, so it doesn't seem to be specific to any particular camera. Appears to be a Windows-only bug, I cannot reproduce on Mac.

    Thanks,
    Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Was this ever fixed? I'm seeing the same behaviour in LR 3.6 (PC / Nikon).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hi Timothy,

    Nope, unfortunately not yet. Some day, I hope? In the meantime, you can work around this issue by importing from a card reader, or the hard drive, rather than from the camera directly.

    Thanks,
    Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hello.

    It seems that LR4 don't take into account user's time zone when creating folders and sorting pictures during import.

    For example:
    My Time Zone is GMT+4.
    Pictures with DateTime = 28/03 20:07 were placed into 2012-03-29 folder (folder with wrong date).
    At the same time pictures with Date=28/03 but time before 20:00 were placed into folder 2012-03-28 (no error here)

    Please see enclosed screenshot.


    This reply was created from a merged topic originally titled
    LR4 places some files to a folder with wrong date during import (Time zone related bug).
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Looks like this bug remains in LR4. It's a big annoyance having to move files after doing an import organized by date.

    I'm sure it does not take 9 moths to fix. Probably it's sitting at the bottom of the bug tracker. Is anyone actually looking into solving this?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Yup, it's still on the list. :-) Sorry for the wait. In the meantime, if you'd like to work around the problem now, you can use a card reader when you import. Bug only happens when importing directly from a connected camera. (If your experience is different than that, please let me know.)

    Thanks,
    Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • In Lightroom 4, when importing photos directly from camera (USB), LR puts some images into wrong date folder. Seems it doesn't check cameras time settings (timezone and summer time settings).
    For example, photo taken on 18th of May at 22.05 pm, LR puts it in 19-05 folder although it shows correct exif data (my time settings in nikon d90 are: gmt +2, and automatic daylight saving time option is "on")

    This reply was created from a merged topic originally titled
    LR4 imports doesn't check camera's time settings and imports into wrong date folderlr4.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Just installed LR4.1 release, still seems to be there?
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    When I import videos from my iPhone with Lightroom (even LR4) I choice to rename the file during import:
    Format: "Date (YYYYMMDD)_HourMinuteSeconde_iPhone_OriginalFilename.
    Wrong time in renamed filename after import captured video from an iPhone.
    Unfortunately the filename is exactly 1hour later than the video is captured in meta data.
    If I import it without rename the file during import and do the rename later (via library --> rename photo) the filename is correct.
    These bug already exists a few versions earlier in LR3.
    Now in LR4 it's back :-(

    This reply was created from a merged topic originally titled
    Lightroom: Wrong time in renamed filename after import captured video from an iPhone..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m amused
    I have Lightroom 4.1 64bit for Windows installed and experience following issue: When I import the exposures from my Nikon D7000 sometimes the importer splitts the files into two different folders, even though the exposure date is from the same day.
    I presume that there is a problem with date comparison. I live in the timezone Berlin, Rome, Vienna; the camera shows the correct time (additional info is UTC+1; summertime) and my pc is synchrone. When I import the exposures, all files with time greater 22:00 are put into a folder with exposuredate + 1. It seems as if the importer treats the filedate as plain UTC, adds 1 hour (UTC+1) PLUS adds another hour for summertime.
    Is this problem already known?

    This reply was created from a merged topic originally titled
    Wrong folderdate on import of exposures in Lightroom 4.1.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I'm using a filename template that includes the photo/video hour, minutes, and seconds. When I import videos from my iPhone 4S running iOS 6.0 into Lightroom 3.6 the hour looks like it is GMT, whereas for pictures it is in timezone time. So, for example, I'm in the mountain timezone, so a video taken at 12:00:00 mountain time gets 18:00:00 in its filename. Photos get the 12:00:00.

    I really don't care too much which way it goes (although for consistency it would be nice to be GMT so timezone doesn't play into it). I really just want them to be consistent so sorting works.

    Here's the strange thing. If I batch rename the videos the filenames then reflect the timezone time! I'd use this as a workaround, but I also like to include the original camera filename in the final filename, and there's no way to get at that when renaming. (Maybe I need to move away from including the original filename...)

    Any ideas? Or is this just a bug?

    This reply was created from a merged topic originally titled
    When importing videos from an iPhone into Lightroom 3.6, the "hour" field value included in the filename is different from that of photos..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    When I import photos from my digital camera (Sony DSC-RX100) into Lightroom 4, the photos are placed into the wrong date folders.

    This reply was created from a merged topic originally titled
    Wrong folder dates during camera import.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Is there any other workaround to this problem? It is causing hundreds of duplicates to be added to my collection. I use an iPhone so the workaround of using a card reader is not practical not is the directory as it would require me copying all the files from my camera and probably break duplicate detection.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Hi Jeffrey,

    As mentioned in the comments above, you can work around this issue by importing from a card reader, or the hard drive, rather than from the camera directly.

    Thanks,
    Ben
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • Also experience this bug with LR 4.3 and a Nikon D7000 connected via USB. (Currently don't own a Card Reader)
    Camera and computer are configured to Australian time zone.

    Just posting because I would like to keep an eye on this thread.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • This reply was removed on 2013-01-26.
    see the change log
  • I have seen quite few anomalies in LR4.3 and LR4.x with how time stamps are used. I live in Australia - this is important because the bugs are around time zone adjustment (I think)

    Here is one specific problem: I have a Nikon D90, I attached the camera to my computer and select import using LR4.3. The photo to be imported is taken at (Time stamp on camera) 31 Jan 2013, 18:26:45. My camera is set to GMT +11 hrs which is the summer time for the area I'm in (ie the 11 hrs includes daylight saving). When the thumb nail is shown before I hit the import button , if I mouse over the thumbnail, the time is shown as 1 Feb 2013 05:26:46. So 11 hrs and 1 sec more. LR also tells me it will put the import into the 2013/2 folder which it needed to create (todate I only have 2013/1 folders) Then I import using LR to rename the filename using the date time. It does this using the correct date time ie 20130131_18-26-45 but puts the import into the 2013/2 folder.

    The 11hrs and 1 sec suggests (ie the extra second suggests) it's getting a timestamp from somewhere else and then adding the GMT adjustment. All time fields in the metadata shown in LR4 are all 18:26:45.

    BTW - other problems I have are the otherway around where LR4 is using GMT as my local time - to fix some of these i can go into Edit capture time (don't touch/change anything) which shows the correct time (ie GMT+11) and execute. It appears that LR4 is picking up different timestamps in different bits of code

    This reply was created from a merged topic originally titled
    Lightroom: Problems with Capture time in Lightroom 4.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I can confirm that with LR4.3 this issue still occurs. My workaround is that I still import the photos straight from the camera, but without renaming them during the import. Once import is finished, I rename them via Library > Rename photo. UTC is disregarded, as it should and time shows up correctly.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    It still fails with Lightroom 5 when in the ICT (UTC+7) time zone and pictures are taken in the evening.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m very disappointed
    Well it's Oct. 2013, more than 2 years since this thread was posted (2011-07-21) and in my LR4.4 and LR5 above comment, this issue has still not been resolved.
    Please don't tell me to add another step to my workflow, (Use a card reader), work out the issue and fix it.

    If you go to the About tab, there are many Engineers/Managers that have signed off on this product. The shame sits with them if they do not clear the problem tickets before releasing the product.

    Engineering
    Jingyuan Bai, Simon Chen, Kjetil Drarvik, Julie Kmoch, Brian Kruse, Ying Liu, Peter Merrill, Andrew Rahn, Kevin Tieskoetter, Jianping Wang, Max Wendt, Ben Zibble, Yu Zhao, Qiang Zhu.

    Camera Raw Engineering
    Eric Chan, Thomas Knoll, Zalman Stern.

    Quality Engineering
    Kelly Castro, Tony Francesconi, Dan Gerber, Paul Kleczka, Shoji Kumagai, Baichao Li, Xin Lu, Craig Marble, Chuntang Pan, Tomoko Shinji, Mark Soderberg, Becky Sowada, Dan Tull, Jeff Van de Walker, Benjamin Warde, Xiaokang Wu, Xin Wu.

    Camera Raw Quality Engineering
    Heather Dolan, David Franzen, John Kwon, Adriana Ohlmeyer, Michelle Qi.

    Release Engineering
    Zach Nelson

    User Experience & Interface Design
    Phil Clevenger, Phil Lu.

    Evangelism
    Julieanne Kost

    Program Management
    Melissa Itamura

    Product Management
    Tom Hogarty, Sharad Mangalick.

    Product Marketing
    David Auyeung, Whitney McCleary, Pam Sogge.

    Prerelease
    Pallab Jyotee Hazarika, Benjamin Warde.

    International Team
    Rose Lu, Annie Tai, Susie Wang, Lily Wen.

    Administration
    Michele Dahlberg, Samantha Wallace.

    Technical Services
    Tina Carter, David Metzger, Brett Nemecek, David Baxter, Kaori Oikawa, Mandhir Bhatia.

    Legal
    Heather Barrett, Birgit Young.

    Adobe Labs
    Daniel Taborga

    Adobe Japan
    Muneo Tochiya

    Community Help and Learning
    Anita Dennis, Chandra Shekhar Puri, Phyllis Howell, Michael Salinero.

    User Research
    Graeme Mott, Marsha Tjandra

    MediaIO
    Jason Bartell, Rich Gerber, Jamie Gjerde, Eric Hanson, Alan Erickson, Dan McCormick, David McGavran, Brad Pillow, Eric Sanders, Nick Schlott, Nariman Sodeifi.

    Flash Player Engineering

    Core Tech Management
    Ranjit Desai, Erik Boe, Jane Bond, Lori Tregoning, Jeff Jiao.

    Adobe Metadata (XMP)
    Frank Biederich; Alan Lillich; Hartmut Warncke; Joerg Ehrlich; Samy Makki; Stefan Makswit, Thorsten Schneider.

    Color Management
    Ken Kameda, Manish Kulkarni.

    JPEG
    Rahul Gupta, Sunil T.M., Shiladitya Bose, Puneet Kumar Garg, Rekha Agarwal.

    Core Tech Release Engineering
    Todd A Burke, David Casey, Mike Houser, Mike Price, Greg Wootton.

    Operations
    Diemay Nagase, Carolyn Young, Beverly King, Donna Kennedy, Deb Hancock, Ben Chan, Maria Jeronimo, Carrie Otto, Christopher Moehrke, Irene Smith, Alina Cristina Constantinescu, Stephanie Heng, Yeng Kar Lim, Diana Harwood, Jackie Cameron, Linda Mitchell, Sandra Stoecker, Cecilia Ramos, Ruth Manson, Felicity Alvarez.

    Management
    Shantanu Narayen, David Wadhwani, Winston Hendrickson, Mark Hamburg, Maria Yap, Tom Hogarty, Melissa Itamura, Julie Kmoch, Becky Sowada.

    Lightroom Babies
    Lightroom 1: Gavin Hamburg, Hazel Gerber
    Lightroom 2: Milo Zibble Kelly, Halcyon Stotzner, Evan Tull
    Lightroom 3: Harper Hogarty, Benjamin Zibble Kelly, Ayla Scouten, James Tull
    Lightroom 4: Tiernan Hogarty, Oliver Tieskoetter, Dudu Wang, Nora Kleczka
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    I wondered why all these great photographers use Lightroom but never complain about this longstanding bug as they travel the world. Then I realized that it was a Windows only bug and they all use Macs..
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m extremely frustrated
    Is there going to be a fix released for this issue any time soon? It is unbelievable to think this issue has gone unresolved for over two years.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • This reply was removed on 2014-02-23.
    see the change log
  • I’m frustrated
    This really needs to be fixed in the next update.
    As a software developer myself, I know the fix will be relatively simple. Also as this is a workflow/productivity issue, it should really be considered a high severity issue for a core workflow/productivity application like LR.

    Adding an extra step to your workflow is really not an acceptable solution for a product advertised to simplify your workflow.

    Everyone else, please bump this thread if this is also important for you.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    It's Lr 5.4 now, three years later and the bug persists... unbelievable!
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned

  • I’m frustrated
    Anyone try this in LR 5.6? I ran into this while demoing LR and it has kept me from making a purchase.
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated kidding, amused, unsure, silly happy, confident, thankful, excited indifferent, undecided, unconcerned