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

Action: XPartsSetDataSourceAction


Parameter

Description

DataSourceType

Type of the database source (0 = EPLAN database (default value), 1 = SQL Server, 3 = eSTOCK collection).

DataBaseFileName

Database name with complete file path.

SqlServer

Name of the SQL server.

SqlCatalog

Name of the SQL database.

SqlUserName

Name of the user.

SqlPassword

Password of the user.

SqlLogin

SQL login (0 = Windows registration (default value), 1 = SQL Server registration (user name + password)).

SqlFullName

Full name of the SQL Server. Cannot be used together with one of the parameters SqlServer, SqlCatalog, SqlUserName or SqlPassword .

CollectionName

Name of the eSTOCK collection.

CollectionId

ID of the eSTOCK collection.

Notes:

  • If DataSourceType = 0, the parameter DataBaseFileName can be used.
  • If DataSourceType = 1 is selected, the parameters SqlServer, SqlCatalog, SqlUserName, SqlPassword, SqlLogin and SqlFullName can be used. The parameter SqlFullName is only used if SqlLogin = 1 is used.
  • If DataSourceType = 3, the parameters CollectionName and CollectionId can be used.

ClosedExample:

Specifies an EPLAN database as the database source:

XPartsSetDataSourceAction 
/DataSourceType:0 
/DataBaseFileName:C:\Users\Public\EPLAN\Data\Article\COMPANY_NAME\Database.alk

Specifies an SQL Server as the database source with a Windows registration during login:

XPartsSetDataSourceAction 
/DataSourceType:1 
/SqlLogin:0 
/SqlServer:SQL_SERVER_NAME 
/SqlCatalog:SQL_DATABASE

Specifies an SQL Server as the database source with SQL Server registration during login:

XPartsSetDataSourceAction 
/DataSourceType:1 
/SqlLogin:1 
/SqlServer:SQL_SERVER_NAME 
/SqlCatalog:SQL_DATABASE 
/SqlUserName:SQL_USERNAME 
/SqlPassword:SQL_PASSWORD

Specifies an SQL Server as the database source with SQL Server registration during login. In the process the full name is specified for the SQL Server:

XPartsSetDataSourceAction 
/DataSourceType:1 
/SqlLogin:1 
/SqlFullName:SQL_SERVER_NAME|SQL_DATABASE|2|SQL_USERNAME|SQL_PASSWORD

Specifies an eSTOCK collection as the database source:

XPartsSetDataSourceAction 
/DataSourceType:3 
/CollectionName:ESTOCK_COLLECTION_NAME 
/CollectionId:ESTOCK_COLLECTION_ID