Export settings configuration

The Weld Manager export settings consist of the keywords listed below. These keywords must be present in one of the two configuration files as described below. The keywords can be added manually to the configuration files, or defined with the corresponding settings in the System Management application.

Keyword	Explanation	Configuration file	System Management setting
`outfile`	File name for the exported file. The usual keywords, including those found in Logistics > Logistical Field Options, can be used. See Logistical Fields Options.	%ncgnorms%\cvar\weld\weldmgr.cfg	Output Filename ¹
`outformat`	Output format for the export. The following values are supported: `Wiscon` – Export type Wiscon `Excel` – Export type Excel	%ncgnorms%\cvar\weld\weldmgr.cfg	Output Format ¹
`outpath`	Output directory for the export file. The usual keywords, including those found in Logistics > Logistical Field Options, can be used. See Logistical Fields Options. Note that the path must be enclosed in double quotes when added manually to the configuration file.	%ncgnorms%\lvar\weld\weldmgrlocals.cfg	Output Directory ¹
`processsinglewelds`	This keyword can be added to the weld configuration file with the value of `no` to prevent `Single` status welds from appearing in drawings, item information and weld reports. This keyword must be added manually to the weld configuration file. See Single and matched welds for more information.	%ncgnorms%\cvar\weld\weldmgr.cfg	No associated setting
`weldgroup`	Specifies which weld group data fields to include in weld reports.	%ncgnorms%\cvar\weld\weldmgr.cfg	Weld Group ¹
`weldname`	Specifies the format of the weld name. The usual general keywords can be used along with the special keywords `weld_method` and `unq`. The `weld_method` keyword is replaced by the name of the weld method in the output. The keyword `unq` is replaced by a number generated by the system, which is unique within the blocks. All of these keywords can be manipulated using the formatting feature, also known as the Field Format Editor in System Management Tools > Field Format Editor.	%ncgnorms%\cvar\weld\weldmgr.cfg	Weld Name Definition ²
`weldpartname`	Specifies how a part should be named. The usual keywords, including those found in Logistics > Logistical Field Options, can be used. See Logistical Fields Options.	%ncgnorms%\cvar\weld\weldmgr.cfg	Weld Part Name Definition ²
`xlstemplate`	Name of an Excel file to be used as a template for the Excel output, including the file path.	%ncgnorms%\lvar\weld\weldmgrlocals.cfg	Excel Template ¹
1) In settings group Import/Export > Weld Manager. 2) In settings group Construction > Welds&Bevels > Settings.

Export type Wiscon

This output consists of a customized XML file accompanied by a STEP file.

Export type Excel

When the output format is set to be an Excel file, the export result for Weld Manager is an Excel file which contains all the weld lines within the block. The table can be customized by editing the template file (see below).

The output format can be set with the outformat keyword in the weld\weldmgr.cfg file in the current norms, or with the Output Format setting in System Management > Import/Export > Weld Manager.

Excel template file

The Excel file specified by the xlstemplate keyword in the weld\weldmgr.cfg file in the current norms is used as the template for the exported Excel file. It defines both the header part and the content of the columns below the header in the Excel report. The template file can also be specified with the Excel Template setting in System Management > Import/Export > Weld Manager.

Important: The template file must be of type XLS, not XLSX.

The template file consists of the header part containing general information, and the last row containing the data for each weld line.

Header part

All of the cells in the template, except for those on the last row, are considered to be part of the header.

Cells in the header section that do not have a comment are copied as such to the header of the exported weld report XLSX file.
You can use general keywords like projectname, object and currentdate in the header section. The system uses the value of those keywords in the exported weld report. The template's cell formatting is used in the report. Therefore the cells in the template should not be blank but contain example data in the proper intended format like Text, Number or Date.

Last row

The last row in the template defines the content of the cells in the export. Cell contents are resolved values of the keywords contained in the cell comments. The template's cell formatting is used in the report. Therefore the cells in the template should not be blank but contain example data in the proper intended format like Text, Number or Date.

All logistical fields in the logistical database, including manually added logistical fields, can be used as keywords in the comments. Because a weld line connects two parts, you should add a postfix _1 or _2 to the logistical fields in the comments to indicate whether the keyword is for a part that has the weld, or a part that gets welded to the other part.

Postfix _1 indicates that the variable is for a part that the weld belongs to (first part).
Postfix _2 indicates that the variable is for a part that gets connected to the first part (second part).

The system recognizes the following additional keywords:

bevelcode – The bevel type as defined by the customized naming in the main3.dat file.
beveltype – The standard bevel type.
blockname_1 – The name of the block that the weld is located in.
blockname_2 – The name of the block that the welded part is located in.
blocknumber_1 – The number of the block that the weld is located in.
blocknumber_2 – The number of the block that the welded part is located in.
compartments – A list of Outfitting compartments that the weld crosses.
unq – A system-generated number that is unique to the block.
weldatt* – Content of the weld attribute as defined by the corresponding att* entry in the configuration file, where * represents the attribute number. See User-defined attributes.
weldcode – The weld code including the first, second and third part (XX.XX.X). See Weld Codes.
weldconnect – The first part of the weld code only (connection type). See Weld Codes, First Part.
welddrawing – Name of the last saved drawing containing the bevel attribute.
weldgroup – Defined in the weldgroup setting in System Management > Import/Export > Weld Manager.
weldlength – Length of the weld.
weldmat1 – Material of the 1st part to be welded.
weldmat2 – Material of the 2nd part to be welded.
weldname – Name of the joint as defined by the weldname entry in the configuration file
weldpart1 – The name of the 1st part to be welded as defined by the weldpartname entry in the configuration file.
weldpart2 – The name of the 2nd part to be welded as defined by the weldpartname entry in the configuration file.
weldsheet – Name of the last saved sheet drawing containing the bevel attribute.
weldstatus – The status of the weld: New, Skipped, Welded, Error, Misplaced or Locked.
weldth1 – Thickness of the 1st part to be welded.
weldth2 – Thickness of the 2nd part to be welded.
weld_level – The level of the weld, according to the hierarchy within the work breakdown structure.
weld_method – Name of the welding method.
weld_throat – Weld throat height.
welded_block – Defined in the Welded Block setting in System Management > Import/Export > Weld Manager.

Keywords can be formatted and combined with strings for even more customizable output.