1. HCM Data Loading Business Objects
  2. Examples of Loading Questionnaires

Examples of Loading Questionnaires

This topic provides examples showing how to load a questionnaire including the sections, questions, responses, and attachments using HCM Data Loader for the subscriber, Recruiting.

Questionnaire

In this example the Questionnaire.dat file creates a questionnaire using user keys.

  • The questionnaire has one section with one question, and three answer choices.

  • The question created for the questionnaire isn't in the question library.

  • The answers include attachments. Attachment files must be provided in the BlobFiles subdirectory of same the compressed .zip file that you supply Questionnaire.dat file in.

METADATA|Questionnaire|QuestionnaireCode|QstnrVersionNum|QuestionnaireName|Status|SubscriberName|PrivacyFlag|CategoryName|UpdateAllowed|SectionOrder|SectionPresentation|PageLayout|InUse|LatestVersion|TemplateQstnrCode
MERGE|Questionnaire|NVVF1|1|NV_HDL_QSTNR_1009_1|Active|Recruiting|Public|Questionnaire Library|Y|Sequential|Stack Regions|1|No|Y|NV_HDL_QSTNR_1009
METADATA|Section|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|NewPage|SubscriberName|IntroText|Name
MERGE|Section|1|NVVF1|1|Y|Recruiting|A sample section.|Training satisfaction
METADATA|Question|QuestionCode|QstnVersionNum|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|QuestionText|SubscriberName|Status|QuestionType|PrivacyFlag|AdhocQstn|CategoryName|QstnSequenceNumber|ResponseTypeName|ScoredFlag|MaxPossibleScore|MinThresholdScore|AddAttachmentFlag|AttachmentTitle|AttachmentDescription|AttachmentFile|AttachmentFileName
MERGE|Question|NVVF1|1|1|NVVF1|1|How do you rate the HDL Training?|Recruiting|A|Multiple Choice|Public|N|Question Library|5|Check Box with Image|Y|10|6|Y|Introduction||Text.txt|Text
METADATA|Answer|QuestionCode|QstnVersionNum|AnswerCode|LongText|AnsSequenceNumber|Score|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|SubscriberName|AddAttachmentFlag|AttachmentTitle|AttachmentDescription|AttachmentFile|AttachmentFileName|Type
MERGE|Answer|NVVF1|1|NVVF1Answer14|Average|1|8|1|NVVF1|1|Recruiting|Y|Intro||Text.txt|Text|FILE
MERGE|Answer|NVVF1|1|NVVF1Answer16|Very Good|1|9|1|NVVF1|1|Recruiting|Y|Intro||Text.txt|Text|FILE
MERGE|Answer|NVVF1|1|NVVF1Answer18|Excellent|1|7|1|NVVF1|1|Recruiting|Y|extract_runs||extract_runs.xml|extract_runs|FILE

Questionnaire with Attachments

This example shows how to load a questionnaire including the attachments for the questionnaire, question, and response using HCM Data Loader for the subscriber, Recruiting. In this example, the Questionnaire.dat file creates a questionnaire with attachments for the questionnaire, question, and response. The user keys are used to identify each record.

  • The questionnaire has an attachment at the questionnaire-level, question-level, and response-level.

  • The answers include attachments. Attachment files must be provided in the BlobFiles subdirectory of same the compressed zipped file that you supply Questionnaire.dat file in.

METADATA|Questionnaire|QuestionnaireCode|QstnrVersionNum|QuestionnaireName|Status|SubscriberName|PrivacyFlag|CategoryName|UpdateAllowed|SectionOrder|SectionPresentation|PageLayout|InUse|LatestVersion|TemplateQstnrCode
METADATA|QuestionnaireAttachment|AttachmentId|Title|QuestionnaireCode|QstnrVersionNum|SubscriberName|QuestionnaireId|File|FileName|Type
METADATA|Question|QuestionCode|QstnVersionNum|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|QuestionText|SubscriberName|Status|QuestionType|PrivacyFlag|AdhocQstn|CategoryName|QstnSequenceNumber|QstnrQstnResponseTypeName|ScoredFlag|MaxPossibleScore|MinThresholdScore|AddAttachmentFlag|AttachmentTitle|AttachmentDescription|AttachmentFile|AttachmentFileName|DeleteAttachmentFlag
METADATA|Answer|QuestionCode|QstnVersionNum|AnswerCode|LongText|AnsSequenceNumber|Score|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|SubscriberName|AddAttachmentFlag|AttachmentTitle|AttachmentDescription|AttachmentFile|AttachmentFileName|Type
METADATA|Section|SectionSeqNum|QuestionnaireCode|QstnrVersionNum|NewPage|SubscriberName|IntroText|Name
MERGE|Questionnaire|QSTNR_HDL_100|1|Interview Feedback|Active|Recruiting|Public|Questionnaire Library|Yes|Sequential|Stack Regions|1|No|Y|HS_QSTNR_10
MERGE|QuestionnaireAttachment||Instructions|QSTNR_HDL_100|1|Recruiting||Instructions.txt|Instructions|FILE
MERGE|Section|1|QSTNR_HDL_100|1|Yes|Recruiting|Give your valuable feedback|Feedback Section
MERGE|Question|QSTNR_100_QSTN_1|1|1|QSTNR_HDL_100|1|How was the interview experience?|Recruiting|A|Multiple Choice|Public|N|Question Library|5|Check Box with Image|Y|5|1|Y|Introduction||Introduction.png|Introduction|
MERGE|Answer|QSTNR_100_QSTN_1|1|QSTNR_100_QSTN_1_ANS_1|Excellent|1|5|1|QSTNR_HDL_100|1|Recruiting|Y|Option||Option1.png|Option|FILE
MERGE|Answer|QSTNR_100_QSTN_1|1|QSTNR_100_QSTN_1_ANS_2|Good|1|3|1|QSTNR_HDL_100|1|Recruiting|Y|Option||Option2.png|Option|FILE
MERGE|Answer|QSTNR_100_QSTN_1|1|QSTNR_100_QSTN_1_ANS_3|Poor|1|1|1|QSTNR_HDL_100|1|Recruiting|Y|Option||Option3.png|Option|FILE

Related Topics