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 |