Import Information
- The file to be imported must be in a comma delimited .csv format.
- Microsoft Excel is able to save using a .csv format that should match these requirements.
- The fields within this file must not contain commas.
- RMS is able to determine whether the first record is a header record.
Field Order
| Order | Field Name | Field Type | Required | Unique | Max Characters | Notes |
|---|---|---|---|---|---|---|
| 1 | Description | Alpha Numeric | Y | Y | 50 | |
| 2 | Code | Alpha Numeric | N | 10 | ||
| 3 | Asset Type | Alpha Numeric | N | 50 | Must already be entered into RMS | |
| 4 | Asset Sub Type | Alpha Numeric | N | 50 | Must already be entered into RMS | |
| 5 | Model Name | Alpha Numeric | N | 50 | ||
| 6 | Serial No | Alpha Numeric | N | 50 | ||
| 7 | Warranty Start | Date | N | |||
| 8 | Warranty End | Date | N | |||
| 9 | Value New | Numeric | N | |||
| 10 | Value Current | Numeric | N | |||
| 11 | Note | Alpha Numeric | N | Unlimited | ||
| 12 | Property Name | Alpha Numeric | Y | 50 | ||
| 13 | Associated Type | Alpha Numeric | N | 50 | Must already be entered into RMS | |
| 14 | Associated To | Alpha Numeric | N | 50 | Must already be entered into RMS |