Questions Menu - Import Questions

Instructions:

1. Select Questions Import questions
2. Select the type of format you would like to import the questions from. There are three basic types:
   • Form - The form can be an EZSurvey form file, an EZSurvey question library, or an HTML form file.
   • Document - A document can be a text set of questions or a text spreadsheet of quetions.
   • Database - The database can be an EZSurvey database, ASCII database, or an ODBC database. The database creates questions in the EZSurvey from based off of the database response values.
3. Select Save and then you will be prompted to select the file that you want to import the questions from.

Form

• EZSurvey (form)

  Description:
  Import an EZSurvey form from a .ezf file. An existing EZSurvey form can be imported into the current EZSurvey project.

  Uses

  • Use this when you have an existing EZSurvey form.
  • Use this when you want to import questions into an existing project.
  • Use this when you want an entire form imported.

  Specification:

  Any EZSurvey form or question library can be used to import with this option.

  Example:

  Open an existing EZSurvey form. Select Import questions EZSurvey (form). Select the EZSurvey form file that you want to import. All of the questions from the other file will be imported.

• Question library (form)

  Description

  Import an EZSurvey question library .ezf file. A Question library can be imported into the current EZSurvey project. The question objects will be inserted into the current project.

  Uses

  • Use this when you have an existing Question library.
  • Use this when you want to import questions into an existing project.
  • Use this when you want an entire Question library imported.

  Specification

  Any EZSurvey form or question library can be used to import with this option. It will let you import a .ezf or .ezf file.

  Example

  Open an existing EZSurvey form. Select Import questions Question library (form). Select the EZSurvey form file that you want to import. All of the questions from the other file will be imported.

• HTML (form)

  Description

  This will import a form in an HTML file. It will look at the form fields and try to determine the field names, field types, and possible field responses. All of the form fields should be turned into questions in the EZSurvey project.

  Uses

  • Use this when you want to import an existing web page.
  • Use this when you have lost your EZSurvey form file and all you have is the HTML survey.
  • Use this when you want to save time by importing an HTML file.

  Specification The HTML file that gets imported must have an HTML form in it. All input fields will be defaulted to write-in-text field types.

  Example

  Section title Plain text Write-in text Write-in number How old are you? 0-12 13-18 above 18 How do you feel about ... ? Good Fine Bad Check all that you like? Apples Grapes Tomatoes What is your favorite color? Red Green Blue

  Multiple list One Two Three Combo box (1) One (2) Two (3) Three Rank order  One  Two  Three DATE TIME

Document

• Text (questions)

  Description

  This will import questions from a text file. The questions and responses must be formatted in a specific way in order to be imported.

  Uses

  Use this when all of your questions and response are in text format.

  • Use this when you want to import all of the questions rather than copying and pasting.

  Specification

  The questions and responses must be formatted in a specific way in order to be imported. The question will start with a [questions_XX] where XX is the field name that you want to give the question. On the next line down should be the text of the question. Below that should be [response_XX] where XX is the field name of the response. Followed by the response text on the next line.

  Example

  [question_Q23] How helpful was the class? [response_3] Moderately Helpful [response_2] Slightly Helpful [response_1] Not at all Helpful [question_Q24] Do you like ... ? [response_1] Yes [response_2] No

• Text Spreadsheet (questions)

  Description

  Import questions from a spreadsheet into your current project. Import Spreadsheet question groups from a file as new questions into the survey.

  Uses

  • Use this when you want to import questions with common response values.

  Specification

  The first row of the question set should be FIELDNAME, then a tab, then QUESTIONTEXT, then a tab, then a list of the response field names. The set of rows should be the questions field name, and then the question, and then the response texts. All of the questions will be imported as single choice type questions. You can import more than one sets of questions at a time by putting a line break and then starting a row with FIELDNAME again.

  Example

  FIELDNAME	QUESTIONTEXT	X	5	4	3	2	1
  Q14	How helpful was A?	Did Not Consult	Extremely Helpful	Very Helpful	Moderately Helpful	Slightly Helpful	Not at all Helpful
  Q15	How helpful was B?	Did Not Consult	Extremely Helpful	Very Helpful	Moderately Helpful	Slightly Helpful	Not at all Helpful
  Q16	How helpful was C?	Did Not Consult	Extremely Helpful	Very Helpful	Moderately Helpful	Slightly Helpful	Not at all Helpful
  Q17	How helpful was D?	Did Not Consult	Extremely Helpful	Very Helpful	Moderately Helpful	Slightly Helpful	Not at all Helpful
  Q18	How helpful was E?	Did Not Consult	Extremely Helpful	Very Helpful	Moderately Helpful	Slightly Helpful	Not at all Helpful

Database

• Database (data)

  Description

  This will create questions in the current project based off of fields and responses in a database file. It does not import the data, it just creates new fields and responses. This will create questions in a form by looking through responses in the database file. It will try to determine the field type and create appropriate responses. This is for any ASCII, or EZSurvey data file.

  Uses

  • Use this to create fields in the current project when you only have a database file and no form file.

  Specification

  It will try to determine the field type and create appropriate responses. The database file should have field names and it should be comma or tab delimited. The larger the data file, the more accurate the import tool will be able to determine the type of question or the possible responses it can have.

• ASCII (data)

  This will import a ASCII data file in the same way that Database (data) imports a data file.

• Tab delimited (data)

  This will import a tab delimited data file in the same way that Database (data) imports a data file.

• Comma delimited (data)

  This will import a comma delimited data file in the same way that Database (data) imports a data file.

• ODBC (data)

  Description

  This will import a data table in the same way that Database (data) imports a data file. It select a DSN entry and then show all of the tables. Select a table and then import all of the data from the table as questions.

  Uses

  • Use this to create questions from an existing production database.
  • Any database like SQL Server, Access, MySQL, Oracle, etc, can have an ODBC DSN created and can be used.

  Specification

  The DSN must already exist. You must select the DSN and the table. If needed you must provide the DSN user ID and password.