File content conversion

[Former Member]

Hey guys

i have an XML structure of the following form

<aaa>

<bbb>

<ccc>

<ddd>---</ddd>

<eee>---</eee>

</ccc>

</bbb>

</aaa>

is it possible to get a CSV file on the receiver side of the following form?

if yes,then how?

aaa bbb ccc ddd eee

thanx

ahmad

[Former Member · Accepted solution]

Hi,

Also see the below links

also

Regards

Chilla

[Former Member · Accepted solution]

hey guys

my FCC is working fine on the receiver side,i used

record structure : aaa, bbb, ccc, ddd, eee,

i tried with

record structure : aaa,, bbb,, ccc,, ddd,, eee,* as well but it doesn't seem to work,may be i m doing something wrong in the second case but i guess on receiver side occurence

( "*") is not required.

thanx

ahmad

[Former Member · Accepted solution]

Hi Ahmad,

See the my answer , i have given the * is more occurrances , if you have no occurrences the donot use *. at last problem solved with this sol only. ihope.

Regards

Chilla

[Former Member · Accepted solution]

yh finally my problem is solved:)

[Former Member · Accepted solution]

Hi,

Thanks

Regards

Chilla

<i>Points reward if it is helpful..</i>

[former_member182418]

Hi Ahmed,

have look in following link:-

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

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

with regards,

Ravi raika

[Former Member]

Hi Ahmad,

Yes it is possible

In record structure : aaa,, bbb,, ccc,, ddd,, eee,*

Note : here * is the occurrences if it is 1 or some number then replace * with that number

IN processing parameters

aaa.fieldSeparater :,

bbb.fieldSeparator :,

ddd.fieldSeparater :,

eee.fieldSeparator :,

Use the endseparator as 'nl'

aaa.endSeparator : 'nl'

Regards

Chilla

[Former Member]

chilla,

you cant have this in reciver side

<b>In record structure : aaa,, bbb,, ccc,, ddd,, eee,*

Note : here * is the occurrences if it is 1 or some number then replace * with that number</b> >>> this not sender.

follow this.

In record structure : aaa, bbb,ccc, ddd, eee

aaa.fieldSeparater :,

bbb.fieldSeparator :,

ddd.fieldSeparater :,

eee.fieldSeparator :,

Use the endseparator as 'nl'

aaa.endSeparator : 'nl'

[former_member192798]

Hi Chandra,

If you see the XML Structure, <aaa>, <bbb> and <ccc> are separate nodes whereas <ddd> and <eee> are actually child nodes of <ccc>. So the solution which you gave will probably throw an error.

Ahmad should design his data type structure like:-

<details>

<aaa>

<bbb>

<ccc>

<ddd>

<eee>

So that his XML structure will lokk like:-

<details>

<aaa>

<bbb>

<ccc>

<ddd>

<eee>

</ccc>

</bbb>

</aaa>

</details>

Ahmad, just confirm whether I understood right. Based on this you can do the content conversion.

Regards.

[Former Member]

Thanx Chilla

well my concern was that wont it be different as my structure is diff.

will FCC parameters be same for

<aaa>

<bbb>---</bbb>

</aaa>

and

<aaa>---</aaa>

<bbb>---</bbb>

thanx

ahmad

[Former Member]

Hi,

I am sure this will work in reciever side

see the below links

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

Regards

Chilla..

[Former Member]

HI,

Yes same

Regards

Chilla

[Former Member]

Yes i saw the blog . did u see the record structe in that blog? and your record structre. ur structre will not work.

Regards

Sreeram Reddy