Skip to content
CadActiveSupport

howto

CSV and Excel Format

CSV and Excel headers AutoAssemble reads when assembling models in Creo.

CSV and Excel (.xlsx) share one header-row parser. The first row is headers (case-insensitive). Blank rows and rows with an empty model name are skipped.

The file dialog groups these as Auto Assemble File. Run the command with Assemble from a File. Sibling formats: JSON Format, XML and NWF Format. Worked jobs: AutoAssemble Examples.

Two header modes

  1. Tree builder — requires MODEL_NAME, LEVEL, and TYPE (or MODEL_TYPE). Builds nested assemblies. First data row must be LEVEL 0 (the top assembly). LEVEL may increase by at most 1 per row. Walkthrough: File-Driven Model Tree.

  2. Mate into the current assembly — requires MODEL_NAME (alias MODEL_ID). Optional CSYS, interface, designation, and mate-to columns. Every row is assembled into the selected assembly. No LEVEL 0 row. Walkthroughs: Schematic Assembly, Assembling Backshells to Connectors.

Tree builder

csv
  • LEVEL 0 defines the top assembly (not assembled as a child). If Creo already has a current assembly, AutoAssemble still reads that row as the file’s top model name, then uses the selected assembly as the output.

  • If a named model does not exist and Create Models if Not Found is on, AutoAssemble creates it from the default start part (or empty if that start part cannot be copied).

Mate into the current assembly

csv

Default CSYS names: part PRT_CSYS_DEF; assembly ASM_DEF_CSYS (fallback ASM_CSYS_DEF). MATING_CSYS of <DEFAULT> uses default placement. Empty MODEL_CSYS uses the placing model’s default CSYS.

Identity columns

Header

Aliases

What it does

MODEL_NAME

MODEL_ID

Creo model name. Required in both modes. Family-table instances need the full name, for example INSTANCE001<FAMILY_NAME>.PRT.

TYPE

MODEL_TYPE

ASM, PRT, SKEL, and similar. Required for the tree builder.

LEVEL

BOM indent. 0 is the top assembly. Required for the tree builder.

SUB_TYPE

Refines type — for example PRT + SKEL is a skeleton part. Skeletons are added as skeletons, not packaged parts. Bulk, skeleton, and harness creation uses TYPE / SUB_TYPE, not COMPONENT_TYPE.

MODEL_TEMPLATE

Start-part / template model name when creating a new model.

DESCRIPTION

DESIRED_DESCRIPTION

Model common name.

Designation and grouping

Header

Aliases

What it does

DESIGNATION

REF_DES, REFDES, DESIRED_DESIGNATION, MTAGNAME, or the organization setting for the ref-des component parameter

Designation applied to the assembled component. How it is stored is the Designator method — see Designator.

COMPONENT_TYPE

Stored label only. Common values: CONNECTOR, BACKSHELL, BULK, SKELETON, HARNESS. Does not change placement.

GROUP

COMPONENT_GROUP

Model-tree group. Nested groups use /.

COLOR

Named color or RGB string.

Mating columns

Three roles: CSYS or interface on the component being placed, which existing component receives it, and CSYS or interface on the receiving side.

Role

Preferred header

Aliases

CSYS on placing model

MODEL_CSYS

MODEL_PLACEMENT_CSYS, CSYS_FROM

CSYS on receiving model

MATING_CSYS

MATING_PLACEMENT_CSYS, CSYS_TO

Interface on placing model

MODEL_PLACEMENT_INTERFACE

MODEL_INTERFACE_NAME

Interface on receiving model

MATED_RECEIVING_INTERFACE

MATING_RECEIVING_INTERFACE, MATED_INTERFACE_NAME

Mate-to component (designation)

MATE_TO

CONNECTED_TO_COMPONENT, MATING_BLOCK_NAME, PARENT_MTAGNAME

Mate-to port / CSYS on that component

CONNECTED_TO_PORT

MATING_BLOCK_CONNECTORNAME

CSYS-to-CSYS does not need mate-to component columns. Mating onto a designated component needs MATE_TO + CONNECTED_TO_PORT and either both interface columns or both CSYS columns. Organization default interface names are not applied if those columns are blank.

Anything listed as MATE_TO is assembled before the rows that point at it, so connectors do not have to appear first in the file.

Offsets, drawings, and parameters

Header

What it does

XOFFSET, YOFFSET, ZOFFSET

Translation applied to the placement. Headers such as XOFFSET(MM) are also accepted.

XTHETA, YTHETA, ZTHETA

Recognized but rotation is not applied. Translation only.

CREATE_DRAWING

Y, YES, X, or TRUE (any case) creates a drawing.

DRAWING_NAME

Drawing name. Skip if blank.

DRAWING_TEMPLATE

Optional start drawing.

MODEL_PARAM_FOO or <MODEL>FOO

Model parameter FOO.

COMP_PARAM_FOO or <COMP>FOO

Component (feature) parameter FOO.

CONN_PARAM_FOO or <CONN>FOO

Cabling connector parameter FOO.

Any other header

Carried as an extra value (typically a component parameter). Names cannot contain spaces.

<INDEX>, <IGNORE>, <SORT>

Ignored.