The following question import template uses the import range name upsfr and contains a table named tControlsItem. The table includes only some of the available fields.
Tables must include the following fields that are marked required and may include any or all of the other fields.
ControlsItemKey—Integer field key (required)
ControlsItemTag—Question ID (required)
ControlsGroupKey—Group (required)
ControlsSectionKey—Section # (required)
ControlsItemObjective—Text that identities the purpose of the question
ControlsItemType—F (Financial), O (Operations), C (Compliance)
ControlsItemRisks—Risks associated with the question
ControlsItemRiskLikelihood—1 through 5
ControlsItemFocus—Text of the question
ControlsItemCommentRequired—True or False
ControlsItemSequence—Order in which the question is presented
ControlsItemHasLinks—True or False (required)
ControlsItemInactive—True or False (required)
ControlsItemExpectedRespones—Yes or No
ControlsItemActivationDate—Date that the question starts beings used (required)
ControlsItemDeactivationDate—Date that the question stops being used (required)
Each field that is to be imported must be included in a named range (expressed in the format upsxxx). You need not import all fields. You can import the general framework of a question and update in FDM.
Note: | In Excel files, format dates as text. |