How to show information legibly from multiple attributes in BOM reports – Elecworks tips and tricks

This Tip & Trick shows how to put legible information for multiple attributes in BOM reports.


As shown a long string in an attribute could be a bit clumsy in reports. Thanks to multiple attributes option, the information can be split onto several lines in the scheme by placing the pipe character “|” in the string.

Affichage des attributs multiples dans elecworks


As this character is saved in the tables too, the pipe character “|” is displayed also in reports when they are generated as drawings, making it difficult to read.

Lisibilité des attributs multiples dans elecworks


With this tip, the final result will be easier to read, without that character.

Attributs multiples dans elecworks


To do this, 3 things must be done
1) The character pipe “|” must be included in the field while paying attention to spaces. It will be the splitter for each line
For example “Main|cabinet”, has no space in between the words Main and Cabinet.

Attributs multiples dans elecworks


2) Symbol with multiple attributes
With the command Multiple attributes, any attribute can be converted to be displayed on multiple lines with this command, with as many lines as needed. You can also specify the distance between the lines.

La commande Attributs multiples dans elecworks


3) Remove the character “|” in reports
The reports must be edited in expert mode and the column with the pipe characters is modified with the SQL clause REPLACE, for example for the column for location description
tew_translatedtext_loc_to.tra_0 AS loc_des_to

The new syntax, to replace the pipe character with a space, will be
REPLACE(tew_translatedtext_loc_to.tra_0, ]]|[[, ]] [[) AS loc_des_to

nouvelle syntaxe dans elecworks

In the report manager, the result will be as seen below:

Gestionnaire de nomenclatures dans elecworks

And in the reports generated as drawings it will be as shown below:

Affichage des attributs multiples dans elecworks

Electrical Design rules and voltage drop calculation – elecworks Tips & Tricks

In this post, we will explain a new useful feature “Design rules check”

These electrical design rules are in the form of reports, and accessible by Project>Design rules check.

They can be used to verify particular details and easily detect any design errors, avoiding extra costs in the project design.
With this new report collection, we can check all design errors of the whole project.

There are 17 new reports to check from wires or connection points without connect up to too many contacts of the part:

  • Part assigned to component but not used
  • Duplicated connection pins
  • Duplicated equipotential in same location
  • List of components which have duplicated parent symbols
  • Template design rules
  • Empty terminal strips
  • Equipotential conflict
  • List of unreferenced elements
  • List of children symbols without parent symbols
  • List of uncabling wires
  • Too many contacts of the part
  • Overloaded pins
  • List of uncabling pins
  • Unused cables
  • Voltage drop in cables
  • Voltage drop for cables in harness
  • Wire without mark

Design rules check in elecworks 2014
In this collection, we want to remark that it has been included a calculation voltage drop reports in cables.

Drop voltage calculation in elecworks 2014

Specific data have been added to the cable properties to allow you to automatically calculate the voltage drop for a cable.

Specific data in cables in elecworks2014

With this kind of reports, we can check the power loss in a cable.

*Note: This is a basic calculation, for advanced calculation, Trace Software has available elecworks Facility, to size and design your electrical installation easily.