cancel
Showing results for 
Search instead for 
Did you mean: 

File Content Conversion problem

Former Member
0 Kudos
387

Hello Guru's,

I just want to read this text file using the file adapter.

Let me know how I have to read this file and pushing in to XI using the FILE CONTENT CONVERSION.

Document name, Document Namespace, Document Offset, Recordset name, Recordset Name space, Recordstructure, recordset Sequence, Recordsets per message, Key Field names, Key field types.

Below are my file structure.

"A",9,"S",20112007,

"X",9,1,"2001","",1.00,49.50,55.00,4.08375,

"X",9,2,"9001","",2.00,45.00,45.00,3.71250,

"X",9,3,"1001","",3.00,32.00,22.00,2.43222,

"X",9,4,"1201","",4.00,22.00,22.00,1.55442,

"X",9,5,"1301","",5.00,23.00,23.00,1.54211,

Can you write the data what need to be given in the File Content Conversion.

Thanks,

Jane.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi jane

as per your input structure

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

you can use the following parameters in the FCC.

RECORD.fieldSeparator :,

RECORD.fieldNames :ur first node field names

RECORD.keyFieldValue :key field value*(i think in ur case it is H)DETAIL.fieldSeparatr :,

DETAIL.fieldNames :ur second node field names

DETAIL.fieldNames :key field value(in this case its D)

if you still face the problem please reply me back.

Thanks

Rinku

Former Member
0 Kudos

I can see the below message in my Communication channel and the file is not reading and nothing is showing in the SXMB_moni.

Cluster Node Details for Channel:

Polling interval started. Length: 30.0 seconds

Processing finished successfully

Processing started

Thanks,

Jane.

Answers (6)

Answers (6)

Former Member
0 Kudos

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

Former Member
0 Kudos

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.

vikas_agarwal
Contributor
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi jane,

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

regards,

latika.