Princeton University Survey Facility

This WebSurvey facility is a legacy service provided by OIT Academic Technology Services. For more information about this service and the available alternatives, please see this solution in the OIT KnowledgeBase: http://helpdesk.princeton.edu/kb/display.plx?ID=9187.


The Princeton University Survey Facility allows members of the Princeton University community to create customized Web survey applications.
Latest Three New Features(to see full listing New Features Summary List):


Overview

Each Web survey application corresponds to a master survey that is owned by the survey creator (survey creators are identified by their OIT Unix netid). Master surveys have properties that determine the overall characteristics of the Web survey application. The following table list the properties that the survey creator can set:

Optional Survey TitleText used as the title for the survey. This text should include HTML tags to properly format the title on the web pages. If not specified, then the survey name is used as the title.
Survey ScriptnameURL for the master survey
(Note ".pl" will be append to name)
For Example, the URL for Survey Scriptname "Test" is
http://websurvey.princeton.edu/cgi-bin/Test.pl
Review Survey URLURL for the master survey to allow a respondent to take the survey and not load the responses to the database ( at the bottom of the html page there will text to inform the respondent that responses will not be loaded into the database). Note that this URL will ignore the "Survey Done" flag.
The Review Survey URL consists of prefacing the string "REVIEW_" before the the survey scriptname.
For example if the Survey Scriptname is "Test", then the Review Survey URL is
http://websurvey.princeton.edu/cgi-bin/REVIEW_Test.pl
Netid Authenticationif enabled then respondents must authenticate before they can take the survey.
Note that an authenticated respondent can take the survey only once ( unless the Allow Retake flag is enabled).
Princeton Netid Filterif the survey requires authentication, this filter can restrict the pool of authorized respondents.
Use either format "Survey_List survey_name" to validate netid against values in a survey list called "survey_name"
for example "Survey_List My_Netid_List" means check netid against the values stored in list"My_Netid_List"
OR
format "students [class years such as 00,01,GS];staff [dept names such as oit,facilities];faculty [dept names such as english,physics]"
For example, specify "students GS" to allow only graduate students
For example specify "students" to allow only undergraduates and graduate students
For example specify "students 99,GS;staff" to allow only class 99 undergraduates, graduate students, and staff
For example, specify "staff;faculty" to allow only staff and faculty
For example, specify "staff oit, athletics;faculty english, physics" to allow only staff who belong to dept names which contain the string "oit" or "athletics" or faculty who belong to dept names which contain the string "english" or "physics".Note that the staff and staff dept checks are case -insensitive,i.e. "staff oit" is processed exactly the same as "staff OIT".
Note - if you want to specify both a list of netids and also students by class, staff, and/or faculty use the format students [class years such as 00,01,GS];staff [dept names such as oit,athletics];faculty[dept names such as english,physics] Survey_List My_Netid_List
For example "students 01,02 Survey_List My_Netid_List to allow only students in classes 01 and 02 or netids in the survey list call My_Netid_List
Note that the Survey_List specification must come after the student/staff/faculty specification.
The netid filter now supports Princeton alumni authentication. The alumni specification is part of the student/staff/faculty/alumni specification. Since alumni can either be undergraduate alumni or graduate alumni, there are different key phrases for each category.
  • Use alumni to refer to any alumni, undergraduate or graduate.
  • Use u_alumni to refer to only undergraduate alumni.
  • Use g_alumni to refer to only graduate alumni.
After each key phrases you can specify a list of classes. Here are some examples
alumniAny alumni (undergraduate or graduate)
alumni 90,91,92Any alumni (undergraduate or graduate) in class 90,91,92
u_alumniAny undergraduate alumni
g_alumniAny graduate alumni
u_alumni 80,81Any undergraduate alumni in class 80,81
g_alumni 85,86Any graduate alumni in class 85,86
u_alumni 80,81;g_alumni 85,86Any undergraduate alumni in class 80,81 or Any graduate alumni in class 85,86
Allow RetakeIf netid authentication is enabled, the survey owner can enable the Allow Retake flag to allow respondents who have already taken the survey, to take the survey over and over again. The current survey session will have the question input fields filled in with the responses from the previous survey session ( if any ). Note that there still be only one set of responses per respondent and it will corresponds to the last survey session. The survey can optionally specified a list of netids who are allow to retake the survey.
Ip Filter Listif specified, then the survey can only be taken from machines which match the ip filter
Start TextIf specified, this text will be displayed in a "Start" survey page. Note that the survey system displays the start text with a default submit button with text "Start Survey". To specify an alternate text string for the submit button, append the start text with the string "==" and your customized text. For example specifying
This is my start text==Go Start!
will result in a web form with the text "This is my start text" and a submit button with text "Go Start!".
End TextIf specified, this text will be displayed at the end of the survey
Authentication TextIf specified, this text will replace the default authentication text in the authentication form(for authenticated surveys only) Note that the survey system displays the authentication text with a default submit button with text "Start Survey". To specify an alternate text string for the submit button, append the authentication text with the string "==" and your customized text. For example specifying
This is my authentication text==Go Authenticate!
will result in a web form with the text "This is my authentication text" and a submit button with text "Go Authenticate!". Note that to use the default authentication text with your own customized submit button text just specify
==Go Authenticate!
as the authentication text.
Survey Done TextIf specified, this text will replace the default survey done text which is displayed when a user takes a survey which has marked done.
Background ColorBackground color of master survey start and end pages
Survey Html Page For authenticated surveys, the survey system will create and update a html page that corresponds to the initial page of the survey. This allows another html page to reference the survey as a html page.

The most important property of the master survey is the list of one or more attached survey subsections. Each survey subsection is essentially a Web form with questions. Each survey subsection has properties the survey creator can set:

Want Questions To Be Numbered?if set, questions which prompt for an input will be displayed with a numerical sequence preface i.e.,
1) Question Text
2) Question Text
...
Note - this flag and the actual question label format can be overridden with a question which is connected to a "Set Question Ctr" choice. See Set Question Ctr option for more information.
Background ColorColor for the survey subsection
Font TypeFont Type Specification for the survey subsection
Font SizeFont Size Specification for the survey subsection
Disabled Reset ButtonBy default a survey subection will have a Reset button next to the Submit button. If this flag is enabled, then the Reset button will not be displayed.
Required Question LabelText string to be displayed as a preface to survey questions that required a response (assuming the Display Required Question Label flag is enabled)
Display Required Question LabelIf enabled, then the Required Question Label will prefaced all survey questions that require a response
Optional Survey TitleIf specified, then this text will override the displayed default survey title. The displayed default survey title is determined by whether the survey subsection is the only survey subsection of a master survey. If it is, then the displayed survey title is the survey subsection name. If it is not, then the displayed survey title is the master survey name followed by the survey subsection name.
Left Margin SpacesThe number of spaces for the left margin ( default is 0)
Right Margin SpacesThe number of spaces for the right margin ( default is 0)
Override Error Message With Warning If this flag is set to "Y" (note the default value is "N") and there are required questions without answers, then instead of seeing the normal required answer error message, the respondent will see a warning message. This warning message allows the user to either go back and make the necessary changes or disregard the warning and continue the survey. If the user chooses to continue, the "unanswered" required questions will have no responses. For a demonstration of how this works, go take the Required Warning Demo survey.
Alternate Required Error Message If specified, this message will be displayed when there is a required error. The default error message is
<center><h4><font color="red">Please answer those questions marked in red and click submit</font></h4></center>
Alternate Require Warning Message If specified, this message will be displayed when there is a required error and the Override Error Message With Warning is set to Y. The default warning message is
<center><h4><font color="red">Please answer those questions marked in red and click submit.<br>If you would prefer not to respond, simply click submit.</font></h4></center>

The master survey is essentially the sequence of Web forms which correponds to the list of attached survey subsections. Survey respondents for a master survey stepped thru the Web forms and answered them in the order specified by the survey subsections list.

A typical survey consists of a series of questions. Each question has an associated input. The input may be a text field where the respondent enters text or makes a selection ( or multiple selections ) from a list of options. If the input is a text field, the entered text is stored as the "response" to the question. If the input is list of options, the selected option ( or selected options ) is stored as the "response" to the question. However, the survey creator may want to associate a hidden value for each listed option and wants that value to be stored as the "response". For example, the list of options maybe ("Male", "Female") and the desired corresponding hidden values are ("M","F"). So when the respondent selects "Male", the corresponding hidden value "M" is stored as the response. To support these requirements, the Survey Facility provides survey lists, survey choices, and survey questions.

Survey List
A survey list is a list of values which is identified by an unique label. The values in these survey lists are used as lists of options in survey questions. There is a special predefined survey list called "Reserved for comment and input text". This special list has no list of values associated with. The significance of this special list will be discussed in following section. The Survey List Editor provides all the necessary functions ( create, edit, and delete) to administer survey lists.

Survey Choice
A survey choice is an object which specifies input type to a question. Each survey choice is identified by its four properties , a display list, a value list, input type, and location. The display list is the name of a survey list and the values in that survey list will be used as the list of options displayed. The value list is the name of a survey list and the values in that survey list will be used as the list of hidden values associated with the options of the display list. The input type dictates the type of input. The currently supported types are shown the the following table:

CheckBoxuse checkboxes to display the list of options
"Row Aligned" CheckBoxsame as CheckBox but the displayed checkboxes are aligned with the previous "Row Aligned" choice (only if the previous question is connected with a "Row Aligned" choice). This choice is mainly used to display a table of Checkboxes.
CheckBox Per Linesame as Checkbox but the checkboxes are displayed as one checkbox per line (Note that by setting the appropriate value in a survey question, this vertical list of checkboxes can be broken up into columns of checkboxes). This type also supports an additional input text field that must be filled in if the checkbox is selected. This is commonly used for requiring input when the Checkbox value is "Others, Please Specify". This additional feature is enabled when the appropriate tag is specified in the checkbox value (go into "Edit List" mode in the List Editor).
Comments Onlyinput type for specifying text only and required no inputs (i.e. comments in a survey)
"Row Aligned" Table Commentuse to specify the column labels for a table of radio buttons with columns and colors.( see Table Format Questions).
PopUpuse popup selection to display the list of options
Radio Buttonsuse radio buttons to display the list of options
Radio Buttons(Reset)same as Radio Buttons but there will be a "Clear Selected Button" next to the radio buttons. This button allows the respondent to clear just the selected button for this question.
"Row Aligned" Radio Buttonssame as Radio Buttons but the displayed radio buttons are aligned with the previous "Row Aligned" choice (only if the previous question is connected with a "Row Aligned" choice). This choice is mainly used to display a table of Radio Buttons.
"Row Aligned" Radio Buttons(Reset)same as "Row Aligned" Radio Buttons but there will be a "Clear Selected Button" next to the radio buttons. This button allows the respondent to clear just the selected button for this question.
"Row Aligned" Table Radio Buttonssame as Radio Buttons but the displayed radio buttons are aligned in a table fromat with subsequent "Row Aligned" Table Radio Buttons. This choice is used to display a table of Radio Buttons with aligned columns and color ( see Table Format Questions).
Input & "Row Aligned" Table Radio Buttonssame as "Row Aligned" Table Radio Buttons also allows for an additional text input value. (see Table Format Questions).
Radio Buttons Per Linesame as Radio Buttons but the radio buttons are displayed as one button per line (Note that by setting the appropriate value in a survey question, this vertical list of radio buttons can be broken up into columns of radio buttons). This type also supports an additional input text field that must be filled in if the radio button is selected. This is commonly used for requiring input when the Radio Button value is "Others, Please Specify". This additional feature is enabled when the appropriate tag is specified in the radio button value (go into "Edit List" mode in the List Editor).
Radio Buttons Per Line(Reset)same as Radio Buttons Per Line but there will be a "Clear Selected Button" next to the radio buttons. This button allows the respondent to clear just the selected button for this question.
Single Select Scrolldisplay the list of options as a scrollable list and allow one selection
Multiple Select Scrollsame as Single Select Scroll but allow multiple selections of options
Text Lineallow respondent to enter a line of text
"Row Aligned" Text Linesame as Text Line but the input line of text is aligned with the previous "Row Aligned" choice (only if the previous question is connected with a "Row Aligned" choice). This choice is mainly used to display a table of text line input fields.
Text Boxallow respondent to enter multiple lines of text in a text box
"At Least" Answer Checkrequires that for n consecutive questions that the respondent must submit at least m answers with answer "answer"
"No More Than" Answer Checkrequires that for n consecutive questions that the respondent must submit no more than m answers with answer "answer"
"Required" Answer Checkrequires the respondent must answer the next n consecutive questions if one of three criteria is satisfied
The answer is equal to a particular value
The answer is not equal to a particular value
The answer is not null
Randomized Questionsspecifies that the order of the next n consecutive questions will be randomized
Set Question Ctrcontrols the automatically labeling of questions. See Set Question Ctr option for more information.
JumpTo_Surveyuse for conditional or undconditional jumping from one subsection to another subsection. See JumpTo_Survey Support for more information.
Random Selectionrandomly select a value from a list and store that value as a response. This is mainly used for randomizing survey subsections( see Randomized Subsections).
Rank_Itemsallows respondent to rank items fro a list See Rank_Items for more information.
Ban Duplicatesprevent duplicate responses within the set of consecutive popup questions. See Ban Duplicates for more information.

The location value determines the placement of the input field in relation to the question text. There are only two location values, "Same Row" and "Next Row". "Same Row" means the input field will appear immediately after the question text. "Next Row" means the input field will appear in the next line after the question text. The Survey Choice Editor provides all the necessary functions ( create, edit, and delete) to administer survey choices. There are special predefined survey choices which are used for specifying a text line input, a text box input, and comments. All these special predefined survey choices use those input types and the special predefined list "Reserved for comment and iput text" as the display and value lists.

Survey lists and survey choices are tightly coupled. The Survey Facility performs consistency checks whenever either survey lists or survey choices are editted. When the name of a survey list has been changed, the Survey Facility automatically updates all choices which have that list as either a display or value list. The Survey Choice Editor insures that when creating or editing a survey choice, both the display list and value list have the same number of values. When a survey creator changes the number of values in a survey list, the Survey List Editor finds ,if any, all survey choices which has that list as either the display or value list. The Survey List Editor will print ,if any, all the survey lists from those survey choices for which there is now a count mismatch.

Survey Question
The survey question is the basic building block of a survey subsection. Each survey question has its own set of properties which determine the charactertics and layout of the actual question. The following table list the properties that the survey creator can set:

Question Text Text string to display as the question text. The following rules apply to question text
1.  Use tag %n SPACE% to specify n number of blank spaces,i.e. %5 SPACE% means insert 5 blank here. This tag should only be used when more than one space is needed.
1a.  Use the choice indentation tag __ to specify indentation text that will preceed the choice input fields. For example consider a question with text
1)%2 SPACE%Select Item in List__%4 SPACE%
attached to a radio button choice. The text string %4 SPACE% will appear next to all the radio butons.
2.  Use tag == to specify a multi-text question,i.e. Question Text 1==Question Text 2. This will require that you must specify an equal number of choices.
3.  If the Choice type is a Comment type and you want the question text not be be wrapped by the Survey system within Html table tags, preface the question text with the freeform comment tag FREEFORM_COMMENT:.
For example, the question text
FREEFORM_COMMENT:<Center><H4>Hello</H4></Center>
will generate a centered header line for the text "Hello"
4.  If Choice type is a Answer Check type, then this text is the answer to check for. For the "Required" Answer Check, this text is the character string which is compared with the response from the previous question. There are three types of comparisions, equal, not equal, and not null. If the comparison test is true, then the next Num Rows of questions must be answered. The default comparision is equal. To specific the not equal comparision, use the "^" tag. For example, the question text "^5" means see if the answer from the previous question is not equal to 5. To specific the not null comparision enter the not null tag "Not_Null" as the question text. This means see if the user has responded to the previous question. In situations when the answer to check for is different from the "displayed" answer, put the "displayed" answer in the "Submit Button Text" field. When an "Answer Check" error condition occurs, the survey system will use the "displayed" answer in the error message.
Display Submit Buttonif set then a Submit button will be displayed in the next line after the survey question. Note that if the last question of a survey subsection has the Display Submit Button enabled, the the default submit button will not be displayed.
Submit Button Text If Display Submit Button is enabled, then this text will appear in the Submit button.
If Display Submit Button is not enabled and if the choice is a "Answer Check", then this text (if specified ) is the alternate "answer" to be displayed in the Error message.
If Display Submit Button is not enabled and if the choice is not an "Answer Check", then this text can be used to specify the color for both the question text and the choices.
To specify the question text color use the tag TEXT_COLOR=Color_Name
To specify the choice color use the tag CHOICE_COLOR=Color_Name
To specify colors for both question text and choice, use both tags but use a "," as the delimiter( order is not important.
For example, valid color specifications are
TEXT_COLOR=teal
CHOICE_COLOR=blue
TEXT_COLOR=navy,CHOICE_COLOR=aqua
The list of valid colors supported by both Netscape and Explorer are
aqua for aqua Color
black for black Color
blue for blue Color
fuchsia for fuchsia Color
gray for gray Color
green for green Color
lime for lime Color
maroon for maroon Color
navy for navy Color
olive for olive Color
purple for purple Color
red for red Color
silver for silver Color
teal for teal Color
yellow for yellow Color
white for white Color
Any color unknown to the browser will be replaced with default colors.
If Display Submit Button is enabled and you want to use an image instead of a submit button, use the tag
IMAGE_SUBMIT:gif_url
where gif_url is the fully qualified URL for the image. For example,
IMAGE_SUBMIT:http://www.princeton.edu/Survey_Graph_Files/login_submit.gif
Number of Line BreaksProvide customized spacing between successive survey questions
Max Columns,
Num Rows,
Max Answers
The following rules apply to the values for Max Columns, Num Rows, and Max Answers:
"Max Columns" multiplied by "Num Rows" is the maximum number of characters allowed in the response.
If the choice type is a "Text Line", then "Max Columns" is the display length of the input field.
If the choice type is a "Text Box", then "Max Columns" is the length and "Num Rows" is the width of the text box.
If the choice is either a "Radio Per Line" or a "Checkbox Per Line" and the question is not a multi-text question, a value for "Num Rows" greater than 1 will generate the appropriate columns of radio buttons or checkboxes. With the possible exception of the last column, each column will have that number of items.
If the choice type is a "Answer Check", then "Num Rows" is the number of consecutive questions the Answer Check will apply to and the "Max Answers" is the threshold limit for the Answer Check.
If the choice type is a "Randomized Questions", then "Num Rows" is the number of the consecutive questions to be randomized.
The value of "Max Answers" determines the maximum number of allowed responses. The minimum value is 1. For choice types which allow for multiple responses ( i.e. checkbox and mulitple scroll ) a value of 1 means no limit on the nnumber of responses. A value greater than 1 is only relevant when the choice type allows for multiple responses. If the question is a multi-part question, then a value greater than 1 only applies if the first choice type allows for multiple answers.
Randomized AnswersFor choice types which have a selection of values, the order in which these values are displayed will be randomized if this flag is set to Y

The two most important properties are the "question text" and the list of survey choices attached to this survey question. Typically there is only one choice attached to a question survey. Survey creators can create "multi-part" survey questions. A multi-part survey question has more than one attached survey choice attached. The corresponding question text contains text which can be "divided" into subquestion texts. The number of choices must be equal to the number of subquestion texts. (Note for questions which is assigned with an Answer Check choice, the question text is the answer to check for). The Survey Question Editor provides all the necessary functions ( create, edit, and delete) to administer survey questions. This utility also provides an option to perform a html syntax check on all the questions. This option will list any html related errors such as unbalanced bold tags, i.e. no ending bold tag for a starting bold tag.


Life Cycle of a Master Survey

Survey creators typically have a rough layout of the survey. This layout includes the questions and the types of inputs. The survey creator should identify the lists of options ( i.e., lists of displayed options and lists of hidden values ) that are required. Next, the survey creator uses Survey List Editor to create the survey lists which correponds to these lists. It is useful to label the survey lists with some common tag so these survey lists can be easily identified. If you follow this suggestion, you can use that tag as a filter to the Survey List Editor. This filter allows you to operate on survey lists with labels that contain that tag. The survey creator should identify the types of inputs desired and use Survey Choice Editor to create the appropriate survey choices. If you follow the suggestion on labeling your survey lists, you can use that tag as a filter to the Survey Choice Editor. This filter allows you to operate on survey choices with descriptions that contain that tag. Next, the survey creator should determine how many survey subsections are needed and use Survey Subsection Editor to create survey subsections. The Survey Subsection Editor requires that you use your OIT Unix netid/password to authenticate. The survey subsection that you create will have your netid as the owner and only that netid can make changes to the survey subsection. Once you have created a survey subsection, you use Survey Question Editor to administer the survey questions for that survey. When all your survey subsections have been created, you use Master Survey Editor to create your master survey. The Master Survey Editor requires that you use your OIT Unix netid/password to authenticate. This editor displays all the survey subsections that belong to you. You then select from this list the sequence of survey subsections for your master survey. You can set all the other properties for your master survey. At this point your Web survey application is completed and is ready for testing and eventually deployment. The Master Survey Editor provided the following options to administer the master survey:

Clear Netid Responsesdelete the survey responses for a netid
Remove Response Ids from Databasedelete the survey responses for a response id (all respondents are automatically assigned an unique response id)
Eliminate All Responses From DatabaseRemove all survey responses
Get Response CountReturns current number of respondents to survey
Get Subsection Response CountReturns current number of respondents to survey subsection ( user can optionally specify a date filter).
Mark Survey Doneif set then respondent will get "Survey Done" message when attempting to take the survey
Step Thru Master SurveyOption to simulate taking the master survey. Responses are not stored.
Step Thru (Marked Done) Master SurveyOption to simulate taking the master survey which has already been marked done. Responses are not stored.
Lock Master Surveyif this option is used then all objects in master survey( survey subsection, questions, choices, and lists ) are "locked" and can not be editted
UnLock Master Surveythis option undo the "Lock Master Survey" action

It is recommended when you are ready to deploy your survey that your use the "Lock Master Survey" option in the Master Survey Editor to lock all objects that constitute your master survey.

Once you have deploy your survey application, you can use "Get Response Count" or the "Get Subsection Response Count" option to monitor your survey responses. When you are ready to stop taking responses, you use the "Mark Survey Done" option.

Finally you use Dump Master Survey to dump your survey responses. The Dump Master Survey Tool requires OIT Unix netid/password authentication. Survey creators can only dump surveys that belong to them. The survey owner can dump either all the survey responses currently stored in the database at the time of the dump or all the survey responses within a date range (by specify after and before dates) or only the most recent response currently stored in the database. If the survey consists of more than one survey subsections, then the survey owner can specific the survey subsections to dump and the order of the survey subsections to dump.

The response dump output consist of a one line header follow by a line corresponding to the set of answers for each respondent. The one line header contains the text for those survey questions which prompt for a response. For each respondent, the ip address, the response id, and date will also be listed. If the survey is "netid authenticated", the netid, first name, last name, middle name will also be displayed (note that the ip address and netid information can be optionally suppressed and be replaced with the "*" character). The responses are dumped according to the following default rules:

The user can optionally change the default rules to produce different responses dump. The survey responses can be dumped as a Web page or in an Excel-compatible format ( tab delimitered format ). Here is a sample Web dump of the Required And Conditional Demo survey ( as describe later in the Conditional Survey Processing section) with the default rules and a date filter of "After 2/17/2000".

Dump For Subsections[Required And Conditional Demo]

Has[17]Questions

For Responses After Date 2/17/2000


Ip Addr Response Id Date Are you a Princeton alumni?(If you ... Degree Obtained(Check All That Appl... Graduation Year of last Princeton d... Department of last Princeton degree Should Princeton have professional ... If you answer is anything but "Not ... (If applicable)enter your off-campu... If you have entered an off-campus a... Spouse's Degree( Check All That App... Should Princeton University remove ... List the eating clubs you have bick... Enter the number roommates you have Please enter your Masters advisor. Enter your dissertation title. Enter your dissertation advisor. Please explain your current positio... Please describe your bickering expe...
128.112.232.79 25394 02/17/2000 14:16 3 NULL NULL NULL 3 NULL NULL NULL 1 3 NULL 1 NULL NULL NULL NULL NULL
128.112.232.79 25395 02/17/2000 14:18 3 NULL NULL NULL 3 NULL NULL NULL 1 3 NULL 2 NULL NULL NULL NULL NULL
128.112.233.13 32592 04/21/2000 12:00 2 3 1908 Classics 3 Duh! 111 Anywhere Street Wunderbar!! 1;2;3 1 asdfa asdfa asdf a asdf asdf 123 sdfa asdf asdf asdfasdf asdfasdfasdf

If the Excel-compatible format is chosen, the user should either save the results to a filename with the extension .xls or to a filename with the extension .txt. Next use MicroSoft Excel to open that file and use the "Save As" option to save the file as a real Excel file. Once you have saved it as an Excel file, you can Microsoft Access to import the responses from the Excel file to an Access database. Since a Excel worksheet is limited to 65536 rows by 256 columns you will not be able to import beyond those specifications. In those situations, it is best to save to a filename with the .txt extension and use another package such as SPSS to import the data.
The View Survey Subsection tool allows any user to see all the currently defined survey subsections and all the question definitions for a survey subsection. If the user enables the "Show Required Flag Status" feature and selects the "View" option, the question's required status will be displayed as a preface label before the question. The Move Survey Subsection to Another Survey Subsection tool allows survey creators to either copy or move all (or a subset of ) the survey questions from a source survey subsection (note this source survey could be any survey in the survey system) to a destination survey subsection ( note destination survey must already exist and must belong to the survey creator).

Please direct comments, questions and problems reports to request-WWW.html
Last Updated Jan 03,2005