Invoke-DevartDataExport

Synopsis

Exports data from a database into the files.

Description

Use the cmdlet to export data from one or several tables to the following file formats: HTML, Text, XLS, XLSX, MS Access, RTF, PDF, JSON, XML, CSV, ODBC, DBF, SQL.

Syntax

Invoke-DevartDataExport -TemplateFile <string> [-Connection <object>] [-OutputFile <string>] [-OutputTable <string>] [-Range <string>] [-SingleFile <string>] [-Table <string>] [<CommonParameters>]

Parameters

-TemplateFile <string>

Specifies a *.det data import template file containing data export settings.

Required? true

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-Connection <object>

The DevartDatabaseConnectionInfo or connection string.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-OutputFile <string>

Specifies destination file, or directory for multiple export. Option is inaccessible for ODBC format.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-OutputTable <string>

Specifies destination table name, this option is available for SQL, ODBC and Access formats.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-Range <string>

Specifies range of exported rows.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-SingleFile <SwitchParameter>

Specifies that all data has to be exported into single file, even if there are several source tables.

Required? false

Position? named

Default value? false

Accept pipeline input? false

Accept wildcard characters? false

-Table <string>

Specifies source table name, there can be some tables specified.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

Outputs:

System.Boolean (returns true on success and false otherwise)

Examples:

---------- EXAMPLE 1 ----------
Invoke-DevartDataExport -Connection $connection -TemplateFile "C:\Temp\template.det"