ExportPartsListFromSystem(String,String,String) Method

In This Topic

Exports parts data from the system's parts database.

Syntax

C#
C++/CLI

public void ExportPartsListFromSystem( 
   string strFilePath,
   string strConverter,
   string strSqlFilterPart
)

public:
void ExportPartsListFromSystem( 
   String^ strFilePath,
   String^ strConverter,
   String^ strSqlFilterPart
)

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 a SQL statement. In order to export complete list, use filter equal to "1=1" or call overloaded method without this parameter. To export one part with a specified part number, e.g. A001, set the strSqlFilterPart to "partnr='A001'"

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' parameter. 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').

Reference

PartsService Class
PartsService Members
Overload List

Send Feedback