Export-NAVAppTableData

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.

Required Parameters

-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
Accept pipeline input:True (ByPropertyName)
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
Accept pipeline input:True (ByPropertyName, ByValue)
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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False

Optional 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
Accept pipeline input:False
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
Accept pipeline input:True (ByPropertyName)
Accept wildcard characters:False