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 Time Records

Category:File Layouts
Category:CSV’s

CSV Layout for Time Records]]

TimeRecord Layout for the Hudson HWeb System



During 2004, HWeb software was updated to include a Time Record management tool inside the software. Prior to this however a Time Record CSV file needed to be created externally and then imported.  This is the format/layout for the externally created Time Record file.

To download a blank Time Record csv file:  ftp://www.hudsonltd.com/misc/timerec.csv

Filename: timerec.[csv/db]

Field Number and Name      Description

1. Key                         Reference for Time Record used in {xxx}fare

2. Record Name               Name of Time Record for Display

3. 24 hour flag                 1 = 24 hour service, 2 = Range of times, Empty = specific

                                  pickup times from Field 4…X

4. Pickup time1                 HH:MM format - time must be in earliest to latest order

                                  (i.e. 16:30,17:00,17:30) Days of the week can also be

                                  used (MOTUWETHFRSASU) with times

5. Pickup time 2..X             HH:MM format - time must be in earliest to latest order

                                 
(i.e. 16:30,17:00,17:30)

Categories: