Re: Delete documents using SharePoint and "Propagate Delete"

ErnestoM — Thu, 21 Jul 2011 12:56:05 GMT

If the user opens DocID 10, the lock will hopefully prevent its deletion.

You would need a sort of catalog form, one that lists all documents available, and allows you to delete one without having to open it.

If you want help setting up a catalog form, let us know.

Re: Delete documents using SharePoint and "Propagate Delete"

Catharine — Tue, 12 Jul 2011 08:59:37 GMT

Hi Jim,

Thank you for the advice, I have never used the RemoveDocument method... I hadn't even realised it was there. I already have an admin view, and this would be simple.

I just have a question about locking...

Is it ok for the user to Open up say DocID 10 and then while DocID 10 is open click the button to delete DocID10 ? As the form is open wouldn't it be locked.?

Just trying to understand the process.

Catharine

Re: Delete documents using SharePoint and "Propagate Delete"

Jim Cantwell — Fri, 08 Jul 2011 16:27:03 GMT

If the sole purpose of SharePoint mapping is allow delete from DBXL, it would be simpler to have an Admin view in the form that has a delete button. DBXL permissions can prevent users from deleting, or you can use an alternative mechanism to hide the delete button. The Delete button would just need a data connection to the RemoveDocument method.

Delete documents using SharePoint and "Propagate Delete"

Catharine — Fri, 08 Jul 2011 15:20:05 GMT

I am using Infopath 2007 and DBXL 2.3.

I have a document type in DBXL. The users access the documents via SharePoint DataViews, I have created some screens using SharePoint designer, and they utilize DataViews into the SQL database. The DataViews have hyperlinks to the documents - i.e the dbxl link This is working well.

The key user would like to be able to delete documents without having to contact me.

In order to give this functionality - without access to DBXL, I have created a form library in SharePoint, where I map the DBXL documents and I have ticked Propogate delete. Only the key user has a menu option to get to this library, although other users appear to need contribute rights for the mapping to work.

This seems to work well most of the time . But I have started to get some errors - see below. The Form library for deleting is called DeleteNPAPRequests and I seem to get these errors when I am editing the document using the hyperlink from the DataViews not when I am trying to delete the document from the DeleteNPAPRequests library.

Is what I am trying to do a suitable solution ? I really do not want to give access to the DBXL Catalog - I think it would cause confusion.

Are these errors caused because I am keeping the document open too long ? I have noticed I have autosave on, would that be affecting it?

Thank you

Catharine

Message: Caught exception checking out SPListItem. http://....../DeleteNPAPRequests (DocType = 'Request', DocId = 2781)

Microsoft.SharePoint.SPException: The file "DeleteNPAPRequests/2781.xml" is checked out or locked for editing by ...... ---> System.Runtime.InteropServices.COMException (0x8107090E): The file "DeleteNPAPRequests/2781.xml" is checked out or locked for editing by .....
   at Microsoft.SharePoint.Library.SPRequestInternalClass.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   at Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   --- End of inner exception stack trace ---
   at Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   at Microsoft.SharePoint.SPFile.CheckOut(Boolean bCheckoutToLocal, String lastModifiedDate)
   at Microsoft.SharePoint.SPFile.CheckOut()
   at Qdabra.Dbxl.Domain.SharePointObjectModel.Save(SharePointListItemMapping mapping, SharePointDocumentData doc)

The stack trace was:    at Microsoft.SharePoint.Library.SPRequest.CheckOutFile(String bstrUrl, String bstrWebRelativeUrl, Boolean bCheckoutToLocal, String bstrLastModified)
   at Microsoft.SharePoint.SPFile.CheckOut(Boolean bCheckoutToLocal, String lastModifiedDate)
   at Microsoft.SharePoint.SPFile.CheckOut()
   at Qdabra.Dbxl.Domain.SharePointObjectModel.Save(SharePointListItemMapping mapping, SharePointDocumentData doc).

Qdabra Database Accelerator

Re: Delete documents using SharePoint and "Propagate Delete"

Re: Delete documents using SharePoint and "Propagate Delete"

Re: Delete documents using SharePoint and "Propagate Delete"

Delete documents using SharePoint and "Propagate Delete"