Bulk Update Work Orders With File Uploads
Have these permissions:
- workorder.update
- workorder.owned.update
- Any necessary field-level permissions. See: Bulk Update Permissions.
You can update multiple fields across multiple work orders with 1 file upload. When you select the fields to include, VNDLY provides a dynamic file template to download.
You can add 1 work order per row of the file and can update 1 or more supported fields for each work order row. The only required field is the unique Work Order Identifier, which is always the first column of the template.
You can use this feature to bulk update these fields on work orders:
- Additional Managers
- End Date
- Exempt Status
- Expense Approvers
- Expense Type
- Job Type
- Location
- Organization Unit
- Overtime Profile
- Pre-VNDLY Invoiced Amount
- Program Team
- Program Team Users
- Reason for Hire
- Resource Managers
- Standard Hours/Week
- Start Date
- Timekeepers
- Timesheet Approvers
- Title
- Update Tax Override
- VNDLY Custom Fields
- Workday Custom Fields
- Work Type Profile
The maximum file size is 10 MB.
You can only clear or delete specific fields. For more information, see the
D
option in the table on step 9.- From the header, select .
- ClickNew Bulk Update.
- ClickBulk Update Work Orders With File.
- (Optional) On theSelect Recordspage, specify criteria for the records you want to update.By default, active work orders are selected.
- ClickNext.
- On theGenerate Templatepage, select anUpdate TypeofUpdate Fields.
- From the drop-down, select theFields to update.
- Click either:
- Generate Template. VNDLY generates and downloads a comma-separated value (CSV) file where you can manually enter the work order IDs and field values for the work orders you want to update.
- Export # records to file. VNDLY generates and downloads a CSV file that’s automatically populated with work order IDs, fields, and field values based on the records you selected. Example: In step 4, you choose to update work orders in theActivestatus, and in step 7, you selectStart Date. You have 111 work orders that meet this criteria, so we display the button asExport 111 records to file. When you click this button, VNDLY generates and downloads a template that includes the work order IDs and existing start date values for your 111 active work orders.
- Enter your data into the CSV file.If you clickGenerate Templatein step 8, the file contains sample data in the correct format for each field on row 2. VNDLY doesn't process this row.For all fields that can have multiple values, the CSV file contains a corresponding update-type column. These are valid values for update-type columns:ValueDescriptionAAdd the additional values to the work order.RReplace the values currently in the work order.DDelete or clear existing values for the fields.This option is available for these fields only:
- Additional Managers
- Expense Approvers
- Program Team Users
- Timesheet Approvers
Find the values to enter into the supported fields on the CSV file:FieldSource of Field ValueAny field that requires a user name- From the header, select .
- Click the user and copy the contents of theUsernamefield.
Location- From the header, select .
- From theCodecolumn, copy the code for the location.
Organization- From the header, select .
- On theOrganization Hierarchytab, copy the code number for the organization unit.
- Save the CSV file.
- On theBulk Update With Filepage, clickNext.
- Upload your CSV file.
- Complete the task:
Option Description Require Approvals (if configured)Select to require any configured approvals.This field only displays for users with theworkorder.bulk.skip_approvalspermission.Disable ConnectorsWhen you disable connectors, the current bulk updates don't sync to Workday HCM via the Workforce Connector.You must have theworkorder.bulk.skip_connectorspermission.Reason for Bulk UpdateEnables you to enter a freeform text explanation for the bulk update. This applies to the entire bulk update, not individual rows. - ClickNext.
- Review the information, and clickNext.
- Preview the rows for errors.The first 100 rows display, you can continue through if needed. If there are errors, correct the CSV file. Save and upload it again.In the preview, you can click any work order row to display the before and after values of all the fields that VNDLY will update.
- ClickConfirm Bulk Update.
- ClickConfirm.
When any field updates fail, all changes for that worker order fail, but VNDLY continues to process the remaining work orders in the file.
A company restructures an organization unit and moves a group of workers to a different organization unit. This impacts a work order that now needs multiple fields updated.
To access the bulk update results, from the header, select . You can view details of each work order updated by clicking the bulk update. To access work orders, click the icon next to the number in the
Work Order ID
column.