API Help
Eplan.EplApi.HEServices Namespace / PartsService Class / ExportPartsListFromSystem Method / ExportPartsListFromSystem(String,String,String,String,String) Method
Full output file name.
Converter long name, e.g: 'XPamExportXml'. See Eplan::EplApi::ApplicationFramework: and Eplan::EplApi::ApplicationFramework: namespace.
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.
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.
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.

ExportPartsListFromSystem(String,String,String,String,String) Method
Exports parts and addresses from the system's parts database.
Syntax

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
ExceptionDescription
Thrown in case of invalid parameters.
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').
See Also