Export-NAVAppTableData
Exports data from a Business Central database table to file.
Syntax
Default (Default)
Export-NAVAppTableData
[-ServerInstance] <String>
[-Tenant <TenantId>]
-Path <String>
-TableId <Int32>
[-Force]
[<CommonParameters>]
Description
Use the Export-NAVAppTableData cmdlet to export table data from a Business Central database to a file. The data must be for a new non-company table created as part of the extension package to which the exported file will be included.
Examples
Example 1
Export-NAVAppTableData -ServerInstance BC -Path '.\' -TableId 10000
This example exports the data from the table with the ID 10000 in the default tenant database for server instance BC to a TAB10000.navxdata file in the current folder.
Parameters
-Force
Forces the command to run without asking for user confirmation to overwrite an existing export file at the given path.
Parameter properties
| Type: | SwitchParameter |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | False |
| Value from remaining arguments: | False |
-Path
Specifies the path to the folder where the export file should be written. A data file with a name of TAB<TABLEID>.navxdata will be created. (Example: TAB10000.navxdata)
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-ServerInstance
Specifies the Business Central Server instance from which the data will be exported, such as BC.
Parameter properties
| Type: | String |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | 0 |
| Mandatory: | True |
| Value from pipeline: | True |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-TableId
Specifies the table ID to export. The ID must be for a new non-company table created as part of the extension.
Parameter properties
| Type: | Int32 |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | True |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
-Tenant
Specifies the tenant from which to export data. If the server instance is configured for single tenant, do not set the parameter.
Parameter properties
| Type: | TenantId |
| Default value: | None |
| Supports wildcards: | False |
| DontShow: | False |
| Aliases: | Id |
Parameter sets
(All)
| Position: | Named |
| Mandatory: | False |
| Value from pipeline: | False |
| Value from pipeline by property name: | True |
| Value from remaining arguments: | False |
CommonParameters
This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.
Inputs
System.String
By value and by property name: ServerInstance
Microsoft.Dynamics.Nav.Types.TenantId
By property name: Tenant
System.String
By property name: Path
System.Int32
By property name: TableId