Bulk End Work Orders With File Upload
- End reasons must exist.
- You must have at least one of the following permissions:
- workorder.end
- workorder.owned.end
- sow.workorder.end
You can end work orders in bulk using a CSV template upload. The
Bulk Update Work Orders with File
functionality enables you to flag work orders for termination and provide an effective end date and time, a time zone, an end reason, and comments in separate template columns.- 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.
- UnderUpdate Type, selectTake an Action.
- Select anUpdate ActionofEnd Work Order.
- 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. 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 for your 111 active work orders.
As you populate the file, consider:- All columns excepteffective_end_datetimeare required.
- Theend_nowcolumn must be Y or N.
- If theend_nowcolumn is set to N, then theeffective_end_datetimemust be populated or the update shows an error message.
- If theend_nowcolumn is Y, then you must entered theeffective_end_timezone,end_reason, andend_comments.
- Save the CSV file.
- On theBulk Update With Filepage, clickNext.
- Upload your CSV file.
- ClickNext.
- Review the information and clickNext.
- Preview the first 100 rows for errors.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.