4 Replies Latest reply: Jan 22, 2013 5:57 AM by sri_kun RSS

    OSB MFL Transform..

    sri_kun
      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
          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
            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
              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
                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.