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 |