Bulk metadata import asset info

[#1]

Hello everybody,

I am trying to update some asset information using bulk metadata import process and result is not as desired:

- Imported .csv file only modifies underlined fields at Basic tab.

Is it posible using bulk metadata import to change fields in Cards Covers tab as follows:

Attached .csv exported file output, I tried to modify values in some fields, importation process is successful but fields are not updated, is it possible that fields are protected and can not be modified?

assetPath,jcr:primaryType{{Name}},jcr:mixinTypes{{Name: multi }},subgroup{{String}},dam:Physicalheightininches{{Decimal}},dam:Physicalwidthininches{{Decimal}},dam:Fileformat{{String}},dam:Progressive{{String}},tiff:ImageLength{{Long}},tiff:YResolution{{String}},exif:ColorSpace{{Long}},jcr:lastModifiedBy{{String}},xmp:CreatorTool{{String}},dam:extracted{{Date}},dc:format{{String}},dam:Bitsperpixel{{Long}},xmpMM:DocumentID{{String}},dam:MIMEtype{{String}},tiff:Orientation{{Long}},dam:Physicalwidthindpi{{Long}},dam:Physicalheightindpi{{Long}},bin{{Long}},type{{String}},tiff:ResolutionUnit{{Long}},xmpMM:OriginalDocumentID{{String}},group{{String}},title{{String}},issueDate{{Date}},dc:modified{{Date}},photoshop:ICCProfile{{String}},photoshop:ColorMode{{Long}},dam:Numberofimages{{Long}},tiff:XResolution{{String}},exif:PixelYDimension{{Long}},xmp:MetadataDate{{Date}},codProd{{String}},exif:PixelXDimension{{Long}},country{{String}},jcr:lastModified{{Date}},dam:Numberoftextualcomments{{Long}},xmpMM:InstanceID{{String}},xmp:ModifyDate{{Date}},xmp:CreateDate{{Date}},tiff:ImageWidth{{Long}},dam:sha1{{String}},dam:size{{Long}},xmpMM:History/jcr:primaryType{{Name}},xmpMM:History/xmpNodeType{{String}},xmpMM:History/xmpArraySize{{Long}},xmpMM:History/xmpArrayType{{String}},xmpMM:History/1/jcr:primaryType{{Name}},xmpMM:History/1/stEvt:action{{String}},xmpMM:History/1/xmpNodeType{{String}},xmpMM:History/1/stEvt:softwareAgent{{String}},xmpMM:History/1/stEvt:when{{Date}},xmpMM:History/1/stEvt:instanceID{{String}},xmpMM:History/2/jcr:primaryType{{Name}},xmpMM:History/2/stEvt:action{{String}},xmpMM:History/2/xmpNodeType{{String}},xmpMM:History/2/stEvt:softwareAgent{{String}},xmpMM:History/2/stEvt:when{{Date}},xmpMM:History/2/stEvt:changed{{String}},xmpMM:History/2/stEvt:instanceID{{String}},xmpMM:History/3/jcr:primaryType{{Name}},xmpMM:History/3/stEvt:action{{String}},xmpMM:History/3/xmpNodeType{{String}},xmpMM:History/3/stEvt:softwareAgent{{String}},xmpMM:History/3/stEvt:when{{Date}},xmpMM:History/3/stEvt:changed{{String}},xmpMM:History/3/stEvt:instanceID{{String}},Iptc4xmpCore:CreatorContactInfo/jcr:primaryType{{Name}},

/content/dam/caas/global/cardcovers/spain/0000001316_494011_20160128_front.png,nt:unstructured,cq:Taggable,1313,8.846116065979004,14.02602481842041,PNG,no,637,720000/10000,1,U509151,Adobe Photoshop CC 2015 (Maquina),2019-05-08T09:13:22+00:00,image/png,32,adobe:docid:photoshop:87536c86-6865-1179-ad17-9c59613319a4,image/png,1,72,72,999999,0999,2,xmp.did:9740c9cd-c733-4228-b2b2-a8eb15a23e80,9999,AHORA ahora,2019-05-08T11:16:00+02:00,2019-05-08T09:16:27+00:00,sRGB IEC61966-2.1,3,1,720000/10000,637,2016-06-15T14:50:35+02:00,000testtest,1010,ES,2019-05-08T09:16:27+00:00,0,xmp.iid:9898c157-77e3-4a3f-8e8c-949328843d58,2016-06-15T14:50:35+02:00,2016-06-01T10:54:11+02:00,1010,7cd23e5dc6e8f3826d3ff1b974166ecb67059fc6,176332,nt:unstructured,xmpArray,3,rdf:Seq,nt:unstructured,created,xmpStruct,Adobe Photoshop CC 2015 (Macintosh),2016-06-01T10:54:11+02:00,xmp.iid:9740c9cd-c733-4228-b2b2-a8eb15a23e80,nt:unstructured,saved,xmpStruct,Adobe Photoshop CC 2015 (Macintosh),2016-06-01T10:54:11+02:00,/,xmp.iid:4a1a8a93-8b63-4552-b299-8ee121cee94b,nt:unstructured,saved,xmpStruct,Adobe Photoshop CC 2015 (Macintosh),2016-06-15T14:50:35+02:00,/,xmp.iid:9898c157-77e3-4a3f-8e8c-949328843d58,nt:unstructured,

Thanks for your help.

[#2 · Accepted solution]

Hello,

Is that only custom metadata fields are not being updated?

To enable metadata import on custom namespaces they should be registered first.

Please check this article to see how to register namespace:

https://helpx.adobe.com/ca/experience-manager/6-4/assets/using/meta-edit.html#Registeringacustomname...

Regards,

Vishu

[#3]

Hello,

In your last comment, you said: "it only modifies those custom metadata fields". Is that statement correct? Or is it typo?

For registering the namespace, you would need to login to crx/explorer of the same server i.e. host:port/crx/explorer. If you don't have access, please ask your administrator to run this test.

Download the output log of the job by clicking on "Result CSV Download" and see if there are any errors.

Regards,

Vishu

[#4]

Hello,

In case you don't want to proceed with custom namespaces, you can wait for an official fix of issue CQ-4269445 - Import metadata without namespace. This will be backported to 6.4 via NPR-29425 which is going to be released in 6.4.5.0.

Regards,

Vishu

[#5]

Dear Vishu

Sorry it was a typo I meant that those custom metadata fields are not updating, import job shows as successful, I have check Metadataimoprtoutput file from the job and you were right, that fields are not updating because Namespace prefix are not registered for the fields.

I will contact my admin to implement this.

Thank you so much for your help.

Kind regards,

Pablo R.

[#6]

Thank you so much for your answer.

To your first question, yes, it only modifies those custom metadata fields, metadata at basic tab updates when .csv file is imported.

I do not have access to local host for registering custom namespaces as you told me.

Looking at html code and comparing two fields, one update and other that doesn't:

Field OK

<input class="coral-Form-field coral3-Textfield" data-metatype="text" type="text" name="./jcr:content/metadata/xmp:CreatorTool" labelledby="label_88efa18c-75b1-4ded-9724-9bff7c31ec83" value="Adobo Fotochop CS9" data-foundation-validation="" data-validation="" is="coral-textfield" id="coral-id-26" aria-labelledby="label_88efa18c-75b1-4ded-9724-9bff7c31ec83" aria-invalid="false">

Field not OK

<input class="coral-Form-field coral3-Textfield" data-visibilitycascading="default" data-requiredcascading="always" data-metatype="text" type="text" name="./jcr:content/metadata/title" labelledby="label_256d917c-9f2e-4823-b166-2698854e9193" value="TARJETA PRUEBA" data-foundation-validation="" data-validation="" is="coral-textfield" required="true" aria-required="true" id="coral-id-287" aria-labelledby="label_256d917c-9f2e-4823-b166-2698854e9193" aria-invalid="false">

Kind regards