The Data Import Interface allows importing of reservation data into the SPMS. The interface replaces a multitude of reservation interfaces we used to have. The new interface provides several key functionality elements including 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.
On top of that, the Data Import Interface also allows import of a Standard Type Setup of almost every type of setup; 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 in which the Data Import Interface accepts and places into the SPMS database. The program is highly flexible and configurable, allowing data to be imported 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 have to be present. All others fields are optional and will either be ignored or assigned with the default values provided by our import procedure.