Asset Import
Information on the requirements for the Asset Import in RMS.
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 |
Sample File
Asset.csv
How could we improve this answer?