Publish - Combined Web Databases

Description:

A single web database can collect data for more than one survey. In these cases, the surveys must have identical form fields and field types. Such is the case for surveys that must include Section 508 forms and multi language surveys.

Reasons:

Instructions:

For a normal .asc database, here is how to setup a single online data file to be used by multiple published surveys.

  1. Create the first survey and publish it to a website.
  2. Copy the first survey's .ezf file and rename it. This will be the second survey.
  3. Make the necessary changes to the seconds survey.
  4. Publish the second survey to the same web directory as the first survey.
  5. Edit the second survey's projectname.ini file. Change the value of the field named SAVEDATANAME to the name of the first survey's database file name. You may want to look at the value in the first surveys .ini file to find out what it is.
  6. Test both surveys to make sure they submit data to the data file.

For an ODBC database, here is how to setup a single database connection to be used by multiple published surveys.

  1. Create the first survey and publish it to a website.
  2. Copy the first survey's .ezf file and rename it. This will be the second survey.
  3. Make the necessary changes to the seconds survey.
  4. Publish the second survey to the same web directory as the first survey. Make sure that the ODBC publishing options are the same as on the first survey.
  5. Test both surveys to make sure they submit data to the data file.

See also...