If you would like to request a new article or update to an existing article in the RMS Help Centre please complete the below form.

    If you require assistance or would like to speak with someone from RMS Customer Support please log a Service Request.

    Add Ons Import

    Information on requirements for importing Add Ons into RMS.

    Import Information

    • The file to be imported must be in a comma delimited .csv format (Field Delimiter).
    • Data fields including a comma should be surrounded in "double quotes"(Text Delimiter).
    • Line returns should be replaced with the pipe character '|'  
    • Microsoft Excel is able to save using a .csv format that should match these requirements.
    • Header rows may be left in place as RMS can determine if there is a header row.

    Field Order

    Order Field Name Field Type Required Max Characters notes
    1 Legacy Res ID Alpha Numeric Y 50 Legacy Res ID
    2 From Date Date Y   Start date of Add On dd-mmm-yyyy
    3 To Date Date Y   End date of Add On dd-mmm-yyyy
    4 Use Arrive True/False     Add on will follow Arr date if changed
    5 Use Depart True/False     Add on will follow Dep date if changed
    6 Add On Type Alpha Numeric Y 20 Name of Add On Category
    7 Add On Alpha Numeric Y 20 Name of Add On Area
    8 Houskeeping True/False     To show in HK report
    9 Sundry Alpha Numeric   20 Name of Sundry if Charging
    10 UseSundryAmt True/False     Use amount from Sundry Charge
    11 Daily Charges True/False     Charge each day
    12 Amount Currency     Amount to Charge

    Sample File

    Add On.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Our team of RMS experts are here for you!

    Submit Question