Author Topic: Caption + keywords to spreadsheeet - how?  (Read 2270 times)

Offline Old timer

  • Member
  • **
  • Posts: 55
    • View Profile
Caption + keywords to spreadsheeet - how?
« on: May 02, 2015, 06:20:11 PM »
Hi Kirk,

Can you supply the formula for this task: ?

Info from (4000) images needs to be on a spreadsheet (like this):

Image ID
Caption
Keywords
(this line for later use)
(this line for later use)
Shooting Date

Thank you in advance!

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Caption + keywords to spreadsheeet - how?
« Reply #1 on: May 02, 2015, 08:38:24 PM »
Sure.  Use the Text Exporter template in the Exporter dialog.  I don't know where your "Image ID" comes from, but you'll need the variable for that field.  Usually for a spread sheet you don't want each image's info to be on different lines--you want the data in different columns so that when you open up the file as a tab separated value file you get each piece of info in its own column.

For that you would use:

{variable for your Image ID}{tab}{caption}{tab}{keywords}{tab}{tab}{date}{nl}

If you really want each piece of info on its own line you would use:

{variable for your Image ID}
{caption}
{keywords}


{date}


That should do it.  Select all of the images, choose the option to put all items in a single file and export.

-Kirk

Offline Old timer

  • Member
  • **
  • Posts: 55
    • View Profile
Re: Caption + keywords to spreadsheeet - how?
« Reply #2 on: May 04, 2015, 11:55:14 AM »
Thanks Kirk, Seems to do exactly what I need.