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.

Problem:

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

Benefit:

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

Attributs multiples dans elecworks

Process

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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.