Variable Request, Export Video Clip Duration to Text File...

[smf]

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,

[Kirk Baker]

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

[Hayo Baan]

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}

[smf]

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.

[Kirk Baker]

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

[Hayo Baan]

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

[smf]

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,