Contact Support

    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?

    Contact Support