Qdabra Database Accelerator

Re: Get a value from a field in an InfoPath form that is not stored in database by DBXL

Hilary Stoupa — Tue, 30 May 2017 21:26:33 GMT

For item 1 - to submit data to the database, you need to add the field in the mapping on the Database tab in the DBXL Admin tool. As to item 2 & 3 - you may need to submit a support ticket for those, but let me have Jim take a look at this post & see if he has some suggestions.

Re: Get a value from a field in an InfoPath form that is not stored in database by DBXL

Doreen — Tue, 30 May 2017 21:19:23 GMT

As it turns out I do have questions. I can submit a support ticket - I have 2 hours available from my recent renewal for dbxl and qRules. I did experience some issues when I injected qRules from 7.2 to 8.1.

My questions are about dbxl admin tool.

1. Do I need to add the promoted field/column on the Database tab or to the SharePoint tab or both to get the value to insert into the new column in the SQL database table?

2. I also ended up with duplicate columns in SharePoint when I published the form after doing the qRules injection. How do I remove them without breaking my form?

3. I believe I don't use or need to use the Taxonomy Tree tab but when I click on it I get an Unhandled exception error... while calling the qTags_AllHierarchies method".... "Server was unable to process request-->Qdabra.QueryDB.QueryDbException:Error D0101">..

I haven't upgraded DBXL Version from 2.7.2013.211 to 3.2 yet...not sure it'll work with InfoPath and SharePoint 2007?

Re: Get a value from a field in an InfoPath form that is not stored in database by DBXL

Doreen — Tue, 30 May 2017 14:55:28 GMT

Thank you, Okay I think I understand what you mean. I will give it a try. I don't use DBXL often enough so I am still a little tentative with it. :)

Re: Get a value from a field in an InfoPath form that is not stored in database by DBXL

Hilary Stoupa — Fri, 26 May 2017 22:40:26 GMT

Hi - you should be able to just add the column to the DB, add the mapping to the document type mapping in DAT and then reshred your documents. :) Let me know if you need more detail?

Get a value from a field in an InfoPath form that is not stored in database by DBXL

Doreen — Fri, 26 May 2017 19:03:52 GMT

I have an InfoPath 2007 form in SharePoint 2007 that uses DBXL and qRules. There is a value in one of the fields that is not stored in the database when it's submitted so the value must be stored in the xml of the form itself.

My goal is to retreive this value for all existing forms and store it in a new column of the database. How can I retrieve this value without having to open every form to look it up and then manually insert it into the database? Is there simple way to do this by modifying the qRules and/or DBXL?

The reason? We are migrating this particular InfoPath form to an asp.net web app and would like to be able to open the existing infopath form data in the new web app. This one value is the only missing piece.