Describe the bug

When a double quote is entered in a free text response, the Javascript to display the chart fails.

Software Versions

• DNN: xx.xx.xx
• Module: 09.00.01

To Reproduce

Steps to reproduce the behavior:

1. Add a free trext response to a survey
2. Add answers, use a double quote somewhere in the free text response
3. Show results
4. No charts are displayed

Expected behavior

Charts should display.

Error log

Javascript console:
Uncaught SyntaxError: Unexpected identifier

Additional context

Workaround: replace the double quotes in the database by single quotes

Hi,
is it possible, that some surveys where deleted when upgrade ?

Some users missing surveys they have created. Can't reproduce it.
Or exists an autodelete of old surveys?
DNN9.5.0
Regards,
Angelo

Describe the bug

The dependencies do net get resolved. As per our community standards, this should use Nuget to make sure everyone has them downloaded as needed and that it works in CI environments too.

To Reproduce

Steps to reproduce the behavior:

1. Clone repo
2. Open project
3. Try to build and notice errors

I want to give the title 'DNN Survey Results' a custom name (not the standard name), but that look impossible.
Am i missing something?

Describe the bug

The module currently has no build scripts.

Is your feature request related to a problem?

Feature
This is a copy of Issue 14464 form CodePlex.

Sort results when displayed
For simple dichotomous yes/no responses, 'view results' ordering is not a big issue; however, as you add more and more options/responses to each question, the results can get a bit ugly when not sorted in, say, descending order. The ability to apply sorting to the 'view results' display would add tremendous value to this project.

Describe the solution you'd like

Add an option to the question if results should be displayed by view order, alphabetically or number of votes.

Describe the bug

This is a copy of Issue 25051 form CodePlex.

Survey layout is askew
In DNN 7+ the width and height of survey color bars is equal (eg the height and width of color blocks is the same) and the resulting layout looks terrible. This is enhanced by the inability to set the width of results, as reported in other issues.

Describe the bug

Solution does not load because it is configured to use local IIS on a specific website url which contributors might not have. Also this would not work in CI

To Reproduce

Steps to reproduce the behavior:

1. Clone repository
2. Try to open solution

Expected behavior

Solution should open.

Screenshots

Describe the solution you'd like

Same as #7 but with multiple choice options per line.

Is your feature request related to a problem?

Feature
This is a copy of Issue 16565, 21105 and 24551 form CodePlex.

Cannot clear survey results with 1 Vote/Reg user
If I have 1 vote/registered user selected, and I use the Clear Results Data function (Clear)... it clears the results in the survey, but the user cannot vote again on the cleared survey.
Sometimes we like to change 1 question; or test the survey module... then the "test" user cannot vote.
SUMMARY: If the survey results are cleared, the user voting history should also be cleared.

Describe the bug

Fehler: ist zur Zeit nicht verfügbar. Die Eingabezeichenfolge hat das falsche Format
Error: is currently not available. The input string is in the wrong format

Software Versions

• DNN: 9.5.0
• Module: 9.0.1
• Chart.js v2.7.3/2.9.2

To Reproduce

Steps to reproduce the behavior:

1. add Question (wie ist das Wetter)
2. Click on '3 answer "geht so>Add answer" "naja>Add answer" und "mal schauen>Add answer"'
3. Scroll down to 'save'
4. See error
   Fehler: ist zur Zeit nicht verfügbar. DotNetNuke.Services.Exceptions.ModuleLoadException: Die Eingabezeichenfolge hat das falsche Format. ---> System.FormatException: Die Eingabezeichenfolge hat das falsche Format. bei System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) bei System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) bei DNN.Modules.Survey.SurveyEdit.UpdateButton_Click(Object sender, EventArgs e) --- Ende der internen Ausnahmestapelüberwachung ---

ModuleId:546
ModuleDefId:139
FriendlyName:
ModuleControlSource:DesktopModules/Survey/SurveyEdit.ascx
AbsoluteURL:/Default.aspx
DefaultDataProvider:DotNetNuke.Data.SqlDataProvider, DotNetNuke
ExceptionGUID:be0016de-76d9-4798-92c8-ce3064a00032
AssemblyVersion:9.5.0
PortalId:0
UserId:1
TabId:68
RawUrl:/links/test/ctl/edit/mid/546?popUp=true
Referrer:https://www.xyz.ch/links/test/ctl/edit/mid/546?popUp=true
UserAgent:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_4) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/13.1 Safari/605.1.15
ExceptionHash:Dyl3xZuvr1yaNbnRzC+hpPQtdlY=
Message:Die Eingabezeichenfolge hat das falsche Format.
StackTrace:
InnerMessage:Die Eingabezeichenfolge hat das falsche Format.
InnerStackTrace:
bei System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal)
bei System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info)
bei DNN.Modules.Survey.SurveyEdit.UpdateButton_Click(Object sender, EventArgs e)
Source:
FileName:
FileLineNumber:0
FileColumnNumber:0
Method:
Server Name: vps74

Additional context

Describe the bug

Module - Survey Settings Tab - "Show closing date message" and "Add consent checkbox?" check boxes are not saved correctly when the values are changed from checked to unchecked.

Software Versions

• DNN: 09.00.00
• Module: 09.00.00

To Reproduce

Steps to reproduce the behavior:

1. Go to Module Settings - Survey Settings Tab.
2. Check both "Show closing date message" and "Add consent checkbox?"
3. Update the Module
4. Go to Module Settings - Survey Settings Tab.
5. Uncheck both "Show closing date message" and "Add consent checkbox?"
6. Update the Module
7. See that the module still displays both items as if they were checked.

Expected behavior

Items should uncheck.

Solution:

Edit the file Settings.ascx.cs in the Project. Go to line 204. Replace TabModuleId with ModuleId as such:
ModuleController.Instance.DeleteModuleSetting(ModuleId, settingName);

Is your feature request related to a problem?

Feature
This is a copy of issue 14463 ad 14465 form CodePlex.

Add Option Display Types
Add Drop down menu and Rating Scale option types

and

Combo Box Options
Provide a feature to display single response options in a combo box versus a series of radio buttons.

Describe the solution you'd like

Add an additional answer type "Single choice (Dropdown list)"

Describe alternatives you've considered

Consider also adding a Dropdownlist with multiple options.

Is your feature request related to a problem?

Feature
This is a copy of Issue 24553 form CodePlex.

Mutliples survey by name
Hi, Is it a way to add (if i dont see it) a name field to have more than 1 survey in the db.
For exemple :

• Page 1 : Question about the services you want add into my catalog
• Page 2 : Question about customer satisfaction
  Regards
  Mike

Describe the solution you'd like

Structure a survey into multiple pages with headers for each page

Describe alternatives you've considered

Could be as well on one page, but add headers for different sections. Sections could be displayed in panels for better clarity.

Describe the bug

chart.js could be included with the module to simplify intallation and upgrades for people.

Describe the bug

We have a customer that has this module on their home page. Once a user submits their response for the survey, they can no longer view the home page as it will redirect them to the results page. I did a quick look through the code and I found that the module checks for a cookie and if the person has voted. If so, it directs the user to the results page. To make this work on home pages, this should really be a configuration setting whether to redirect users to the results page if they have voted.

Software Versions

• DNN: 9.6.2
• Module: 90.00.01

To Reproduce

Add Module to homepage of site
Add Question to Survey
Submit Vote for Survey
No longer able to access homepage.

Describe the bug

The 09.00.00 sql script causes errors when upgrading from latest version and prevents upgrading the module

Software Versions

• DNN: 08.00.04
• Module: 09.00.00

To Reproduce

Steps to reproduce the behavior:

1. Install Survey 04.70.01
2. Try to upgrade to Survey 09.00.00

Expected behavior

Upgrade should work fine

Screenshots

Additional context

I fixed some sql syntax on older scripts due to EVS warnings, but there are still some issues. @MaiklT can you try the steps above and take a look... I also added build scripts, so you can clone to either the DesktopModules folder of a site or in any location, building in release mode will produce the intaller in the Install subfolder.

Just in case, here is a build right now that has that issue.
Dnn.Modules.Survey_09.00.00_Install.zip

Sidenote, I referenced Dnn 8 dll versions and change only 1 procedure in the upgrade code so that will make the module Dnn 8 and 9 compatible.

Describe the bug

In the latest version 09.00.01 the result component is changed to ChartJS.
Unfortunately this component is pretty static and you can't change the Look and Feel.

In context of the WCAG we need the optimize/change the result graph.

Is there a way to change this with css/template?

Software Versions

• DNN: 9.6.x
• Module: 09.00.01

To Reproduce

Steps to reproduce the behavior:

1. Add the survey module on a page
2. Add the questions/results
3. Fill in the survey
4. Click on "View Results"
5. Show the Graph

Expected behavior

Results with block graphs like in the old module.
Option to style/change the resultgraph with css/template/?
Option to make the resultsgraph wcag compatible

Screenshots

This is the resultsview we like to have:

Describe the bug

Attempt to upgrade the existing module to the latest 9.1.0 release version results in SQL error.

Software Versions

• DNN: 09.08.01, recently upgraded from DNN 08.00.04
• New module version: 09.01.00
• Installed module version: 04.70.01

Expected behavior

Upgrading extension should proceed without issues.

Error log

Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904):
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_SurveyResults_Users".
The conflict occurred in database "copy-1.volgau.com", table "dbo.Users", column 'UserID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query)
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:2f77ed62-1597-458e-97b3-5e7cdfb07823
Error Number:547,State:0,Class:16 ALTER TABLE dbo.SurveyResults WITH CHECK ADD CONSTRAINT FK_SurveyResults_Users FOREIGN KEY (UserID) REFERENCES dbo.Users (UserID) ON DELETE SET NULL 

Additional context

The issue is caused by some installation-specific content in the database tables, namely UserIDs of non-existent (removed) users.

In my case, there are number of records in dbo.SurveyResults which reference non-existing UserID, which can be checked with this statement:

select * from dbo.SurveyResults where UserID <> -1 and UserID not in (select UserID from dbo.Users)

The issue is fixed (for me) by executing this statement prior to module upgrade:

delete from dbo.SurveyResults where UserID <> -1 and UserID not in (select UserID from dbo.Users)

StartJob Installatie starten
Info Installatie starten - DNN_Survey
Info Installatie starten - Config
Info Backup van vorige versie wordt gemaakt - web.config
Info Configuratie bestand bijgewerkt - web.config
Info Component succesvol geïnstalleerd - Config
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Cleanup
Info Component succesvol geïnstalleerd - Cleanup
Info Installatie starten - Script
Info Begin uitvoer Sql
Info Backup van vorige versie wordt gemaakt - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Aangemaakt - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider
Info Uitvoeren03.01.00.SqlDataProvider
Info Start uitvoer Sql: 03.01.00.SqlDataProvider bestand
Failure SQL uitvoer leverde de volgende uitzonderingen op: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.GetSurveys @ModuleID int as select SurveyID, Question, ViewOrder, OptionType, CreatedByUser, CreatedDate from Surveys where ModuleID = @ModuleID order by ViewOrder System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.GetSurvey @SurveyID int, @ModuleID int as select SurveyID, ModuleID, Question, ViewOrder, OptionType, Users.FirstName + ' ' + Users.LastName AS CreatedByUser, CreatedDate, ( select sum(Votes) from SurveyOptions where SurveyOptions.SurveyID = Surveys.SurveyID ) AS Votes from Surveys left outer join Users on Surveys.CreatedByUser = Users.UserID where SurveyID = @SurveyID and ModuleID = @ModuleID System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.AddSurvey @ModuleID int, @question nvarchar(500), @ViewOrder int, @OptionType char(1), @UserName nvarchar(100) as insert into Surveys ( ModuleID, Question, ViewOrder, OptionType, CreatedByUser, CreatedDate ) values ( @ModuleID, @question, @ViewOrder, @OptionType, @userName, getdate() ) select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'CreatedByUser'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:b972169e-a2e4-40c7-a150-637f3df90776 Error Number:207,State:1,Class:16 create procedure dbo.UpdateSurvey @SurveyID int, @question nvarchar(500), @ViewOrder int, @OptionType char(1), @UserName nvarchar(100) as update Surveys set Question = @question, ViewOrder = @ViewOrder, OptionType = @OptionType, CreatedByUser = @UserName, CreatedDate = getdate() where SurveyID = @SurveyID
Info Einde Sql uitvoer: 03.01.00.SqlDataProvider gereed
Info Sql uitvoer gereed
Failure Installatie mislukt - Script
Info Component installatie wordt ongedaan gemaakt - Config
Info Aanpassingen in configuratie bestand succesvol ongedaan gemaakt - web.config
Info Component installatie succesvol ongedaan gemaakt - Config
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Component installatie wordt ongedaan gemaakt - Cleanup
Info Component installatie succesvol ongedaan gemaakt - Cleanup
Info Installatie mislukt - DNN_Survey
Info Tijdelijke installatie map verwijderd
EndJob Installatie mislukt

In 2011, a thread in the DNN forums started about what should be added to the Survey module. There were some nice suggestions, but nothing has happened...

Therefore, I give it another try:

• Single choice grid with "from-to" selection
• Single choice grid with options in the header
• Multiple choice (checkboxes) grid with options in the header
• Free text answers, as well as single-line and multi-line textboxes
• Headings for different chapters
• Labels for explanations etc.
• Export of results to xlsx (or csv at least)
• (Not so important:) Improved templates and styling capabilities (themes)
• (Important, but propably not realistic): ML support
• Multi-page capabilities (one page after the other has to be answered)
• Tabbed surveys (user cab jump between pages as he wants)

See also DNN Forum

Describe the bug

There appears to be an issue with the SQL Providers when installing a new version of this module.

Software Versions

• DNN: 9.7.2
• Module: 09.01.00

To Reproduce

Steps to reproduce the behavior:

1. Attempt to install module for first time in an existing installation
2. Installation aborts with a SQL error

Expected behavior

Module should be installed ready for use on the installation

Screenshots

If applicable, add screenshots to help explain your problem.

Error log

Note: Debug DLL's
Please replace the current extension DLL's with the debug DLL's (if these are available with the release) and reproduce the error with the debug DLL's before pasting the error log.

Paste the error log that is related to this issue.
Install Package::DNN_Survey

Info::Starting Installation

Info::Starting Installation - DNN_Survey

Info::Starting Installation - Config

Info::Creating backup of previous version - web.config

Info::Config file updated - web.config

Info::Component installed successfully - Config

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Cleanup

Info::Component installed successfully - Cleanup

Info::Starting Installation - Script

Info::Begin Sql execution

Info::Folder Created - C:\VWC090404Edu\DesktopModules\Survey\Providers\DataProviders\SqlDataProvider

Info::Created - Providers\DataProviders\SqlDataProvider\03.01.00.SqlDataProvider

Info::Executing 03.01.00.SqlDataProvider

Info::Start Sql execution: 03.01.00.SqlDataProvider file

Info::SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Reference to database and/or server name in 'dbo.dbo.Surveys' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:e33cf65e-44e8-4841-8378-1be4f8a781f7 Error Number:40515,State:1,Class:15 create procedure dbo.GetSurvey @SurveyID int, @ModuleID int as select SurveyID, ModuleID, Question, ViewOrder, OptionType, dbo.Users.FirstName + ' ' + dbo.Users.LastName AS CreatedByUser, CreatedDate, ( select sum(Votes) from dbo.SurveyOptions where dbo.SurveyOptions.SurveyID = dbo.Surveys.SurveyID ) AS Votes from dbo.dbo.Surveys left outer join dbo.Users on dbo.Surveys.CreatedByUser = dbo.Users.UserID where SurveyID = @SurveyID and ModuleID = @ModuleID

Info::End Sql execution: 03.01.00.SqlDataProvider file

Info::Finished Sql execution

Info::Installation Failed - Script

Info::Rolling back component install - Config

Info::Config file changes rolled back - web.config

Info::Component rolled back successfully - Config

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Rolling back component install - Cleanup

Info::Component rolled back successfully - Cleanup

Info::Installation Failed - DNN_Survey

Info::Deleted temporary install folder

Info::Installation Failed

Server Name: HansPC

Additional context

Add any other context about the problem here.

Hi,
when i create a survey and would like to test it, i can't edit it after fill out, because i only see results and i have no chance to get on the survey form.

Describe the solution you'd like

It should be possible to export the survey results to xlsx or csv files.

The cake script had vendors in some places because it was copied and some changes where missed.

Describe the bug

This is a copy of Issue 24448 form CodePlex.

Can't Export Data
Hi,
When I export the data to excel all I get are the column headers. I don't get any data. How can I fix that?

Software Versions

• DNN: 06.02.07
• Module: 04.70.00

Is your feature request related to a problem?

Feature
This is a copy of Issue 14462 form CodePlex.

Previous Polls list and display
Visitors can click through to "Previous Polls/Surveys", where they can view a list of the expired surveys by name and click on them to view their final results. An example of such a list can be viewed here: http://www.monster.co.uk/polls/

Describe the solution you'd like

This could be a different module that archives old surveys.

Additional context

We have to think if this could be an option for a free module. The feature sounds more like something used for professional polls...

I have created a survey and want to display the free text answers in a donut chart.
When testing with 4 participants, a 'doughnut' graph was neatly displayed, but things go wrong with even more participants!
But the module does not show a graph but puts the texts one after the other. The last line is rendered corrupted!
Can i do something about this?

When you click on "view results" before there are any surveys submitted, you get a critical error message.

Not sure if that's a defect, or if I should ask for a feature of either displaying a message that there are no results yet, or disable button until there are results.

Starttext of a sentence not displayed (Horizontal Bar).
If you chosse for a 'Bar' chart the all answers shown together.
In short, whatever graph you choose, it doesn't look good!

Describe the solution you'd like

It should be possible to display a grid with single-coice answers in a certain answer range, e.g. very good - good - OK - bad - very bad.

Export Survey Result To Csv In Persian Show unusual character

• DNN: 09.06.01
• Module: 09.01.00

Steps to reproduce the behavior:

1. Add Survey with Answers in Persian Lag
2. Try To export Result To CSV

Survey_Results_1166_1400-02-27-022054.zip

Describe the solution you'd like

The Survey module only provides single-choice (radiobuttons) or multiple-choice answers. Free text answers (single- and multiple-line) should be addded.

Is your feature request related to a problem?

Feature
Add a setting for the separator and delimiter characters for the CSV export. In former versions this was always a comma and no delimiter, but that does not work when opening the CSV file in Excel (at least not in the German version?). It has been replaced by a semicolon and no delimiter in version 9.0.0, but maybe it's better to introduce a setting.

Describe the solution you'd like

Add two settings: Separator and Delimiter. Maybe it is better to provide options in a dropdownlist.

Describe alternatives you've considered

Maybe also add a setting for the encoding (ANSI or UTF-8)

Some sql scripts do not succeed due to deprecated syntax no longer supported in modern sql servers.

Describe the bug

An error occurs when submitting a survery that includes a free text option

Software Versions

• DNN: 08.00.04
• Module: 09.00.00

To Reproduce

Steps to reproduce the behavior:

1. Create a survey with a few single and multiple options questions
2. Add a free text option
3. Try to submit survey

Expected behavior

Survey should submit without errors

Screenshots

Error log

at System.Data.SqlClient.SqlBuffer.get_Boolean()
at System.Data.SqlClient.SqlDataReader.GetBoolean(Int32 i)
at petapoco_factory_0(IDataReader )
at PetaPoco.Database.d__21.MoveNext() at System.Collections.Generic.List1..ctor(IEnumerable1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable1 source)
at PetaPoco.Database.Fetch[T](String sql, Object[] args)
at DotNetNuke.Data.PetaPoco.PetaPocoDataContext.ExecuteQuery[T](CommandType type, String sql, Object[] args)
at DNN.Modules.Survey.Components.Controllers.SurveyResultsController.Get(Int32 surveyID) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\Components\Controllers\SurveyResultsController.cs:line 79
at DNN.Modules.Survey.SurveyResults.OnPreRender(EventArgs e) in D:\websites\vendors\DesktopModules\DNN.Survey\DNN.Survey\SurveyResults.ascx.cs:line 211
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Describe the solution you'd like

It should be possible to add labels etc. to provide further information to a question or something alike.

Describe the bug

The Event viewer reports the following error:
at DNN.Modules.Survey.Components.Controllers.SurveyBusinessController.UpgradeModule(String version) in \DesktopModules\DNN.Survey\DNN.Survey\Components\Controllers\SurveyBusinessController.cs:line 157
at DotNetNuke.Entities.Modules.EventMessageProcessor.UpgradeModule(EventMessage message)

Software Versions

• DNN: 08.00.04
• Module: 04.70.00 upgrading to 09.00.00

To Reproduce

Steps to reproduce the behavior:

1. Install a clean Dnn 8
2. Install Survey 04.70.00
3. Upgrade to Survey 09.00.00
4. Check the event log

Is your feature request related to a problem?

Feature
This is a copy of Issue 14466 form CodePlex.

Captcha
Add Captcha support to reduce robot voting.