File Content Conversion Requirement

[Former Member]

Dear Experts,

I have a scenario where PI (7.1) has to pick file from a FTP server and also IDoc data should write on File using FCC in both cases. However the incoming file (fixed lengths) will be in following format without any end-separator, so I would like to know whether the FCC will work for this requirement or not...

usually file with End-separator looks like below...

002     123     2345BBB     C

003     231     ADD2213     E

However, in my case the file comes contentiously without any End-separator...

002     123     2345BBB     C003     231     ADD2213     E

In the same way, we have to write the file in another interface (IDoc to File) without any End-separator using Append functionality...

Could you please check and give me some idea on this requirement?

Thanks-
Rams

[gagandeep_batra]

Hi rams,

As there is no end separator you  can read the whole file in single line and use UDF in mapping to split it.

Regards

GB

[Former Member]

Dear GB,

Shall i request for any sample code to read the whole file in a single line and split it using UDF.

It would be very thankful for your kind help.

Regards,
Rams

[former_member191435]

Hi Rams,

Please find below thread...

take one string as a source and create your target structure as it is... and use code of Mark used in below thread.

Thanks,

Sreenivas

[Former Member]

Thanks Sreenivas,

I have gone through the link, however the discussion was on splitting the string "Based on some symbol". But in my case it is on fixed lengths, how can i acheive this solution?

Regards

Rams

[former_member184720]

read each line into separate string.. follow Greg's suggestion in the below thread for FCC.

For splitting the string based on fixed length go through below discussion which has lot of suggestions.

splitting string in java into fixed length chunks - Stack Overflow

[Muniyappan]

Use FCC with Fixed length configuration. there should not be any issue for append.

[former_member182455]

Hi,

please check the below url for sender Flat file with out end separator.

http://www.saptechnical.com/Tutorials/XI/Contentconversion/page1.htm

File receiver with content convertion.

File Receiver with Content Conversion

----------------------------------------------------------------------------

Refer the below links for complete understanding of the FCC

File Content prameters for the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

File Content prameters for the Sender Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Refer

File Receiver with Content Conversion

File Receiver with Content Conversion

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File content conversion sites

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

File Content Conversion for Unequal Number of Columns

File Content Conversion for Unequal Number of Columns - FCC

Content Conversion (Pattern/Random content in input file)

Content Conversion (Pattern/Random content in input file) - FCC

XI Configuration for MDM Integration - Sample Scenario - FCC - MDM

File to R/3 via ABAP Proxy

File to R/3 via ABAP Proxy - FCC

XI/PI: 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

File Content prameters for the Receiver Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/frameset.htm

File Content prameters for the Sender Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Refer

File Receiver with Content Conversion

File Receiver with Content Conversion

Configuring the Receiver File/FTP Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/95/bb623c6369f454e10000000a114084/frameset.htm

File content conversion sites

Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)

Introduction to simple (File-XI-File)scenario and complete walk through for starters(Part2)

File Receiver with Content Conversion

Content Conversion (Pattern/Random content in input file)

NAB the TAB (File Adapter)

Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)

Introduction to simple (File-XI-File)scenario and complete walk through for starters(Part2)

How to send a flat file with various field lengths and variable substructures to XI 3.0

Content Conversion (Pattern/Random content in input file)

NAB the TAB (File Adapter)

File Content Conversion for Unequal Number of Columns

Content Conversion ( The Key Field Problem )

The specified item was not found.

File Receiver with Content Conversion

http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

XI in the role of a FTP

XI in the role of a FTP - FCC

Regards

Srinivas