1 Introduction

The Data Import Interface allows you to import reservation data into the shipboard Property Management System (SPMS). The interface replaces a multitude of reservation interfaces. The new interface provides several key functionality elements including a greater number of data formats, fixed length and delimited file format and above all, a user-definable format of reservation files SPMS can accept. Its Code modular structure allows for easy modifications in the future.

In addtion, the Data Import Interface also allows you to import a Standard Type Setup of almost every type, for example, Standard Excursions, Bookable Excursions, Course/Certificate Code, Amenity Code, Special Request Code and many more.

The following sections describe the standard set of data the Data Import Interface accepts and places into the SPMS database. The program is highly flexible and configurable, allowing you to import data into almost every table/column that exists in the SPMS database, subject to the proposed or recommended fields by your DBA.

Note:

Fields that are marked as required must be present. All others fields are optional and either ignored or assigned with the default values provided by the import procedure.