CHRS Knowledge Base

Mass Data Update

Updated on

Workflows are not supported in your browser.
Please use a recent version of Chrome, Edge, Firefox or Safari to display this page.

Overview

This job aid shows users how to complete mass Job and Position data updates in CHRS.

Background

  • You can use this procedure to change multiple job and position fields at one time.
  • The process requires a comma-separated values (CSV) file to be uploaded to the PeopleSoft server.

Use separate run controls for updates to Job data and Position data.

The JP Mass Data Upload processor does the following:

  • Verifies that the file has correct headers.
  • Verifies that the data values are usable.
  • Loads the data into the Job and Positoin pages using a component interface.

Slack Channel

We have created a slack channel in the Cal State Tech space to try and help with answering questions about this process.   proj---wa-mass-data-update

Required security roles

  • SWHR: CHR_WA_JPMDU and CHR_WA_JP_MASS_DATA_UPLOAD
  • Campuses: CHR_WA_JP_MASS_DATA_UPLOAD

Begin Workflow

This workflow will guide you through the procedure.

What are you updating?

Prepare the CSV file

Create the CSV file using your own preferred method. Most campuses use the queries to create the CSV files, and then edit as needed.

Verify the CSV file: Excel sometimes adds extra columns or rows that cause the parser to fail.

The CSU_WA_JPMDU_JOB_DATA query includes all the fields that you can update using the mass update process. Use this query to get the header names for your CSV file.

Validate the criteria used in the queries to confirm you are targeting the appropriate population.

Use the query to create the CSV file

Step 1: Navigate to Menu > Reporting Tools > Query > [Query Manager/Query Viewer]

Step 2: Search for the query.

Query Viewer search

Step 3: Run the query query to Excel.

Query Viewer search results

Step 4: Download the XLSX file.

Downloading from a browser

Step 5: Open the Excel file for editing.

Excel file example

Step 6: Delete the row above the header row.

Delete the row above the field headers

Step 7: Edit the file as needed for your mass update.

Do not modify the header names or the header order.

  • You can delete columns or rows as long as you do not change the column order.
  • You can create the CSV files manually, but you must use the required header names.
  • Be careful when dragging cell content down in excel, dates and numeric fields will increment automatically.  
  • If PS Query adds a row above the list of field names, be sure to delete it.  
  • The header row (the row containing field names) must be the first row in the file.

Step 8: Save the file to CSV format.

Create the Job Run Control

Create separate run controls for job and position.

Step 1: Open the Navbar button

Navbar button

Step 2: Navigate to Workforce Administration > CSU Workforce Admin Process > CSU WA JP Mass Data Upload > JP Mass Data Upload

Step 3: Click Add a New Value.

Add a new value

Step 4: Enter a run control ID for Job updates, then click Add.

Run control ID for job

Upload the CSV file

Step 1: Open the Navbar button.

Navbar button

Step 2: Navigate to Workforce Administration > CSU Workforce Admin Process > CSU WA JP Mass Data Upload > JP Mass Data Upload

Step 3: Select the applicable Run Control (for Job or Position).

Step 4: Click the FTP Upload tab.

FTP Upload tab

Step 5: Enter the upload file data:

  1. Select the Job table option.
  2. Select your business unit.
File load fields

Select your upload method

  • Built in will allow CSU FTP Utility setup to be selected.
  • Manual will allow you to type in the file path and file name.

Use this method if the FTP Target has been set up.

Step 1: Select Built in.

built in radio button

Step 2: Select the FTP Target.

FTP target menu

Step 3: Click Upload Input File.

Upload input file button

Step 4: Click Choose File.

Choose file button

Step 5: Locate the file.

Step 6: Click Upload.

Upload button

Step 1: Select Manual.

Manual radio button

Step 2: Enter the manual parameters:

  • File Path
  • File Name
File Path and File Name fields

Make sure to have a slash “/” after the path.

Select Job Options

You are updating Job Data

Step 1. Click the Job Options tab.

Job options tab

Step 2: Select only the fields that you are changing.

Job Data - only the Positions Number options is selected

Step 3: Click Save. Make sure that you are saving to the Job updates run control.

Save button

Prepare the CSV file

Create the CSV file using your own preferred method. Most campuses use the queries to create the CSV files, and then edit as needed.

Verify the CSV file: Excel sometimes adds extra columns or rows that cause the parser to fail.

The CSU_WA_JPMDU_POSITION_DATA query includes all the fields that you can update using the mass update process. Use these queries to obtain header names for your CSV file.

Validate the criteria used in the queries to confirm you are targeting the appropriate population.

Use Queries to create the CSV file

Step 1: Navigate to Menu > Reporting Tools > Query > [Query Manager/Query Viewer]

Step 2: Search for the query.

Query Viewer search

Step 3: Run the query query to Excel.

Query Viewer search results

Step 4: Download the XLSX file.

Downloading from a browser

Step 5: Open the Excel file for editing.

Excel file example

Step 6: Delete the row above the header row.

Delete the row above the field headers

Step 7: Edit the file as needed for your mass update.

Do not modify the header names or the header order.

  • You can delete columns or rows as long as you do not change the column order.
  • You can create the CSV files manually, but you must use the required header names.
  • Be careful when dragging cell content down in excel, dates and numeric fields will increment automatically.  
  • If PS Query adds a row above the list of field names, be sure to delete it.  
  • The header row (the row containing field names) must be the first row in the file.

Step 8: Save the file to CSV format.

Create Position Run Control

Create separate run controls for job and position.

Step 1: Open the Navbar button

Navbar button

Step 2: Navigate to Workforce Administration > CSU Workforce Admin Process > CSU WA JP Mass Data Upload > JP Mass Data Upload

Step 3: Click Add a New Value.

Add a new value

Step 4: Enter a run control ID for Position updates, then click Add.

Run control ID for position

Upload the CSV file

Step 1: Open the Navbar button.

Navbar button

Step 2: Navigate to Workforce Administration > CSU Workforce Admin Process > CSU WA JP Mass Data Upload > JP Mass Data Upload

Step 3: Select the Position Run Control.

Step 4: Click the FTP Upload tab.

FTP Upload tab

Step 5: Enter the upload file data:

  1. Select the Position table option.
  2. Select your business unit.
File load fields

Select your upload method

  • Built in will allow CSU FTP Utility setup to be selected.
  • Manual will allow you to type in the file path and file name.

Use this method if the FTP Target has been set up.

Step 1: Select Built in.

built in radio button

Step 2: Select the FTP Target.

FTP target menu

Step 3: Click Upload Input File.

Upload input file button

Step 4: Click Choose File.

Choose file button

Step 5: Locate the file.

Step 6: Click Upload.

Upload button

Step 1: Select Manual.

Manual radio button

Step 2: Enter the manual parameters:

  • File Path
  • File Name
File Path and File Name fields

Make sure to have a slash “/” after the path.

Select Position Options

You are updating Position data.

Step 1: Click the Position Options tab.

Position Options tab

Step 2: Select only the fields that you are changing.

Position options - Reason and Salary Admin Plan are selected

Step 3: Click Save. Make sure that you are saving to the Position update run control.

Save button

Run the process

Before you run the process, ensure the following conditions have been met:

  • You have uploaded a CSV file.
  • You have selected the applicable options to update.

Step 1: Click the Run Control tab.

Run control tab

Step 2: Click Run.

Run button

Step 3: Click OK.

Proces Scheduler Request

Step 4: Click Process Monitor.

Process Monitor

Step 5: Wait for the Distribution Status to be posted.

Distributions tatus is posted

Step 6: Click Details.

Details link

Step 7: Click View Log/Trace.

view log/trace link

Step 8: Click to review the log file.

log file

Step 9: Confirm the updates were made to Job or Position data.

End of article

Congratulations, you are done!

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Previous Article (job aid) View and Override CSU Hire Dates
Next Article (job aid) SSI/GSI, Prob-to-Perm (L15) Checklist
Do you need an article? Contact Us