cancel
Showing results for 
Search instead for 
Did you mean: 

FCC for file receiver help

former_member190543
Participant
0 Kudos

Hi all,

My source xml is:

node1_mt

<node2>

  <node3> 0 to u

     field1

     field2

     field3

     <node4> 0 to u

        fielda

        fieldb

        fieldc

     </node4>

  </node3>

  fieldaa

  fieldbb

My target file should be: (csv)

field1 field2 field3

fielda fieldb fieldc

fielda fieldb fieldc

...

fielda fieldb fieldc

How should I have my FCC parameters please?

Many thanks.

Ramesh.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member190543
Participant
0 Kudos

Hi experts,

Any ideas please?

How to separate the item line from my header for the first item line in the target csv file?

Thanks.

former_member190543
Participant
0 Kudos

I am giving my recordset structure as:

Recordset Structure: node2,node3,node4

node2.fieldSeparator   = ,

node3.fieldSeparator   = ,

node4.beginSeparator = 'nl'

node4.fieldSeparator   = ,

node4.endSeparator   = 'nl'

and it is not producing the desired result.

Thanks.

former_member312864
Active Participant
0 Kudos

is thr any repetation for node3 and node4 if yes then it has to be captured in recordset structure

former_member312864
Active Participant
0 Kudos

instead of node4 beginSeparator add node3 endSeparator

former_member190543
Participant
0 Kudos

Hi Sarojkanta,

I tried that, but still giving me output as:

field1 field2 field3 fielda fieldb fieldc

The 'nl' for header is not working.

Any idea?

Thanks.

former_member312864
Active Participant
0 Kudos

have you tried with node2.addHeaderLine value 1

former_member190543
Participant
0 Kudos

I tried, but it still doesn't make any difference. I think I am missing some other parameter. It is considering the fields under the next node as the fields under the header and populating everything in one line.

Thanks,.

former_member312864
Active Participant
0 Kudos

share your complete target structure

former_member190543
Participant
0 Kudos

ok, now got a bit further.

I am just using:

Recordset structure: header,item

header.addHeaderLine  = 1

header.fieldSeparator    = ,

header.endSeparator    = 'nl'

item.fieldSeparator       = ,

item.endSeparator       = 'nl'

This is creating the output file as: (for multiple items)

field1  field2 field3 fielda fieldb fieldc

fielda fieldb  fieldc

fielda fieldb  fieldc

Now my only question is how can I take the first item line and put it in a separate line instead of the header?  like...

field1  field2 field3

fielda fieldb fieldc

fielda fieldb  fieldc

fielda fieldb  fieldc

Many thanks.

former_member312864
Active Participant
0 Kudos


you can add one more parameter "header.fieldNames" see is thr any change is output.

also pass the item.fieldNames

former_member190543
Participant
0 Kudos

I tried adding the fieldNames for both header and item, but still no difference. I also tried putting the beginSeparator for the item line, but it puts an empty line before each line item. The first tiem line still comes next to the header.

Any other thing I can try?

Thanks.

former_member312864
Active Participant
0 Kudos

try filedFixedLengths in header

former_member190543
Participant
0 Kudos

I tried that also, still makes no difference