Data Processing Scripts
Applicable Products
Talent Management - Compensation
Applicable Releases
21.11 and later
Summary
The Data Processing Scripts page stores scripts used by administrators to populate system configurations and other data from CSV files or pulled directly from SmartGrids.
Detailed Information
The Data Processing Scripts page stores scripts used by administrators to populate system configurations and other data from CSV files or pulled directly from SmartGrids. For example, Incentive Goals can be managed in a spreadsheet outside of PeopleFluent Talent Management and then uploaded to the Data File Processing page. A script then processes that data and populates the data in PeopleFluent Talent Management. Scripts also exist to easily copy goals forward from year to year.
To navigate to this page, go to one of the following:
-
Primary Navigation Menu > Compensation Administration > Data Processing Scripts
-
Primary Navigation Menu > Performance Administration > Data Processing Scripts
-
Primary Navigation Menu > Succession Administration > Data Processing Scripts
The Scripts section contains a list of the scripts that are currently stored on the page. Sample scripts are provided, and administrators can write and store custom scripts here that work with their specific data according to their business needs.
The list displays the following columns:
Table: Data Processing Scripts
|
Field |
Description |
|
Edit |
Click to modify the script name, display name, and the script itself. You can also add any notes to help manage your scripts. |
|
Script Name |
The internal name for the script. Names cannot start with a number, contain spaces, or use special characters other than underscores (_). |
|
Script |
The script code. |
|
Syntax Check |
Displays a green check mark icon if the script passes a validation check. If it fails, a red exclamation point icon is displayed instead. Hover over the exclamation point to see the error. |
|
Display Name |
The display name used in the script. This field may use spaces and special characters. |
|
Delete |
An icon that deletes the script.
|
Below the list, the following buttons are available:
Table: Script Buttons
|
Field |
Description |
|
Add |
Click to add a new script. |
|
Validate Set |
Click to check all the scripts on this page for valid syntax. Note that this just validates syntax, it does not verify that the script works as designed. |
Scripts can also use data directly from a SmartGrid without the need to upload a file to the Data File Processing page. In order to pull data directly from a SmartGrid view, the script must reference the grid ID and the view ID. To find this information, go to the SmartGrid that you want to pull data from and click Select View > Manage Views. In the Manage Views dialog box, the grid ID is listed under Grid Type. View IDs are listed in the table below the Grid Type field.
For example, the script would have a line similar to this:
def employeeIDList = DataScriptUtils.getGridData(1234, "viewID");
where 1234 is the grid ID and viewID is the ID of the view.