fieldSeparator values in FCC

[Former Member]

Hi Experts,

Please confirm values for the fieldSeparator and endSeparator.

for tabdelimited files:

Record.fieldSeparator = '/t' or '\t'

Record.endSeparator = '/n' or '\n'

and also the values need to be in single quotes or not.

Please suggest.

Thanks in advance.

MK

[GabrielSagaya · Accepted solution]

Record.fieldSeparator = 'ox09'

Record.endSeparator = ' '

the values need to be in single quotes.

For tab separated file

[Former Member]

Thank you all.

I am now getting the below error.

Could not process due to error: java.lang.Exception: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'Conversion configuration error: Unknown structure 'ns0:Message_MT' found in document', probably configuration error in file adapter (XML parser error)'

the source structure is:

ns0:Message_MT
----------Recordset
-------------------Row
------------------------Number
------------------------mode

the target 1 & 2 structure is:

ns0:Message_MT
----------Recordset
-------------------Row
------------------------Number
------------------------mode

we are trying split the source message based on the mode value ( if mode =001 and if mode = 002)

source and target are text files.

Recorset structure (for the target file adapter) :  Recordset,Row

Is the above value is correct.

Please suggest how to resolve it.

Thanks,

MK

[Former Member]

HI

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

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

Please see the below links for file content conversion..

- FCC

- FCC

File Content Conversion for Unequal Number of Columns

- FCC

Content Conversion (Pattern/Random content in input file)

- FCC

- FCC - MDM

XI in the role of a FTP

- FCC

File to R/3 via ABAP Proxy

- FCC

- 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

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

Please see the below links for file content conversion..

- FCC

- FCC

File Content Conversion for Unequal Number of Columns

- FCC

Content Conversion (Pattern/Random content in input file)

- FCC

- FCC - MDM

XI in the role of a FTP

- FCC

cheers

[Former Member]

> Record.fieldSeparator = '/t' or '\t'

> Record.endSeparator = '/n' or '\n'

For fieldSeparator = no need to put coats e.g. if fields are separated with comma then put only , .

For endSeparator = 'nl' (in single coats)

[Former Member]

Hi,

For tabdelimiter take '0X09'

and check some links on FCC

File content conversion sites

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

Regards,

Phani

[Former Member]

Thanks all,

after correcting those values, I am getting the below error for the receiver communication channel.

Delivery of the message to the application using connection File_http://sap.com/xi/XI/System failed, due to: com.sap.aii.af.ra.ms.api.RecoverableException: Channel has not been correctly initialized and cannot process messages.

Error Category: XI_J2EE_ADAPTER_FILE 
Error Code: INITIALIZATION_ERROR

Please suggest further to rectify the issue.

Thanks,

MK

[Former Member]

hi,

Content conversion parameters are case sensitive

Row.f(not F)ieldNames -

Row.f(not F)ieldSeparator-

Row.p(notP)rocessConfiguration - FromConfiguration

Row.e(not E)ndSeparator - 'nl'

check it out

reward points if helpfull

regards

kummari

[Former Member]

hi

specify '0x09' (zero x and zero nine) as field saparator

and '\n' as end separator in single quotes

or

copy and paste the tab space in field separator

reward points if helpfull

regards

kummari

Edited by: kummari on Jul 21, 2008 10:29 AM

Edited by: kummari on Jul 21, 2008 10:31 AM