Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 262 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
SMART Excel Import Export
Administrator
Member, Moderator, Administrator Posts: 2,495
SMART Excel Import Export
SMART Excel Import Export is the tool for importing / exporting data from any NAV table via MS Excel. It can be used in different way: as universal dataport, as possibility to store data outside the NAV, as tool for data migration, etc.
Main features:
- import / export data from any NAV table;
- possibility to choose which fields should be exported; which fields should be validated;
- possibility to specify commit interval (as records quantity) - useful on huge amount of data;
- high import / export speed due to improved excel read / write algorithm
- import doesn't stop on error. the error log will be shown instead;
You can find this and other tools and how-to's here: http://wedonav.com/#/experience/
http://www.mibuso.com/dlinfo.asp?FileID=1462
Discuss this download here.
SMART Excel Import Export is the tool for importing / exporting data from any NAV table via MS Excel. It can be used in different way: as universal dataport, as possibility to store data outside the NAV, as tool for data migration, etc.
Main features:
- import / export data from any NAV table;
- possibility to choose which fields should be exported; which fields should be validated;
- possibility to specify commit interval (as records quantity) - useful on huge amount of data;
- high import / export speed due to improved excel read / write algorithm
- import doesn't stop on error. the error log will be shown instead;
You can find this and other tools and how-to's here: http://wedonav.com/#/experience/
http://www.mibuso.com/dlinfo.asp?FileID=1462
Discuss this download here.
0
Comments
It seems that is not able to import checkbox fields (0 or 1) or I do not know how to use it.
I tried different combinations is not working.
Thanks,
Mihai
Hello, Mihai
Please try using "Yes" and "No" values for Boolean fields. And import the file using English language in NAV client.
This feature seems great. But i'm having some problems with the functionality regarding choosing fields or amount of data to export/import.
The role i'm using has access to everything but NAV still says that I haven't got access to the fields for defining which fields to export. Is there something that im missing?
Is there any manual on the function that you can share.
Message:
- You do not have permission to run the excel field table.
most likely that your license doesn't allow you to use objects in range 80000..80005. "Excel Field" table has ID 80003.
You should renumber the objects in txt file (included in download - SMARTExcelImportExport.txt) to the range which is allowed by your license.
You can use any of the renumbering tools, for example Fast Renumbering Object and Field Tool or MBS-Navision Compare & Renumbering Tool.
I've uploaded renumbered objects here (50000..50005), probably this range is allowed by your license.
Thanks,
Niall