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

InfoPath Dev

Qdabra® Training

Use our Google Custom Search for best site search results.

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

Last post 05-30-2017 02:26 PM by Hilary Stoupa. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 05-26-2017 12:03 PM

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

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

     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.

  • 05-26-2017 03:40 PM In reply to

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

    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?
    Hilary Stoupa

  • 05-30-2017 07:55 AM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

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

     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.  :)

  • 05-30-2017 02:19 PM In reply to

    • Doreen
    • Top 50 Contributor
      Female
    • Joined on 08-11-2010
    • Federal Way, WA
    • Posts 291

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

    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?

     

  • 05-30-2017 02:26 PM In reply to

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

     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.

    Hilary Stoupa

Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.