Load Data Overview

The Data Load Wizard enables organizations to upload a list or table of information into the system, eliminating the need to manually insert individual records. Data can be loaded to different parts of the system with a consistent process, allowing you to upload, review, and import data.

The Data Load Wizard can import new records or adjustments and export existing data in multiple file formats (.xls, .xlsx .csv, .txt). Note: Files loaded via the Data Load Wizard cannot contain HTML encoding. Editable templates and helpful hints guides are available for each file type for accurate importing.

Reporting is available to provide information regarding error logs and counts of records that are added or updated.

To start the Data Load Wizard, go to Admin > Tools > Core Functions > Data Load Wizard, and then click Load Data. The Data Load Wizard opens to the Get Started tab. Select the type of data you are loading and click Next. The available types of data to load are:

Compensation Load Deprecation

The ability to perform Compensation loads using Data Load Wizard (DLW) will begin to be deprecated with the November 2022 Release. Data Load Wizard Compensation loads include Employee Salary, Salary Structure and Individual Targets.

Data Load Wizard is a legacy data load tool, built on older technology, with limited load type support, a dated interface, and slow performance. Edge Import addresses these issues with a modern interface and an intuitive workflow that can support a greater number of concurrent loads, while providing administrators with a delightful user experience.

Learning Load Deprecation

Ability to perform learning data loads using Data Load Wizard (DLW) is deprecated with the May '22 Release. DLW is a legacy data load tool which was built on older technology, is accessed using an older user interface (UI), and experiences slow performance and limited load type support.

Organizations can enable Edge Import in the Edge Marketplace and review the migration and starter guides to help them through the migration steps.

User/OU Load Deprecation

Ability to perform Users and OU data loads and feeds using Data Load Wizard (DLW) was deprecated with an end-of-life in the May ‘22 Release for most customers. End-of-support for most customers occurred in the February ‘22 Release and support for defects related to DLW Users and OU loads and feeds also stopped at this time.

Important: For customers using the following Data Load Wizard features that are not available in Edge Import, we do not recommend migration of Inbound Data Feed (IDF) for Users and OUs from Data Load Wizard to Edge Import at this time:

  • Groups OU load
  • Recruitment and use GUID in Data Load Wizard Users feeds
  • Sensitive Personally Identifiable Information (SPII) fields - Date of Birth/SSN

Customers using the above features will be informed when these features are available in Edge Import and will be given at least three months to deprecate.

Contents

Security

The following permissions relate to the Load Data Wizard functionality:

PERMISSION NAME PERMISSION DESCRIPTION CATEGORY
Data Load Wizard - Competency Bank Enables administrator to load competency bank data via the Data Load Wizard. This permission also enables administrators to track data loads and manage data load templates. This is an administrator permission. Data Load Wizard
Data Load Wizard - Data Load Queue Enables administrator to access the Data Load Queue screen, which displays all data loads, including current and past loads. Constraints can be applied to this permission. However, these constraints do not impact which data loads are visible to the administrator. This is an administrator permission. Data Load Wizard
Data Load Wizard - Group Data Load Enables administrator to load group data via the Data Load Wizard. This permission also enables administrators to track data loads and manage data load templates. This permission cannot be constrained. This is an administrator permission. Data Load Wizard
Data Load Wizard - OUs Enables administrator to load OUs. This permission also enables administrators to track data loads and manage data load templates. This is an administrator permission. Data Load Wizard
Data Load Wizard - Performance Enables administrator to load performance data via the Data Load Wizard. This permission also enables administrators to track data loads and manage data load templates. This is an administrator permission. Data Load Wizard
Data Load Wizard - Resume Enables administrator to load resume data via the Data Load Wizard. This permission also enables administrators to track data loads and manage data load templates. This is an administrator permission. Data Load Wizard
Data Load Wizard - Set User Password Enables administrator to set a default password for new users when loading users. This is an administrator permission. Data Load Wizard
Data Load Wizard - Users Enables administrator to load users. This permission also enables administrators to track data loads and manage data load templates. This is an administrator permission. Data Load Wizard

Note: A user's permissions and constraints to create OUs and users outside of the Data Load Wizard are separate permissions. When assigning these permissions please mimic the constraints of those permissions for a consistent user experience. If an administrator attempts to load data which is restricted to them, they receive an error.

Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard Data Load Wizard