Skip to main content
Try for free

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

How To Import Part Spec Groups

Allow external media cookies to watch this video.

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.
  1. Prepare the spreadsheet

    Use one row per rule. A group with three interchangeable parts has three rows with the same Name.

    ColumnHeading in the templateRequired?What goes in it
    NamenameYesThe part spec group's name, for example Group A. Rows with the same name go in the same group.
    RuleruleYesThe 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 Namerule_nameSuggestedA name for the rule.
    DescriptiondescriptionNoThe group's description.
    Top Level Prcparttop_level_prcpartNoAn assembly whose BOM should use this group.
    Top Level Revisiontop_level_revisionNoThe assembly's revision; leave blank for the current revision.
    Component Prcpartcomponent_prcpartNoThe 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.

  2. Import the file

    1. Go to Admin > APIs & More > Data Import.
    2. In Import Type, pick Part Spec Groups. Available Import Columns lists the columns above.
    3. Click Choose File, pick your file, and click Import File. For a CSV file, check the CSV Delimiter first.
    4. 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.
    5. 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 ….
    6. 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.
  3. Check the groups

    1. Go to Parts > Part Spec Groups. The imported groups are listed.
    2. 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).