Date:         Mon, 30 Jun 2008 17:05:35 -0400
Reply-To:     Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject:      Re: Sharepoint question
Comments: To: "Duell, Bob" <BD9439@ATT.COM>
In-Reply-To:  <331C5406E0EC64408B07D6B74516BE17045C4D97@BD01MSXMB018.US.Cingular.Net>
Content-Type: text/plain; charset="us-ascii"

Bob:
Why does the SharePoint app have different pages per site instead of
different folders (if that's actually the case)? Sounds as if developers
of the nifty "VBS scripts" and SharePoint developers are working in
parallel worlds.
S

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Duell, Bob
Sent: Monday, June 30, 2008 2:10 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Sharepoint question


Hi all,

To begin with, I'm sorry for posting a non-SAS question, but I really
don't know where else to turn.

I'm trying to automate a reporting application (which primarily uses
SAS), the end result of which is a ZIP file sitting on a file server on
our network.  The PC application is "nifty" and complicated, remote
submitting SAS Access to Oracle queries on a UNIX server, exporting
results to an Access database on my PC, generating and executing VBS
scripts to update multi-sheet Excel pivot tables and zipping the result
to the file server, all scheduled using Windows Scheduled Tasks.

The last thing I must do is go to a SharePoint site for each ZIP file
and update the reference to point to the new file.  All I do is type
over the name in a box labeled "URL" with the new file name and click
the "Save and Close" button on the form.

I can see the full URL of the SharePoint page (running something with an
"aspx" extension) and I can see the HTML source (containing Javascript).
I have very limited experience with either. (Okay, I have no experience
at all!)

This is tedious and silly; there must be some way to automate it.  Any
ideas?

Thanks!

Bob