4.3.9. Loading data (Mapping import)

4.3.9. Load Data (Mapping Import)

Imports an Excel file to update the mapping data used by "Place Items" in the "AdditionalComponents.json" file.

Ribbon Button: "AutoRouting" > "Load Data"
Command: PiCriLoadMappingData

Workflow:

1. Click "Load Data". A file dialog opens, defaulting to the "Resources" folder of the add-in.
2. Select an Excel file (.xlsx).
3. PiCri reads the workbook and converts each worksheet into a section of the JSON output.
4. The result is saved as "AdditionalComponents.json" in the "Resources" folder, replacing the existing file.

Requirements for the Excel file:

• The workbook must contain a worksheet named "Map" (the worksheet name becomes the JSON property name).
• Row 1 must be the header row.
• Column 1 contains the entry ID (key).
• Columns from column 2 onwards contain the data fields, whose headers match the JSON field names: "FirstPart", "SecondPart", "ConnectedItem", "Quantity", "ContentIsoSymbolDefinition".

Upon successful import, a confirmation message is displayed.