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

In This Topic

Exports parts and addresses from the system's parts database.

Syntax

C#
C++/CLI

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

public:
void ExportPartsListFromSystem( 
   String^ strFilePath,
   String^ strConverter,
   String^ strSqlFilterPart,
   String^ strSqlFilterAddress,
   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 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'" In order to skip this data in the output, use "1=0" string.
strSqlFilterAddress: Sql filter for advanced users. With this filter the exported data can be reduced by providing an SQL statement. In order to export complete data, use filter equal to "1=1" or call overloaded method without this parameter. 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' and 'strSqlFilterAddress' 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').

Reference

PartsService Class
PartsService Members
Overload List

Send Feedback