FCC to File

[Former Member]

Hi Frnds,

Iam doing FCC to File Interface my Source Text file Like Below i want send xml File for Receiver Side, How can i Achieve this with Sender FCC Parameters. Please Help on this.

“H”,”E100”,”M”,”IT”,”102, ITPL Bangalore”,”Whitefield”,”BANGALORE”,”560066”

“I”,”234”,”JUNE1”,”01062014”,”450”,””,”450”,”General”,”S”

“I”,”323”,”JUNE7”,”07062014”,”234”,”6”,”240”,”General”,”S”

“I”,”234”,”JUNE21”,”21062014”,”460”,””,”460”,”General”,”S”

“I”,”234”,”JULY14”,”14072014”,”150”,”20”,”170”,”General”,”S”

“T”,”4”,”1330”

Regards,

Rajendar K

[Former Member · Accepted solution]

Hi all,

thanks for All for your Response issue was solved with below Parameters.

Header.endSeparator : "'nl'

Header.fieldSeparator : ,

Header.enclosureSign : "

Header.fieldNames :  key,ID,EmpID,Gender,Department,Address,City,State,Pincode

Header.keyFieldValue :"H"

Item.fieldSeparator : ,

Item.endSeparator :  "'nl'

Item.fieldNames :  key,ID,Item_No,Item_ID,Date,VerifyQty,RejectQty,TotalQty,Description,Status

Item.keyFieldValue : "I"

Item.enclosureSign : "

Trailer.endSeparator : "'nl'

Trailer.fieldSeparator : ,

Trailer.fieldNames :  key,ID,TotalItem,TotalQty

Trailer.keyFieldValue : "T"

Trailer.enclosureSign : "

Regards,

Rajendar K

[naveenkumar_chekuri]

Hi Rajendar,

refer below link for configuration....

Thanks,

Naveen

[Former Member]

Hi,

Add keyfieldname and below entries in FCC.

Header.endSeparator : 'nl'

Header.fieldSeparator : ,

Header.fieldNames : key,field1,field2,field3,...

Header.keyFieldValue : "H"

Header.keyFieldInStructure : ignore

Item.endSeparator : 'nl'

Item.fieldSeparator : key,field1,field2,field3,...

Item.keyFieldValue : "I"

Item.keyFieldInStructure : ignore

Trailer.endSeparator : 'nl'

Trailer.fieldSeparator : key,field1,field2,field3,...

Trailer.keyFieldValue : "T"

Trailer.keyFieldInStructure : ignore

If you dont want double quotes in content use enclosuresign = " in FCC

Please check below links

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

http://wiki.scn.sap.com/wiki/display/XI/Basic+File+Adapter+Content+Conversion

SAPTechnical.COM - File Content Conversion

Regards,

Praveen

[Former Member]

Hi Praveen,

thank for your Reply that file pick from Source directory But Am getting Below Error in SXMB_MONI please find the Screenshot And help on this.

Regards,

Rajendar K

[Former Member]

Hi,

Can you please post the sample source XML and inbound payload for your mapping.

Also please share your FCC in sender file adapter.

Regards,

Praveen

[Former Member]

Hi Rajender,

Perhaps you are using Occurrence 1 in Data Type in ESR and you are not including it in PayLoad or giving it blank value. Set the occurrence 0.1 in Data Type

[Former Member]

Hi Praveen,

please find the the my input text file below

"H”,”E10522”,”M”,”IT”,”102”,”ITPL Bangalore”,”BANGALORE”,”560066"

"I”,”234”,”JUNE1”,”01062014”,”450”,”3”,”450”,”General”,”"

"T”,”4”,”1330"

in moni am getting like below before mapping.

<?xml version="1.0" encoding="utf-8"?>

<ns:MT_E10522_FCC2f_Test_S xmlns:ns="http://E10522_FCC2f_Test">

<Recordset>

    <Header>

        <ID>&quot;H”</ID>

        <EmpID>”E10522”</EmpID>

        <Gender>”M”</Gender>

        <Department>”IT”</Department>

        <Address>”102”</Address>

        <City>”ITPL Bangalore”</City>

        <State>”BANGALORE”</State>

        <Pincode>”560066&quot;</Pincode>

    </Header>

    <Item>

        <ID>&quot;I”</ID>

        <Item_No>”234”</Item_No>

        <Item_ID>”JUNE1”</Item_ID>

        <Date>”01062014”</Date>

        <VerifyQty>”450”</VerifyQty>

        <RejectQty>”3”</RejectQty>

        <TotalQty>”450”</TotalQty>

        <Description>”General”</Description>

        <Status>”&quot;</Status>

    </Item>

    <Trailer>

        <ID>&quot;T”</ID>

        <TotalItem>”4”</TotalItem>

        <TotalQty>”1330&quot;</TotalQty>

    </Trailer>

</Recordset>

</ns:MT_E10522_FCC2f_Test_S>

Pleae Help on This .

Regards,

Rajendar K

[former_member312864]

It means some target mandatory field is not mapped or not getting any value . Please share your target structure and mapping screenshot

[Former Member]

Hi Paridha,

Now am getting the Output but  i didn't any data please find below screevshot.

Regadrs,

Rajendar K

[former_member312864]

share your mapping . root node for target is not mapped thats why your are not getting any target values

[Former Member]

Hi

Please share the screen shot of your mapping. Looks like there is some problem.

Also please make sure that you have mapped your parent node in message mapping.

[Former Member]

Hi Rajender,

There is Test Tab in Mapping where you can is your mapping run properly or not. So first check there and rebound your mapping again

[Former Member]

Hi Parida,

My Mapping is one to one only

and my inbound Payload in MONI is below please find .

<?xml version="1.0" encoding="utf-8"?>

<ns:MT_E10522_FCC2f_Test_S xmlns:ns="http://E10522_FCC2f_Test">

<Recordset>

    <Header>

        <ID>H</ID>

        <EmpID>E10522</EmpID>

        <Gender>M</Gender>

        <Department>IT</Department>

        <Address>102</Address>

        <City>ITPL Bangalore</City>

        <State>BANGALORE</State>

        <Pincode>560066</Pincode>

    </Header>

    <Item>

        <ID>I</ID>

        <Item_No>234</Item_No>

        <Item_ID>JUNE1</Item_ID>

        <Date>01062014</Date>

        <VerifyQty>450</VerifyQty>

        <RejectQty>3</RejectQty>

        <TotalQty>450</TotalQty>

        <Description>General</Description>

    </Item>

    <Trailer>

        <ID>T</ID>

        <TotalItem>4</TotalItem>

        <TotalQty>1330</TotalQty>

    </Trailer>

</Recordset>

</ns:MT_E10522_FCC2f_Test_S>

Regards,

Rajendar K

[former_member312864]

share your target structure and mapping screenshot. Problem is with target field mapping nothing wrong in source structure

[Former Member]

Hi

The problem is happening because of extra field '<Recordset>' in your input payload. You have to remove this from payload.

for that check the content conversion in the file adapter and add the parameter 'ignoreRecordsetName' = true

check this for more details

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

This will solve your problem.

[Former Member]

Hi,

Iam facing Another Issue for this interface if iam using Multiple Item Records its not picking the File please find my Parameters below and mapping please find the above please help on this.

RecordsetStucture : Header,1,Item,*,Trailer,1

Regards,

Rajendar K

[Former Member]

Hi,

Is there any error in sender channel in channel monitoring?

Based on the input i have created FCC, please check and use below parameters

parameters:

Input File:

"H","E100","M","IT","102, ITPL Bangalore","Whitefield","BANGALORE","560066"

"I","234","JUNE1","01062014","450","","450","General","S"

"I","323","JUNE7","07062014","234","6","240","General","S"

"I","234","JUNE21","21062014","460","","460","General","S"

"I","234","JULY14","14072014","150","20","170","General","S"

"T","4","1330"

Input XML:

Regards,

Praveen

[Former Member]

Hi praveen,

as for your suggestion its picking the file But that file not reached to Target directory. please help on this.

Regards,

Rajendar K

[Former Member]

Hi Rajendar,

Check is there any mapping error for the interface in SXMB_Moni? Also check is there any system error in Adapter engine message monitoring.

Regards,

Praveen

[former_member312864]

check for receiver communication channel

[Former Member]

Hi Parida,

that file deleted from Source directory but am not Able to see the message log in Sender CC i don't what is the problem please help on this.

Regards,

Rajendar K

[former_member312864]

Hi Rajender ,

If possible try to use archive option on ther sender side . File missing problem quite occurs in case of file adapter .

Regards,

Sarojkanta