Navigation

 ·   Wiki Home
 ·   Wiki Help
 ·   Categories
 ·   Title List
 ·   Uncategorized Pages
 ·   Random Page
 ·   Recent Changes
 ·   RSS
 ·   Atom
 ·   What Links Here

Active Members:

Search:

 

Create or Find Page:

 

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 letters

Fare 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

 

Categories: