Invoke-DevartDataImport

Synopsis

Imports data from the files into database.

Description

Use the cmdlet to import data from the following file formats: Text, MS Excel, MS Access, XML, JSON, CSV, ODBC, DBF.

Syntax
Invoke-DevartDataImport -Connection <object> [-Create <SwitchParameter>] [-InputFile <string>] [-InputTable <string>] [-Table <string>] [-TemplateFile <string>] [<CommonParameters>]
Parameters
-TemplateFile <string>

Specifies template file.

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

-Create <SwitchParameter>

If specified, new table to import the data to will be created.

Required? false

Position? named

Default value false

Accept pipeline input? false

Accept wildcard characters? false

-InputFile <string>

Specifies file with the data that you want to import. Option is inaccessible for ODBC format.

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-InputTable <string>

Specifies table or view to import the data from (for Access and ODBC formats).

Required? false

Position? named

Accept pipeline input? false

Accept wildcard characters? false

-Table <string>

Specifies target table (the one where you want to insert the imported data).

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-DevartDataImport -Connection $connection -TemplateFile "C:\Temp\template.dit"