Example for Loading an Entire New Specialization Hierarchy with Sections and Activities Using the SpecializationV3.dat File

First you load only the SpecializationV3 object using the SpecializationV3.dat file. After that process successfully completes, you load the corresponding sections and activities using the V3 objects and the SpecializationV3.dat file.

1. Load Only the SpecializationV3 Object

METADATA|SpecializationV3|SpecializationId|EffectiveStartDate|EffectiveEndDate|SpecializationNumber|Title|ShortDescription|Description|PublishStartDate|PublishEndDate|CoverArtFile|CoverArtFileName|SourceType|SourceId|SourceInfo|OwnedByPersonId|OwnedByPersonNumber|MinimumExpectedEffort|MaximumExpectedEffort|SourceSystemOwner|SourceSystemId|GUID|DescriptionText|ShowSectionIfSingleSectionExists
MERGE|SpecializationV3||2021/08/02||HDLSPEC1_451_0208|SpecializationV3 HDL 0208|Test Short Description||2021/08/02||||||||4|15|30|||||Y

2. Load V3 Section and Activities Objects

COMMENT - Include the parent SpecializationV3 row even you don't have any updates, otherwise the load process fails.
METADATA|SpecializationV3|SpecializationId|EffectiveStartDate|EffectiveEndDate|SpecializationNumber|Title|ShortDescription|Description|PublishStartDate|PublishEndDate|CoverArtFile|CoverArtFileName|SourceType|SourceId|SourceInfo|OwnedByPersonId|OwnedByPersonNumber|MinimumExpectedEffort|MaximumExpectedEffort|SourceSystemOwner|SourceSystemId|GUID|DescriptionText|ShowSectionIfSingleSectionExists
MERGE|SpecializationV3||2021/08/02||HDLSPEC1_451_0208|SpecializationV3 HDL 0208|Test Short Description||2021/08/02||||||||4|15|30|||||Y

COMMENT - Edit the default section.
METADATA|SpecializationV3|SpecializationId|EffectiveStartDate|EffectiveEndDate|SpecializationNumber|Title|ShortDescription|Description|PublishStartDate|PublishEndDate|CoverArtFile|CoverArtFileName|SourceType|SourceId|SourceInfo|OwnedByPersonId|OwnedByPersonNumber|MinimumExpectedEffort|MaximumExpectedEffort|SourceSystemOwner|SourceSystemId|GUID|DescriptionText|ShowSectionIfSingleSectionExists
MERGE|SpecializationV3||2021/08/02||HDLSPEC1_451_0208|SpecializationV3 HDL 0208|Test Short Description||2021/08/02||||||||4|15|30|||||Y

COMMENT - Add another section.
METADATA|SpecializationSectionV3|SpecializationSectionId|EffectiveStartDate|EffectiveEndDate|SpecializationSectionNumber|Title|Description|DescriptionText|CompletionRuleType|NumberOfActivitiesToComplete|SequenceRuleType|SequenceRuleSectionNumber|InitialAssignmentStatusOfActivities|SectionPosition|SpecializationId|SpecializationNumber
MERGE|SpecializationSectionV3||2021/08/02||HDLSPEC1_451_0208_SEC|Default Section||Update default section||||||1||HDLSPEC1_451_0208
MERGE|SpecializationSectionV3||2021/08/02||HDLSPEC1_451_SEC2|Section 2||Description::Section2|ORA_COMPLETION_SECTION|-1|ORA_SECTION_PREVIOUS||ORA_ASSN_REC_ACTIVE|2||HDLSPEC1_451_0208

COMMENT - Add activities to the second section.
METADATA|SpecializationSectionActivityV3|ActivityId|EffectiveStartDate|EffectiveEndDate|ActivityNumber|SpecializationSectionId|SpecializationSectionNumber|CourseLearningItemId|CourseLearningItemNumber|SequenceRuleType|SequenceRuleActivityNumber|ActivityPosition|ActivityCompletionType
MERGE|SpecializationSectionActivityV3||2021/08/02||HDLSPEC1_451_S1_A1||HDLSPEC1_451_0208_SEC||COURSE-202104280937-HDL|||1|ORA_REQUIRED