Other Subjects

How to Generate a DBXL Key

Kervi Alfafara — Fri, 01 Feb 2019 07:47:20 GMT

This document details how you can generate a DBXL key so you can use Qdabra DBXL WithUserKey Services.

To obtain the document, click DOWNLOAD above. A free trial of DBXL is available on Qdabra.com.

How to Use Report Builder to Build Queries and Retrieve Data from DBXL

Kaoru Okumura — Wed, 15 Jun 2016 01:26:50 GMT

Product: DBXL v2.5 or higher. Note: screenshot corresponds to DBXL Admin Tool in v3.0 or before. v3.1 and above admin tool will appear differently

QuerDBWithUserKey Service

PrachiSingh07 — Mon, 22 Jun 2015 18:19:30 GMT

Office 365 (O365) browser forms don’t support forwarding authentication credentials to external Web sites.

To use your O365 forms with Qdabra’s DBXL service installed on a separate site (e.g. Azure), QueryDBWithUserKey is the solution.

This document contains the detailed steps to use the QueryDBWithUserKey service. It will guide you through two approaches to use this service:

1.) Manually

2.) Dynamically

Indexing in DBXL v2.8

ErnestoM — Tue, 01 Jul 2014 14:40:12 GMT

There are various ways in which indexes can be added to speed up the performance of DBXL v2.8. This document explains various scenarios and which indexes are useful in each.

Last updated 7/1/2014.

DBXL Reshred via Poweshell script

ErnestoM — Fri, 27 Jun 2014 20:54:53 GMT

DBXL forms can be reshred via the DBXL Admin Tool or via the DBXL Migration Tool. A third alternative for reshredding is a SharePoint Powershell script. The main benefit of the Powershell script is that it allows reshredding a range of DocIDs, instead of reshredding one document or ALL documents.

The Powershell script can be run from any desktop or server with Powershell installed.

Powershell script: AddDbxlLicense

ErnestoM — Tue, 12 Nov 2013 14:06:04 GMT

If you have a SharePoint 2013 farm running Windows Server 2012 OS with the minimal server GUI installed, you won’t have access to Internet Explorer or Windows Explorer. In situations like this, you can install a license using the PowerShell. Using this script, execute:.\AddDbxlLicense.ps1 http://yoursite/qdabrawebservice <EMAIL_ADDRESS> C:\<path>\<license-file>.lic

Import forms into DBXL using a PowerShell script

ErnestoM — Mon, 11 Nov 2013 19:03:43 GMT

Although you can use the Migration Tool (a/k/a Document Deployer) to import forms into your DBXL Document Type, this process does not retain the filename.

To work around this issue, Qdabra Software provides this PowerShell script. The steps in this document explain how to use this script.

This script was last updated on 11/11/2013.

Qdabra Dbxl Document History

ErnestoM — Wed, 19 Jun 2013 21:21:31 GMT

This package includes two template parts (XTPs): one for InfoPath 2007 and one for InfoPath 2010. Use this XTP in your DBXL forms if you would like to display a version history.

Note that the steps in the XTP assume that your XSN is a DBXL-based solution that already submits to DBXL. You may use the QdExpenseReport-Sample that comes with your DBXL installation.

Click DOWNLOAD above to obtain the XTPs, which contain step by step deployment instructions.

Create an InfoPath Dashboard form using QueryDocumentNodeSet

ErnestoM — Tue, 19 Mar 2013 15:23:58 GMT

In the past we have shown how to create a SharePoint data view to show the data stored in DBXL. Here are some references:

These steps involve using SharePoint Designer 2007 or 2010. In SharePoint Designer 2013, the WYSIWYG editor is no longer available, which makes the process of creating a data view more difficult.

Using the QueryDocumentNodeSet web method, contained in the DBXL web service, we can create a codeless, browser compatible InfoPath form which acts as a data view or a Dashboard.

The package includes:

Step by step instructions
InfoPathDashboard-QdExpenseReport.XSN which is the Dashboard for the Expense Report doctype that comes with DBXL.
InfoPathDashboard-CustomerContact.XSN is the Dashboard after following the steps to reconfigure it to query from the CustomerContactForm.XSN (that form template is also attached).

Create an XTP to Lock and Unlock DBXL forms

ErnestoM — Fri, 18 Jan 2013 19:08:43 GMT

This tutorial allows you to create an InfoPath template part (XTP) that will lock and unlock forms that are stored in DBXL. You can reuse this XTP in any form template where you wish to provide this functionality to your users.

Click download above to obtain the PDF.

Qdabra.Dbxl.Client DLL

Jimmy — Mon, 17 Sep 2012 19:04:57 GMT

This is a .NET library for use in interacting with DBXL from .NET code. See the following blog post for more details:

http://www.infopathdev.com/blogs/jimmy/archive/2012/09/18/interacting-with-dbxl-from-code-qdabra-dbxl-client.aspx

The current version is 2.6.0.0.

How to install Query Builder

ErnestoM — Tue, 14 Aug 2012 14:16:35 GMT

Click DOWNLOAD above to obtain the latest Query Builder tool with instructions on how to install the form.

Query Builder can be installed using the Form Installer utility.

Last updated: 2014-12-10

How to prevent a user from submitting duplicate data to DBXL

ErnestoM — Tue, 06 Mar 2012 14:14:05 GMT

Imagine that your InfoPath form, which submits to DBXL, needs to make sure that there are no duplicate records. Using the web method QueryDocumentNodeSet, we can quickly check whether DBXL already contains a matching record.

For the purposes of this tutorial, we will implement the solution on a very simple form, though you can extend this as desired. Click DOWNLOAD above to obtain the PDF document.

How to turn off DBXL versioning

ErnestoM — Fri, 03 Feb 2012 20:06:40 GMT

DBXL versioning is turned on by default, as it is necessary for certain scenarios. For safety purposes the checkbox in DAT is also disabled, so that it is not accidentally deactivated. However, should you wish to turn off versioning (i.e. uncheck Enable History), follow these steps. Click DOWNLOAD above to obtain the PDF guide.

Using DBXL URN-based Solutions and Email Forms to Communicate with External Users

ErnestoM — Tue, 17 Jan 2012 20:32:45 GMT

Scenario

There are times when we want someone not logged into the domain to be able to edit a form which needs to be submitted to DBXL. Let's say that "User A" is a person who works inside the domain and therefore has access to submit to DBXL and "User B" is a person who is working outside of the domain.

Value Proposition

Using DBXL's "URN-based solution" feature gives us the power to use InfoPath forms to capture offline e-mailed data for centralized DBXL upload. We can email forms back-and-forth, to and from external users (sometimes offline/disconnected or simply not a member of the domain), and at the same time, manage those forms in private locations such as a domain. We need to make sure that the form data in both the public and the private locations are in-sync.

Here's an outline of the solution we're trying to accomplish:

1. User A emails the form template (XSN) file to an external user, User B (External version).

2. User B opens the form template, fills it out and emails back to User A.

3. User A receives the form (XML) and opens it with the higher version of the form template (Internal version).

4. User A submits the form to DBXL.

5. User A opens the form from DBXL, edits it and emails it back to User B.

Note that User A may receive a warning message that the original form template cannot be found and suggests another form template to open the form instead. Clicking Yes will open the form with the correct version of the form template.

6. User B receives the form, accepts the changes, re-edits and re-emails back to User A.

Note that User B may receive a warning message that the form template associated with the form has a higher version than the one stored on the machine. Clicking Yes will allow user to open the form.

7. User A receives the form and re-submits it to DBXL.

Requirements

DBXL v2.4 or higher
InfoPath 2007 with SP2 or InfoPath 2010 with SP2
Outlook 2007 or 2010 (for domain members)