1. HCM Data Loader
  2. How You Test the HCM Spreadsheet Data Loader Process Flow and Connections

How You Test the HCM Spreadsheet Data Loader Process Flow and Connections

Before you attempt to load your own data, you may want to test HCM Spreadsheet Data Loader end-to-end processing without creating unwanted data. This topic describes how to test HCM Spreadsheet Data Loader end-to-end processing.

Testing End-to-End Processing

To test end-to-end processing, you use:

  • A process, Test HCM Data Loader Process Flow and Connections

  • An object, Example Object

When you run the Test HCM Data Loader Process Flow and Connections process, you set the Action parameter to Test HCM Spreadsheet Data Loader. The process:

  1. Generates a .csv file of data for the example object

  2. Initiates HCM Spreadsheet Data Loader to import and load the file

  3. Creates a log file, which you can access on the Scheduled Processes page

Approximately 200 hundred records of example data are imported and loaded to the object's own tables. No data is saved to the application tables.

The Example Object

The example object:

  • Has child and grandchild components

  • Supports create and update actions

  • Has attributes of most data types

A predefined spreadsheet template is provided for the example object. The generated .csv file is based on this template.

Deleting the Test Data

You're recommended to run the Test HCM Data Loader Process Flow and Connections process periodically to delete the test data and associated data sets. When you run the process, you set the Action parameter to Delete test data. The process deletes all example data, regardless of whether the data was created by HCM Data Loader or HCM Spreadsheet Data Loader. It generates a file of HCM Data Loader DELETE instructions, adds the file to the DeleteExampleObject||<date and time>||.zip file, and uploads it.