2 Import File Format

This interface is designed to read a flat or comma delimited file format only. The acceptable file type is determined by the value set in Parameter group “DataImport”,”Reservation File Type”. For example, 'D' for delimited, 'F' for fixed length or a default value if a parameter is not specified

Each flat file represents a group of entries that the program is able to import. The format of each file name is described below:

<DATA_TYPE><EXPORT_DATE>.TXT

Where:

<DATA_TYPE>

is the group of entries presented in the file.

<EXPORT_DATE>

is the date when the file was created by an external system. Format is always YYYYMMDD.

.TXT 

is the File extension.

The sequence in which the data is read is important. The program will first process the Group details file, followed by the Guest or Crew Master File. This sequence allows you to assign guests/crew to groups, translating external system identifiers into SPMS internal numbers.

Below is the supported data transfer and file format.

Table 2-1 Reservation Data Type

NAME	FILE NAME	DESCRIPTION
Master Data (Guests) File (MASTER)	MASTERYYYYMMDD.TXT	Master data (required and imported first) used when importing guests.
Master Data – Crew File (MASTER)	CRWMASTERYYYYMMDD.TXT	Master data (required and imported first) used when importing crew members.
Group Details File (GROUP)	GROUPYYYYMMDD.TXT	Groups details.
Visitors Details File (VISITORS)	VISITORYYYYMMDD.TXT	Visitor details.
Flight Details File (FLIGHT)	FLIGHTYYYYMMDD.TXT	Flight details (can have many rows for one Master Data row).
Amenity/Gift Orders File (GIFT)	GIFTYYYYMMDD.TXT	Amenity and gift orders details (can have many rows for one Master Data row).
Document Details File (DOCUMENTS)	DOCUMENTSYYYYMMDD.TXT	Document Types (can have many rows for one Master Data row).
Special Request (SRT)	SRTYYYYMMDD.TXT	Special request orders (can have many rows for one Master Data row).
Pre-Postings File (PPS)	PPSYYYYMMDD.TXT	Pre-Postings (can have many rows for one Master Data row).
Excursion Bookings File (EPO)	EXCYYYYMMDD.TXT	Excursions pre-booked tickets (can have many rows for one Master Data row).
Pre-Paid Excursions (EPO)	PREPAIDESEYYYYMMDD.TXT	Excursions pre-paid tickets (can have many rows for one Master Data row).
Excursions Waitlist (EPW)	EPWYYYYMMDD.TXT	Excursions waitlist (can have many rows for one Master Data row).
Courses/Certificates File (COURSE)	COURSEYYYYMMDD.TXT	Courses/Certificates details (can have many rows for one Master Data row). Basically, the difference between standard courses and medical certificates is by the TAK_COUID imported by the reservation.
Restaurant/Dining Assignment File (DINING)	DINING.TXT	Restaurant dining information file (for Dining System).
Courses/Certificates File (COURSE)	GHIYYYYMMDD.TXT	Guest history information.
Guest History File (GHI)	CHIYYYYMMDD.TXT	Crew history information.
Crew History File (CHI)	DISYYYYMMDD.TXT	Discount details.
Discount Details	ROTYYYYMMDD.TXT	Routing details.
Spa Booking Details (SPA)	UDFYYYYMMDD.TXT	User definable field details.
User Definable Field Details	UDDYYYYMMDD.TXT	User definable data details.
Routing Details	SPIYYYYMMDD.TXT	Spa retail items details.
Spa Retail Items (SPI)	SPYYYYYMMDD.TXT	Spa treatment items details.
Spa Treatment Items (SPY)	SPBYYYYMMDD.TXT	Spa packages details.
Spa Packages/Combo (SPB)	SPVYYYYMMDD.TXT	Spa price definition details.
Spa Items and Packages Pricing Definition (SPV)	SPAYYYYMMDD.TXT	Spa bookings details.
User Definable Data	GC1YYYYMMDD.TXT	Gift Card details.
Gift Card Details	CC1YYYYMMDD.TXT	Credit Card details.
Credit Card Details	PREBOOKEDTKPOYYYYMMDD.TXT PREPAIDTKPOYYYYMMDD.TXT	Pre-booked and Pre-paid Events Tickets (can have many rows for one Master Data row). For Pre-booked Events Tickets, must be all in one import file and Prepaid Event Tickets must be in a separate file.
Pre-booked and Pre-paid Events Bookings Details (TKPO)	TKPWYYYYMMDD.TXT	Events Waitlist (can have many rows for one Master Data row).

Table 2-2 Standard Type of Setup

NAME	FILE NAME	DESCRIPTION
Standard Excursions Setup (STDEXCURSION)	STDEXCURSION.TXT	Standard Excursion import (Can import pre-setup standard excursion to be used onboard).
Bookable Excursions Setup (BOKEXCURSION)	BOKEXCURSION.TXT	Bookable Excursions import is based on Standard Excursion setup import with a particular DATE.
Excursion Package Definition Setup (EXCPACKAGE)	EXCPACKAGE.TXT	Excursions Package Definition import should always be imported prior to Packaged Excursions Linking Setup import.
Package Excursions Linking Setup (EXCPACKAGELINK)	EXCPACKAGELINK.TXT	Packaged Excursions Linking Setup defines which Tours are assigned to each Package with the necessary Package specific prices.
Courses and Certificates (CCERTSETUP)	CCERTSETUP.TXT	Courses and Certificates Code import (To be able to import the courses and certificates code and description).
Amenity Setup (AMTSETUP)	AMTSETUP.TXT	Amenity Code import (To be able to import the amenity code and description).
Special Request Setup (SRTSETUP)	SRTSETUP.TXT	Special Request Code import (To be able to import the special request code and description).
Event Templates Setup (TKTESETUP)	EVENTTEMPLATES.TXT	Event Templates import.
Event Templates Pricing Setup (TKPTSETUP)	EVENTTEMPLATESPRICING.TXT	Since Events can have different Prices for different Price Categories and Account Types, we need to be able to import Prices for each Event Template.
Bookable Events Setup (TKBESETUP)	EVENTBOOKABLES.TXT	Bookable Events import is based on Event Templates setup, imported with a particular DATE.
Bookable Events Pricing Setup (TKPBSETUP)	EVENTBOOKABLESPRICING.TXT	Since Events can have different Prices for different Price Categories and Account Types, we need to be able to import Prices for each Bookable Event.