ExportPartsListFromSystem(String,String,String,String,String,String,String,String,String) Method

In This Topic

Exports parts and other parts management items like addresses, constructions, terminals, accessory lists and accessory placements from the system's parts database.

Syntax

C#
C++/CLI

public void ExportPartsListFromSystem( 
   string strFilePath,
   string strConverter,
   string strSqlFilterPart,
   string strSqlFilterAddress,
   string strSqlFilterConstruction,
   string strSqlFilterTerminal,
   string strSqlFilterAccessoryList,
   string strSqlFilterAccessoryPlacement,
   string strCfgFilePath
)

public:
void ExportPartsListFromSystem( 
   String^ strFilePath,
   String^ strConverter,
   String^ strSqlFilterPart,
   String^ strSqlFilterAddress,
   String^ strSqlFilterConstruction,
   String^ strSqlFilterTerminal,
   String^ strSqlFilterAccessoryList,
   String^ strSqlFilterAccessoryPlacement,
   String^ strCfgFilePath
)

Parameters

strFilePath: Full output file name.
strConverter: Converter long name, e.g: 'XPamExportXml'. See Eplan::EplApi::ApplicationFramework: and Eplan::EplApi::ApplicationFramework: namespace.
strSqlFilterPart: Sql filter for advanced users. With this filter the exported parts can be reduced with an SQL statement. In order to export complete list, use string "1=1" To export one part with a specified part number, e.g. "A001", use string "partnr='A001'" In order to skip this data in the output, use "1=0" string.
strSqlFilterAddress: Sql filter for addresses. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use string "1=1" or call overloaded method without this parameter. In order to skip this data in the output, use "1=0" string.
strSqlFilterConstruction: Sql filter for constructions. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use string "1=1". In order to skip this data in the output, use "1=0" string.
strSqlFilterTerminal: Sql filter for terminals. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use string "1=1". In order to skip this data in the output, use "1=0" string.
strSqlFilterAccessoryList: Sql filter for accessory lists. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use string "1=1". In order to skip this data in the output, use "1=0" string.
strSqlFilterAccessoryPlacement: Sql filter for accessory placements. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use string "1=1". In order to skip this data in the output, use "1=0" string.
strCfgFilePath: Full file name of the configuration file. Details about configuration file structure are described in "Parts Management: Configuration Files for the Import and Export of Data" chapter of P8 Help.

Exceptions

Exception	Description
ArgumentException	Thrown in case of invalid parameters.
BaseException	An error occurred while exporting parts data.

Remarks

In order to filter the output data you can provide an SQL filter through the 'strSqlFilterPart', 'strSqlFilterAddress', 'strSqlFilterConstruction', 'strSqlFilterTerminal', 'strSqlFilterAccessoryList' and 'strSqlFilterAccessoryPlacement' parameters. The syntax is the same as the WHERE statement in regular SQL queries. For parts, you can use any column name from the 'tblPart' table existing in your currently used parts database (e.g.: 'manufacturer', 'productgroup' or 'typenr'). For other parts management items (addresses, constructions, etc.) check column names in the respective tables in the current parts database.

Reference

PartsService Class
PartsService Members
Overload List

Send Feedback