File Content Conversion problem

hi jane,

give ur src xml...it will be easier to tell u the parameters.

regards,

latika.

hi jane,

in your scenario there is no need to give all these parameters.

give only

Document Namespace: give <b>namespace as in ID</b>

Recordset name: give your <b>root structure name</b>

Recordstructure: give all the fields in structure like<b> name,place ,date,*</b>

then go to next step:

give field separator , end separator

and it will work

hope this will help

regards

HONEY

hi,

you need to mention your messagetype name under document name,and the corresponding namespace under document namespace.

Recordset Structure would be the occurence.if you wnat your header to appear once and detail records more than once,then you need to mention as HEADER,1,DETAIL,*;

Recordset Sequence would be the sequence of records in the source xml.and the keyfield names would be the sequence of fieds in the source MT.

for more info you can refer to the links below.

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2

http://help.sap.com/saphelp_nw70/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

http://help.sap.com/saphelp_nw70/helpdata/en/e3/94007075cae04f930cc4c034e411e1/frameset.htm

kindly reward with points if found useful.

regards

madhu

Hi Jane,

In Document Name: Message type name

Document Namespace: namespace of message type

recordset name: Record

RecordsetStucture: Record,1

Recordsets per message : no. of messages you want to process at a time

Recordsets per message : String

Record.fieldSeparator : ,

Record.fieldNames : field1,field2,.....

Record.endSeparator : 'nl'

Hope it will be useful.

Thanks

Hello All,

Here is my file structure parameters to get the vlaues from the file.

InputFile

H,1,X,1234567

D,1,1,Jackson,1,13.00

D,1,2,Johnson,3,23.00

H,2,R,7654321

D,2,1,Freaaga,5,13.00

D,2,2,Steeeve,7,22.00

My Input Structure:

<documentName>

<recordset>

<NameA>

<field-nameA1>field-value</field-nameA1>

<field-nameA2>field-value</field-nameA2>

<field-nameA3>field-value</field-nameA3>

</NameA>

<NameB>

<field-nameB1>column-value</field-nameB1>

<field-nameB2>column-value</field-nameB2>

<field-nameB3>column-value</field-nameB3>

<field-nameB4>column-value</field-nameB4>

<field-nameB5>column-value</field-nameB5>

</NameB>

</recordset>

</documentName>

File Content Conversion parameters in my adapter configuration:

Document name - documentName

Document Namespace - http://sapxi.com/xi/xiname

Recordset name - recordset

Record Structure - NameA,*,NameB

Recordset Sequence - Ascending

Key Field Name - keyvalue

Key Field Type - String

Name Values

NameA.fieldFixedLengths --> 1,1,1,7

NameA.keyFieldValue --> H

NameA.fieldNames --> keyvalue,field-nameA1,field-nameA2,field-nameA3

NameA.fieldSeparator --> ,

NameA.endSeparator --> 'nl'

NameB.fieldFixedLengths --> 1,1,7,1,5

NameB.keyFieldValue --> D

NameB.fieldNames --> keyvalue,field-nameB1,field-nameB2,field-nameB3,field-nameB4,field-nameB5

NameB.fieldSeparator --> ,

NameB.endSeparator --> 'nl'

This is how I am using the file content conversion and still the values are not coming in to XI. Can you check this and correct me where I am missing.

Thanks,

Jane.

Hi Jane,

<i>Cluster Node Details for Channel:

Polling interval started. Length: 30.0 seconds

Processing finished successfully

Processing started</i>

Your Sender File Communication channel is working properly as per your post.You need to check that whether the given Source directory in CC having the file or not and also check the filenaming convention once which you have mentioned in CC. If the file has presents in specfied directory, channel will read that and process the same.If there are any errors occurs your channel will dispaly the same.

Cheers

Veera