Guidelines for Loading Content Items

Upload content items to item catalogs using HCM Spreadsheet Data Loader (HSDL) or HCM Data Loader (HDL) using spreadsheet templates. These templates are designed to cater to the validations of the content type for which items are getting added or updated.

The following templates are delivered for each content type and can be used to create or update content items:

Template Code	Template Name
ORA_CONTENT_ITEM_PROJECTS	Merge Content Items - Projects
ORA_CONTENT_ITEM_BEHAVIORS	Merge Content Items - Behaviors
ORA_CONTENT_ITEM_ESTABLISHMENTS	Merge Content Items - Establishment
ORA_CONTENT_ITEM_HONORS	Merge Content Items - Honors and Awards
ORA_CONTENT_ITEM_LANGUAGES	Merge Content Items - Languages
ORA_CONTENT_ITEM_COMPETENCIES	Merge Content Items - Competencies
ORA_CONTENT_ITEM_DEGREES	Merge Content Items - Degrees
ORA_CONTENT_ITEM_EDUCATION_LEVELS	Merge Content Items - Education Levels
ORA_CONTENT_ITEM_CERTIFICATIONS	Merge Content Items - Licenses and Certifications
ORA_CONTENT_ITEM_MEMBERSHIPS	Merge Content Items - Memberships

Use the Spreadsheet Templates task in the Data Exchange work area to review these templates. Here you can make copies to customize or grant access to the roles that can use each template. The templates support create and update of content items.

Content item rating levels can be uploaded for the content types that support rating model. The following templates can be used to upload content item rating levels for specific content type:

• Merge Content Items - Behaviors

• Merge Content Items - Competencies

• Merge Content Items - Languages

In the above mentioned 3 templates, 10 instances of content item rating level are exposed. These can be used to override the rating level descriptions associated with the rating model for a given content item. If there are more than 10 rating levels, copy and create a new template and add the required number of instances of the content item rating level.