Contact Support

    Meal Card Import

    Information on the Meal Card Import available in 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 Guest ID Numeric Y*
    A new Guest Record will be created if no Guest ID is supplied.
    Must include a Guest ID or Surname for import.
    2 Surname Alpha Numeric Y*   Mandatory if no Guest ID supplied.
    3 Given Alpha Numeric N   Will be used when creating a new Guest Record.
    4 Property Alpha Numeric Y   Property must exist in RMS. 
    5 Company Alpha Numeric N   Company must exist in RMS.
    Use if Meal Card is associated to a specific company.
    6 Meal Allowed Alpha Numeric Y 20 Enter using RMS and custom setup options.
    7 Starting From Date Y 11 DD-MMM-YYYY
    Start Date for the Meal Card.
    8 Expiring On Date Y 11 DD-MMM-YYYY
    End Date for the Meal Card.
    9 Meal Card Number Numeric Y
    Card Number

    Sample File

    Meal Card Import.csv

    Was this article helpful?

    Send Feedback

    Can’t find what you’re looking for?

    Contact Support