Author Topic: Mass Import of IPTC from Spreadsheet  (Read 4324 times)

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Mass Import of IPTC from Spreadsheet
« on: January 19, 2021, 01:44:32 AM »
Hi
Have gone thru previous threads and tried various options but still unable to do this.

- is the attachment here which I have saved as a Tab delimited file the correct format
- did step as below with \ as delimiter

In Copyright enter:
/{filename}#2/
In Keywords enter:
/{filename}#3/
Then apply the IPTC Stationery Pad to selected photos.

- however the result i get is /CUL-IS09AG0KL.jpg#3/ in keyword and /CUL-IS09AG0KL.jpg#2/ in copyright.

Please guide where am i going wrong.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25024
    • View Profile
    • Camera Bits, Inc.
Re: Mass Import of IPTC from Spreadsheet
« Reply #1 on: January 19, 2021, 07:20:40 AM »
Hi
Have gone thru previous threads and tried various options but still unable to do this.

- is the attachment here which I have saved as a Tab delimited file the correct format
- did step as below with \ as delimiter

In Copyright enter:
/{filename}#2/
In Keywords enter:
/{filename}#3/
Then apply the IPTC Stationery Pad to selected photos.

- however the result i get is /CUL-IS09AG0KL.jpg#3/ in keyword and /CUL-IS09AG0KL.jpg#2/ in copyright.

Please guide where am i going wrong.

You say that your delimiter is the backslash (\), so what happens if you use it instead of the forward slash (/) as you say you entered?

\{filename}#2\
and
\{filename}#3\

Does it work OK then?

-Kirk

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Re: Mass Import of IPTC from Spreadsheet
« Reply #2 on: January 19, 2021, 11:07:59 PM »
Thanks for the prompt response Kirk.

Oops, changing \ worked along with changing the nos starting from 1.

So, if i use attached file along with appropriate \{filename}#1\

it works but i get results in two fields Caption and Keywords with "

"Hubbard Glacier, Alaska, USA"
"Hubbard, Glacier, Alaska, USA, Abroad, Color, Colors, Frozen, glacial, Horizontal, Landmark, landscape, mountain, mountains, nature, nobody, Ocean, Outdoor, Photography, scenic, sea, snow, United, States, of, America, DPA-AAA, AAA-259471"

How could i please avoid the "
And then why doesnt the " show in other fields.

Also the filename in the Excel and image needs to be exact jpg or JPG. Is there anyway to circumvent that. As my images are mixed with jpg and JPG.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25024
    • View Profile
    • Camera Bits, Inc.
Re: Mass Import of IPTC from Spreadsheet
« Reply #3 on: January 20, 2021, 09:02:39 AM »
Thanks for the prompt response Kirk.

Oops, changing \ worked along with changing the nos starting from 1.

So, if i use attached file along with appropriate \{filename}#1\

it works but i get results in two fields Caption and Keywords with "

"Hubbard Glacier, Alaska, USA"
"Hubbard, Glacier, Alaska, USA, Abroad, Color, Colors, Frozen, glacial, Horizontal, Landmark, landscape, mountain, mountains, nature, nobody, Ocean, Outdoor, Photography, scenic, sea, snow, United, States, of, America, DPA-AAA, AAA-259471"

How could i please avoid the "
And then why doesnt the " show in other fields.

Remove the quotes from your text file.  They don't need to be there.  Some of your columns have quotes, some don't.  Remove all of them.

Also the filename in the Excel and image needs to be exact jpg or JPG. Is there anyway to circumvent that. As my images are mixed with jpg and JPG.

This cannot be changed.  How are you generating your list of names?  If you get a directory listing and paste it into the first column, the names will be correct.

-Kirk

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Re: Mass Import of IPTC from Spreadsheet
« Reply #4 on: January 21, 2021, 03:53:31 AM »
Thanks so very much Kirk.

The excel doesn't show " but the text does. I then manually removed it in the text file tho. Any idea why this might be the case.

Directory listing worked perfectly.

Another query tho - how could i add Licensor url field in the IPTC.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25024
    • View Profile
    • Camera Bits, Inc.
Re: Mass Import of IPTC from Spreadsheet
« Reply #5 on: January 21, 2021, 09:07:14 AM »
Thanks so very much Kirk.

The excel doesn't show " but the text does. I then manually removed it in the text file tho. Any idea why this might be the case.

No idea why Excel would do that.  But if the data you give to PM has quotes in it then quotes you will get.

Directory listing worked perfectly.

Another query tho - how could i add Licensor url field in the IPTC.

You would use the Edit button in the Metadata Template dialog to bring up the Licensors dialog and enter your code replacement sequence in the URL field of the Licensors dialog.

-Kirk

Offline agbob

  • Newcomer
  • *
  • Posts: 9
    • View Profile
Re: Mass Import of IPTC from Spreadsheet
« Reply #6 on: January 25, 2021, 02:15:11 AM »
Thanks very very much for all your assistance Kirk.