---
id: object/codeunit/1806
type: object
title: Codeunit 1806 "Excel Data Migrator"
summary: Codeunit 1806 "Excel Data Migrator" in Base Application (System.Integration). 7 public procedures, 2 events, 14 event subscribers. Present since at least BC23, still in BC30.
tier: official
language: en
tags:
  - codeunit
  - base application
versions:
  introduced: null
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: c488b38dca34ac305cb7855b3275af3bcbd8e499e176f829d05ec8867a660dae
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/ExcelDataMigrator.Codeunit.al
    title: src/Layers/W1/BaseApp/ExcelDataMigrator.Codeunit.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: codeunit
object_id: 1806
name: Excel Data Migrator
namespace: System.Integration
app: Base Application
extends: null
first_version: "23"
last_version: "30"
present_in:
  - "23"
  - "24"
  - "25"
  - "26"
  - "27"
  - "28"
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 0
  procedures: 47
  events: 2
  subscribers: 14
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 10
  called_by: 0
  implements: 0
---

# Codeunit 1806 "Excel Data Migrator"

> Codeunit 1806 "Excel Data Migrator" in Base Application (System.Integration). 7 public procedures, 2 events, 14 event subscribers. Present since at least BC23, still in BC30.

Base Application · System.Integration · BC23-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Layers/W1/BaseApp/ExcelDataMigrator.Codeunit.al) · facts from BC29

## Events published

- `OnUploadFile(var ServerFileName: Text)` (integration)
- `OnDownloadTemplate(var HideDialog: Boolean)` (integration)

## Event subscriptions

- RegisterExcelDataMigrator subscribes to Table "Data Migrator Registration" OnRegisterDataMigrator
- HasSettings subscribes to Table "Data Migrator Registration" OnHasSettings
- OpenSettings subscribes to Table "Data Migrator Registration" OnOpenSettings
- ValidateSettings subscribes to Table "Data Migrator Registration" OnValidateSettings
- HasTemplate subscribes to Table "Data Migrator Registration" OnHasTemplate
- GetInstructions subscribes to Table "Data Migrator Registration" OnGetInstructions
- DownloadTemplate subscribes to Table "Data Migrator Registration" OnDownloadTemplate
- ImportData subscribes to Table "Data Migrator Registration" OnDataImport
- SelectDataToApply subscribes to Table "Data Migrator Registration" OnSelectDataToApply
- HasAdvancedApply subscribes to Table "Data Migrator Registration" OnHasAdvancedApply
- OpenAdvancedApply subscribes to Table "Data Migrator Registration" OnOpenAdvancedApply
- ApplySelectedData subscribes to Table "Data Migrator Registration" OnApplySelectedData
- HasErrors subscribes to Table "Data Migrator Registration" OnHasErrors
- ShowErrors subscribes to Table "Data Migrator Registration" OnShowErrors

## Procedures

- `ImportExcelData(): Boolean`
- `ImportExcelDataByFileName(FileName: Text[250])`
- `ImportExcelDataStream(): Boolean`
- `ImportExcelDataByStream(FileStream: InStream)`
- `ExportExcelTemplate(): Boolean`
- `ExportExcelTemplateByFileName(var FileName: Text; HideDialog: Boolean): Boolean`
- `GetPackageCode(): Code[20]`

Plus 24 local procedures.

## Triggers

OnRun

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 8611 "Config. Package Management"](../codeunit/8611.md) (16 calls: `ApplySelectedData → ApplyPackage`, `ApplySelectedData → CleanPackageErrors`, `ApplySelectedData → SetHideDialog`, …)
- [Codeunit 419 "File Management"](../codeunit/419.md) (3 calls: `ImportExcelData → UploadFile`, `ImportExcelDataByFileName → ValidateFileExtension`, `ImportExcelDataStream → GetToFilterText`)
- [Codeunit 8618 "Config. Excel Exchange"](../codeunit/8618.md) (2 calls: `ExportExcelTemplateByFileName → ExportExcel`, `ExportExcelTemplateByFileName → SetHideDialog`)
- [Page 1807 "Data Migration Settings"](../page/1807.md) (2 calls: `OpenSettings → (object)`, `ValidateSettings → (object)`)
- [Codeunit 10 "Type Helper"](../codeunit/10.md) (1 call: `GetInstructions → CRLFSeparator`)
- [Codeunit 1812 "Data Migration Del G/L Account"](../codeunit/1812.md) (1 call: `RemoveDemoData → (object)`)
- [Codeunit 43 "Language"](../codeunit/43.md) (1 call: `CreatePackageMetadata → GetDefaultApplicationLanguageId`)
- [Codeunit 9015 "Application System Constants"](../codeunit/9015.md) (1 call: `CreatePackageMetadata → ApplicationVersion`)
- [Page 8614 "Config. Package Card"](../page/8614.md) (1 call: `OpenAdvancedApply → (object)`)
- [Page 8616 "Config. Package Errors"](../page/8616.md) (1 call: `ShowErrors → (object)`)

## Across versions

- Present in: BC23-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "codeunit", object_name: "Excel Data Migrator")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.