Focal Point
[SOLVED] Help with getting data from local pc to server

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8861003102

December 13, 2006, 11:52 AM
DKWAN
[SOLVED] Help with getting data from local pc to server
How a fex running in webfocus server (self serv page) copy a file from my local desktop PC?

case- I need to allow user to copy a file from his local c drive and put into a folder in the webfocus server. Since I don't have much knowledger in js etc, any way using a focus fex to do that?
Please help.

This message has been edited. Last edited by: Kerry,



Prod: WebFOCUS 7.1.1 CGI - Self Service - Report Caster,Win2000/IIS
Output: HTML, Excel 2000 and PDF
December 13, 2006, 12:25 PM
susannah
if your server has network rights to access files on that user's pc, then in your fex just filedef the file on the users pc and copy it or read it.
If your server doesn't have those rights, then get your network admin to set them up.
FILEDEF YOURFILE DISK \\computername\directoryname\..\filename.ext



In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 13, 2006, 03:17 PM
RichH
Another possibility might be to code FTP in a batch or script file and execute it from the procedure. You should be able to find examples of this on the ibi site.


WebFOCUS 8202 Win 2012
Test - WebFOCUS 8203 on Win 2012
December 13, 2006, 04:15 PM
TexasStingray
I have used a FileLoader Servlet in the past to upload a users excel file and used the value of one of the columns to create the WHERE statement for a table request. I would search the web for it. The one I used allowed you to specify the directory that the file is to be loaded to.

Scott




Scott

December 14, 2006, 12:33 AM
DKWAN
Thanks. RichH, susannah.
I tried both ways you mentioned. One way or the other, it is not working for my setup.
Scott's suggestion is something I want to see at this moment.
Scott, do you mind provide me the URL or more details to locate the FILELOADER SERVLET.
Thanks so much



Prod: WebFOCUS 7.1.1 CGI - Self Service - Report Caster,Win2000/IIS
Output: HTML, Excel 2000 and PDF
December 14, 2006, 10:14 AM
TexasStingray
Sorry it's File Upload Servlet
Here is couple of links

http://www.servletsuite.com/servlets/upload.htm
http://www.oop-reserch.com/cross_servlet.html

Scott




Scott

November 10, 2008, 04:59 PM
MacLonghorn
Stingray:
With the new MRE, there's a file upload feature but it's not an end user tool, really. Question is: Is there now a FileUpload function that's exposed that we can take advantage of without having to install one of those servlets you mentioned?


Thanks.

Mark
WF 7.6 Windows
November 11, 2008, 04:39 AM
Danny-SRL
DKWAN,

Is this supposed to be a service that you want to extend to your users, or is it part of an application which needs the data from your user's PC?
What type of file? NOTEPAD? EXCEL?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

November 11, 2008, 11:29 AM
MacLonghorn
Once a month, users need to upload a tab delimited file within MRE which will then be inserted to SQL Server. I've got the bulk of the process covered, except for the file upload/save. I've seen the MRE file upload but it's not really made for the end user as it makes you create a MFD. I thought since that was added, there might be an API to allow file uploads.


Thanks.

Mark
WF 7.6 Windows
November 11, 2008, 03:41 PM
Waz
What is the format of the file to be uploaded and what is going to happen to it ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

November 11, 2008, 04:40 PM
MacLonghorn
Waz
I appreciate your response, but if you read my post, you will find the answer. At this point, I simply am trying to upload a file to the server and save it wherever I want, probably in the apps directory.


Thanks.

Mark
WF 7.6 Windows
November 12, 2008, 04:22 PM
Waz
Mark, sorry, but I am a bit confused, the original post was from DKWAN, is this the same issue ?

As for the Tab delimited file, I wrote the original upload routine, and many of its functions and options were discarded when it was IBI'ified, it would allow you to re-execute a previous load with just a call. Unfortunately it is written for V5.2 and uses several ActiveX objects.

I personally think that a jsp to upload the file is the easiest. I have written one myself for the same reasons, the important thing is to have a simple process for the users to follow.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!