FCC on sender side

[Former Member]

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

[Former Member]

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

[GabrielSagaya]

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'

[Former Member]

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

<b>help.Sap.com</b>

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

[Former Member]

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

[Former Member]

Hi Ramesh

Node4 is a subelement of Node3. so can u suggest me how to proceed

Thanks

Hema

[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

[prabhu_s2]

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

[Former Member]

HI,

Refer the below thread for FCC.

Thnx

Chirag Gohil