Export-NAVAppTableData

Reference

Module:: Microsoft.Dynamics.Nav.Apps.Tools

Exports data from a Microsoft Dynamics NAV database table to file.

Syntax

Export-NAVAppTableData
      [-ServerInstance] <String>
      [-Tenant <TenantId>]
      -Path <String>
      -TableId <Int32>
      [-Force]
      [<CommonParameters>]

Description

Use the Export-NAVAppTableData cmdlet to export table data from a Microsoft Dynamics NAV 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 DynamicsNAV -Path '.\' -TableId 10000

This example exports the data from the table with the ID 10000 in the default tenant database for server instance DynamicsNAV 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.

Type:	SwitchParameter
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	False
Accept wildcard characters:	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)

Type:	String
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-ServerInstance

Specifies the Microsoft Dynamics NAV Server instance from which the data will be exported, such as DynamicsNAV.

Type:	String
Position:	0
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-TableId

Specifies the table ID to export. The ID must be for a new non-company table created as part of the extension.

Type:	Int32
Position:	Named
Default value:	None
Required:	True
Accept pipeline input:	True
Accept wildcard characters:	False

-Tenant

Specifies the tenant from which to export data. If the server instance is configured for single tenant, do not set the parameter.

Type:	TenantId
Aliases:	Id
Position:	Named
Default value:	None
Required:	False
Accept pipeline input:	True
Accept wildcard characters:	False