Import from an sql database

tiagofrancis

Hi folks,

Does anyone knows how to import data from an sql database to navision?


Kind regards

Alex_Chow

It's not a good idea to import straight into Navision from SQL. It's recommended that all data imports be done through Navision to ensure all business rules are checked.

kriki

And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

Alex_Chow

kriki wrote:

And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

To a temporary table you mean. Then write a process to move them into production table.

nunomaia

tiagofrancis wrote:

Hi folks,

Does anyone knows how to import data from an sql database to navision?


Kind regards

It's one time operation or is a periodically operation? Do you have direct access to SQL from Navision?

kriki

Alex Chow wrote:

kriki wrote:

And if you want to do it anyway, create a new table just for this purpose. Then use a NAS (or a client) to put in in the real Navision-tables.

To a temporary table you mean. Then write a process to move them into production table.

That's what I mean.

tiagofrancis

At the end of the day, i have to export DATA from Nav throughout a CU i've created. The next step is to import DATA, but i don't know what is the best way to do it...SAMPLE CODE?

tiagofrancis

I've exported with success...

nunomaia

you can use a dataport to achive that

kriki

If you use a NAS, you have to create a codeunit to export/import data. Navision NAS cannot use dataports. Don't ask me why.

Alex_Chow

kriki wrote:

If you use a NAS, you have to create a codeunit to export/import data. Navision NAS cannot use dataports. Don't ask me why.

You could write a process only report to read and import flat files.