Project item: AX Tools

Project

Priority

StatusCompletePendingBlocked

Hours allocated

Needs ResearchNoYes - Minor Research RequiredYes - Significant Research Required

Top Priority?OtherTop Priority

Attachments

Save and Close

Save and Continue Editing

Return to list
Last Saved:
17-Oct-2025 09:41

Task<p><strong>Flight scraper</strong></p><p><strong>Populate Kayak data</strong></p><ul><li>Add a button (under Actions) that ROLE_ADMIN can run to populate flights (Kayak) for all active airports serving GVA, for a period of dates.&nbsp;<ul><li>Use same date schedule as in the Settings</li></ul></li></ul><p><strong>Populate GVA.CH data</strong></p><ul><li>On morning of T+1, run the GVA.CH scrape for ‘tomorrow’, on all flights<ul><li>This is a one-off check, mainly to confirm that the scheduled times from Kayak match the times from gva.ch. &nbsp;ie ScheduledDepartureTimeGvach === ScheduledArrivalTimeGvach<ul><li>Chron: Run at 8am, on T+1 (ie on Monday 8am, run Tuesday's GVA.CH Overview and Details flight scraper)&nbsp;</li></ul></li></ul></li><li>Throughout T+0, the ‘detailed' refresh should run on “selected” individual flights, where the criteria for selection is:<ul><li>Arrivals:<ul><li>actualArrivalTime is null <strong>and</strong></li><li>scheduledArrivalTimeGvach is after ‘now’ - 1hour&nbsp;</li></ul></li><li>Departures<ul><li>actualDepartureTime is null <strong>and</strong></li><li>status is not cancelled</li><li>scheduledDeparturelTimeGvach is after ‘now’ - 1hour&nbsp;</li></ul></li></ul></li></ul><p><strong>Code-share</strong></p><ul><li>Code share is no longer a relational field (linked to FlightTrips).&nbsp;</li><li>The Codeshare entity has a flightNumber and the record stores the associated other flights.&nbsp;<ul><li>This enables mutliple flightTrips with the same flightNumber to be linked to the CodeShare<ul><li>So the determination has to be a lookup on a matching flight number</li></ul></li></ul></li><li>The objective is to combine multiple entries for the same flight and return the code-share data in the flight details in the transfer bookings (so a user can search for their flight by any of the flight numbers)</li><li>Check the scrape functionality on the "Operated by" to identify “child” flights (ie the ones that are going to be deleted)</li><li>Establish a view &nbsp;of all flights where there are more than one flight departing at the same time to the same location.</li><li>Build up a list of code-shares - &nbsp; question, the gva.ch notes scrape concatenates the flight numbers. &nbsp;Should we maintain that array or separate into individual code-share identifiers - which will allow us to identify ones to delete?)</li><li>Write a service that identifies the duplicates and delete</li></ul>

Delete