Skip to Content
author's profile photo Former Member
Former Member

File Content Conversion problem

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 05:21 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 04:33 AM

    hi jane,

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

    regards,

    latika.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 05:25 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2007 at 05:39 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2007 at 05:48 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 01:55 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 05:29 AM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.