IDOC to Flat file

[Former Member]

Hi All,

There is a requirement which needs to convert an incoming ORDERSP IDOC in to a flat file and place it on a target AS2 server. Also the data needs to be separated by special character '|'; could you suggest as to how we can approach and design this scenario. Thanks in advance for your solutions.

Thanks and Regards

[gagandeep_batra]

"There is a requirement which needs to convert an incoming ORDERSP IDOC in to a flat file and place it on a target AS2 server. Also the data needs to be separated by special character '|'; could you suggest as to how we can approach and design this scenario. Thanks in advance for your solutions."

you can use concatenate function in java mapping to concatenate all fields with each other and separated by any character .

[former_member184681]

Hi,

The clue here is to use the Receiver File Adapter with File Content Conversion settings (for instance, "|" as the field separator). Thanks to this, PI will automatically convert your IDoc message from PI's internal XML structure to a properly formatted flat file.

Hope this helps,

Greg

[Former Member]

But the IDOC is a hierarchial structure so only the 1st level of hierarchy fileds are being displayed. Moreover the target is an AS2 server so we cannot use File Adapter.

[rajasekhar_reddy14]

Check with AS2 Team what format they want if they want evry field is separated with Pipe(special character) in one line, then build mapping logic and concatenate all fields and separet with Pipe.

finally do content conversion . not sure about AS2 adapter supports FCC or not.

or

after converting in to one string add second level maping XSLT , and remove prefix tags and genarate output in text mode,,here you can avoid FCC .

Regards,

Raj

[Shabarish_Nair]

you can use FCC and provide the parameter fieldSeperator as |

also for AS2 there is not standard adapter available so you will have to use a 3rd party adapter ex. seeburger