Decision Tree Import/Export Formats

Regulatory Affairs Managers can import questions into and export questions from decision tree templates.

This page discusses:

A specific column and row format is used for importing and exporting questions for decision tree templates. 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 decision tree template. The same format is used for questions exported from a decision tree template. 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, State, and Category 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 decision tree template.

QuestionResponseSequence OrderCommentStateCategory
Question 11Question 1 commentsActiveDecision
Question 1.1Yes1.1Question 2 commentsActiveDecision
Question 1.1.1Yes1.1.1Question 3 commentsActiveDecision
Question 1.1.2No1.1.2Question 4 commentsActiveDecision
Question 1.2No1.2Question 5 commentsActiveDecision
The resulting .csv file will contain the following information:

Question,Response,Sequence Order,Comments,State,Category
Question 1,,1,Question 1 comments,Active,Decision
Question 1.1,Yes,1.1,Question 2 comments,Active,Decision
Question 1.1.1,Yes,1.1.1,Question 3 comments,Active,Decision
Question 1.1.2,No,1.1.2,Question 4 comments,Active,Decision
Question 1.2,No,1.2,Question 5 comments,Active,Decision