Connecting Assets to an Issue List in Dashboard

Owned by Lamont Eddins
Last updated: Oct 29, 2024 by Veronika Maishutovich

Once you have created a list of asset types and assets in Asset Manager, you need to associate your assets with an issue list in Dashboard. Assets added to a dashboard become selectable when you are creating a service request.

In order for assets to receive proper maintenance or repair, connecting all assets to the issue list is vital. The dashboard is able to recognize and support the process of creating a work order for an asset. You can connect assets to the issue list by:

  • Asset Type Name
  • Asset Type ID
  • Asset Type Trade

Asset type details page where you can copy the asset type name or ID

Connecting Assets by Asset Type Name

Connecting assets to the issue list requires the Asset Type Name to be added onto the issue list under the equipment column. This allows the issue list to identify the equipment added as an asset when work orders are created. For example, if a dishwasher is one of the assets that may require a work order, dishwasher would be added on the equipment line on the issue list.

⦿ How to Associate an Asset Type to its Asset Type Name on an Issue List
  1. Navigate to the Assets (Equipment) > Manage Asset Types.

  2. Click the Export Asset Types button.
    Downloading the list of asset types

    Save this file as you will need it later to associate assets with an issue list.

  3. Navigate to your dashboard, click the main menu in the upper-left corner, and select Convert Issue List.

  4. Locate the Issue List you want to modify, and download it. Then open the file.
    Downloading an issue list from the Convert Issue List page
  5. On the Issues tab of the issue list, enter the Asset Type Name in the Equipment column.
    Entering asset type names in the Equipment column
  6. In the EquipmentEntry column, specify whether users must always associate work orders with assets or this step should be optional for them.
    1. Enter Optional to allow users to skip the step of linking a work order to an asset.
    2. Enter Required to make this step mandatory.
      Specifying whether the equipment entry is required or optional
  7. Save the issue list as an XLSX file.
  8. Navigate back to the Convert Issue List section, and click Upload New Issue List.
    Uploading a new issue list on the Convert Issue List page
  9. Click Select File on the modal that opens.
    Overlay where you upload a new issue list
  10. Click the Upload button to upload the file. Once the file has been validated by the system, close the modal. 
  11. Drag the file to the appropriate dashboard on the right side.
    Drag the desired issue list from the left column to the required dashboard in the right column
  12. Navigate to the Edit Dashboard Settings section > Request tab, and ensure that the Enable Asset checkbox is selected. This checkbox allows you to make the assets list visible during the work order creation process.
  13. (When applicable) Select the Enable Asset Replacement Flag on the Request tab of your dashboard settings to activate the Replace option (in addition to the Repair option) on the assets list during the work order creation process. 

You have associated assets with your issue list and now can start creating work orders linked to assets in your dashboard.

Connecting Assets by Asset Type ID

A system generated Asset Type ID has been added to all Asset Types. This added feature strengthens the connection between the assets and the Issue List. Most of what the feature does happens in the background, out of sight of most users. However, for those who use languages other than English,  you will be able to associate an asset type to a problem code by the asset type ID rather than the asset type name. 

⦿ How to Associate an Asset Type to its Equipment ID on an Issue List
  1. Navigate to the Assets (Equipment) > Manage Asset Types.

  2. Click the Export Asset Types button.
    Downloading the list of asset types

    Save this file as you will need it later to associate assets with an issue list.

  3. Navigate to your dashboard, click the main menu in the upper-left corner, and select Convert Issue List.

  4. Locate the Issue List you want to modify, and download it. Then open the file.
    Downloading an issue list from the Convert Issue List page
  5. On the Issues tab of the issue list, add a new column before the Troubleshooting column, and name it EquipmentId.
    Adding a new column called EquipmentId to the issue list
  6. Using the Equipment column as a guide, enter the corresponding asset type ID from the asset types file you downloaded into the EquipmentId column. Your resulting file should look like this:
  7. In the EquipmentEntry column, specify whether users must always associate work orders with assets or this step should be optional for them. 
    1. Enter Optional to allow users to skip the step of linking a work order to an asset.
    2. Enter Required to make this step mandatory.
  8. Save the issue list as an XLSX file.
  9. Navigate back to the Convert Issue List page, and click Upload New Issue List.
    Uploading a new issue list on the Convert Issue List page
  10. Click Select File on the modal that opens.
    Overlay where you upload a new issue list
  11. Click the Upload button to upload the file. Once the file has been validated by the system, close the modal. 
  12. Drag the file to the appropriate dashboard on the right side.
    Drag the desired issue list from the left column to the required dashboard in the right column
  13. Navigate to the Edit Dashboard Settings section > Request tab, and ensure that the Enable Asset checkbox is selected. This checkbox allows you to make the assets list visible during the work order creation process.
  14. (When applicable) Select the Enable Asset Replacement Flag on the Request tab of your dashboard settings to activate the Replace option (in addition to the Repair option) on the assets list during the work order creation process. 

You have associated assets with your issue list and now can start creating work orders linked to assets in your dashboard.

As you update your Issue List remember to add the Asset Type ID, which ensures that the correct assets appear when you are creating a service request. 

Test creating a work order for the asset types where the equipment ID has been added to ensure that it is working as expected.

When you are creating a service request, you will be asked to associate your work order with an asset.

Select an asset to associate with your work order

Connecting Assets by Asset Type Trade

Alternative to using a specific numeric ID, you can associate an asset to a work order by Trade. As you add assets to your inventory, this will allow you to not have to update the Issue List every time because it will already be accounted for by Trade association—Primary only or Primary and Secondary Trades.

⦿ How to Associate an Asset Type to its Equipment ID on an Issue List
  1. Select the Issue List you would like to modify. See Modifying the Issue List if you need a refresher.
  2. On the Issues tab of the issue list, add a new column before the Troubleshooting column, and name it EquipmentId.
    Adding a new column called EquipmentId to the issue list
  3. In the EquipmentID Column, enter either Primary Trade or Trade.
    When you choose Primary Trade, all assets that have the same primary trade that is listed in the Trade column for this issue will populate.


    Alternatively, enter Trade and all assets that have the same trade listed as the Primary or additional trade will populate as asset choices to choose when creating a work order.

    Ex: The hot water heater has Primary trade listed in the Equipment ID. The Primary Trade listed is Electrical. So all assets that have Electrical as the primary trade will populate during work order creation.


    If we choose Trade, any assets that have Electrical listed as primary or additional trade will populate.

  4. In the EquipmentEntry column, specify whether users must always associate work orders with assets or this step should be optional for them.
    1. Enter Optional to allow users to skip the step of linking a work order to an asset.
    2. Enter Required to make this step mandatory.
    3. Blank will not pull up any assets.
  5. Save the issue list as an XLSX file.
  6. Upload New Issue List. If you need further details see Modifying an Issue List.
  7. Navigate to the Edit Dashboard Settings section > Request tab, and ensure that the Enable Asset checkbox is selected. This checkbox allows you to make the assets list visible during the work order creation process.

    You may also want to check Asset Not Listed in the event that the asset that needs repair is not showing in the list. This will allow the you to still create the work order and add in the asset later.

  8. (When applicable) Select the Enable Asset Replacement Flag on the Request tab of your dashboard settings to activate the Replace option (in addition to the Repair option) on the assets list during the work order creation process.


You have associated assets with your issue list and now can start creating work orders linked to assets in your dashboard.


Test creating a work order for the asset types where the equipment ID has been added to ensure that it is working as expected.

Formatting Alert: UTF-8 Format Required
When uploading information in the form of Spreadsheets, Templates, Text Documents and or copied and pasted to Service Automation or Provider Automation, the Content must be UTF-8 formatted. Content that is not UTF-8 formatted may be misread by our system and cause errors in how your data is interpreted.


 Windows Specific

Windows Specific

Open file in Notepad

Choose Save As

There are three items to update in the Save dialog that comes up.

Save as type: change this to All FilesFile

Name: name your file and add the .csv extension to it - e.g.: myupdates.csv

Encoding: click on the dropdown and choose UTF-8

Save!

 MAC Specific


Mac Specific

  1. Open file in Number
  2. Hover over Export

  3. In the submenu that appears, choose CSV
  4. Click on Advanced Options to show the Text Encoding dropdown
  5. Select Unicode (UTF-8) from the dropdown menu

  6. Click Next Export!




 Google Sheets Specific

Google Sheets

  1. Click File
  2. Click on or hover over Download As

  3. Choose the option Comma-separated values (.csv, current sheet)

  4. After clicking on that option, your file will be automatically downloaded to your computer


In this Article

Related Articles