MAXAGRID
 
Search:
 

Layout

The following is an overview of processes and file layouts in place for interfacing with a Traffic system. All files are of ASCII Text format.

Maxagrid prepares "*.ctm" file specifying calendar dates and dayparts for which Avails data is needed on a station by station basis. Traffic monitors existence *.ctm files and when asked provides a *.abl file containing the Avails data.

Traffic will alter the file extension to indicate the processing state of a given *.Ctm file. When processing, the file extension will be changed to *.Ct0, when processing is complete, the extension will be changed to *.Ct1 if successful or *.Ct2 if a processing error has occurred. A companion log file will also be produced that provides processing information for a given *.Ctm file. The Log File will have the same base file name as the processed *.Ctm file and have and extension of *.clg.

The *.abl returned, will match the full daypart & calendar range of the respective *.ctm, and will be given the same *.ctm file name. Refresh files are subsequently submitted (*.rfh, of *.abl format) when logs are to be committed, Each will have a unique file name and only contain those daypart and calendar ranges that have changed since the time of the most recent submitted .ctm/.abl files.

Layout of Maxagrid CTM FILE

Position Length Description
======== ====== ===========

Header record

   1-4      4   Internal file type identification. For *.ctm files is "KENN".
   5-8      4   File Version. Initially is "001A".
   9-27    19   Create date/time stamp. Format is: "YYYY/MM/DD HH:MM:SS"
  28-46    19   Read date/time stamp. Format is: "YYYY/MM/DD HH:MM:SS"
 
                The Create Stamp in 9-27 is provided by Maxagrid.
                The Read Stamp in 28-46 is initially blank filled when file
                is created; and entered when file processed by Traffic.

    47      1   Process flag.

                "0" If no action taken, and initial value set by Maxagrid
                "1" If file was succesfully processed by Traffic system.
                "2" If Traffic processing encountered some error

                Errors would include invalid field values; e.g. a not
                recognized station, badly formatted date, or time.
        
  48-57    10   Number of date/daypart records following. RJBF.
  58-88    31   Station identification. Alphanumeric, LJBF. Must
                match Traffic identification string for station.
  89-100   12   File [name][.ext] in [8.3] format. Identical to external
                name when file was created.
 101-116   16   Reserved Area for Maxagrid 
 117-132   16   Reserved Area for Traffic
 133-134    2   CRLF (H0D0A) terminator.

Date/daypart records

  1-10    10    Unique Maxagrid daypart identifier. Numeric, RJBF.
 11-20    10    Date "YYYY/MM/DD" for which Avails Data is requested.
 21-28     8    Daypart begin time, "HH:MM:SS" 24HR clock format.
 29-36     8    Daypart end time, "HH:MM:SS" 24HR clock format.
 37-67    31    Station identification. AlphaNumeric, LJBF. Must
                match Traffic identification string for station.
 68-69     2    CRLF (H0D0A) terminator.

Sequence of Date/daypart records would be ascending by date, then begin time associated with the Maxagrid daypart.

Layout of Traffic Avails FILE (ABL /RFH) Files

Position Length Description
======== ====== ===========

Header record

  1-4      4    Internal file type identification. For *.ctm files is "TOBY".
  5-8      4    File Version. Initially is "001A".
  9-27    19    Create date/time stamp. Format is: "YYYY/MM/DD HH:MM:SS"
 28-46    19    Read date/time stamp. Format is: "YYYY/MM/DD HH:MM:SS"
 
                The Create Stamp in 9-27 is provided by Traffic
                The Read Stamp in 28-46 is initially blank filled when file
                is created; and entered when file processed by Maxagrid

   47      1    Process flag.   "0" if the file has not been processed by Maxagrid.
                                "1" if successfully processed
                                "2" if and error occurred during processing.

                Process flag in 47 is initially set to "0" the file is created, and
                updated by MaxaGrid when file is read. Primarily, errors would include
                invalid field values; e.g. a not recognized station, badly formatted
                date, or time value.
        
 48-57    10    Number of availability records following. RJBF.
 58-88    31    Station identification. Alphanumeric, LJBF. Must
                match Traffic identification string for station.
 89-100   12    File [name][.ext] in [8.3] format. Identical to external
                name when file was created.
 101-116  16    Reserved Area for Maxagrid 
 117-132  16    Reserved Area for Traffic
 133-134   2    CRLF (H0D0A) terminator.

Availabilities Records

  1-10    10    Unique Maxagrid daypart identifier. Numeric, RJBF.
 11-20    10    Date "YYYY/MM/DD" for which Avails Data was requested.
 21-28     8    Daypart begin time, "HH:MM:SS" 24HR clock format.
 29-36     8    Daypart end time, "HH:MM:SS" 24HR clock format.

   37      1    Data Type. Numeric. Value meanings follow
                0 On-Line information ( Actuals )
                1 Off-Line Information ( Projections )	

   38      1    Record Type. Numeric. Value meanings follow
                Values 7-9 are un-assigned.

                Value   Description

                  0     Commercial inventory capacity
                  1     Non-Commercial inventory capacity
                  2     All spots placed. Commercial + Non-Commercial.
                  3     Commercial inventory placed
                  4     Non-Commercial inventory placed
                  5     Commercial inventory bumped
                  6     Non-Commercial inventory bumped

                Usage of record type (i.e. RT) is as follows. If RT=3 then
                the Count field in 42-47 carries the number of commercial units
                placed; the Time field in 48-55 carries the commercial time
                placed; the Revenue field carries the income dollars 
                associated with the placed revenue.

 39-41     3    Priority code. Numeric, RJBF, Range "000" - "255".
 42-47     6    Count field. Numeric, RJBF. 
 48-55     8    Time field. 24HR format "HH:MM:SS". 
 56-61     6    Revenue field. Numeric, RJBF. Rounded to nearest whole dollar.
 62-63     2    CRLF (H0D0A) terminator.

Sequence of records would be ascending by date, then begin time associated with the Maxagrid daypart then record type then priority.

EXAMPLE CTM FILE

KENN001A1998/10/04 13:03:10                   0      2912WYOU                           PBB3F893.CTM
        361998/09/2800:00:0005:00:00
         11998/09/2805:00:0006:00:00
         61998/09/2806:00:0009:00:00
        111998/09/2809:00:0012:00:00
        161998/09/2812:00:0016:00:00
        211998/09/2816:00:0019:00:00
        261998/09/2819:00:0022:00:00
        311998/09/2822:00:0000:00:00
        371998/09/2900:00:0005:00:00
         21998/09/2905:00:0006:00:00
         71998/09/2906:00:0009:00:00
        121998/09/2909:00:0012:00:00
        171998/09/2912:00:0016:00:00
        221998/09/2916:00:0019:00:00
        271998/09/2919:00:0022:00:00
        321998/09/2922:00:0000:00:00
        381998/09/3000:00:0005:00:00
         31998/09/3005:00:0006:00:00
         81998/09/3006:00:0009:00:00
        131998/09/3009:00:0012:00:00
        181998/09/3012:00:0016:00:00
        231998/09/3016:00:0019:00:00
        281998/09/3019:00:0022:00:00
        331998/09/3022:00:0000:00:00
        391998/10/0100:00:0005:00:00
         41998/10/0105:00:0006:00:00
         91998/10/0106:00:0009:00:00
        141998/10/0109:00:0012:00:00
        191998/10/0112:00:0016:00:00
        241998/10/0116:00:0019:00:00
        291998/10/0119:00:0022:00:00
        341998/10/0122:00:0000:00:00
        401998/10/0200:00:0005:00:00
         51998/10/0205:00:0006:00:00
        101998/10/0206:00:0009:00:00
        151998/10/0209:00:0012:00:00
        201998/10/0212:00:0016:00:00
        251998/10/0216:00:0019:00:00
        301998/10/0219:00:0022:00:00
        351998/10/0222:00:0000:00:00
(etc.,…)

EXAMPLE ABL/RFH FILE

TOBY001A1998/10/05 21:15:371998/10/04 18:47:021      1896B105                           B105SMPL.Abl
         61998/10/0506:00:0009:00:0000128    2900:29:00     0
         61998/10/0506:00:0009:00:0000150     900:08:00     0
         61998/10/0506:00:0009:00:0001128     200:31:00     0
         61998/10/0506:00:0009:00:0001150     700:16:00     0
         61998/10/0506:00:0009:00:0002100     200:01:00     0
         61998/10/0506:00:0009:00:0002128     200:01:00     0
         61998/10/0506:00:0009:00:0002150    1500:10:30   333
         61998/10/0506:00:0009:00:0002170     100:00:30     0
         61998/10/0506:00:0009:00:0002185     300:03:00   225
         61998/10/0506:00:0009:00:0002190     300:03:00   145
         61998/10/0506:00:0009:00:0002195     100:00:30    85
         61998/10/0506:00:0009:00:0002196     100:01:00    90
         61998/10/0506:00:0009:00:0002200     400:04:00   283
         61998/10/0506:00:0009:00:0002250    1000:09:00   459
         61998/10/0506:00:0009:00:0002255     300:03:00   167
         61998/10/0506:00:0009:00:0003100     200:01:00     0
         61998/10/0506:00:0009:00:0003128     200:01:00     0
         61998/10/0506:00:0009:00:0003150     600:06:00   333
         61998/10/0506:00:0009:00:0003170     100:00:30     0
         61998/10/0506:00:0009:00:0003185     300:03:00   225
         61998/10/0506:00:0009:00:0003190     300:03:00   145
         61998/10/0506:00:0009:00:0003195     100:00:30    85
         61998/10/0506:00:0009:00:0003196     100:01:00    90
         61998/10/0506:00:0009:00:0003200     400:04:00   283
         61998/10/0506:00:0009:00:0003250    1000:09:00   459
         61998/10/0506:00:0009:00:0003255     300:03:00   167
         61998/10/0506:00:0009:00:0004150     900:04:30     0
        111998/10/0509:00:0012:00:0000128    2500:25:00     0
        111998/10/0509:00:0012:00:0000150    1300:10:00     0
        111998/10/0509:00:0012:00:0001128     000:25:00     0
        111998/10/0509:00:0012:00:0001150     700:20:00     0
        111998/10/0509:00:0012:00:0002150    1400:10:00   314
        111998/10/0509:00:0012:00:0002170     100:00:30     0
        111998/10/0509:00:0012:00:0002185     300:03:00   216
        111998/10/0509:00:0012:00:0002190     400:04:00   220
        111998/10/0509:00:0012:00:0002196     200:02:00   160
        111998/10/0509:00:0012:00:0002250    2000:18:00  1023
        111998/10/0509:00:0012:00:0003150     700:06:30   314
        111998/10/0509:00:0012:00:0003170     100:00:30     0
        111998/10/0509:00:0012:00:0003185     300:03:00   216
        111998/10/0509:00:0012:00:0003190     400:04:00   220
        111998/10/0509:00:0012:00:0003196     200:02:00   160
        111998/10/0509:00:0012:00:0003250    2000:18:00  1023
        111998/10/0509:00:0012:00:0004150     700:03:30     0
(etc.,...)

 

 

 

 
Site Designed by: www.MasterLink.com