11-09-2022 12:16 PM - last edited on 01-12-2023 08:46 AM by JackLacava
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.
However, I am able to successfully import the members table XFW_ACM_MetadataAccountImportMembers
Any one has any idea what could be the issue with the XFW_ACM_MetadataAccountImportTree table?
11-10-2022 04:55 AM
Hi Sai, in the Import Tree tab, these are the columns that I see:
...same if you check the actual table.
Did you try loading your template without the Aggregation Weight column and only use the four columns in that table?
11-10-2022 05:06 AM
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.
Thanks again for looking into this.
11-10-2022 09:48 AM
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.
11-10-2022 11:19 AM
Thanks Karl. I tried your suggestions but still the same error. I will raise a support ticket.