Qdabra Database Accelerator

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Fri, 28 Jan 2011 23:13:31 GMT

Hi Ted and Hilary,

Apologies for not posting back on this, but yes it seems to have done the trick. The XML include didn't work for me, but I've now placed a string field within the form which stores the document type name and all seems fine. Just need to get them to use the same columns within the form library now :0)

Thanks as ever for your excellent support.

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

Ted Fitch — Fri, 28 Jan 2011 23:02:15 GMT

Ged, did Hilary's post help you resolve this issue?

Thanks

Ted

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 20:02:38 GMT

Thanks Hilary,

I'll give it another try tomorrow morning and hopefully will be able to resolve the problem.

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

Hilary Stoupa — Mon, 24 Jan 2011 19:53:33 GMT

Hi --

It doesn't have to be a separate XML -- it can be a field in the form itself. The field (whether in the main or a secondary data source) needs to contain the name of the DBXL document type (from DAT). Your DBXL Submit connection needs to have that field specified for the doctype parameter.

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 19:15:43 GMT

Hi Jimmy,

I have an existing form library that users have been submitting forms to, but the design is too unwieldy. As a result, I've now split the form into four separate ones and hence now want to use these instead of the existing big form. The problem began with users being unable to submit forms and the error message received then is the same I'm still getting.

No longer at work so cannot attached a screenshot, but error is

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception Code: I0001
Exception Message: No DocumentType found for ''.

I followed the blog posting I found and created an XML file with the same name and the XSN and the document type, but still received the error. To be honest, the last time I tried this I didn't do that - does it have to be an XML file loaded as a resource or can I simply create a field within the form and store the name in there? Should it be name of the file including the extension or just the name of the content type attached to the form library?

Re: Something I've done has changed the sharepoint linking - don't understand why.

Jimmy — Mon, 24 Jan 2011 15:10:34 GMT

Hello Ged,

What is the specific error you are receiving? Are you opening the XSN from SharePoint, or from DBXL? If you're opening it from SharePoint, do you have your Submit connection set up to provide a value for the documentType parameter?

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 14:07:27 GMT

I've just created a new sub site to test this and if I use the DocumentService.asmx service then the form says that it's been successfully been submitted, but no documents appear in DAT. If I use DocumentServiceEx.asmx then it complains that it cannot find the document type. Don't know where to go with this now...

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 12:46:50 GMT

Hi Ernesto,

I haven't seen this document before, but I did try something similar in a blog post that I found on the web site. Does it need to be a fresh sub site or will it work with a site that has existing document types of the same name?

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

ErnestoM — Mon, 24 Jan 2011 12:13:02 GMT

Hi Ged,

I'm going to update our support ticket on this, but I wanted to make sure you've been directed to this document.

http://www.infopathdev.com/files/folders/sharepoint_integration/entry60330.aspx

It covers how to use the new Content Types feature in DBXL.

More soon. Thanks.

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 11:02:18 GMT

I only get this message if the template file is not saved as the template.xsn. Check the box in DAT to publish library and XSN and it all works fine. However, I have a form library with four content types and hence I can't always engineer this.

Any suggestions?

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 10:36:14 GMT

Quick update. The issue that was affecting a single set of forms and form library is now affecting all of the forms with the following error:

InfoPath cannot submit the form.
An error occurred while the form was being submitted.
The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Exception Code: I0001
Exception Message: No DocumentType found for ''.

   at Qdabra.Dbxl.WebService.DbxlDocumentServiceEx.CheckAndThrowException(StatusInfo info)
   at Qdabra.Dbxl.WebService.DbxlDocumentServiceEx.SubmitDocument(String docTypeName, String xml, String name, String author, String description, Int32& docId, String& refId)
   --- End of inner exception stack trace ---

The system seems to have lost the configuration settings for the documents, as I can now no longer access document information in DAT. I have therefore converted a set of test documents from the configuration that I cannot read to a new configuration and it's those that are producing the errors above.

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Mon, 24 Jan 2011 09:32:31 GMT

Hi Ted,

Didn't resolve the issue on the live system. When trying to add a document via SharePoint the system complains that it cannot find the document type. However, I can successfully create a new document using the DBXLAdmin interface, open it via SharePoint and submit a revised version.

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

Ted Fitch — Fri, 21 Jan 2011 16:19:05 GMT

Thanks Ged, please let us know if you run into any issues.

Ted

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Fri, 21 Jan 2011 16:11:44 GMT

Hi Ted,

I can now access the Content Types functionality, but need to test it on the live system on Monday. I have a separate live system on the University network which I might have a go at this weekend just as practice for the clinical one.

Ged

Re: Something I've done has changed the sharepoint linking - don't understand why.

GedCT — Thu, 20 Jan 2011 17:27:15 GMT

Hi Ted,

Will let you know once I've deployed the latest version onto my test system. Assuming that appears, then will put it into production. I'm hopeful this will solve it, as it definitely appears to be a content types issue - somehow the forms are mapping to the template.xsn file even where this doesn't exist. Sometimes it asks whether I'd like to redirect to what should be the correct content type and other times it doesn't open anything and complains it cannot access the resource.

Hope that this can be rectified, as there's at least one additional project that I'm looking to use DBXL on, as it usually works fantastically well.

Ged