Contact Support

    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

    Sample File

    Categories .csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support