Eplan Platform API
EPLAN API / API Reference / Actions / XPamArticlesSyncAction
XPamArticlesSyncAction
 Synchronization of articles/parts databases from V2022 to SQL Server V2.9.
 

Parameter Description
srcdb
Path or connection string of the source database (V2022) (input parameter, mandatory)
destdb
Connection string of the destination database. Format: server|catalog|logintype|username|pwd
 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.
 server - name of the server
 catalog - name of the database
 username - user name
 pwd - password for access
 
opensrcdbshared
If this parameter is 1, the source database is opened shared.
 Otherwise, the database is opened exclusively (input parameter, optional)
 
opendestdbshared
If this parameter is 1, the destination database is opened shared.
  Otherwise, the database is opened exclusively (input parameter, optional)
 
full
If this parameter is 1, all parts are synchronized. In source database missing parts are deleted in destination database.
 Otherwise, only changes after the last timestamp are synchronized (input parameter, optional)
 

Remarks
 The first call will synchronize the whole database. All further calls only adjust the changes since the last call.
 

Example
    XPamArticlesSyncAction
                /srcdb:"d:\part001.alk"
                /destdb:"SQLEXPRESS|eplanparts|0"
   
         Parts data synchronization for an Access database:
         
          XPamArticlesSyncAction
                /srcdb:"C:\<DataDirectory>\Article\EPLAN\ESS_part001.alk"
                /destdb:"C:\<DataDirectory>\Article\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"