Qdabra Database Accelerator

Re: What are ramifications of moving a DBXL form to a different library after it's been DB and SharePoint mapped?

Doreen — Thu, 20 Jun 2013 19:15:35 GMT

Wow, really? I guess I'll be your guinea pig. :I

Re: What are ramifications of moving a DBXL form to a different library after it's been DB and SharePoint mapped?

ErnestoM — Thu, 20 Jun 2013 12:56:00 GMT

DBXL doesn't have the ability to map forms to subfolders within libraries, sorry.

If the users will be moving the files manually to subfolders, I'm not sure how that's going to affect the SharePoint mapping. It would be a good test, but it's never come up before. Let us know what you find!

Re: What are ramifications of moving a DBXL form to a different library after it's been DB and SharePoint mapped?

Doreen — Wed, 19 Jun 2013 23:45:51 GMT

Okay thanks Ernesto that makes sense.

You are talking about mapping between libraries. What about moving an item (forms) from the root library to one or more folders in the same library? Does that make any difference wtih the SharePoint mapping?

Re: What are ramifications of moving a DBXL form to a different library after it's been DB and SharePoint mapped?

ErnestoM — Wed, 19 Jun 2013 19:02:20 GMT

Hi Doreen,

I don't think manually creating folders and then manually moving the XML files is a good idea. Users make mistakes, so it's best to control what they can and cannot do. As the form designer, you can control this with some simple changes. Basically, you would allow DBXL to control the SharePoint mapping, via a conditional mapping.

Your document type would have two SharePoint mappings, each with its own condition. For example

http://<myserver>/<myACTIVElibrary>

Condition: my:status = 'Active'

http://<myserver>/<myINACTIVElibrary>

Condition: my:status = 'Inactive'

Within the form, you would have a simple status field (Active vs. Inactive). Its value will then control whether the form is mapped to the Active library or the Inactive library.

The database mapping is not affected by any of this.

Hope this helps!

What are ramifications of moving a DBXL form to a different library after it's been DB and SharePoint mapped?

Doreen — Wed, 19 Jun 2013 17:00:38 GMT

I assume the database mapping will always follow the form but I also assume the SharePoint library mapping will break? Is this true?

I have a form template that will be submitted to one SharePoint (2007) library. User wants to create other document libraries to archive the form into when she's finished with the forms. Will this break the form?

I assume she can "safely" create folders in the existing library to move them into as an alternative?