Use the form below to submit an article request or log a Service Request to contact RMS Customer Support..

    Quoted Rate Import

    Information on the requirements for the Quoted Rate Import available in RMS.

    Import Information

    • The file to be imported must be in a comma delimited .csv format (Field Delimiter).
    • If a data field within this file contains commas, it should be surrounded with "double quotes" (Text Delimiter).
    • Line returns should be replaced with the pipe character '|'. (Usually found on the backslash key).
    • Microsoft Excel is able to save using a.csv format that should match these requirements.
    • RMS is able to determine whether the first record is a header record.


    The Quoted Rate Import will override any existing rates on reservations and record the nightly breakdown.

    Reservation Stay Dates not covered by the import will display a value of $0.

    Field Order

    Order Field Name Field Type Required Max Charaters RMS Equivalent
    1 Legacy Res ID Alpha Numeric Y 50 Legacy Res ID
    2 Date Date Y 50 Date Rate Applies
    3 Total_Rate Numeric Y   Base Rate Amount
    4 Charge Type Alpha Numeric N   Rate Type

    Sample File

    Quoted Rate.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Article Request