When importing a CSV file, the Import/Export Assets page displays highlighted cells to indicate issues that need attention before or after importing.
Jump to a section:
- Yellow Highlighted Cells
- Red Highlighted Cells
- Fire Extinguisher Form — Character Limits & Yellow Error Causes
Yellow Highlighted Cells
Yellow highlighted cells do not need to be resolved before importing. They appear when a non-required field is empty. You can proceed with the import and fill in those fields later if needed.
Red Highlighted Cells
Red highlighted cells indicate errors that must be resolved before the CSV file can be imported. You will need to correct the CSV file and re-import it to clear these errors.
Red errors are displayed across all form types when:
- A required field is empty.
- A field exceeds the maximum character limit.
- The LastTested date is not in the correct format.
- The Type field does not contain a valid, available type for selection.
💡 Example: A red error in the Type column means the required Type field is empty. A red error in the Next Year column means the value entered exceeds the 4-character limit.
Fire Extinguisher Form — Character Limits & Yellow Error Causes
The following character limits apply to Fire Extinguisher form fields. Exceeding these limits will result in a red error.
Field |
Maximum Characters |
|---|---|
Tag |
64 |
Zone |
128 |
Serial |
64 |
Manf |
64 |
Manf Date |
32 |
Model |
64 |
Size |
16 |
Type |
64 |
LastType |
64 |
LastYear |
4 |
NextType |
64 |
NextYear |
4 |
Weight |
32 |
📌 Note: FormLink also checks whether the ServiceTypeLast date can be properly formatted. If not, a red error will be displayed.
Yellow errors on a Fire Extinguisher form are displayed when any of the following conditions exist:
- Empty Serial # field
- Empty Manf field
- Manf is not in the list of available manufacturers
- Empty Model # field
- Empty Size field
- Size entered is not in the list of available sizes
- Type entered is not in the list of available types
- NextType entered is not in the list of available types
- LastType entered is not in the list of available types
- Empty ManfDate field
- Empty Weight field