Hi,
How do I convert XML file coming from M3 (custom BOD) to CSV file?
Is it correct format for file template?
Regards,
KK
Hey KK,
Looks like you're headed in the right direction. I'd recommend checking out the documentation on file templates. Once you generate the metadata for your file template, you can create a new entry for your file connector and select the metadata model when optioned onto the "File Templates" radio button.
Once you've got your Data Flow set up and configured, sending your BOD through should result in a resulting file being dropped into your file server.
Hi Mike, thanks for a response.
I have build data flow, but there are two issues with output CSV file:
1) there are no headers in the file
2) first line is missing first value, other lines are fine.
Here is my CSV file schema
And file template
XSLT map transforms M3 BOD into this XML
Any suggestion will be greatly appreciated.
Thanks
Kirill
Hi @kirill-kuchumov Could you share your mapping ?If possible, I would like to have a example of a conversion between a structure with two level (Header and lines in a BOD ) toward a flat structure as CSV file Thanks
Hi Denis,
I have deleted it.
I just made flat file instead of CSV where I build lines as values separated by commas.
