Frontpage 2000 auto publish

[Kaci]

How do I put an auto refreshing excel spreadsheet onto a website in Frontpage
2000, so that it will auto refresh, everytime the excel sheet changes?

 

[Jim Buyens]

There's really no good solution for this.

One approach is to set up a link that points to a file sharing location,
such as
<a href="file:\\server\sharename\folder\linens.xls">Sheets</a>. However,
this is only practical on intranets.

Another approach is to set up a timed process that FTPs the file every night
or whatever. However, you have to make sure that the FTP only replaces that
one existing file. If you try to get fancy, you can corrupt the FP server
extensions.

Perhaps best is to simply store, open, and save the spreadsheet directly on
the Web server. Just type a URL such as
http://www.mydomain.com/mysite/linens.xls into Excel's File Open or File Save
As dialog box.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*-----------------------------­-----------------------
|\----------------------------­-----------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||----------------------------­-----------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/----------------------------­-----------------------
*-----------------------------­-----------------------

 

[Jim Cheshire]

There's really no good solution for this.

One approach is to set up a link that points to a file sharing
location, such as
<a href="file:\\server\sharename\folder\linens.xls">Sheets</a>.
However, this is only practical on intranets.

Another approach is to set up a timed process that FTPs the file
every night or whatever. However, you have to make sure that the FTP
only replaces that one existing file. If you try to get fancy, you
can corrupt the FP server extensions.

Perhaps best is to simply store, open, and save the spreadsheet
directly on the Web server. Just type a URL such as
http://www.mydomain.com/mysite/linens.xls into Excel's File Open or
File Save As dialog box.

A better solution would be to use ASP or ASP.NET to stream the file to the
client. That would allow you to store it in a protected location that is
not directly browsable and give you control over who gets to it.

--
Jim Cheshire
JIMCO Software
http://www.jimcoaddins.com

The premiere add-in and software source
for Microsoft FrontPage.

 

[Jim Buyens]

Right, except that question was about uploading, not delivering.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jim Cheshire]

Right, except that question was about uploading, not delivering.

I think you're missing my point. The most common way of doing this is to
store the spreadsheet at a shared file location. When the file is
requested, you stream it to the client in a binary stream. The point is
that the location of the spreadsheet need not change.

In other words, don't assume that the spreadsheet needs to be uploaded to
the server in order to deliver it to a client fresh. That's not the way
it's typically done.

--
Jim Cheshire
JIMCO Software
http://www.jimcoaddins.com

The premiere add-in and software source
for Microsoft FrontPage.

 

[Jim Buyens]

Well, I already suggested:

One approach is to set up a link that points to a file sharing
location, such as
<a href="file:\\server\sharename\folder\linens.xls">Sheets</a>.
However, this is only practical on intranets.

But yes, I suppose a Web page could set the HTTP headers and then read the
sharename copy into the Response stream. But again, the poster didn't explain
his/her environment and requirement for download. He/she might be operating
an external Internet hosted site, in which case sharenames usually aren't
available and therefore your approach probably wouldn't work. But in other
environements your approach would be fine. We just don't know. That wasn't
the question. That's why I didn't go there.

Jim Buyens
Microsoft MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Windows SharePoint Services Inside Out
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Jim Cheshire]

Well, I already suggested:


But yes, I suppose a Web page could set the HTTP headers and then
read the sharename copy into the Response stream. But again, the
poster didn't explain his/her environment and requirement for
download. He/she might be operating an external Internet hosted site,
in which case sharenames usually aren't available and therefore your
approach probably wouldn't work. But in other environements your
approach would be fine. We just don't know. That wasn't the question.
That's why I didn't go there.

I realize you didn't go there. That's why I did.

--
Jim Cheshire
JIMCO Software
http://www.jimcoaddins.com

The premiere add-in and software source
for Microsoft FrontPage.