Skip to end of banner
Go to start of banner

Technician Work Order Assignment Bulk Upload

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »

Bulk Upload Auto- Assign Rules

In Work Order Assignment rules can be created to automatically assign work orders to technicians based on location, trade and periods of time. This time saving feature allows field technician managers to create a set of rules for one or more technicians, one or more trades or one or more locations, and have User Management do the rest.

Note: For each Auto Assign rule that you create, you must enter the Subscriber ID, the technicians email address, the trade, and the subscribers location where the services are to take place.





⦿ How to Use the Bulk Upload Template to Create Auto Assign Work Order Rules
  1. Navigate to Work Order Assignment, Under Work Orders.
  2. Click Bulk Upload.
  3. Select Sample Template, then launch it in your preferred spreadsheet application.
  4. Enter the Subscriber ID, Technician Email Address, Trade and Location for each rule you wish to create.
  5. Save the document as an XLSX formatted file.
  6. Click Bulk Upload, then click +Select File.
  7. Locate the saved template, then click Upload XLSX.
  8. You can review the last upload results by clicking the Click here to download last upload results, which will download the results of your last uploaded rules.



Note: If you submit an Auto-Assign Rule that already exists, an  error will appear in the error column.

Reviewing Current Auto Assign Rules


You can view the current auto assign rules by downloading the Current Rules template, available on the bottom of the Bulk Upload modal. The rules contained within are based on the last auto assign rules uploaded and validated by Service Automation.

⦿ How to Review Current Auto Assign Rules
  1. Navigate to Work Order Assignment.
  2. Click Bulk UpLoad.
  3. Click Current Rules, which will download a template with the current auto assign rules.
  4. Open the template in your preferred spreadsheet reader.

The spreadsheet that opens displays all of the auto assign rules that are currently in place.

Modifying Current Auto Assign Rules via Bulk Upload

The auto assign rules created for technicians can be modified using the Bulk Upload template. This includes removing rules for one or more technicians or adding rules for one or more technicians.

⦿ How to Modify Auto Assignment Rules via Bulk Upload
  1. Navigate to Work Orders > Work Order Assignment.
  2. Click the Bulk Upload button.
  3. Click the  Current Rules Button, which downloads the Current Rules template.
  4. Open the Current Rules template.
  5. You can:
    1. Remove current rules by adding remove next to the rule you want to remove, under the add/remove column;
    2. Add a new rule by entering the required information, Subscriber ID, Tech Email, Trade and Location;
  6. Save the template as a .XLSX  formatted file.
  7. Navigate back to the Bulk Upload modal and upload the template.
  8. To review the modification just made, click the Click here to download last upload results link on the Bulk Upload modal.
  9. Open the template to review that last rules uploaded.

In this Article

Related Articles

  • No labels