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

Lars_Westman

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

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

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

mohana_cse06

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

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

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

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..