on 07-20-2011 7:36 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks everyone for your feedback on the scenario.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
93 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.