fo webhelp - kt - se ground
TRANSCRIPT
KT - SE GROUND
Frédéric Sagez
November 2016 | France
Technical Support (eGTS) Team
Ground Transportation
Egencia is launching support for ground transportation online in Sweden, making it easy to book a taxi, a bus or the ArlandaExpress (Jan 2016) with a flight. In addition to domestic ground services, taxis are available in approximately 40 airports internationally. To provide ground transportation to customers, we are working with Flygtaxi, one of the top local providers of Ground Transportation. (FLYGTAXI, FLYGBUSS, UBER)
Page 2 | Confidential
ARCHITECTURE
Page 3 | Confidential
https://www.egencia.se/ground-transportation/
Page 4 | Confidential
SUMMARY
1. HOW TO INVESTIGATE
2. USE CASES
3. RESOURCES
4. JIRA
5. CONFLUENCE
Page 5 | Confidential
1- HOW TO INVESTIGATE
DTC
MONGO DB
MS SQL
SPLUNK
TEALEAF
TRIP – GLOBAL ITINERARY
Page 6 | Confidential
https://dtc.ch.expeso.com/_pages/index.php (EXPESO)
Page 7 | Confidential
TOOLS FRONT-OFFICE
Page 8 | Confidential
PNR Details
Page 9 | Confidential
XML Details
RDBMS
Page 10 | Confidential
SQL Server Management Studio
Page 11 | Confidential
PNR Details with Ground linked
Page 12 | Confidential
See All Ground of the day if you want !
RDBMS
(EXPESO)
Page 13 | Confidential
Page 14 | Confidential
Supplier Reference Details
Page 15 | Confidential
departureLocation arrivalLocation product
"departureLocation" : {"type" : "ADDRESS", "code" : "AV1", "name" : "Avan (Luleå)", "streetNumber" :
NumberInt(20),"street" : "Avans Byaväg", "city" : "Luleå", "postalCode" : "2580", "country" : "SE", "coordinates" : {
"latitude" : "65.679524", "longitude" : "21.805302"
}},
"departureDatetime" : ISODate("2016-10-07T05:55:00.000+0000"),
"arrivalLocation" : {"type" : "AIRPORT", "code" : "LLA", "name" : "Luleå Kallax flygplats", "city" : "Luleå", "country" : "SE", "coordinates" : {
"latitude" : "65.549189", "longitude" : "22.125557"
}}, "arrivalDatetime" : ISODate("2016-10-
09T16:26:00.000+0000"),
"product" : {"carriage" : {
"type" : "TAXI", "code" : "TAXI", "description" : "Delad taxi för 1 person.
Samplaneras med andra resenärer för lägre pris ochmiljöpåverkan. Vid Delad taxi kan varje resenär ha med sig ett handbagage och en normalstor resväska.",
"capacity" : NumberInt(1), "numberOfPassengersRequired" : false, "foidRequired" : false, "category" : "ST"
}, "company" : {
"name" : "Delad TAXI (1 psgr)"}, "rulesAndRegulations" : {
"pickupTimeLocked" : true, "rules" : [
{"action" : "LATEST_CANCEL_TIME", "possible" : true, "untilDatetime" : ISODate("2016-10-
07T04:55:00.000+0000")}
], "possiblePickupTimeSelector" : [
ISODate("2016-10-07T05:55:00.000+0000")]
}
Page 16 | Confidential
pricing traveler informations
"amount" : "437.00", "currency" : "SEK", "breakdowns" : [
{"amount" : "412.26", "type" : "BASE"
}, {
"amount" : "24.74", "type" : "TAXES", "breakdowns" : [
{"amount" : "0.06", "type" : "TAXES_IN_PERCENT"
}]
}], "type" : "STANDARD"
"traveler" : {"userId" : "11262627", "civility" : "Herr", "firstName" : "Dan ", "lastName" : "Jåma", "email" : "[email protected]","phone" : "+46705868618"
},
"informations" : {"distance" : "22.766", "duration" : NumberInt(1312)
}
Page 17 | Confidential
connection
"connection" : {"tripType" : "FLIGHT", "tripReference" : "SK5", "departureLocation" : {
"code" : "LLA"}, "departureDatetime" : ISODate("2016-10-09T17:10:00.000+0000"),"arrivalLocation" : {
"code" : "MMK"}, "arrivalDatetime" : ISODate("2016-10-10T08:55:00.000+0000"), "international" : false
}, "bookingReference" : "R000729660", "status" : "VALIDATED"
"_id" : NumberInt(127227), "_class" : "com.egencia.groundtransportation.model.GroundProduct","reservation" : {
"status" : "VALIDATED", "bookingReference" : "2016000727546", "bookingType" : "ONLINE"
},
"mdCode" : "197157842", "vendorReference" : "FLYGTAXI", "vendorPhone" : "+46812092000"
}
https://chsxsplsrc922/fr-FR/app/launcher/home (EXPESO)
Page 18 | Confidential
LOG MANAGEMENT
Page 19 | Confidential
Request Supplier Exchanges
Page 20 | Confidential
Errors Request From Supplier
https://oxptealeaf8/portal/ReportBuilder.aspx (EXPESO)
Page 21 | Confidential
CUSTOMER BEHAVIOR ANALYSIS
Page 22 | Confidential
Sniff User’s Navigation
Page 23 | Confidential
Matching Informations (RESPONSE)
Page 24 | Confidential
Json Code Details (REPLY)
Page 25 | Confidential
Json Supplier Exchange
https://www.egencia.se/trip-webapp/
Page 26 | Confidential
TRIP – GLOBAL ITINERARY
Page 27 | Confidential
PNR Air Details
Page 28 | Confidential
PNR Ground Details (From/To Connexion)
Page 29 | Confidential
PDF ITINERARY Summary
Page 30 | Confidential
Checkout Web-page Details
Page 31 | Confidential
History of the Booking
Already on your way !
Page 32 | Confidential
2- USE CASESTITLE EXAMPLE ISSUE Analysis RESULTS
Taxi is shown as Towncar/Limo in Egencia Online
01470209Wrong label (vendor reference) indicated in the Trip information
[GROUND SE][TRIP] Case number 01470209 - Wrong Vendor Reference
EGE-112842
Cannotinsert/sync/cancel groundtransportation
01388884We cannot add Ground Transportation due to Four services servers which were down
The Support Team reported that we saw anyerror logs about this issue.• PM has fixed this matter in developing
the management of the time out from providers services : EGE-96256
EGE-105708
Taxi departure time wrong loaded in CCI
01416432
Taxi booked in CCI by client and taxi was 10 mins late so client missed flight and had to buy a new flight ticket.
• The estimated journey time is correct but the taxi was late : you need to claim a request to the taxi company
• The estimated travel time is too short : we asked Flygtaxi to review its calculation algorithm for this address and they work on it
Open a Thread with Thomas Petit,
Wong Ho and Cecile Saunier to have a feedback
Not possible to book Ground transportation for customer
01415114
The customer want to book an Air Trip with Rail Product (From GOT Central Station to Stockholm Central Station)
Rather than taking the flight (GOT -> RNA), he takes a train for his return.• You can get only Ground Transportation
products like Taxi, Shared Taxi or Bus. (Exception Arlanda...)
Answer to the customer that it’s
not possible
Book a bus in website that doesn’t exist in real life
01431454You can add a ground transportation which called Flygbuss/Swebus but it’s not exist
You need to ask FlygTaxi to remove this item in their products• Ask the technical / product contact from
FlygTaxi : Mikael Kjellström<[email protected]>
EGE-110091
Page 33 | Confidential
3- RESOURCES – Follow links in Confluence
Project Overview
https://confluence/display/ECT/SE Ground Project documentation V1.0 - V1.1 and V1.2
How to and troubleshooting guide
https://confluence/display/ECT/SE Ground Transportation - Central Support Documentation with How to and troubleshooting guide
Fix/Version
https://confluence/display/ECT/SE Ground Transportation - Releases Schedule
MongoDB
https://confluence/display/ECT/SE Ground Transportation - How to connect to production mongoDB
https://confluence/display/ECT/SE Ground Transportation - How to find data in MongoDB
MS SQL
https://confluence/display/ECT/SE Ground Transportation - What is the look of Ground in ECTWeb
Splunk
https://confluence/display/ECT/SE Ground Transportation - How to check the logs in Splunk
Page 34 | Confidential
4- JIRA - Current live Bugs
Page 35 | Confidential
Bug BR Summary Creator Created Updated
EGE-101636 4 [SE Ground] The text on summary say Flygtaxi, but it is a bus that has been booked.
Praveen Kumar Madiraju [X]
23/11/2015 13:29 25/Aug/16 6:41
EGE-101969 6 [GROUND][POS SE] Wrong Example For Phone Number David Martin Balli [X]
30/11/2015 14:15 08/06/2016 09:12
EGE-108406 6 [GROUND SE][TRIP][Locked Status] Ground transport as Taxi not appear in the booking Trip
Frederic SAGEZ 17/Feb/16 5:36 07/11/2016 10:27
EGE-110095 4 [SE GROUND] Unable to Cancel/Delete Taxi still booked Frederic SAGEZ 04/03/2016 13:36 07/11/2016 10:27
EGE-112270 4 [GROUND][OFTEN]: Booking XMLs did not generate and cancellation of the taxi is not going through from CCI to Navision
Shilpa Nandanwar 06/Apr/16 5:35 07/11/2016 10:27
EGE-114266 7 [SE GROUND][SYSTEMATIC][SE POS]: Wrong Departure Time for Bus in Confirmation Email sent to the traveler
Shilpa Nandanwar 29/Apr/16 9:22 AM
07/11/2016 10:28
EGE-126751 6 [SE Ground][Air booking] Incorrect/suspicious air booking in a ground booking
Isha Mehla 09/09/2016 17:32 07/11/2016 10:27
EGE-127158 6 [GROUND][SYSTEMATIC]: Incorrect Long/Lat location provided by Flygtaxi
Shilpa Nandanwar 16/09/2016 11:16 20/09/2016 10:43
EGE-128752 6 [SE GROUND][ITINERARY][TRIP] Unable and Impossible to Cancel a Ground Transportation
Frederic SAGEZ 03/10/2016 13:03 03/11/2016 16:38
EGE-129623 6 [GROUND SE][ARN][ITINERARY] Ground Transportation appears booked in finalization, only in Draft and not cancellable
Frederic SAGEZ 11/10/2016 16:57 07/11/2016 10:28
EGE-130535 4 [SE Ground]- Cannot book or cancel ground due to ConnectTimeoutException
Isha Mehla 19/10/2016 15:48 19/10/2016 16:31
EGE-130539 4 [SE Ground][International location] Cannot book ground on international locations
Isha Mehla 19/10/2016 16:20 19/10/2016 16:51
5- CONFLUENCE - where adding regular basis
New Analysis should be added in Confluence
https://confluence/display/ECT/KT - SE GROUND
Page 36 | Confidential
QUESTIONS?
Page 37 | Confidential
105 SLA - Time passed: 60 hours (8 days) - Jira: 12 Bugs Open and 5 Closed
About your speaker
BONUS
Page 38 | Confidential
How To : Pick-up Time Calculation
Page 39 | Confidential
1.Create a configurable hour offset, let's set it to 2 hours
2.Create a minutes interval (minutes_interval), let's set to 5 minutes
3.When taking a taxi from the connection (the arrival location is an airport), the pick-up time values will be HH:MM with
1.the HH:MM of the arrival date
2.the 4 next HH:MM with an interval of minutes_interval
3.the 4 next HH:MM with an interval of minutes_interval * 2
4.the 4 next HH:MM with an interval of minutes_interval * 3
5.etc...
Example with 11H00 as arrival date, the maximal hour is 13H00 :
When taking a taxi to the connection (the departure location is an airport), the same principle is applied, with the departure date
and descending dates.
HH:MM Interval
11:00
11:05 5
11:10 5
11:15 5
11:20 5
11:30 10
11:40 10
11:50 10
12:00 10
12:15 15
12:30 15
13:00 15