Author Topic: Variable Request, Export Video Clip Duration to Text File...  (Read 5895 times)

Offline smf

  • Newcomer
  • *
  • Posts: 10
    • View Profile
I'd like to export video clip duration (00:00:11:15) to a Text file so I can drop it into an excel file.
Thanks,

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24730
    • View Profile
    • Camera Bits, Inc.
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #1 on: May 05, 2014, 09:27:36 PM »
I'd like to export video clip duration (00:00:11:15) to a Text file so I can drop it into an excel file.

I don't understand what it is that you're wanting.  Please explain in greater detail.

-Kirk

Offline Hayo Baan

  • Uber Member
  • ******
  • Posts: 2552
  • Professional Photographer & Software Developer
    • View Profile
    • Hayo Baan - Photography
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #2 on: May 05, 2014, 11:10:09 PM »
I think what he is looking for is a variable for the duration of a video so he can use the text exporter to create a list of files and durations to then import into an excel file.

Something like this: {filename},{duration}
Hayo Baan - Photography
Web: www.hayobaan.nl

Offline smf

  • Newcomer
  • *
  • Posts: 10
    • View Profile
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #3 on: May 06, 2014, 08:56:44 AM »
That's right, "00:00:13:19" is the time duration for a video clip, getty images wants the information in an excel sheet. The excel column is called clip length.
The problem is that I have over 100 clips that all have different clip lengths. And manually typing is out of the question; I can open the clips individually in Quicktime pro and cut and paste the duration into my excel sheet, but that sucks. So, I am asking if there's a variable that will batch export video clip duration to the text exporter under File > Export. So I can then cut and paste the info into an excel sheet.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24730
    • View Profile
    • Camera Bits, Inc.
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #4 on: May 06, 2014, 09:09:22 AM »
That's right, "00:00:13:19" is the time duration for a video clip, getty images wants the information in an excel sheet. The excel column is called clip length.
The problem is that I have over 100 clips that all have different clip lengths. And manually typing is out of the question; I can open the clips individually in Quicktime pro and cut and paste the duration into my excel sheet, but that sucks. So, I am asking if there's a variable that will batch export video clip duration to the text exporter under File > Export. So I can then cut and paste the info into an excel sheet.

There currently is no variable that extracts the duration of a video.

-Kirk

Offline Hayo Baan

  • Uber Member
  • ******
  • Posts: 2552
  • Professional Photographer & Software Developer
    • View Profile
    • Hayo Baan - Photography
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #5 on: May 06, 2014, 10:44:45 AM »
As long as PhotoMechanic does not offer the {duration} variable, you can easily accomplish the same from the command line using exiftool. If you use e.g.,
Code: [Select]
exiftool -csv -Duration file.mov or
Code: [Select]
exiftool -csv -Duration *.mov
The output of this command is already formatted as a comma separated file (filename,duration) and can thus be easily imported into excel.

You can download exiftool from the website of the maker.

Hope this helps,
Hayo
Hayo Baan - Photography
Web: www.hayobaan.nl

Offline smf

  • Newcomer
  • *
  • Posts: 10
    • View Profile
Re: Variable Request, Export Video Clip Duration to Text File...
« Reply #6 on: October 01, 2014, 12:18:03 AM »
Here we are 4 months later and I need to export clip duration again.
I thank you for your option, but I'm not so sure how to use the exiftool on a mac.
I went to the site you posted and it seems easy enough.
But with that said I'm still not that savvy with what you're talking about.
Thanks again Hayo Baan. Hopefully PM will post the variable some day.

Best,