Dynamics Community Forum Thread Details

Importing from another software

Hello,

I am taking a CSV output from another software and transforming it thru power automate in SharePoint to match the column format of my Journal Entry configuration package.

The Excel needs to look like this configuration package Excel import

My export ends up looking like this once manipulated to this automatically:

but given that it doesn't have the XML Schema in Row one, which I noticed can't be Copy and pasted in, I get this error:

***********

If requesting support, please provide the following details to help troubleshooting:

Error message:
The Excel workbook must contain an XML map.

Internal session ID:
1c2ff50d-bb65-4d16-8466-f4662366bc3c

Application Insights session ID:
92533947-9752-476c-99e1-22d5c83fedca

Client activity id:
3f455cb4-ad41-43b7-9fa0-f9f830efb6e5

Time stamp on error:
2024-11-06T20:44:29.2641752Z

User telemetry id:
59c86b4a-c97f-4e98-b983-2d3a9ab645b9

AL call stack:
"OpenXML Management"(CodeUnit 6223).ExtractXMLSchema line 5 - Base Application by Microsoft
"Config. Excel Exchange"(CodeUnit 8618).ImportExcel line 26 - Base Application by Microsoft
"Config. Excel Exchange"(CodeUnit 8618).ImportExcelFromSelectedPackage line 6 - Base Application by Microsoft
"Config. Package Card"(Page 8614)."ImportFromExcel - OnAction"(Trigger) line 4 - Base Application by Microsoft

********

How do I get the XML Schema, so that I can embed it at the top on my converted other software output so that I can import it using the configuration package?

Does the Schema change every time?

I've included the Configuration package export ( Default .....xlsx) and the converted from other software to similar input without XML mapping file ( BC_ EXPORT). Don't mind the name should be Export for BC. In the latter, I deleted sensitive info in description.

Otherwise I can take the latter's filled out rows and copy and paste into teh CB config package Excel export, save it and reimport and that populates the journal entries but does not give the document the next number in the No. Series attached to that Journal Batch Name. I could do this instead if I could get it to prepopulate the Document #.

Any help would be appreciated.

Thanks,

Cedric