Easy DataLoad v1.0 Dynamics NAV
Now available an easy way to load data into Dynamics NAV from any database platform (Tested for: MySQL and SQL Server) . The technology used is ADO.
Very handy when you are migrating to Navision. No more exporting data from your old system. No Excel worksheets necessary. Never build dataports again and again to import your data into Navision.
Just fill in the right drivers, map the fieldnames (from the source database) to the Navision fields. And import the data into NAV!
http://www.mibuso.com/dlinfo.asp?FileID=922
Discuss this download here.
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Or no business logic at all (for some tables that is ok).
Or import them in new tables in Navision for that purpose and then create some codeunits (or other objects) to put them into the real tables of Navision, using the business logic.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Could you please elaborate how to specify the drivers and how to map the fields.
this should really come in handy!
sharran
--Navision Developer --
Now available an easy way to load data into Dynamics NAV from any database platform (Tested for: MySQL, SQL Server, MSAccess) . The technology used is ADO.
Very handy when you are migrating to Navision. No more exporting data from your old system. No Excel worksheets necessary. Never build dataports again and again to import your data into Navision.
Just fill in the right drivers, map the fieldnames (from the source database) to the Navision fields. And import the data into NAV!
Version v1.1:
- Added export of settings which can be imported using dataport
- Added support for MS Access driver
- Example included with Northwind database (MS Access)
http://www.mibuso.com/dlinfo.asp?FileID=922
Discuss this download here.