Qdabra Tools

Assist with ADA Compliance

sbhunter — Mon, 22 Dec 2025 13:28:33 GMT

Are there any tools (native or add-on) to assist with making forms ADA compliant?

InfoPath XML to SharePoint list tool, does it still exist?

poppyq — Wed, 02 Jun 2021 18:55:29 GMT

I am trying to find the InfoPath XML to SharePoint list tool, but there doesn't seem to be a link anywhere. Is this tool still supported? It's still mentioned on Qdabra's tools page, but there are no links for it. I did find two different versions of the HowTo guide, but it doesn't mention anything about where to actually get the "Mapping Tool", as it's called in one of the guides. Thanks!

Error when querying sharepoint for displayname of editor column

Marzipan — Tue, 25 May 2010 15:22:29 GMT

I have successfully used the AD web service to populate my:Tasks/my:UserInfo/my:DisplayName and display it on a form in a text field

I have a button that then run the data connection "GetListItemsStr" to query a SP list.

I used the query builder to create the xml

When I use this query string it return all items:

When I use a this query generated by querybuilder to filter to the value of the editor field below, I get the error below:

concat("<query><columns><column name='ID'/><column name='Title'/><column name='Status'/><column name='DueDate'/><column name='CalendarItem'/><column name='Modified_x0020_Comment'/><column name='Status'/><column name='AssignedTo'/></columns><filter><eq><column name='Editor'/><value>", xdXDocument:get-DOM()/my:Tasks/my:UserInfo/my:DisplayName ,"</value></eq></filter><sort><column name='DueDate' order='ASC'/></sort></query>")

The query cannot be run for the following DataObject: GetListItemsStr
InfoPath cannot run the specified query.
The SOAP response indicates that an error occurred on the server:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Xml.XmlException: Data at the root level is invalid. Line 1, position 1.
   at System.Xml.XmlTextReaderImpl.Throw(Exception e)
   at System.Xml.XmlTextReaderImpl.ParseRootLevelWhitespace()
   at System.Xml.XmlTextReaderImpl.ParseDocumentContent()
   at System.Xml.XmlLoader.Load(XmlDocument doc, XmlReader reader, Boolean preserveWhitespace)
   at System.Xml.XmlDocument.Load(XmlReader reader)
   at System.Xml.XmlDocument.LoadXml(String xml)
   at Qdabra.Dbxl.WebService.QuerySharePointService.XmlFromString(String str)
   at Qdabra.Dbxl.WebService.QuerySharePointService.GetListItemsStr(String listUrl, String query, String queryOptions)
   --- End of inner exception stack trace ---

Any help would be apprecitated

Unable to use the InfoPath to SharePoint List tool

Catharine — Mon, 28 Sep 2015 15:04:18 GMT

I am trying to open the InfoPath to SharePoint List tool I have used this many times in the past - but I am now getting

InfoPath cannot open a new form. The form cannot be opened. To fix this problem, contact the form designer... with the detail

Form template: urn:schemas-microsoft-com:office:infopath:Qdabra-InfoPath-to-SharePoint-List-Tool:-myXSD-2007-11-27T15-29-00
Access is denied.

I have tried to re-install the form and get an error An unexpected error occurred:Retrieving the COM class factory for component with CLSID...... failed due to the following error - 80080005 Server execution failed)

I have tried opening the form from the QRules Library - when I try and open I get the same error as above and when I try in design it says it is already in use.

I am using InfoPath 2013 - any ideas ?

Catharine

Query a Repeating Table with Report Builder

mfrey — Wed, 19 Jun 2013 20:11:53 GMT

Is it possible to query repeating table data from a form stored in DBXL using the Qdabra Report Builder? I read through the blog post and am able to get all the non-repeating data.

Thanks!

Mike

Issues with Infopath to sharepoint Lists

ianlh — Tue, 26 Aug 2014 10:59:52 GMT

Hi,

I have created a infopath 2013 form to submit to an online 365 sharepoint site. This form has a non repeating part that the user fills in (meeting title, attendees etc.), then a repeating section that tasks are filled into. The form submits perfectly to the required library on sharepoint and can be opened and the contents edited and resubmited as the next version.

Repeating Section

I followed the excellent tutorial by Hillary to create a list from this form, which I would then use to populate a task list.

This works, but I am having a major problem:

If the form is opened from the library and an action modified (due date changed etc.) or action added, then on the resubmit all the actions are repeated with a new ID. Is there any way to prevent this and only allow the updated action to be modified? On the library that the form is resubmitted to the form shows the correct revision increase and only the actions changed or added are effected.

QDABRA FILE DROP

Joedy — Wed, 09 Jul 2014 03:06:57 GMT

Hi I currently purchased the QDabra File Drop active X control but having issues installing it

I ran the batch file and it was all good but I cannot find the location for the ICT file as it does not exist

I run windows 8 Pro and InfoPath 2013, has anyone else had this issue?

Creating a link to link back to the item in the form library

agardner — Wed, 25 Jun 2014 18:38:53 GMT

I am using the submit to SharePoint list function to submit my InfoPath forms to a list. Is there a way to create a link in the list that will link back to the item in the InfoPath form library? I would like to pull up the item in the list and click on a link that will pull up the actual associated form that is in the form library.

Excel to InfoPath tool

FredC — Tue, 01 Apr 2014 16:11:03 GMT

The target Infopath form on Sharepoint is comprised of 6 text boxes for data entry, 2 text boxes with person picker control, 1 repeating table with 2 columns, and 3 repeating tables each with 3 columns. Is this a combination that the tool is built to handle? What would the xls need to look like?

I'm off to download the trial version to see what I can see.

qRules Mapping - Infopath to SharePoint list only one row of repeating table is submitted

d24n4e — Thu, 27 Mar 2014 09:50:57 GMT

Hi I followed Hilary's excellent walkthrough to create my own submit to SP overtime authorisation form (changing fields to my own requirements etc). I only have one SPlist that I need all the data to be sent to, but when I have multiple lines in my repeating table, only the first one is submitted to my list. What might I be doing wrong please?

In my form I basically have header information (project details) then overtime request information (e.g date) then below it a repeating table so the project manager can request overtime pre-approval for multiple resources with different start/end times.

Thanks

Mapping SharePoint List ID to field in InfoPath form

blalor — Wed, 29 Jan 2014 17:07:47 GMT

This seems like a basic question but I just can't seem to find the answer.

Using Qrules 5.2, InfoPath and SharePoint 2010. I've successfully used the InfoPath to SharePoint List Tool to submit the form data to the SP list. But I also need the ability, when the form is reopened, to edit one field in the SP list. I've followed Hillary's blog post for using the RefreshSharePointListItems command but in her post it says:

If you look at your mapping.xml file in a text editor, you'll see the IsId attribute is set to "true":

When I look at my mapping.xml file, this mapping is not there and using the InfoPath To SharePoint List Tool did not display the SharePoint ID field as an option for mapping my form field to it.

How do I map my field "ShpID" to the SharePoint ID field so that edits can be made? Do I just manually add this mapping to the mapping.xml file and if so, do I then need to run the tool to publish the new mapping file to the SP list?

Thanks for the help!

--Bill

Using the install tool to install the "Qdabra InfoPath to SharePoint List Tool" form

aarenz — Tue, 17 Sep 2013 20:55:28 GMT

When dragging the "Qdabra InfoPath to SharePoint List Tool" to the forminstaller, I get an error that says: An unexpected error occurred: Retrieving the COM class factory for component with CLSID xxxx see image for details. I am running Windows 7 64bit. Must be missing something.

Using Report Builder after you've installed InfoPath 2010 and 2013

JohnLiu — Tue, 23 Jul 2013 04:33:24 GMT

When 2013 is installed, it creates assembly binding information that prevents Report Builder from working.

To fix this, open as administrator. You'll need a decent editor (Visual Studio). Notepad won't let you see inside \Windows\assembly\

C:\Windows\assembly\GAC_MSIL\Policy.12.0.Microsoft.Office.InfoPath\15.0.0.0__71e9bce111e9429c\Policy.12.0.Microsoft.Office.InfoPath.config.

Change the binding number to version 14.

This will allow you to open Report Builder in 2010.

file:///C:\ReportBuilderTool\ReportBuilder.xsn
InfoPath cannot open the selected form because of an error in the form's code.
System.Reflection.TargetInvocationException, mscorlib

System.Reflection.TargetInvocationException: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.InfoPath, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.InfoPath, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.Office.InfoPath, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.Office.InfoPath, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c'

Assembly manager loaded from: C:\Windows\Microsoft.NET\Framework\v2.0.50727\mscorwks.dll
Running under executable C:\PROGRA~2\MICROS~3\Office14\INFOPATH.EXE
--- A detailed error log follows.

=== Pre-bind state information ===
LOG: User = SHAREPOINTGURUS\Jumpei.Yamauchi
LOG: DisplayName = Microsoft.Office.InfoPath, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
(Fully-specified)
LOG: Appbase = file:///C:/Users/jumpei.yamauchi/AppData/Local/Microsoft/InfoPath/FormCache3/D0DA85C8.BC2/$ea1365874cd270ef
LOG: Initial PrivatePath = NULL
Calling assembly : InfoPath Form Template, Version=1.0.4153.12851, Culture=neutral, PublicKeyToken=2f07faa609590625.
===
LOG: This bind starts in default load context.
LOG: No application configuration file found.
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v2.0.50727\config\machine.config.
LOG: Publisher policy file is found at C:\Windows\assembly\GAC_MSIL\Policy.12.0.Microsoft.Office.InfoPath\15.0.0.0__71e9bce111e9429c\Policy.12.0.Microsoft.Office.InfoPath.config.
LOG: Publisher policy file redirect is found: 12.0.0.0 redirected to 15.0.0.0.
LOG: ProcessorArchitecture is locked to MSIL.
LOG: Post-policy reference: Microsoft.Office.InfoPath, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c, processorArchitecture=MSIL
LOG: Attempting download of new URL file:///C:/Users/jumpei.yamauchi/AppData/Local/Microsoft/InfoPath/FormCache3/D0DA85C8.BC2/$ea1365874cd270ef/Microsoft.Office.InfoPath.DLL.
LOG: Attempting download of new URL file:///C:/Users/jumpei.yamauchi/AppData/Local/Microsoft/InfoPath/FormCache3/D0DA85C8.BC2/$ea1365874cd270ef/Microsoft.Office.InfoPath/Microsoft.Office.InfoPath.DLL.
LOG: Attempting download of new URL file:///C:/Users/jumpei.yamauchi/AppData/Local/Microsoft/InfoPath/FormCache3/D0DA85C8.BC2/$ea1365874cd270ef/Microsoft.Office.InfoPath.EXE.
LOG: Attempting download of new URL file:///C:/Users/jumpei.yamauchi/AppData/Local/Microsoft/InfoPath/FormCache3/D0DA85C8.BC2/$ea1365874cd270ef/Microsoft.Office.InfoPath/Microsoft.Office.InfoPath.EXE.

   at System.Reflection.Assembly._GetType(String name, Boolean throwOnError, Boolean ignoreCase)
   at System.Reflection.Assembly.GetType(String name, Boolean throwOnError)
   at System.AddIn.AddInExecutorInternal.System.AddIn.IAddInExecutorInternal.Execute(String assemblyName, String className, IRemoteArgumentArrayContract initArgs)
   at System.AddIn.AddInExecutor`1.Execute(String assemblyName, String className, IRemoteArgumentArrayContract args)
   at Microsoft.VisualStudio.Tools.Applications.EntryPointAdapter..ctor(IRemoteArgumentArrayContract initArgs)

   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeConstructor(Object[] args, SignatureStruct& signature, IntPtr declaringType)
   at System.RuntimeMethodHandle.InvokeConstructor(Object[] args, SignatureStruct signature, RuntimeTypeHandle declaringType)
   at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.Reflection.ConstructorInfo.Invoke(Object[] parameters)
   at System.AddIn.AddInExecutorInternal.System.AddIn.IAddInExecutorInternal.Execute(String assemblyName, String className, IRemoteArgumentArrayContract initArgs)
   at System.AddIn.AddInExecutorInternal.System.AddIn.IAddInExecutorInternal.Execute(String assemblyName, String className, IRemoteArgumentArrayContract initArgs)
   at System.AddIn.IAddInExecutorInternal.Execute(String assemblyString, String className, IRemoteArgumentArrayContract args)
   at System.AddIn.AddInExecutor`1.Execute(String assemblyName, String className, IRemoteArgumentArrayContract args)
   at Microsoft.VisualStudio.Tools.Applications.Internal.ExceptionFilter.ExceptionFilterHelper.ExecuteCustomization(AddInExecutor`1 executor, String assemblyName, String className, IRemoteArgumentArrayListContract args, IExceptionFilterCallback callback)
   at Microsoft.VisualStudio.Tools.Applications.AddInImpl.AttemptInternalLoad(IAppDomainBindingContract appDomainBinding, String appBase, String configFile, PermissionSet topOfStackPermission, StrongName[] strongNameAssemblies)

Issue with InfoPath to SharePoint List tool

TomRenfro — Fri, 21 Jun 2013 14:24:34 GMT

I'm working through a previous tutorial on setting up dashboards, and have gotten to the step using this tool. My problem is the tutorial references an Extract Schemas button in the Define Mapping tab. I've installed multiple versions of this tool, and don't see the button at all. How can I pull in the schema for a form if I don't have access to this button?

As an aside, I also opened the tool in design mode, and I don't see the button there either. Thanks.

Where is document on how to use Query Builder?

Doreen — Mon, 08 Apr 2013 20:09:18 GMT

I am following tutorial "Copy SQL values to infopath repeating section fields usign QueryDB" - on page 7 a reference line is made to "document" about how to use Query Builder...the link is broken.

Problems with Infopath Sharepoint to List Tool

tyty4u2 — Fri, 05 Apr 2013 03:00:19 GMT

I have a government laptop that is locked down tight. I am having issues with Qrules Infopath Sharepoint to List Tool Form. When I open the form, the schema at the right only shows HTML code. I attached a screen shot. I have reinstalled Qrules and verified the form is set for full trust. Any help would be great!!!

qRules SharePoint Mapping Tool

nowb23 — Tue, 26 Feb 2013 22:06:18 GMT

I just purchased a copy of qRules 4.3. How do I download a copy of the SharePoint Mapping Tool? Thanks

Excel to Infopath issue

jerryO — Thu, 25 Oct 2012 18:53:39 GMT

I recently purchased the Excel to XML tool and have used it successfully. I have been working on a new application that has a repeating table in the template. I have created the excel sheet with 2 worksheets(Sheet1 and Savings), Sheet1 has the main data and Savings has the repeating table data. I am creating the forms locally and the forms are being generated correctly except for the forms that have more than 1 child document. (Sheet1 has a unique document ID column as the key to the Savings worksheet. The Savings worksheet can have mutiple matching children)

When I run the executable to create the xml files locally, the rows that match 1 to one from the Parent to Child get created and can be opened succefully. The rows that match more than 1 child document are created but the forms cannot be opened. The error when opening the forms is:

The form contains schema validation errors: Details:

Element '{http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-06-28T14:32:08}Savings' is unexpected according to content model of parent element '{http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-06-28T14:32:08}myFields'.
Expecting: {http://schemas.microsoft.com/office/infopath/2003/myXSD/2012-06-28T14:32:08}ProjLanguage, {http://schemas.microsoft.com/off....

I have a Proj Language field in the template but it is not part of the mappings file. The Proj Language field is a drop down that chooses the language for the form, it gets choices from an external data source which is anothe xml file on the site. (This is using the language localization from Matt Faus)

I attached the mapping and template

XLS to XML tool - Can't open mapping.xml without template

Deeayrian — Tue, 23 Oct 2012 15:39:53 GMT

When I first purchased the XLS to XML tool a few months ago, I did some testing with it on a Sharepoint library to see how it would work. Now, we are ready to go live with using it so I wanted to open up the previously created mapping.xml file to review how I had it set up but everytime I try to open it, it asks me what template I want to use to open it and gives me a browse button to find a template.

What template is it looking for and why is it asking me for this? I don't remember it asking this before and when I open up the sample mapping file it doesn't ask me for this. I tried to browse it to the originally created templates but it gives me an error.

Excel to InfoPath Tool, Unable to open form from DAAT in order to create template

DC Forms — Mon, 22 Oct 2012 17:17:29 GMT

I am working from the Qdabra's Excel to InfoPath Tool User Guide last updated on 4/26/2012 11:01 AM. On page 9, Scenario B: Output Directly to DBXL, Step 4 states "Open the original form from DAT, and click File > Save to generate a new, blank form. Save it in the “source” folder with the name template.xml, and close InfoPath."

When I attempt to open my form from DAAT I get the error "InfoPath cannot open a new form. The form template is trying to access files and settings on your computer. InfoPath cannot grant access to these files and settings because the form template is not fully trusted. For a form to run with full trust, it must be installed or digitally signed with a certificate."

This is an administrator approved web form published to SharePoint.

How else can I go about generating the template.xml document?

XLS to XML Tool - Problem mapping Network Drive

dsnightthunder — Fri, 29 Jun 2012 21:39:36 GMT

I am using the XLS to XML tool to map to a Form Library on a Office 365 Sharepoint Team Site.

My computer is running a pretty old laptop with Windows XP Media Edition. When I go to map the network drive, it says there is no network???

Also, Office 365 does not allow me to save the opened blank form to the C:\ drive Qdabra folder...

What should I do???

DBXL Migration Tool - Import

emcandrew2 — Wed, 11 Apr 2012 20:57:48 GMT

How do I get the DBXL Migration Tool to import my documents by the correct filename? In my scenario my xml filenames are social security number format (xx-xxx-xxxx.xml), but every time I import them using the migration tool, they assume the docID as the filename within DBXL and in my SharePoint library. I've looked at all of the mapping files but can't find where to set the import filename convention.

XLS to XML save as "template"

cnorris135 — Mon, 12 Mar 2012 18:00:54 GMT

Was wondering.... as i am trying to save my "template" file, I can not do a save as through the form because I have turned that feature off. Do I need to have this on in order to save the file as a template.xml or did you mean the internet File save as?

Chris

XLS to XML question

cnorris135 — Fri, 02 Mar 2012 17:33:07 GMT

setting up my spreadsheet in preparation of running the tool, and have a few questions

Can a field (column) in the spreadsheet can be matched with a field in a repeating table? Is it as simple as just picking the repeating table field like you would with a regular field in a form?
if your spreadsheet cell contains more than one value seperated by a semicolon, and you want to possibly populate the repeating table with each value going into a seperate row, is this possible or does the cell value only populate the first row of the repeating table with all values of the cell?

thank you

Excel to XML question

cnorris135 — Thu, 23 Feb 2012 14:39:06 GMT

getting ready to migrate a large amount of data to XML (infopath) in a sharepoint form library using the XLS to XML tool. For the File Name Info, the excel column that i will be using has duplicate entries. I am not sure but how does the XLS to XML handle this? Will I run into errors? I asked because the data i am migrating over is relevant the way it is named.

Thank you