Field Validation for Equipment Module
Overview
Use this guide to format your data correctly when performing a Bulk Upload to add equipment. Fields must follow the validations below to avoid upload errors.
- For Add, Equipment Name, Category Name, and Group Name are required. Other fields are optional but recommended for complete records.
Note: Ensure that all required fields are provided. Optional fields left blank will be saved as empty values during upload.
See the table below for a complete list of field descriptions and validation rules.
Add Equipment
| Field | Description | Example | Required/Optional | Validation Rule |
|---|---|---|---|---|
| Equipment Name | Name of the equipment item | CAT Bulldozer 320D | Required | Must be unique; cannot be blank |
| Beacon MAC Address | BLE beacon’s MAC address if assigned | C6:AA:39:00:AA:F1 | Optional | Must follow valid MAC format (XX:XX:XX:XX:XX:XX ) if provided |
| Brand | Manufacturer/brand name of the equipment | Caterpillar | Optional | Free text |
| Model | Model number/name | 320D | Optional | Free text |
| Category Name | Category/type of equipment | Bulldozer | Required | Must match an existing category in the system |
| Group Name | Group to assign the equipment to | Field Operations | Required | Must match an existing group name exactly |
| Asset Assignment | User or driver the asset is assigned to | john.doe@example.com | Optional | Must match a valid user/driver email in the system if provided |
| Purchase Vendor | Vendor or supplier from whom the equipment was purchased | ABC Equipment Rentals | Optional | Free text |
| Purchase Price | Cost of the equipment at purchase | 65000 | Optional | Must be a valid positive number |
| Purchase Date | Date of purchase | 2022-05-10 | Optional | Must follow YYYY-MM-DD format |
| Warranty Expiration | Date when the warranty expires | 2025-05-10 | Optional | Must follow YYYY-MM-DD format |
| In Service Date | Date when the equipment went into service | 2022-06-01 | Optional | Must follow YYYY-MM-DD format |
| Estimated Service Life | Expected service life in years | 7 | Optional | Must be a valid positive number |
| Out Of Service Date | Date when the equipment was retired or taken out of service | 2030-06-01 | Optional | Must follow YYYY-MM-DD format |