Replace the extension with "real" objects....

Lars_Westman · 2016-10-23

Imagine that you install an extension but later on want to use a fob/txt instead and import the same objects as normal objects. Is this possible? What about the archived data that you want to restore when you import the fob?

I did a little test on this an I kind of bricked my database... (lucky me it was a db just for testing this specific scenario).

Since extensions takes away some of the control over the solution that we are used to have, I can see this as a valid scenario. It might be a customer that want's customizations. I know you can build a dependent extension on top if you want to customize, but what if you really want to revert back to real objects?

mohana_cse06 · 2016-10-24

read this blog
http://ishwar-nav.blogspot.in/2016/10/what-happens-to-data-after-extension-is.html

Data will be stored in sql. you can create some queries to move data from those created tables to real tables?

Jan_Veenendaal · 2016-10-24

Any ideas about the reverse scenario: having a customized database, and then move the customization, including data, to an extension?

mohana_cse06 · 2016-10-24

you need to include upgrade codeunit in extension to move data from real tables to extension tables..
https://msdn.microsoft.com/en-us/library/mt703362(v=nav.90).aspx

Jan_Veenendaal · 2016-10-24

Thanks Mohana,
The link you provide is about upgrade codeunits from one version of an extension to another (or even the same) of the extension. But I think you are right - we could use the 'normal' upgrade process to make a copy of the data into upgrade tables. Then only the extension should be aware that the upgrade data exists.

So an extension upgrade codeunit should probably do something like:

IF NAVAPP.GETARCHIVERECORDREF(ExtensionTable, ArchiveRecRef) THEN
  NAVAPP.RESTOREARCHIVEDATA(ExtensionTable)
ELSE
  IF DataFromUpgradeTableExists THEN
    ImportDataFromUpgradeTable
[  ELSE
    LoadDefaultDataForNAVXPackage];

Lars_Westman · 2016-10-24

mohana_cse06 wrote: »

read this blog
http://ishwar-nav.blogspot.in/2016/10/what-happens-to-data-after-extension-is.html

Data will be stored in sql. you can create some queries to move data from those created tables to real tables?

It wouldn't be that fun figuring out the relations between the real table names and the temporary names they have in SQL.... ;-)

My main reason for me to write the post was that if you don't realize that a table you are importing already exist in an installed extension you will end up with an unaccesible database. At least that's what happened to me on the 2017 limited beta. My service goes down as soon as I try to login and I get the error that the specified tenant does not exist.

mohana_cse06 · 2016-10-24

I expect an error at that point.. I have seen error while installing extension if already object is present, it should be vice versa also..

Replace the extension with "real" objects....

Comments

Categories