CourseV3.datファイルを使用した自己ペース講義による新規コース階層全体のロードの例

まず、CourseV3.datファイルを使用して、CourseV3およびOfferingV3オブジェクトのみをロードします。そのプロセスが正常に完了したら、V3オブジェクトおよびCourseV3.datファイルを使用して、対応するセクションおよびアクティビティをロードします。

1. CourseV3オブジェクトと自己ペースOfferingV3オブジェクトのみのロード

METADATA|CourseV3|CourseId|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|CoverArtFile|CoverArtFileName|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
MERGE|CourseV3||2021/04/28||COURSE-202104280937-HDL|Title:COURSE 202104280937-HDL|ShortDesc:COURSE 202104280937-HDL||2021/04/28|2023/03/01|0|1|USD|0|0||||4|FUSION_HCM_LEARNING|2021042809371|HCM Learning Source Info for 202104280937|||

METADATA|OfferingV3|OfferingId|EffectiveStartDate|EffectiveEndDate|OfferingNumber|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OfferingStartDate|OfferingEndDate|PrimaryInstructorId|FacilitatorType|PrimaryLocationId|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|CourseId|CourseNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingV3||2021/04/28||OFFERING-202104280937-HDL|Title:Offering 202104280937-HDL||ORA_SP|2021/04/28|2023/03/10||||||4|US|5|30||COURSE-202104280937-HDL||4|FUSION_HCM_LEARNING|2021042809372|HCM Learning Source Info for 202104280937|Y|||

2. V3セクションおよびアクティビティ・オブジェクトのロード

COMMENT - Include the parent OfferingV3 row even you don't have any updates, otherwise the load process fails.
METADATA|OfferingV3|OfferingId|EffectiveStartDate|EffectiveEndDate|OfferingNumber|Title|Description|OfferingType|PublishStartDate|PublishEndDate|OfferingStartDate|OfferingEndDate|PrimaryInstructorId|FacilitatorType|PrimaryLocationId|CoordinatorNumber|LanguageCode|MinimumCapacity|MaximumCapacity|CourseId|CourseNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|ShowSectionIfSingleSectionExists|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingV3||2021/04/28||OFFERING-202104280937-HDL|Title:Offering 202104280937-HDL||ORA_SP|2021/04/28|2023/03/10||||||4|US|5|30||COURSE-202104280937-HDL||4|FUSION_HCM_LEARNING|2021042809372|HCM Learning Source Info for 202104280937|Y|||

COMMENT - Edit the default section.
METADATA|OfferingActivitySectionV3|OfferingSectionId|EffectiveStartDate|EffectiveEndDate|OfferingSectionNumber|SectionPosition|OfferingId|OfferingNumber|Title|Description|DescriptionText|NumberOfActivitiesToComplete|CompletionRuleType|SequenceRuleSectionNumber|SequenceRuleType|SourceSystemOwner|SourceSystemId|GUID
MERGE|OfferingActivitySectionV3||2021/04/28||OFFERING-202104280937-HDL_SEC|1||OFFERING-202104280937-HDL||||-1|ORA_COMPLETION_SECTION||ORA_SECTION_ANYTIME|||

COMMENT - Add a self-paced activity to the default section.
METADATA|SelfPacedActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|ActivityPosition|Title|Description|ExpectedEffort|SelfCompleteFlag|CompletionRuleType|SequenceRuleActivityNumber|SequenceRuleType|ContentId|ContentNumber|OfferingSectionId|OfferingSectionNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
MERGE|SelfPacedActivityV3||2021/04/28||SP-ACT1-03282122-HDL|1|Title:SP ACT1 202103282122-HDL||8|Y|||ORA_ACTIVITY_ANYTIME||||OFFERING-202104280937-HDL_SEC||||||

COMMENT - Add a second self-paced activity to the default section.
MERGE|OfferingActivitySectionV3||2021/04/28||OFF-SEC-04012122-HDL|2||OFFERING-202104280937-HDL|Title:OFF-SEC-04012122-HDL||||ORA_COMPLETION_ACTIVITY||ORA_SECTION_PREVIOUS|||
MERGE|SelfPacedActivityV3||2021/04/28||SP-ACT2-03282122-HDL|1|Title:SP ACT2 202103282122-HDL||8|N|||ORA_ACTIVITY_ANYTIME||||OFF-SEC-04012122-HDL||||||

COMMENT - Add an evaluation activity to the offering.
METADATA|EvaluationActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|Title|OfferingId|OfferingNumber|QuestionnaireCode|QstnrRequiredForCompletion|SourceSystemOwner|SourceSystemId|GUID