Question Re: Conversion from TXT. to XML format in Technology Q&A

Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 05:55:30 GMT

HI Experts,

I have a requirement from the client for conversion of .txt files to .xml files as they think they have some structural issues with .txt files . So just want to know what should be plan of action . and what can be tha\e consequences of the same.

ONE THING TO NOTE IS THAT THE PROJECT IS ALREADY LIVE AND ALL THE SCENARIOS ARE ALREADY WORKING FINE WITH \.TXT FILES TO IDOC CONVERSION.

REGARDS

SARAS JAIN

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 05:57:34 GMT

makeit<filename> .xml inf file adapter setting rather than filename .txt which set currenlty.

Regards

Srfeeram.G.Reddy

Re: Conversion from TXT. to XML format

bhavesh_kantilal — Mon, 26 Feb 2007 05:58:49 GMT

Saras,

What exactly is your question? Can you give us more details on what you want?

Regards

Bhavesh

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 05:59:59 GMT

Saras Jain,

>> So just want to know what should be plan of action . and what can be tha\e consequences of the same.

You can use File Content Conversion in File adapter for achieving this.

FIle-IDOC, you said it is live. Do you need to convert the input txt file to input XML now? If so, you will have 2 different scenarios, the first one is file-file and the next one is is file(xml) to IDOC.

Regards,

Jai Shankar

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 06:00:45 GMT

HI,

As explained above if you are receiveing the .xml files you would have to change the sender file adapter file names :.xml from .txt..

and you should change the txt file to xml file by manually or by using some interface or by some tools..

First you would have to take the structure of .txt files and does the same structure and occurrences are followed in the structure or not.. and you would have to take record set,record structure,occurrences and size of the input file...

-- Are they using the FTP or not..

-- Is there any need of IDoc packaging..etc.. if receiving system is R3(IDoc)..

Please see the below links for file content conversion..

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter - FCC

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns - FCC

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

/people/harrison.holland5/blog/2006/12/20/xi-configuration-for-mdm-integration--sample-scenario - FCC - MDM

/people/shabarish.vijayakumar/blog/2006/04/03/xi-in-the-role-of-a-ftp - FCC

/people/prateek.shah/blog/2005/06/14/file-to-r3-via-abap-proxy - FCC

/people/mickael.huchet/blog/2006/09/18/xipi-how-to-exclude-files-in-a-sender-file-adapter - EOIO - File

http://help.sap.com/saphelp_nw04/helpdata/en/ee/c9f0b4925af54cb17c454788d8e466/frameset.htm - cc

http://help.sap.com/saphelp_erp2005vp/helpdata/en/95/bb623c6369f454e10000000a114084/content.htm - fcc cOUNTER

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/da1e7c16-0c01-0010-278a-eaed5eae5a5f - conversion agent

with item fiels.

/people/ravikumar.allampallam/blog/2005/06/24/convert-any-flat-file-to-any-idoc-java-mapping - Any flat file to any Idoc

Regards

Chilla..

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 06:01:04 GMT

IN MY PROJECT DATA IS POSTED IN FORM .TXT FILES FROM POS.

Now they want to change the file format to .xml format.

We want to change for both outbound/inbound.

Re: Conversion from TXT. to XML format

bhavesh_kantilal — Mon, 26 Feb 2007 06:04:30 GMT

Saras,

No Capitals please. FYI, typing in capitals is equiavlent to shouting at people on the Internet.

Regarding your question, if the client wants to move to XML files,

1. Confirm if the XML file is going to be of the format in which the datatype already has been created in XI, i.e the output of content conversion should be the input XML files format.

if yes for 1 then just make the chaange in your sender file adapters to remove content conversion and things will work fine.

if the XML format is going to be different to the source datatype, you will be looking at readoing the entire scenarios all over again including the design.

Regards

Bhavesh

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 06:05:22 GMT

dont do contentconversion and save it as .xml

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Feb 2007 06:16:32 GMT

HI,

As explained by bhavesh , if you have the .xml file then no need to have the FCC.

Regards

Chilla..

Re: Conversion from TXT. to XML format

Former Member — Mon, 26 Mar 2007 05:51:53 GMT

thnx contributors