can sFTP sender channel can pick two format files(fixed lenght and '|'pipe delimited)

[Former Member]

Hi,

I got a scenario where PI picks the file using sFTP adapter and sends to different ECC systems. But the sender system may send two format of files one as Fixed length and another is pipe delimited. But both contains same column names. how do i need to do the message mapping as i need to split the flat file into idoc and File format to send it ECC systems, also can i use the same directory to pick both the files or there should be different directory for PI to pick the file.

[rhviana · Accepted solution]

Hi Selva,

I think it's more interesting the files into differents folders, in this case will be easy for you use CONTENT Conversion, for fixed values and others do "|".

How to do that:

http://www.riyaz.net/sap/xipi-file-content-conversion-for-complex-structures/79/

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

You can use a javamapping to slipt the file and send do IDOC fields.

Kind regards,

BR.

RicardoViana.

[Former Member · Accepted solution]

Hi RicardoViana.

I am new to PI7.30

What type of message mapping i can go with. My files are simple structure like below: based on the delivery number  ranges(depends upon each receiver system)  need to split the file in to Idoc and File.

Dlv.Number | date|   |    |   bill number| | name

XXXXXXXXX | xx/xx/xxxx| | | xxxxxxxxxxxx| | ttttttttttt

XXXXXXXXX | xx/xx/xxxx| | | xxxxxxxxxxxx| | ttttttttttt

Thanks in Advance.

[rhviana · Accepted solution]

Good Selva,

Welcome to SAP PI world !

So you must as I understand use a multi-mapping, could you please read the link below:

http://help.sap.com/saphelp_nwpi711/helpdata/en/21/6faf35c2d74295a3cb97f6f3ccf43c/frameset.htm

After that:

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/90dcc6f4-0829-2d10-b0b2-c892473f1...

Michal has something nice:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/10/18/pixi-pi-73-content-based-routing-...

Regards,

BR.

Ricardo Viana.