Hello Atlantis,

Did you get a solution for this?

Satgur,

Can you please help by providing a lil info on how can this be achieved as described by you?

Many Thanks,

Cool_D

Hi Satgur,

I choose approach#2, however I didn't find apex code which can post webpage to external server.

Therefore, I use javascript in VF page.

Once user click a button in VF Page, the javascript behind the button is called and a window is pop-up.

In the window, we put extenal server url in it. Then it will post request to java web server where we can store uploaded file. When the file is uploaded into Oracle, the java appliaction will invoke SF web service to store the file name into SF.

In addition, we can use SF id to retreive the file in the external server(Oracle).

One limitation is that only laptop in the intranet network can access the java application.

As most of the SF users in our company will not logon SF outside intranet network. this will not affect them.

Okay, i have a little different scenario!

I want to send the file to an FTP server within the company network. Can i achieve this functionality in a similar way?

Or is there any other way of doing the same?

Many Thanks,

Cool_D

Thanks atlantis, that really helps!!

One more query i have, how do you exactly do this - "In the window, we put extenal server url in it. "

Also, what exactly happens when you do this? Is the file just transferred from local desktop to the server over the wire?

Will it work if instead of a local file, I am sending an attachment link (already existing in salesforce) to the server?

Your help has been gr8!!

Thanks,

Cool_D

Hi,

#1. I am not sure if you are familiar with js. i have pasted my jscode in my VF page below.

================================

<script type="text/javascript">
    var curPopupWindow = null;
    
    function closePopup()
    {
        if (curPopupWindow != null)
        {
            if (!curPopupWindow.closed)
            {
                try {
                    curPopupWindow.close();
                } catch(ex) {
                 // This Exception code is to deal with IE issues checking
                 // The window closed property
                }
            }
            curPopupWindow = null;
            self.history.go(0);
        }
    }
   
   
    function doFileStorage(opt)
    {
        var s = '{!SessionId}';
        var u = '{!$Api.Enterprise_Server_URL_160}';
        var i = '{!doc.Id}';   

        //the application url you need request and the arguments that application needs     
        var q = 'http://jptky840unx.jp.fid-intl.com:16080/file?SfSID='+s+'&SfURL='+u+'&OPT='+opt+'&DocID='+i;
       

        // 1 for upload, 2 for download

        if (opt == 1)
        {
            var t = (screen.height - 400) / 2;
            var l = (screen.width - 600) / 2;

            // this statement is used to pop-up window
            curPopupWindow = window.open(q,'','height=400,width=600,top='+t+',left='+l+',toolbar=no,menubar=no,scrollbars=no,resizable=no,location=no,status=no');
        }

        else if (opt == 2)
        {
            window.location.href = q;
        }
    }  
   
</script>

...

<apex:commandButton value="Attach File" onclick="doFileStorage(1)" action="{!attachFile}"  />

#2. whatever you use to make the application in your interanet, the application will pick up the files user selected in local driver or anywhere they can access in the form of "filestream". Then the application can do the next step as you need.

#3. the you wanna send the attachement link in SF to the application. I think it should also work.

You need to use the attachment id and SF webservice to retrieve the document in SF.

Then put it to the ftp server.

Anyway, if the file is on the SF already, i dont think my solution is the best one.

Maybe you should think about web services or outbounding message.

Hope it is helpful for you.

Best regards,

Atlantis