The Job Import Tool option allows the user to accept inputs from other systems such as MAP Remote Entry, ERP, Excel files, 3 rd Part CAD drawings to produce a job of items ready and configured for manufacturing.
Attributes such as Specification, Material and Quantities can be sent to the conversion tool from these alternative systems. Connectors, Seams, Airturns etc can also be allocated if different to the automatic assignment of the active Specification: - DW144, SMACNA, etc.
The CAMduct software application comprises of Libraries of Ductwork Pattern Templates that can be customized and organised, by the Manufacturer, into Windows Folders. Each Pattern Template has a Pattern No. which defines the Shape of the Pattern. A List of required Dimensions and Options can be entered to determine it overall Developments.
Patterns can be configured with preset dimensions or attributes ready for the import file to automatically assign the unique values that are required, such as Width, Depth, Length, Specification, Materials etc.
The patterns can be placed into a folder structure of your choice so long as the over arching folder attribute is set to " JCM Conversion ".
Some manufacturers may like to have customer specific folders as the patterns may require different attributes on the items or variant costing details assigned.
Right Click on the highest level folder where the patterns are all contained and select Properties of the folder. As shown in the example below for the Common Parts folder, the master system should have the JCM Conversion type assigned ready for when the import occurs.
ASCII File Breakdown Each Dimension of an item can be processed along with Specification, Material, Pattern options etc. The Specification will determine Gauge, Standard Straight length, Connectors, Seams, Supports, Stiffening requirements etc which can be setup on the master system ready for the import file.
See Appendix A for Job Information breakdown of the ASCII file and Appendix B for an Item breakdown.
Dimensions are specified from the source whether this is from a CAD package, Excel import or ERP system. Appendix C details an example of some duct pieces and how they should be processed. The example identifies the format which is required for the conversion and also specifies the validation for selecting dimension fields such as the Offset Width of a Square to Round "Central".
Appendix A - Job details defined
Key: For readability we have added the color symbol that should be taken out when creating the conversion file. * = When allocated denotes the field as a requirement.
JOB_START * JOBHEADER_START * JOB_NAME (type = FILENAME) If not supplied the Job Name will be UNTITLEDXXX where XXX is the first available number that creates a Job that does not already exist in the current project area. JOB_REFERENCE (type = TEXT) A reference name for the Job JOB_DATE (JOB_DATE, type = TEXT) Note that the software does NOT check that this is a valid date entry. COMPANYADDRESS_START (type = TEXT) Enter address is applicable. COMPANYADDRESS_ENDCUSTOMERADDRESS_START (type = TEXT) Enter address is applicable. CUSTOMERADDRESS_ENDPROJECTAREA_START (type = FILENAME) A list of folders that form the path to the folder in which the Job will be created. The root folder is the default Project Area set up on the Master system. For example, if this section contained the entries CUSTOMERA FLOOR2 ROOM3 and the Job Name was set to F2-R3 with the default Project Area on the Master System being C:\MAP-Software\Shared\Projects , then the Job would be saved as C:\MAP-Software\Shared\Projects\CUSTOMERA\FLOOR2\ROOM3\F2-R3.MAJ If this information is not supplied the Job will be saved in the default Project Area. PROJECTAREA_END ARCHIVE (option = {YES/NO}) Should the database on the Master system be saved with this Job? The default is set to NO. FIELD1 (type = TEXT) Additional job information can be inserted using this field. FIELD2 (type = TEXT) Additional job information can be inserted using this field. PROCESS (type = TEXT) Process Name of process to be started automatically once job loaded. Only used if job is auto-loaded as batching option JOBHEADER_END* ITEM_START*<ITEM Details to be inserted at this point ( Appendix B). See example (Appendix C) for example structure > ITEM_END* JOB_END*
Appendix B - Item details defined
Key: For readability we have added the color symbol that should be taken out when creating the conversion file. *= When allocated denotes the field as a requirement.
ITEM_START*
ITEMHEADER_START* Group Option Start Only one of the following group options should be present in any Item. The ITEMFILE method or PATTERN_CID are recommended for both speed and flexibility. The behavior of this option is not defined if more than one of these group options is present in a single item.
PATTERN_NUMBER (type = INTEGER) A unique number determined by the software to identify a particular base fitting. This method cannot be used to select fittings which have been created by copying and editing base fittings, though it can be used if the base fitting has only been edited. The fitting template file must be in the default fittings folder. The behavior of this option is not defined if the default folder contains more than one fitting with the same pattern number.
PATTERN_CID (type = INTEGER) A user defined number which identifies a particular fitting. The fitting template file must be in the default fittings folder. The behavior of this option is not defined if the default folder contains more than one fitting with the same pattern CID.
PATTERN_ALIAS (type = TEXT) A user defined text string which identifies a particular fitting. The fitting template file must be in the default fittings folder. The behavior of this option is not defined if the default folder contains more than one fitting with the same pattern alias.
ITEMFILE (type = FILE) The full path and filename to the required fitting template (.ITM) file. (Path + Filename)
PATTERN_REF (type = TEXT) A user defined text string which gives the full path & filename to a fitting template through the use of a lookup table. Group Option End
PRODUCT_NAME (type = TEXT) Required for Product Lists. The Product Description for a Product List. Required to specify which entry in a product list is used.
ITEM_NUMBER* (type = TEXT) The name that will be given to this item in the Job.
SPEC (type = TEXT) The name of the Specification that will be used for this item. This must match a Specification name on the Master system that is valid for this particular fitting. (Specs can be found in the Pattern Database > Specifications). If not supplied the Specification for the fitting will be set to None.
MATERIAL* (type = TEXT) The name of the Material that will be used for this item. This must match a Material name on the Master system. (Main Database > Materials)
Group Option Start Only one of the following Group Options is required, though both may be present. If both are present the GAUGE entry will be used if the Master system is set to Metric configuration, and the WIRE_GAUGE entry if set to Imperial.
GAUGE (type = DECIMAL) Required Group Option The thickness of the Material that will be used for this item and best used if not determining a Specification.
WIRE_GAUGE (type = INTEGER) Required Group Option The wire gauge equivalent for the thickness of the Material. Group Option End
GAUGE_RANGE (type = DECIMAL) The additional thickness of material that the parts can be cut out using to save Wasted material on nests. Default value is 0
DOUBLEWALL (option = {INSIDE/OUTSIDE/OFF}) Include to specify whether a fitting should be made with two skins. If not supplied then the data is picked up from the base fitting. If double wall is specified then Insulation MUST also be specified, as this defines The thickness between the skins. If Double wall is set to INSIDE or OUTSIDE then the following groups are required
DOUBLEWALL_ENTRY (option ={INSIDE/OUTSIDE}) Required Group Option Whether the dims specified are the INSIDE or OUTSIDE skin dimensions
DOUBLEWALL_MATERIAL (type = TEXT) Required Group Option The Material name of the second Skin
One of the following MUST also be specified
DOUBLEWALL_GAUGE (type = DECIMAL) The true thickness of the second Skin
DOUBLEWALL_WIRE_GAUGE (type = INTEGER) The wire gauge of the second Skin
QUANTITY* (type = INTEGER) The quantity of items to be produced.
INSULATION_MATERIAL (type = TEXT) Optional (Required for DOUBLEWALL ) The name of the Material that will be used for the insulation for this item. This must match a Material name on the Master system. If not supplied the Insulation will be set to None.
INSULATION_GAUGE (type = DECIMAL) Optional (Required for DOUBLEWALL)
INSULATION_SIDE (option = {INSIDE/OUTSIDE}) Optional - NOTE this should not be used for DOUBLEWALL entry
FACINGS_START (type = TEXT)
FACINGS_END
NOTES (type = TEXT)
ORDER_NUMBER (type = TEXT)
PALLET (type = TEXT)
HOLES (type = INTEGER) Optional - Entry of the number of holes required as a value within this header. Dimensions and Options used for the holes such as Width, Depth and Offset values for the hole should be listed under the DIMS_START field or as options respective to the pattern in use.
EXTRAFTIME (type = DECIMAL)
EXTRAETIME (type = DECIMAL)
ITEMHEADER_END
DIMS_START (type = DECIMAL) The dimensions that determine the size of the fitting. If the number of dimensions supplied is less than the number required by the fitting template then the remaining dimensions will be the same as the fitting template. If the number of dimensions supplied is more than the number required by the fitting template then the extra dimensions will be ignored. The dimensions must be supplied in the correct order taking into account if the master system has locked dimensions. These will then be ignored so the next unlocked dimension is used.
DIMGROUP_STARTNot implemented
DIMGROUP_END
DIMS_END
OPTIONS_START (type =DECIMAL) The options that control various aspects of the fitting. If the number of options supplied is less than the number required by the fitting template then the remaining options will be the same as the fitting template. If the number of options supplied is more than the number required by the fitting template then the extra options will be ignored. The options must be supplied in the correct order taking into account locked Options as per the dimensions example.
OPTIONS_END
CONNS_START ( type =TEXT) The names of the Connectors that will be used by the fitting to be listed as shown in the example for "DM-25" Slide on Flange. Both C1 and C2 can be specified. If the pattern supports additional connectors you can list C3, C4 etc The connectors must be supplied in the correct order. These must match with Connector names on the Master system (Pattern Database > Connectors > Select the Pattern Group from the list)
CONNS_END
CONN_POSITION_START
INSERTION_POINT (type = DECIMAL) Co-ordinates to be specified in the drawing separated by commas
DIRECTION_VEC (type = DECIMAL) Co-ordinates to be specified in the drawing separated by commas
WIDTH_VEC (type = DECIMAL) Co-ordinates to be specified in the drawing separated by commas
CONN_POSITION_END
SEAMS_START (type =TEXT) The names of the Seams that will be used by the fittings These must match with Seam names on the Master system. The seams must be supplied in the correct order.
SEAMS_ENDIf Double wall is specified then the following options are also required:
DOUBLEWALL_CONNS_START (type =TEXT) The names of the Connectors that will be used by the fitting for the second Skin These must match with Connector names on the Master system The connectors must be supplied in the correct order.
DOUBLEWALL_CONNS_END
DOUBLEWALL_SEAMS_START (type =TEXT) The names of the Seams that will be used by the fitting for the second Skin These must match with Seam names on the Master system The seams must be supplied in the correct order.
DOUBLEWALL_SEAMS_END
SPLITTERS_START (type =TEXT) The names of the Splitters that will be used by the fitting. These must match with Splitter names on the Master system. The splitters must be supplied in the correct order if there are multiple sets.
SPLITTERS_END
AIRTURNS_START (type =TEXT) The names of the Airturns that will be used by the fitting. These must match with Airturn names on the Master system. The airturns must be supplied in the correct order if there are multiple sets.
AIRTURNS_END
CUSTOM_DATA_START (type = TEXT) Identify custom data that is assigned to the item.
CUSTOM_DATA_END
ITEM_END
JOB_END