Per Case #126382-
I have a need to export XML data, through the export scenario (E.g. NOT through Web service/endpoints).
How should the Data provider be set up?
Sample: I want to both import and export a structure similar to that generated by this SQL: (An example showing Either is fine, a field or two is enough)
Select( Select top 3 BAccount.AcctCD As [CustomerID], BAccount.AcctName As [CustomerName], Customer.CustomerClassID AS [CustomerClassID], Customer.TermsID As [TermsID] From Customer Inner Join BAccount On BAccount.BAccountID = Customer.BAccountID And BAccount.CompanyID = Customer.Companyid Where Customer.Companyid > 0 for xml Path(''), Type ) AS Customers FOR XML PATH(''), TYPE, ELEMENTS
Which produces XML such as:
<Customers><CustomerID>ABCSTUDIOS</CustomerID><CustomerName>ABC Studios Inc</CustomerName><CustomerClassID>KEY</CustomerClassID><TermsID>30D</TermsID><CustomerID>ABARTENDE </CustomerID><CustomerName>USA Bartending School</CustomerName><CustomerClassID>KEY</CustomerClassID><TermsID>30D</TermsID><CustomerID>ACTIVESTAF</CustomerID><CustomerName>Active Staffing Service</CustomerName><CustomerClassID>LOCAL</CustomerClassID><TermsID>30D</TermsID></Customers>
Basically Customer ID, Name, Class, and Terms - Limited data set, since looking for the data provider
Have found the provider PX.DataSync.Xml - NO examples, though. Import/Export training seems to skip anything other than Excel / Sql server
Also posted on Stack Overflow:
Support did give an answer, for the existing XML Data provider:
After reviewing it into more details, the system uses the following format of XML file, using the Root, Column and Rows tags.
You need to create your XML file in this format in order to be successfully uploaded to the system:
<?xml version="1.0" encoding="us-ascii"?>
Please notice that using this approach it is very strict.
Request XML export Redesign – It’s of VERY limited use. I’d expect to be given either a “Random-ish” file, or a spec of a file needed (I have a variety, or heck, use the sample I provided – Produce that XML). Usually the input / output CANNOT be modified, it’s provided from/to another party (or system). So design a way, compatible with the existing system, that allows a designer to specify the transition from/to a XML structure outside of your control