The bolt mapping feature allows Advance Steel to use a user-configured name for a specific bolt. This name can be used in both BOM lists and drawing labels through a special token that evaluates the mapped name and displays it.
The main steps required to create and use a bolt mapping are: setting the mapping priority, configuring the mapping and then the BOM template/label configuration for the derived document.
First we first need to turn on the mapping. This can be done by checking the default, "Mapping", which is in the Graitec Advance Manager / Defaults tab – in the category "Connecting elements / Anchors/Bolts".
1. Configuring the mapping priority.
The mapping priority is a series of tokens that form the name of the bolt that takes its mapping from the specific configuration.
This setting is a default value available in the Graitec Advance Manager / Defaults application, in the Structural BOM/NC category. The default name is Mapping bolts, priority 1.
For example, if we need for each different bolt class, material, set and diameter to get a different mapping, we need to set the default that controls the priority as follows: %Norm %Material %Set %Diameter.
The tokens that can be used to configure this default are: %Norm – bolt class name, %Diameter, %Set – assembly set, %Length, %Coating and %Material.
By having more tokens configured, we can have a more precise mapping. If the default is configured, for example, only with the token %Norm, and then we can have only one mapping definition line where we map the bolt class name to an external name, without the option to mapping multiple diameters, materials etc. of that bolt class name to multiple external names.
2. Mapping configuration.
In this section we will configure the mapping relations between the bolt name given by Advance Steel and the custom external name which we need to display in BOM lists and labels.
The mapping is done in the AstorAddIn.mdb database, as Advance Steel prioritizes this table over the AstorBase.mdb table which stores by default many mappings (for example for flat profiles).
To configure the mapping, open the AstorCurrentAddIn database with the Graitec Advance Manager Table editor, and then open the table called MapInternToExtern.
The table cells associated to a new entry are as follows:
⇒ Key: Unique number. If there are multiple lines that contain the same Internal name mapping, then Advance Steel will consider the one with the lowest Key number.
⇒ Internal – It needs to be filled with the original name, the one that requests the mapping. The format of this entry needs to match the attributes set in the Priority default.
⇒ External 1 – 4 – these four column cells contain the external name to which the bolt name is mapped. Each of them has a token associated for configuration.
⇒ The unconfigured cells can remain empty.
⇒ Description – free text for user description about a specific mapping. The information in this field does not have an option to appear in Advance Steel documents.
⇒ OwnerText – mapping owner.
Note: The names used as a source for mapping (in the Internal column) must be internal names, and not the ones that come from the “RunName” value in source tables.
For example, when we refer to the bolt assembly, we need to use the internal name which for a specific bolt assembly can be found as follows:
Open the database AstorBase.mdb and go to the Sets table.
The internal name is found in the Key column, while in the RunName column we have the interface name for that specific set. For example the 2NaW set has as internal name 2MuS.
Mapping configuration example:
Bolt that requires mapping:
Name: 6914
Material: 10.9
Set: Na2W
Diameter: 12mm
The configuration requires to:
- Add a new line to the MapInternToExternal table as follows:
- External1: name used for mapping, for example 6914-M12X
3. Label configuration
The mapped information from the External1 – 4 columns can be displayed in BOM templates and drawing (labels, detail names) through a series of contents / tokens named External 1 – 4 and they evaluate the respective column information if the object they are attached to corresponds to the mapping priority and value preset in the “Internal” column.
BOM template contents:
Drawing style label editor:
