File Adapter Reciver Side: FCC Convetion Problum in PI 7.1

[Former Member]

Hi Experts

XML Structure

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

- <ns0:mt_idoc2file xmlns:ns0="http://ns_idoc2file">

- <REC>

- <ROW>

<MATNR>CPF30007</MATNR>

<MTART>ROH</MTART>

<MBRSH>F</MBRSH>

<MAKTX>25 lbs. geschn. Karotten</MAKTX>

<MEINS>LBR</MEINS>

</ROW>

</REC>

</ns0:mt_idoc2file>

i am traying to convert this xml to txt format in PI 7.1 . i am unable to conveting structure in TXT . i am getting the error .

"

Conversion initialization failed: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'REC.fieldFixedLengths' or 'REC.fieldSeparator' is missing"

FCC Parameter what i have given.

Record Struture :ROW,REC

ROW.filedName :MATNR,MTART,MBRSH,,MAKTX,MEINS

ROW.filedSeparator:,

ROW.endSeparator :nl

ROW.fieldFixedLengths:12,20,21,20,10

Please any one help me out from this issu.

Thanks and Regards

G.Praveen Kumar

Edited by: praveen.tecnics on Sep 30, 2010 2:37 AM

[Former Member · Accepted solution]

Hi,

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

- <ns0:mt_idoc2file xmlns:ns0="http://ns_idoc2file">

- <REC>

- <ROW>

<MATNR>CPF30007</MATNR>

<MTART>ROH</MTART>

<MBRSH>F</MBRSH>

<MAKTX>25 lbs. geschn. Karotten</MAKTX>

<MEINS>LBR</MEINS>

</ROW>

</REC>

</ns0:mt_idoc2file>

FCC Parameter what i have given.

Record Struture :ROW,REC

ROW.filedName :MATNR,MTART,MBRSH,,MAKTX,MEINS

ROW.filedSeparator:,

ROW.endSeparator :nl

ROW.fieldFixedLengths:12,20,21,20,10

Can you please change your data type as per this XML

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

- <ns0:mt_idoc2file xmlns:ns0="http://ns_idoc2file">

- <ROW>

<MATNR>CPF30007</MATNR>

<MTART>ROH</MTART>

<MBRSH>F</MBRSH>

<MAKTX>25 lbs. geschn. Karotten</MAKTX>

<MEINS>LBR</MEINS>

</ROW>

</ns0:mt_idoc2file>

Dont put REC, logically its nt required also.

Now use the same FCC u have specified, it will work, remeber to change the MM accordinly also...

Babu

[Former Member]

Hi Praveen,

It seems your FCC parameters are not correct. Try using below parameters it will surely works

FCC for CSV file should like this:

Recordset Structure : ROW,REC

ROW.fieldSeparator:,

ROW.endSeparator :'nl'

FCC for FieldFixedLegth file should like this:

Recordset Structure: ROW,REC

ROW.fieldFixedLengths:12,20,21,20,10

ROW.endSeparator :'nl'

You can not use fieldName parameter at file FCC receiver configuration, since you are using ROW.fieldName :MATNR,MTART,MBRSH,,MAKTX,MEINS

In additon ROW.endSeparator: 'nl' (must be single quote)

Regards,

Abid Farooque

[former_member192295]

Hi,

I think problem is because of FCC declaration. Follow the below statements it will work

Record Struture :ROW,REC,*

ROW.fieldNames :MATNR,MTART,MBRSH,,MAKTX,MEINS

ROW.filedSeparator:,

ROW.endSeparator :nl

ignoreRecordsetName: true

No need to declare both statements fieldSeparator and fieldFixedLen at a time. One statement is enough either fieldSeparator or fieldFixedLengths.

[Former Member]

Hi Praveen,

You try to remove the "REC" from Record Structure parameter.

Thank you,

Sateesh

[former_member189420]

Hello Praveen,

As I know you can convert structure of level 2 to text file using FCC. Remove the node REC so that you bring the ROW to higher level and end up having only 2 levels. I have faced the same problem and I was able to resolve it by doing what I have suggested you.

Regards,

Anand Patil