Program Metadata to TAG translation

Started by StarGeek, January 08, 2016, 07:06:35 PM

Previous topic - Next topic

StarGeek

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
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

SK

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

Quote from: SK on January 04, 2017, 06:26:13 PMIs 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.
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

StarGeek

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.
"It didn't work" isn't helpful. What was the exact command used and the output.
Read FAQ #3 and use that cmd
Please use the Code button for exiftool output

Please include your OS/Exiftool version/filetype

twoj

I've been working on Videos in Lightroom and i wanted to add that they have a Video Metadata section, weird as it is since you can't edit tags on Videos in LR. Anyways it starts off with information i gathers from a scan of the video, stuff like;
Duration
Trimmed Duration
Video Frame Rate
Video Alpha Mode
Video Dimentions
Audio Channel Type
Audio Sample Rate
Audio Sample Type

It then proceeds with metadata of the video file, it seems that this information was mostly gathered from this webpage;
https://community.adobe.com/t5/lightroom-classic-discussions/lr-4-changes-to-photo-get-metadata/m-p/4066165

Just after some basic tests it seems most of those are coming from the;
XMP xmpDM Tags
such as;
Director of Photography -> [XMP-xmpDM] DirectorPhotography
Day of Shoot -> [XMP-xmpDM] ShotDay

But also some of my entries are coming from [ItemList] which i thought was more Quicktime tags. Anyways i thought i would add this to the knowledge of LightRoom. I'll try experimenting a bit more to see if i can track down some more of these tags.

twoj

I went through the tags today and indeed they are the XMP xmpDM Tags
a bit more can be found about Adobe use of them here;
https://developer.adobe.com/xmp/docs/XMPNamespaces/xmpDM/

So these are the values i found, they may contain errors and not complete so use at your own risk;

Speaker Placement CMD: -XMP-xmpDM:SpeakerPlacement="speaker1" Confirmed
Tape Name CMD: -XMP-xmpDM:TapeName="tape1" Confirmed
Alternate Tape Name CMD: -XMP-xmpDM:AltTapeName="alt-tape1" Confirmed
Scene CMD: -XMP-xmpDM:Scene="scene1" Confirmed
Shot Name CMD: -XMP-xmpDM:ShotName="shot1" Confirmed
Shot Date CMD: -XMP-xmpDM:ShotDate="2023:06:20 12:00:00-04:00" Confirmed_(Supports TimeZones)
Shot Location CMD: -XMP-xmpDM:ShotLocation="location1" Confirmed
Log Comment CMD: -XMP-xmpDM:LogComment="log1" Confirmed_Display will override to [ItemList] Comment

Artist CMD: -XMP-xmpDM:Artist="artist1" Confirmed_Display will override to [ItemList] Artist
Album CMD: -XMP-xmpDM:Album="album1" Confirmed
Genre CMD: -XMP-xmpDM:Genre="genre1" Confirmed
Release Date CMD: -XMP-xmpDM:ReleaseDate="2023-07-17" Confirmed(Supports TimeZones)_Display will override to [ItemList] Content Create Date
Composer CMD: -XMP-xmpDM:Composer="composer1" Confirmed
Engineer CMD: -XMP-xmpDM:Engineer="engineer1" Confirmed
Instrument CMD: -XMP-xmpDM:Instrument="instrument1" Confirmed

Comment CMD: -XMP-xmpDM:DMComment="comment1" Confirmed
Client CMD: -XMP-xmpDM:Client="client1" Confirmed
Good CMD: -XMP-xmpDM:Good="good1" Needs to be set to certain values for Lightroom (Unset, Good, Not Good)
Project Name CMD: -XMP-xmpDM:ProjectName="project1" Confirmed
Director CMD: -XMP-xmpDM:Director="director1" Confirmed
Director of Photography CMD: -XMP-xmpDM:directorPhotography="directorofPhoto" Confirmed
Camera Model CMD: -XMP-xmpDM:CameraModel="model1" Confirmed
Camera Angle CMD: -XMP-xmpDM:CameraAngle="angle1" Needs to be set to certain values for Lightroom (Unset, Low Angle, etc)
Camera Move CMD: -XMP-xmpDM:CameraMove="move1" Needs to be set to certain values for Lightroom (Unset, Aerial, etc)
Day of Shoot CMD: -XMP-xmpDM:ShotDay="Shot on Aug 18th 2023" Confirmed