Web Services

Re: Simple (?) Web Service

AndersR — Mon, 20 Feb 2006 00:16:43 GMT

Hi Tom

i did the exact thing a month ago or so, using Web services and EventHandlers (except i did it on the CheckIn event since i only wanted to copy the document when it was approved).

the problem is that you cannot access the API across servers (or even portals), so you need to either use existing web services (check the lists.asmx web service in your SPPT SDK) or create a custom sharepoint web service (this is what i did) that you implement on the target box. Theres a good article on this subject on MSDNhttp://msdn.microsoft.com/library/en-us/odc_SP2003_ta/html/ODC_WritingCustomWebServicesforSPPT.asp

hth

//AndersR

Re: Simple (?) Web Service

bigheadhanks — Tue, 14 Feb 2006 21:54:12 GMT

OK! I have made considerable progress on this issue today. I took Patrick's advice and created an Event Handler. The Event Handler simply takes any submitted document/form to a library and moves it to another library. I really like this solution as it doesn't require any new form code. However, I am having an issue with the Event Handler that I created. The Event Handler that I created seems to only work if the Document/Form libraries are on the same WSS site. It will not move the file from one WSS site to another, and more importantly it will not move a file from a Portal site's document library to a WSS site's document library. I put in an exception handler in the code and it is returning a: "Value does not fall within the expected range." error. I have attached the code for the assembly below.


Imports Microsoft.SharePoint

Public Class FormMove : Implements IListEventSink
    Public Sub OnEvent(ByVal listEvent As Microsoft.SharePoint.SPListEvent) Implements Microsoft.SharePoint.IListEventSink.OnEvent
        On Error Resume Next
        Dim SharePointWeb As SPWeb = listEvent.Site.OpenWeb()
        Dim SharePointEventItem As SPFile = SharePointWeb.GetFile(listEvent.UrlAfter)
        Dim oItem As SPListItem = SharePointEventItem.Item
        Dim sFileName As String = oItem.File.Name.ToString()

        If listEvent.Type = SPListEventType.Insert Then
            Err.Clear()
            Dim MoveToPath As String = "http://sharepointsite/doclib/" + sFileName
            SharePointEventItem.MoveTo(MoveToPath)

        End If

    End Sub 'OnEvent
End Class

Re: Simple (?) Web Service

bigheadhanks — Tue, 14 Feb 2006 15:25:19 GMT

Well I believe that I can achieve what I need to achieve by using an event handler as suggested above. If anyone out there has an example event handler that I might be able to look at, I would greatly appreciate it.

Thanks!

Tom

Re: Simple (?) Web Service

bigheadhanks — Tue, 14 Feb 2006 12:50:11 GMT

Thanks for the response Patrick. I will report back any solutions I find to my problem. Thanks again.

Re: Simple (?) Web Service

Patrick Halstead — Tue, 14 Feb 2006 06:25:28 GMT

Hi Tom,
You are right - this is an issue. The other way to handle it is to use an Event Handler to move the forms from the form library after they are submitted. Both a Web service and an Event Handler will require administrator permissions on the server. You will want to write a Web service that checks the user's credentials and grants permissions based on that. The Recruiting Accelerator that my team at Microsoft created 2+ years ago is a great resource because it has code for a Web service that does this on top of a SQL database. It also includes web parts for showing the data on the SharePoint site. Please search MSDN or Microsoft sites for that project and let us know if you find it.

Patrick Halstead [InfoPath MVP]
InfoPath Dev Seattle

Simple (?) Web Service

bigheadhanks — Mon, 13 Feb 2006 18:51:16 GMT

Greetings!

I have a few forms that I am creating which contain sensitive information. The problem is that with SharePoint permissions as I understand them, anyone who can submit a form to a library, can also read forms in that library. The only work-around that I can find to keep the form library secure is to have a webservice to submit the form to the library for the user. That way the form gets submitted and the library stays secure. My problem is one, I'm not sure if this is even possible. And two, if it is possible, I have no idea where to start. Can someone point me in the right direction?

Thanks,

Tom