Extracting the metadata as a .csv

[BDeRango]

Hello! I am working with Photo Mechanic version 5.0 using Windows 7.

I would like to extract the metadata (both EXIF and IPTC) from a batch of images and save it as a .csv so I can import it into a GeoDatabase. Is there a way that I can do this with Photo Mechanic?

Thanks!

[Kirk Baker]

Hello! I am working with Photo Mechanic version 5.0 using Windows 7.

I would like to extract the metadata (both EXIF and IPTC) from a batch of images and save it as a .csv so I can import it into a GeoDatabase. Is there a way that I can do this with Photo Mechanic?

Sure.  Use the Export dialog.  Choose the Text exporter template.  Use the appropriate variables like so:

{filename}{tab}{caption}{tab}{width}{tab}{height}{tab}{date}{nl}

(put as many variables as you want with tabs in between them.)

Set it to export as a single file.  It will be a tab-separated text file.

HTH,

-Kirk

[Simon Jacobs]

This is excellent.

Is there a way to put a line break in so that I don't have to put them in manually between each extracted caption?

Thanks.

SJ

[Simon Jacobs]

Ah, just put a carriage return in...

Brilliant!

[Simon Jacobs]

OK, mainly sorted but i'd like to extract just the file  sequential frame NUMBER if that's possible?

ie: If the Filename is: POU150115_01.jpg I'd like just the 01,02,03 etc part to be extracted.

I tried putting a sequence variable in but it did not increment. Just named them all 83!

Or could I put a sequence into another field and pull that in to the export variables?

Any help appreciated.

SJ

[Kirk Baker]

Simon,

OK, mainly sorted but i'd like to extract just the file  sequential frame NUMBER if that's possible?

ie: If the Filename is: POU150115_01.jpg I'd like just the 01,02,03 etc part to be extracted.

I tried putting a sequence variable in but it did not increment. Just named them all 83!

Or could I put a sequence into another field and pull that in to the export variables?

Don't bother with the sequence variable.  Use Variable Substring Extraction:

http://wiki.camerabits.com/en/index.php?title=User_Manual_Flat_View#Variable_Substring_Extraction

{filenamebase:-2,2} should do the trick.

HTH,

-Kirk

[Simon Jacobs]

Good heavens!

Is there anything you didn't think of?!

I genuinely don't know how I would run my business without PM...

Thank you Kirk.

[Kirk Baker]

Simon,

Good heavens!

Is there anything you didn't think of?!

Yes.  That's why we have so many Feature Requests.

I genuinely don't know how I would run my business without PM...

Thank you Kirk.

You're welcome!

-Kirk