Author Topic: Export user defined text data file  (Read 6757 times)

Offline kdahlstrom

  • Newcomer
  • *
  • Posts: 1
    • View Profile
Export user defined text data file
« on: August 14, 2006, 01:15:38 PM »
Is there anyway to export a text data file (comma delimited or .csv) of user defined data fields. For selected iamges within Photo Mechanic. My editor requires a comma delimited file for the database on the server when uploading images.

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Export user defined text data file
« Reply #1 on: August 14, 2006, 01:56:11 PM »
Is there anyway to export a text data file (comma delimited or .csv) of user defined data fields. For selected iamges within Photo Mechanic. My editor requires a comma delimited file for the database on the server when uploading images.

Yes, use the File->Export->Text... command.  You can export any of the image variables that you like.  Put commas between them and export to a single file and you'll have a CSV text file.

HTH,

-Kirk

Offline editor@africamediaonline.

  • Newcomer
  • *
  • Posts: 15
    • View Profile
Re: Export user defined text data file
« Reply #2 on: January 05, 2024, 01:07:04 PM »
Hi Kirk,

I have been successfully exporting most fields from a catalogue into a spreadsheet. I am using variables such as this:

{filename}{tab}
{title}{tab}
{headline}{tab}
{description}{tab}
{captionwriter}{tab}
{keywords}{tab}
{persons}{tab}
{featuredorgname}{tab}
{photog}{tab}
{copyright}{tab}
{credit}{tab}
{source}{tab}
{copyrighturl}{tab}
{usage}{tab}
{iptcdate}{tab}
{location}{tab}
{city}{tab}
{province}{tab}
{country}{tab}
{countrycode}{tab}
{instructions}{tab}
{contactaddress}{tab}
{contactcity}{tab}
{contactstate}{tab}
{contactzip}{tab}
{contactcountry}{tab}
{contactemail}{tab}
{contactphone}{tab}
{contactweb}{tab}
{imagesuppliername}{tab}
{imagesupplierid}{tab}
{imagesupplierimageid}{tab}

One field, however, that I do not have a variable for is Registry Image Identifier. How do I export that field? It seems to have no variable.

Thanks

Dave

Online ahoward

  • Camera Bits Staff
  • Hero Member
  • *****
  • Posts: 973
    • View Profile
Re: Export user defined text data file
« Reply #3 on: January 05, 2024, 04:25:52 PM »
There are currently no variables to extract the information from the various tables in the metadata.

Offline editor@africamediaonline.

  • Newcomer
  • *
  • Posts: 15
    • View Profile
Re: Export user defined text data file
« Reply #4 on: January 08, 2024, 03:51:33 AM »
Thank you for your response ahoward. Can I assume, then, that there is no way of extracting that data using Photo Mechanic and I need to look for another means of doing it?

Thanks so much,

David

Offline Kirk Baker

  • Senior Software Engineer
  • Camera Bits Staff
  • Superhero Member
  • *****
  • Posts: 25020
    • View Profile
    • Camera Bits, Inc.
Re: Export user defined text data file
« Reply #5 on: January 08, 2024, 11:57:57 AM »
David,

Can I assume, then, that there is no way of extracting that data using Photo Mechanic and I need to look for another means of doing it?

That's correct.

-Kirk