Load From List

What

Automatically creates a part structure from a user-defined file.

Why

This command allows you to quickly create a series of parts within the current drawing.

How

You must first define an Excel file with the list of parts to be created automatically.

Once the command is launched, you will be asked to select an excel file through a dedicated dialog box. Once confirmed, the parts will be added to the current drawing as indicated in the file.

List creation rules.

A complete example is provided with the rules for defining the structured list parts at the path: %PUBLIC%\Documents\QS Informatica\QS2D XX\Samples.

The command creates a part for each row read from the Excel sheet and sets the attributes set in the columns inside them.

It also allows you to build a hierarchical structure using the two attributes "id" and "idparent". A part is assigned if its idparent matches the id of a previously created part.

Attribute Mapping

Textual

  • $name: Set the part name
  • "Attribute Name" - Sets the column content in the defined attribute (e.g. description - sets the description attribute)
  • id : assigns a unique identifier to the part (needed to structure parts)
  • idparent : the parent id to set to the part
  • POS. : shot peening position
  • $prtclass : classification (see attribute management )

Booleans

Part features that are considered according to the "true or false" logic.

Booleans are considered TRUE (YES) if not empty (put 1 for simplicity) otherwise FALSE.

  • .commerc: commercial part
  • .lck : non-editable part
  • hidden : part turned off
  • labunderline : UNDERLINED tree label
  • labbold : BOLD tree label
  • labitalic : ITALIC tree label
  • .notempty : protects from "delete empty parts"

Colours (AutoCAD)

  • labcolor : color tree label
  • .prtc : colore spotlight