Category Import
Information on the requirements for the Category Import available 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 | RMS Equivalent | Notes |
|---|---|---|---|---|---|---|---|
| 1 | ShortDesc | Alpha Numeric | Y | Y | 50 | Short Description | |
| 2 | LongDesc | Alpha Numeric | N | N | 4000 | Long Description | |
| 3 | GLCode | Alpha Numeric | N | N | 30 | G/L Acc Code | |
| 4 | Property Name | Alpha Numeric | Y | N | 50 | Property Name | |
| 5 | RMSOnline | Yes/No Field | N | N | 3 | Available to RMSOnline | |
| 6 | Class | Int | N | N | Class of Category | See Category Classes below. | |
| 7 | Housekeeping | Yes/No Field | N | N | 3 | Include on Housekeepers Report | |
| 8 | Occ | Int | N | N | Max Occ Per Area | ||
| 9 | Client Description | Alpha Numeric | N | N | 50 | Category Client Description |
Category Classes
Where Class is left blank all Categories will be set to Accommodation by default.
Use the following if a combination of Category Classes is required:
- Facility = 0
- Accommodation = 1
- Activity = 2
- Dock = 3
- Site = 4