Path:
Disciplines > ECAD > EPLAN Electric P8 > Parts database
In order to work with EPLAN Pro Panel, it must be possible to access the parts database. There are corresponding methods for this in the formula language, as well as model variables. The advantage of model variables is that SQL databases can be addressed as well, and the required data can be determined before generation begins.
Note:
These model variables are not assigned to parameter names, but the required values are directly entered.
Note:
An Access database can only be accessed if Microsoft Office 64-bit is installed.
Note:
Changes to the model variables for the parts database do not become effective until after a restart of the EEC because they are read in during the start. When P8 or Pro Panel is started, the model variables are transferred to the P8 or Pro Panel application respectively.
Model variable | Example value |
---|---|
Access Database File | Parts\CompanyName\ESS_part001.mdb |
SQL Catalog | |
SQL Password | |
SQL Server | |
SQL Username |
If a relative path is specified for the Access database file, the resulting absolute path is composed of the following settings:
- The specification for -Dcom.mind8.global.resourcePath= in the initialization file (e.g. ec.ini).
- The specification for Path to ECAD macros in the preferences.
- The specification Access Database File in the model variables.
An absolute path specification for the Access database file overrides the specifications in the initialization file and the preferences.
Note:
If there is no specification for the model variables, the parts database that is specified in the options of P8 under User > Management > Parts is accessed.
Access to the database can be carried out either by a database user who has to carry out corresponding specifications for authorizations, or by a user who authorizes themselves through their Windows login. The following tables show which specifications are required respectively (values are only examples).
The following specifications are required in the case of a Windows authorization:
Model variable | Value |
---|---|
Access database file | |
SQL Catalog | DataBaseName |
SQL Password | |
SQL Server | ServerName\SQLEXPRESS |
SQL Username |
The following specifications are required in the case of an SQL Server Authentication:
Model variable | Value |
---|---|
Access Database File | |
SQL Catalog | DataBaseName |
SQL Password | *** |
SQL Server | ServerName\SQLEXPRESS |
SQL Username | LoginName |
The password is displayed represented by asterisks.