How-To Import Object Textfiles

If you want to import several objects based on a textfile, you should split them and run this powershell script:

Import-Module "C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\140\RoleTailored Client\Microsoft.Dynamics.Nav.Ide.psm1"

Get-ChildItem $PSScriptRoot -Filter *.txt | Import-NAVApplicationObject -DatabaseName "Demo Database NAV (14-0)" -DatabaseServer SQL01 -NavServerInstance BC140 -NavServerManagementPort 7045

This Two-Liner will import all *.txt-Files from your Powershell Script Root Folder into your database.

Any importing errors will be shown separatly. This is the first entry in your log:

Import-NAVApplicationObject : : [21364760] Es gibt einen Syntaxfehler beim Import auf Zeile 219 , Position 16 :                 DecimalPlaces=0:5;.
Ein '{' (ElemBegin) wurde erwartet. -- File: C:\page_0000000515.TXT
[0] Der Import brach ab bei Zeile 219. -- File: C:\page_0000000515.TXT
In Zeile:1 Zeichen:81
+ ... ter *.txt | Import-NAVApplicationObject -DatabaseName "Demo Database  ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Import-NAVApplicationObject

This is the 2nd entry in your log:

Import-NAVApplicationObject : : [23462179] Das Funktionsattribut [AccSchedLine2] ist in diesem Kontext ungültig. -- File: C:\report_0000000029.TXT
[0] Der Import brach ab bei Zeile 390. -- File: C:\report_0000000029.TXT
In Zeile:1 Zeichen:81
+ ... ter *.txt | Import-NAVApplicationObject -DatabaseName "Demo Database  ...
+                 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,Import-NAVApplicationObject

If you see this error:

Interner Fehler '9' in Modul '24'. Internal Error '9' in Module '24'.

You should check your object for doubled triggers: