You are here: Integrations > Bulk Loader

Bulk Loader

Bulk Loader lets you quickly bulk-create or update various LearnCenter training items, bulk-map Users to training, bulk-create and update User training history, and bulk-create and mange schedules for automatic loads from third party systems. All of these tasks can be done using standard template files that are provided for download right on the Bulk Loader page.

The following User Permission is required to view and use this feature: Manage Bulk Loader, sub Permission of Manage Integrations.

See User Permissions and Integrations User Permissions for instructions on granting and denying these User Permissions.

Bulk Loader is particularly useful if you have very large numbers of items to create, update,map, or manage, because it significantly reduces the amount of time and effort needed to complete these tasks. Use cases for using Bulk Loader might include things like:

All of these can be achieved easily and quickly with Bulk Loader. You can even schedule these processes to happen at certain intervals without much intervention from you. See Process for Using Bulk Loader for instructions on using this feature.

Bulk Loader performance is optimized to process source files that have a maximum of 5000 rows.

On the Control Panel:

  1. Click on the Integrations menu to expand it.
  2. Click Bulk Loader.The Bulk Loader is organized into four tabs to logically organize and display the various loader types.
  1. Select the Training tab if you want to bulk-create or update training items and category mappings.

  1. Select the appropriate loader from this tab. The top portion of this page provides you with access to the templates you need to create or update your data. It also provides you with the mechanism for uploading that data to LearnCenter. The available loaders for this tab are:
  1. Select any of the following from the Loader Options section:
  1. To create new records

    AND
  2. To update existing records that match the items in your data file.

This safeguard prevents you from accidentally overwriting events. Note that in general, LearnCenter does not enforce unique training item names. If the Bulk Loader finds more than one training item record with the exact same name, it will generate an error in the results file to call that situation to your attention in order to give you the option to update the training item names to be unique and rerun the data file. Also this option has no effect in the case of Enrollment Users, as the only operation performed there is mapping (enrolling) to the Enrollment.

OR

  1. Select the Users & History tab if you want to manage the mapping of Users to training items and their history. You can create User history or update past, present, and future completions.

  1. Select the appropriate loader from this tab. The top portion of this page provides you with access to the templates you need to create or update your data. It also provides you with the mechanism for uploading that data to LearnCenter. The available loaders for this tab are:
Bulk Loader does not support the use of past completions with recurring Learning Plans.

 

As a best practice with recurring Learning Plans, it is recommended that you do the following: First ensure that Users are not yet assigned to the recurring Learning Plans you are loading. Next, load their Course completions in date order; oldest to newest. Finally, assign Users to the recurring Learning Plans.
  1. Select any of the following from the Loader Options section:
  1. To create new records

    AND
  2. To update existing records that match the items in your data file.

This safeguard prevents you from accidentally overwriting events. Note that in general, LearnCenter does not enforce unique training item names. If the Bulk Loader finds more than one training item record with the exact same name, it will generate an error in the results file to call that situation to your attention in order to give you the option to update the training item names to be unique and rerun the data file. Also this option has no effect in the case of Enrollment Users, as the only operation performed there is mapping (enrolling) to the Enrollment.

  1. Select the Results tab to view all of the data upload attempts you or other Administrators have made.

It also provides you with access to the Source Files that you created and uploaded and the Results File for your upload, which can include information about errors that occurred during the upload process). You can click the up/down arrow at the top of the Date Started and Date Completed columns to sort the results in ascending or descending order by started or completed date and time. You can click the hyperlinks for the Source files and the Results files to display or download them. You will notice that both file types have a naming convention that includes their run dates. This helps you to identify them should you decide to save them on your hard drive. Tip: you can match up the rows in the Source File and the Results files to give you an understanding of what was done for every row of information when the Source File was uploaded.

Both the Source File and the Results file can be up to 10 Mb in size.

The last 10 Source and Results files for each Loader are available on this page. Files beyond 10 are purged from the system on a weekly basis.

Best Practice: It is a best practice to download the source and results for each load to your local computer.

The results file will have one row in the output for every row in the source data file to allow for each matching of any error conditions.

File Purge

Files are purged every Sunday night. The most recent 10 runs are saved.

This number can be raised to as high as 50. Customer Support throughContact Customer Support through My Oracle Support My Oracle Support and open an SR requesting to change the Bulk Loader Table Value if you would like this number changed..

Related Topics IconRelated Topics

 

Copyright © 2010-2018, Oracle and/or its affiliates. All rights reserved.