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:
- A normal survey and a Section 508 survey may need to point to the same database.
- A survey may be published in a single-page format and a multi-page format. Both surveys may use the same online web database.
- A survey may be published in several languages and all of the data may be collected into a single online database.
- A normal survey may have an administration page where the survey administrator can edit 'hidden' and other fields. Both surveys may use the same online database.
- Two surveys may have a different look and feel but may still use the same online database
Instructions:
For a normal .asc database, here is how to setup a single online data file to be used by multiple published surveys.
- Create the first survey and publish it to a website.
- Copy the first survey's .ezf file and rename it. This will be the second survey.
- Make the necessary changes to the seconds survey.
- Publish the second survey to the same web directory as the first survey.
- 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.
- 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.
- Create the first survey and publish it to a website.
- Copy the first survey's .ezf file and rename it. This will be the second survey.
- Make the necessary changes to the seconds survey.
- 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.
- Test both surveys to make sure they submit data to the data file.
See also...