Page 1 of 1

Extract Forms Data

PostPosted: Fri Jul 22, 2011 10:45 am
by sbuttitta
I need to extract forms data out of Touchworks 10. I found the data in the Impact database and can get all the data for a particular document, but shy of creating templates for each form, is there a way to get the data out in the same format you see it in Touchworks?

Re: Extract Forms Data

PostPosted: Mon Jul 25, 2011 10:28 am
by mike.dow

Administrative / Impact.MD Forms are tough to query. The values are stored in custom tables and the columns are not well named (e.g. Field123 may be Retinal Exam on the form).

I tried to dig up an existing query, but could not find it easily. The tables are in the Impact database and start with the letters FRM.

Good luck!