The DPAccess.csv file contains all downpipe accessory definitions that link to specific downpipe products through matching product codes.
🧾 How accessories link to downpipes
Accessory definitions are linked to downpipes by matching product codes. For example, a downpipe with product code DSR/0.45/100/50/2400/CB will use the accessory group that starts with the same code in the DPAccess.csv file.
🔧 File structure
The file follows this format:
;Description,Code,Gauge,Finish,Items per Box,Cost,No. per Est. Method,Est. Method,Mat. = 0 / Lab. = 1
Field definitions
Field | Description |
Description | Name of the accessory (e.g., "100 x 50 Dropper", "Strap", "Offset") |
Code | Product code for the accessory (same accessory can be used on multiple downpipes) |
Gauge | Base metal thickness or gauge of the item |
Finish | Surface finish such as painted, galvalume, etc. |
Items per Box | Number of items supplied per box (use 1.0 for single items) |
Cost | Cost for the item or box of items |
No. per Est. Method | Quantity used per downpipe length or per downpipe item |
Est. Method | How the accessory is estimated (see estimation methods below) |
Mat./Lab. Flag | 0 = Material cost item, 1 = Labour cost item |
🛠 Estimation methods
Method | Description | When to Use |
0 | Not estimated | Items that don't contribute to costs |
1 | Spaced Along the Downpipe | Items installed at regular intervals (e.g., straps every 1200mm) |
2 | Per DP | One item per downpipe (e.g., droppers) |
3 | Per DP (Offset) | Offset connections per downpipe |
4 | Optional (included) | Optional items included in base estimate |
5 | Optional (excluded) | Optional items excluded from base estimate |
6 | Per Join | Items used at connection points |
🛠 Example accessory group
Here's how a complete accessory group appears in the file:
;DSR/0.45/100/50/2400/CB,100 x 50 Dropper,DP/100/50/Za,0.450000,C/B,1.0,2.120000,1.000000,2,0
Strap,DSC/100/50/C,0.450000,C/B,1.0,1.120000,1200.000000,1,0
Offset,Up To 600mm,0.450000,C/B,1.0,3.120000,300.000000,3,0
Boot,,0.450000,C/B,1.0,0.000000,1.000000,4,0
Elbow,,0.450000,C/B,1.0,0.000000,1.000000,4,0
This example shows:
Dropper: One per downpipe (method 2), costs $2.12
Strap: Spaced every 1200mm along downpipe (method 1), costs $1.12 each
Offset: Per downpipe offset (method 3), spaced every 300mm, costs $3.12
Boot and Elbow: Optional items included in estimate (method 4), no cost assigned
💡 Tips for editing the file
Each accessory group starts with a semicolon (;) and the downpipe product code
Maintain consistent formatting for product codes and finishes
Use 0.000000 for zero costs
The "No. per Est. Method" field controls spacing - for straps, this might be 1200 (mm between straps)
Always include all standard accessories even if cost is zero
⚠️ Important notes
Product codes must exactly match between downpipe and accessory files
Finish codes should be consistent (e.g., use either "Za" or "Z/A" throughout)
Each accessory group must end with a semicolon on its own line
Labour items (flag = 1) are used for installation costs separate from material costs