Skip to Content
avatar image
Former Member

Script needed at OS level to Convert XML to FlatFile

Hi All,

Can any one providde me Script to Convert XML to FlatFile at OS Level(Windows Based script).I'd thankful for your suggestions..

Thanks

Pullarao

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 17, 2007 at 06:50 AM

    Hi !!

    You can execute a Unix script running in the XI server from the File communication channel. Ie. if you want to do something which was not part of XI adapter configuation , then you can make use of external unix script and you can execute those from the XI.

    For this, write a unix script and place in the XI OS level provided that path is accessible from PI Channel.

    E.g

    So u can use this in either Sender Channel to modify the data before it reaches into the Integration Server or in Receiver channel it is generally used to transfer the files into different location via Secure FTP

    SAP help: http://help.sap.com/saphelp_nw2004s/helpdata/en/bc/bb79d6061007419a081e58cbeaaf28/content.htm

    Blog:/people/sameer.shadab/blog/2005/09/21/executing-unix-shell-script-using-operating-system-command-in-xi

    XI can be in any OS.

    Go through this again first.

    http://help.sap.com/saphelp_nw04/helpdata/en/e3/94007075cae04f930cc4c034e411e1/content.htm

    More in this blog,

    /people/shabarish.vijayakumar/blog/2006/08/01/along-came-a-file-adapter-mr-ftp-and-rest-of-the-gang

    Check these links

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

    <b>Pls Reward if useful</b>

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 17, 2007 at 06:22 AM

    Hey

    i dont think a script will solve this problem,do a simple FCC on sender side.

    any specific reason of going with OS script for this conversion?

    Thanx

    Aamir suhail

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      My requirement is here i want o transfer 200 mb xml file to target location as text file.I want to use file splitting concept in sender channel.But it won't work for xml file.Becuase of this first i'm trying to convert xml to text file then i'm planning to use file splitting concept.For this reason xml to text file conversion i want to use script file then next conversion i want involve XI server.

      Thanks

      Pullarao.