Updated : ABAP Proxy to FTP scenario

[former_member191528]

Hello All,

We have a service interface with the following structure where N1,N2,N3 are nodes with attributes within them.

N1

Attribute 1

Attribute 2

N2

Attribute 3

Attribute 4

N3

Attribute 5

Attribute 6

N4

Attribute 7

Attribute 8

We need to convert it into single flat file as follows

Attribute 1 Attribute 2 Attribute 3 Attribute 4 Attribute 5 Attribute 6 Attribute 7 Attribute 8

Can the following be achieved using file adapter ?

Thanks,

Kiran

Edited by: Kiran Sakhardande on Jul 20, 2011 8:40 PM

[Former Member · Accepted solution]

Hi,

Define your receiver message type as :

DT_Rcv

Row ..... 1..unbounded

Attrb1

Attrb2

Attrb3

Attrb4

Attrb5

Attrb6

Attrb7

Attrb8

In your receiver FCC, define the end seperator as new line character.

Another option can be java mapping, wherein in the map itself, you create the text file. Incase you go for this option and you are on PI 7.1, define the inbound service interface as XI3.0 compatible so that it can take a non xml structure.

Regards

[former_member191528]

Thanks everyone for your feedback on the scenario.

[former_member472138]

I suggest you to do it out in simple, change the target structure with strings instead of attributes, and then in FCC use comma separator or fixed field lengths.

Regards

Pothana

[Former Member]

Hi,

As you are using ABAP Proxy, do additional coding to format the data how do you want the data at target side. So that you can send one record as a string, in PI create data type filed with 1..Unbounded. At target use simple FCC to write a file. Try this oprion.

Cheers

Veera

[Former Member]

Hi Kiran,

You can do a concat and get it in one line with FCC.

Else can have multiple fields for each attribute and write in one line using FCC.

Make sure you give example so that somebody can help you out exactly.

Regards,

---Satish

[former_member854360]

Hi Kiran,

This is an interesting requirement.

Using Receiver file adapter FCC we cant convert XML attribute value to flat file.

You need to go for Adapter module or Java Mapping.