Qdabra Database Accelerator

Re: Report on repeating data for existing forms

tenbao — Tue, 27 May 2014 18:07:27 GMT

Thank you for the info.

Re: Report on repeating data for existing forms

Jim Cantwell — Fri, 23 May 2014 22:21:35 GMT

The DBXL event receiver will submit the document to DBXL whenever the SharePoint Added, Updated or Deleting events are fired. Workflow operations that update the form content should generate these events and the DBXL document updated.

Re: Report on repeating data for existing forms

tenbao — Fri, 23 May 2014 20:24:21 GMT

I was hoping for an easier solution than mapping with SQL. I was also hoping that DBXL had the ability to get the collection of XML documents and parse them somehow.

It's great to read that DBXL 2.8 is now based on the Event Receiver model. Does that mean form updates done via SharePoint workflows would now be updated in the SQL DB mapped fields as well?

Re: Report on repeating data for existing forms

ErnestoM — Fri, 23 May 2014 20:13:41 GMT

I think there are some options for DBXL if you don't want the form(s) to submit to the web service.

In DBXL v2.8, the forms submit directly to the form library, and the DBXL Event Receiver maps the data to DBXL. Then, DBXL can map the data to SQL for reporting. The Deployment Guide (and other DBXL v2.8 documents) can be found here for more info: http://www.infopathdev.com/files/folders/installation_and_setup/tags/DBXL+v2.8/default.aspx

Using DBXL v2.7 Standalone Edition, you could perform a sync with a form library and download the data into a local version of DBXL, then map into SQL. More info on that scenario here: http://www.infopathdev.com/files/folders/standalone/entry74112.aspx

Hope this helps!

Re: Report on repeating data for existing forms

Hilary Stoupa — Fri, 23 May 2014 18:56:36 GMT

Not really - if you promote your repeating fields to your library, you can set them to "merge" the data, but trying to sort that out is pretty messy. You can submit the repeating data to a list (either via CAML, custom code, or qRules) and then report on the list....

Report on repeating data for existing forms

tenbao — Fri, 23 May 2014 18:50:53 GMT

I've read through a few posts on reporting on repeating data through DBXL. But it seems that in those posts the forms are submitting to DBXL. Is there a way to report on repeating data for forms that are submitting to SharePoint?