Import-NAVApplicationObject

Module:

Microsoft.Dynamics.Nav.Ide Module

Imports Business Central application objects from a file into a database.

Syntax

All (Default)

Import-NAVApplicationObject
    [-Path] <String[]>
    [-DatabaseName] <String>
    [-DatabaseServer <String>]
    [-LogPath <String>]
    [-ImportAction <String>]
    [-SynchronizeSchemaChanges <String>]
    [-NavServerName <String>]
    [-NavServerInstance <String>]
    [-NavServerManagementPort <Int16>]
    [-SuppressBuildSearchIndex]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

DatabaseAuthentication

Import-NAVApplicationObject
    [-Path] <String[]>
    [-DatabaseName] <String>
    -Username <String>
    -Password <String>
    [-DatabaseServer <String>]
    [-LogPath <String>]
    [-ImportAction <String>]
    [-SynchronizeSchemaChanges <String>]
    [-NavServerName <String>]
    [-NavServerInstance <String>]
    [-NavServerManagementPort <Int16>]
    [-SuppressBuildSearchIndex]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

Description

The Import-NAVApplicationObject function imports the objects from the specified file(s) into the specified database. When multiple files are specified, finsql is invoked for each file. For better performance the files can be joined first. However, using seperate files can be useful for analyzing import errors.

Examples

EXAMPLE 1

Import-NAVApplicationObject MyAppSrc.txt MyApp

This command imports all application objects in MyAppSrc.txt into the MyApp database.

EXAMPLE 2

Import-NAVApplicationObject MyAppSrc.txt -DatabaseName MyApp

This command imports all application objects in MyAppSrc.txt into the MyApp database.

EXAMPLE 3

Get-ChildItem MyAppSrc | Import-NAVApplicationObject -DatabaseName MyApp

This commands imports all objects in all files in the MyAppSrc folder into the MyApp database. The files are imported one by one.

EXAMPLE 4

Get-ChildItem MyAppSrc | Join-NAVApplicationObject -Destination .\MyAppSrc.txt -PassThru | Import-NAVApplicationObject -Database MyApp

This commands joins all objects in all files in the MyAppSrc folder into a single file and then imports them in the MyApp database.

Parameters

-Confirm

Prompts you for confirmation before running the cmdlet.

Parameter properties

Type:	SwitchParameter
Default value:	None
Supports wildcards:	False
DontShow:	False
Aliases:	cf

Parameter sets

(All)

Position:	Named
Mandatory:	False
Value from pipeline:	False
Value from pipeline by property name:	False
Value from remaining arguments:	False

-DatabaseName

Specifies the name of the database into which you want to import.

Parameter properties

Type:	String
Default value:	None
Supports wildcards:	False
DontShow:	False

Parameter sets

(All)

Position:	2
Mandatory:	True
Value from pipeline:	False
Value from pipeline by property name:	False
Value from remaining arguments:	False

-DatabaseServer

Specifies the name of the SQL server instance to which the database you want to import into is attached. The default value is the default instance on the local host (.).

Parameter properties

Type:	String
Default value:	.
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

-ImportAction

Specifies the import action. The default value is 'Default'.

Parameter properties

Type:	String
Default value:	Default
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

-LogPath

Specifies the log folder.

Parameter properties

Type:	String
Default value:	"$Env:TEMP\NavIde\$([GUID]::NewGuid().GUID)"
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

-NavServerInstance

Specifies the Business Central Server instance that is being used.The default value is DynamicsNAV90.

Parameter properties

Type:	String
Default value:	DynamicsNAV90
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

-NavServerManagementPort

Specifies the port on the Business Central Server server that the Business Central Windows PowerShell cmdlets access. The default value is 7045.

Parameter properties

Type:	Int16
Default value:	7045
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

-NavServerName

Specifies the name of the server that hosts the Business Central Server instance, such as MyServer.

Parameter properties

Type:	String
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

-Password

The password to use with the username parameter to authenticate to the database. If you do not specify a user name and password, then the command uses the credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:	String
Default value:	None
Supports wildcards:	False
DontShow:	False

Parameter sets

DatabaseAuthentication

Position:	Named
Mandatory:	True
Value from pipeline:	False
Value from pipeline by property name:	False
Value from remaining arguments:	False

-Path

Specifies one or more files to import.

Parameter properties

Type:	String[]
Default value:	None
Supports wildcards:	False
DontShow:	False
Aliases:	PSPath

Parameter sets

(All)

Position:	1
Mandatory:	True
Value from pipeline:	True
Value from pipeline by property name:	True
Value from remaining arguments:	False

-SuppressBuildSearchIndex

Specifies whether the build of the Search Index needs to be suppressed.

Parameter properties

Type:	SwitchParameter
Default value:	False
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

-SynchronizeSchemaChanges

Specifies the schema synchronization behavior. The schema synchronization will run against all objects in the database, not just the objects that you import.

'no' specifies not run schema synchronization.

'yes' specifies to run schema synchronization with validation, which means that if there are destructive changes in any objects in the database, the synchronization wil fail. This is the default value.

'force' specifies to run schema synchronization without validation. For destructive changes, data in columns of the business data table that are affected by changes will be deleted.

Parameter properties

Type:	String
Default value:	Yes
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

-Username

The user name to use to authenticate to the database. The user name must exist in the database. If you do not specify a user name and password, then the command uses the credentials of the current Windows user to authenticate to the database.

Parameter properties

Type:	String
Default value:	None
Supports wildcards:	False
DontShow:	False

Parameter sets

DatabaseAuthentication

Position:	Named
Mandatory:	True
Value from pipeline:	False
Value from pipeline by property name:	False
Value from remaining arguments:	False

-WhatIf

Shows what would happen if the cmdlet runs. The cmdlet is not run.

Parameter properties

Type:	SwitchParameter
Default value:	None
Supports wildcards:	False
DontShow:	False
Aliases:	wi

Parameter sets

(All)

Position:	Named
Mandatory:	False
Value from pipeline:	False
Value from pipeline by property name:	False
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

You can pipe a path to the Import-NavApplicationObject function.

Outputs

None

Related Links

• Compile-NAVApplicationObject
• Create-NAVDatabase
• Delete-NAVApplicationObject
• Export-NAVApplicationObject
• Invoke-NAVDatabaseConversion