View CSV Layout for Exception Records
Category:File Layouts
Category:CSV’s
CSV Layout for Exception Records
**NOTE: Prior to HWeb Version 1.87, the only way to build exception records was to create them on a spreadsheet, save it in CSV (Comma Separated Value) format and them import to local system software and / or export to the web system. Beginning with version 1.87, the local software contains a tool for building exception records within the application, which is generally easier and quicker. The tool also allows for easy upload to web reservation site. For more information on how to use the local system exception creation tool, please click HERE.
Exception Record Layout for the Hudson HWeb System
To Download a blank Exception Record csv template: http://client.hudsonltd.com/templates/csvs/locexc.csv
Filename: locexc.[csv/db]
Number | Letter | Title | Content Description | |
1 | A | Key | {Location Key}.YYMMDD.Airport KEY | |
2 | B | Direction | Direction for exception information (blank = all directions). Directions: D-Departure, A-Arrival, P-Point-to-Point and H-Hourly. To disable multi place letters together (PH – disables PtoP & Hourly | |
3 | C | Time list | List of times, separated with ^ (ie MOTUWETHFR^3:00^6:00) | |
4 | D | Status | D = Disable entirely, or leave blank to enable location | |
5 | E | DelayA | Minutes of additional Arrival delay | |
6 | F | DelayD | Minutes of additional Departure delay | |
7 | G | Service 2 | Additional dollar amount to add, or D to disable | |
8 | H | Service 1 | Additional dollar amount to add, or D to disable | |
9 | I | Service 4 | Additional dollar amount to add, or D to disable | |
10 | J | Service 3 | Additional dollar amount to add, or D to disable | |
11 | K | Service 5 | Additional dollar amount to add, or D to disable | |
12 | L | Service 6 | Additional dollar amount to add, or D to disable | |
13 | M | Service 7 | Additional dollar amount to add, or D to disable | |
14 | N | Service 8 | Additional dollar amount to add, or D to disable | |
15 | O | Service 9 | Additional dollar amount to add, or D to disable | |
16 | P | Service 10 | Additional dollar amount to add, or D to disable | |
17 | Q | Service 11 | Additional dollar amount to add, or D to disable | |
18 | R | Service 12 | Additional dollar amount to add, or D to disable | |
19 | S | DepTime Rec | New departure time record to use on exception date | |
20 | T | ArrTime Rec | New arrival time record to use on exception date | |
21 | U | Notes | Any message you want displayed for an Agent to see | |
Exception Record Examples
Note:
Airport key must be in capital lettersFare key is found in Key field of your xxxFares.csv file
Key Field Examples
Specific location for a specific date, for a specific airport
<fare key>.<yymmdd>.AIRPORTKEY
Specific Location for a specific date, for all airports
<fare key>.<yymmdd>
All Locations for a specific date, for all airports
*.<yymmdd>.AIRPORTKEY - all locations on this date for specific airport
All Locations for a specific date, for all airports
*.<yymmdd> - all locations on this date
All Locations for all days, for a specific airports
*.*.AIRPORTKEY
All Locations for all days, for all airports
*
Duplicate Key
If a key entry must be duplicated, follow the second entry with a .X(1-n). For example *.*.AIRPORTKEY, *.*.AIRPORKEY.1, *.*.AIRPORKEY.2
Example CSV file layout
To disable all services to Logan from 6:00 am until 9:59pm for Feb. 25, 2001
A | B | C | D |
*.010225.BOS | D | 06:00^09:59 | D |
To disable all services from Logan from 12 noon until 1:59pm for Feb. 25, 2001
A | B | C | D |
*.010225.BOS | A | 12:00^13:59 | D |
To add 15 minutes to the departure lead time of all locations every Monday and Friday from 8:00am until 11:30am
A | B | C | D | E | F |
*.*.BOS | D | MOFR^08:00^11:30 | 15 |
To add a ten dollar ($10) surcharge service one (1) on New Years Eve
A | B | C | D | E | F | G | H |
*.011231 | 10 |