Old systems information migration

Dear customers,

This article will cover the option to have old data migrated from your old system into GO7 PSS.

Here are the basic rules for the file structure:

1. We require the data to be in one Excel file in one sheet.
2. Columns of the File:
1. PNR ref - This is your old system pnr reference, text value.
   After the migration, you will be able to search the booking according to your old PNR ref using “name XXXXX” in the search engine of GO7 PSS system.
2. Accounting code - This is an accounting code of the agency the booking is related to, make sure the accounting code is updated in the agency, normally if the bookings are “direct” customers bookings, you should open an agency called “old bookings” and update it’s accounting code.
3. Flight number - This is the flight number and it should match the flight number in GO7 PSS
4. Flight date - This is the flight date, there should be an available flight which matches the flight date.
5. From - This is the code of the departure of the flight
6. To - This is the code of the arrival of the flight.
7. Class - This is the Class code and should match an available class on the flight in GO7 PSS system.
8. Title - The title of the passenger.
   Possible options: Prof.(M)  / Prof.(F)  / Ms. / Mrs. / Mr. / Miss. / Hon. (M) / Hon. (F) / Dr. (M) / Dr. (F) / Child
   The import tool does not support Infants updating.
9. Passenger first name - This is the passenger first name
   Passenger names must be different in one specific booking, if you have 2-3 passengers with the same name in one booking, the system will migrate it as one.
10. Passenger last name - This is the passenger last name
    Passenger names must be different in one specific booking, if you have 2-3 passengers with the same name in one booking, the system will migrate it as one.
11. Remark 1 - Remark which will be inserted to the PNR, This is not mandatory, leave the column blank if not filled.
12. Remark 2 - Remark which will be inserted to the PNR, This is not mandatory, leave the column blank if not filled.
13. Remark 3 - Remark which will be inserted to the PNR, This is not mandatory, leave the column blank if not filled.
14. Remark 4 - Remark which will be inserted to the PNR, This is not mandatory, leave the column blank if not filled.
15. Fare - This is the NET fare of the segment.
16. TAX - This is the TAX of the segment
17. Gross fare - This is the GROSS FARE of the segment
3. Once you send us the file, we will do it in stages, while in those stages we might send you back the file for updating if we find errors, the errors you might see are:
1. Agent accounting code not found - in this case it means the system could not find an accounting code you have inserted in the file, please make sure all the accounting codes are in place in the system and file.
2. Destination not found - there is a mismatch between destinations codes in the file and the system.
3. Flights not found - There is a mismatch between the flight numbers in the file and what’s in the system.
4. Classes not found - There is a mismatch between the classes in the file and what’s in the system.
4. Once all the bookings are in the system, you will need to “Ticket” them manually according to the booking.