Category: Development

Writing an automation for Navision in C#


Writing a automation for Navision is pretty simple, when you first know how to do it :-)

First of all, I assume that you already know about C#.

So here are the basic steps for creating an automation:

Read more »

C# and Dns.GetHostEntry

I am currently building a new FTP automation for Navision.

During this I discovered that Dns.GetHostEntry is not always stable.
Read more »

Trace Flag 4616

When using Navision (Dynamics NAV 5.0 or higher) with SQL 2005 (express or full) – you will receive a trace flag error, when trying to create a new database, unless you already has changed your SQL Server configuration.

So what to do when receiving this error? That’s simple – add the trace flag ;-)
Read more »

Splitting files using Visual Basic Scripts

Do you occasionally need to split a file based on its content?

If yes – then this can be done quickly by using a Visual Basic Script and “Scripting.FileSystemObject”.

Lets take a closer look.
Read more »

Using SQL Views in Navision


Did you know that it is possible to use views in Navision?

If you often are collecting/viewing data from several tables it can be usefull to use a SQL View. Created SQL Views can then afterwards be used from Navision.

First you have to create the SQL View. This is can be done in 2 ways on the SQL Server.

One way is to use the Microsoft SQL Server Management. Here you right click on View select New where you afterwards can select tables, joins, fields etc.

Read more »

Importing Image from a non Navision table to a Navision blob field


In SQL it is possible to define tables with a column, which is of type image. This field type is not known by Navision or by ADO and can thereby not be extracted like other fields.

There exists 2 ways to get this fields value.

1) One way is to stream the image to a file and then afterwards import it into the blob.

Read more »