Data Collection – iSurvey News and Help https://www.isurvey.soton.ac.uk/help iSurvey News and Help Fri, 12 Jun 2020 06:05:33 +0000 en-US hourly 1 https://wordpress.org/?v=4.9.8 Opening CSV files containing international language data https://www.isurvey.soton.ac.uk/help/opening-csv-files-containing-international-language-data/ Mon, 13 Nov 2017 10:55:15 +0000 https://www.isurvey.soton.ac.uk/help/?p=580 Continue reading ]]> A user reported that responses from Greek participants looked fine in iSurvey but appeared as meaningless symbols (e.g. ΓεÏμανία) when the CSV data file was opened in Excel. I used the excellent free open-source Notepad++ to open the CSV file and check its encoding, UTF-8, which supports almost all international languages. The Greek language responses looked fine.

It turns out the problem is the way Excel imports CSV files, which by default does not support UTF-8 data. There is an easy work around described by the Information Technology Group at the Institute for Advanced Studies at Princeton:

Follow the steps outlined below to use Microsoft Excel to open a .csv file that uses UTF-8 character encoding.

  1. Open Microsoft Excel.
  2. Click on the Data menu bar option.
  3. Click on the From Text icon.
  4. Navigate to the location of the file that you want to import.  Click on the filename and then click on the Import button.  The Text Import Wizard – Step 1 or 3 window will now appear on the screen.
  5. Choose the file type that best describes your data – Delimited or Fixed Width.
  6. Choose 65001: Unicode (UTF-8) from the drop-down list that appears next to File origin.
  7. Click on the Next button to display the Text Import Wizard – Step 2 or 3 window.
  8. Place a checkmark next to the delimiter that was used in the file you wish to import into Microsoft Excel.  The Data preview window will show you how your data will appear based on the delimiter that you chose.
  9. Click on the Next button to display the Text Import Wizard – Step 3 of 3.
  10. Choose the appropriate data format for each column of data that you want to import.  You also have the option to not import one or more columns of data if you want.
  11. Click on the Finish button to finish importing your data into Microsoft Excel.
]]>
Deleted data cannot be restored https://www.isurvey.soton.ac.uk/help/deleted-data-cannot-be-restored/ Mon, 14 Aug 2017 10:36:37 +0000 https://www.isurvey.soton.ac.uk/help/?p=573 Continue reading ]]> We have had a couple of ServiceLine requests recently asking for data that had accidentally been deleted to be restored, and unfortunately that is not possible – deleted data is gone for ever.

The technical team say that “iSurvey doesn’t do ‘soft deletes’ (marking records as deleted), so once the user hits delete, the data is deleted.”

iSurvey is backed up daily, but that is so we can restore the whole system in case of a catastrophic failure – for example if the server was hacked. Note that all data and survey edits since that backup was made would be lost.

So the golden rule is ALWAYS download a copy of the data before deleting any records.

If you are checking iSurvey regularly (maybe once each day) to look at any new responses to your survey, I would recommend downloading the data as part of that check. It never hurt to have too many backups, provided you store that data securely.

 

 

]]>
Why do I have lots of ‘blank’ participants? https://www.isurvey.soton.ac.uk/help/why-do-i-have-lots-of-blank-participants/ Wed, 06 Jun 2012 08:38:48 +0000 https://www.isurvey.soton.ac.uk/help/?p=443 Continue reading ]]> You may find that your survey gets a lot of empty participants i.e. participants that appear to have started the survey but have given no answers.

This is often due to ‘robots’ and search engine spiders that are trawling the internet.

If your survey is ‘online’ and public, you may see this occurring.

Because of this we’ve added a new feature ‘delete blank participants’ which will allow you to ‘one click’ clean up your participant dataset.

]]>
How do I pre-populate a participant question response? https://www.isurvey.soton.ac.uk/help/how-do-i-pre-populate-a-participant-question-response/ Mon, 03 Oct 2011 10:30:00 +0000 https://www.isurvey.soton.ac.uk/help/?p=411 Continue reading ]]> in some cases it is useful (if not essential) to pre-populate a question  with a custom response for that participant. e.g. if each participant has a unique research ID associated with them and you do not want them to have to find it and then risk having them type it in wrong.

There are two ways of doing this.

Option 1. By appending the survey web address

This is best used if you have a single individual you want to send to. How to do this.

a) Get the ID number of the question you want to pre-populate.
You can find this by going to the question and editing it. Look in the URL and you will see the question ID. In the example below the question ID is 149739

b) Change the survey URL and append the question ID and response
Your survey URL will be something like this. www.isurvey.soton.ac.uk/MYSURVEYID where MYSURVEYID is the ID of your survey. Change this to the following:
www.isurvey.soton.ac.uk/start.php?id=MYSURVEYID
Check that works! If it looks ok,  append the URL with the following
‘&qid149739=My Response’
Where 149739 is THE ID NUMBER OF YOUR QUESTION.

The finished URL should look like this:
https://www.isurvey.soton.ac.uk/start.php?id=3271&qid149739=My Response

where id=3271 is your survey ID,  149739 is your question ID and ‘My Response’ is the text you wish to pre-populate the question.

Option 2 : Use the ‘Custom Data’ option in the Invitation Lists

Invitation lists let you send out emails to multiple participants at once by uploading a CSV containing their name and emails.

By populating the ‘Custom Data’ field you can pre-populate any question you wish with bespoke text for each participant.
The CSV file has the format:
Email Address, First Name, Last Name, Custom Data

The example below will pre-populate question ID 149739 with the text ‘AC345G’
johnsmith@soton.ac.uk, John, Smith, qid149739=AC345G

You can pre-populate many questions at once by adding a new question ID (qid) separated by ‘&’
e.g.  johnsmith@soton.ac.uk, John, Smith, qid149739=AC345G&qid149740=Male&qid149742=single

]]>
What is the participant ‘time out’ period? https://www.isurvey.soton.ac.uk/help/what-is-the-participant-time-out-period/ Fri, 12 Aug 2011 09:17:54 +0000 https://www.isurvey.soton.ac.uk/help/?p=395 Continue reading ]]> If a participant spends more than one hour on a single page they will be ‘timed out’.

The time out feature ensures maximum security for your data. It’s essentially the same as logging in to your online bank – when you are ‘inactive’ for a while it automatically logs you out.

It is highly recommended if you are running large surveys that you do not have all your questions on one page. Break things up into sections, or have 4/5 questions per page for each section if you only have one section.

If a participant is timed out any data on that page will be lost.

]]>
Why do I have a lot of ‘non-finisher’ participants? https://www.isurvey.soton.ac.uk/help/why-do-i-have-a-lot-of-non-finisher-participants/ Mon, 06 Jun 2011 14:39:48 +0000 https://www.isurvey.soton.ac.uk/help/?p=362 Continue reading ]]> The nature of online surveys dictate that you will get many ‘non completers’ – typically only 30-40% of people that start your survey will actually complete the entire survey.

This will obviously vary if their is a reward for completion e.g. payment, research credits etc..

You will also get an increased drop out rate if you have a particularly long survey with many questions.

Finally, it should be noted that each time you test your survey using the ‘Full preview’ mode a new participant is created.

If your dataset is only valid if you use 100% completers, a data download option for downloading ONLY complete datasets is available.

]]>
How can I ensure that participants answer all questions in my survey? https://www.isurvey.soton.ac.uk/help/how-can-i-ensure-that-participants-answer-all-questions-in-my-survey/ Mon, 06 Jun 2011 14:30:45 +0000 https://www.isurvey.soton.ac.uk/help/?p=359 Continue reading ]]> One of the options within ‘Survey Options’ allows you to alert participants if they try to proceed when they have left questions unanswered.
This highlights questions on the page they have not attempted to complete. (see screen shot)

The 'blank answer' alert option

Please note that due to ethical reasons you CANNOT force participants to answer all questions before progressing to the next page- all iSurvey can do is alert them to the fact that they have missed some, and if they wish they can attempt to complete them.

]]>
Is there a limit to the number of participants I can have? https://www.isurvey.soton.ac.uk/help/is-there-a-limit-to-the-number-of-participants-i-can-have/ Tue, 24 May 2011 15:09:36 +0000 https://www.isurvey.soton.ac.uk/help/?p=346 No. There is no limit to the number of participants / datasets you collect.

There is also no limit to the number of surveys, sections or questions you want to create.

]]>
How can I view my data? https://www.isurvey.soton.ac.uk/help/how-can-i-view-my-data/ Mon, 09 May 2011 14:18:32 +0000 https://www.isurvey.soton.ac.uk/help/?p=316 Continue reading ]]> You can view your datasets online, as well as downloading all data as a CSV spreadsheet for importing into SPSS or Excel.

Options for online viewing include bar graphs, pie charts and 3d pies. Examples are shown below – note you can customised the colour, graph type and graph size.

Bar Chart Example

3d Pie Example

Simple Pie Example

]]>
Can I password protect my survey? https://www.isurvey.soton.ac.uk/help/can-i-password-protect-my-survey/ Mon, 09 May 2011 14:13:14 +0000 https://www.isurvey.soton.ac.uk/help/?p=314 Yes, if you wish to restrict participants from accessing your survey unless they have a password you can easily do so. The option is found in the ‘Survey settings

]]>