C/Side to SQL Migration - specifying the corrected dates

rsaritzky
Member Posts: 469
Hi,
I'm converting a database from C/Side to SQL. The FieldCheck codeunit displays a form with the "Incorrect Values" table at the end, asking you if you wish to implement the recommended changes.
This database has quite a few date errors (almost 700), and NAV doesn't do a great job in suggesting the "correct" date - it just changes the year to 1754, e.g. 02/12/0008 is suggested to change to 02/12/1754 - but I'd like it to be 02/12/2008.
I can edit the form one record at a time, but what I'd like to do is ask the end-user to specify the date they want, and import that list into this page.
I can find the table and import the data, but I can't find where (or if) in the FieldCheck and related codeunits that I can tweak the code to just use the current contents of the Incorrect Values Table, skip the FieldCheck stuff and just apply the updates. The codeunit appears to purge the Incorrect Values table before starting (or use a temporary global to store the values and then save them at the end to the permanent table.)
Has anyone attempted to add functionality so this table can be reviewed at a later time and then implement the changes - without re-running the datecheck logic?
Thx
Ron
I'm converting a database from C/Side to SQL. The FieldCheck codeunit displays a form with the "Incorrect Values" table at the end, asking you if you wish to implement the recommended changes.
This database has quite a few date errors (almost 700), and NAV doesn't do a great job in suggesting the "correct" date - it just changes the year to 1754, e.g. 02/12/0008 is suggested to change to 02/12/1754 - but I'd like it to be 02/12/2008.
I can edit the form one record at a time, but what I'd like to do is ask the end-user to specify the date they want, and import that list into this page.
I can find the table and import the data, but I can't find where (or if) in the FieldCheck and related codeunits that I can tweak the code to just use the current contents of the Incorrect Values Table, skip the FieldCheck stuff and just apply the updates. The codeunit appears to purge the Incorrect Values table before starting (or use a temporary global to store the values and then save them at the end to the permanent table.)
Has anyone attempted to add functionality so this table can be reviewed at a later time and then implement the changes - without re-running the datecheck logic?
Thx
Ron
Ron
0
Comments
-
I would copy it to excel and write a dataport to fix the data. Make sure you have all the columns necessary to update the correct table and record.0
-
ara3n wrote:I would copy it to excel and write a dataport to fix the data. Make sure you have all the columns necessary to update the correct table and record.
The dataport isn't the problem - there's no way currently to force the processing of that table. In the standard FieldCheck codeunit, the processing of the table happens when the form is closed. The form is run modally in the middle of a function (NextTable) that is called repeatedly. I've been unable to decipher how the function works to trigger the implementation of the changes. Once the form is closed, you can open the form directly, but not force the processing of changes.
RonRon0 -
check the code on table that is used for the temp form.0
-
ara3n wrote:check the code on table that is used for the temp form.
RonRon0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions