Example of updating Oracle Learning course publish end dates using HCM Data Loader

Here's how you can update the publish end dates for multiple Oracle Learning courses using the Course.dat file.

1. Create and export a report with the relevant course information.
   1. Go to Tools > Reports and Analytics.
   2. On the Reports and Analytics page, select Browse Catalog. You might need to allow your browser to open the catalog.
   3. On the Catalog page, select New > Analysis.
   4. On the Select Subject Area dialog box, search for and select Workforce Learning - Learning Management Real Time.
   5. On the Untitled page, in the Subject Areas pane, expand the Learning Items folder.
   6. Drag Learning Item Name to Selected Columns.
   7. Expand the Learning Item Type folder.
   8. Drag Code to Selected Columns.
   9. On the Code column, select Settings > Filter.
   10. On the New Filter dialog box, in the Value field, search for and select ORA_COURSE.
   11. Select OK.
   12. On the Untitled page, in the Subject Areas pane, Learning Item folder, drag Learning Item Number to the Selected Columns section.
   13. In the Subject Areas pane, expand the Learning Items > Course Specific Details folder.
   14. Drag Course Effective Start Date to Selected Columns.
   15. In the Subject Areas pane, expand the Learning Items > Learning Item Owner > Worker (Owner) folder.
   16. Drag Person Number to Selected Columns.
   17. On the Results tab, select Export this analysis > Data > Tab Delimited.
   18. Save the file to your device.
2. Create the Course.dat file.
   1. Open a blank Microsoft Excel file.

   2. Copy this content and paste it into cell 1A.

      METADATA|Course|CourseId|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|CoverArtFile|CoverArtFileName|TrailerLiId|TrailerLiNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
      MERGE|Course||||||||||||||||||||||||||

   3. Select cell 1A.
   4. On the Data tool strip, select Text to Columns.
   5. On the Convert Text to Columns Wizard - Step 1 of 3 dialog box, select Next.
   6. On the Convert Text to Columns Wizard - Step 2 of 3 dialog box, in the Delimiters group, select Other.
   7. In the corresponding field enter only the pipe symbol ( | ).
   8. Select Next.
   9. On the Convert Text to Columns Wizard - Step 3 of 3 dialog box, select Finish.

   10. Add a row for each course with a publish end date to update.

       • Start each course row with MERGE.
       • Enter dates in YYYY/MM/DD format.
       • Set EffectiveStartDate to the course effective start date.
       • You can find the course publish start dates by going to My Client Groups > Learning and Development > Learning Catalog. They're in the Start Date column.
       • For OwnedbyPersonNumber, use the person number from your exported analysis.

       Here's how the column headers should look and a sample row of a course to update:

       METADATA|Course|CourseId|EffectiveStartDate|EffectiveEndDate|CourseNumber|Title|ShortDescription|Syllabus|PublishStartDate|PublishEndDate|MinimumExpectedEffort|MaximumExpectedEffort|CurrencyCode|MinimumPrice|MaximumPrice|CoverArtFile|CoverArtFileName|TrailerLiId|TrailerLiNumber|OwnedByPersonId|OwnedByPersonNumber|SourceType|SourceId|SourceInfo|SourceSystemOwner|SourceSystemId|GUID
       MERGE|Course||2019/06/14||OLCxxxxxx|Example Course|||2019/06/14|2019/07/22|||||||||||xxxxxx|||||| 

   11. After you add all the courses to update, in the Microsoft Excel file, select File > Save as.
   12. On the Save As dialog box, set File name to Course.
   13. Set Save as type to Text (Tab delimited)(*.txt).
   14. On the Microsoft Excel dialog box asking if you want to keep the format, select Yes.
   15. Close the Microsoft Excel file.
   16. Go to the location where you saved the file.
   17. Change the file name from Course.txt to Course.dat.
   18. Right-click the Course.dat file and select Open with > Notepad++. You can download and install the app from your browser search if you don't already have it.
   19. In Notepad++, select Search > Replace.
   20. In the Find what field, enter \t
   21. In the Replace field, enter |
   22. Set Search Mode to Extended (\n, \r, \t, \0, \x...).
   23. Select Replace All. This makes sure that the pipe ( | ) is the delimiter, which HCM Data Loader requires.
   24. Save your changes and close the file.
   25. Compress the file as Course.zip
3. Import the course data using HCM Data Loader.
   1. In Oracle Fusion apps, select My Client Groups > Data Exchange.
   2. On the Data Exchange page, search for and select the Import and Load Data task.
   3. On the Import and Load Data page, select Import File.
   4. On the Import File dialog box, browse for and select your Course.zip file.
   5. Review the information.
   6. Select Submit Now.
   7. Refresh the Import and Load Data page to make sure the file loaded without errors.