ImportTranslate

Imports UI text strings for objects from a text file to a specified Dynamics NAV database.

Syntax

finsql.exe command=importtranslate, file=<importfile>, [servername=<server>,] [database=<database>,] [filter=<filter>,] [logfile=<path and filename>,] [username=<username>,] [password=<password>,] [ntauthentication=<yes|no|1|0>]  

Parameters

file

Specifies the path and name of the text file that contains the text strings to import, for example C:\translatestrings.txt. This parameter is required.

servername

The name of the database server that hosts the Dynamics NAV database in which you want to import text strings. The format of this parameter is <computername>\<database server instance>.

If you do not specify both the servername and the database parameter, then the database server and database that are stored in the fin.zup file are used.

Note

When you first specify a database server and database to open, either from a command at a command prompt or from a client, the database server and database are stored in the fin.zup file. By default, the fin.zup file is located at C:\users\<user name>\AppData\Roaming\.

If you do not specify the servername parameter but you do specify the database parameter, then the Open Database window opens so that you can specify the database server name.

Tip

To view the name of the server on which the current database is stored, on the File menu, choose Database, and then choose Information. Use the value of the Database Server field for the servername parameter.

database

The Dynamics NAV database in which you want to import the text strings.

If you do not specify both the servername and the database parameter, then the database server and database that are stored in the fin.zup file are used.

Note

When you first specify a database server and database to open, either from a command at a command prompt or from a client, the database server and database are stored in the fin.zup file. By default, the fin.zup file is located at C:\users\<user name>\AppData\Roaming\.

If you do not specify the database parameter but you do specify the servername parameter, then the Open Database window opens so that you can specify the database name.

Tip

To view the name of the current database, on the File menu, choose Database, and then choose Information. Use the value of the Database Name field for the database parameter.

filter

A filter on the Object table. Use the filter parameter to specify the objects to which you want to import the text strings. Use a semicolon to separate multiple filters. The only operator that you can use in the filter is '='. The following table shows the fields in the Object table on which you can filter.

Object table field Values Example
Type Table, Codeunit, Page, Report, XMLport, Query Type=Table|Page
ID Integer or range of integers ID=50000..50500
Name Any valid object name "Name=Cost Entry"
Modified yes, no, 1, 0 Modified=yes
Compiled yes, no, 1, 0 Compiled=0
Date Date, in the numeric format determined by your regional settings Date=12/1/2016
Time Time, in the numeric format determined by your regional settings Time=12:00:00
Version List Any valid version Version List=NAVW110.00
Caption Any valid caption Caption=Company Information
Locked Yes, no, 1, 0 Locked=1
Locked By Domain\username "Locked By=CRONUS\viktor"

If you do not specify a filter, then all objects in the Object table are included.

logfile

The path and file name for the file that contains error messages that result from the command. If there are no errors, then a log file is not created.

By default, the file is named naverrorlog.txt and is located in the same location as finsql.exe.

The navcommandresult.txt file, which contains information about the success or failure of the command, is created in the folder that is specified by the logfile parameter.

When you run finsql.exe with a command, the previous log file and result file are deleted.

Note

If User Access Control (UAC) is turned on and you do not specify to run the command prompt window as Administrator, then the command prompt window runs as a standard user. In this case, if you do not specify the logfile parameter, then the command fails because the standard user cannot write to the default location of the log file.

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 Windows user name and password of the current user to authenticate to the database.

Note

If User Access Control (UAC) is turned on, and you do not specify to run the command prompt window as Administrator, then the command prompt window runs as a standard user. In this case, if you do not specify the username parameter, then even if the current Windows user is an Administrator, the command is run as the standard user.

If you specify the username parameter, then you must also specify the password parameter and the ntauthentication parameter must be no.

For more information about database users and permissions, see Setting Database Owner and Security Administration Permissions.

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 Windows user name and password of the current user to authenticate to the database.

ntauthentication

Specifies whether to use NT authentication. The possible values are yes, no, 1, or 0. If you specify the username and password parameters, then you must specify ntauthentication=no or ntauthentication=0.

Remarks

You can use this command for translating text strings in multilanguage setup of Dynamics NAV. The contents of the text file must be compatible with Dynamics NAV. Therefore, the text file will typically have originated from a text file that was previously exported from the database, and then modified. For more information, see How to: Add Translated Strings By Importing and Exporting Multilanguage Files and Multilanguage Development.

Example

This example shows how to run the ImportTranslate command to import text strings from a text file to the Demo Database NAV (10-0) database. The text file that has the path and file name C:\navtextstrings.txt.

finsql.exe command=importtranslate, file=C:\navtextstrings.txt, servername=TestComputer01\NAVDEMO, database="Demo Database NAV (10-0)"  

See Also

BuildVirtualMetadata
CreateDatabase
UpgradeDatabase
CreateLanguage
CompileObjects
Compiling Objects
DeleteObjects
DesignObject
ExportObjects
ImportObjects
ExportLangModule
ImportLangModule
ExportTranslate
ImportTranslate
Using the Development Environment from the Command Prompt