Question Re: Dynamic Folder with File to File (XML) without Mapping in Technology Q&A

Dynamic Folder with File to File (XML) without Mapping

Former Member — Mon, 19 Jan 2015 14:45:59 GMT

Dear Experts,

I have received a new requirement on File to File scenario.

PI has to pick a file from one network directory and place it on specific directory. Please note that there will not be any mapping as client does't want to change the file content...

File Names will be:

Partner1_001_Invoice.xml

Partner1_002_Invoice.xml

.........

Partner2_001_Invoice.xml

Partner2_002_Invoice.xml

.....

In Target System, the directories will be like following....

Partner1

---001

---002

Partner2

---001

---002

In this case, PI has pick the file 'Partner1_001_Invoice.xml' file and it should place file on following directory...

Partner1

---001

and so on...

Need help to configure the above interface....

Thanks-
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Mon, 19 Jan 2015 15:47:08 GMT

Here you go.

Dynamic file name in a File to File pass through scenario - Code Gallery - SCN Wiki

You can create a java mapping as per this blog. Using this option, you can create both dynamic file name and dynamic folder with some manipulations in this java code.

Regards,

Kedar

Re: Dynamic Folder with File to File (XML) without Mapping

former_member258865 — Mon, 19 Jan 2015 15:56:47 GMT

Try with variable subtitution: http://help.sap.com/saphelp_nwpi711/helpdata/en/44/6a316af5a23672e10000000a114a6b/frameset.htm

Regards.

Re: Dynamic Folder with File to File (XML) without Mapping

RaghuVamseedhar — Mon, 19 Jan 2015 15:57:54 GMT

http://wiki.scn.sap.com/wiki/display/XI/Dynamic+file+name+for+pass-through+scenario

http://scn.sap.com/community/pi-and-soa-middleware/blog/2015/01/12/dynamic-and-yet-perfectly-static-benefits

please follow steps mentioned in wiki. Use dynamic folder instead of filename.

Re: Dynamic Folder with File to File (XML) without Mapping

praveen_sutra — Mon, 19 Jan 2015 17:36:02 GMT

Hi Rams,

Similar concept can be used.

hope this helps.

thanks and regards,

Praveen T

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 09:28:11 GMT

Dear Praveen,

I am trying to create java code by copying your code, however i am getting many errors. (shown on below screenshot). Could you please check and help me to resolve these?

For Instance the error is like...the import com.sap.aii.mapping.api.AbstractTransformation cannot be resolved

waiting for your feedback...

thanks-
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

praveen_sutra — Tue, 20 Jan 2015 09:34:31 GMT

Hi Rams,

you would require to perform step 3 mentioned in the blog.

Step 3: Right Click on Project-> Properties -> Java Build Path -> Add External Jars.

this should resolve your issue.

thanks and regards,

Praveen T

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 10:00:26 GMT

Thanks Praveen,

Now i am trying to change the java code as per my requirement. However I am unable to do it.

Is it possible to you to help me to build the java code as per my requirement? I have to pick the Root and Subdirectory from the file name and place the file with same name as it picks from the source field.

It would be very thankful if you could help me in this case.

Best Regards,
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:18:03 GMT

Dear Praveen,

I am able to complete the JAVA mapping.

I am using File Adapters both ends and enabled 'Adapter-Specific Attributes' with 'File Name'. Also in the receiver File Adapter i mention * in the target Directory and also on Target File Name.

I ran the interface and it is failed on receiver file adapter with following error...

File processing failed with Target directory 'T:\usr\sap\XD1\DVEBMGS68\j2ee\cluster\server0\*' does not exist and cannot be created

However in the Java Code, for time being i have passed constant Target Directory name.

Following is the code....Could you please check and help me to resolve....

String targetDir= "//intsap/intpi/XD1";

// set the target root directory ends

String subDir ="/";

try {

InputStream inputstream = transformationInput.getInputPayload()

.getInputStream();

OutputStream outputstream = transformationOutput.getOutputPayload()

.getOutputStream();

Map mapParameters = (Map) transformationInput.getInputHeader()

.getAll();

mapParameters.put(DynamicConfigurationKey.create("http://sap.com/xi/XI/Dynamic",StreamTransformationConstants.DYNAMIC_CONFIGURATION), "");

DynamicConfiguration conf = (DynamicConfiguration) mapParameters.get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

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

DynamicConfiguration conf1 = (DynamicConfiguration) mapParameters.get(StreamTransformationConstants.DYNAMIC_CONFIGURATION);

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

String filename=conf.get(key);

// Setting the Directory and Filename

conf.put(key,filename);

conf1.put(key1,targetDir);

// Copying Input file and writing it as Output file

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

inputstream.read(b);

outputstream.write(b);

} catch (Exception exception) {

getTrace().addDebugMessage(exception.getMessage());

throw new StreamTransformationException(exception.toString());

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:26:24 GMT

Hi Praveen,

It's strange, i could see the directory name on Message but it is trying to put it on different folder...

however in the Audit Log...

Adapter Framework caught exception: Target directory 'T:\usr\sap\XD1\DVEBMGS68\j2ee\cluster\server0\*' does not exist and cannot be created

Please help me...

regards,
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:26:38 GMT

Target directory can not be '*', that is the reason why it is failing.

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:27:57 GMT

>>>File processing failed with Target directory 'T:\usr\sap\XD1\DVEBMGS68\j2ee\cluster\server0\*' does not exist and cannot be created

Did you also select the check box for Directory name under adapter specific message attributes in your receiver channel.

I see that you are trying to create the files under "//intsap/intpi/XD1" ? Are you sure if this directory path exists?

is it a shared drive? "//intsap" ?

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:28:47 GMT

Dear Kedar,

In this case, what should be there on Target Directory?

I am passing dynamic target directory from Java Mapping...

Thanks-
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:31:13 GMT

Dear Hareesh,

I didn't select the 'Directory' on Adapter-specific attributes.

Yes, the target directory is exists and its been using for other interfaces also...

Thanks-
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:34:20 GMT

>>>I didn't select the 'Directory' on Adapter-specific attributes.

Please select it. In order to use the dynamic configuration that you set in java mapping, you should select the checkboc for directory as well

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:37:19 GMT

From where you are getting this 'T:\usr\sap\XD1\DVEBMGS68\j2ee\cluster\server0\*' path?

What do you want in your target directory? Is there any condition based on which you will choose particular target directory out of multiple option??

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:45:04 GMT

Thanks Hareesh,

After choosing the 'Directory' i could see that the correct directory name on channel.

regards,

Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:46:55 GMT

Hmm.. You may close the thread if your issue has resolved.

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 15:57:01 GMT

Hi Hareesh,

As of now, I have passed the target Directory as a constant. However as per the requirement I have get the Directory/SubDirectory names from the File Name and place the file on it...

As i am not JAVA resource, I am unable to write the logic on JAVA. It would be thankful if you could provide me some code to get the directory names from the file name....

After this i will close the thread...

Thanks-
Rams

Re: Dynamic Folder with File to File (XML) without Mapping

Former Member — Tue, 20 Jan 2015 16:01:00 GMT

What is your logic? You can simply add if then logic.. below for your reference.

if(filename.equals("Partner2_001_Invoice.xml") {

targetDir = "//configure your directory";

}

else if

{

}