You can see how many complete and incomplete entries your questionnaire has by pointing your browser to http://survey.osucre.be/username/complete.php (change survey.osucre.be to your server name if applicable and change your username).
To download your data you need to access the fetch file. You will need your username and password to fetch your data. Go to http://survey.osucre.be/username/fetch.html . On this page, enter your username and password. Now choose which output you prefer: excel or csv. Click the fetch button to get your data.
If you choose excel the excel format, an excel file will be generated that contains your data. As mentioned before, no more than 256 fields will be visible in the excel sheet. Moreover if text cells contain more than 256 characters, only the first 256 will be visible.
If you choose csv all data will be put into your browser window. Each cell will be separated by a semicolon. If respondents have used semicolons, the cells will not correspond to the database content, but this should be very easy to remediate. Choose edit - select all and next edit - copy in your browser to copy the data to your memory (CTRL+C). Next open a plain text file (for example in notepad) and paste the data inside. Now you can open this file in any spreadsheet or statistical program by telling that cells are delimited by semicolons (;).
Note that fetching the data will only get a copy of the data in the database. It will not erase any data. Doing another fetch will yield the same data, or possibly additional data if more respondents have filled out the questionnaire.
I you use SPSS to analyze your data: an SPSS syntax file is generated with the survey. This syntax file will add variable labels (questions) and value labels (answer options) to your SPSS data file. Make sure your data file only contains the data from your survey before you do this. Not doing so could result in errors. To run the syntax file, just open it in SPSS, select everything (CTRL+A) and click the run button (or press CTRL+R) or select the "Run all" option from the "Run" menu. Additionally, a syntax is created (named importdata.sps) that will enable you to import the Excel data into an SPSS file.
IMPORTANT NOTE CONCERNING SPSS SYNTAX
This is how the variable labels and value labels are added to the SPSS syntax:
When the OSuCre syntax contains a question combined with an input option (e.g. radio button) a line is added to the SPSS syntax containing the text in the Question column of the OSuCre syntax. In the SPSS syntax the question itself will thus be used as label. You have the option to change this by doing the following:
Type in your question and add the SPSS syntax between braces ({}).
An example: Type in as a question: "Please rate the following person:{person1}".
The survey will now contain "Please rate the following person" while the SPSS syntax file will contain "person1" as a label.
OSuCre uses an analogous procedure for the value labels. Adding text in between braces ({}) to the label columns in the OSuCre syntax will tell SPSS what value labels to add.
Two examples are given below:
| QUESTION | TYPE | SIZE | DIRECTION | CONTROL | LABEL 1 | LABEL 2 | LABEL 3 | LABEL 4 | LABEL 5 |
| Please rate the following person {person 1} | radio | 5 | very attractive | very unattractive | |||||
| I am {gender} | radio | 2 | a man{male} | a woman{female} |
Important: When converting your syntax file, two files are created (empty.html and empty.php) to erase your database. If someone can guess your password, it would be very easy to erase all of your data. Make sure you have a hard to guess password! You could also consider not uploading the empty.html and empty.php files.
Removing ALL data from the database can be done by pointing your browser to http://pehelp.vub.ac.be/username/empty.html and entering your username and password.
Respondents can in no way erase any data from your database.