Importing data in navision (with business logic enabled)

Arhontis

Hello everyone,

I was wondering of the different ways to import data in navision and be able to get thru the business logic (I mean validations and table trigger C/AL execution).

I know that dataports provide that kind of functionality (if you write it). Is there any other way?

Have a happy new year, and I wish for syntax highlighting in C/AL editing....

darrenc

Sometimes I define a staging table in Navision – dump data into that staging table through SQL Server, then run a code unit that copies/validates that data from the staging table to the core Navision table(s). This is a lot of extra work and expense if you are looking at a one-time data import, but I find it handy when interacting with other programs that are base on SQL. Dataports are probably the most straight forward.