 |
Applies to: STACK-IT Version 7.5 and higher. |
Block File Format
The Block file format is not quite as simple, but can contain much more information from the Stack-It Quote file. This file format is used when there is a need to transfer detailed information not available in the Record file format , such as elevations and other stacking data.
This file structure contains blocks of data where each block of data is identified by a block marker indicating the type of data, followed by the data.
 |
Setup Process - Configuring and activating the file mirror. | ||||||||||||||||||||
|
Content Details - How the exported data is packaged.
| ||||||||||||||||||||
|
|
The file mirroring is typically set up by the system administrator using the steps listed below.
|
Select the Mirror File Configurations screen. (Main-> Admin-> Files-> Quote Mirror) |
|
In the "Available Content" list, select the data items to be included in the export file. Add these items to the "Utilized Content" list. The order in which the items appear in the "Utilized Content" list is automatically determined so that related data items will be kept together. |
| In the File Format list, choose the delimiter to be used in the export file. (Comma Separated, Tab Delimited, Carriage Return, or Semicolon) |
|
In the Output Units frame, choose the output units of measure. |
|
To have the unit of measure labels included in the export file, check the box labeled "Export Unit Labels". |
|
in the "Output Path" box, click the Browse button and select the directory location to receive the export files. |
|
The final step is to check the box labeled "Activate Quote Mirroring". |
Once
it is set been activated, each time a quote file is saved, the mirror
function will automatically save an export file in the specified location
that contains the selected content and formats.
return to top
The selected content is placed in the export file in related groups or blocks. Each block begins with a marker to identify the type of block followed by the data for that block.
The File Header block is always included in the export file. All the other blocks are included only if data from that block is selected. Blocks with no data selected for export are omitted from the export file.
The Structure and Stack blocks will be repeated for each structure in the estimates (if they have data selected).
The following tables identify
each of the block types. The examples
shown contains all possible data. In most cases, only a fraction of the
available data will be used.
return to top
File
Header Block
The File Header block is always present.
| Data | Example |
| Marker Product Name File Version Copyright Address |
:AMS STACK-IT Manhole Estimator 6 Copyright 1992-2000 by Advanced Management Systems Inc. P.O. Box 3611 - Federal Way - WA 98063-3611 |
Date
Block
The Date block identifies the date estimate was created. It is present if
data is selected, otherwise it is omitted.
| Data | Example |
| Marker Quote Date |
:DATE 01-15-1999 |
ID
Block
The ID block contains the Quote identifier number for the current estimate. It
is present if data is selected, otherwise it is omitted.
| Data | Example |
| Marker Quote ID |
:ID 99010011 |
Name
Block
The Name block contains the two job name lines for the current estimate. It is
present if data is selected, otherwise it is omitted.
| Data | Example |
| Marker Job Name Line 1 Job Name Line 2 |
:NAME Metromont Subdivision Basic Storm Layout |
Address
Block
The Address block contains the location, contact, tax rate, and job notes for
the current estimate. It is present if data is selected, otherwise it is
omitted.
| Data | Example |
| Marker Location Line 1 Location Line 2 Location Line 3 Contractor Engineer Salesman Plant Delivery Date Tax Rate Job Notes |
:ADDR 1234 West Avondale Richmond County Williamton, AZ Renauld Developers Alfred Jones Jeanette Williams South Division 11/2/1999 8.75 These are the job notes on the cover page. |
Discount
Block
The Discount block contains the discount data (size, component, percentage) for
the current estimate. It is present if data is selected, otherwise it is
omitted.
| Data | Example |
| Marker Discount Data | (repeats for each discount record) | |
:DISC 18",A-Lok,-25 48",Cone Conc. W/32"O,-10 48",Cone Concentric,-10 |
Rules
Block
The Rules block contains the stacking limitations and preferences for the
current estimate. It is present if data is selected, otherwise it is
omitted.
| Data | Example |
| Marker Max Height, Active Max Weight, Active Min Parts, Price, Weight |
:RULES 15240,1 2585476.066,0 1,1,0 |
Freight
Block
The Freight block contains the data used to calculate the freight charges for
the current estimate. It is present if data is selected, otherwise it is
omitted.
| Data | Example |
| Marker Load Weight, Rate, Distance, Unload Rate |
:FREIGHT 14000.0lb,255,0,12.3 |
Structure
Block
The Structure block contains the engineering and selection data used in the
stacking process. This block contains the data for a single
structure. It is present if data is selected, otherwise it is omitted.
This block is repeated once for each structure in the estimate.
| Data | Example |
| Marker MH ID, Spec, Type, Size, Rim, Reducer Invert-1 Elev, Deg, Pipe, Dia, Connector Invert-2 Elev, Deg, Pipe, Dia, Connector Invert-3 Elev, Deg, Pipe, Dia, Connector Invert-4 Elev, Deg, Pipe, Dia, Connector Invert-5 Elev, Deg, Pipe, Dia, Connector Invert-6 Elev, Deg, Pipe, Dia, Connector Invert-7 Elev, Deg, Pipe, Dia, Connector Invert-8 Elev, Deg, Pipe, Dia, Connector Catch Depth, Catch Reference Component Select - Rim, Gasket Component Select - Adjust , Gasket Component Select - Top, Gasket Component Select - Stack, Gasket Component Select - Reducer, Gasket Component Select - Stack, Gasket Component Select - Base, Gasket Component Select - Reserved Int. Coating, Cat ID, Ext. Coating, Cat ID Structure Notes Step Part, Spacing, Location, Mode |
:ITEM Manhole #1,Seattle,Type 1 Sanitary,48",45.66',0' 35.55',120,PVC SDR35,10",8" A-Lok 340,35.488',11.5" 35.77',330,PVC SDR35,8",A-Lok 285,35.697',9.75" 35.697',0,,0",,0',0" 0',0,,0",,0',0" 0',0,,0",,0',0" 0',0,,0",,0',0" 0',0,,0",,0',0" 0',0,,0",,0',0" 1524,0 Ring & Cover-Not Furnished, 0 Grade Rings, Cone Concentric, Riser, MJ Cone Concentric, 0 0" Integral Base|3', 0 Epoxy|10 mil,Epoxy|5 mil MH #1 - Structure Notes. Rung|1.333', 225°,AUTO |
Stack
Block
The Stack block contains the actual list of materials for a single
structures. It is present if data is selected, otherwise it is omitted.
This block is repeated once for each structure in the estimate.
When both the Structure and Stack blocks are included, the Stack block immediately follows its associated Structure block.
| Data | Example |
| Marker Part Count Part Record | | Each part record may have: Size, Component, Catalog ID (Cat ID), Product Code, Price, Adjusted Price, Cost, Weight, Height | | |
:STACK 15 24",Ring & Cover-Not Furnished,4.5" Alpha,,0,0,0,0lb,0' 4.5" 24",Grade Rings,3",GR3,18,18,0,230.0lb,0' 3" 48",Cone Concentric,2',48AC2FT,124,111.6,0,1734.0lb,2' 0" 48",Riser,5',485F,325,325,0,4320.0lb,5' 0" 48",Integral Base,3',48AORMB,380,380,0,3830.0lb,3' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0",Rung,1.333',Stp16,2.5,2.5,0,0lb,0' 0" 0.495",Epoxy,10 mil,epx3,2.5,2.5,0,1.0lb,0' 0" 0.574",Epoxy,5 mil,epx3,1.43,1.43,0,1.0lb,0' 0" 8",A-Lok,340,340 ALoc,10.25,10.25,0,1.0lb,0' 0" 0",A-Lok,285,285 ALoc,8.5,8.5,6.25,1.0lb,0' 0" |
| Configuration Selections |
 |
| Export File Contents |
:AMS STACK-IT Manhole Estimator 6 Copyright 1992-2000 by Advanced Management Systems Inc. P.O. Box 3611 - Federal Way - WA 98063-3611 :ID 99010011 :NAME Metromont Subdivision 11/2/1999 :ITEM Manhole #1,Seattle,Type 1 Sanitary,48" :STACK 7 24",Ring & Cover-Not Furnished,4.5" Alpha,,0,0 24",Grade Rings,1",GR1,6,0 24",Grade Rings,1",GR1,6,0 48",Cone Concentric,2',48AC2FT,111.6,0 48",Riser,5',485F,325,0 48",Integral Base,3',48AORMB,380,0 0",A-Lok,285,285 ALoc,8.5,6.25 :ITEM Manhole #2,New,Area Inlet,30" x 30" :STACK 4 30" x 30",Frame & Grate,9",FG30X30,386,0 30" x 30",Area Inlet,0.762M,303002,85,65 0",A-Lok,285,285 ALoc,8.5,6.25 0",A-Lok,285,285 ALoc,8.5,6.25 :ITEM Manhole #3,Seattle,Type 2 Reducing,60" :STACK 39 24",Ring & Cover-Not Furnished,4.5" Alpha,,0,0 24",Grade Rings,3",GR3,18,0 48",Cone Concentric,2.5',48AC2.5FT,139.5,0 48",Riser,3.5',483.5F,227.5,0 60",Reducing Slab,1',RDSL6,236,0 60",Riser,3,R603,258,0 60",Riser,5,R605,430,0 60",Riser,5,R605,430,0 60",Riser,5,R605,430,0 60",Riser,1.5,R601.5,129,0 60",Integral Base,2',IB602,432,0 60",Base Charge,,,50,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 0",Rung,1',Stp12,2.5,0 1.596",Epoxy,10 mil,epx3,2.5,0 0.108",Epoxy,15 mil,epx3,3.75,0 |
A Customer Focused Corporation…