Author Topic: Program Metadata to TAG translation  (Read 8332 times)

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 3693
Program Metadata to TAG translation
« on: January 08, 2016, 07:06:35 PM »
One problem that pops up sometimes is when is talking about what one program calls a metadata tag and what are the actual tags that are written.  I attempted to go though all of the metadata in my copy of Lightroom (v. 4.4) and make a translation between the two.  If anyone notices any errors or if a different version of Lightroom does things differently, let me know or post below and I'll add it in.

At some point, I'll try to do the same with some other programs I have access too. 

Let me know if anyone has any suggestions as well.


Lightroom MetadataActual Tags Written


Capture TimeEXIF:DateTimeOriginal
IPTC:DateCreated
IPTC:TimeCreated
XMP:DateCreated


Persons ShownXMP:PersonInImage


TitleXMP:Title
IPTC:ObjectName


LabelXMP:Label


RatingXMP:Rating


CaptionEXIF:ImageDescription
IPTC:Caption-Abstract
XMP:Description
Note: If there are multiple lines, Lightroom will use Carriage Returns in Caption-Abstract, but Line Feeds in ImageDescription and Description


User CommentEXIF:UserComment


GPS Data
  • GPS
  • Altitude
Writes to EXIF GPS block.  Will erase XMP GPS data if it exists.
GPSLatitudeRef
GPSLatitude
GPSLongitudeRef
GPSLongitude
GPSAltitude
GPSTimeStamp
GPSImgDirectionRef
GPSImgDirection
GPSMapDatum


Contact->CreatorEXIF:Artist
IPTC:By-line
XMP:Creator


Contact->Job TitleIPTC:By-lineTitle
XMP:AuthorsPosition


Contact->AddressXMP:CreatorAddress


Contact->CityXMP:CreatorCity


Contact->State / ProvinceXMP:CreatorRegion


Contact->Postal CodeXMP:CreatorPostalCode


Contact->CountryXMP:CreatorCountry


Contact->PhoneXMP:CreatorWorkTelephone


Contact->E-mailXMP:CreatorWorkEmail


Contact->WebsiteXMP:CreatorWorkURL


IPTC->HeadlineIPTC:Headline
XMP:Headline


IPTC->IPTC Subject CodeXMP:SubjectCode


IPTC->Description WriterIPTC:Writer-Editor
XMP:CaptionWriter


IPTC->CategoryIPTC:Category
XMP:Category


IPTC->Other CategoriesIPTC:SupplementalCategories
XMP:SupplementalCategories


Image->Date CreatedIPTC:DateCreated
XMP:DateCreated


Image->Intellectual GenreXMP:IntellectualGenre


Image->IPTC Scene CodeXMP:Scene


Image->SublocationIPTC:Sub-location
XMP:Location


Image->CityIPTC:City
XMP:City


Image->State / ProvinceIPTC:Province-State
XMP:State


Image->CountryIPTC:Country-PrimaryLocationName
XMP:Country


Image->ISO Country Code
In Lightroom, ISO Country Code must consist of two or three ASCII letters, or three ASCII numerals.
The IPTC standard states that Country-PrimaryLocationCode should have a length of three.
While writing to Country-PrimaryLocationCode, ExifTool will respond with an error if the length is not three, but this limit can be overwritten with the -m option
IPTC:Country-PrimaryLocationCode
XMP:CountryCode


Workflow->Job IdentifierIPTC:OriginalTransmissionReference
XMP:TransmissionReference


Workflow->InstructionsIPTC:SpecialInstructions
XMP:Instructions


Workflow->CreditlineIPTC:Credit
XMP:Credit


Workflow->SourceIPTC:Source
XMP:Source


Copyright->Copyright Status
True for Copyrighted, False for Public Domain, removed for Unknown
Photoshop:CopyrightFlag
XMP:marked


Copyright->CopyrightEXIF:Copyright
IPTC:CopyrightNotice
XMP:Rights


Copyright->Rights Usage TermsXMP:UsageTerms


Copyright->Copyright Info URLPhotoshop:URL
XMP:Copyright Info URL


Description->Person ShownXMP:PersonInImage


Description->Location Created->SublocationXMP:LocationCreatedSublocation


Description->Location Created->CityXMP:LocationCreatedCity


Description->Location Created->State / ProvinceXMP:LocationCreatedProvinceState


Description->Location Created->CountryXMP:LocationCreatedCountryName


Description->Location Created->Country CodeXMP:LocationCreatedCountryCode


Description->Location Created->World RegionXMP:LocationCreatedWorldRegion


Description->Location Shown->SublocationXMP:LocationShownSublocation


Description->Location Shown->CityXMP:LocationShownCity


Description->Location Shown->State / ProvinceXMP:LocationShownProvinceState


Description->Location Shown->CountryXMP:LocationShownCountryName


Description->Location Shown->Country CodeXMP:LocationShownCountryCode


Description->Location Shown->World RegionXMP:LocationShownWorldRegion


Description->Name of Org ShownXMP:OrganisationInImageName


Description->Code of Org ShownXMP:OrganisationInImageCode


Description->EventXMP:Event


Artworks or Objects->Artwork Shown->TitleXMP:ArtworkTitle


Artworks or Objects->Artwork Shown->Date CreatedXMP:ArtworkDateCreated


Artworks or Objects->Artwork Shown->CreatorXMP:ArtworkCreator


Artworks or Objects->Artwork Shown->SourceXMP:ArtworkSource


Artworks or Objects->Artwork Shown->Inventory NumberXMP:ArtworkSourceInventoryNo


Artworks or Objects->Artwork Shown->Copyright NoticeXMP:ArtworkCopyrightNotice


Models->Additional InfoXMP:AdditionalModelInformation


Models->AgeXMP:ModelAge


Models->Minor Age DisclosureXMP:MinorModelAgeDisclosure


Models->Release StatusXMP:ModelReleaseStatus


Models->Release IDXMP:ModelReleaseID


Admin->Image Supplier->NameXMP:ImageSupplierName


Admin->Image Supplier->IdentifierXMP:ImageSupplierID


Admin->Supplier Image IDXMP:ImageSupplierImageID


Admin->Image Registry Entry->Organization IDXMP:RegistryOrganisationID


Admin->Image Registry Entry->Item IDXMP:RegistryItemID


Admin->Max Avail HeightXMP:MaxAvailHeight


Admin->Max Avail WidthXMP:MaxAvailWidth


Admin->Source TypeXMP:DigitalSourceType


Rights->Image Creator->NameXMP:ImageCreatorName


Rights->Image Creator->IdentifierXMP:ImageCreatorID


Rights->Copyright Owner->NameXMP:CopyrightOwnerName


Rights->Copyright Owner->IdentifierXMP:CopyrightOwnerID


Rights->Licensor->NameXMP:LicensorName


Rights->Licensor->IdentifierXMP:LicensorID


Rights->Licensor->Street AddressXMP:LicensorStreetAddress


Rights->Licensor->Extended AddressXMP:LicensorExtendedAddress


Rights->Licensor->CityXMP:LicensorCity


Rights->Licensor->State / ProvinceXMP:LicensorRegion


Rights->Licensor->Postal CodeXMP:LicensorPostalCode


Rights->Licensor->CountryXMP:LicensorCountry


Rights->Licensor->Telephone 1
If changed by drop down menu, it can create a secondary tag with the type of phone number:LicensorTelephoneType1
XMP:LicensorTelephone1
Related: XMP:LicensorTelephoneType1


Rights->Licensor->Telephone 2
If changed by drop down menu, it can create a secondary tag with the type of phone number
XMP:LicensorTelephone2
Related: XMP:LicensorTelephoneType2


Rights->Licensor->E-MailXMP:LicensorEmail


Rights->Licensor->URLXMP:LicensorURL


Property->Release IdXMP:PropertyReleaseID


Property->Release StatusXMP:PropertyReleaseStatus



Revisions:
2016-01-08: First draft, info for Lightroom v. 4.4
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

SK

  • Jr. Member
  • **
  • Posts: 19
Re: Program Metadata to TAG translation
« Reply #1 on: January 04, 2017, 06:26:13 PM »
Hi StarGeek,
First off! Great job in collating all the info!

Is there a USE CASE for groups like
  • Workflow
  • Models
  • Artworks or Objects
I am not familiar with LR, Is it possible to explain how these are used in LR (examples)?

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 3693
Re: Program Metadata to TAG translation
« Reply #2 on: January 04, 2017, 07:05:44 PM »
Is there a USE CASE for groups like
  • Workflow
  • Models
  • Artworks or Objects

There must be otherwise someone went to a lot of work for nothing.  Some (all?) of these are detailed in the IPTC-PhotoMetadata spec pdf.  For example, JobID is defined as
"Number or identifier for the purpose of improved workflow handling. This is a user created
identifier related to the job for which the item is supplied."

I can only guess at the case uses for these items as I'm simply an amateur and these seem orientated toward a professional studio or business.  For the casual user, they probably aren't of any use.

Just as an example, here's what the Workflow section in LR 4.4 looks like.  It's showing the tags I preloaded on an image in order to identify what tags are read.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.

StarGeek

  • Global Moderator
  • ExifTool Freak
  • *****
  • Posts: 3693
Re: Program Metadata to TAG translation
« Reply #3 on: June 13, 2017, 11:14:43 PM »
It's not pretty, but here is the data for Flickr

Flickr
Metadata NameTags read, priority orderTags Written
(site cannot write tags)
Headline1
  • IPTC:Headline
  • IPTC:ObjectName
  • XMP-dc:Title
  • File Name
n/a
Description
  • IPTC:Caption-Abstract
  • XMP-dc:Description
  • EXIF:ImageDescription
n/a
Tags
  • IPTC:Keywords
  • XMP-dc:Subject
  • Combined Tags
    • IPTC:City
    • IPTC:Province-State
    • IPTC:Country-PrimaryLocationName
    • xmp:City
    • XMP-photoshop:State
    • XMP-photoshop:Country
    • XMP-iptcCore:CountryCode
n/a
Orientation
(not shown, respected on upload)
  • EXIF:Orientation
n/a
Taken on
  • XMP-exif:DateTimeOriginal
  • EXIF:DateTimeOriginal
  • Date Uploaded
n/a
Make1
  • XMP-tiff:Make
  • EXIF:Make
n/a
Model1
  • XMP-tiff:Model
  • EXIF:Model
n/a
LensModel1
  • XMP-exifEX:LensModel
  • EXIF:LensModel
n/a
FNumber1
  • EXIF:FNumber
  • XMP-exif:FNumber
n/a
FocalLength1
  • EXIF:FocalLength
n/a
ExposureTime
  • EXIF:ExposureTime
  • XMP-exif:ExposureTime
n/a
ISO
  • EXIF:ISO
n/a
GPS2EXIF GPS tags
  • GPS:GPSLatitudeRef
  • GPS:GPSLongitude
  • GPS:GPSLongitudeRef
  • GPS:GPSLatitude
n/a
  • 1 No field name shown, sometimes there is an icon
  • 2 GPS map locations are shown based upon GPS privacy settings at time of upload
  • If IPTC:Keywords and XMP-dc:Subject do not exist, then Tags is populated with all of the listed combined tags.
  • If the "Show Exif" link is clicked, all tags extracted by Exiftool are shown, as Flickr uses Exiftool to extract metadata.
Troubleshooting hints:
* When posting, include your OS, Exiftool version, and type of file you're processing (MP4, JPG, etc).
* Double all percent signs (%) in a Windows batch file.
* If your GPS coords are negative, make sure and set the GpsLatitudeRef and GpsLongitudeRef tags correctly.