Date:         Tue, 1 Jul 2008 16:43:28 -0400
Reply-To:     Don Henderson <donaldjhenderson@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     RFC822 error: <W> MESSAGE-ID field duplicated. Last occurrence
              was retained.
From:         Don Henderson <donaldjhenderson@HOTMAIL.COM>
Subject:      Re: Sharepoint question
Comments: To: "Duell, Bob" <BD9439@ATT.COM>
In-Reply-To:  <331C5406E0EC64408B07D6B74516BE17045C4DA4@BD01MSXMB018.US.Cingular.Net>
Content-Type: text/plain; charset="us-ascii"

It has been a long time since I looked at SharePoint, but I have used other
portals that notify folks about changes to pages or files. One trick I have
gotten to work a few times involved identifying the URL that is used by the
form that uploads a file. Assuming that GET is allowed (i.e, the URL
contains the name value pairs), you might be able to use the URL (or SOCKET)
access method in SAS to "invoke" the URL so that the file is updated.

If the form must use POST, you could create an html file with all the right
values (and a FORM that is automatically submitted when the form is loaded)
and then use the WBROWSE command to load it.

Both of these presume that you have a way of using the URL or the FORM to
log in to the server.

Not sure if/how this might work. But figured I would mention it as a
possibility.

HTH,
donh

> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Duell, Bob
> Sent: Tuesday, July 01, 2008 4:03 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Sharepoint question
>
> Yes, it seems like a good approach, but in this case, it
> defeats the purpose of SharePoint.  When I update the link to
> the new file, SharePoint sends an email message to anyone
> that has requested notification.  So even if I used the same
> file name, I need to somehow notify SharePoint that the data
> has changed.
>
> I'm sure there must be a way to do this programmatically;
> I'll figure it out eventually.  When I do, I'll follow-up
> with you all.
>
> Thanks,
>
> Bob
>
> -----Original Message-----
> From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On
> Behalf Of Steven Raimi
> Sent: Tuesday, July 01, 2008 5:56 AM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Re: Sharepoint question
>
> >How about just reusing the same name so that it always points to the
> latest
> >report?
> >
>
> Bob,
>
>    I think you should consider this, depending on your business needs.
> Every time you create the new file, you could save one to the
> "official"
> name and one with the date (so you have history).  If your
> Sharepoint users need the date, perhaps you could bake it
> into the spreadsheet(s).
> Keep it simple...
>
> Steve Raimi
>