ACM Metadata Import Error

Sai_Maganti
Contributor II

While importing parent/child metadata from the ACM interface, I am getting an error on the table XFW_ACM_MetadataAccountImportTree. I created my own excel template for this purpose. Can't find any standard template.

ACM_Err1.png

However, I am able to successfully import the members table XFW_ACM_MetadataAccountImportMembers

ACM_Success.png

Any  one has any idea what could be the issue with the XFW_ACM_MetadataAccountImportTree table?

4 REPLIES 4

Henning
Contributor III

Hi Sai, in the Import Tree tab, these are the columns that I see:

Henning_0-1668073984999.png

...same if you check the actual table.

Henning_1-1668074084997.png

Did you try loading your template without the Aggregation Weight column and only use the four columns in that table?

Henning

My ACM installation has the "AggregationWeight" column in the table. However, the help document doesn't say so.

I have now tried to import without the "AggregationWeight" column but still getting the same error message. I was able to manually add rows but not via import process.

treetable.png

Thanks again for looking into this.

Sai

KarlT
New Contributor III

Hi Sai, the error reads like it might be an issue with the import template - have you checked everything such as the named ranges match in both files? Maybe try removing the unecessary rows (top row and blank row). If this doesn't work and you are sure the files are the same, then I'd recommend raising a support ticket.

Regards

Thanks Karl. I tried your suggestions but still the same error. I will raise a support ticket.

Best

Sai