SSI Web v8 saves to a MySQL database on the server. We no longer are saving respondent data to files on the server. If you are hosting on your own your server will need the following:
After a database has been manually created for SSI Web, the following Database Settings will need to be entered into SSI Web:
- Database Name
- Host Name
- User Name
To upload your survey to the server you can use SSI Web’s Auto Upload feature. Auto Upload will upload the necessary survey files and it will build the database tables. Subsequent uploads will automatically apply necessary changes to the database.
NOTE: If you upload your survey manually, after uploading the survey files you will need to log into the Admin Module to “apply changes” to the database. This will need to be done anytime the survey is changed.
Assuming that your study name is “study1″ the following tables will be created for the study in the database:
This table contains miscellaneous information about the study.
This table contains a column for each data point in your survey. If you have a large survey the data will be split across multiple data tables (data1, data2, data 3, etc.).
This table contains a comma separated list of data field names for each data table. If data is spread across multiple data tables the “map” table shows which data field is in which data table.
This table contains the history data for each respondent. This data is used when the respondent backs up in a survey.
This table contains the constructed list data.
If the study contains passwords this table contains all of the password information.
If the study contains quotas this table contains all of the quota information.
If your server does not have a database, or you want to try out our hosting service, you can host your v8 Beta surveys with us for free. To host with us go to:
Sign up for a new account (or use your current account) and create a V8 Beta Server project. Free hosting will only be available until the end of the beta period.
If you have any feedback on the database please let us know.