FileMaker and ExifTool

[Archive]

[Originally posted by principe on 2008-02-19 19:48:06-08]

Hi, I am new to this Forum... a little presentation:

photographer, I am using Filemaker to store all Metadata and related Info about images. I am publishing a runtime of this solution, which can work as on the Metadata side as on the administration side. The solution have 34 related databases.

Good, on a first time I used the TroiFile to ingest Metadata into image, but this plug-in only work on Legacy IPTC fields.
Looking for XMP compatibility, I begin a jorney with ExifTool, creating script from Filemaker, which send commands to The Terminal and execute ExifTool.

I have experienced some little problem:

1) when I write the "xmp-dc:Subject" tag and I verify in Photoshop File Info, my keywords are quoted ("key1, key2, key3, "). The same happens with Subject Codes and Scene. Those fields have in common that are bags.

2) XMP-iptcCore  tags are correctly written with exception of Country and State/Region.
 
There is the two command lines:

exiftool -XMP-iptcCore:CreatorContactInfoCiAdrCtry='FileMakerCountryfield' & Pathtofile

exiftool -XMP-iptcCore:CreatorContactInfoCiAdrRegion='FileMakerRegionfield' & Pathtofile

3) I cannot find some fields to write n the Photoshop File Info, the information exist if I retrieve from ExifTool, but don't appears in File Info: Job Identifier, Instructions and Right Usage Terms.

ExifTool is a great tool, and implementing it in my solution allow me to create a full XMP compatibility, which is the new standard about Metadata. I appreciate suggestions,

Sincerely,

Leonide Principe

http://www.leonideprincipe.com/photokey" target="_blank">http://www.leonideprincipe.com/photokey

[Archive]

[Originally posted by exiftool on 2008-02-19 20:00:47-08]

Hi Leonide,

I'm not sure I understand all your problems correctly, but
here goes:

1) Did you write the tags separately (ie. "-xmp-dc:subject=key1 -xmp-dc:subject=key2 ...").
This  is the most common mistake.

2) so this doesn't work?:

Code:

> exiftool a.jpg -XMP-iptcCore:CreatorContactInfoCiAdrRegion=v
    1 image files updated

> exiftool a.jpg -XMP-iptcCore:CreatorContactInfoCiAdrRegion
Creator Region                  : v

3) Try writing the tags in Photoshop and use ExifTool to see where
they were written.

- Phil

[Archive]

[Originally posted by principe on 2008-02-21 18:26:48-08]

Hi Phil,

Thanks for your useful answer, I have solved two fields with the write-to-photoshop-and-see-exiftool.

From Contact Country and Contact Region, I am trying different options in all directions... no way.

From the "xmp-dc:subject" tag, the problem is that I am writing a field which contains all my Keywords (it is a flat text: key1, key2, key3, ...), and ExifTool are treating my whole keyword set as a unique word. Considering that I am sending 50-100 words on each image, I cannot use the one-by-one keyword system. I tried to substitute the comma and space ", " in my Filemaker field with "rdf:li" separator... don't work. It seem that codes are generated by xmp.

If the syntax  "-xmp-dc:subject=key1 -xmp-dc:subject=key2 ..." cannot be changed, I need to split my Keyword field , but with a variable number of words I don't show a light, until now.

Thank again, Leonide

[Archive]

[Originally posted by exiftool on 2008-02-21 22:46:10-08]

There are a couple of ways around this.  The best way would be
to write your own script using the ExifTool API to do exactly
what you want instead of trying to go through the exiftool
application.  But this can't be done if you want to use the
Windows executable version.

The other option is to do as you say and split the Keyword
field.  I don't see this as being very difficult.  All you have
to do is substitute ', ' for '" -xmp-dc:subject="' wherever
it occurs in your string, then use '-xmp-dc:subject="string"'
on the command line.  This will work even for hundreds of
keywords on Unix, but there may be a command-line limitation
in Windows.  If the length of the command line turns out to
be a problem, you should look into writing the arguments to
a file and using the -@ option.

- Phil

[Archive]

[Originally posted by principe on 2008-02-25 01:10:05-08]

Phil,

now all works very fine with exception of DateCreated.

All bag fields like Keywords writes line-by-line, separated by the proper code.

I am writing both Legacy IPTC and IPTC Core in just one click from Filemaker.

From the Date Created side:

I used -XMP-photoshop:DateCreated from ExifTool default,

I used -XMP-xmp:MetadataDate, -xmp:MetadataDate and -XMP:MetadataDate
I used -xmlns-photoshop:CreatedDate, the tag originated from IView Pro,

and I used -xap-photoshop:CreatedDate, the tag originated from Photoshop.

I used variations of those tags too... nothing.

The strange is that all others photoshop tags (Headline, Instructions, Source...) are working normally.

Somehow I am very grateful, and I trust in your new answer...

Sincerely, Leonide

[Archive]

[Originally posted by exiftool on 2008-02-25 13:43:20-08]

I assume that your problem is other software isn't seeing your
creation date tag?  You will find the answer by looking at the
date that is being displayed, and using exiftool to find the tag
in the file with this date.  (Did you try setting EXIF:CreateDate, or
XMP-exif:CreateDate, or IPTC:DateCreated and IPTC:TimeCreated?)

- Phil

[Archive]

[Originally posted by principe on 2008-02-26 03:15:51-08]

No way, Phil,

I am here full-time on DateCreated tag, I tried as possibilities as I can.

If I write the date in Bridge and iView Pro and I get the Info through ExifTool I have the tag XMP-photoshop:DateCreated.

When I reverse the situation with the same tag, sending from ExifTool, it don't write in the file.

More strange is that both IPTC:DateCreated and XMP-photoshop:DateCreated don't works.

My aim is to write in the file all Photoshop File Info fields (Contact, Content, Image, Status) in both format Legacy IPTC (IIM0 and IPTC Core (XMP). I have all fields of both formats, excluding DateCreated, in both formats too.

I tried to change the date format in the command line YY/MM/DD and MM/DD/YY or YYYY... no way

The command line do nothing.

Thanks for help, Leonide

[Archive]

[Originally posted by exiftool on 2008-02-26 13:00:22-08]

Hi Leonide,

I think you are not being accurate when you say that the information
is not being written.  Isn't the problem really that your application is not
reading it?

Since I don't have these applications, it may be difficult for me to help
any more.  But perhaps if you send me three (small) images, one before
the date is changed, and one each after changing the date with
Bridge and IView Pro.  My email is philharvey66 at gmail.com.

- Phil

[Archive]

[Originally posted by dericed on 2008-03-04 11:16:02-08]

Hi Leonide, I'm working on a similar solution combining Filemaker and exiftool. Did you set up your command line with exiftool -t -S -q -f -r and then list the individual tags? I'm having trouble finding a command line that will work best for a Filemaker import. Are you clearing out all the hyphens that show up to note empty fields.
Dave

[Archive]

[Originally posted by leslie on 2008-05-29 08:53:44-07]

I don't know if it helps but I have been having a few problems with the XMP-photoshop:DateCreated tag.

If I run exiftool from the command line it all seems to work fine. A check with exiftool -u -s -g1 clearly shows the tag.

If I try to run exiftool as part of the wrapper I have made exiftool writes that the XMP-photoshop:DateCreated Tag does not exist (or similar).

I had assumed that "something" was wrong with my wrapper since it worked from the commandline. I think the version is version 7. At any rate it is the version that installs with Ubuntu Hardy x64 from the repositories.

PS: Big thanks to you Phil!. I had a huge backlog of photos and once I have my wrapper editor sorted for new photos I am going to use exiftool to automatically update a couple of thousand old photos which have thier data stored in a spreadsheet.

[Archive]

[Originally posted by exiftool on 2008-05-29 11:09:36-07]

Hi Leslie,

I don't have many ideas about why your wrapper shouldn't
be working.  The most likely problem is a simply typo, but
also there could be a problem if you have two conflicting
versions of exiftool installed on your system.  I suggest trying
to write tags in EXIF and IPTC to see if these work.

- Phil

P.S.  I should have updated this thread to close the issue that
Leonide was having back in February.  The problem was the
date formatting which should needs to be in the format
"YYYY:MM:DD", and was solved via email exchange.