You are viewing limited content. For full access, please sign in.

Question

Question

Reporting on data with external reporting software

asked on May 24, 2019 Show version history

New to laserfiche. I want the ability to report off data stored in the forms. I have a Report IQ software I can link to the DB, but I am not sure where the form data is located. 

 

Would It be easier if I exported the data into a seperate DB for reporting, or can I use the existing LF DB?

0 0

Answer

SELECTED ANSWER
replied on May 24, 2019

Copying the data out to a reporting database might be easier depending on what you're trying to accomplish. The data structure for Forms is somewhat complicated because it has to support an infinite number of variations in form fields.

The secondary concern would be that the underlying database is subject to change when new versions are released and that could break your reports. If you use workflow to retrieve field values and put them into a secondary database you could structure the data exactly the way you want.

If you want to pursue reporting directly off the Forms database, it is going to require joins on several tables to get the form, instances, submissions, variables, etc. Basically there's no single database entry for a form/submission, it is a complex web of relationship mapping.

2 0
replied on May 24, 2019

What is the best way to use Workflow to export into a reporting DB? I couldn't find a straightforward way to accomplish.

0 0
replied on May 24, 2019

You would have each form submission initiate a workflow at the end of the process. In the workflow, you would use a Retrieve Business Process Variables activity to get the data from the form, and use an Insert/Update Data activity to put those values into your database.

1 0

Replies

You are not allowed to reply in this post.
You are not allowed to follow up in this post.

Sign in to reply to this post.