Receiver File content Conversion

[Former Member]

Hi all.

plz help me in this file content conversion.......i have given the Content conversion parameters I gave for this i am getting the output at all....

<b><u>XML file without Content conversion parameters</u></b>

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

<ns1:mt_IB_WIP xmlns:ns1="urn:agrp:ib">

<ROU>

<Record_Type>ROU</Record_Type>

<Sender_ID>philips.99015338</Sender_ID>

<Receiver_ID>philips.AP</Receiver_ID>

<Document_Type>OSTRPT</Document_Type>

<Sender_ID_qualifier/>

<Receiver_ID_qualifier/>

<Document_version_number>ADIDAS.AP</Document_version_number>

<Filler/>

<HDR>

<Record_Type>HDR</Record_Type>

<Vendor_ID>789002</Vendor_ID>

<Purchase_order_number>507437001</Purchase_order_number>

<Customer_order_number>0271327071</Customer_order_number>

<Article_number>011009</Article_number>

<Transfer_date>1817</Transfer_date>

<Transfer_time>1817</Transfer_time>

<WIP_date/>

<Division>1</Division>

<WIP_date_qualifier>LC</WIP_date_qualifier>

<Client_Number>0504</Client_Number>

<LSCD/>

<Reason_Code>00</Reason_Code>

<Filler/>

<STS>

<Record_Type>STS</Record_Type>

<Vendor_id>789002</Vendor_id>

<Purchase_order_number>507437001</Purchase_order_number>

<Customer_order_number>0271327071</Customer_order_number>

<Article_number>011009</Article_number>

<Transfer_date>20070612</Transfer_date>

<Transfer_time>1817</Transfer_time>

<Free_text_description/>

<Division>1</Division>

<Filler/>

</STS>

</HDR>

<HDR>

<Record_Type>HDR</Record_Type>

<Vendor_ID>789002</Vendor_ID>

<Purchase_order_number>507437001</Purchase_order_number>

<Customer_order_number>0271327071</Customer_order_number>

<Article_number>011009</Article_number>

<Transfer_date>1817</Transfer_date>

<Transfer_time>1817</Transfer_time>

<WIP_date>20070612</WIP_date>

<Division>1</Division>

<WIP_date_qualifier>FC</WIP_date_qualifier>

<Client_Number>0504</Client_Number>

<LSCD>20070612</LSCD>

<Reason_Code>00</Reason_Code>

<Filler/>

<STS>

<Record_Type>STS</Record_Type>

<Vendor_id>789002</Vendor_id>

<Purchase_order_number>507437001</Purchase_order_number>

<Customer_order_number>0271327071</Customer_order_number>

<Article_number>011009</Article_number>

<Transfer_date>20070612</Transfer_date>

<Transfer_time>1817</Transfer_time>

<Free_text_description/>

<Division>1</Division>

<Filler/>

</STS>

</HDR>

</ROU>

</ns1:mt_IB_WIP>

<b><u>This is file format required by client</u></b>

ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

HDR7530016520490010450164320 089490 200706121729200706221 LC0560200706220000

STS7530016520490010450164320 089490 200706121729 1

ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

HDR753001651906001PO0067109-1000 089490 200706121729200706201 LC0560200706200049

STS753001651906001PO0067109-1000 089490 20070612172903 - PHILIPS SYSTEM PROBLEM 1

ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

HDR753001651905001PO0067108-1000 089490 200706121729200706201 LC0560200706200049

STS753001651905001PO0067108-1000 089490 20070612172903 - PHILIPS SYSTEM PROBLEM 1

ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

HDR7530016505190010271407426 089490 200706121729200706221 LC0560200706220000

STS7530016505190010271407426 089490 200706121729 1

ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

<u><b>Content conversion parameters I gave</b></u>

Record set structure ROU,1,HDR,,STS,

ROU.fieldFixedLengths 3,35,35,6,5,5,5,26

ROU.endSeparator 'nl'

ROU.fieldNames

Record_Type,Sender_ID,Receiver_ID,Document_Type,Sender_ID_qualifier,Receiver_ID_qualifier,Document_version_number,Filler

ROU.keyFieldValue ROU

HDR.fieldFixedLengths 3,6,9,16,8,8,4,8,3,2,4,8,4,49

HDR.endSeparator 'nl'

HDR.fieldNames

Record_Type,Vendor_ID,Purchase_order_number,Customer_order_number,Article_number,Transfer_date,Transfer_time,WIP_date,Division,WIP_date_qualifier,Client_Number,LSCD,Reason_Code,Filler

HDR.keyFieldValue HDR

STS.fieldFixedLengths 3,6,9,16,8,8,4,50,3,1

STS.endSeparator 'nl'

STS.fieldNames Record_Type,Vendor_id,Purchase_order_number,Customer_order_number,Article_number,Transfer_date,Transfer_time,Free_text_description,Division,Filler

STS.keyFieldValue STS

**************plz tell me what i will have to add to get get the desired out put ...

...plz help me in solving this**********

thanks

shakif<u></u>

[Former Member · Accepted solution]

Hey

first of all check in RWB under adapter monitoring,what is the error you are getting for the receiver file adaapter

Thanx

Ahmad

[Former Member]

Ok juz u use the following and try

addHeaderLine = 0

fieldFixedLengths = as per the requirement

fixedLengthTooShortHandling = ignore.

endSeparator = 'nl'

it will definetly work

<b>Cheers,

*RAJ*

*REWARD POINTS IF FOUND USEFULL*</b>

[vikas_agarwal]

Hi,

You dont have to pass the occurance in the Recordsetstructure and also u dont have to pass field names.And add headerline like

Rou.addHeaderLine = 0

HDR.addHeaderLine = 0

STS.addHeaderLine = 0

regards

Vikas

[Former Member]

hi shakif,

U r getting :ROUPHILIPS.99018623 PHILIPS.AP OSTRPT W1

row multiple times whereas u have defined it in the FCC parameters as ROU,1

which means that its occurence is 1 ,Please chk the structure and then put the parameters .

Regards,

[RKothari]

Hi,

I would also suggest that there is no need of passing 'fieldnames' along with the occurance in the recordset structure.

Regards,

Rahul

[Former Member]

Hi,

you should not pass the occurance in recordset stucture shakif.

Regards

Pushkar

Message was edited by:

Pushkar Anand