Codeunit 1798 Data Migration Mgt.
src/Layers/W1/BaseApp/System/DataMigration/DataMigrationMgt.Codeunit.al787 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Integration;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.Finance.GeneralLedger.Journal;using Microsoft.Inventory.Item;using Microsoft.Inventory.Journal;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using System.Environment.Configuration;using System.Threading;codeunit 1798 "Data Migration Mgt."{ TableNo = "Job Queue Entry"; trigger OnRun() var DataMigrationError: Record "Data Migration Error"; DataMigrationStatus: Record "Data Migration Status"; Retry: Boolean; DataCreationFailed: Boolean; begin EnableDataMigrationNotificationForAllUsers(); DataMigrationStatus.Get(Rec."Record ID to Process"); DataMigrationStatus.SetRange("Migration Type", DataMigrationStatus."Migration Type"); Retry := Rec."Parameter String" = RetryTxt; OnBeforeMigrationStarted(DataMigrationStatus, Retry); if not Retry then begin DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::Pending); DataMigrationFacade.OnFillStagingTables(); // Close the transaction here otherwise the CODEUNIT.RUN cannot be invoked Commit(); end else DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::"Completed with Errors"); // migrate GL accounts (delete the existing ones on a first migration and if GL accounts are migrated) DataMigrationStatus.SetRange("Destination Table ID", DATABASE::"G/L Account"); if DataMigrationStatus.FindFirst() and not Retry then if not CODEUNIT.Run(CODEUNIT::"Data Migration Del G/L Account") then DataMigrationError.CreateEntryNoStagingTable(DataMigrationStatus."Migration Type", DATABASE::"G/L Account"); if CheckAbortRequestedAndMigrateEntity( DataMigrationStatus, DATABASE::"G/L Account", CODEUNIT::"GL Acc. Data Migration Facade", Retry) then exit; // migrate customers if CheckAbortRequestedAndMigrateEntity(DataMigrationStatus, DATABASE::Customer, CODEUNIT::"Customer Data Migration Facade", Retry) then exit; // migrate vendor if CheckAbortRequestedAndMigrateEntity(DataMigrationStatus, DATABASE::Vendor, CODEUNIT::"Vendor Data Migration Facade", Retry) then exit; // migrate items if CheckAbortRequestedAndMigrateEntity(DataMigrationStatus, DATABASE::Item, CODEUNIT::"Item Data Migration Facade", Retry) then exit; // migrate any other tables if any CheckAbortAndMigrateRemainingEntities(DataMigrationStatus, Retry); OnCreatePostMigrationData(DataMigrationStatus, DataCreationFailed); OnValidateMigration(DataMigrationStatus, DataCreationFailed); if DataCreationFailed then exit; OnAfterMigrationFinished(DataMigrationStatus, false, StartTime, Retry); end; var DataMigrationStatusFacade: Codeunit "Data Migration Status Facade"; DataMigrationFacade: Codeunit "Data Migration Facade"; AbortRequested: Boolean; StartTime: DateTime; RetryTxt: Label 'Retry', Locked = true; DataMigrationNotCompletedQst: Label 'A data migration is already in progress. To see the status of the migration, go to the %1 page. Do you want to do that now?', Comment = '%1 is the caption for Data Migration Overview'; CustomerTableNotEmptyErr: Label 'The migration has stopped because we found some customers in %1. You must delete them and then restart the migration.', Comment = '%1 product name '; ItemTableNotEmptyErr: Label 'The migration has stopped because we found some items in %1. You must delete them and then restart the migration.', Comment = '%1 product name '; VendorTableNotEmptyErr: Label 'The migration has stopped because we found some vendors in %1. You must delete them and then restart the migration.', Comment = '%1 product name '; DataMigrationInProgressMsg: Label 'We''re migrating data to %1.', Comment = '%1 product name '; DataMigrationCompletedWithErrosMsg: Label 'Data migration has stopped due to errors. Go to the %1 page to fix them.', Comment = '%1 Data Migration Overview page'; DataMigrationEntriesToPostMsg: Label 'Data migration is complete, however, there are still a few things to do. Go to the Data Migration Overview page for more information.'; DataMigrationFinishedMsg: Label 'Yes! The data you chose was successfully migrated.'; DataMigrationNotificationNameTxt: Label 'Data migration notification'; DataMigrationNotificationDescTxt: Label 'Show a warning when data migration is either in progress or has completed.'; DontShowTxt: Label 'Don''t show again'; MigrationStatus: Option Pending,"In Progress","Completed with errors",Completed,Stopped,Failed,"Not Started"; GoThereNowTxt: Label 'Go there now'; MoreInfoTxt: Label 'Learn more'; DataMigrationHelpTopicURLTxt: Label 'https://go.microsoft.com/fwlink/?linkid=859445', Locked = true; CustomersEmptyListNotificationNameTxt: Label 'Show a suggestion to import customers when none exists.'; VendorsEmptyListNotificationNameTxt: Label 'Show a suggestion to import vendors when none exists.'; ItemsEmptyListNotificationNameTxt: Label 'Show a suggestion to import items when none exists.'; CustomerContactNotificationNameTxt: Label 'Show a suggestion to create contacts for newly created customers.'; VendorContactNotificationNameTxt: Label 'Show a suggestion to create contacts for newly created vendors.'; CustContactNotificationDescTxt: Label 'Show a suggestion to create contacts for customers.'; VendContactNotificationDescTxt: Label 'Show a suggestion to create contacts for vendors.'; local procedure HandleEntityMigration(var DataMigrationStatus: Record "Data Migration Status"; BaseAppMigrationCodeunitToRun: Integer; Retry: Boolean) var DataMigrationError: Record "Data Migration Error"; begin if DataMigrationStatus.FindFirst() then if DataMigrationStatus."Source Staging Table ID" > 0 then StagingTableEntityMigration(DataMigrationStatus, BaseAppMigrationCodeunitToRun, Retry) else begin DataMigrationStatusFacade.UpdateLineStatus(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DataMigrationStatus.Status::"In Progress"); DataMigrationError.ClearEntryNoStagingTable(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID"); Commit(); // save the dashboard before calling the extension codeunit if CODEUNIT.Run(DataMigrationStatus."Migration Codeunit To Run") then begin DataMigrationStatus.Get(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID"); if DataMigrationStatus."Migrated Number" = 0 then DataMigrationStatusFacade.IncrementMigratedRecordCount( DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DataMigrationStatus."Total Number"); DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::"In Progress"); if DataMigrationStatus.FindSet() then DataMigrationStatusFacade.UpdateLineStatus( DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DataMigrationStatus.Status::Completed); end else begin DataMigrationError.CreateEntryNoStagingTable(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID"); DataMigrationStatusFacade.UpdateLineStatus( DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DataMigrationStatus.Status::Failed); end; end; Commit(); // save the dashboard as the job could fail on the next task end; local procedure StagingTableEntityMigration(DataMigrationStatus: Record "Data Migration Status"; BaseAppCodeunitToRun: Integer; Retry: Boolean) var TempDataMigrationParametersBatch: Record "Data Migration Parameters" temporary; DummyDataMigrationStatus: Record "Data Migration Status"; DataMigrationError: Record "Data Migration Error"; StagingTableRecRef: RecordRef; "Count": Integer; begin StagingTableRecRef.Open(DataMigrationStatus."Source Staging Table ID"); if StagingTableRecRef.FindSet() then begin DataMigrationStatusFacade.UpdateLineStatus(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DummyDataMigrationStatus.Status::"In Progress"); repeat if AbortRequested then exit; DataMigrationError.Reset(); if not Retry or (Retry and DataMigrationError.FindEntry(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", StagingTableRecRef.RecordId) and DataMigrationError."Scheduled For Retry" = true) then begin Count += 1; TempDataMigrationParametersBatch.Init(); TempDataMigrationParametersBatch.Key := Count; TempDataMigrationParametersBatch."Migration Type" := DataMigrationStatus."Migration Type"; TempDataMigrationParametersBatch."Staging Table Migr. Codeunit" := DataMigrationStatus."Migration Codeunit To Run"; TempDataMigrationParametersBatch."Staging Table RecId To Process" := StagingTableRecRef.RecordId; TempDataMigrationParametersBatch.Insert(); DataMigrationError.ClearEntry(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", StagingTableRecRef.RecordId); end; if Count = 100 then begin // try to process batch Commit(); // to save the transaction that has deleted the errors ProcessBatch(DataMigrationStatus, BaseAppCodeunitToRun, TempDataMigrationParametersBatch, Count); Count := 0; TempDataMigrationParametersBatch.DeleteAll(); end; until StagingTableRecRef.Next() = 0; if AbortRequested then exit; if Count > 0 then begin Commit(); // to save the transaction that has deleted the errors ProcessBatch(DataMigrationStatus, BaseAppCodeunitToRun, TempDataMigrationParametersBatch, Count); end; end; DataMigrationStatus.CalcFields("Error Count"); if DataMigrationStatus."Error Count" = 0 then DataMigrationStatusFacade.UpdateLineStatus( DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DummyDataMigrationStatus.Status::Completed) else DataMigrationStatusFacade.UpdateLineStatus( DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", DummyDataMigrationStatus.Status::"Completed with Errors"); end; local procedure ProcessBatch(DataMigrationStatus: Record "Data Migration Status"; BaseAppCodeunitToRun: Integer; var TempDataMigrationParametersBatch: Record "Data Migration Parameters" temporary; "Count": Integer) var TempDataMigrationParametersSingle: Record "Data Migration Parameters" temporary; DataMigrationError: Record "Data Migration Error"; begin // try to process batch if CODEUNIT.Run(BaseAppCodeunitToRun, TempDataMigrationParametersBatch) then begin // the batch was processed fine, update the dashboard DataMigrationStatusFacade.IncrementMigratedRecordCount(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", Count); Commit(); // save the dashboard status before calling the next Codeunit.RUN end else begin // the batch processing failed TempDataMigrationParametersBatch.FindSet(); repeat // process one by one TempDataMigrationParametersSingle.DeleteAll(); TempDataMigrationParametersSingle.Init(); TempDataMigrationParametersSingle.TransferFields(TempDataMigrationParametersBatch); TempDataMigrationParametersSingle.Insert(); if CODEUNIT.Run(BaseAppCodeunitToRun, TempDataMigrationParametersSingle) then begin // single record processing succeeded, update dashboard DataMigrationStatusFacade.IncrementMigratedRecordCount(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", 1); Commit(); // save the dashboard status before calling the next Codeunit.RUN end else begin DataMigrationError.CreateEntry(DataMigrationStatus."Migration Type", DataMigrationStatus."Destination Table ID", TempDataMigrationParametersSingle."Staging Table RecId To Process"); Commit(); // save the new errors discovered end; until TempDataMigrationParametersBatch.Next() = 0; end; end; procedure RunStagingTableMigrationCodeunit(CodeunitToRun: Integer; StagingTableEntityVariant: Variant): Boolean begin exit(CODEUNIT.Run(CodeunitToRun, StagingTableEntityVariant)); end; [EventSubscriber(ObjectType::Page, Page::"Data Migration Overview", 'OnRequestAbort', '', false, false)] local procedure OnRequestAbortSubscriber() begin AbortRequested := true; end; local procedure CheckAbortRequestedAndMigrateEntity(var DataMigrationStatus: Record "Data Migration Status"; DestinationTableId: Integer; BaseAppCodeunitToRun: Integer; ReRun: Boolean): Boolean begin if AbortRequested then begin DataMigrationStatus.Reset(); DataMigrationStatus.SetRange("Migration Type", DataMigrationStatus."Migration Type"); SetAbortStatus(DataMigrationStatus); OnAfterMigrationFinished(DataMigrationStatus, true, StartTime, ReRun); exit(true); end; DataMigrationStatus.SetRange("Destination Table ID", DestinationTableId); HandleEntityMigration(DataMigrationStatus, BaseAppCodeunitToRun, ReRun); end; local procedure CheckAbortAndMigrateRemainingEntities(DataMigrationStatus: Record "Data Migration Status"; Retry: Boolean) begin if AbortRequested then begin DataMigrationStatus.Reset(); DataMigrationStatus.SetRange("Migration Type", DataMigrationStatus."Migration Type"); SetAbortStatus(DataMigrationStatus); OnAfterMigrationFinished(DataMigrationStatus, true, StartTime, Retry); exit; end; DataMigrationStatus.SetFilter("Destination Table ID", StrSubstNo('<>%1&<>%2&<>%3&<>%4', DATABASE::Item, DATABASE::Customer, DATABASE::"G/L Account", DATABASE::Vendor)); DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::Pending); if DataMigrationStatus.FindSet() then repeat HandleEntityMigration(DataMigrationStatus, DataMigrationStatus."Migration Codeunit To Run", Retry); until DataMigrationStatus.Next() = 0; end; procedure SetStartTime(Value: DateTime) begin StartTime := Value; end; procedure SetAbortStatus(var DataMigrationStatus: Record "Data Migration Status") begin DataMigrationStatus.SetFilter( Status, StrSubstNo('%1|%2', DataMigrationStatus.Status::"In Progress", DataMigrationStatus.Status::Pending)); if DataMigrationStatus.FindSet() then repeat DataMigrationStatus.Status := DataMigrationStatus.Status::Stopped; DataMigrationStatus.Modify(true); until DataMigrationStatus.Next() = 0; end; [IntegrationEvent(true, false)] [Scope('OnPrem')] procedure OnBeforeMigrationStarted(var DataMigrationStatus: Record "Data Migration Status"; Retry: Boolean) begin end; [IntegrationEvent(false, false)] procedure OnCreatePostMigrationData(var DataMigrationStatus: Record "Data Migration Status"; var DataCreationFailed: Boolean) begin end; [IntegrationEvent(false, false)] [Scope('OnPrem')] procedure OnValidateMigration(var DataMigrationStatus: Record "Data Migration Status"; var DataCreationFailed: Boolean) begin end; [IntegrationEvent(false, false)] [Scope('OnPrem')] procedure OnAfterMigrationFinished(var DataMigrationStatus: Record "Data Migration Status"; WasAborted: Boolean; StartTime: DateTime; Retry: Boolean) begin end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Data Migration Mgt.", 'OnBeforeMigrationStarted', '', true, true)] local procedure OnBeforeMigrationStartedSubscriber(var Sender: Codeunit "Data Migration Mgt."; var DataMigrationStatus: Record "Data Migration Status"; Retry: Boolean) var Message: Text; begin Sender.SetStartTime(CurrentDateTime); if Retry then Message := 'Migration started.' else Message := 'Migration restarted.'; Session.LogMessage('00001I7', Message, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', StrSubstNo('Data Migration (%1)', DataMigrationStatus."Migration Type")); end; [EventSubscriber(ObjectType::Codeunit, Codeunit::"Data Migration Mgt.", 'OnAfterMigrationFinished', '', true, true)] local procedure OnAfterMigrationFinishedSubscriber(var DataMigrationStatus: Record "Data Migration Status"; WasAborted: Boolean; StartTime: DateTime; Retry: Boolean) var TotalNumberOfRecords: Integer; Message: Text; MigrationDurationAsInt: BigInteger; begin DataMigrationStatus.SetRange("Destination Table ID", DATABASE::"G/L Account"); if DataMigrationStatus.FindFirst() then TotalNumberOfRecords += DataMigrationStatus."Total Number"; DataMigrationStatus.SetRange("Destination Table ID", DATABASE::Item); if DataMigrationStatus.FindFirst() then TotalNumberOfRecords += DataMigrationStatus."Total Number"; DataMigrationStatus.SetRange("Destination Table ID", DATABASE::Vendor); if DataMigrationStatus.FindFirst() then TotalNumberOfRecords += DataMigrationStatus."Total Number"; DataMigrationStatus.SetRange("Destination Table ID", DATABASE::Customer); if DataMigrationStatus.FindFirst() then TotalNumberOfRecords += DataMigrationStatus."Total Number"; MigrationDurationAsInt := CurrentDateTime - StartTime; if WasAborted then Message := StrSubstNo('Migration aborted after %1', MigrationDurationAsInt) else Message := StrSubstNo('The migration of %1 records in total took: %2.', TotalNumberOfRecords, MigrationDurationAsInt); if Retry then Message += '(Migration was restarted)'; Session.LogMessage('00001DA', Message, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', StrSubstNo('Data Migration (%1)', DataMigrationStatus."Migration Type")); end; procedure StartMigration(MigrationType: Text[250]; Retry: Boolean) var DataMigrationError: Record "Data Migration Error"; DataMigrationStatus: Record "Data Migration Status"; JobQueueEntry: Record "Job Queue Entry"; JobParameters: Text[250]; StartNewSession: Boolean; CheckExistingData: Boolean; begin CheckMigrationInProgress(Retry); StartNewSession := false; CheckExistingData := true; OnBeforeStartMigration(StartNewSession, CheckExistingData); if CheckExistingData then CheckDataAlreadyExist(MigrationType, Retry); DataMigrationStatus.Reset(); DataMigrationStatus.SetRange("Migration Type", MigrationType); if not Retry then begin DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::Pending); if DataMigrationStatus.FindSet() then repeat DataMigrationError.SetRange("Migration Type", MigrationType); DataMigrationError.SetRange("Destination Table ID", DataMigrationStatus."Destination Table ID"); DataMigrationError.DeleteAll(); until DataMigrationStatus.Next() = 0; end else DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::"Completed with Errors"); Commit(); // commit the dashboard changes so the OnRun call on the migration codeunit will not fail because of this uncommited transaction if Retry then JobParameters := RetryTxt; DataMigrationStatus.FindFirst(); if StartNewSession then // run the migration in a background session JobQueueEntry.ScheduleJobQueueEntryWithParameters(CODEUNIT::"Data Migration Mgt.", DataMigrationStatus.RecordId, JobParameters) else begin JobQueueEntry."Record ID to Process" := DataMigrationStatus.RecordId; JobQueueEntry."Parameter String" := JobParameters; CODEUNIT.Run(CODEUNIT::"Data Migration Mgt.", JobQueueEntry); end; end; [IntegrationEvent(false, false)] local procedure OnBeforeStartMigration(var StartNewSession: Boolean; var CheckExistingData: Boolean) begin end; procedure CheckMigrationInProgress(Retry: Boolean) var JobQueueEntry: Record "Job Queue Entry"; DataMigrationOverview: Page "Data Migration Overview"; Status: Option; begin Status := GetMigrationStatus(); JobQueueEntry.SetRange("Object ID to Run", CODEUNIT::"Data Migration Mgt."); JobQueueEntry.SetFilter(Status, '%1|%2|%3', JobQueueEntry.Status::"In Process", JobQueueEntry.Status::"On Hold", JobQueueEntry.Status::Ready); if (Status = MigrationStatus::Pending) and not JobQueueEntry.FindFirst() then exit; if (Status in [MigrationStatus::"Completed with errors", MigrationStatus::"In Progress", MigrationStatus::Pending]) and not Retry then begin if Confirm(StrSubstNo(DataMigrationNotCompletedQst, DataMigrationOverview.Caption)) then DataMigrationOverview.Run(); Error(''); end; end; procedure GetMigrationStatus(): Integer var DataMigrationStatus: Record "Data Migration Status"; begin if DataMigrationStatus.IsEmpty() then exit(MigrationStatus::"Not Started"); DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::"In Progress"); if DataMigrationStatus.FindFirst() then exit(MigrationStatus::"In Progress"); DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::Stopped); if DataMigrationStatus.FindFirst() then exit(MigrationStatus::Stopped); DataMigrationStatus.SetFilter(Status, '=%1', DataMigrationStatus.Status::Failed); if DataMigrationStatus.FindFirst() then exit(MigrationStatus::Failed); DataMigrationStatus.SetRange(Status, DataMigrationStatus.Status::"Completed with Errors"); if DataMigrationStatus.FindFirst() then exit(MigrationStatus::"Completed with errors"); DataMigrationStatus.SetFilter(Status, '<>%1', DataMigrationStatus.Status::Completed); if not DataMigrationStatus.FindFirst() then exit(MigrationStatus::Completed); exit(MigrationStatus::Pending); end; local procedure CheckDataAlreadyExist(MigrationType: Text[250]; Retry: Boolean) begin if Retry then exit; // check tables are clear. For GL accounts, we delete them automatically ThrowErrorIfTableNotEmpty(MigrationType, DATABASE::Customer, StrSubstNo(CustomerTableNotEmptyErr, PRODUCTNAME.Short())); ThrowErrorIfTableNotEmpty(MigrationType, DATABASE::Vendor, StrSubstNo(VendorTableNotEmptyErr, PRODUCTNAME.Short())); ThrowErrorIfTableNotEmpty(MigrationType, DATABASE::Item, StrSubstNo(ItemTableNotEmptyErr, PRODUCTNAME.Short())); end; local procedure ThrowErrorIfTableNotEmpty(MigrationType: Text[250]; TableId: Integer; ErrorMessageErr: Text) var DataMigrationStatus: Record "Data Migration Status"; RecRef: RecordRef; begin if DataMigrationStatus.Get(MigrationType, TableId) then begin if DataMigrationStatus.Status <> DataMigrationStatus.Status::Pending then exit; RecRef.Open(TableId); if not RecRef.IsEmpty() then Error(ErrorMessageErr); end; end; procedure StartDataMigrationWizardFromNotification(Notification: Notification) begin PAGE.Run(PAGE::"Data Migration Wizard"); end; procedure ShowDataMigrationRelatedGlobalNotifications() var DataMigrationStatus: Record "Data Migration Status"; DataMigrationOverview: Page "Data Migration Overview"; Notification: Notification; begin if not IsGlobalNotificationEnabled() then exit; if DataMigrationStatus.IsEmpty() then exit; Notification.Id(GetGlobalNotificationId()); case GetMigrationStatus() of MigrationStatus::Pending, MigrationStatus::"In Progress": begin Notification.Message(StrSubstNo(DataMigrationInProgressMsg, PRODUCTNAME.Short())); Notification.AddAction(MoreInfoTxt, CODEUNIT::"Data Migration Mgt.", 'ShowMoreInfoPage'); end; MigrationStatus::"Completed with errors", MigrationStatus::Failed: begin Notification.Message(StrSubstNo(DataMigrationCompletedWithErrosMsg, DataMigrationOverview.Caption)); Notification.AddAction(GoThereNowTxt, CODEUNIT::"Data Migration Mgt.", 'ShowDataMigrationOverviewFromNotification'); end; MigrationStatus::Completed: if CheckForEntitiesToBePosted() then begin Notification.Message(DataMigrationEntriesToPostMsg); Notification.AddAction(GoThereNowTxt, CODEUNIT::"Data Migration Mgt.", 'ShowDataMigrationOverviewFromNotification'); end else begin Notification.Message(DataMigrationFinishedMsg); Notification.AddAction(DontShowTxt, CODEUNIT::"Data Migration Mgt.", 'DisableDataMigrationRelatedGlobalNotifications'); end; else exit; end; Notification.Send(); end; [Scope('OnPrem')] procedure GetGlobalNotificationId(): Guid begin exit('47707336-D917-4238-942F-39715F52BE4E'); end; [Scope('OnPrem')] procedure GetCustomerContactNotificationId(): Guid begin exit('351199D7-6C9B-40F1-8E78-ff9E67C546C9'); end; [Scope('OnPrem')] procedure GetVendorContactNotificationId(): Guid begin exit('08DB77DB-1F41-4379-8615-1B581A0225FA'); end; internal procedure GetItemListEmptyNotificationId(): Guid begin exit('91ec9d2f-5328-4543-a4bb-565910ad168f'); end; internal procedure GetCustomerListEmptyNotificationId(): Guid begin exit('ce4f84ea-a382-433a-a908-e2b22799321a'); end; internal procedure GetVendorListEmptyNotificationId(): Guid begin exit('920c72f6-4771-4984-a223-5f941951cd40'); end; local procedure IsGlobalNotificationEnabled(): Boolean var MyNotifications: Record "My Notifications"; begin exit(MyNotifications.IsEnabled(GetGlobalNotificationId())); end; [EventSubscriber(ObjectType::Page, Page::"My Notifications", 'OnInitializingNotificationWithDefaultState', '', false, false)] local procedure OnInitializingNotificationWithDefaultState() var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault(GetGlobalNotificationId(), DataMigrationNotificationNameTxt, DataMigrationNotificationDescTxt, true); InsertDefaultCustomerContactNotification(true); InsertDefaultVendorContactNotification(true); InsertDefaultCustomerListEmptyNotification(true); InsertDefaultVendorListEmptyNotification(true); InsertDefaultItemListEmptyNotification(true); end; procedure ShowDataMigrationOverviewFromNotification(Notification: Notification) begin PAGE.Run(PAGE::"Data Migration Overview"); end; procedure IsMigrationInProgress(): Boolean begin exit(GetMigrationStatus() in [MigrationStatus::"In Progress", MigrationStatus::Pending]); end; procedure ShowMoreInfoPage(Notification: Notification) begin if PAGE.RunModal(PAGE::"Data Migration About") = ACTION::LookupOK then ShowDataMigrationOverviewFromNotification(Notification); end; procedure CheckForEntitiesToBePosted(): Boolean var DataMigrationStatus: Record "Data Migration Status"; DummyCode: Code[10]; begin DataMigrationStatus.SetFilter( Status, '%1|%2', DataMigrationStatus.Status::Completed, DataMigrationStatus.Status::"Completed with Errors"); if not DataMigrationStatus.FindSet() then exit(false); repeat if DestTableHasAnyTransactions(DataMigrationStatus, DummyCode) then exit(true); until DataMigrationStatus.Next() = 0; end; procedure DestTableHasAnyTransactions(var DataMigrationStatus: Record "Data Migration Status"; var JournalBatchName: Code[10]): Boolean var GenJournalLine: Record "Gen. Journal Line"; ItemJournalLine: Record "Item Journal Line"; begin case DataMigrationStatus."Destination Table ID" of DATABASE::Vendor: begin DataMigrationFacade.OnFindBatchForVendorTransactions(DataMigrationStatus."Migration Type", JournalBatchName); if JournalBatchName = '' then exit(false); GenJournalLine.SetRange("Journal Batch Name", JournalBatchName); GenJournalLine.SetRange("Account Type", GenJournalLine."Account Type"::Vendor); GenJournalLine.SetFilter("Account No.", '<>%1', ''); exit(GenJournalLine.FindFirst()); end; DATABASE::Customer: begin DataMigrationFacade.OnFindBatchForCustomerTransactions(DataMigrationStatus."Migration Type", JournalBatchName); if JournalBatchName = '' then exit(false); GenJournalLine.SetRange("Journal Batch Name", JournalBatchName); GenJournalLine.SetRange("Account Type", GenJournalLine."Account Type"::Customer); GenJournalLine.SetFilter("Account No.", '<>%1', ''); exit(GenJournalLine.FindFirst()); end; DATABASE::Item: begin DataMigrationFacade.OnFindBatchForItemTransactions(DataMigrationStatus."Migration Type", JournalBatchName); if JournalBatchName = '' then exit(false); ItemJournalLine.SetRange("Journal Batch Name", JournalBatchName); ItemJournalLine.SetFilter("Item No.", '<>%1', ''); exit(not ItemJournalLine.IsEmpty()); end; else begin DataMigrationFacade.OnFindBatchForAccountTransactions(DataMigrationStatus, JournalBatchName); if JournalBatchName = '' then exit(false); GenJournalLine.SetRange("Journal Batch Name", JournalBatchName); GenJournalLine.SetRange("Account Type", GenJournalLine."Account Type"::"G/L Account"); GenJournalLine.SetFilter("Account No.", '<>%1', ''); exit(not GenJournalLine.IsEmpty()); end; end; end; [Scope('OnPrem')] procedure ShowHelpTopicPage(Notification: Notification) begin HyperLink(DataMigrationHelpTopicURLTxt); end; procedure GetDataMigrationHelpTopicURL(): Text begin exit(DataMigrationHelpTopicURLTxt) end; [Scope('OnPrem')] procedure DisableDataMigrationRelatedGlobalNotifications(Notification: Notification) var MyNotifications: Record "My Notifications"; begin if not MyNotifications.Disable(GetGlobalNotificationId()) then MyNotifications.InsertDefault(GetGlobalNotificationId(), DataMigrationNotificationNameTxt, DataMigrationNotificationDescTxt, false); end; local procedure EnableDataMigrationNotificationForAllUsers() var MyNotifications: Record "My Notifications"; begin MyNotifications.SetRange("Notification Id", GetGlobalNotificationId()); if MyNotifications.FindSet() then repeat MyNotifications.Enabled := true; MyNotifications.Modify(true); until MyNotifications.Next() = 0; end; procedure InsertDefaultCustomerContactNotification(Enabled: Boolean) var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault( GetCustomerContactNotificationId(), CustomerContactNotificationNameTxt, CustContactNotificationDescTxt, Enabled); end; procedure InsertDefaultVendorContactNotification(Enabled: Boolean) var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault( GetVendorContactNotificationId(), VendorContactNotificationNameTxt, VendContactNotificationDescTxt, Enabled); end; procedure InsertDefaultCustomerListEmptyNotification(Enabled: Boolean) var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault( GetCustomerListEmptyNotificationId(), CustomersEmptyListNotificationNameTxt, '', Enabled); end; procedure InsertDefaultVendorListEmptyNotification(Enabled: Boolean) var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault( GetVendorListEmptyNotificationId(), VendorsEmptyListNotificationNameTxt, '', Enabled); end; procedure InsertDefaultItemListEmptyNotification(Enabled: Boolean) var MyNotifications: Record "My Notifications"; begin MyNotifications.InsertDefault( GetItemListEmptyNotificationId(), ItemsEmptyListNotificationNameTxt, '', Enabled); end; procedure UpdateMigrationStatus(var DataMigrationStatus: Record "Data Migration Status") var JobQueueEntry: Record "Job Queue Entry"; begin if not (DataMigrationStatus.Status in [DataMigrationStatus.Status::Pending, DataMigrationStatus.Status::"In Progress"]) then exit; JobQueueEntry.SetFilter(Status, '%1|%2', JobQueueEntry.Status::Ready, JobQueueEntry.Status::"In Process"); JobQueueEntry.SetRange("Object ID to Run", CODEUNIT::"Data Migration Mgt."); if JobQueueEntry.FindFirst() then exit; JobQueueEntry.SetRange(Status, JobQueueEntry.Status::Error); if JobQueueEntry.FindFirst() then begin DataMigrationStatus.Validate(Status, DataMigrationStatus.Status::Failed); DataMigrationStatus.Modify(true); end; end; procedure CheckIfMigrationIsCompleted(CurrentDataMigrationStatus: Record "Data Migration Status") var DataMigrationStatus: Record "Data Migration Status"; DataMigrationFacade: Codeunit "Data Migration Facade"; begin DataMigrationStatus.SetRange("Migration Type", CurrentDataMigrationStatus."Migration Type"); DataMigrationStatus.SetFilter("Destination Table ID", '<>%1', CurrentDataMigrationStatus."Destination Table ID"); DataMigrationStatus.SetFilter( Status, '%1|%2|%3', DataMigrationStatus.Status::"In Progress", DataMigrationStatus.Status::Pending, DataMigrationStatus.Status::"Completed with Errors"); if DataMigrationStatus.IsEmpty() then DataMigrationFacade.OnMigrationCompleted(CurrentDataMigrationStatus); end;}