surveyproject/surveyproject

Survey Project Webapplication - development, sources & releases

surveyproject repository /

• Survey™ Project (SP) is a free. open source survey and (data entry) forms webapplication (WAP) for processing & gathering data online.

• Survey™ Project is written in C#, ASP.NET and runs on Windows OS, IIS and MsSqlserver databases.

• Survey™ Project is an easy-to-use webapp to collect data and information from customers, visitors or employees efficiently.

At Github you will find the most recent Survey™ Project releases, source code and several branches for (public) development. Former releases (up untill v 2.3) and sources can be found at http://survey.codeplex.com

Documentation

Available Guides for SP™ v2.5

• Quickstart UserGuide
• Installation Guide
• Developers Guide

Download at: http://www.surveyproject.org/Support/Helpfiles/GuidesManuals/tabid/300/Default.aspx

On Github check the docs directory of the repository for information on:

• Support
• Code of Conduct
• Contributions
• Issue Template
• Pull Request Template

Platform & Websites

The following sites are part of the current project and development platform:

+Survey™ Project Community at http://www.surveyproject.org

• main site of the project for regular status updates
• forums on all SP™ related subjects
• all product information and backgrounds
• links and help files

+Survey™ Project Demonstation at http://www.surveyproject.net

• test and demo site of the latest SP™ webapplication
• test and demo of online survey samples

+Survey™ Project Codeplex at http://survey.codeplex.com

• former versions of the source code
• former releases;
• (legacy) documentation

Note: as announced by Microsoft [2017/03/31] the Codeplex site will shutdown. Already this Github site has replaced all former Codeplex features for the SP™ project. All information on Codeplex will be archived and remain available.

Branches Overview

Current

• master: initial branche containing the SP v2.3 production source code

• sp_24_dev: SP v2.4 production source code

• sp_25_dev: SP v2.5 production source code - current default

Future

• sp_26_dev: branche to be created based on sp_25_prod for project development of SP v. 2.6

surveyproject's Issues

Remove binaries from repository

Add a .gitignore file to the repository so the binaries don't clutter up the diffs and get copied from branch to branch all over the history of the repository. Having them in the repository drastically increases the size of the repo.

Will follow up with a PR.

Usermanagement authorizations based on usergroups

Current working

• Usermanagement does not have an option to create groups of users;
• Usermanagement is allowed to admins and users assigned the roleright: "user manager access";
• Once authorized they have access to all users ever created or imported;

Proposed working:

• option to create usergroup and add users to a group;
• option to base usermanagement access on usergroup authorization;

This would make it possible to give access to a specific usergroup only.

Answers Default text of default language on Multilanguage survey not shown

Discovered in SP v. 2.3 (andn in the SP 2.4 alpha version so far)

To replicate:

• create new survey
• set survey to multilanguage (e.g. en-US default + nl-NL second)
• create question + add answer
• set answer default text: [any text} in answereditor for both en-US and nl-NL language
• open weblink to survey, choose default language (en-US)
• the default text does not show
• restart survey: choose second language: the default text does show correcty

Expected situation:

• default text should show on default language correctly as well

Edit option for Repondents after Survey Submit

NEW FEATURE

a. User story

As a ...

Respondent and (registered) SP user

I want to ...

be able to login to SP and change/ edit the survey answers I submitted through the SP webapplication

So that I can ...

correct mistakes or add additional info/ answers to the survey after a review or on receiving feedback.

b. Acceptance Criteria

Scenario 1

Given...

An SP User (repondent) who has answered and submitted a (SP Security Context secured) survey throught the Take Survey menu (one or more times) and who is authorised to access the Individual Reponses menu (new Roleright) to edit previously submitted answers

When....

the respondent wants to edit (change/ add to) the answers submitted (individual reponses of the specific respondents/ SP user) and is logged in to SP and on opening the Individual Reponses webpage

Then .....

a (table)list of survey reponses submitted by the particular SP user only (!) is presented of which each submission (row) can be clicked to open the full resultsreport of all Q/A's including edit options (change/ save/ resubmit).

Scenario 2

Given...

An SP Administrator or SP User who has the 'field entries access' role assigned

When....

logged in to SP and on opening the Individual Responses webpage (former Field Reporting webpage)

Then .....

a (table) list of survey reponses submitted by all (!) repondents (Sp users and other) is presented of which each submission (row) can be clicked to open the complete resultsreport including edit options (change/ save/ resubmit).

Scenario 3

Given...

A survey that needs to have the option to view/edit/change answers after submisson by the respondent

When....

creating the survey (Q/A) and determining the survey settings

Then .....

• the "SP security Context" security addin must be added to the survey and activated
• an SP Useraccount must be created for each individual repondent to login to the SP webapplication
• an appropriate role/ rolerights must be assigned to the Useraccount
• the survey must be assigned to the Useraccount

Foreign Constraint

When I run the publish function from Visual Studio and drop everything in the database, recreate it and try to load data in a script generated by the database, I get this error. The script is set to check constraints and check for object existence. Why would there be a missing constraint?

Severity Code Description Project File Line
Error Web deployment task failed. (An error occurred during execution of the database script. The error occurred between the following lines of the script: "1504" and "1508". The verbose log might have more information about the error. The command started with the following:
"/****** Object: Index [PK_vts_tbSurvey] Script"
The constraint 'PK_vts_tbSurvey' is being referenced by table 'vts_tbSurveyAsset', foreign key constraint 'FK__vts_tbSur__Surve__1387E197'.
Could not drop constraint. See previous errors. http://go.microsoft.com/fwlink/?LinkId=178587 Learn more at: http://go.microsoft.com/fwlink/?LinkId=221672#ERROR_SQL_EXECUTION_FAILURE.) SurveyWAP 0

Redirection URL removed on Changing Notification Settings

General description

• when a Redirection URL is set through the Completion menu option it will be removed when the Notification message is set or edited through the Survey Settings menu.

FileType missing from vts_spFileGetListForGuid

When getting a list of files with the group guid:

FileData guidFiles = new Answers().GetGuidFiles(this.GroupGuid);

FileType is always null

The origin of this issue of is that the stored procedure being called (vts_spFileGetListForGuid) does not return FileType.

One specific place FileType is intended to be used but does not behave as intended is in the AnswerUploadItem.cs for displaying the uploaded files.

fix:
change vts_spFileGetListForGuid to be:
SELECT FileId, GroupGuid, FileName, FileSize, FileType, SaveDate, -1 as VoterId FROM vts_tbFile WHERE GroupGuid = @GroupGuid

Add new DocFX project to SP solution to create/ maintain Technical Documentation

• Add a new DocFX project to the SP solution to create/ maintain Technical Documentation
• Use the DocFx SP project to automatically create webpages to be hosted on a Github/surveyproject site

Inconsistent values with Field - Slider on save progress

With an answer of type Field-Slider, saving your progress on the survey loads the wrong value after the process is complete...

Steps to reproduce:
On a form with save progress mode set to manual
A slider with min value 1 and max value 10...
Open the survey and set the slider to 6, then click save progress
You will see the slider get set to 1 after progress has been saved.
If you click save progress a second time, after the process is complete, the slider will display 6 again
Clicking the save progress button a third time will change the slider to display 1 again.
Clicking save progress a fourth time will change the slider to 6 again

This seems to toggle back and forth indefinitely.

If you look at the HTML, you can clearly see that the input element's value is set to 6 when the slider displays 1, and the input element's value is set to 1 when the slider displays 6

Token Security error on submitting survey

When using token security on a survey an error will show on submitting the survey:

"The number of parameters does not match number of values for stored procedure."

The cause of the error can be found (and fixed) in:

...\Reflector\Nsurvey_SQLServerDAL\Votations.NSurvey.SQLServerDAL\SurveyToken.cs

Solution: add surveyid to arraylist:

    public void UpdateToken(int surveyID, string token,int voterId)
    {
        ArrayList commandParameters = new ArrayList();
        {
            commandParameters.Add(new SqlParameter("@surveyid", surveyID).SqlValue);
            commandParameters.Add(new SqlParameter("@token", token).SqlValue);
            commandParameters.Add(new SqlParameter("@voterId", voterId).SqlValue);
        }

        object obj2 = DbConnection.db.ExecuteScalar("vts_spSurveyTokenUpdate", commandParameters.ToArray());
    }

Friendly Name URL duplicates not blocked

Expected Behaviour

When creating a Friendly Name URL (menu Campaigns/Web/...) there should be a check on uniqueness of the name used. It should not be possible to use the same Friendly URL on two different surveys.

Actual Behaviour

Even if a Friendly name for the URL is already used on a survey it is not rejected and no warning message is shown. If two similar Friendly URL's exist when used the choice of survey to be shown is 'random'.

Steps to Reproduce Behaviour

1. Create 2 different surveys
2. Create a Friendly URL for both surveys with the same name: no warning or rejection follows
3. Open both surveys by the Friendly URL: random choice of survey to open (highest ID first?)

Possible Cause and/or Solution

Solution: build check on Friendly Name already used and block saving new entry if already in use.

Technical Specifications

• Version of Survey Project: SP v. 2.4
• Type of Device (pc, laptop, tablet, mobile): all
• Browser Type & Version: all
• Operating System: all

Context (Environment)

There is a potential security risk if using a Friendly Name URL may open different surveys at random. To end users there will be great confusion if a survey is opening that should not.

Improved Survey Statistics page

Additional information to be added to the GlobalStats Page (Statistics menu)

• surveytitle added + status Active/ Inactive
• Active Languages added (if ML is enabled)
• Open / Close date added (if not null)

Branching rules should be exported/imported

The branching capabilities are great but without being able to export them and import them, they are of limited usefulness.

Add a new/ updated list of LanguageCodes for MultiLanguage use

• Add a new (extended and updated) list language/country codes to be used in multi language scenarios:

• ML surveys, libraries etc.

• New technical setup: separate XML file for language/ country codes instead of the current default language XML file.

Custom HTML lost in Question editor

I put in this code (so that I can write CSS against the controls)

My Label

after saving and reloading, it changes to this

My label

scroll form builder by touchpad or touchscreen

NEW FEATURE

a. User story

As a ...

Survey Creator & SP administrator

I want to ...

be able to scroll the SP webpages in a user friendly and unambiguous way on PC's/ laptops and tablets

So that I can ...

work efficiently and use different devices to create, publish and administer surveys

b. Acceptance Criteria

Scenario 1

Given...

the formbuilder webpage (or any other SP webpage)

When....

creating a lengthy survey longer than the browsers viewport

Then .....

scrolling must be possibe on different devices (PC/ Laptop/ Tablet)

Scenario 2

Given...

a lenghty SP webpage longer than the browsers viewport

When....

its necessary to scroll up and down the page

Then .....

scrolling must be possible by using the cursor or by pointing device

Scenario 3

Given...

a lenghty SP webpage longer than the browsers viewport

When....

its necessary to scroll up and down the page

Then .....

there can be only one scroll bar necessary to scroll/ view all content

Add Security Improvements

Several adjustments needed/ advised based on (ZAP) security testing:

• clickjacking
  HTTP header added to web.config
  X-Frame-Options
  https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/X-Frame-Options
  https://blogs.msdn.microsoft.com/ieinternals/2010/03/30/combating-clickjacking-with-x-frame-options/

• autocomplete off on password form field
  loginbox.ascx attrib added

• XXS security header
  https://www.veracode.com/blog/2014/03/guidelines-for-setting-security-headers
  https://developer.mozilla.org/en-US/docs/Web/HTTP/Headers/X-XSS-Protection
  http://www.insiderattack.net/2014/04/configuring-secure-iis-response-headers.html

• server http header removed
  global.config application_begin ..

• encrypted Viewstate on survey form

Data Export CSV file not containing Username/ Email address

SP version 2.3

a. Current behaviour:
The Data Export CSV file contains two fields Username/ Email that are not filled properly on exporting survey respondents data through the Results/ Data Export Menu.

The XML export option does contain the email address of the respondent.

b. Required behaviour:

• if available all fields should be filled properly (both XML and CSV files)

Procedure or function 'vts_spAnswerAddNew' expects parameter '@CssClass', which was not supplied.

When try to import a xml question I get the error message
"
Procedure or function 'vts_spAnswerAddNew' expects parameter '@CssClass', which was not supplied.
"

Graphical Reports appear to do nothing

I don't know what else I can say or provide here. Select a survey, go to Results >> Reports. Click on... everything but Graphical Reports do nothing at all. The other two options seem to work.

Multiple Survey submission problem: refresh page or browse back

1. ISSUE/ BUG/ ERROR

a. Expected Behaviour

To block a person to submit the same questionnaire many times.

b. Actual Behaviour

When they submit the questionnaire, they could click "Back" button of the browser. Then, they could submit the same questionnaire again and we see the database received the 2nd record. In addition, on the page of the questionnaire, when a user clicks the "Submit" button twice, there are two questionnaire records.

c. Steps to Reproduce Behaviour

1. Submit a questionnaire and the system shows a thank you information.
2. Click the button "Back" on the browser.
3. Submit this questionnaire again.

The other problem is:

1. Click the button "Submit" quickly twice.

d. Possible Cause and/or Solution

We get the information from the forum.
http://www.surveyproject.org/Forums/tabid/107/forumid/6/threadid/514/scope/posts/Default.aspx
However, it is not the solution we expect.

e. Technical Specifications

• Version of Survey Project: 2.3
• Type of Device (pc, laptop, tablet, mobile): PC
• Browser Type & Version: Chrome
• Operating System: Windows 7, Mac OSX

BE Project Files completed and corrected

Technical Change (upgrade/ adjustment)

Description

Cleanout, completion and correction of BE Project files (Votations.Nsurvey.Data)

Impact & Changes

• xsd files included in project
• cs files added if missing
• filterdata correction (Parentid)

Surveylist Additions to increase useability

Two changes to improve useability of the Survey list overview:

• add the URL Friendlyname to Surveylist gridview in the title tooltip
• add SurveyID to title (+ adjust text alignment)

Assemblies/ DLL namechange to Surveyproject.[name]

Technical Changes (upgrade/ adjustment)

Description

Name change of DLL's/ Assemblies to SurveyProject.[name] instead of Votations.Nsurvey.[name]

Impact & Changes

• Assemblies name change only; code namespaces not adjusted (future option)
• all code files (.aspx/ .cs) corrected: replace votations.nsuvey if hardcoded
• Export/ import survey XML files corrections needed
• Sql installation scripts corrections

Adding pages in the middle of a survey doesn't update existing branching rules

1. Start with a survey where a question on page 1 determines if page 2 or 3 is next and pages 2 and 3 both go to 4.
2. Add page after page 1.
3. The branching on page 1 goes to the new page 2 and page 3 (which was page 2), the branching on page 3 (was 2) goes to 4 (was 3), and the branching on 4 (was 3) does to itself.

Graphically, if I had pages (A, B, C, D), with branching which cause flow to be either

• A -> B -> D, or
• A -> C -> D.

If I add Z after A so I have (A, Z, B, C, D), my branching is now

• A -> Z -> C -> C and
• A -> B -> C -> C

Add paging to survey list

Proposal for new feature:

• add paging options to the survey list in menu: Survey > Survey List
• currently all surveys are shown in a long list;

Want to be able to add dropdown list for row headers for matrix question type.

Current system does only allow basic titles for row and column headers in matrix question type. I would like to be able to add dropdown selections for the rows headers. The user will be able to select one an option in each row for the header then give a grade on the columns for the selected option.

Is it possible to add this feature the survey project?

Scrolling and page frame

The forms sometimes do not expose action buttons and don't allow scrolling within the page. Recommend removing fixed footer and stop truncating display.

Implement SSRS Reports in SP

Add SSRS (Sqlserver Reportings Services) reports to SP:

• initial/ basic reports on SP survey/ voter data
• technical structure to easily add new (custom) SSRS reports

SP Webapp changes:

• NsurveyReports/.. directory
• Basic SSRS reports added
• reporting services dlls added
• new directory: sqlservertypes added
• Nuget (2) packages added

New Security addin - Alert message added and set as default

• Add a new 'General Warning Message' to choose from (DDL) as the alert action when a security add in is used an added to a survey;
• Change the default alert option 'build message box: thank you message' to the new General Warning message

Set Skip Logic to Questions that are on the same Survey Page

NEW FEATURE

a. User story

As a ...

Survey Creator

I want to ...

be able to create a survey where its possible to "skip" (hide) a question that is on the same page as the question who's answer triggers it

So that I can ...

use skip logic without having to create different pages to hide or skip a question

b. Acceptance Criteria

Scenario 1

Given...

a survey page containing multiple questions

When....

adding skip logic (question level) by selecting a 'trigger' question from the Question DDL

Then .....

the DDL should also contain (preceding) questions that are on the same page as the question to be 'skipped'

Scenario 2

Given...

a survey including the new skip logic feature

When....

a respondent answers the one page survey containing multiple questions

Then .....

the question to which the skip logic is added must be hidden or shown correctly based on the logic and answers given

Create a default Admin Account on First Login after Installation of SP

NEW FEATURE

a. User story

As an ....

Administrator or person responsible for the technical installation of SP

I want to ...

create a default SP Admin account automatically on first login after the (technical) installation of SP based on a valid username/ password combination entered

So that I can ...

have access to SP and start administering the SP webapplication

b. Acceptance Criteria

Scenario 1

Given...

a newly installed version of the SP webapplication

When....

starting/opening the webapplication for the first time in a webbrowser and on first login

Then .....

a default SP admin account must be created based on the username/ password entered in the login textboxes

Scenario 2

Given...

an already existing SP webapplication including one or more useraccounts

When....

loging into the webapplication

Then .....

no new (admin) account must be created and regular username/ password checks must be executed to give access to SP or show a warning message

Scenario 3

Given...

a newly installed version of the SP webapplication

When....

starting/opening the webapplication for the first time in a webbrowser and on first login with an incorrect password (not compliant with password rules)

Then .....

a warning message should show and no account must be created

Field - Hidden default values lost on pause/resume.

When using a Field - Hidden text box to collect information from the URL with ##DefaultValue## set on the answer, the value passed through the URL is lost after pausing and resuming.

Steps to reproduce:

1. Create new survey with manual resume mode
2. Create answer type Field - Basic as our control case
3. Set the "Default text value" box to equal "##DefaultURLValue##"
4. Create answer type Field - Hidden as our test case
5. Set the "Default text value" box to equal "##DefaultURLValue##"
6. Open the survey with "&DefaultURLValue=ThisIsADefaultValue" appended to the URL
7. Save Progress & keep track of resume code
8. Check database to see that the value saved once for each answer
9. Open the survey again, this time omitting the URL parameter
10. Select resume and enter the resume code
11. Take note that the Field - Basic text box retains the original URL parameter value
12. Submit the survey
13. View the voter report or look in the database to see that the original URL parameter value has been replaced with an empty string for the Field - Hidden answer.

My thoughts:
I'm pretty sure the "why" of this is that on the answers being submitted from the client, because the URL parameter is missing, the empty string overwrites the original value from before the values are submitted to the database, since the original value would not be included in the OnAnswersSubmit() function, unlike the Field - Basic answer which set the AnswerText on the client.

In our implementation of the application, we collect a small amount of information before directing the user to the survey, and then store that information passed through the URL as part of the survey.
We don't know what the query string parameters were supposed to be when resuming and therefore cannot repopulate the URL identically from the client-side. Currently, the only thing we know is the resume code.

I'm fairly certain this was not intended behavior, but I have yet been unable to pinpoint the origin of the issue. It seems that sometime between loading the VoterAnswers on resume (line 1344 of SurveyBox.cs) and the merge between VoterAnswers and currentVisitorAnswerSet on SubmitAnswersToDb() (line 1518 of SurveyBox.cs), the original value is lost and overwritten.

My current workaround ideas that I have yet to attempt to implement include
A. Create a new AnswerType to replace Field - Hidden that renders the text box on the client, and is set to display: none in the CSS so that the AnswerText is set and also passed when submitting the answers
B. Attempt to recreate the original URL parameters by querying the database on resume and redirecting the user to the appropriate URL with the parameters set.

Any thoughts or suggestions for a fix? We are losing data / receiving bad data every time a user pauses and resumes a survey.

Upgrade AnswerType Field Calendar to JQuery Datepicker version

• The current anwertype Field Calendar (Datepicker) causes a postback to the server.
• By replacing it with the Jquery version it can be handled in the User interface untill submitting the survey.
• The use of the Jquery datepicker is consistent with its use on other pages of the SP admin tool

New Regular Expressions: hours, minutes checks

New Regular Expressions to add to the default RegEx list:

• hours
• minutes

Used to check for 0 - 60 minutes or 0 - 24 hours.

Removing Table structures

Technical Change (upgrade/ adjustment)

Description

Removing Html Table structures and replacement by Div's to improve mobile compatibility and reponsiveness

Impact & Changes

• Removing html Table structures and replace by Div's
• Clean/ correct codefiles (aspx/ cs etc.)
• Gradual replacement over several releases
• Priority on survey form related code/ pages first.

SP 2.4 Quality Assurance and Testing

Main task for the SP QA & Testing project for version 2.4

• setup and create (default and automated) test sets for SP
• test and report testresults

Can't import a survey twice

I want to revise a survey offline. The workflow I'm considering for this is:

1. Create a survey in my own environment
2. Export the survey
3. Import it to a public place
4. Edit it locally
5. Export it
6. Import the survey as a second survey in the public place
7. Deactivate the old survey
8. Activate the new survey
9. Merge data from the two versions (method TDB)

But at step 6, I get "Another survey with the same name exists in the folder. Please import into different folder." What folder? What name? I gave it a different title.

It would be helpful to include XML-based answers in the survey export

It would be nice to embed XML-based answers in the XML export so that only one file had to be used to transport or archive a survey.

Administration login broken if website gated by Azure AD

Survey does work, but administration side does not successfully log in if Azure website configured with Azure AD authenitcation

Question and Basic AnswerText Box on Same Line

Hi People

Is there anyway through css or code where I can align the Question and Answer on the same line such

Question Answer

Rather than

Question
Answer

For example this would be requried when asking for name , etc.

Thanks

Ray

Missing entries from Databasetable vts_Tbvts_tbWebSecurityAddIn

For unknown reasons 2 database entries were lost since SP v. 2.1: IP Filter and Token Protection. These entries must be added again to the Mssql databasescript.

Original entries in sql code SP 2.0:

SET IDENTITY_INSERT [dbo].[vts_tbWebSecurityAddIn] ON
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (1, N'PasswordProtection', 1, N'Votations.NSurvey.Security.PasswordWebSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (2, N'IPProtection', 1, N'Votations.NSurvey.Security.IPWebSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (3, N'CookieProtection', 1, N'Votations.NSurvey.Security.CookieWebSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (4, N'EmailCodeProtection', 1, N'Votations.NSurvey.Security.EmailWebSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (5, N'ASPNETSecurityContextProtection', 1, N'Votations.NSurvey.Security.ASPNetContextSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (6, N'NSurveySecurityContextProtection', 1, N'Votations.NSurvey.Security.NSurveyContextSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (7, N'EntryQuotaProtection', 1, N'Votations.NSurvey.Security.EntryQuotaSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (8, N'Token Protection', 1, N'Votations.NSurvey.Security.TokenSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
INSERT [dbo].[vts_tbWebSecurityAddIn]([WebSecurityAddInId], [Description], [BuiltIn], [TypeNameSpace], [TypeAssembly], [TypeMode]) VALUES (9, N'IP Filter', 1, N'Votations.NSurvey.Security.IPRangeSecurityAddIn', N'Votations.NSurvey.WebControls', 0)
SET IDENTITY_INSERT [dbo].[vts_tbWebSecurityAddIn] OFF

Fileupload files missing on VoterReport in Edit mode

Current working (SP 2.3.)
1- Create survey including Question with Upload Answer option;
2- submit survey including an uploaded file through the upload question
3- go to reports/ votereports -> click details to open voterreport of submitted survey
4- the uploaded file is shown correctly on the voterreport screen
5- next switch to Voter Answer Edit mode
6- the (list of) uploaded file(s) no longer shows

Expected situation:

• on step 5/6: the list of uploaded files should be shown (similar to the one shown on the non- editable voter report screen)

Instruction on installing & using AD/ Windows Authentication

Based on several requests over the years it seems about time to come up with a proper instruction on how to setup SP using Active Directory or Windows Authentication integration. This is mainly used in intranet setups.

Code changes to SP may be needed. Changing settings on the IIS webserver are certainly part of the setup.

MIssing Columns for XML Export Requiring Not Null

The survey export from both 2.3 and 2.1 does not include (vts_Survey) FolderId and DefaultSurvey in the exported XML. Both columns are defined as "not null" so the import into 2.3 fails. Saving a new survey also fails with the same error: Cannot insert the value NULL into column 'FolderId', table 'surveyproject.dbo.vts_tbSurvey'; column does not allow nulls. INSERT fails.

Add shared header for columns in matrix type question.

In the current matrix type question there is a column header text for each column. That would be nice to have a column shared header for the columns to describe the columns.

SP Localization and Translations

Main task for Localization and Translations project

• Maintain, edit and add the language files for SP
• Create language files for new languages

Slider AnswerType correction and completion

• ever since the introduction of the Slider Answertype it has not been fully functional and working correctly due to viewstate issues that needed correction

Expected:
viewstate corrected
fully working answertype

FeatReq: Confirmation on bulk user uploads

Background:
I had used a script to format most of my user data and didn't look at it super close (~100 users)
I opted to use the user's email address as their username for logging in.
Two of our users shared the same email, and therefore shared the same username.
The second of these users was not created, but no error message was given, the only way I knew any had failed was that I went to double check the number of rows added in the database.

Request:
Just as a simple feature, it would be nice to see "Of X attempted user uploads, Y were successful" or even just "X of Y successful" since the context of the user's action is fairly obvious.
I understand that wanting a bunch of feedback on a bulk upload can be a little silly, but totals would probably help a lot. I managed to find the missing user pretty quickly, but I thought this might be quick to implement and could help someone else in the future

Email Code protection - Only Invited Emails Can Participate not working correctly

SP v. 2.3

Current behaviour

• On adding the Email code protection security addin the checkbox "only invited emails can participate" is checked by default;
• the working of the option is explained in the helpfiles:
• Only Invited Emails Can Participate: option to open the survey to respondents who did not receive any invitation code.

If this option is activated respondents without code will be able to take the survey several times (if they receive the proper link) while respondent with the invitation code will only be able to submit their answers once.

Note: the helpfiles do not describe the current working correctly.

One side effect of having the checkbox checked is that the email addresses of respondents invited through the mailing menu are not registered on user level (set to anonymous instead). To have the email registered properly the "Only invitation" checkbox must be unchecked.

This is confusing/ counterintuitive and not correct.

Required Behaviour

• clear and consistant behaviour (to be defined yet)