File Content Conversation in PI7.1

[Former Member]

Hi frends,

Iam trying file to idoc scenario in PI7.1.i got the required output...i want to write FCC in sender side

my input file structure is

100-100,3000,0001,201,2,ST,0000001000

03,

20100430,20100430

where my XML

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

<ns0:MT_GM_File_Sender xmlns:ns0="http://autoscribe.com/xi/erp/n47/GoodsMovement">

<E1BP2017_GM_ITEM_CREATE>

<Key/>

<MATERIAL>100-100</MATERIAL>

<PLANT>3000</PLANT>

<STGE_LOC>0001</STGE_LOC>

<MOVE_TYPE>201</MOVE_TYPE>

<ENTRY_QNT>2</ENTRY_QNT>

<ENTRY_UOM>ST</ENTRY_UOM>

<COSTCENTER>0000001000</COSTCENTER>

</E1BP2017_GM_ITEM_CREATE>

<E1BP2017_GM_CODE>

<Key/>

<GM_CODE>02</GM_CODE>

</E1BP2017_GM_CODE>

<E1BP2017_GM_HEAD_01>

<Key/>

<PSTNG_DATE>20100430</PSTNG_DATE>

<DOC_DATE>20100430</DOC_DATE>

</E1BP2017_GM_HEAD_01>

</ns0:MT_GM_File_Sender>

i have written fcc as follows...

Document Name : DT_GM_File_sender

Document namespae : http://a.com/xi/erp/n47/GoodsMovement

Recordsetstructure : E1BP2017_GM_ITEM_CREATE,,E1BP2017_GM_CODE,1,E1BP2017_GM_HEAD_01,

KeyFieldName : Key

E1BP2017_GM_ITEM_CREATE.fieldNames :Key,MATERIAL,PLANT,STGE_LOC,MOVE_TYPE,ENTRY_QNT,ENTRY_UOM,COSTCENTER

ignoreRecordsetName : true

E1BP2017_GM_ITEM_CREATE.KeyFieldValue : 1

E1BP2017_GM_ITEM_CREATE.KeyFieldinStructure : ignore

E1BP2017_GM_ITEM_CREATE.fieldSeparator : ,

E1BP2017_GM_ITEM_CREATE.endSeparator: 'nl'

E1BP2017_GM_CODE.fieldNames : Key,GM_CODE

ignoreRecordsetName : true

E1BP2017_GM_CODE.KeyFieldValue : 2

E1BP2017_GM_CODE.KeyFieldinStructure : ignore

E1BP2017_GM_CODE.fieldSeparator: ,

E1BP2017_GM_CODE.endSeparator : 'nl'

E1BP2017_GM_HEAD_01.fieldNames : Key,PSTNG_DATE,DOC_DATE

ignoreRecordsetName : true

E1BP2017_GM_HEAD_01.KeyFieldValue : 3

E1BP2017_GM_HEAD_01.KeyFieldinStructure : ignore

E1BP2017_GM_HEAD_01.fieldSeparator : ,

E1BP2017_GM_HEAD_01.endSeparator : 'nl'

Help me out whr i went wrong r provide me necessary for my requirment

Thanks in advance.

Dinesh

[Former Member]

Hi Dinesh,

[Document Name : DT_GM_File_sender]

Document Name should always be your Message Type and not Data Type..... kindly rectify this....

Cheers

Dhwani

[Former Member]

hi dhwani,

i have changed it to messagetype..but iam getting this error...

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'E1BP2017_GM_ITEM_CREATE.keyFieldValue': no value found

help me out r else try to gve me FCC ...

With Regards,

Dinesh

[Former Member]

HI Dinesh,

Also you say 1, 2, 3 are your Key fields in the file structure....but these values should be present in your input file to distinguish between the 3 lines.

Also in your XML, I can not see the value "03" (line 2 value in your file) getting populated in the XML.

Please chcek this, and to use your Key Field concept you need to have the key fields as a part of your XML.

Cheers

Dhwani

[Former Member]

Hi Dinesh,

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Mandatory parameter 'E1BP2017_GM_ITEM_CREATE.keyFieldValue': no value found 

As i mentioned the xml does not have the Key Fields 1,2,3 as you mentioned in the FCC..... you need to have values to be present in your input file.....

kindly check this...

Cheers

Dhwani

[Former Member]

hi dhwani,

i have changed my input file as

1,100-100,3000,0001,201,2,ST,0000001000

2,03

3,20100430,20100430

but stil iam getg the same error....

this is my input xml...

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

<ns0:MT_GM_File_Sender xmlns:ns0="http://autoscribe.com/xi/erp/n47/GoodsMovement">

<E1BP2017_GM_ITEM_CREATE>

<Key>1</Key>

<MATERIAL>100-100</MATERIAL>

<PLANT>3000</PLANT>

<STGE_LOC>0001</STGE_LOC>

<MOVE_TYPE>201</MOVE_TYPE>

<ENTRY_QNT>2</ENTRY_QNT>

<ENTRY_UOM>ST</ENTRY_UOM>

<COSTCENTER>0000001000</COSTCENTER>

</E1BP2017_GM_ITEM_CREATE>

<E1BP2017_GM_CODE>

<Key>2</Key>

<GM_CODE>03</GM_CODE>

</E1BP2017_GM_CODE>

<E1BP2017_GM_HEAD_01>

<Key>3</Key>

<PSTNG_DATE>20100430</PSTNG_DATE>

<DOC_DATE>20100430</DOC_DATE>

</E1BP2017_GM_HEAD_01>

</ns0:MT_GM_File_Sender>

Help me out to solve ths issue.

With Regards,

Dinesh

Edited by: Dineshbabu.M on May 19, 2010 11:55 AM

[Former Member]

Hi Dinesh,

Follow the below blog by shabrish:

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

This will help you resolve your issue......

Also check....

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

Cheers

Dhwani

Edited by: dhwani kamdar on May 19, 2010 3:38 PM

[Former Member]

hi dhwani,

usin that blog i have made the following changes..but iam stil getting the same error.

My FCC Content

E1BP2017_GM_ITEM_CREATE.fieldSeparator ,

E1BP2017_GM_ITEM_CREATE.fieldNames :Key,MATERIAL,PLANT,STGE_LOC,MOVE_TYPE,ENTRY_QNT,ENTRY_UOM,COSTCENTER

E1BP2017_GM_ITEM_CREATE.KeyFieldValue : 1

E1BP2017_GM_ITEM_CREATE.keyFieldInStructure : ignore

E1BP2017_GM_CODE.fieldSeparator : ,

E1BP2017_GM_CODE.fieldNames : Key,GM_CODE

E1BP2017_GM_CODE.KeyFieldValue : 2

E1BP2017_GM_CODE.keyFieldInStructure : ignore

E1BP2017_GM_HEAD_01.fieldSeparator : ,

E1BP2017_GM_HEAD_01.fieldNames : Key,PSTNG_DATE

E1BP2017_GM_HEAD_01.KeyFieldValue : 3

E1BP2017_GM_HEAD_01.keyFieldInStructure : ignore

ignoreRecordsetName : true

my flatfile structure is like ths :

100-100,3000,0001,201,2,ST,0000001000

03

20100430,20100430

I need FCC.Help me out

Regards,

Dinesh

[Former Member]

Hi Dinesh,

Can you please post the Source Data Type that you have created in your IR.....

Cheers

Dhwani

[prasanna_shanmugasundaram]

what is the issue?? what are you looking for??