Author Topic: Extracting the metadata as a .csv  (Read 3256 times)

Offline BDeRango

  • Newcomer
  • *
  • Posts: 1
    • View Profile
Extracting the metadata as a .csv
« on: November 03, 2015, 10:54:57 AM »
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!

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 21338
    • View Profile
    • Camera Bits, Inc.
Re: Extracting the metadata as a .csv
« Reply #1 on: November 03, 2015, 02:05:53 PM »
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

Offline Simon Jacobs

  • Newcomer
  • *
  • Posts: 24
    • View Profile
Re: Extracting the metadata as a .csv
« Reply #2 on: January 15, 2016, 07:04:08 AM »
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

Offline Simon Jacobs

  • Newcomer
  • *
  • Posts: 24
    • View Profile
Re: Extracting the metadata as a .csv
« Reply #3 on: January 15, 2016, 07:05:21 AM »
Ah, just put a carriage return in... :)

Brilliant!

Offline Simon Jacobs

  • Newcomer
  • *
  • Posts: 24
    • View Profile
Re: Extracting the metadata as a .csv
« Reply #4 on: January 15, 2016, 07:22:52 AM »
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
« Last Edit: January 15, 2016, 08:51:40 AM by Simon Jacobs »

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 21338
    • View Profile
    • Camera Bits, Inc.
Re: Extracting the metadata as a .csv
« Reply #5 on: January 15, 2016, 09:25:20 AM »
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

Offline Simon Jacobs

  • Newcomer
  • *
  • Posts: 24
    • View Profile
Re: Extracting the metadata as a .csv
« Reply #6 on: January 15, 2016, 09:32:50 AM »
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.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 21338
    • View Profile
    • Camera Bits, Inc.
Re: Extracting the metadata as a .csv
« Reply #7 on: January 15, 2016, 11:27:00 AM »
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