The Fasten_V6.csv file contains all fastener data for your roofing projects. This is the current format that replaced the legacy Fasten.csv file.
🧾 File Format Overview
The Fasten_V6.csv file uses a comma-separated format with specific fields for each fastener product. Here's the basic structure:
; Fastener definition file for Roof Wizard
;Supplier, Size, Description, Code, Items per unit cost, Not used, Plain cost, Color cost
Supplier, 12x65, Hex Head type 17, F1265HT17, 1000, 0, 166.98, 192.46
END
🔧 Field Definitions
Field | Description | Character Limit |
1 | The name of the supplier | 25 |
2 | The size of the fastener | 25 |
3 | A description | 25 |
4 | A unique product code | 25 |
5 | Product Finish | 25 |
6 | Number of fasteners per box | - |
7 | Type – mechanical, liquid or roll (0 – mechanical, 1- liquid, 2 – roll) | - |
8 | Cost per box for fasteners | - |
9 | Unused | - |
💡 Important Notes
Product Code as Primary Key: The fastener product code (Field 4) is the primary key that sheeting and flashing products use to find the correct fastener information. Ensure each code is unique.
Simplified Pricing: Compared to the old Fasten.csv file, the cost is now per product type and every product needs a unique product code. The different pricing for painted or plain became redundant, so Field 9 is now unused.
Character Limits: Some fields have character limits indicated in brackets (e.g., [25]). Stay within these limits to avoid data truncation.
⚠️ Legacy File Information
You may find an old Fasten.csv file in your ..\User folder from earlier installations. This is a redundant file that has been superseded by Fasten_V6.csv and is no longer used.
If you imported data from an old Fasten file, you may notice values in Field 9. These values are ignored by the current system.
Key Differences from Legacy Format:
Field 8 in legacy format: Cost per box for plain fasteners (zinc or galv)
Field 9 in legacy format: Cost per box for coloured fasteners
Field 8 in V6 format: Cost per box for fasteners (single pricing model)
Field 9 in V6 format: Unused
🛠 Example Entry
Here's how a complete fastener entry should look:
AcmeFasteners, 12x65, Hex Head type 17, F1265HT17, Galvanised, 1000, 0, 166.98,
Note the empty Field 9 at the end - this maintains the correct field structure.