Exports data from a database into files.
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.
Invoke-DevartDataExport -TemplateFile <string> [-Connection <object>] [-OutputFile <string>] [-OutputTable <string>] [-Range <string>] [-SingleFile <SwitchParameter>] [-Table <string>] [<CommonParameters>]
-Connection <object>
The DevartDatabaseConnectionInfo or connection string.
Required? false
Position? named
Default value
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
Default value
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
Default value
Accept pipeline input? false
Accept wildcard characters? false
-Range <string>
Specifies range of exported rows.
Required? false
Position? named
Default value
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
Default value
Accept pipeline input? false
Accept wildcard characters? false
-TemplateFile <string>
Specifies a *.det data export template file containing data export settings.
Required? true
Position? named
default value
Accept pipeline input? false
Accept wildcard characters? false
<CommonParameters>
This cmdlet supports the following common parameters: Verbose, Debug, ErrorAction, ErrorVariable, WarningAction, WarningVariable, InformationAction, InformationVariable, OutBuffer, PipelineVariable, and OutVariable. For more information, see About CommonParameters.
System.Boolean (returns true on success and false otherwise)
---------- EXAMPLE 1 ----------
Invoke-DevartDataExport -Connection $connection -TemplateFile "C:\Temp\template.det"
See Switches used in the command line for information on additional command line options.