The 5 basic rules for working with Database and Lists in electro-technical documentation
This article describes the 5 things you need to know in order to work with databases and lists quickly and effectively - in an advanced electro-technical CAD-program as PCschematic ELautomation
When having achieved reasonable skills in drawing PLC, wiring and power control circuit diagrams, you can save a lot of time by getting familiar with how to work with databases and lists. To phrase it in a popular way, you might say that there are 5 things you should know, in order to work with databases and lists effectively - in an advanced electro-technical documentation program as PCschematic ELautomation. 1. How to let PCschematic fill out lists automatically When creating electro-technical documentation projects, the applied components are represented by one or more electrical symbols - one symbol for each of the functions in the component. All of these symbols can have attached article data - e.g. an EAN13 number or a type description. This makes it possible for the program to fetch further data for the symbol/component in the attached database. When the project lists are to be filled out, the program therefore fetches information about which components that are used, directly from the drawn circuit diagrams. Based on this information the program fetches further information in the database, and the lists are filled out automatically. 2. How to create your own database To make this function the best, it is an advantage to be able to create your own database. This could for instance be done by just importing parts of the existing component vendor databases for the program. Data, which you already have electronically, can also easily be added to the database. Some companies choose to select a single person as responsible for handling the PCschemaitc database.
When you click on a component from one of the component databases, you automatically get a menu containing electrical symbols for all functions in the component. When placing these symbols, you simultaneously transfer data to the diagrams, which enables PCschematic to fill out ordering lists and to generate ordering files automatically
3. How to perform database maintenance When you wish to perform database maintenance, you should also know how to edit database information, update information from the applied component vendor databases, and how to add new components to the database. Here you can save time by learning how to create new components to the database graphically, as well as by learning how to design your own symbols. 4. How to Create, Insert and Update project Lists If you do not use the pre-defined list pages, which are included in the program package, it is a good idea to get
familiar with how to create lists in PCschematic ELautomation. - Or at least to learn how to easily adapt these lists to meet your own demands. You should then know how to easily insert these lists in the project, as well as how to quickly specify which components to include when generating the lists. Finally, you should know which command to apply, in order to have the lists filled out. 5. How to Export list files All list types in the program can be created as list files. When you e.g. wish to export a parts list to a storage management system, send an ordering file, a
wirenumber file, or a PLC I/O list to a PLC program, you should know how to create list files in few minutes. This takes a little effort from your side If you wish to learn how to do this on your own, this takes a little effort. However, the manuals for the program includes descriptions, in which you can see how to do - so this is definitely possible. A short-cut to also master this side of
electro-technical documentation, is taking a course in the program. The time spent on such a course, will be regained quickly in your daily work. Further information You may read more in the following articles: • The 10 basic rules for drawing Wiring and Power control circuit diagrams on PC • The 5 basic rules for working with electro-technical documentation projects
• The 5 basic rules for automatic creation of electro-technical documentation projects • The 5 basic rules for working with PLCs in electro-technical documentation projects