Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 305 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Renaming fields IDs in Navision tables & effects on other Objects
Mohamed_Zayed
Member Posts: 39
Problem:
Now we found that one of our Programmer have given new Fields IDs in NAv_2016 for all our new fields which are coming from Nav_2009.
What we want to have :
We want to maintain the same fields IDs in our new Nav_2016 with the same Fields ID like Nav_2009.
Our Concerns:
Now the question is if we changed all tables fields numbers what will happen:
I want to prevent wrong field mapping. for example I am afraid that a code field will not be mapped to another code field and Navision will not complain! If this happened this will destroy all our work which we did in the last 6 months.
What is the best way to changes the tables fields ID without destroying our work?
Now we found that one of our Programmer have given new Fields IDs in NAv_2016 for all our new fields which are coming from Nav_2009.
What we want to have :
We want to maintain the same fields IDs in our new Nav_2016 with the same Fields ID like Nav_2009.
Our Concerns:
Now the question is if we changed all tables fields numbers what will happen:
I want to prevent wrong field mapping. for example I am afraid that a code field will not be mapped to another code field and Navision will not complain! If this happened this will destroy all our work which we did in the last 6 months.
What is the best way to changes the tables fields ID without destroying our work?
0
Best Answers
-
Mohamed_Zayed
Member Posts: 39
Solution:
1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.0 -
Kishorm
Member Posts: 921
Mohamed_Zayed wrote: »Solution:
1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.
Only do this if you don't mind losing the data in the fields you are renumbering. If you do need the data then you will need to handle that too (e.g. by creating temporary tables and creating upgrade codeunits)5
Answers
1. Export all your objects, change field ID in Text file and import.
2. Export all objects (exclude the tables in which you are going to change the field id's) and change field id's in table (dev), import the objects.
take backup of your objects before do these steps.
Only do this if you don't mind losing the data in the fields you are renumbering. If you do need the data then you will need to handle that too (e.g. by creating temporary tables and creating upgrade codeunits)