Thursday, February 6, 2014

Microsoft Dynamics NAV 2013 Open the Microsoft Dynamics NAV Windows Client in Configuration Mode

Microsoft Dynamics NAV 2013 Open the Microsoft Dynamics NAV Windows Client in Configuration Mode To configure a profile, you must open the Microsoft Dynamics NAV Windows client in configuration mode. Open the Microsoft Dynamics NAV Windows client in configuration mode 1.At the command prompt, navigate to the root folder of the Microsoft Dynamics NAV Windows client. For example: cd C:\Program Files (x86)\Microsoft Dynamics NAV\70\RoleTailored Client 2.Type the following command: Microsoft.Dynamics.Nav.Client.exe -configure -profile: "profileid" Replace profileid with the name of the profile that you want to configure. Example: Microsoft.Dynamics.Nav.Client.exe -configure -profile:"Accounting Manager"

Friday, January 31, 2014

Manage objects in Microsoft Dynamics NAV 2013 R2 Dev Environment from command prompt

Manage objects in Microsoft Dynamics NAV 2013 R2 Dev Environment from command prompt

RUN-> cmd

C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>

To Export Objects:
In fob file type
C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql command=exportobjects, file=C:\vendor_obj.fob, servername=MITSYS, database=NAVDEMO71, filter="Type=Table;ID=23"
In text format file type
C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql command=exportobjects, file=C:\vendor_obj.txt, servername=MITSYS, database=NAVDEMO71, filter="Type=Table;ID=23"


To Import Objects:

C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql command=importobjects, file=C:\vendor_obj.txt, servername=MITSYS, database=NAVDEMO71

To Compile Objects:
C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql command=compileobjects, file=C:\vendor_obj.txt, servername=MITSYS, database=NAVDEMO71, filter="Type=Table;ID=23"

To Design Objects:

C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql designobject=Table 23

Filters:
You can use any of column name in object designer and any of commands like exportobjects, importobjects, compileobjects etc.
Examples:

1. C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>
finsql command=exportobjects, file=C:\objects.txt, servername=MITSYS,
database=NAVDEMO71, filter="Type=Table;Name=C*"


2. C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql
command=exportobjects, file=C:\objects.txt,
servername=MITSYS, database=NAVDEMO71, filter="Name=C*"

3. C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql
command=exportobjects, file=C:\objects.txt, servername=MITSYS, database=NAVDEMO71, filter="Date=10/01/13"

Import object in Multi tenant environment

C:\Program Files (x86)\Microsoft Dynamics NAV\71\RoleTailored Client>finsql command=importobjects,
file=C:\objects.txt, servername=MITSYS, database=DemoNAVAPP, importaction=overwrite,
validatetablechanges=yes/no navservername=localhost, navserverinstance=DynamicsNAV71,
navservermanagementport=7045, tenant=t1