Dynamic receiver file name C1.yyMMdd.C2

Former Member · ‎12-21-2009

PI Experts,

Is it so difficult to acheive in SAP PI? I hope I made the requirement clear.

Scenario: Sender AS2 adapter --> PI --> Receiver File (NFS) Adapter. Just a file pass through, no mapping

Requirement: Irrespective of sender adapter in a file pass through scenatio where we wont read the file (payload just contains the flat file), I want to delivery the same file with the naming convention C1.yyMMdd.C2 where C1, C2 are constants and yyMMdd is cuurent date. So sum up, need to have current date in a file name on receiver side with out reading the payload.

1) Variable substituation works on if we are are receiving the variable value from the payload.

2) Looks like ASMP works only same filename from a sender to a receiver file adapter, because if you are not using sender adapter or using sender adapter without selecting ASMP - File Name, there no way you can receive DynamicConfiguration under SOAP Header. Please correct me if I am worng.

3) Running the OS command after file processing to re-name the file, may be its the last resort, but I would expect and would like to do in PI.

What is the best possible solution?

- Riya Patil

Former Member · ‎01-13-2010

.

Edited by: RaghuVamsee on Jan 13, 2010 2:51 AM

Former Member · ‎01-13-2010

.

Edited by: RaghuVamsee on Jan 13, 2010 2:51 AM

RaghuVamseedhar · ‎01-13-2010

import com.sap.aii.mapping.api.*;

import java.io.*;

import java.util.Map;

public class DataSubString implements StreamTransformation

{

private Map map;

String s;

public void setParameter(Map map1)

{

}

public void execute(InputStream inputstream, OutputStream outputstream) throws StreamTransformationException

{

try

{

// a) Set ouput File name

DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File" , "FileName");

String Outputfile = conf.put(key,("C1" + new Date() + "C2"));

// b) Just copy input file to output file

byte[] b = new bytehttp://inputstream.available();

inputstream.read(b);

String strContent = new String(b);

outputstream.write(strContent.getBytes());

} catch (Exception exception)

{

exception.printStackTrace();

}

Edited by: Raghu Vamsee on Jan 13, 2010 2:49 AM

RaghuVamseedhar · ‎01-13-2010

Hi,

I understand:-

1. File content is not read. So we can send a flat file, JPG file or any binary file.

2. Target file name should be C1 CurrentData C2.

Solutions:-

A. Write a Adapter Module in receiver file channel, it should change the file name as required. In this case, there is no need of ESR at all, we can just do configuration in ID.

/people/william.li/blog/2006/09/08/how-to-send-any-data-even-binary-through-xi-without-using-the-integration-repository

Disadvantage:- Adapter module coding is difficult. Requires more memory to run. Difficult to maintain. When there is other way, why to go with Adapter module :).

B. This is simple solution possible (Using Java Mapping).

Step 1:- In Sender File channel check u201CAdapter u2013 Specific Message Adapteru201D in Advanced tab. File Name should be checked.

Step 2:- In Receiver File channel check u201CAdapter u2013 Specific Message Adapteru201D in Advanced tab. File Name should be checked. Step 3:- Create dummy DT , MT (structure is not all important) in ESR.

Step 4:- Create OM using dummy MT ( sender and receiver MT is same), then MM as Java mapping.

What this Java mapping will do a) change the File Name using DynamicConfiguration (This is an element in SOAP header, you can see this one in SXI_MONITOR). b) Copy input payload to output payload without any change.

Hope you know how to implement Java Mapping. http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8138. [original link is broken] [original link is broken] [original link is broken]

Edited by: Raghu Vamsee on Jan 13, 2010 2:48 AM

former_member200962 · ‎12-22-2009

Requirement: Irrespective of sender adapter in a file pass through scenatio where we wont read the file (payload just 
contains the flat file), I want to delivery the same file with the naming convention C1.yyMMdd.C2 where C1, C2 are constants and 
yyMMdd is cuurent date. So sum up, need to have current date in a file name on receiver side with out reading the payload.

Suppose C1 = Priya, C2 = Patil.....in mapping have the below logic:

Constant1(Riya.) -->
               --> Concat1 -->
currentDate -->
                                    Concat2 --> DyncamicUDF --> AnyTargetNode (can be even target Root Node)
Constant2(.Patil) -->

currentDate is present under the Date functions of Message Mapping.....double-click on currentDate and enter the date format (in your case it will be yyMMdd)

Input to Concat2 will come from Concat1 and Constant2.

UDF for Dynamic Configuration will be:

DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);
DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");
String File_Name = var1 + ".txt";
conf.put(key, File_Name);
return " ";

In above UDF var1 represents the input to UDF....i.e. O/P of Concat2

You do not need to check ASMA in Sender channel.....it should be checked in receiver channel.

Regards,

Abhishek.

Former Member · ‎12-21-2009

Just try this UDF it should work.. I don't have system with me so cannot check it but this is well known solution, so it should work.

DynamicConfiguration conf = (DynamicConfiguration) container.getTransformationParameters().get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);
 
DynamicConfigurationKey key = DynamicConfigurationKey.create("http://sap.com/xi/XI/System/File","FileName");
 
String SourceFileName = "C1." + a + ".C2";

conf.put(key, SourceFileName);

return "";

Dynamic receiver file name C1.yyMMdd.C2

Accepted Solutions (0)

Answers (6)

Answers (6)

Re: generating qrcode using image url in crystal r...

Re: SAP PI - Determine the receiver based on Sourc...

Análise Combinatória de dados de bancos diferentes

Re: generating qrcode using image url in crystal r...

SOAMANAGER - Field Cardinality - Min Occurence - W...