*****FOR HUDSON TECH SUPPORT ONLY*****
Setting up and Configuring Client to Receive FlightView data
NOTE: Information for other flight service configurations are at the very bottom of this document.
1) Contact RLM Software – Get Username and PW
2) Add Username and Password to Hudson CRM page
3) Logon to Client server: Open Agent and go to Tools Configuration Advanced Features System Profiles Tab. Scroll to end of table to FLIGHT INFORMATION CONNECTION. Double click the field in the default profile. Scroll to the end of the string. – Add ||USERNAME:PASSWORD| (all uppercase). Example:
a. …..%FIDATE%||NORTHSHORE:SHUTLE#41|. The entire connection string should look like this:
FLIGHTVW|xml.flightview.com|80||GET /fvHudson/fvXML.exe?ACID=%FIFLIGHT%&AL=%FIAIRLINE%&%FIDIR%AP=%FIAIRPORT%&%FIDIR%DATE=%FIDATE%||USERNAME:PASSWORD|
NOTE: If
the Hudson Client is subscribing to the 30 day advance lookup feature. Make the
following modification to the above connection string:
…/fvHudson30/fvXML.exe?ACID=%…
4) Click APPLY and OK to save changes to configuration
5) Add Airlines.csv file to HWeb folder on client server (Available at ftp://hudsonltd.com/misc/airlines.csv.
6) Edit HWeb.ini (
a. System Parameters
i. AirlineTransFile=PrimaryDirairlines.csv OR
ii. AirlineTransFile=SERVERNAMEHudsonHWebairlines.csv
b. [FLIGHTINFO]
[FLIGHTINFO]
INFOTYPE=1
INTERVALTYPE=1
INTERVALUNIT=60
INTERVAL=3
RETRYMAX=3
WHERE=(Operation<>'C') AND (Direction='A') AND LEFT(PickupKey,2)<>'XX' AND DATEDIFF(n,getdate(),FlightTOD) < 180 AND DATEDIFF(n,getdate(),FlightTOD) > -60 AND (Len(FlightNumber)>0) AND (Len(Airline)>0)
7) Edit Confguration: Tools Configuration Fare & Services:
a. Airports / Major Ports Tab: Place check mark in the column FLIGHT LOOKUP for all ports to be enabled for flight lookup.
**Effective with HWebAgent version 1.87, rather than a check box, you will be presented with a drop down menu where the default setting is: <none>. Change this setting to Flight view. (The other setting: local table, is for those clients who have manually built and maintain a database of flights that arrive at a local airport.)
HWeb Bridge - Configuration
If the client wishes for the Hudson system to automatically update and display current arrival information in the HWeb Dispatcher, then the client must have HWeb Bridge installed and running on the server or preferably on a workstation that is left on an running during all hours that the company is open and operating.
The HWeb Bridge will scan the reservation database and look for all reservations where the direction is set to Arrival from 60 minutes ago up to 180 minutes from now (this setting is contained in the HWeb.ini file). If the reservation meets that criteria, the bridge will send an XML query to RLM software and ask for a flight update. Once the data is received back, the dispatcher grid will be updated and refreshed showing flight status and updated arrival information. If the HWeb Bridge has been installed, check to ensure that the Flight Information trace route setting has been enabled. From the Bridge, click Tools - Bridge Trace Options. Place a check mark next to the box labled 'FLIGHTINFO.' Click OK to save settings. Close and restart the Bridge application. The Log window will display the flight query results after each polling interval.
To Test in Agent:
- Find and open an arrival reservation for the current day, within the next 3 hours.
- On the Pickup/Dropoff Tab, click the ? next to the Flight Type
- When the Flight Information dialog box opens, check first to ensure all fields are accurate and then click GET STATUS
- If you see something like:
- “Connection to xml.flightview.com complete” followed by Flight information, your configuration is successful.
To Test in Dispatcher
- Open the gdf file: FlightInfo (normally found in the HWebTemplatesSupport folder). If FlightInfo.gdf does not exist, it may be downloaded to the TemplatesSupport folder from: ftp://hudsonltd.com/misc/FlightInfo.gdf.
- Todays arrivals should be displayed along with current Flight status and status color coding.
- Test the update connection by selecting any arrival that is displayed as IN AIR. Right click on that reservation and select FLIGHT INFORMATION from the menu.
- check first to ensure all fields are accurate and then click GET STATUS
- If you see something like:
- “Connection to xml.flightview.com complete” followed by Flight information, your configuration is successful.
Troubleshooting
Common Error Code:
Connection to xml.flightview.com failed
HTTP state 1 400 Bad Request
In the event of the above error code, check the following:
1) Connection String in Configuration – including username and password
2) Review airline.csv in HWeb folder – must have complete list of airline names and codes
3) Flight Lookup enabled in Configuration
4) Ini files have been modified correctly
Confirm with RLM Software that Username, Password are correct and have been activated
To Enable / Configure flight status services other than FlightView:
FlightStats
The System Profile configuration query string should read:
XML|10.5.167.5|80||GET /service/flightinfo?ACID=%FIFLIGHT%&AL=%FIAIRLINE%&%FIDIR%AP=%FIAIRPORT%&%FIDIR%DATE=%FIDATE%&SITEID=cwbr1&LOGIN=USERID:PASSWORD:ACCT#&LookupType=FLIGHTSTATS||||FlightInfoReply|
In this configuration, Flight Queries are being processed via Hudson Server and are not being passed directly to flight service company. Note that the the IP address specified is Hudson internal server address and will correspond to the server through which the requests are being made. (As of date of this edit (7/10) the IP displayed is for LTD6)
Additionally, the airlines.csv file that is uploaded to client website has different layout. See the attachment above as example (airlines-web.csv). The first 3 columns are Record Key (Airline Name), IATA Code (2-3 characters), and Preferred (value=Y for all airlines).
OAG
The system profile configuration query string for OAG lookups will read:
XML|www.hudsonltd.com|80||GET /service/flightinfo?ACID=%FIFLIGHT%&AL=%FIAIRLINE%&%FIDIR%AP=%FIAIRPORT%&%FIDIR%DATE=%FIDATE%&SITEID=fltinfo&LOGIN=USERID:PASSWORD||||FlightInfoReply|