File Upload Automation?

[RecLambyUK]

Hi guys,

I personally dont believe that I can achieve the following situation but I will ask the question to those far more knowledgable than me!

Anyway... We have a system which generates excel spreadsheets based on the info contained in several files on an FTP server. Is there any way we can take these generated excel files and automatically have them uploaded via a script/program to sharepoint for viewing by the public?

Many thanks in advance.
John

 

[philhege]

Yup. Write a .NET file-watcher service that polls the contents of the target directory (where the generated Excel spreadsheets end up), and uploads any deposited Excel files to the Sharepoint library.

For that matter, what's your spreadsheet generator system written in? Maybe you can put it all in the same wrapper.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[RecLambyUK]

If this can be done philhege, how do you actually place files on sharepoint? I thought as it was all referenced into a DB that you could only upload using the sharepoint interface?

I am sorry if I seem a bit naive here, but could you please explain a little more on your solution?

Kind regards
John

 

[philhege]

You can use the Sharepoint object model to perform the insert, or, in the case of shared libraries, assuming the client has the Web client running, you can just copy the file to the WebDAV share.

Phil Hegedusich
Senior Programmer/Analyst
IIMAK

http://www.iimak.com

-----------
I'll have the roast duck with the mango salsa.

 

[SPSAdmin]

Hello,

Yes, using the webDAV & copying the files on to the sharepoint site document library would be the easiet way of doing this.

Map a network drive to the sharepoint document library, write a batch file which runs the xcopy or copy command.
Schedule a task which invokes the batch file.

thanks