pick up a file from url in a field and drop to target folder

[Former Member]

Hi Guys,

I have no clue how to go abt the requirement...pls let meknow if this possible...

I have an xml file with one field coming in as link

<address>http://xtz/file.jpeg</address>

The requirement is that XI should pick up the file from the address aand drop t to the target folder...

I dont see how this possible in XI...has ne one doe it before..

Pls share ur experiences and ideas

Regards,

Teja

[Former Member · Accepted solution]

Hi Teja,

What is the issue here? You have an xml file and you want to put the value as a fixed length file or xml file in output? Please explain your requirement with an example input payload and what you want as output. Your subject and description say two different things. So can you be clear for more inputs here.

Regards,

---Satish

[Former Member · Accepted solution]

hello satish,

I will try to articulate it more so u can share your views...

The input payload from the incomin xml file has a field carrying a link like this..

That link actually is the place where an image file is stored...

<name>test</name>

<add>testaddress</add>

<address>http://testfolder/source/imagefiles/image1.jpg

and the output file is

<name>test</name>

<addr>testaddress</add>

So the requirement is to pick up the source file and post it in the target folder for xml and pick up the

jpeg file from the link provided within the address field and drop the jpeg file in the

http://testfolder/target/imagefiles/image1.jpg

This is the entire scenario,

Is it possible in PI?

Pls share ur thughts, pls help me out

Regards,

Teja

Edited by: Ravindra Teja on Sep 30, 2009 8:51 PM

[Former Member · Accepted solution]

Teja,

If you have access to the testfolder from where you want to copy / write file then its pretty simple.

You can use Java mapping. Inside java mapping you can read image file as a binary64 data from source and recreate same file on target. You can read image name from the xml node.

Let me know if you need more details.

Hope this will help.

Thanks,

Nilesh

[Former Member · Accepted solution]

Hey

As far as i know,this will be really tricky to implement (it at all possible in XI).

The reason being that the URL you will get in the payload will most probably will be dynamic (keep on changing in every payload) and since you can't configure a sender SOAP adapter for dynamic URL,you won't be able to pick the file.

Thanks

Aamir

[Former Member · Accepted solution]

Hi Aamir,

I was not able to follow your idea of using SOAP adapter, where can i incorporate this scenario?

Cos I have a sender file adapter, file is picked, one field in xml has url...how/ where can i use sender SOAP adapter

[Former Member · Accepted solution]

Hey

>>one field in xml has url

From what i understand is that you will pick up a file from some FTP location ,this file has a tag <address> ,you also need to pick a image file from this URL.so basically you need to pick 2 files (one is main file and other is image),right?

when you mentioned URL,i assumed that the image is accessed via some webservice so you can use SOAP to pick it up.

In case the image file exist on the same FTP server then you need to use sender File adapter (instead of SOAP) but even there you can not specify dynamic directories to pick files from.

For file adapter to pick files,we have to specify all the directories beforehand.

Thanks

Aamir

[Former Member · Accepted solution]

Thanks for the reply Aamir,

That is the exact requirement, sender file adapter...

is there any work around to achieve the same??..

can we call a piece of java code from a UDF to drop that image file to a particular folder and then design another interface for the image file from that particular location??

would it be possible??

Appreciate ur thoughts

Regards,

Teja

[Former Member]

Hi Teja,

According to my experience it is not possible.

After picking the file from the source folder we can take the link, but how we can connect to that link and how we can take the file, i don't think its possible by using the standatd functionality.

you can try with userdefined function module.

Regards

Ramesh

[agasthuri_doss]

Teja,

> XI should pick up the file from the address

If the URL created by XI means is it OK, If that so use SOAP Adapter..Create WSDL file and pass to the source system..Let them post the data.

Cheers

Agasthuri