Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.6K 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
- 280 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 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
Validation from within Excel before import
Jocafe
Member Posts: 10
Hello again,
I've stumbled upon a need I'm finding a hard time trying to provide a solution for.
Case scenario: we want to be able to add a function in NAV in order to export an excel template (so far so good).
Now, we also want the user to be able to fill the worksheet and in case there is an error (maybe a posting group was not typed in correctly) we want excel to "complain" and give at least some sort of error because that posting group does not exist within NAV BEFORE the import (on run-time).
Is there a way to accomplish that before the actual impot of the worksheet so when the import process is actually going to be done, we'll know that everything is correct beforehand? I saw this exact thing a while back but I cannot seem to find it. So if someone knows how to make this happen or a "workaround" I'd appreciate it.
I hope I've made myself understandable.
I've stumbled upon a need I'm finding a hard time trying to provide a solution for.
Case scenario: we want to be able to add a function in NAV in order to export an excel template (so far so good).
Now, we also want the user to be able to fill the worksheet and in case there is an error (maybe a posting group was not typed in correctly) we want excel to "complain" and give at least some sort of error because that posting group does not exist within NAV BEFORE the import (on run-time).
Is there a way to accomplish that before the actual impot of the worksheet so when the import process is actually going to be done, we'll know that everything is correct beforehand? I saw this exact thing a while back but I cannot seem to find it. So if someone knows how to make this happen or a "workaround" I'd appreciate it.
I hope I've made myself understandable.
0
Comments
If you are using NAV2013, did you check Rapidstart Services?
It wont be validated in excel but it will be inserted in a Intermediate table and once click to Apply the data to database then it will validate the fields and show error if there is any issue..
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
And yes, I did. Actually the solution I need has to do with modifying something related to RapidStart. And yes, that was my plan B, but the great way would be something like what I was asking. Ideally I'd like to do that
Thank you very much for your insight