Eplan Platform API
EPLAN API / API Reference / Actions / XPartsSetDataSourceAction
In This Topic
    XPartsSetDataSourceAction
    In This Topic 
     Changes the setting responsible for parts management database type.

    Parameter Description
    DataSourceType 
     0 = EPLAN Database (default value), 1 = SQL server, 3 = eSTOCK collection
    DataBaseFileName 
     Full database path name
    SqlServer 
     SQL server name
    SqlCatalog 
     SQL database name
    SqlUserName 
     SQL user name
    SqlPassword 
     SQL user password
    SqlLogin 
     0 = Windows registration (default value), 1 = SQL server registration (username + password)
    SqlFullName 
     If set, then SqlServer, SqlCatalog, SqlUserName and SqlPassword parameters are not used.
    CollectionName 
     Name of the eSTOCK collection
    CollectionId 
     ID of the eSTOCK collection
    Force 
     force downloading of all data of a eSTOCK collection

    Remarks 
     When DataSourceType = 1, SqlServer, SqlCatalog, SqlUserName, SqlPassword, SqlLogin and SqlFullName parameters can be used. SqlFullName would be used only when SqlLogin = 1.
 When DataSourceType = 0, DataBaseFileName can be used.
 When DataSourceType = 3, CollectionName and CollectionId can be used.

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


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


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


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


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

     

     

    EPLAN API , 27.08.2024, © by EPLAN GmbH & Co. KG. All rights reserved.

    Use the Eplan Global Support Portal for feedback and support