Conversion from TXT. to XML format

[Former Member]

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

[Former Member · Accepted solution]

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

Regards

Srfeeram.G.Reddy

[Former Member]

thnx contributors

[Former Member]

HI,

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

Regards

Chilla..

[Former Member]

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/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-eaed5eae... - 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..

[Former Member]

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

[bhavesh_kantilal]

Saras,

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

Regards

Bhavesh

[Former Member]

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.

[bhavesh_kantilal]

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

[Former Member]

dont do contentconversion and save it as .xml