Import Information
- The file to be imported must be in a comma delimited .csv format (Field Delimiter), see template at the bottom of this article.
- 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 | See Date Formats Start Date for the Meal Card. |
| 8 | Expiring On | Date | Y | 11 | See Date Formats End Date for the Meal Card. |
| 9 | Meal Card Number | Numeric | Y | Â | Card Number |
Â
Date Formats
All date fields must use the DD-MMM-YYYY format (25-JAN-2025).
Â
Downloadable Import File
The attached import file below contains the required file format for an owner contract import. Download the file and review the column headers. Populate the file with the owner legacy ID, area, contract start and renewal dates along with a percentage share.
Â
Comments
0 comments
Please sign in to leave a comment.