Skip to main content
Administrator Guide
Last Updated: 2026-11-13
Bulk Update Work Orders With File Uploads

Bulk Update Work Orders With File Uploads

Have these 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.
  1. From the header, select
    More
    Bulk Updates
    .
  2. Click
    New Bulk Update
    .
  3. Click
    Bulk Update Work Orders With File
    .
  4. (Optional) On the
    Select Records
    page, specify criteria for the records you want to update.
    By default, active work orders are selected.
  5. Click
    Next
    .
  6. On the
    Generate Template
    page, select an
    Update Type
    of
    Update Fields
    .
  7. From the drop-down, select the
    Fields to update
    .
  8. 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 the
      Active
      status, and in step 7, you select
      Start Date
      . You have 111 work orders that meet this criteria, so we display the button as
      Export 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.
  9. Enter your data into the CSV file.
    If you click
    Generate Template
    in 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:
    Value
    Description
    A
    Add the additional values to the work order.
    R
    Replace the values currently in the work order.
    D
    Delete 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:
    Field
    Source of Field Value
    Any field that requires a user name
    1. From the header, select
      More
      Users
      .
    2. Click the user and copy the contents of the
      Username
      field.
    Location
    1. From the header, select
      Company Settings
      Organization
      Locations
      .
    2. From the
      Code
      column, copy the code for the location.
    Organization
    1. From the header, select
      More
      Company Settings
      Organization
      Organization Hierarchy
      .
    2. On the
      Organization Hierarchy
      tab, copy the code number for the organization unit.
  10. Save the CSV file.
  11. On the
    Bulk Update With File
    page, click
    Next
    .
  12. Upload your CSV file.
  13. Complete the task:
    Option Description
    Require Approvals (if configured)
    Select to require any configured approvals.
    This field only displays for users with the
    workorder.bulk.skip_approvals
    permission.
    Disable Connectors
    When you disable connectors, the current bulk updates don't sync to Workday HCM via the Workforce Connector.
    You must have the
    workorder.bulk.skip_connectors
    permission.
    Reason for Bulk Update
    Enables you to enter a freeform text explanation for the bulk update. This applies to the entire bulk update, not individual rows.
  14. Click
    Next
    .
  15. Review the information, and click
    Next
    .
  16. 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.
  17. Click
    Confirm Bulk Update
    .
  18. Click
    Confirm
    .
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
More
Bulk Updates
. 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.