Advice on coping data from XMP-acdsee:categories to -XMP-lr:HierarchicalSubject

[Bones]

I want to ensure the cataloging i have in the ACDsee DAM is embedded into the image files as part of migrating to iMatch

From my Forum reading - it appears the topic has been covered in the past and exiftool supports the ACDsee proprietary ACDsee Categories & Collections structure. However, i am un able to sort a command that copies the tag data

i have the following in a test image a.jpg with dummy/representative tag data (attached)

Code Select Expand

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -G1 -XMP-acdsee:Collections -XMP-acdsee:Categories -XMP-acdsee:Keywords -IPTC:Keywords a.jpg
[XMP-acdsee]    Collections                     : <Collections><Collection Assigned="0">Workflow<Collection Assigned="0">Photo Import (PI)<Collection Assigned="1">1. PI GeoTagged</Collection><Collection Assigned="1">0. PI Imported, Cam Owner, Author</Collection><Collection Assigned="1">2. PI Revers Geocoded</Collection><Collection Assigned="1">4. PI Rated</Collection><Collection Assigned="1">5. PI Categories - People, Event...</Collection><Collection Assigned="1">6. PI Foldered</Collection></Collection></Collection><Collection Assigned="0">CL_Color<Collection Assigned="1">CL_Blue</Collection><Collection Assigned="1">Green</Collection></Collection><Collection Assigned="0">CL_Size<Collection Assigned="1">CL_Small</Collection></Collection></Collections>
[XMP-acdsee]    Categories                      : <Categories><Category Assigned="0">CR_Size<Category Assigned="1">CR_Small</Category></Category><Category Assigned="1">CR_Color<Category Assigned="1">CR_Blue</Category><Category Assigned="1">Green</Category></Category></Categories>
[XMP-acdsee]    Keywords                        : KW_Color, KW_Color|KW_Blue, KW_Color|Green, KW_Size|KW_Small
[IPTC]          Keywords                        : CR_Blue, CR_Color, CR_Small, Green, KW_Blue, KW_Color, KW_Small
I have added data to -XMP-lr:HierarchicalSubject as a test - seemed OK

Code Select Expand

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -XMP-lr:HierarchicalSubject="A|B" a.jpg
    1 image files updated

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -XMP-lr:HierarchicalSubject a.jpg
Hierarchical Subject            : A|B
i ran this command and got an error - any suggestions?
Note - using a test version of acdsee.config @StarGeek provided a while back

Code Select Expand

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -config acdsee-test.config -XMP-lr:HierarchicalSubject+<-XMP-acdsee:Categories a.jpg
The system cannot find the file specified.

[Phil Harvey]

You need quotes around arguments containing ">" or "<".

- Phil

[Bones]

Phil - Ta - doh
Thats fixed the Syntact error - suspect i still have a logical/concept error
not really sure/clear what i am asking exiftool to be doing

i got no tag values changed
this is what i got

Code Select Expand

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -config acdsee-test.config "-XMP-lr:HierarchicalSubject+<-XMP-acdsee:Categories" a.jpg
    0 image files updated
    1 image files unchanged

D:\NAS49\Photo\Test7_AD-MD_into_Keywords>exiftool -XMP-acdsee:Categories  -XMP-lr:HierarchicalSubject a.jpg
Categories                      : <Categories><Category Assigned="0">CR_Size<Category Assigned="1">CR_Small</Category></Category><Category Assigned="1">CR_Color<Category Assigned="1">CR_Blue</Category><Category Assigned="1">Green</Category></Category></Categories>
Hierarchical Subject            : A|B

[Phil Harvey]

I really don't know why you are copying this to HierarchicalSubject, but the problem in your command is common mistake 5a.

- Phil

[StarGeek]

I really don't know why you are copying this to HierarchicalSubject

Also wondering this.  That ACDSee tag is just going to be copied as one long string, not as the individual categories listed.

[Bones]

Thanks
Got it to work as described - copy of the whole string. Yes that is not what i valued

I was not sure what the command would do in terms of straight copy or unpacking and building a lr:HierarchicalSubject compliant hierarchy.

Thus i presume if i want to unpack that psuedo xml structure acdsee have and build the Hierarchies - i will need a script/program - and to me it seems as though it is tricky/non-trivial. Looking around i found this from years back - https://dev.exiv2.org/boards/3/topics/1912

I will look some more and update if i achieve something useful

Again - thanks for the help