Author Topic: Import metadata from excel file to iptc fields  (Read 5155 times)

Offline MarcoDG

  • Newcomer
  • *
  • Posts: 8
    • View Profile
Import metadata from excel file to iptc fields
« on: April 27, 2012, 08:00:02 AM »
Hello,

I am running Photo Mechanic version 4.6.8 and I run Mac OS X 10.6.8 on my Intel-based Mac.
As I'm french, my writing might not be perfect ... I'm sorry for that.  ;)
I have read a few topics on the forum about this excel and metadata issue but ... I can't succeed with the posts I've read and as it is important to me, I bring the topic again.

I need to import data from a excel sheet to the iptc fields of many images.
Each image must have specific data that is gathered on 6 cells of the excel sheet. The first cell is the filename. The other 5 cells contain specific data related to the image.
Here is a line of the spreadsheet : M_2011-3-83.tif   2011.3.83   Plats   E1.T10.B33   33.5   65   160,6

I've understood that I have to save the excel file as a csv file or as a tab seperated text file.
And then import this file in the code replacement dialog box.
And then go to the IPTC Stationery pad.

But then I do not know what to do....

Could you help me with step by step explanation please ?

Thanks a lot.

Marc.



[attachment deleted by admin]

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24731
    • View Profile
    • Camera Bits, Inc.
Re: Import metadata from excel file to iptc fields
« Reply #1 on: April 27, 2012, 09:15:35 AM »
Marco,

You definitely only should save the file as a tab-separated text file, not a comma separated text file.  In order to help you further I would need to know what fields of the IPTC dialog you want which columns of data to be placed?

-Kirk

Offline MarcoDG

  • Newcomer
  • *
  • Posts: 8
    • View Profile
Re: Import metadata from excel file to iptc fields
« Reply #2 on: April 27, 2012, 12:01:13 PM »
Thanks Kirk,

I've changed a little the line in order to mix 2 cell in one as the size of the document.

2011-3-83.tif   2011.3.83   Plats   E1.T10.B33   33.5 x 65 cm

The first data is the filename and do not need to be put in any iptc field.
The second data is 2011.3.83 is the name of the object and needs to go in the field "object name"
The next data "plats" is the "Headline"
Then next is E1.T10.B33 should go in "Edit status"
Next 33,5 x 65 cm is the size and should go to "Caption"

I've saved the excel file as a text file separated by tabs.
Please what value do I have to put in the little box "delimeted character" of the Code Replacement dialog box as I use a tab-separated text file ?

Thanks.
Marc


[attachment deleted by admin]

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 24731
    • View Profile
    • Camera Bits, Inc.
Re: Import metadata from excel file to iptc fields
« Reply #3 on: April 27, 2012, 01:06:21 PM »
Marc,

I've changed a little the line in order to mix 2 cell in one as the size of the document.

2011-3-83.tif   2011.3.83   Plats   E1.T10.B33   33.5 x 65 cm

The first data is the filename and do not need to be put in any iptc field.
The second data is 2011.3.83 is the name of the object and needs to go in the field "object name"
The next data "plats" is the "Headline"
Then next is E1.T10.B33 should go in "Edit status"
Next 33,5 x 65 cm is the size and should go to "Caption"

I've saved the excel file as a text file separated by tabs.

OK.  First select all of your files that you want to import data into.  Then open up the IPTC Stationery Pad.  Clear out any check boxes preceding the fields you don't want to change.  Then in the Object Name field enter:

\{filename}\

In the Headline field enter:

\{filename}#2\

In the Edit Status field enter:

\{filename}#3\

In the Caption field enter:

\{filename}#4\

If your images already have captions make sure to set the '+' checkbox preceding the Caption field as well, or you will lose the existing captions.

Now Apply the Stationery Pad.  Your images will now have the data imported into them.

Quote from: MarcoDG
Please what value do I have to put in the little box "delimeted character" of the Code Replacement dialog box as I use a tab-separated text file ?

Make sure it is the '\' character or my above examples won't work.

HTH,

-Kirk