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

FCC on sender side

Hi All,

I need to do FCC on the sender side.I need to read the data in to the following structure.

<b>Record</b>

++<b>Node1</b>

+++Name

+++ID

++<b>Node2</b>

+++Salary

+++Sign

++<b>Node3</b>

+++Location

+++Phone

+++<b>Node4</b>

++++DOB

++++Company

++++DOJ

Sample data

Ajay,888----


> Node1 fields

20000,----


> Node2fields

Pune,9999999999,<b>22101985,XYZ,19102008,27031982,PQR,18122005,02041983,ZZZ,26122008</b>----


>Node3 fields

Bolded fields of the node 3 fields are node 4 fields repeating 3 times.

Could any one suggest me how to carry out FCC for this.

Thanks in advance

Hema

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

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

    HI,

    Refer the below thread for FCC.

    Alert Inbox displays 80 characters only.

    Thnx

    Chirag Gohil

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2007 at 06:14 AM

    /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

    Add a comment
    10|10000 characters needed characters exceeded

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

    hi Hema,

    this might help you

    Document Name - Message Type Name

    Document Namespace - give the namespace

    Recordset Name- Record

    Recordset Structure - Node1,,Node2,,Node3,,Node4,

    Recordset per Message *

    Node1.fieldNames - Name,ID

    Node1,fieldSepartor - ,

    Node1.keyFieldValue - (give unique) - ID

    Node2.fieldNames

    Node2,fieldSepartor - ,

    Node1.keyFieldValue -

    Node3.fieldNames

    Node3,fieldSepartor - ,

    Node1.keyFieldValue -

    Node4.fieldNames

    Node4,fieldSepartor - ,

    Node1.keyFieldValue -

    Just for help refer these blogs

    /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

    /people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

    /people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

    /people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

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

    /people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

    regards

    Ramesh P

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hema,

      <b><Node4 is a subelement of Node3. so can u suggest me how to proceed></b>

      Same as for Node3.

      <b>Suggestion:</b> Rewarding the points can increase the response rate. So always reward points for helpful answers.

      Regards,

      Sarvesh

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

    Hope this will help you.

    <b>Introduction to simple(File-XI-File)scenario and complete walk through for starters(Part1)</b>

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

    <b>Introduction to simple (File-XI-File)scenario and complete walk through for starters(Part2)</b>

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

    <b>Content Conversion (Pattern/Random content in input file)</b>

    /people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

    <b>How to send a flat file with various field lengths and variable substructures to XI 3.0</b>/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    <b>File Content Conversion for Unequal Number of Columns</b>

    /people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

    <b>Content Conversion ( The Key Field Problem )</b>

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

    <b>How to send a flat file with fixed lengths to XI 3.0 using a Central File Adapter</b>

    /people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter

    help.Sap.com

    http://help.sap.com/saphelp_nw04/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2007 at 06:50 AM

    Hi

    Document Name - MessageType

    Document Namespace - namespace

    Recordset Name- Record

    Recordset Structure - Node1,1,Node2,1,Node3,3,Node4,3

    Recordset per Message *

    Node1.fieldNames - Name,ID

    Node1,fieldSepartor - ,

    Node1.endSeparator -'nl'

    Node2.fieldNames- Salary, sign

    Node2,fieldSepartor - ,

    Node2.endSeparator -'nl'

    Node3.fieldNames-Location,phone

    Node3,fieldSepartor - ,

    Node3,endSepartor - ,

    Node4.fieldNames-DOB,Company,DOJ

    Node4,fieldSepartor - ,

    Node4,endSepartor - 'nl'

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi Hema

    you can use the following content conversion at the sender side.

    according to ur structure you have to make the occurence for the node 3 and node 4 as 0..unbounded.

    node1.fieldSeparator :,

    node1.fieldNames :name,id

    node1.keyFieldValue :1

    node2.fieldSeparatr :,

    node2.fieldNames :salary,sign

    node2.keyFieldValue :2

    node3.fieldSeparatr :,

    node3.fieldNames :location,phone

    node3.keyFieldValue :3

    node4.fieldSeparatr :,

    node4.fieldNames :DOB,company,DOJ

    node4.keyFieldValue :4

    you must also have the key field in your file.

    if you still face the problem please reply me back.

    Thanks

    Rinku

    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.