Import/Export Question Formats

Users with the proper role in the app can import questions into and export questions from change questionnaires and impact questionnaires.

This page discusses:

See Also
Creating a Questionnaire
Creating an Impact Questionnaire Template
Importing Questions Into a Questionnaire

Change Questionnaire Import/Export Format

A specific column and row format is used for importing and exporting questions for change questionnaires. The first row contains the column headers, and each subsequent row contains the question content and attributes. The import file must be saved in the .csv file format. The export file will be exported as a .csv file.

Format

The following format must be used for .csv file containing questions to be imported into a change questionnaire. The same format is used for questions exported from a change questionnaire. There must be a column in the file for each type of information, even if there are no entries for that column. The Question, Sequence Order, and State columns must have entries for each question.

QuestionResponseSequence OrderCommentStateCategory
<text of each question><Response for decision question><Sequence number that specifies question order and sub-question hierarchy><Comments about the question><Lifecycle state of the question: Active or Inactive><Category of question response:
  • Decision
  • Descriptive
>

Example

Following is an example of a table containing questions that can, once saved as a .csv file, be imported into a change questionnaire.

QuestionResponseSequence OrderCommentStateCategory
Is this change related to a product?1Question 1 commentsActiveDecision
Is it a software product?Yes1.1Question 2 commentsActiveDecision
Is it an app?Yes1.1.1Question 3 commentsActiveDecision
Is it a module?No1.1.2Question 4 commentsActiveDecision
Is it related to a service?No1.2Question 5 commentsActiveDecision
The resulting .csv file will contain the following information:

Question,Response,Sequence Order,Comments,State
Is this change related to a product?,,1,Question 1 comments,Active
Is it a software product?,Yes,1.1,Question 2 comments,Active
Is it an app?,Yes,1.1.1,Question 3 comments,Active
Is it a module?,No,1.1.2,Question 4 comments,Active
Is it related to a service?,No,1.2,Question 5 comments,Active

Impact Questionnaire Import/Export Format

A specific column and row format is used for importing and exporting questions for impact questionnaires. The first row contains the column headers, and each subsequent row contains the question content and attributes. The import file must be saved in the .csv file format. The export file will be exported as a .csv file.

Format

The following format must be used for .csv file containing questions to be imported into an impact questionnaire. The same format is used for questions exported from an impact questionnaire. There must be a column in the file for each type of information, even if there are no entries for that column. The Question, Response Type, and State columns must have entries for each question.

QuestionResponse TypeResponse RangeCommentsState
<text of each question><Format for available responses:
  • Checkbox
  • Combobox
  • Listbox
  • Radiobutton
  • Textarea
  • Textbox
>		<Available responses, each separated by | ><Comments about the question><Lifecycle state of the question: Active or Inactive>

Example

Following is an example of a table containing questions that can, once saved as a .csv file, be imported into an impact questionnaire.

QuestionResponse TypeResponse RangeCommentsState
Does this change affect more than one productRadiobuttonYes|NoQuestion 1 commentsActive
How many products are affected by the change?Checkbox1|2|3|4|5Question 2 commentsActive
Which software version is affected?ListboxVersion 1|Version 2|Version 3|Version 4Question 3 commentsActive
Describe the problem.TextareaQuestion 4 commentsActive
The resulting .csv file will contain the following information:

Question,Response Type,Response Range,Comments,State
Does this change affect more than one product,Radiobutton,Yes|No,Question 1 comments,Active
How many products are affected by the change?,Checkbox,1|2|3|4|5,Question 2 comments,Active
Which software version is affected?,Listbox,Version 1|Version 2|Version 3|Version 4,Question 3 comments,Active
Describe the problem.,Textarea,,Question 4 comments,Active