Querying the Checkbox Database

[jvg]

Hi,

I've installed the trial version of the check box survey application in my local machine and exploring the various features. One of my requirement is to get export the data from check box survey so that it matches with our existing survey. So I've wrote some custom SQL statements and I could able to get all the answers and the associated items with a survey. However I've a hard time in getting the survey questions from the checkbox database. Can somebody help me out in finding the right table to get the Survey questions?

Thanks,
JVG

[pwiesner]

Typically detailed support on the inner workings of the database is limited to customers who have purchased the developer kit. That being said the particular task you are trying to accomplish is a difficult one. Most of the the logic responsible for exporting results resides in the application and not stored procedures I can point you toward.

The best way to capture this query for a given report would be to connect a SQL profiler to your database when you run a Checkbox report.

Do you have a requirement that the export be performed in the database? If not, the developer kit contains methods for exporting survey responses to csv.

If you need a more detailed explanation please contact your sales representative.