Configuration

In order to map the JSON pre item to CadConnect, first a field mapping configuration needs to be applied.

A mapping configuration always needs to be created based on a JSON pre item.

This configuration is available for all users of CadConnect within the Business Central company, making it possible to share configurations among users.

Upon activating “Create Configuration” please enter a name for the configuration and select the relevant import structure.

Then it is time to map the fields from the JSON pre item to the CadConnect fields.
Click the three dots on the right to get a list of keys available to map.

Item related Fields

First section hold the mapping of data-fileds, that will end up as fields in the Item card.

BOM related Fields
Next section hold the mapping of data-fileds, that will end up as fields in the BOM lines.

Template Fields
If you have set up advanced templates, the next section will hold the mapping of the Template definition fields.
For setting up and using templates, please refer to the description in CadConnect setup and extended description in section Using Advanced templates

Attribute Fields
If you have set up Attributes to be imported through CadConnect, the next section will hold the mapping of these Attributes.

Variant Fields
If you in the Setup have selected to use Item variants, the next section will hold the mapping of these Variants.
You can import up to 8 variants pr. Item. You can import existing Variants or add new variants.
When adding new variants, you can here also here supply the variant description.

Dimension Fields
If you have set up Dimensions to be imported through CadConnect, the next section will hold the mapping of these Dimensions.
You can import existing Dimension Values or add new Dimension Values.
When adding new values, you can here also here supply the Dimension value name.

Routing/Operation Fields
You have the possibility to import either references to existing routings or new operations lines that then will end up as a new routing in CadConnect and BC.
You have one Setup Field to concern: Default Resource Type (Work Centre or Machine Centre). When you import operations and thereby resource no. the system will look in the Setup to define what type the imported resource should have.

!Please note, you can only import operations using existing resources. CadConnect does not have the ability to create new resources as this implies serious considerations regarding posting groups, costing, capacity planning and so on.

If you set an import reference for Routing No. then the values imported from that column must match an existing BC Routing. This will then be added as routing to the item found on the same line in Excel or the item found on the line just above the routing line, if there are no item reference in the Excel row with the Routing reference.
If you set import references for Prod.Res.No. then the values imported from that column must match an existing BC Resource of the type selected in Setup. This will then be added as an operation to the item found on the line just above the first routing line. Additional lines will be added as operations on the same routing. The operations will be filled with relevant data from the columns specified in the following import references.
The mapping of Routing/Operation data is done in the next section.

Item Links
If you want to import File Links you must select the number of Links in Setup – up to 10, and do the mapping in the next section.
You can in Setup define whether these Links shall be transferred to Items or to BOMs.
The File Names will be transferred to the Description Field in Links and the File Addresses will be transferred to the LinkAddress Field in Links.

!Please note, that these values are handled by CadConnect as simple texts. There are no validation in CadConnect whether the File Links you import exists, are accessible and/or readably. This is your responsability to ensure that.