One of my vendor sends xml invoices. Is there a way to map it to sync.supplierinvoice ?
Hello! You will need to create a custom BOD in the Data Catalog, in ION. Once the custom XML BOD is ION you can pick it up pass it to the mapping tool in a Data Flow. If you are CloudSuite, you would have the ability to use ION Scripting or the Mapping tool. On-premise does not have ION Scripting.
Brandon,
I am very new to all of this. Do I have to create a xsd ? In my supplier xml file, the invoice # is <DOC>212654</DOC>. HOw can I tell ion that this is the invoice number ?
What you can do is create a File Template in ION, define it as XML. Then you will have the option to upload sample XML (use the sample with richest set of values), and ION will generate custom BOD based on that (via Generate Metadata button).
In dataflow you can then define a File connection point using this File template. It will pick the XML from network share and translate it into custom BOD. In dtaflow you will have to add the mapping from sync.customBOD to Sync.SupplierInvoice. <DOC> element in source for example will point to element <DocumentID> in target, etc.
Thks I will try it
