Codeunit 1806 Excel Data Migrator

Base Application, System.Integration

src/Layers/W1/BaseApp/ExcelDataMigrator.Codeunit.al43 procedures and triggers, in source order. Copyright (c) Microsoft Corporation. MIT

ImportExcelData line 45

  1. 50raisesOnUploadFile
  2. 52callsCodeunit 419 File Management UploadFile
  3. 56callsImportExcelDataByFileName

ImportExcelDataByFileName line 64

  1. 71callsCodeunit 419 File Management ValidateFileExtension
  2. 72callsCreatePackageMetadata
  3. 73callsValidateTemplateAndImportData

ImportExcelDataStream line 78

  1. 90callsCodeunit 419 File Management GetToFilterText
  2. 92callsImportExcelDataByStream

ImportExcelDataByStream line 96

  1. 102callsCreatePackageMetadata
  2. 103callsValidateTemplateAndImportDataStream

ExportExcelTemplate line 109

  1. 114raisesOnDownloadTemplate
  2. 115callsExportExcelTemplateByFileName

ExportExcelTemplateByFileName line 119

  1. 127callsCreatePackageMetadata
  2. 129callsCodeunit 8618 Config. Excel Exchange SetHideDialog
  3. 130callsCodeunit 8618 Config. Excel Exchange ExportExcel

CreatePackageMetadata line 138, local

  1. 146writesTable 8623 Config. Package DeleteAll(true)
  2. 148callsCodeunit 8611 Config. Package Management InsertPackage
  3. 149callsCodeunit 43 Language GetDefaultApplicationLanguageId
  4. 151callsCodeunit 9015 Application System Constants ApplicationVersion
  5. 152writesTable 8623 Config. Package Modify
  6. 154callsInsertPackageTables
  7. 155callsInsertPackageFields

InsertPackageTables line 158, local

  1. 165writesTable 1806 Data Migration Setup Insert
  2. 168callsInsertPackageTableCustomer
  3. 169callsInsertPackageTableVendor
  4. 170callsInsertPackageTableItem
  5. 171callsInsertPackageTableAccount
  6. 174writesTable 8616 Config. Package Field ModifyAll

InsertPackageFields line 177, local

  1. 179callsInsertPackageFieldsCustomer
  2. 180callsInsertPackageFieldsVendor
  3. 181callsInsertPackageFieldsItem
  4. 182callsInsertPackageFieldsAccount

InsertPackageTableCustomer line 185, local

  1. 190callsCodeunit 8611 Config. Package Management InsertPackageTable
  2. 192writesTable 8613 Config. Package Table Modify
  3. 193callsCodeunit 8611 Config. Package Management InsertProcessingRuleCustom

InsertPackageFieldsCustomer line 197, local

  1. 203writesTable 8616 Config. Package Field DeleteAll(true)
  2. 205callsInsertPackageField
  3. 206callsInsertPackageField
  4. 207callsInsertPackageField
  5. 208callsInsertPackageField
  6. 209callsInsertPackageField
  7. 210callsInsertPackageField
  8. 211callsInsertPackageField
  9. 212callsInsertPackageField
  10. 213callsInsertPackageField
  11. 214callsInsertPackageField
  12. 215callsInsertPackageField
  13. 216callsInsertPackageField
  14. 217callsInsertPackageField
  15. 218callsInsertPackageField
  16. 219callsInsertPackageField

InsertPackageTableVendor line 222, local

  1. 227callsCodeunit 8611 Config. Package Management InsertPackageTable
  2. 229writesTable 8613 Config. Package Table Modify
  3. 230callsCodeunit 8611 Config. Package Management InsertProcessingRuleCustom

InsertPackageFieldsVendor line 234, local

  1. 240writesTable 8616 Config. Package Field DeleteAll(true)
  2. 242callsInsertPackageField
  3. 243callsInsertPackageField
  4. 244callsInsertPackageField
  5. 245callsInsertPackageField
  6. 246callsInsertPackageField
  7. 247callsInsertPackageField
  8. 248callsInsertPackageField
  9. 249callsInsertPackageField
  10. 250callsInsertPackageField
  11. 251callsInsertPackageField
  12. 252callsInsertPackageField
  13. 253callsInsertPackageField
  14. 254callsInsertPackageField
  15. 255callsInsertPackageField

InsertPackageTableItem line 258, local

  1. 263callsCodeunit 8611 Config. Package Management InsertPackageTable
  2. 265writesTable 8613 Config. Package Table Modify
  3. 266callsCodeunit 8611 Config. Package Management InsertProcessingRuleCustom

InsertPackageFieldsItem line 270, local

  1. 276writesTable 8616 Config. Package Field DeleteAll(true)
  2. 278callsInsertPackageField
  3. 279callsInsertPackageField
  4. 280callsInsertPackageField
  5. 281callsInsertPackageField
  6. 282callsInsertPackageField
  7. 283callsInsertPackageField
  8. 284callsInsertPackageField
  9. 285callsInsertPackageField
  10. 286callsInsertPackageField
  11. 287callsInsertPackageField
  12. 288callsInsertPackageField
  13. 289callsInsertPackageField
  14. 290callsInsertPackageField
  15. 291callsInsertPackageField
  16. 292callsInsertPackageField
  17. 293callsInsertPackageField
  18. 294callsInsertPackageField
  19. 295callsInsertPackageField

InsertPackageField line 298, local

  1. 307callsCodeunit 8611 Config. Package Management InsertPackageField
  2. 309validatesTable 8616 Config. Package Field Processing Order
  3. 310writesTable 8616 Config. Package Field Modify(true)

ValidateTemplateAndImportData line 318, local

  1. 333callsIsTableInExcel
  2. 334callsValidateTemplateAndImportDataCommon
  3. 337callsTable 370 Excel Buffer CloseBook
  4. 338writesTable 8613 Config. Package Table Delete(true)

ValidateTemplateAndImportDataStream line 343, local

  1. 358callsIsTableInExcelStream
  2. 359callsValidateTemplateAndImportDataCommon
  3. 362callsTable 370 Excel Buffer CloseBook
  4. 363writesTable 8613 Config. Package Table Delete(true)

ValidateTemplateAndImportDataCommon line 368, local

  1. 379callsTable 370 Excel Buffer ReadSheet
  2. 397writesTable 8616 Config. Package Field Modify
  3. 403callsCodeunit 8611 Config. Package Management InitPackageRecord
  4. 410callsInsertAccountsFieldData
  5. 415callsInsertFieldData
  6. 418callsInsertFieldData
  7. 428writesTable 370 Excel Buffer DeleteAll
  8. 429callsTable 370 Excel Buffer CloseBook

IsTableInExcel line 433, local

  1. 437callsTryOpenExcel
  2. 438callsTryOpenExcel
  3. 439callsTryOpenExcel

TryOpenExcel line 443, local

  1. 445callsTable 370 Excel Buffer OpenBook

IsTableInExcelStream line 448, local

  1. 452callsOpenExcelStream
  2. 454callsOpenExcelStream

OpenExcelStream line 459, local

  1. 461callsTable 370 Excel Buffer OpenBookStream

InsertFieldData line 464, local

  1. 468callsCodeunit 8611 Config. Package Management InsertPackageData

CreateDataMigrationEntites line 472, local

  1. 479writesTable 1801 Data Migration Entity DeleteAll
  2. 484callsTable 1801 Data Migration Entity InsertRecord

RegisterExcelDataMigrator line 489, local

  1. 491callsTable 1800 Data Migrator Registration RegisterDataMigrator
  2. 491callsGetCodeunitNumber

HasSettings line 495, local

  1. 497callsGetCodeunitNumber

OpenSettings line 504, local

  1. 506callsGetCodeunitNumber
  2. 509runsPage 1807 Data Migration Settings

ValidateSettings line 514, local

  1. 518callsGetCodeunitNumber
  2. 527runsPage 1807 Data Migration Settings

HasTemplate line 531, local

  1. 533callsGetCodeunitNumber

GetInstructions line 540, local

  1. 545callsGetCodeunitNumber
  2. 548callsCodeunit 10 Type Helper CRLFSeparator

DownloadTemplate line 556, local

  1. 558callsGetCodeunitNumber
  2. 561callsExportExcelTemplate

ImportData line 568, local

  1. 570callsGetCodeunitNumber
  2. 573callsImportExcelData

SelectDataToApply line 582, local

  1. 584callsGetCodeunitNumber
  2. 587callsCreateDataMigrationEntites

HasAdvancedApply line 593, local

  1. 595callsGetCodeunitNumber

OpenAdvancedApply line 602, local

  1. 606callsGetCodeunitNumber
  2. 613runsPage 8614 Config. Package Card
  3. 615callsCreateDataMigrationEntites

ApplySelectedData line 620, local

  1. 628callsGetCodeunitNumber
  2. 635callsCodeunit 8611 Config. Package Management SetHideDialog
  3. 636callsCodeunit 8611 Config. Package Management CleanPackageErrors
  4. 641callsCodeunit 8611 Config. Package Management ValidatePackageRelations
  5. 645callsCodeunit 8611 Config. Package Management SetHideDialog
  6. 647callsCodeunit 8611 Config. Package Management CleanPackageErrors
  7. 657writesTable 8613 Config. Package Table Delete(true)
  8. 662callsRemoveDemoData
  9. 663callsCodeunit 8611 Config. Package Management ApplyPackage

HasErrors line 669, local

  1. 673callsGetCodeunitNumber

ShowErrors line 682, local

  1. 686callsGetCodeunitNumber
  2. 690runsPage 8616 Config. Package Errors

InsertPackageTableAccount line 703, local

  1. 708callsCodeunit 8611 Config. Package Management InsertPackageTable
  2. 710writesTable 8613 Config. Package Table Modify
  3. 711callsCodeunit 8611 Config. Package Management InsertProcessingRuleCustom

InsertPackageFieldsAccount line 715, local

  1. 721writesTable 8616 Config. Package Field DeleteAll(true)
  2. 723callsInsertPackageField
  3. 724callsInsertPackageField
  4. 725callsInsertPackageField
  5. 726callsInsertPackageField
  6. 727callsInsertPackageField
  7. 728callsInsertPackageField
  8. 729callsInsertPackageField
  9. 730callsInsertPackageField
  10. 731callsInsertPackageField
  11. 732callsInsertPackageField
  12. 733callsInsertPackageField
  13. 734callsInsertPackageField

RemoveDemoData line 737, local

  1. 749runsCodeunit 1812 Data Migration Del G/L Account

InsertAccountsFieldData line 754, local

  1. 760callsInsertFieldData
  2. 763callsInsertFieldData
  3. 766callsInsertFieldData
  4. 769callsInsertFieldData
  5. 772callsInsertFieldData
  6. 776callsInsertFieldData
  7. 779callsInsertFieldData
  8. 782callsInsertFieldData
  9. 785callsInsertFieldData
  10. 788callsInsertFieldData
  11. 791callsInsertFieldData
  12. 794callsInsertFieldData
  13. 798callsInsertFieldData
  14. 801callsInsertFieldData
  15. 805callsInsertFieldData
  16. 808callsInsertFieldData
  17. 811callsInsertFieldData
  18. 815callsInsertFieldData
  19. 818callsInsertFieldData
  20. 821callsInsertFieldData
  21. 823callsInsertFieldData