File Content Conversion.

[Former Member]

Hi all,

I am implementing a FILE TO FILE scenario.

I just wanted to know how exactly do the following FCC parametrs work for the Receiver File adapter:

<record_name>.addHeaderLine

<record_name>.headerLine

<record_name>.fixedLengthTooShortHandling

Also , I want the flat file created to have a header in the center of the file .

For example:

< spaces > HEADER

$$$$$$$$$$$$$$$$$$$$$$$$$$

@@@@@@@@@@@@@@@

######

also,kindly suggest how do i incorporate a blank line between the header n item records using FCC.

thanks in advance.

Edited by: neha nagrani on Apr 11, 2008 11:57 AM

Edited by: neha nagrani on Apr 11, 2008 11:59 AM

[rodrigoalejandro_pertierr]

hi,

to insert a blank line by FCC put this. E.X

Customer.EndSeparator "\r\n\r\n" or "\n\r\n\r" and dont remember exactly but this is the way.

see this, is the same you want

Thanks

Rodrigo

Edited by: Rodrigo Pertierra on Apr 11, 2008 9:11 AM

[Former Member]

Hi All,

for my receiver FILE ADAPTER:

I am getting followinfg error in the Communication channel monitoring:

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Exception in XML Parser (format problem?):'java.lang.Exception: Message processing failed in XML parser: 'Conversion configuration error: Unknown structure 'ns0:MT_ERROR_REPORT_RX' found in document', probably configuration error in file adapter (XML parser 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:MT_ERROR_REPORT_RX' found in document', probably configuration error in file adapter (XML parser error)'

My recordset structure :HEADER,ERROR_DETAIL,TRAILER.

n my FCC parametrs are:

HEADER.fieldFixedLengths:50,20,10,10

HEADER.endSeparator:'nl'

ERROR_DETAIL.fieldSeparator: ,

ERROR_DETAIL.endSeparator: 'nl'

TRAILER.fieldSeparator : ,

TRAILER.endSeparator: 'nl'

Kindly Help.

[Former Member]

Hi,

Check it according to this

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

REgards

Seshagiri

[rodrigoalejandro_pertierr]

hi,

check whether the structure you define is the same you are specting

which ur structure?? cpy it please

Thanks

Rodrigo

Edited by: Rodrigo Pertierra on Apr 14, 2008 8:52 AM

[Former Member]

Hi all,

if one of my nodes is as follows:

<ERROR_DETAIL>

<INTERFACE_REF></INTERFACE_REF>

<SAP_KEY></SAP_KEY>

<KF1></KF1>

<KF2></KF2>

<ERROR_DESC></ERROR_DESC>

</ERROR_DETAIL>

and if i want all these tag names to appear in the Text file before all records as the header; how sholud i do that .

i tried doing ERROR_DETAIL.addHeaderLine:1

it does not work

my out put should look like this:

Interface_Ref_Key, SAP_Key, Key Field1, Key Field2, Error_Description

aaaaa,bbbb,cccc,ffff,wwww,hhh

etc..etc

please suggest

[Former Member]

Hi,

Regarding this - how do i incorporate a blank line between the header n item records using FCC.

Give the parameters as -

Header.addHeaderLine = 2

refer - http://help.sap.com/saphelp_nw70/helpdata/EN/33/c6e63b60c25767e10000000a11402f/frameset.htm

Thanks,

Anoop

[Former Member]

NameA.endSeparator

If you enter a character string here, the system adds it to the last column as a closing character. You can also make this specification in addition to NameA.fieldFixedLengths. To include a line break following the closing character, you must explicitly define it by attaching ´nl´ (including the quotation marks) to the string.

The default value is a line break (no explicit separator after the last column; instead the structures are arranged line-by-line).

NameA.beginSeparator

If you specify a character string here, the system places it before the first column. You can also make this specification in addition to NameA.fieldFixedLengths.

The default value is an empty character string (no separator before the first column).--

Do it this way for blank line.

DETAIL.beginSeparator and specify. 'nl'

is name of your item

note: reward if helpful!!

regards,

Akhil

Edited by: Akhil Rastogi on Apr 11, 2008 2:08 PM

Edited by: Akhil Rastogi on Apr 11, 2008 2:13 PM

[Former Member]

Hi,

Check this

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

/people/shabarish.vijayakumar/blog/2007/08/03/file-adapter-receiver--are-we-really-sure-about-the-concepts

Regards

Seshagiri

[Former Member]

Hi Neha,

Hope you have gone through this link it explains all.

Link:[http://help.sap.com/saphelp_nw70/helpdata/EN/d2/bab440c97f3716e10000000a155106/content.htm]

For spaces before header you can achieve it by placing spaces before the first field of Header in your mapping.

Hope it helps you a bit.

Regards and luck

Akhil

Edited by: Akhil Rastogi on Apr 11, 2008 2:00 PM