I'm enjoying my Mavic Air, but as someone else also have noticed: There seems to be a bug in the current firmware (v01.00.0400) regarding EXIF data for video files. Specifically; the Air seems to not record time stamps in video files.

This results in problems for software that tries to keep track of and catalog video files by date / time. In my case, Lightroom. When importing these files to Lightroom, none of the video files have a correct date or time. (Images have correct time stamps, this problem seems to only apply to video files.).

Using Exiftool (link) and just pulling the various date tags of one of the original video files directly from the sim card gives this result:

K:\DCIM\100MEDIA> exiftool -time:all -a -G0:1 -s DJI_0196.MP4
[File:System]   FileModifyDate                  : 2018:06:05 20:19:14+02:00
[File:System]   FileAccessDate                  : 2018:06:06 00:00:00+02:00
[File:System]   FileCreateDate                  : 2018:06:05 20:19:15+02:00
[QuickTime]     CreateDate                      : 0000:00:00 00:00:00
[QuickTime]     ModifyDate                      : 0000:00:00 00:00:00
[QuickTime:Track1] TrackCreateDate              : 0000:00:00 00:00:00
[QuickTime:Track1] TrackModifyDate              : 0000:00:00 00:00:00
[QuickTime:Track1] MediaCreateDate              : 0000:00:00 00:00:00
[QuickTime:Track1] MediaModifyDate              : 0000:00:00 00:00:00


Only 3 of 9 tags have values. And those three that do have values aren't used when importing into Lightroom. At least they aren't enough.

I haven't looked fully into this yet and and therefore I'm not sure exactly wich of these tags Lightroom needs, but I've found that the following workflow works for me to fix these files:

The following are instructions for a Windows PC. But Exiftool exists for Mac and I'm guessing the procedure will be the same, at least in principle.

• Copy the whole DCIM folder from your memory card to a folder on your hard drive (will include all images and video files)
  (Makes the next steps run a lot faster. Plus, you have a backup on your card in case something goes wrong.)
  
  In my case, the DCIM folder was copied to D:\12\AIR Import
  -
• Open Powershell (or Command prompt / CMD.EXE) in the copied 100MEDIA folder on your hard drive (D:\12\AIR Import\100MEDIA in my case).
  -
• Run the following command: (NB! One continous line)
  
  exiftool -v0 -progress -overwrite_original "-CreateDate<FileModifyDate" "-ModifyDate<FileModifyDate" "-TrackCreateDate<FileModifyDate" "-TrackModifyDate<FileModifyDate" "-MediaCreateDate<FileModifyDate" "-MediaModifyDate<FileModifyDate" "-FileCreateDate<FileModifyDate" *.MP4
  
  This will set the other Exif tags in all video files to the correct date and time. Depending on the size of your files, this could take some time. Luckily, Exiftool gives you progress information as it works with the files. Btw: This is for MP4 files. If your files are in MOV format, exchange the "*.MP4" part at the end of the command with "*.MOV".
  -
• When finished, run this command:
  
  exiftool -v0 -progress -overwrite_original "-CreateDate>FileModifyDate" *.MP4
  
  (Again: If your files are in MOV format, exchange the "*.MP4" part at the end of the command with "*.MOV".)
  -
• Final step: Import into Lightroom
  
  Import your DCIM folder with the modified video files from your hard drive into Lightroom. (Use Copy or Move files and Add to catalog when importing).
  

Here's the results pulling time stamps from one of the modified files (same thing that was done in the beginning of this post):

D:\12\AIR Import\100media> exiftool -time:all -a -G0:1 -s DJI_0196.MP4
[File:System]   FileModifyDate                  : 2018:06:05 20:19:14+02:00
[File:System]   FileAccessDate                  : 2018:06:05 20:19:14+02:00
[File:System]   FileCreateDate                  : 2018:06:05 20:19:14+02:00
[QuickTime]     CreateDate                      : 2018:06:05 20:19:14
[QuickTime]     ModifyDate                      : 2018:06:05 20:19:14
[QuickTime:Track1] TrackCreateDate              : 2018:06:05 20:19:14
[QuickTime:Track1] TrackModifyDate              : 2018:06:05 20:19:14
[QuickTime:Track1] MediaCreateDate              : 2018:06:05 20:19:14
[QuickTime:Track1] MediaModifyDate              : 2018:06:05 20:19:14
[XMP:XMP-xmp]   CreateDate                      : 2018:06:05 20:19:14+02:00
[XMP:XMP-xmp]   ModifyDate                      : 2018:06:05 20:19:14+02:00



I hope this information can be useful for others.

I'm also really hoping DJI will fix this in a future FW update. The above workflow works (at least for me it does), but it is a bit cumbersome and shouldn't be necessary.

This is awesome!  Fixed it and not too cumbersome.  Just put the commands in a .bat file.  Thank you for posting!

Legend. Thank you. I made a powershell script to do this - I've hard coded the USB drive letter - it's not the cleanest solution but as long as I remember to do it before importing to LR and the letter doesn't change this has resolved it!

Thanks. This really helps. Does anyone knows about a permanent fix either on Lightroom or Mavic?