This document contains the release notes for all releases of SelectSurveyASP Advanced. The notes for each release are listed in reverse chronological order, so that the notes for the most recent release are always listed at the top of this file. The notes for each release include the version number, the date of the release, a comprehensive list of all files affected, a list of databases changes (if any), and a detailed list of all changes to the code in each release.
A change in the first number in the version (for example, 6.1.0 increases to 7.0.0) indicates a very significant change in the application, including a significant amount of new functionality. Such changes often reflect a number of changes and additions to the data model. Despite all these changes to the data model, it may still be a relatively easy task to upgrade to the new version, but some change or changes will have to be made to the database.
You can upgrade to a new release in one of the two following ways:
1. You can simply install a new version of the application. If you have data in the older version, you can then copy your data or database over. If the release was a major one (first number changed, indicating database incompatability), you must refer to the release notes in this document and manually upgrade the database.
2. You can add the changed files to your current installation. Look in the release notes, see which files have changed since the release you are running, and copy over those files. If you have made custom modifications to your application, be careful when copying over files that you do not copy over any of your changes.
A WORD OF CAUTION: Whenever upgrading, especially if you are applying new files to an existing release, always make a backup copy of your database. Any new release could potentially contain bugs, and possibly, these bugs could lead to deleted or corrupted data in your database.
- Global change of semi-colon split delimiter to eliminate response text from breaking all reports and exports. File(s) affected: ResultsOverview.asp, Include/Collection_inc.asp
- Fixed email bug that gave error, "BOF or EOF is true" in file Include/SurveyEmail_inc.asp on line 124. File(s) affected: Include/SurveyEmail_inc.asp
- Fix bug for error, "Syntax error converting the nvarchar value 'SurveyAnswerTextNull' to a column of data type int" on ResultsOverview.asp if there is a numeric filter using a SQL database. File(s) affected: Include/SurveyReportFilter_inc.asp
- Fixed bug that occurred when trying to modify item when survey has responses. File(s) affected: Item.asp
- Fixed bug for download error on export page and also for error when browser would try to download the export file as a .ASP file. File(s) affected: Include/Top_inc.asp.
- Fixed a bug where images were not showing up in admin edit mode when using back/next buttons. File(s) affected: TakeSurvey.asp
- Fixed a bug for uppercase table name in code causing error in case-sensitive SQL installs. File(s) affected: ExportDataAction.asp
- Fix a bug that was sometimes causing duplicate questions to show up when using the back/next buttons while taking a survey. File(s) affected: CreateSurveyAction.asp, TakeSurvey.asp, TakeSurveyAction.asp, Include/SurveySecurity_inc.asp, Include/Utility_inc.asp
- Fixed several bugs related to European date/time issues. File(s) affected: Include/Utility_inc.asp, TakeSurvey.asp, TakeSurveyAction.asp
- Improved the way cache control works for downloading file from data export. File(s) affected: Include/Top_inc.asp
- Fixed SQL deadlock causing timeout when copying very large surveys with numerous subitems. File(s) affected: CreateSurveyAction.asp
- Improved SQL syntax to be compliant with additional versions of MySQL drivers. File(s) affected: ResultsIndividual.asp
- Added more error handling so that truncated URL's when taking a survey go to a friendly error page indicating that the survey ID was invalid instead of the to the error page. File(s) affected: Include/SurveySecurity_inc.asp, Include/Encryption_inc.asp
- Fixed a typo in the code. File(s) affected: InsertFromLibraryAction.asp
- Fixed a bug in the SendMailASPEMail, SendMailJMail, SendMailJMail4, and SendMailASPMail functions by adding a check for semicolon on end of string for single BCC address before array split. File(s) affected: Include/Email_inc.asp
- Fixed hidden fields loop starting at line 1408 of ExportDataAction.asp which was causing error on CSV export when including hidden fields that have empty responses. File(s) affected: ExportDataAction.asp
- Fixed issue where required part of javascript for Constant Sum question type not rendering. File(s) affected: TakeSurvey.asp
- Fixed a bug where the condition was failing on Not Equals on line 256. File(s) affected: Include/SurveyPageCondition_inc.asp
- Fixed a small bug for taking surveys on line 739. File(s) affected: TakeSurvey.asp
- Added additional option on export page to export email list email address in export data. File(s) affected: ExportData.asp, ExportDataAction.asp
- Separated SQL Server from MS Access in report filter for Constant Sum, Ranking, and Matrix Rating Scale question types to fix bug when filtering on text data. File(s) affected: Include/SurveyReportFilter_inc.asp
- Fixed several bugs related to templates and libraries owned by "Create" users. File(s) affected: LibraryList.asp, TemplateList.asp
- Fixed CLng() error if result is null or not a number, which would happen if browser validation was disabled and non-numeric data was entered. File(s) affected: Include/SurveyPageCondition_inc.asp
- Fixed an error that occurs when only 1 email address in database when looping through to send emails. File(s) updated: SendEmailMessageAction.asp
- Fixed a bug where it was possible to get two identical report share ID's because of the time-based encryption algorithm. File(s) affected: ReportShareAction.asp
- Fixed a bug where SQL for open-ended numeric question types comparisons on report filtering did not work. File(s) affected: Include/SurveyReportFilter_inc.asp,
- Added more export options (Email First Name and Email Last Name) which joins the email_address_table to export data. File(s) affected: ExportData.asp, ExportDataAction.asp
- Single response login required updateable fix to take survey query. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp, TakeSurveyActionComplete.asp, SurveyRendering_inc.asp
- Fixed a bug where on the overview report, skipped totals were incorrect when a user existed mid-way through a survey. File(s) affected: ResultsOverview.asp
- Fixed a bug with updating surveys with Access where the questions were not being ordered correctly.
- Fixed a bug that caused the wrong order of elements and an EOF error when editing a survey with presentation elements. File(s) affected: TakeSurvey.asp
- Fixed a bug in exporting matrix checkbox questions. File(s) affected: ExportDataAction.asp
- Fixed a bug with updating surveys to prevent against duplicate submissions for an updateable survey. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp, TakeSurveyError,asp, Include/Constants_inc.asp
- Improved the verbiage in the descriptions of the respondent access levels. File(s) affected: Survey.asp
- Fixed a bug with database drop downs that was causing edit button to not show up if the connection string was invalid. File(s) affected: Include/SurveyRendering_inc.asp
- Fixed a bug on taking surveys that was introduced in version 8.1.2 when fixing the issue with the "back" button. File(S) affected: TakeSurvey.asp, TakeSurveyAction.asp
- Fixed a critical bug introduced by a fix in the last release that caused some responses in some cases not to be saved when a survey was submitted. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp
- Fixed a bug in the code that prevents against SQL injections. File(s) affected: Include/Utility_inc.asp
- Fixed a bug that would cause invalid use of null page error when selecting a hidden field querystring filter for a report. File(S) affected: ReportFilterList.asp
- Reformatted several queries in the survey page that had subqueries, since subqueries do not work in all versions of MySQL. This change only impacts MySQL users. File(s) affected: TakeSurvey.asp
- Fixed a bug on the email addresses in a list where saving the active status when there were more email addresses than shown on the page at once would incorrectly change the status of email addresses not show. File(s) affected: EmailAddress.asp, EmailAddressAction.asp
- Fixed a bug in the database dropdown question where if a SQL statement did not return any records, an attempt was still made to close the recordset, which caused an error. File(s) affected: Include/SurveyRendering_inc.asp
- Fixed a small bug in the data export routine where a time value was incorrectly being formatted as a date. File(S) affected: ExportDataAction.asp
- Fixed a bug on taking surveys that would happen when clicking the "Back" button at the bottom of the survey page in the order of 'back - back - next' which would cause multiple responses to be recorded in the database for that responseID. This also caused reports to show incorrect number of respondents for questions with multiple responses. File(S) affected: TakeSurvey.asp, TakeSurveyAction.asp, Include/Top_inc.asp
- Fixed a bug that occurred when bulk deleting users from the main list of users. The bug was that the entry in the user to role mapping table was not being deleted. File(s) affected: UserListAction.asp
- Fixed a bug in user registration where a logged in user returning to register a second account had incorrect permissions. File(s) affected: User.asp
- Fixed a bug in user registration where an adminstrator could incorrectly create a second user with the username "admin". File(s) affected: User.asp
- Fixed a bug that affected the software with version of MySQL greater than 4.0. The but was that any query count selected in a query using count(*) was coming back as non-numeric data. File(s) affected: Include/SurveyUtility_inc.asp, Include/SurveySecurity_inc.asp, Include/SurveyPageCondition_inc.asp, MoveItemAction.asp, ItemAction.asp, Item.asp, InsertFromLibraryAction.asp, ImportUsersAction.asp, EmailMessageList.asp, EmailMessageDetails.asp, EmailListList.asp, EmailList.asp, EmailAddressList.asp, DeleteResponse.asp, DeletePage.asp, DeleteItem.asp, DeleteEmailAddress.asp, CreateSurveyAction.asp, CreateEmailListAction.asp, CopyPage.asp, CopyItemAction.asp, User.asp, TakeSurvey.asp, SurveyList.asp, Survey.asp, SendEmailMessage1.asp, ResultsOverview.asp, ReportFilterList.asp
- Fixed a bug in the survey options page where date comparisons with European dates was not working. File(s) affected: Survey.asp, Include/Config_inc.asp
- Fixed a bug where the routine that cleaned out extraneous pipes assumed a three-digit item ID, which created errors once the ID's hit 4 digits. File(s) affected: Include/SurveyUtility_inc.asp
- Fixed a bug in the overview report where the size of the bars was rendering incorrectly for ranking questions. File(s) affected: ResultsOverview.asp
- Fixed a bug where default answers were not being applied correctly for some question types. File(s) affected: Include/SurveyRendering_inc.asp
- Added code to prevent against SQL injections. File(s) affected: Include/Utility_inc.asp
- Fixed a bug where if a user accessed the export data page via a report share, and then clicked "Cancel", they lost the ability to view the share. File(s) affected: ExportData.asp
- Added functionality so that there is now a checkbox before each user on the main list of users that can be used to bulk delete the users. File(s) affected: UserList.asp, UserListAction.asp
- Fixed a bug where the totals per row in a matrix checkbox question were not always correct. File(s) affected: ResultsOverview.asp
- Added functionality so that default values can be supplied in the querystring and used to prepopulate answers to questions. This features applies to the following question types: Number, Date, Yes/No, True/False, Comments, and Open-Ended One Line. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp, Include/SurveyRendering_inc.asp
- Fixed a bug where moving a page in a survey with more than 10 pages was not working because of a casting issue where the page numbers were being treated as strings instead of as numbers. File(s) affected: MovePageAction.asp
- Fixed a bug in the sending of emails where carriage returns were being replaced by <br> tags in HTML emails. File(s) affected: SendEmailMessageAction.asp
- Fixed a bug where the time completed in the User Responses format for data export was being rendered as a date instead of as the time. File(s) affected: ExportDataAction.asp
- Fixed a bug in the export data routine where if username was selected for SPSS format, the "Username" column was displayed twice. File(s) affected: ExportDataAction.asp
- Updated the SQL Server and MySQL database files to use all lowercase letters for table and column names. The entire application uses lowercase, so with this change, the software can easily run on a case-sensitive database. File(s) affected: SQL Server and MySQL database scripts
- Fixed an issue where a SQL "IN" clause was not working correctly with MySQL version 4.x. File(s) affected: Include/SurveyRendering_inc.asp
- Fixed a bug that ocurred only when sending out a survey using the email list functionality, and the respondent access level was set to anonymous access, multiple responses. When a user tried to respond a second time, they incorrectly were getting a message saying that they could not respond again. File(s) affected: TakeSurvey.asp
- Fixed a bug that occurred only when trying to send a follow-up message with filtering in a situation where no email addresses matched the filter criteria specified. File(s) affected: SendEmailMessageAction.asp
1. Added a new column called HIDDEN_FIELD_ID to the SUR_REPORT_FILTER table. Sequentially, this column goes just after the END_DATE column. The column is of type Number (Access) or int (SQL Server) and is not required.
CODE CHANGES AND ADDITIONS
- Added new functionality that allows a user to filter on hidden fields. File(s) affected: ReportFilterList.asp, ReportFilterListAction.asp, Include/Constants_inc.asp, Include/SurveyReportFilter_inc.asp, [DATABASE CHANGES]
- Modified the data export routine to fix a few small bugs. File(s) affected: ExportDataAction.asp
- Fixed a bug where a SQL statement was failing when using MySQL and trying to render matrix questions. File(s) affected: Include/SurveyRendering_inc.asp
- Fixed a bug that occurred in a survey that had no answerable questions on the first page, and where the security level was set to Login Require (Not Updateable). The bug was that the user could not get past the first page. File(s) affected: TakeSurvey.asp
- Fixed a bug in the results overview report where navigating to the detailed text answer page did not work if there was a character that needs encoding in the sub item text. File(s) affected: ResultsOverview.asp
- Fixed a bug in the results overview report where navigating to the results sharing page did not work if there was a character that needs encoding in the survey title. File(s) affected: ResultsOverview.asp
- Fixed a bug where a sub-function was being called incorrectly. File(s) affected: Include/SurveyRendering_inc.asp
- Improved the way the pagination is displayed on the individual results report. File(s) affected: ResultsIndividual.asp
- Fixed a bug in the data export routine that occurred when hidden fields were selected and more than one survey used the same value for the a hidden field. File(s) affected: ExportDataAction.asp
- Fixed a bug where the row text was not displayed for all question types in the data export. File(s) affected: ExportDataAction.asp
- Added a new JavaScript routine called IsFirstDateEarlierEuropean to fix a bug where client-side date comparisons in European date environments was not wokring correctly. File(s) affected: TakeSurvey.asp, ClientInclude/Utility.js, Include/Utility_inc.asp
- Fixed a bug where, when moving an item, the pages from all other surveys where showing up in the list of pages. File(s) affected: MoveItem.asp
- Fixed a bug that occurred when an email was sent out, a user responded, and then the response was deleted. When the owner for the survey viewed the message history, there was a link to the already-deleted survey response, which would cause an error when clicked. The link is now replaced with the word "Deleted" if the response has been deleted. File(s) affected: EmailMessageDetails.asp
- Fixed a bug where on the message history details of an email with more than 50 recipients, the back button did not work when paginating past the first page. File(s) affected: EmailMessageDetails.asp
- Added support for JMail version 4.0 and above. File(s) affected: Include/Email_inc.asp, Include/Constants_inc.asp, Include/Config_inc.asp
- Fixed a bug where if a response was taken via an email invitation, and then the email address was deleted, an error occurred on the individual results report. The code now checks to see if the email address was first deleted. File(s) affected: ResultsIndividual.asp
- Fixed a bug where updateable surveys being taken through an email invitation could not be accessed through the email link for an update. File(s) affected: TakeSurvey.asp
- Fixed a bug where the number of subitems was being counted incorrectly if there were trailing carriage returns in the list of subitems. File(s) affected: ItemAction.asp
- Fixed a bug where inserting a new page above at least one existing page, and then inserting the first item by either copying an existing question or inserting from a survey, caused the page attributes to be thrown off. File(s) affected: CopyItemAction.asp
- Fixed a bug when creating a user where a one-character username did not work because the functionality checking existing users was using the wrong format. File(s) affected: User.asp
- Fixed a bug where deleting an email list was not deleting the email history from the SUR_EMAIL_MESSAGE and SUR_EMAIL_SENT_HISTORY tables. File(s) affected: DeleteEmailList.asp
- Fixed a bug where a survey with no answerable questions, when responded to via an email invitation, was not updating the email invitation history to indicate that the survey had already been responded to. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp
- Fixed a bug where if a report share was sent out, and then later deleted, the application threw an error if a user than tried to access the report share. File(s) affected: AccessDenied.asp, Include/Constants_inc.asp, Include/ReportShare_inc.asp
- Fixed a bug that occurred when taking a single response, login required, updateable survey for the second time when the same user had already responded to another survey. The bug was that the software couldn't find the previous response. File(s) affected: TakeSurvey.asp
NEW FILES: Documentation/Manuals/SelectSurveyASPDatabaseModel.pdf, Documentation/Manuals/SelectSurveyASPDeveloperManual.pdf, Documentation/Manuals/SelectSurveyASPUserManual.pdf, Documentation/Manuals/SelectSurveyASPAdvancedButtonSources.zip
CODE CHANGES AND ADDITIONS
- Added the data model, user's guide, developer's guide, and button source files to the Documentation/Manuals folder.
- Fixed a bug where, when inserting an item into a library by copying an existing item, and then clicking on the Cancel button, produced an error. File(s) affected: CopyItem.asp
- Fixed a bug in the query for displaying the list of pages for moving a page within a survey. File(s) affected: MovePage.asp
- Modified the data export routine to fix a few small bugs. File(s) affected: ExportDataAction.asp
- Removed a few constants from the constants file that were no longer being used. File(s) affected: Include/Constants_inc.asp
- Improved the default ordering for how email lists are displayed. File(s) affected: EmailListList.asp
- Fixed a bug where the decline and responded status were transposed for sending follow-up email messages. File(s) affected: SendFollowUpMessageAction.asp
- Fixed a bug where refreshing the report filter list page when logged in as a "Create" user was not working correctly. File(s) affected: ReportFilterList.asp
- Fixed a bug in the libraries where the library page was not displaying correctly if it contained an HTML question. File(s) affected: InsertFromLibrary.asp
- Fixed a small bug in the way survey responses were sent out upon survey completion. File(s) affected: TakeSurveyActionComplete.asp
- Fixed a bug in the survey error page where the page was not being displayed correctly for owners who are not admin's and when then survey was not live. File(s) affected: TakeSurveyError.asp
- Fixed a bug in in the main reports page where the link to each individual results report was going to the wrong result. File(s) affected: Reports.asp
- Fixed a bug where the "Move Page" button was being displayed when there was only one page in the survey. File(s) affected: ModifySurvey.asp
- Fixed a bug where a survey in Manual Response Entry mode with no answerable questions on the first page would not advance to the second page in the survey. File(s) affected: TakeSurvey.asp
- Fixed a small bug where selecting from a predefined group of answers that did not have at least five answers caused an error. File(s) affected: Item.asp
- Fixed a bug that occurred in a survey with no answerable questions on the first page when the user went to the second page, and the clicked the Back button to get to the first page. File(s) affected: TakeSurvey.asp
- For redirects upon survey completion, added code that checks for http or https at the beginning of the URL. If it's missing, the http or https prefix is added. File(s) affected: TakeSurveyActionComplete.asp
NEW FILES: TakeSurveyError.asp, Resources/SurveyButtons/Ok.gif
DATABASE CHANGES: None.
CODE CHANGES AND ADDITIONS
- Fixed a bug in the functionality for copying a page. This bug only came up with a few question types. File(s) affected: CopyPage.asp
- Fixed a bug where double quotes were not showing up correctly in edit mode for answers to questions. File(s) affected: Item.asp
- Improved the formatting for how multi-page surveys with responses are displayed in design mode. File(s) affected: ModifySurvey.asp
- Fixed a bug that occurred if inserting a question from a survey, and the user selected a different survey, and then clicked Cancel. This caused the user to return to the wrong survey. File(s) affected: CopyItem.asp
- Added code that ensures that when a survey is opened, the closed_date field is set to Null. File(s) affected: ChangeStatus.asp
- Fixed a bug where updating a library was saving the Public field incorrectly. File(s) affected: LibraryAction.asp
- Fixed a bug where the single quotes in email list names were not being handled correctly by the client-side JavaScript. File(s) affected: EmailAddress.asp, EmailAddressList.asp
- Fixed a small bug that caused template footers with <table> tags to be displayed incorrectly in surveys. File(s) affected: TakeSurvey.asp
- Improved the overall formatting of all templates, and applied template functionality to the error page that pops up if a survey cannot be taken. In so doing, separated the error page for the application from the error page for templates. File(s) affected: TakeSurvey.asp, TakeSurveyActionComplete.asp, AccessDenied.asp, TakeSurveyError.asp (new), Resources/SurveyButtons/Ok.gif (new)
- Fixed a bug where the survey ID was not being correctly encrypted for manual entry mode surveys. File(s) affected: TakeSurveyActionComplete.asp
- Improved the formatting for the individual results report. File(s) affected: ResultsIndividual.asp
- Fixed a bug in report sharing and improved the navigation between pages within a report share. File(s) affected: ResultsOverview.asp, ResultsIndividual.asp, Include/Constants_inc.asp, ExportData.asp, AccessDenied.asp
- Fixed a bug that prevented a user from getting to a survey through a web page link if the survey requires a login. File(s) affected: TakeSurvey.asp
- Fixed a bug with missing include file references. File(s) affected: ReportFilterList.asp, ReportFilterListAction.asp
- Improved the formatting of the data on the page. File(s) affected: SendReportShareMessageAction.asp
- Fixed a bug in the encryption routine for survey ID's that was failing if the seconds or minutes happened to be 0 at the time of encryption. File(s) affected: Include/Encryption_inc.asp
- Fixed a bug in managing user accounts. File(s) affected: User.asp, Include/AppHeader_inc.asp
- Improved the state management of the default page. File(s) affected: Default.asp
- Improved the column alignment on the main list of surveys to allow more space for the title to be displayed. File(s) affected: SurveyList.asp
- Modified the maxlength attribute on the Title field to limit input to 50 characters. File(s) affected: Survey.asp
- Modified how the JavaScript is generated for constant sum questions to fix a bug where non-required questions were requiring input. File(s) affected: TakeSurvey.asp
- Modifed the SQL script for creating the SQL script to change the value of all columns ending in _YN to be char(1). File(s) affected: Documentation/SQLScripts/SelectSurveyASPTables.sql
Version 8.0.0 (Released on 1/27/2004)
UPDATED FILES: All files in the application have been updated.
2. Increased the length of the ANSWER_TEXT column in the SUR_ITEM_ANSWER table from 125 to 255 characters.
3. Increased the length of the ANSWER_TEXT column in the SUR_PAGE_CONDITION table from 125 to 255 characters.
4. Increased the length of the ANSWER_TEXT column in the SUR_REPORT_FILTER table from 125 to 255 characters.
5. Added a few additional primary keys, as well as a number of indexes, to the SQL Server script.
6. Added a new table called SUR_REPORT_SHARE.
7. Added a new entry in the SUR_ID_GENERATION table with the NEXT_AVAILABLE_ID set to 100 and the NAME column set to SurveyGenerationReportShare.
8. Added a new column called REPORT_SHARING_ENABLED_YN to the SUR_SURVEY table. Sequentially, this column goes just after the STATUS column. The column is of type Text (Access) or char (SQL Server), is 1 character long, and is required. If upgrading, the default value for all existing surveys should be set to N.
9. Added a new entry in the SUR_ID_GENERATION table with the NEXT_AVAILABLE_ID set to 100 and the NAME column set to SurveyGenerationIPAddress.
10. Added a new table called SUR_IP_ADDRESS.
11. Added two new columns to the SUR_ITEM table. Sequentially, these two columns go just after the OTHER_TEXT column. The two columns, in order, are called OTHER_DISPLAY_TYPE and MAXIMUM_LENGTH. The OTHER_DISPLAY_TYPE column is of type varchar (SQL Server) or Text (Access), 10 characters long, and is not required. The MAXIMUM_LENGTH column is of type int (SQL Server) or Number (Access) and is not required.
12. Added three new columns to the SUR_SURVEY table. Sequentially, these three columns go just after the SURVEY_COMPLETE_REDIRECT_URL column. The three columns, in order, are called SURVEY_COMPLETE_DISPLAY_CLOSE, SURVEY_COMPLETE_DISPLAY_CONTINUE, and SURVEY_COMPLETE_DISPLAY_REPORTS. All three columns are of type char (SQL Server) or Text (Access), are 1 character long, and are required. If upgrading, the values for all three columns must be either "N" (not to display the button) or "Y" (to display the button). Any surveys that have either "Display Message with Continue Button" or "Display Message with View Reports Button" in the COMPLETION_ACTION column should be changed to "Display Message Only". For surveys that were set to "Display Message with Continue Button", set the value of the SURVEY_COMPLETE_DISPLAY_CONTINUE button to "Y". For surveys that were set to "Display Message with View Reports Button", set the value of the SURVEY_COMPLETE_DISPLAY_REPORTS button to "Y". For all other values in the COMPLETION_ACTION column, you can set the three buttons to be displayed or not displayed, as desired. All surveys with a value of "Display Message Only" in the COMPLETION_ACTION column should be changed to "Display Message".
13. Added a new table called SUR_LIBRARY_TO_ITEM_MAPPING.
14. Added a new table called SUR_LIBRARY.
15. Added a new entry in the SUR_ID_GENERATION table with the NEXT_AVAILABLE_ID set to 100 and the NAME column set to SurveyGenerationLibrary.
16. Added a new column called ROW_TEXT_WIDTH to the SUR_ITEM table. Sequentially, this column goes just after the MAXIMUM_NUMBER_RESPONSES column. The column is of type Number (Access) or int (SQL Server) and is not required.
17. Removed the columns ALLOW_EDIT_YN and ALLOW_COPY_YN from the SUR_TEMPLATE table.
18. Added four new columns to the SUR_TEMPLATE table. The first column, called MATRIX_HEADER_COLOR, goes just before the MATRIX_FIRST_COLOR column. This column is of type Text (Access) or varchar (SQL Server), is 7 characters long, and is not required. The second column, called SURVEY_ALIGNMENT, goes just after the LOGO_ALIGNMENT column. This column is of type Text (Access) or varchar (SQL Server), is 10 characters long, and is not required. The last two columns are called HTML_TOP and HTML_BOTTOM. Sequentially, these two columns go, in that order, just after the NAVIGATION_LINK_FONT_FAMILY column. Both fields are of type Memo (Access) or text (SQL Server) and are not required.
CODE CHANGES AND ADDITIONS
- Added libraries, which are sets of questions that a user can create and then insert into any survey. File(s) affected: Include/AppHeader_inc.asp, LibraryList.asp (new), Library.asp (new), LibraryAction.asp (new), InsertFromLibrary.asp (new), Item.asp, ItemAction.asp, DeleteLibrary.asp (new), Include/Constants_inc.asp, AccessDenied.asp, Resources/Buttons/CreateNewLibrary.gif (new), Include/SurveySecurity_inc.asp, ModifyLibrary.asp (new), Item.asp, ItemAction.asp, CopyItem.asp, CopyItemAction.asp, ReorderItem.asp, DeleteItem.asp, Resources/Buttons/InsertFromLibrarySmall.gif (new), [DATABASE CHANGES]
- Changed many of the tables in the application so that the columns are sortable by clicking on the column headings. File(s) affected: Include/Constants_inc.asp, Resources/StyleSheet/SurveyStyle.css, SurveyList.asp, Reports.asp, UserList.asp, TemplateList.asp, TemplateList.asp, EmailListList.asp, EmailMessageList.asp, EmailAddressList.asp, EmailMessageDetails.asp, SortArrowDown.gif (removed), SortArrowUp.gif (removed)
- Added three new pieces of functionality to templates. The first is the ability to specify the heading color for matrix questions. The second is the ability to specify how the survey is aligned in the page (left, center, or right). The third is the ability to provide, if desired, raw HTML for the top and bottom of the survey. File(s) affected: PreviewTemplate.asp, Template.asp, TemplateAction.asp, TakeSurvey.asp, TakeSurveyAction.asp, Include/SurveyRendering_inc.asp, Include/Constants_inc.asp
- Added functionality for moving items to any other location within a survey. File(s) affected: ModifySurvey.asp, Include/Constants_inc.asp, MoveItem.asp (new), MoveItemAction.asp (new), Resources/Buttons/MoveSmall.gif (new), Resources/Buttons/Move.gif (new)
- Added functionality for moving pages to any other location within a survey. File(s) affected: ModifySurvey.asp, Include/Constants_inc.asp, MovePage.asp (new), MovePageAction.asp (new), Resources/Buttons/MovePageSmall.gif (new)
- Added an option so that when "other" is selected for radio buttons or checkboxes, the user can use either a textbox or a textarea to capture the response. File(s) affected: Item.asp, ItemAction.asp, Include/Constants_inc.asp, Include/SurveyRendering_inc.asp, TakeSurvey.asp, ModifySurvey.asp, CopyItemAction.asp, [DATABASE CHANGES]
- Added an option for text questions to set the maximum number of characters that can be inputted. File(s) affected: Item.asp, ItemAction.asp, Include/Constants_inc.asp, Include/SurveyRendering_inc.asp, TakeSurvey.asp, ModifySurvey.asp, CopyItemAction.asp, [DATABASE CHANGES]
- Fixed a bug in the Reports home page where surveys with report security not set to the highest level were not being displayed in the dropdown to users with "Create" permission. File(s) affected: Report.asp
- Added the ability under the completion actions section to optionally display each of the Continue, Close, and View Reports buttons, independent of each other. With this change, the completion actions dropdown now has four values instead of six. File(s) affected: Survey.asp, SurveyAction.asp, CreateSurveyAction.asp, Include/Config_inc.asp, TakeSurveyActionComplete.asp, CreatesurveyAction.asp, [DATABASE CHANGES]
- Added functionality to that a use can set the width of the row text for matrix, constant sum, ranking, and open-ended more than one line questions. This fetaure grants the user more control over how these questions are rendered. File(s) affected: CopyItemAction.asp, CopyPage.asp, CreateSurveyAction.asp, InsertFromLibraryAction.asp, Item.asp, ItemAction.asp, ModifyLibrary.asp, ModifySurvey.asp, TakeSurvey.asp, Include\SurveyRendering_inc.asp, Include/Constants_inc.asp, [DATABASE CHANGES]
- Added IP range validation for taking surveys. File(s) affected: Include/Constants_inc.asp, IPAddressList.asp (new), IPAddressListAction.asp (new), Survey.asp, ClientInclude/Utility.js, Resources/Buttons/InsertIPAddresses.gif (new), TakeSurvey.asp, AccessDenied.asp, Include/SurveyUtility_inc.asp
- Fixed a bug in the user page where an admin updating his/her own account was receiving an error during the update. File(s) affected: User.asp
- Fixed a bug where an item with an "other" choice, when copied, was not including the "other" prompt in the new question. File(s) affected: CopyItem.asp
- Added a "Top" option for logo alignment on templates. The "Top" alignment places the logo above the survey title rather than next to it.
- Removed the functionality from templates that allowed each template to be granted public copy and and edit permissions. Most users found this functionality to be confusing and of little use. File(s) affected: Template.asp, TemplateAction.asp, TemplateList.asp, CreateTemplate.asp, CreateTemplateAction.asp, [DATABASE CHANGES]
- Added functionality for sending follow-up emails to recipients of an email message. This functionality allows the user to specify one or more response statuses, and then sends emails to all users with those statuses. File(s) affected: EmailMessageList.asp, SendFollowUpMessage1.asp (new), SendFollowUpMessage2.asp (new), SendFollowUpMessageAction.asp (new), Include/Constants_inc.asp, AccessDenied.asp
- Fixed a bug on the overview and individual reports where the note indicating the number of filters incorrectly included inactive filters. File(s) affected: Include/SurveyUtility_inc.asp
- Fixed a bug in the JMail email component code. File(s) affected: Include/Email_inc.asp
- Added code to the login functionality that clears the session for new logins. File(s) affected: LoginAction.asp
- Modified the functionality for creating a new email list from scratch so that as soon as the email list is created, the user is redirected to the page for importing email addresses. File(s) affected: CreateEmailListAction.asp
- Fixed a bug in the email invitations that was allowing a user to respond to a single email invitation more than once. File(s) affected: TakeSurvey.asp, Include/Constants_inc.asp, AccessDenied.asp
- Added a separate subfolder, called SurveyButtons, that contains the buttons that are used in the surveys themselves. The reason for this is that the buttons for the new look and feel are appropriate for the application, but not for all templates use for surveys. The buttons in the SurveyButtons folder are simpler and more generic, and can be used with most, if not all, survey templates.
- Fixed a bug that was causing some piped values not to be displayed correctly. File(s) affected: Include/SurveyRendering_inc.asp
- Modified the functionality for copying an item so that after copying an item, the focus on the main modify survey page is set to the new item. File(s) affected: CopyItemAction.asp
- Changed the way cookies work so that information about when a survey was taken is stored in a cookie with no expiration, and login information is stored in a temporary cookie. File(s) affected: Login.asp, LoginAction.asp, User.asp, Logout.asp, Include/CurrentUser_inc.asp, Include/Constants_inc.asp
- Fixed a bug with a missing style for headings when taking a survey. File(s) affected: TakeSurvey.asp, Include/SurveyRendering_inc.asp
- Encrypted the survey ID when taking a survey to provide an added layer of security. File(s) affected: ChangeStatus.asp, Deploy.asp, ModifySurvey.asp, ResultsIndividual.asp, SurveyList.asp, TakeSurvey.asp, TakeSurveyAction.asp, TakeSurveyActionComplete.asp, User.asp
- Fixed a bug that occured whenever the last item was deleted from a page with only one item on it. File(s) affected: DeleteItem.asp
- Fixed a bug in page conditions that occurred when a page condition was based on a question that was not displayed to the user because it was on a page that was not displayed due to another page condition. File(s) affected: Include/SurveyPageCondition_inc.asp
- Fixed a bug where email addresses ending in .info were being returned as invalid because the code limited the last section to three characters. The code now allows for 4 characters. File(s) affected: Include/Utility_inc.asp
- Improved the encryption routine so that it only produces numbers and letters, with no special characters. This was necessary because of the odd case where it could produce a closing and ending HTML brace, with text in between (such as <werw>), which would be interpreted as an HTML tag. File(s) affected: Include/Encryption_inc.asp
- Added default first and second colors for the progress bar. If either of these is omitted in the template, there is now a default set in the code. File(s) affected: Include/Constants_inc.asp, TakeSurvey.asp
- Changed the answer alignment attribute for questions so that horizontal appears before vertical (alphabetical order), and so that vertical is now the default (for better formatting by default). File(s) affected: Item.asp
- Fixed a small bug in report filtering for Yes/No questions. File(s) affected: Include/ReportFilter_inc.asp
- Added the ability to copy items from another survey owned by the current user. File(s) affected: CopyItem.asp, CopyItemAction.asp, Item.asp
- Added functionality to the main survey list page so that if a user tries to access it who is not logged in, they are redirected to the login page rather than the access denied page. File(s) affected: SurveyList.asp
- Fixed a small bug where when the item page was refreshed after selecting a new item type, the point values just entered were not preserved. File(s) affected: Item.asp
- Changed the way predefined answers and columns are inputted. Previously, there was an input control to enter the number of items. Now, instead, there is simply a button that can be clicked to enter an additional item. File(s) affected: Item.asp, Resources/Buttons/InsertNewAnswerSmall.gif (new), Resources/Buttons/InsertNewColumnSmall.gif (new)
- Added new functionality for each survey to have the abilit not to display any question numbers. File(s) affected: Survey.asp, ModifySurvey.asp, Include/Constants_inc.asp, Include/SurveyRendering_inc.asp
- Added new functionality so that for question with predefined sets of answers the user can select from a set of answer groups to prepopulate the list of choices. File(s) affected: Item.asp, Include/Constants_inc.asp, [DATABASE CHANGES]
- Fixed a bug that occurred when displaying hidden fields was not selected and there are no hidden fields associated with the survey. File(s) affected: ExportDataAction.asp
- Fixed a bug in the client-side JavaScript routine isValidEmailAddress(). The routine was limiting the domain extensions to three characters, but now with the new .name and .info domain extensions, four characters is needed. File(s) affected: ClientInclude/Utility.js
- Fixed a bug when querying the existing results for updating a survey for an anonymous user. File(s) affected: TakeSurvey.asp
- Fixed a bug in the client-side validation for importing users. File(s) affected: ImportUsers.asp
- Fixed a bug where a missing space in a combo input control was causing the wrong value to be saved to the database. File(s) affected: Survey.asp
- Fixed a bug in the reporting where carriage returns entered in a response were not being correctly formatted when displayed on the reports. File(s) affected: ResultsText.asp, ResultsIndividual.asp
- Fixed a bug where the manual response entry mode was not working correctly for surveys with more than one page. File(s) affected: TakeSurvey.asp
- Added new functionality so that after copying a page in a survey, the focus is immediately set to the start of the new page. File(s) affected: CopyPage.asp
- Improved the formatting of the progress bar when taking a survey. File(s) affected: TakeSurvey.asp
1. Added two new columns to the SUR_TEMPLATE table. Sequentially, these two columns go just after the MATRIX_SECOND_COLOR column. The two columns, in order, are called PROGRESS_FIRST_COLOR and PROGRESS_SECOND_COLOR. Both are of type varchar (SQL Server) or Text (Access), 7 characters long, and are not required.
2. Changed the data type of the ITEM_SUB_TEXT column in the SUR_ITEM table to Memo (Access) or text (SQL Server).
3. Added a new column called HIGHLIGHT_RESPONSES_YN to the SUR_SURVEY table. Sequentially, this column goes just after the REPORT_SECURITY column. The column is of type Text (Access) or char (SQL Server), is 1 character long, and is required. If upgrading, the default value for all existing surveys should be set to N.
CODE CHANGES AND ADDITIONS
- Added a new respondent access level called "Manual Response Entry." This mode allows an adminstrator or survey owner to manually enter responses to a survey. File(s) affected: Include/Constants_inc.asp, TakeSurvey.asp, TakeSurveyAction.asp, ResultsIndividual.asp, AccessDenied.asp, TakeSurveyActionComplete.asp, Survey.asp, Include/SurveySecurity_inc.asp
- Added functionality to highlight a user's responses on the overview report. File(s) affected: Survey.asp, SurveyAction.asp, CreateSurveyAction.asp, Resources/Images/Star.gif (new), ResultsOverview.asp, Include/Constants_inc.asp
- Added an option so that the Cancel button can not be displayed on the survey. File(s) affected: Include/Constants_inc.asp, Survey.asp, TakeSurvey.asp
- Added a progress bar option to each survey. File(s) affected: TakeSurvey.asp, Template.asp, TemplateAction.asp, PreviewTemplate.asp, Include/Constants_inc.asp, CreateTemplateAction.asp, [DATABASE CHANGES]
- Fixed a small bug in the database dropdown question type. File(s) affected: PageCondition.asp, Include/SurveyReportFilter_inc.asp, Include/SurveyRendering_inc.asp
- Fixed a bug where Yes/No questions were not filtering correctly. File(s) affected: Include/SurveyReportFilter_inc.asp
- Fixed a bug that was preventing existing surveys from being copied correctly. File(s) affected: CreateSurveyAction.asp
- Fixed a bug that was affecting survey creation on surveys using European dates. File(s) affected: SurveyCreationAction.asp
- Fixed a bug around how pages are copied. File(s) affected: CopyPage.asp
- Fixed a bug that resulted when an item was deleted from a page that only had a single item on it. File(s) affected: DeleteItem.asp
- Fixed a bug with recording responses correctly that occured when a user clicked the back button at least two times in a survey. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp, TakeSurveyActionComplete.asp, Include/Constants_inc.asp
- Fixed an unterminated string error. File(s) affected: ExportDataAction.asp
- Fixed a few small bugs related to the new database dropdown functionality. File(s) affected: Item.asp, PageCondition.asp, Include/SurveyReportFilter_inc.asp, Include/SurveyRendering_inc.asp
- When a user goes to insert a new item and then cancels, there is new functionality that brings the focus to the point where the insert button was clicked on the main modify survey page. File(s) affected: Item.asp
- Fixed a bug in one of the reports where, if a user entered HTML elements in the response, the text was not displaying correctly. File(s) affected: ResultsText.asp
1. Added two new columns to the SUR_ITEM table. These two columns are called DATABASE_SQL and DATABASE_DSN, and sequentially, go just after the IMAGE_ALIGNMENT column in that order. The DATABASE_SQL column is of type text (SQL Server) or Memo (Access) and is not required. The DATABASE_DSN column is of type varchar (SQL Server) or Text (Access), is 255 characters long, and is not required.
2. Added a new entry in the SUR_ITEM_TYPE table. This entry has an item_type_id of 22, has item_type_name equal to "Choice - Database Dropdown", and has question_yn = "Y".
CODE CHANGES AND ADDITIONS
- Added a new question type for a database-driven dropdown. File(s) affected: Item.asp, ModifySurvey.asp, Include/SurveyRendering_inc.asp, Include/Constants_inc.asp, ExportDataAction.asp, PageCondition.asp, ReportFilterList.asp, ReportFilterListAction.asp, ResultsIndividual.asp, ResultsOverview.asp, TakeSurveyAction.asp, SurveyPageConditionAction.asp, Include/SurveyReportFilter_inc.asp, Include/SurveyRendering_inc.asp, ItemAction.asp, CreateSurveyAction.asp, CopyPage.asp, CopyItemAction.asp, [DATABASE cHANGES]
- Added functionality so that when a user inserts or edits a question in a survey, when they return to the main page for creating a survey, the focus is shifted back to the question either edited or inserted. Previously, the focus was always at the top of the page, which required the user to scroll down each time. File(s) affected: ItemAction.asp, Item.asp
- Fixed two small bugs related to navigation on the survey options page. File(s) affected: Survey.asp, SurveyAction.asp
- Fixed a small bug in the overview report: File(s) affected: ResultsOverview.asp
- Fixed two small bugs where the ordering of pages numbers for page properties was not being maintained correctly when inserting new pages and deleting existing pages. File(s) affected: ItemAction.asp, RemovePageBreak.asp
- Fixed two style sheet formatting bugs for actual surveys. File(s) affected: TakeSurvey.asp, TakeSurveyActionComplete.asp
- Improved the spacing of questions in surveys. File(s) affected: Include/SurveyRendering_inc.asp, TakeSurvey.asp
3. In the SUR_ID_GENERATION table, changed the SurveyGenerationEmailListEntry key to SurveyGenerationEmailAddress.
4. Add three new records to the SUR_ID_GENERATION table. Each entry should start with a value of 100, and the keys are SurveyGenerationEmailSentHistory, SurveyGenerationEmailMessage, and SurveyGenerationHiddenField.
5. Made the following changes to the SUR_EMAIL_LIST table:
- Changed the name of the EMAIL_ADDRESS_ACTIVE_COUNT column to EMAIL_ADDRESS_COUNT
- Removed the EMAIL_ADDRESS_INACTIVE_COUNT table.
6. Made the following changes to the SUR_EMAIL_ADDRESS table.
- Changed the name of the CUSTOM_DATA column to CUSTOM_DATA_1
- Added two new columns called CUSTOM_DATA_2 and CUSTOM_DATA_3. These two columns are located in this order just after the CUSTOM_DATA_1 column. They are not required, and are both of data type Text (Access) or varchar (SQL Server), and are 75 characters long.
- Added a new column called DELETED_YN. This is the last column in the table, it is required, its data type is Text (Access) or varchar (SQL Server), and it is one character long. Possible values are N or Y. If upgrading, insert N into all existing rows.
7. Added a new column to the SUR_RESPONSE table called EMAIL_ADDRESS_ID. Sequentially, this column goes just after the ANONYMOUS_ID column. The data type is int, and the field is not required.
8. Added the SUR_HIDDEN_FIELD table.
9. Added the SUR_RESPONSE_HIDDEN_FIELD table.
CODE CHANGES AND ADDITIONS
- Fixed a bug when creating a new survey by copying an existing survey. File(s) affected: CreateSurveyAction.asp
- Added an enormous amount of functionality to the email list so that email message can be sent, managed, and tracked. Users can respond to surveys using a link in an email that encrypts the survey, and contains information for tracking who responded to the survey. File(s) affected: CreateSurveyAction.asp, DeleteEmailAddress.asp, DeleteEmailList.asp, EmailAddress.asp, EmailAddressAction.asp, EmailAddressList.asp, EmailAddressListAction.asp, EmailList.asp, EmailListAction.asp, EmailListList.asp, ImportEmailAddresses.asp, ImportEmailAddressesAction.asp, Include/Constants_inc.asp, Include/ID_inc.asp, Include/SurveyPageConditions_inc.asp, Login.asp, LoginAction.asp, ResultsIndividual.asp, TakeSurey.asp, User.asp, CreateEmailList.asp (new), CreateEmailListAction.asp (new), EmailMessageDetails.asp (new), EmailMessageList.asp (new), ExportEmailList.asp (new), ExportEmailListAction.asp (new), Resources/Buttons/SortArrowDown.gif (new), Resources/Buttons/SortArrowUp.gif (new), Resources/Buttons/Export.gif (new)
- Fixed a bug in page conditions where page conditions were behaving inconsistently for multiple response anonymous surveys. File(s) affected: Include/SurveyPageConditions_inc.asp
1. Added a new column to the SUR_SURVEY table called RESPONSE_EMAIL_ADDRESSES. This column is not required and is of type Memo (Access) or text (SQL Server). Sequentially, this column should be position immediately after the SURVEY_COMPLETE_REDIRECT_URL column.
2. In the SUR_SUBITEM table, changed the data type of the SUBITEM_TEXT column to allow for unlimited length entries. In Access, the new data type for the column is Memo, and in SQL Server, the new datatype is text. The field is still required.
3. In the SUR_TEMPLATE table, changed the name of the BACKGROUND_COLOR column to SURVEY_BACKGROUND_COLOR.
4. In the SUR_TEMPLATE table, added a new column called PAGE_BACKGROUND_COLOR. This column is of type Text (Access) or varchar (SQL Server), is 7 characters long, and is required. If upgrading, use a default value of #FFFFFF. Sequentially, this new column is located right after the SURVEY_BACKGROUND_COLOR column.
5. Added three new columns to the SUR_SURVEY table. The three columns are BACK_BUTTON_DISPLAY, CANCEL_BUTTON_DISPLAY, and CANCEL_BUTTON_REDIRECT_URL, are the last three in the table, and are in the table in the same order as noted here. The BACK_BUTTON_DISPLAY column is of type Text (Access) or varchar (SQL Server), is 20 characters, and is required. If upgrading, use the value "Display" as the default. The CANCEL_BUTTON_DISPLAY column is of type Text (Access) or varchar (SQL Server), is 50 characters, and is required. If upgrading, use the value "Close browser" as the default. The CANCEL_BUTTON_REDIRECT_URL is of type Text (Access) or varchar (SQL Server), is 255 characters, and is not required. If upgrading, no default value is required.
6. Changed the name of the ADMIN_EMAIL_ADDRESSES field in the SUR_SURVEY table to ADMIN_EMAIL_ADDRESS. Changed the data type of this field from Memo (Access) or text (SQL Server) to Text (Access) or varchar (SQL Server), with a length of 75 characters.
CODE CHANGES AND ADDITIONS
- Added options on each survey to optionally display the Back button, and to specify the action to take when the user clicks the Cancel button. The possible actions are close the browser, redirect to a specified URL, or redirect to the end of the survey (and default to whatever action was set for the end of the survey). File(s) affected: TakeSurvey.asp, Include/Constants_inc.asp, Survey.asp, SurveyAction.asp, CreateSurveyAction.asp
- Added the ability to set the background color on a survey. File(s) affected: ResultsIndividual.asp, ResultsOverview.asp, ResultsText.asp, Include/SurveyUtility_inc.asp, Include/Constants_inc.asp, TemplateAction.asp, CreateTemplateAction.asp, Template.asp, TakeSurvey.asp, PreviewTemplate.asp, Include/SurveyRendering_inc.asp, TakeSurveyActionComplete.asp, [DATABASE CHANGES]
- Added support for the ASPEmail server component for sending out emails. File(s) affected: Include/Email_inc.asp, Include/Constants_inc.asp, Include/Config_inc.asp
- Changed the admin address field so that only a single administrator email address can be entered, rather than multiple email addresses separated by semi-colons. File(s) affected: Survey.asp, SurveyAction.asp, CreateSurveyAction.asp, [DATABASE CHANGES]
- In the individual results report, for the started and completed times, added the time to the date. Also, if the user did not complete the survey, the end date and the elapsed time both now say, "Incomplete." File(s) affected: ResultsIndividual.asp
- Changed (Improved) the look and feel of the application by using a one pixel wide black border on all of the wizard box tables. File(s) affected: ResultsText.asp, ResultsIndividual.asp, ResultsOverview.asp, Include/Constants_inc.asp
- Added a Close button to the Thank You page after completing a survey. File(s) affected: TakeSurveyActionComplete.asp
- Fixed a bug in the page conditions that ocurred only when a user did not meet the requirements to view at least two pages at the end of a survey. File(s) affected: Include/SurveyPageCondition_inc.asp
- Added a new format for exporting data to CSV file. The new format is SPSS format, and exports each respondent's entire set of answers on one row, with each possible answer to each question in its own column. File(s) affected: CreateCSVFile.asp, ExportData.asp, Include/Constants_inc.asp
- Fixed a bug in the data export functionality where one question surveys were not being exported correctly. File(s) affected: CreateCSVFile.asp
- Fixed a bug where exports for "User Responses" where there were questions missed due to page conditions were being shifted to the left by the number of questions skipped as a result of the page conditions. File(s) affected: CreateCSVFile.asp
- Fixed the messages for both checkboxes and open ended - one or more lines questions. The problem was that the messages that said the required number of responses always used the plural for "response" or "value," but needed to be modified to also use the singular if the specified number is 1. File(s) affected: Include/SurveyRendering_inc.asp, TakeSurvey.asp
- Fixed a bug in the survey options page in the SQL for users logged in with "Create" permission. File(s) affected: Survey.asp
- Created all new buttons for the entire application to improve the look and feel. File(s) affected: All files in the Resources/Buttons folder
- Fixed a client-side JavaScript bug that occured if a user tried to save a new item without first selecting the item type. File(s) affected: Item.asp
- Fixed a bug where, when a new question with multiple rows (matrix, ranking, constant sum, etc.) was added, the number of subitems was being recorded as one less than there are actually are. File(s) affected: ItemAction.asp
- Added an option to have each response emailed to a list of email addresses when the survey is submitted. File(s) affected: Survey.asp, SurveyAction.asp, CreateSurveyAction.asp, TakeSurveyAction.asp, TakeSurveyActionComplete.asp, Include/SurveyEmail_inc.asp (new), [DATABASE CHANGES]
- Changed the name of the application cookie to include the edition. This change prevents a bug in a situation where a user has both Classic and Advanced installed, and tries to access one application after already being logged into the other. File(s) affected: Include/Constants_inc.asp
- Fixed a bug in the client-side validation for constant sum questions where the total was not being reset for each question. Therefore, on any constant sum question that was at least the second such question on a page, the cumulative total started with the total from the previous question. File(s) affected: TakeSurvey.asp
- Fixed the alignment of the buttons on the list of email addresses. File(s) affected: EmailList.asp
- Fixed a bug in both the preview template and take survey pages where the red asterisk, used for denoting a required question, did not have a style applied. File(s) affected: TakeSurvey.asp, PreviewTemplate.asp
- Increased the maximum length of row text for matrix, rating, constant sum, and open-ended one or more line questions. Previously, the length was limited to 100 characters, while now the length is unlimited. File(s) affected: ItemAction.asp, [DATABASE CHANGES]
- Fixed a bug in the page for editing page title and introduction where the page was incorrectly calling a client-side JavaScript function that does not exist. No client-side validation is required on this page. File(s) affected: Page.asp
- Fixed a bug where the join between a survey and the page properties table was missing part of the WhERE clause, thus causing records to be returned multiple times. File(s) affected: ModifySurvey.asp
- Fixed a bug in the report filtering that was generating an error when filtering on Yes/No or True/False questions. File(s) affected: Include/SurveyReportFilter_inc.asp
- Fixed the vertical alignment of the question number on the take survey page so that it is always even with the top of the question text. Previously, the number was dropped a very small amount from being even with the top of the question text. File(s) affected: Include/SurveyRendering_inc.asp
- Added logic to set the default role when creating a new user. File(s) affected: User.asp
- When inserting a new item, the page initially displays a dropdown box with the list of item types. New logic was added so that the Save button is not displayed at this point. File(s) affected: Item.asp
- When sending HTML emails, the carriage returns were not being correctly changed to <br> tags, so all of the text was being displayed without any line breaks. All <br> tags are now correctly inserted. File(s) affected: EmailInvitationAction.asp
- Updated the default security level to be "Multiple Response, Anonymous Access Allowed". File(s) affected: CreateSurveyAction.asp
1. Changed the name of the PASSWORD column in the SUR_USER table to USER_PASSWORD.
2. Added a new column called USER_ATTRIBUTE_TYPE to the SUR_REPORT_FILTER table. This column is of type Text (Access) or varchar (SQL Server), and is 15 characters long. The column is NOT required. Sequentially, this column should be positioned just after the FILTERED_ITEM_ID column.
3. Added a new column to the SUR_REPORT_FILTER table called USER_ID, which is a foreign key to the USER_ID column in the SUR_USER table. The USER_ID column is not required and is of type Number (Access) or int (SQL Server). Sequentially, this column should be position immediately after the SURVEY_ID column.
4. Added the SUR_TEMPLATE table
5. Added the TEMPLATE_ID column to the SUR_SURVEY table. This column is of type Number (Access) or int (SQL Server) and is required. Sequentially, the TEMPLATE_ID column is the third column in the table, immediately after the TITLE column. If upgrading, set the value of this column to 1 (the default template ID).
6. Removed the LOGO_PATH, LOGO_ALIGNMENT, BORDER_COLOR, BORDER_WIDTH, and BACKGROUND_COLOR columns from the SUR_SURVEY table.
7. Added the SUR_PAGE table.
8. Removed the INTRODUCTION column from the SUR_SURVEY table.
CODE CHANGES AND ADDITIONS
- Added templates, which are the ability to define a complete look and feel for any survey. File(s) affected: Include/SurveySecurity_inc.asp, Reports.asp, Survey.asp, Template.asp, TakeSurveyAction.asp, User.asp, Include/Constants_inc.asp, Include/AppHeader_inc.asp, Include/SurveySecurity_inc.asp, AccessDenied.asp, Template.asp (new), TemplateAction.asp (new), TemplateList.asp (new), CreateTemplate.asp (new), CreateTemplateAction.asp (new), Resources/Buttons/CreateNewTemplate.gif (new), PreviewTemplate.asp (new), Resources/Buttons/PreviewTemplate.gif (new), [DATABASE CHANGES]
- Changed the name of the PASSWORD column in the SUR_USER table to USER_PASSWORD. The reason for this is that SQL Server considers "password" to be a reserved word, which causes problems on some versions of SQL Server. File(s) affected: ForgotPassword.asp, user.asp, UserAction.asp, LoginAction.asp, ImportUsersAction.asp, [DATABASE STRUCTURE]
- Added functionality to the report filters so that each logged in user can maintain his/her own set of filters for each survey. File(s) affected: ReportFilterList.asp, ReportFilterListAction.asp, Include/Constants_inc.asp, Include/SurveyUtility_inc.asp, Include/SurveyReportFilter_inc.asp, [DATABASE STRUCTURE]
- Fixed a bug in how cookies were being set that was erroneously allowing an anonymous user to get a differnt anonymous user ID each time they took a survey. File(s) affected: Include/Constants_inc.asp, Include/SurveySecurity_inc.asp
- Fixed a bug in the page for taking surveys where the new language property was not specified in one of the queries for retrieving information about the survey. File(s) affected: TakeSurvey.asp
- Added another filter type to the report filter page called "User Attribute." File(s) affected: ReportFilterList.asp, ReportFilterListAction.asp, Include/Constants_inc.asp, Include/SurveyReportFilter_inc.asp
- Changed the extension of the client-side JavaScript include file from .ijs to .js to make it more of an industry standard. File(s) affected: ClientInclude/Utility.ijs became ClientInclude/Utility.js, CopyItem.asp, CreateSurvey.asp, EmailAddress.asp, EmailInvitation1.asp, EmailInvitation2.asp, EmailList.asp, ExportData.asp, ForgotPassword.asp, ImportEmailAddresses.asp, ImportUsers.asp, Item.asp, PageCondition.asp, ReportFilterList.asp, Reports.asp, Survey.asp, TakeSurvey.asp, Template.asp, User.asp
- Fixed a bug where, when the Back button was clicked on a survey, the page numbering was incorrect on the previous page. File(s) affected: TakeSurveyAction.asp
- Added the ability to add a page title and/or a page introduction to every page in the survey. To accomodate this, the overall introduction for the entire survey was removed, and the page number was shifted to the upper right-hand corner of the survey page. File(s) affected: ModifySurvey.asp, Survey.asp, TakeSurvey.asp, SurveyAction.asp, CreateSurveyAction.asp, CopyPage.asp, DeletePage.asp, DeleteSurvey.asp, Resources/Buttons/EditPagePropertiesSmall.gif (new), Resources/Images/ClassAppsLogo.gif (new), [DATABASE CHANGES]
1. Changed the FILTERED_ITEM_ID column in the SUR_REPORT_FILTER table to not required.
2. Deleted the NUMBER_PAGES_YN column in the SUR_SURVEY table, and replaced it with a new column called PAGE_NUMBERING_FORMAT. The new column is a 40 character Text (Access) or varchar (SQL Server) field, is required, and should be positioned in the SUR_SURVEY table just before the QUESTION_NUMBERING_FORMAT column. If upgrading, all rows that had Y in the NUMBER_PAGES_YN column should now have the following value in the PAGE_NUMBERING_FORMAT column:
Display progress in 'Page X of Y' format
All rows that had N in the NUMBER_PAGES_YN column should now have the following value in the PAGE_NUMBERING_FORMAT column:
Do not display page numbers
3. Add a new column to the SUR_ITEM answer table called RANDOM_ANSWER_ORDER_YN. This column is a single character and is required. Acceptable values for this column are Y or N. Sequentially, this table should be added to the SUR_ITEM table right after the REQUIRED_YN column. If upgrading, add this column as not required, update all rows to N, then change the column to required. You can then go into any individual question and make the item have random order in its questions.
4. Added a new column to the SUR_ITEM_ANSWER table called RANDOM_ORDER_NUMBER. This column is a of type Number (Access) or int (SQL Server) and is not required. Sequentially, this column goes right after the ORDER_NUMBER column.
5. Added a new column to the SUR_SUBITEM table called RANDOM_ORDER_NUMBER. This column is a of type Number (Access) or int (SQL Server) and is not required. Sequentially, this column goes right after the ORDER_NUMBER column.
6. Added a new column to the SUR_SURVEY table called SURVEY_LANGUAGE. This column is of type Text (Access) or varchar (SQL Server), is 10 characters long, and is required. Sequentially, this column goes right before the STATUS column. If upgrading, this column can be defaulted to "en" (English).
CODE CHANGES AND ADDITIONS
- Added the ability to randomize answers for all questions with matrixes or multiple predefined answers. File(s) affected: Include/Constants_inc.asp, Include/SurveyRendering_inc.asp, Item.asp, ItemAction.asp, CopyPage.asp, CopyItemAction.asp, ModifySurvey.asp, Include/Utility_inc.asp, TakeSurvey.asp
- Fixed a bug where the filtered_item_id column in the sur_report_filter table was incorrectly set to required. Since date filters do not need an item ID, the column is not required.
- Added a preview button to the modify survey page. The preview button displays the survey in a new window, which means that many of the buttons that should be disabled on the modify survey page when a survey has responses are still visible. To fix this, added validation to each of the other pages for inserting, deleting, and copying pages and items. File(s) affected: ModifySurvey.asp, CopyPage.asp, DeletePage.asp, ModifySurvey.asp, DeleteItem.asp, Item.asp
- Improved the page number functionality so that each survey can have page numbers displayed in one of three formats (page number only, page x of y progress indicator, or no page number). File(s) affected: TakeSurvey.asp, Include/Constants_inc.asp, Survey.asp, SurveyAction.asp, CreateSurveyAction.asp
- Added a Back button to the survey page so that users taking a multi-page survey can traverse backwards. File(s) affected: TakeSurvey.asp, TakeSurveyAction.asp
- Added the ability to set the language for a survey. The language is set with the lang attribute on the <html> tag. File(s) affected: Survey.asp, SurveyAction.asp, CreateSurveyAction.asp, Include/Constants_inc.asp, TakeSurvey.asp, TakeSurveyAction.asp
- Fixed a small bug in the SQL for the report filter logic that was causing an error when run against SQL Server. File(s) affected: Include/SurveyReportFilter_inc.asp
- Fixed a bug in the data export for user responses where all questions in all surveys were being included in the exported data, rather than just the questions for the desired survey. File(s) affected: CreateCSVFile.asp
- Fixed a bug in the query in page conditions that was causing an error on page two of surveys with no questions that require answers on page one. File(s) affected: Include/SurveyPageConditions_inc.asp
- Fixed a bug in the individual results report where the subitems collection was pointing to the wrong question in the case where an option buttons question directly preceded a matrix question. File(s) affected: ResultsIndividual.asp
- Fixed a bug in the list of email lists that was incorrectly displaying all email lists, regardless of whether or not the current user owned them or was an admin. Now, to see a list, the user must be either the list owner or an admin. File(s) affected: EmailListList.asp
- Added code to send emails by JMail or CDO.Message. The CDO.Message component replaces CDONTS on Windows 2003 server. File(s) affected: Include/Email_inc.asp, Include/Config_inc.asp, Include/Constants_inc.asp
- Added the ability on the individual report to specify which response number to navigate to, and then go to that response, rather than having to scroll through the responses with the plus and minus 10 buttons. File(s) affected: ResultsIndividual.asp, Resources/Buttons/GoSmall.gif (new), Resources/Buttons/ArrowBackSmall.gif (new), Resources/Buttons/ArrowForwardSmall.gif (new), Resources/Buttons/ArrowForwardOne.gif (deleted), Resources/Buttons/ArrowForwardTen.gif (deleted), Resources/Buttons/ArrowBackOne.gif (deleted), Resources/Buttons/ArrowBackTen.gif (deleted)
- When a survey respondent takes a survey with more than one page, they will sometimes click the Back button on the browser, and then resubmit the answers to a previous page. This was causing bugs, since the same question was answered more than once in the database. In this release, this bug is fixed, so that when a user resubmits a page by using the Back button, the previous answer or set of answers gets updated in the database. File(s) affected: TakeSurveyAction.asp, TakeSurvey.asp, TakeSurveyActionComplete.asp, Include/Constants_inc.asp
NEW FILES: Resources/Buttons/InsertFilter.gif, Resources/Buttons/ManageFilters.gif, DeleteReportFilter.asp, Include/SurveyReportFilter_inc.asp, ReportFilterList.asp, ReportFilterListAction.asp
DATABASE CHANGES:
1. Added a column to the SUR_ITEM_ANSWER table called ANSWER_VALUE. This column is of type Number (Access) or int (SQL Server), and is not required. Sequentially, this column should is the fourth column in the table, after ANSWER_TEXT and before ORDER_NUMBER.
2. Added a new table called SUR_REPORT_FILTER.
3. Added a new entry in the SUR_ID_GENERATION table with the NEXT_AVAILABLE_ID set to 100 and the NAME column set to SurveyGenerationReportFilter.
4. Changed the name of the SUR_PAGE_CONDITION_OPERATOR table to SUR_OPERATOR (since operators are now used on both page conditions and report filters)
5. Increased the size of the answer text field from 75 to 125 characters. This change applied to both the ANSWER_TEXT column of the SUR_ITEM_ANSWER table and the ANSWER_TEXT column of the SUR_PAGE_CONDITION table.
6. For table SUR_EMAIL_LIST, removed column EMAIL_ADDRESS_COUNT and replaced it with two columns (in this order): EMAIL_ADDRESS_ACTIVE_COUNT and EMAIL_ADDRESS_INACTIVE_COUNT. Both of these columns are required. If upgrading, change the name of the EMAIL_ADDRESS_COUNT column EMAIL_ADDRESS_ACTIVE_COUNT, and add the EMAIL_ADDRESS_INACTIVE_COUNT column right after it.
CODE CHANGES AND ADDITIONS
- Added report filtering, which is the ability to limit the report results based on answers to questions. File(s) affected: ResultsIndividual.asp, ResultsOverview.asp, ResultsText.asp, Include/SurveyUtility_inc.asp, Include/Constants_inc.asp, AccessDenied.asp, Resources/Buttons/InsertFilter.gif (new), Resources/Buttons/ManageFilters.gif (new), DeleteReportFilter.asp (new), ManageReportFilters.asp (new), DeleteResponses.asp, Include/Utility_inc.asp, Include/SurveyRendering_inc.asp, Include/AppHeader_inc.asp, Include/SurveyReportFilter_inc.asp (new), CreateCSVFile.asp, CreateSurvey.asp, CreateSurveyAction.asp, EmailInvitation2.asp, EmailList.asp, Reports.asp, ResultsOverview.asp, ResultsText.asp, Survey.asp, SurveyList.asp, Include/Utility_inc.asp, Include/Config_inc.asp, Include/Constants_inc.asp, ReportFilterList.asp, Item.asp, Survey.asp, TakeSurvey.asp
- Added point values to the answers for option buttons, checkboxes, and dropdowns. File(s) affected: Item.asp, ItemAction.asp, ResultsOverview.asp, ResultsIndividual.asp, CopyItemAction.asp, CopyPage.asp, CreateSurveyAction.asp, CopyItemAction.asp, CopyPage.asp, CreateSurveyAction.asp
- On the copy item page, if there are no items available, the Continue button is now hidden. Previously, the Continue button was visible, and would cause an error if clicked. File(s) affected: CopyItem.asp
- Updated the validation for ranking questions so that when the question is required, the user must enter a value for all items. Previously, the user had only been required to enter at least one value. File(s) affected: TakeSurvey.asp
- Updated the validation for constant sum questions to make sure that all values entered are numeric. Previously, the check for numeric values was only done if the question was required. Also, updated the code so that if the total is specified and the question is not marked as required, the user must still enter values totalling the specified sum. Finally, when the total is wrong, the current total is now displayed in the error message. File(s) affected: TakeSurvey.asp
- Increased the maximum length of the individual item answers from 75 to 125 characters. This required changing the maxlength attribute for the text boxes, and changing the database column widths (see above). File(s) affected: Item.asp
- When sending email invitations, added an option to specify whether the email is text or HTML format. File(s) affected: ForgotPassword.asp, EmailInvitationAction.asp, EmailInvitation2.asp, Include/Email_inc.asp
- Fixed a bug where a field in a recordset was being accessed after the recordset had been closed. Now, instead, a local variable with the value is accessed instead. File(s) affected: TakeSurveyActionComplete.asp
- Fixed a bug where, if an item had subitems, but then was changed to an item type without subitems, the subitems were not deleted from the SUR_SUBITEM table, as they should be. File(s) affected: ItemAction.asp
- Fixed a bug in the individual report where the subitems recordset was not being advanced the correct number of rows for each item that contained subitems. File(s) affected: ResultsIndividual.asp
- Fixed a bug in the results overview report that was incorrectly calculating the number of skipped responses. The bug was being caused by not counting people who never even finished the survey as having skipped the question. File(s) affected: ResultsOverview.asp
- Improved the way that dates are internationalized. All bugs related to dates in Europe are now fixed, plus users have the ability to specify the character used as the delimiter in dates. File(s) affected: CreateSurvey.asp, CreateSurveyAction.asp, EmailInvitation2.asp, EmailList.asp, Reports.asp, ResultsOverview.asp, ResultsText.asp, Survey.asp, SurveyList.asp, Include/Utility_inc.asp, Include/Config_inc.asp, Include/Constants_inc.asp, ReportFilterList.asp, Item.asp, Survey.asp, TakeSurvey.asp, ResultsText.asp, ResultsIndividual.asp
- Modified the main list of surveys so that clicking on the link for "Analyze" brings the user straight to the overview report rather than to the main reports page. File(s) affected: SurveyList.asp
- Removed the small edit button next to the introduction on the main modify survey page. File(s) affected: ModifySurvey.asp
- Enhanced the data export functionality by adding the row text (subitem) for matrix questions to the CSV file. File(s) affected: CreateCSVFile.asp
- Fixed a bug that wa preventing the results text for type "Other" from displaying correctly. File(s) affected: ResultsText.asp
- Fixed a small bug in the client-side validation for ranking questions. File(s) affected: TakeSurvey.asp
- Added the ability to change the active status of email addresses in bulk from the main list of email addresses. Also, replaced the existing counter for all email addresses with two separate email address counts -- one for active email addresses, and one for inactive email addresses. File(s) affected: EmailList.asp, EmailListAction.asp, EmailListList.asp, EmailAddress.asp, EmailAddressAction.asp, ImportEmailAddressesAction.asp, DeleteEmailAddress.asp, EmailInvitation1.asp, EmailInvitation2.asp
- Added a new data format to the data export functionality. The new format displays data with entire user responses on a single row, and each question as a column next to the answer. File(s) affected: CreateCSVFile.asp, ExportData.asp, Include/Constants_inc.asp
- Fixed a bug where, if a user responded to a survey and then was deleted, the individual results report threw an error. File(s) affected: ResultsIndividual.asp
- Cleaned up the alignment of input controls for specifying email information for invitations, and increased the number of characters in the subject from 50 to 125. File(s) affected: EmailInvitation2.asp
- Fixed a bug in the server-side email validation. The bug was that email addresses with an underscore in the username, which is valid, were being reported as invalid. File(s) affected: Include/Utility_inc.asp
- Fixed a bug in the way answers for matrix rating questions were rendered to the input page and then recorded to the database. The bug was that if the rating scale did not start with one, the first n number of answers less than the starting value were being omitted. File(s) affected: Include/SurveyRendering_inc.asp,
- Added a new function for date comparisons called SQLEncodeDate(). This function uses the appropriate delimiters to wrap dates when the dates are used in comparisons in the WHERE clause. File(s) affected: Include/Utility_inc.asp
- Fixed a bug in the functionality for copying a survey where the copy failed if a survey with no items in it was copied. File(s) affected: CreateSurveyAction.asp
- Fixed several bugs in the data export functionality. The bugs fixed were that double quotes were not being quotes, which was causing errors when the data contained double quotes. Not all fields were being correctly wrapped in double quotes. Added logic so that if a question has a question alias, the alias is displayed in the exported data. Added the report filtering to the query. File(s) affected: CreateCSVFile.asp, Include/Utility_inc.asp
DATABASE CHANGES: In the SQL file only, increased the length of the SUBITEM_TEXT field in the SUR_SUBITEM table from 50 to 100 characters
CODE CHANGES AND ADDITIONS
- When a survey owner or an admin clicks on preview for a survey that has not been launched, the Access Denied page now has a link to allow the user to immediately launch the page and view the survey. File(s) affected: ChangeStatus.asp, AccessDenied.asp
- Fixed a bug that was incorrectly copying items. Individual items are copied on both the "copy page" page and the page that copies an entire survey. File(s) affected: CopyPage.asp, CreateSurveyAction.asp
- Fixed several bugs related to copying surveys and items. File(s) affected: CopyItemAction.asp, CopyPage.asp
- Fixed a bug in the "page x of y" formatting. File(s) affected: TakeSurvey.asp
- Expanded the width of the dropdown listing all existing surveys. File(s) affected: CreateSurvey.asp
- Removed the small edit icon next to the introduction if there is no introduction. File(s) affected: ModifySurvey.asp
- Cleaned up some of the white space on the survey page if there is no introduction. File(s) affected: ModifySurvey.asp
- Fixed a bug in how the hex background color is determined for matrix questions. File(s) affected: Include/Utility_inc.asp
- Cleaned up some of the formatting and alignment in the way questions are displayed in a survey. File(s) affected: Include/SurveyRendering_inc.asp
- Fixed a bug that was preventing new surveys from being created correctly. File(s) affected: CreateSurveyAction.asp
- Fixed a number of small bugs in how the individual results report was being displayed. File(s) affected: ResultsIndividual.asp
- Improved the formatting on the final page of the survey. File(s) affected: TakeSurveyActionComplete.asp
- Added detailed descriptions above two of the textarea's for user to include HTML in the formatting of the introdution and the completion message. File(s) affected: Survey.asp
- In the report filter, some of the questions were getting completely truncated. Fixed the code so that a question is always cleanly displayed in the dropdown box. File(s) affected: ResultsIndividual.asp, ResultsOverview.asp
Version 6.0.0 (Released on 06/30/2003)
SelectSurveyASP Advanced is built on top of of SelectSurveyASP Classic, Version 5.0.1. Therefore, while this is the first release of the Advanced version, it has been given a version number of 6.0.0 to reflect the many iterations of work in the previous version of the application.
Note that the data model has changed considerably between the Classic and the Advanced versions. Therefore, upgrading from the Classic to the Advanced version is not easily done, and thus the two are considered to be entirely separate applications.
This release contains all of the great functionality in the Classic version, plus the following major enhancements:
- The appliation has 7 new question types:
- Matrix - One Answer per Row (Option Buttons)
- Matrix - Multiple Answers per Row (Checkboxes)
- Matrix - Multiple Answers per Row (Textboxes)
- Matrix - Rating Scale (Numeric)
- Constant Sum
- Ranking
- Open Ended - One or More Lines
- Reporting has been significantly improved, including:
- Reports now use bar graphs
- Summary calculations are now included in the overview report
- Ability to filter all reports to display the entire survey, pages within a survye, or individual question
- Admins and report owners can edit any individual response
- Each question can be replaced with a question alias in the reports for more concise display
- Improved content display on the top of all reports
- Reports now display the number of users who skipped each question
- Answer piping. Piping means the ability to display the answer to a previous question in the text of a subsequent question.
- Ability to add logos at the top of a page
- Ability to do a bulk upload and insert of users
- Each user can now have to three custom data fields
- The main page for modifying surveys contains a shortcut for copying individual questions
- The main page for modifying surveys contains a shortcut for copying entire pages of questions
- Email address validation option for open ended questions
- Option to close window upon survey completion
- Many usability improvements, emphasizing less clicks, more logical usage, and less redundant places to perform the same functionality
- Progress is now displayed on each page in a survey in the form of, "Page x of y," where x is the current page and y is the total number of pages in the survey
- Improved look and feel of surveys when displayed to the respondents