Thursday, September 19, 2024

INSERT NAMES into AMADEUS GROUPS from EXCEL

INSERT NAMES into AMADEUS GROUPS from EXCEL

Today we are going to see how to introduce names in Amadeus groups by inserting them in EXCEL format. We will no longer have to do NM1 SOLER / JAVIER, ... This entry will be very useful to you:

- We recover PNR in Amadeus from the cryptic screen:

RT KLXX3U                                                                       

RP/MADLH0100/MADLH0100 WS/RC 7FEB22/0920Z KLXX3U

0. 10RUSSIA SENIOR BIO NM: 0

  1 MIS 1A HK10 XXX 19SEP PAST

  2 LH1831 Q 07JUN 2 BIOMUC HK10 0735 0945 *1A/E*

  3 LH2564 Q 07JUN 2 MUCLED HK10 2 1210 1550 *1A/E*

  4 ARNK

  5 LH1445 K 14JUN 2 DMEFRA HK10 1315 1545 *1A/E*

  6 LH1146 K 14JUN 2 FRABIO HK10 1 2045 2250 *1A/E*

  7 AP ANGEL SOLER 910000000

  8 APE SECURED DATA

  9 TK OK05AUG/QLHLH0109


- Click on "Show in graphical mode" : It takes us to the Amadeus graphical mode


Display in graphical mode

     

More productsShow reservation file


- Click on "download template file" : An Excel table will be enabled so that we can include the names. Sometimes we see "export file"


Group information and contact

Group name:  SENIOR RUSSIA JUNGroup size:  25Passenger names:  0Unassigned seats:  25
General Telephone Number (AP)ANGEL SOLER 34915594892Delete
Email (APE)SECURED DATADelete


- We open the Excel that is generated and appears in the lower left part and we enter the names and/or data of the passengers.

Booking File_Template Amadeus

Once the names are saved, we close Excel.


- We import the file by clicking on " Import File"

Group information and contact

Group name:  SENIOR RUSSIA JUNGroup size:  25Passenger names:  0Unassigned seats:  25
General Telephone Number (AP)ANGEL SOLER 34915594892Delete
Email (APE)SECURED DATADelete


This excel file is located in "Team Downloads". Double-clicking it returns you to the graphical mode and click on " import selected data " to save the names entered in the group reservation.

Then we return to the cryptic mode by clicking on "show command page"


Show on command page

     

More products  Show reservation file


At this point we will have the names entered in the Amadeus PNR. We will only have to save the changes with ER. This operation has not only made our work much faster, but also prevented errors

No comments:

Post a Comment