I have a requirement wherein I would be receiving a XML file and I need to convert it into a delimited flat file. I have the XSD with me…
I know that I can use the services xmlStringToNode and xmlNodeToDocument to get IS document…But after that …to convert it into a delimited flat file I need the FF Schema…is there a easy way to generate the FF Schema using the XSD that i have for the xml file…?
Manually creating the FF Schema is the only option…?
The structure of the xml is complex…It has several levels of fields and sub-fields in the records…So I worry that If I start to create the FF schema manually by looking at the XSD, I am bound to make errors.
I am using wm 7.1 developer
[FONT=Arial Narrow][SIZE=2][COLOR=#0000ff][FONT=Arial Narrow][SIZE=2][COLOR=#0000ff]Hi mch1326,
By using the following Built in service you can create a ff schema from XSD.
Try it. please post on same thread if you are facing any issue.
Thanks for your response.
The XSD is actually the XML schema for the XML file that i receive provided to me by the vendor (sender).
The XSD does not conform to the FFGeneration.xsd format to be used with the pub.flatFile.generate:saveXMLASFFSchema service
I still gave it a try, but it errored with the msg …missing /FFSchema field, which is as expected because the XSD does not have all the fields required by FFGeneration.xsd…
Let me know if you have any more suggestions…