Extract Forms Data

Extract Forms Data

Postby sbuttitta » Fri Jul 22, 2011 10:45 am

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?
sbuttitta
 
Posts: 1
Joined: Fri Jul 22, 2011 7:54 am

Re: Extract Forms Data

Postby mike.dow » Mon Jul 25, 2011 10:28 am

Steve,

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!
Mike
Mike Dow
VP, Technical Services
Galen Healthcare Solutions
mike.dow
 
Posts: 16
Joined: Tue Mar 22, 2011 3:49 pm


Return to Conversions

Who is online

Users browsing this forum: No registered users and 1 guest

cron