Office XML on your 2.x 3.x or 4.x database

Marije_Brummel
Member, Moderators Design Patterns Posts: 4,262
You can use this cool functionality if you perform a technical upgrade of your database. This means only using the new runtime (fin.exe and server.exe) on your old business logic.
These are the steps to take after the runtimeupgrade
Implement Office XML in a Technical Upgrade
Codeunit 1
Copy the 3 functions from a 5.0 database
Name ID
LaunchApp 116
SelectStyleSheet 117
ManageStyleSheets 118
Objects
Copy these opbjects from 5.0 to your database
Type ID Name
Form 690 Manage Style Sheets
Form 691 Send-to Programs
Form 692 Import Style Sheet
Form 693 Program Selection
Form 694 Style Sheets
Codeunit 403 Application Launch Management
System Tables
Copy the values from system tables
2000000065 Send-To Program
2000000066 Style Sheet
2000000067 User Default Style Sheet
From a 5.0 database to your database
And your GO
One other advantage of doing a runtime upgrade is having support for Windows Vista.
A good step after this runtime upgrade is to do a functional upgrade to be fully prepared for 5.1.
Good Luck
These are the steps to take after the runtimeupgrade
Implement Office XML in a Technical Upgrade
Codeunit 1
Copy the 3 functions from a 5.0 database
Name ID
LaunchApp 116
SelectStyleSheet 117
ManageStyleSheets 118
Objects
Copy these opbjects from 5.0 to your database
Type ID Name
Form 690 Manage Style Sheets
Form 691 Send-to Programs
Form 692 Import Style Sheet
Form 693 Program Selection
Form 694 Style Sheets
Codeunit 403 Application Launch Management
System Tables
Copy the values from system tables
2000000065 Send-To Program
2000000066 Style Sheet
2000000067 User Default Style Sheet
From a 5.0 database to your database
And your GO

One other advantage of doing a runtime upgrade is having support for Windows Vista.
A good step after this runtime upgrade is to do a functional upgrade to be fully prepared for 5.1.
Good Luck
0
Comments
-
And do not forget to buy appropriate granule... or it is working with all licenses??? :-k 8)0
-
Hmm, good point. I've tested with a partner license and it works but with a customer license for 5.0 it does not. ](*,)
Does anyone know if it is :
a). A separate granule
b). A bug in the licensemodule
c). Something else
Otherwise you can always renumber. :-$0 -
I didn't found it in granule list. but:
1) it means, that there is no granule for this but you need to request refresh of license
2) It is in the list but I didn't found it
3) It is part of other granule0 -
0
-
Oops :oops:
Did not read this post. Stupid me. At least we follow the same steps.0 -
One remark.
See that the appropriate security settings are added as well (for the new objects ... being:
Table 2000000065 Send-To Program
Table 2000000066 Style Sheet
Table 2000000067 User Default Style Sheet
Table 2000000068 Record Link
Form 690 Manage Style Sheets
Form 691 Send-to Programs
Form 692 Import Style Sheet
Form 693 Program Selection
Form 694 Style Sheets
Codeunit 403 Application Launch Management
8)
I was working on a blog post before I saw this thread ...... luckily I didn't waste too much time
.
0 -
Hi,
Thanks for this great manual.
I tried it with an 4.00 SP3 database which we run with NAV 2009 SP1 client. Everything worked but as soon I add the new functions to CU1 the client crashed completly. Any ideas?
Best regards0 -
You can also copy and paste the functions and it will copy the same id's0
-
alsol wrote:Hi,
Thanks for this great manual.
I tried it with an 4.00 SP3 database which we run with NAV 2009 SP1 client. Everything worked but as soon I add the new functions to CU1 the client crashed completly. Any ideas?
Best regards
Hi Alsol,
Same thing happened with me. Did you find a solution for this?
Greetz
LD0 -
How did you add them? Did you copy and paste the functions?0
-
Hi,
I added the functions by copying the whole function. And the function ID were the same. Unfortunately it still does not work.
Any ideas?
Best regards,
Felix0 -
export CU 1 and compare it to 2009 Sp1 and see if something is different. Also, I am assuming you have copied these from 2009 cronus db.0
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