File Content Conversion(SenderFileadapter) fields parameters

[Former Member]

Hi all

I am doing aFile to File scenario,

Using content Conversion at SENDER FILE adapter

my source message type is as :

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

<ns0:MT_Cnet_Source xmlns:ns0="http://abc.com/Cnet">

<<b>HeaderPayment</b>>

<First_Payt_Doc/>

<Beneficiary_email_id/>

<<b>/HeaderPayment</b>>

<<b>AdviceFormat</b>>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

<<b>/AdviceFormat</b>>

<<b>LineItem</b>>

<Title1/>

<Title3/>

<<b>/LineItem</b>>

<<b>FILENAME</b>>

<FNAME/>

<<b>/FILENAME</b>>

</ns0:MT_Cnet_Source>

it has 3 structures :HeaderPayment(0,1),AdviceFormat(0,1),LineItem(0,unbounded)

in Recordsetstructure i gave= HeaderPayment,1,AdviceFormat,1,LineItem,1

in FCC parameters i used

HeaderPayment.fieldname... =First_Payt_Doc,Beneficiary_email_id

HeaderPayment.fieldseperator ='nl'

HeaderPayment.endseperator ='nl'

ignorerecordset = true

similarly for rest 2 structure also

my source text file is type :

we0023

lesli@gmail.com

xyc

acd

21/05/2007

10034

acccd

payment

i tried alot of options,refering sdn..still on reading the file value are not coming in the designated fields...

Thanks &Regards,

ajay

[bhavesh_kantilal · Accepted solution]

You need to use a KeyField in this case.

Refer to this blog and try to use the Concept of key field for the content conversion to take place,

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

Regards

Bhavesh

[Former Member · Accepted solution]

Dear Bhavesh

one of my field contain<b> _{</b> and <b>}H</b> as key fields,

does it create any problem,

i am getting an error HeaderPayment.KeyFieldValue is not found

Regards

ajay

[Former Member · Accepted solution]

Hi ,

<i>n Recordsetstructure i gave= HeaderPayment,1,AdviceFormat,1,LineItem,1</i>

You have multiple occurance of lineitem so you should give it as,

Recordsetstructure e= HeaderPayment,1,AdviceFormat,1,LineItem,*

Thanks ,

Suvarna

[Former Member · Accepted solution]

hey ajay,

as u have mentioned that there are special character ~ and ~H as key fields

could u please show the actual content of text file you want to read.

Thanks.

[Former Member · Accepted solution]

You are Right i correct it but i sxmb_moni

i get as <HeaderPayment>

<First_Payt_Doc/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

</AdviceFormat>

<LineItem>

<Title1/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

<HeaderPayment>

<First_Payt_Doc/>

<Beneficiary_email_id/>

</HeaderPayment>

<AdviceFormat>

<Client_Code/>

<Payment_Document_No/>

<Document_Date/>

</AdviceFormat>

<LineItem>

<Title1/>

<Title3/>

</LineItem>

<FILENAME>

<FNAME/>

</FILENAME>

the header payment should not repeat....

Regards

Ajay

[Former Member · Accepted solution]

Hi Ajay ,

First check the occurance of HeaderPayment node it should be 1..1

and when you map HeaderPayment right click on the source field and check the context it should be HeaderPayment .

Thanks ,

Suvarna

[Former Member · Accepted solution]

Hi all

the source txt file is as...some fields are blank also...

~

25/05/2007

ID1

SAP

2000000069

1000.00

INR

R

A00150

SONY COMPANY LIMITED

MUMBAI

530023

HDFCB

SAP1

25/05/2007

25/05/2007

R

MUM

000

2400450003328

SBI BANK LIMITED

~

~H

SAP

2000000069

25/05/2007

~D

Invoice Number:INVOICE NO XXXX

Invoice Date:25/05/2007

Document No:1900000078

Document Date:25/05/2007

thanks & regards

ajay

[Former Member]

hey ajay,

1. your recordset structur should be

HeaderPayment,,AdviceFormat,,LineItem,*.

• is used for zero occurence or more than one occurence. and 1 only is occurence is 1.

2. no need of using keyfield here .

3.

HeaderPayment.fieldnames. =First_Payt_Doc,Beneficiary_email_id

HeaderPayment.fieldseperator ='nl'

HeaderPayment.endseperator ='nl'

is ok..

try and let us know the result..