Import Equipment Records

Things to Consider

  • Required User Permissions

  • Imported equipment categories, types, makes, models, and custom statuses are added to the tool's configuration settings.

  • The fields Equipment ID, Status Type, Status, Category, Type and Ownership are required.

  • If using the following custom statuses, the must have the following status types:

    • 'Available' needs an 'Available' status type.

    • 'Active' needs an 'In Use' status type.

    • 'Inactive' needs an 'Unavailable' status type.

  • The document must be in .xlsx format.

Steps

Prepare Equipment Records for Import

  1. Navigate to the company's Equipment tool.

  2. Click Import.

  3. Click Download Excel Template to download the template.

  4. Enter your equipment information into the spreadsheet:

    • Equipment ID. The unique ID for the piece of equipment.

    • Name. The name of the equipment.

    • Status Type. The category for the custom status:

      • Available

      • In Use

      • Unavailable

    • Status. The custom status name. See Configure Custom Statuses for Equipment.

    • Category. The category of equipment. Example: Earthmoving Equipment, Lifting Equipment, etc.

    • Type. The type of equipment. Example: Cement Mixer, Skid Steer, etc.

    • Make. The equipment's make.

    • Model. The equipment's model.

    • Year. The year the equipment was made. The year must be between 1970-Present.

    • Serial #. The equipment's serial number.

    • Notes. Any notes about the equipment.

    • Ownership. Who owns the equipment:

      • Owned

      • Rented

      • Subcontracted

    • Rate/Hr. The equipment's rate per hour in decimal format.

  5. Save the file.

Import

  1. Navigate to the company's Equipment tool.

  2. Click Import.

  3. Click Upload .xlsx File and select the prepared equipment file.
    OR
    Drag and drop the prepared equipment file from you computer to the upload box.

  4. Click Upload.