This functionality is only available for certain module packages. Info / Copyright

Action: XPamArticlesSyncAction


Parameters

Description

srcdb

File path (*.alk) or connection string (SQL database) of the source database.

destdb

File path (*. mdb) or connection string (SQL database) of the target database.

opensrcdbshared

Specifies how the source database is opened (optional, 0 = exclusive, 1 = not exclusive). Default value: 0

opendestdbshared

Specifies how the target database is opened (optional, 0 = exclusive, 1 = not exclusive). Default value: 0

Syntax of the connection string:
"server | catalog | logintype | username | pwd"

Component

Description

server

Name of the server

catalog

Name of the database

logintype

Login type; possible values are:

0 = Windows authentication

1 = SQL authentication (encrypted password)

2 = SQL authentication (non-encrypted password)

username and pwd are optional for logintype = 0.

username

User name

pwd

Password for access

ClosedExample:

Parts data synchronization for an Access database:

XPamArticlesSyncAction 
/srcdb:"C:\<Datenverzeichnis>\Artikel\EPLAN\ESS_part001.alk" 
/destdb:"C:\<Datenverzeichnis>\Artikel\EPLAN\ESS_part001.mdb"

Parts data synchronization for SQL databases:

XPamArticlesSyncAction 
/srcdb:"SQLEXPRESS|parts_2022|0" 
/destdb:"SQLEXPRESS|parts_old|0"
XPamArticlesSyncAction 
/srcdb:"SQL2019|parts_2022|2|Mustermann|12345" 
/destdb:"SQL2019|parts_old|2|Mustermann|12345"