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.
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
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
Add a comment