How To Import Part Spec Groups
Load many part spec groups (sets of interchangeable parts) at once from a spreadsheet, and optionally attach each group to the BOM lines that use it.Updated Nov 9 2026
Before you start
- Data Import is under Admin > APIs & More, shown to users with the Can View API & Import Submenu function (API Access role by default; Admin always).
- The Part Spec Groups import needs the Can Edit Part Spec Groups function (Admin, Manager, Engineer or Part Spec Group Admin role by default).
- If your file attaches groups to BOMs, the assemblies, their BOMs and the components must already exist.
-
Prepare the spreadsheet
Use one row per rule. A group with three interchangeable parts has three rows with the same Name.
Column Heading in the template Required? What goes in it Name nameYes The part spec group's name, for example Group A. Rows with the same name go in the same group. Rule ruleYes The part number this rule matches, for example PRT1. %is a wildcard and\%a literal%. The screen lists it under Suggested Columns, but a row without it fails.Rule Name rule_nameSuggested A name for the rule. Description descriptionNo The group's description. Top Level Prcpart top_level_prcpartNo An assembly whose BOM should use this group. Top Level Revision top_level_revisionNo The assembly's revision; leave blank for the current revision. Component Prcpart component_prcpartNo The component on that BOM that the group replaces. To get a file with these headings, pick the import in Cetec (next section) and click Download Template. Keep the template's headings (
name,rule, …): Cetec matches the columns automatically only when the headings are exactly these. -
Import the file
- Go to Admin > APIs & More > Data Import.
- In Import Type, pick Part Spec Groups. Available Import Columns lists the columns above.
- Click Choose File, pick your file, and click Import File. For a CSV file, check the CSV Delimiter first.
- In Import Preview, check the drop-down above each column names the right import column. If a drop-down shows (identify column) (your headings differ from the template's), pick the column there. Untick Use? on any row you don't want loaded; Cetec unticks the header row for you.
- Click Validate. Fix anything listed in Validation/Import Results (or untick that row's Use?), load the file again if you changed it, and validate again. A BOM problem is reported on its row, for example … has no BOM or component "…" is not on the BOM of ….
- When Cetec shows Validation completed successfully., click Import. Cetec shows Import completed successfully. with the number of rows imported, and a Download Import Summary link.
-
Check the groups
- Go to Parts > Part Spec Groups. The imported groups are listed.
- Click a group's Name and check its rules under PART SPEC RULES and the parts under PARTS IN SPEC (BASED ON PART SPEC RULES).