This discussion is archived
4 Replies Latest reply: Jan 22, 2013 3:57 AM by sri_kun RSS

OSB MFL Transform..

sri_kun Newbie
Currently Being Moderated
Hi,

We have a scenario of converting an .xml file to .csv file in OSB.

Can we use the MFL transform for the conversion of XML to CSV? we also need the Headers in CSV file generated.

Please let me know if any one have used this or suggest me an approach if any?

Thanks,
SV..
  • 1. Re: OSB MFL Transform..
    Abhinav Journeyer
    Currently Being Moderated
    Hi Sri,

    Yes you can convert xml payoad to CSV format using mfl transformation.
    It would be better if you can elaborate your scenario.

    I have done the reverse a year back !!
    http://abhinavgupta3.blogspot.in/2012/01/adding-namespace-to-xml-structure.html

    Regards,
    Abhinav
  • 2. Re: OSB MFL Transform..
    sri_kun Newbie
    Currently Being Moderated
    HI Abhinav,

    My case is we have an xsd with some simple and complex types in it, we want to convert this into CSV along with the headers from the XML.

    It could be helpful for me , if you can provide me any example using the MFL.

    Thanks,
    SV.
  • 3. Re: OSB MFL Transform..
    Abhinav Journeyer
    Currently Being Moderated
    Hi Sv,

    Find below samples

    http://biemond.blogspot.in/2008/12/flat-file-to-xml-with-oracle-service.html
    http://www.javamonamour.org/2010/06/oracle-mfl-tutorial.html

    It is considered good etiquette to reward answerers with points (as "helpful" - 5 pts - or "correct" - 10pts).
  • 4. Re: OSB MFL Transform..
    sri_kun Newbie
    Currently Being Moderated
    Hi Abhinav,

    Thanks for the references.

    We have created a MFL transformation out of an XSD and developed one proxy service which is having the MFL transformation in the request stage and assign the $body/* to a temp variable.

    Now when we tried to test this , we are getting an error as below:

    Binary to XML mfl transformation failed for the MFL Resource XX/Resources/XXXXXXX : null

    I am able to test the MFL created successfully with comma(,) as a delimiter but when we are trying to test it from proxy service we are getting the above error.

    Could you please help us in resovling this?

    Thanks,
    SV.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points