This functionality is only available for certain module packages.

Model variables for the parts database

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 user name

If a relative path is specified for the Access database file, the resulting absolute path is composed of the following settings:

  1. The specification for -Dcom.mind8.global.resourcePath= in the initialization file (e.g. ec.ini).
  2. The specification for Path to ECAD macros in the preferences.
  3. 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 user name

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 user name LoginName

The password is displayed represented by asterisks.