Parameters |
Description |
|
File path (*.alk) or connection string (SQL database) of the source database. |
|
File path (*. mdb) or connection string (SQL database) of the target database. |
|
Specifies how the source database is opened (optional, 0 = exclusive, 1 = not exclusive). Default value: 0 |
|
Specifies how the target database is opened (optional, 0 = exclusive, 1 = not exclusive). Default value: 0 |
|
Specifies how the parts data synchronization is performed (optional, 0 = only the changes after the last time stamp are synchronized, 1 = all parts data are synchronized and deleted parts data are deleted). Default value: 0 |
Syntax of the connection string:
Component |
Description |
---|---|
|
Name of the server |
|
Name of the database |
|
Login type; possible values are: 0 = Windows authentication 1 = SQL authentication (encrypted password) 2 = SQL authentication (non-encrypted password)
|
|
User name |
|
Password for access |
Note:
Before you carry out modifications in the parts databases, this action has to be carried out "to be begin with" once so that the time stamp is set in the workstation settings. Without the time stamp deleted parts, for example, are not detected.
Parts data synchronization for an Access database:
XPamArticlesSyncAction /srcdb:"C:\<Data directory>\Parts\EPLAN\EPLAN_part001.alk" /destdb:"C:\<Data directory>\Parts\EPLAN\EPLAN_part001.mdb"
Parts data synchronization for SQL databases:
XPamArticlesSyncAction /srcdb:"<SQL_server_name>|parts_2022|0" /destdb:"<SQL_server_name>|parts_old|0"
XPamArticlesSyncAction /srcdb:"<SQL_server_name>|parts_2022|2|John Doe|12345" /destdb:"<SQL_server_name>|parts_old|2|John Doe|12345"