Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Assets

Template

Assets can be added in bulk, using one of the supplied templates. Adding assets using the template allows you to add multiple assets, of the same asset type, at once, therefore simplifying the process. When No Template (Custom Attributes) is used, any excel template with your own unique attributes for assets can be added. When uploaded into Service Automation, there is a mapping process to convert your unique attributes to the ones within Service Automation. When uploads are completed, a history for each individual upload is available. It includes the:

  1. File name
  2. Asset Type
  3. Record Added/Upload
  4. Provider (If template uploaded by a provider)
  5. User
  6. Date
  7. Back Up File (Downloadable excel file)
  8. Results File (Downloadable excel file)

Service Automation provides three different templates for uploading assets and adding asset tags to assets. The templates are located under the Imported Assets link in Asset Manager:

  • Excel Template (Standard Attributes Only)
  • Excel Template (All Attributes)
  • Excel Template (Asset Tags)

The "Excel Template (All Attributes)" and "Excel Template (Asset Tags)" only have columns' headers. You will not be provided with prompts on how to fill out the fields. The "Excel Template (Standard Attributes Only)" provides you with hints as to the type of data you should enter in a particular field.

Page for uploading assets via templatesImage RemovedImport Assets PageImage Added

Note

The fields are case sensitive. Therefore, when entering Asset Types for your coffee machines, you must enter “Coffee Machines”, not “coffee machine”.

Navigating Asset Template Columns

The columns in the template will indicate which are required and optional. Adding as much information onto the template helps with repair and maintenance as well as data collection on the assets. All or Custom attributes have the same attributes as Standard Attributes plus columns related to refrigerant assets. 


Info

The follow attributes with an * asterisk is required information for the template. 


Standard Attributes:

  1. *Asset Type: Must be validated against the Asset Type list against the Asset Module.
  2. *Location: Location ID in Service Automation.
  3. Area: Free text field to help identify the asset.
  4. *Work Order Area: Drop-down to select work order area for the asset.
  5. *Tag ID: Unique name to identify specific asset.
  6. *Brand: Name or producer of the asset.
  7. *Model No: Specific type of asset.
  8. *Serial No: Asset’s unique identity number.
  9. *Install Date: Date which the asset has been installed.
  10. *Manufactured Date: Date which the asset was built.
  11. *Purchase Date: Date for when the asset was bought.
  12. *Condition: Asset is either: broken, poor, average, good or excellent.
  13. *Is Leased: Is the asset being borrowed. (True or False)
  14. Lease Date: Start date for the leasing contract.
  15. Lease Period: Number of months the asset is being leased.
  16. Warranty Period: Number of months for the warranty on the asset.
  17. Warranty Provider: The external technician who will service the warranty.
  18. Warranty Starts from Install Date: If true, starts from install date, if false, starts from purchase date.
  19. Warranty Category: Select a category for the warranty work order.
  20. Warranty Priority: Select a priority for the warranty work order.
  21. Life Expectancy (months): Longevity of the asset.
  22. Original Value: Cost of the asset.
  23. Currency: Type of money used to buy the asset.
  24. Energy Efficiency: Specific energy efficiency of the asset.
  25. Capacity: Maximum amount of weight the asset can contain.
  26. Asset Tag: Specific identify for scanning and validating.
  27. Deactivated: Is the asset deactivated. (True or False)
  28. Has Component: A part that helps with other parts for the asset. (True or False)
  29. Has Circuit: A system within an asset that performs a task. (True or False)
  30. *Asset Status: Whether the asset is verified. Confirm or Unconfirmed.
  31. *Asset Repair Status: Is the asset being used. In Use or Out for Repair

All or Custom Attributes:

  1. CARB ID: California Air Resources Board number
  2. System Location: Indoor or Outdoor or both.
  3. *Total Charge: Amount of coolant in the asset.
  4. Vendor: Refrigerant Asset external technician.
  5. Has Leaked Detector: Does the asset have a leak detector. (True or False)
  6. *Rack ID: Unique number for rack asset.
  7. *Description: EPA calculation method.

Asset Tags:

  1. Location ID: Location for the asset.
  2. Tag ID: Unique asset name.
  3. Asset Tag: Unique name for scanning and validating.
Adding Assets of the Same Asset Type via Template

Receiving Error Messages During Upload

Image Added

Certain columns go through a validating process on the content. For example, validating occurs on the Asset Type column to compare and match with Service Automation before the upload process happens.


Image Added

Once the file is processed and the information are inaccurate, it provides a new file with error messages on what needs changing for a successful upload.


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Add Multiple Assets of the Same Asset Type
  1. Navigate to the Imported Assets link in Asset Manager.

  2. Select the Upload Assets link.

  3. Download either the "Excel Template (Standard Attributes Only)" or "Excel Template (All Attributes)" template by clicking the corresponding link.
    Image RemovedUnder Download Template, use the drop-down arrow to select either Standard or All Attributes
    Download Template drop-downImage Added

    Note

    The "Excel Template (Asset Tags)" template is only for uploading asset tags.

    1. For the "Standard Attributes" template: Enter the desired Asset Type name in the corresponding field, and provide the required information.

    2. For the "All Attributes" template: Locate the desired Asset Type in the template, and add the information for this Asset Type. Then, remove all other asset types from the file.
  4. Add information onto template
  5. Save the file in the XLSX file format.

    Note

    The Asset Type field in the template is case sensitive and must be entered as listed under Asset Types.

    If an Asset Type has one of its attributes set to “hidden” and you enter a value on the spreadsheet for that attribute, you will receive an error when you attempt to upload the template.

    Error upon uploading the assets via templateImage Removed

    Click the corresponding Select .xlsx File button, and then navigate to the location where you saved the XLSX file.

  6. Under Upload Assets, use the drop-down arrow to select Standard or All Attributes
    Upload Template drop-downImage Added

  7. The system has validated the upload, click the Confirm Importbutton to complete the process
    Confirm buttonImage Added

  8. The upload information is available for viewing and downloading. Confirming the assets' template uploadImage Removed


Note

Depending on the number of assets being uploaded, there may be a slight delay while the system processes the upload. Therefore, recently uploaded asset files will appear as "Queued" until they are completely processed. Queued asset uploadsImage Removed

Adding Assets of Different Asset Types via Template

Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Add Assets of Different Asset Types via Template
  1. Navigate to the Imported Assets link under Assets (Equipment).

  2. Select the Upload Assets link.
    Imported Assets section in Asset ManagerImage Removed

  3. Select the Excel Template (All Attributes)This file will list all of the Asset Types currently loaded into Service Automation. 

  4. Open the template in a spreadsheet reader that can save files in the XLSX file format.Under Download Template, use the drop-down arrow to select All Attributes
    Download Template drop-downImage Added

  5. Locate the Asset Typethen add the information for the first Asset Type.

  6. Continue adding information for subsequent assets of the same type as the previous asset type.

  7. Locate the next Asset Type, then add the information for that asset type.

  8. When you have added all of the assets you want to upload, remove all other asset types from the file.

  9. Save the file in the XLSX file format.

  10. Click the Select .xlsx File (All Attributes) button.

  11. Select the template file, then click the Open button. The Template will begin to upload. The template will undergo validation:

  12. If validated, you have nothing more to do.

  13. If the template fails validation, download and review the error report, then fix the template and re-upload it.

  14. Under Upload Assets, use the drop-down arrow to select All Attributes
    Upload Template drop-downImage Added
  15. Click the Confirm button to finalize the process

    Note

    Depending on the number of assets uploaded, there may be a slight delay with processing.


  16. The upload process becomes available for viewing


Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to Add Assets with No Template
  1. Navigate to the Imported Assets link under Assets (Equipment)

  2. Create custom assets list
  3. Save the file
  4. Under Upload Assets, use the drop-down arrow to select No Template to open the Column Mapping modal
  5. Use the modal to match the excel fields with the Service Automation fields
    Column mapping modalImage Added

    Info

    When making a Service Automation field selecting, the upload field checkbox must be checked. 


  6. Click the Import button to add the No Template assets

  7. Click the Confirm button to finalize the process

  8. The upload process becomes available for viewing and downloading


Live Search
spaceKeySCU
placeholderSearch our Knowledge Base
typepage
labelsfm

Panel
titleColor#ffffff
titleBGColor#5fa7d0
borderStylegroove
titleIn this Article

Table of Contents
maxLevel3
minLevel2
indent20px

Panel
titleColorwhite
titleBGColor#75a346
titleRelated Articles

Filter by label (Content by label)
showLabelsfalse
max8
showSpacefalse
sorttitle
cqllabel in ( "assetadministration" , "assethistory" , "assetintelligence" , "assetmanager" , "assetmanageradministration" , "assetrepairhistory" , "assetupload" , "importassets" ) and space = currentSpace ( )