Codeunit 1200 Import Bank Statement
src/Layers/W1/BaseApp/Bank/Statement/ImportBankStatement.Codeunit.al143 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Bank.Statement;using System;using System.IO;using System.Xml;/// <summary>/// Handles the import and parsing of bank statement files in XML format through the data exchange framework./// Processes XML bank statement files and converts them into structured data exchange records./// </summary>/// <remarks>/// Parses XML bank statement files according to configured data exchange definitions./// Creates data exchange field records for further processing by bank statement import workflows./// Integrates with Data Exchange Framework for standardized file processing and error handling./// </remarks>codeunit 1200 "Import Bank Statement"{ Permissions = TableData "Data Exch. Field" = rimd; TableNo = "Data Exch."; trigger OnRun() var DataExchLineDef: Record "Data Exch. Line Def"; XMLDOMManagement: Codeunit "XML DOM Management"; XmlNode: DotNet XmlNode; XMLStream: InStream; LineNo: Integer; begin Rec."File Content".CreateInStream(XMLStream); XMLDOMManagement.LoadXMLNodeFromInStream(XMLStream, XmlNode); DataExchLineDef.Get(Rec."Data Exch. Def Code", Rec."Data Exch. Line Def Code"); ProgressWindow.Open(ProgressMsg); Parse(DataExchLineDef, Rec."Entry No.", XmlNode, '', '', LineNo, LineNo); ProgressWindow.Close(); OnRunOnAfterRun(Rec); end; var#pragma warning disable AA0470 ProgressMsg: Label 'Preparing line number #1#######';#pragma warning restore AA0470 ProgressWindow: Dialog; local procedure Parse(DataExchLineDef: Record "Data Exch. Line Def"; EntryNo: Integer; XMLNode: DotNet XmlNode; ParentPath: Text; NodeId: Text[250]; var LastGivenLineNo: Integer; CurrentLineNo: Integer) var CurrentDataExchLineDef: Record "Data Exch. Line Def"; XMLAttributeCollection: DotNet XmlAttributeCollection; XMLNodeList: DotNet XmlNodeList; XMLNodeType: DotNet XmlNodeType; i: Integer; begin CurrentDataExchLineDef.SetRange("Data Line Tag", ParentPath + '/' + XMLNode.LocalName); CurrentDataExchLineDef.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code"); if CurrentDataExchLineDef.FindFirst() then begin DataExchLineDef := CurrentDataExchLineDef; LastGivenLineNo += 1; CurrentLineNo := LastGivenLineNo; DataExchLineDef.ValidateNamespace(XMLNode); end; if XMLNode.NodeType.Equals(XMLNodeType.Text) or XMLNode.NodeType.Equals(XMLNodeType.CDATA) then InsertColumn(ParentPath, CurrentLineNo, NodeId, XMLNode.Value, XMLNode.ParentNode.Name, DataExchLineDef, EntryNo); if not IsNull(XMLNode.Attributes) then begin XMLAttributeCollection := XMLNode.Attributes; for i := 1 to XMLAttributeCollection.Count do InsertColumn(ParentPath + '/' + XMLNode.LocalName + '[@' + XMLAttributeCollection.Item(i - 1).Name + ']', CurrentLineNo, NodeId, XMLAttributeCollection.Item(i - 1).Value, XMLAttributeCollection.Item(i - 1).Name, DataExchLineDef, EntryNo); end; if XMLNode.HasChildNodes then begin XMLNodeList := XMLNode.ChildNodes; for i := 1 to XMLNodeList.Count do Parse(DataExchLineDef, EntryNo, XMLNodeList.Item(i - 1), ParentPath + '/' + XMLNode.LocalName, NodeId + Format(i, 0, '<Integer,4><Filler Char,0>'), LastGivenLineNo, CurrentLineNo); end; end; local procedure InsertColumn(Path: Text; LineNo: Integer; NodeId: Text[250]; Value: Text; Name: Text; var DataExchLineDef: Record "Data Exch. Line Def"; EntryNo: Integer) var DataExchColumnDef: Record "Data Exch. Column Def"; DataExchField: Record "Data Exch. Field"; IsHandled: Boolean; begin IsHandled := false; OnBeforeInsertColumn(DataExchLineDef, EntryNo, LineNo, NodeId, Name, ProgressWindow, IsHandled, Path, Value); if IsHandled then exit; // Note: The Data Exch. variable is passed by reference only to improve performance. DataExchColumnDef.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code"); DataExchColumnDef.SetRange("Data Exch. Line Def Code", DataExchLineDef.Code); DataExchColumnDef.SetRange(Path, Path); if DataExchColumnDef.FindFirst() then begin ProgressWindow.Update(1, LineNo); if DataExchColumnDef."Use Node Name as Value" then DataExchField.InsertRecXMLField(EntryNo, LineNo, DataExchColumnDef."Column No.", NodeId, Name, DataExchLineDef.Code) else DataExchField.InsertRecXMLField(EntryNo, LineNo, DataExchColumnDef."Column No.", NodeId, Value, DataExchLineDef.Code); end; end; /// <summary> /// Integration event raised after completing the bank statement import run. /// </summary> /// <param name="DataExch">The data exchange record that was processed.</param> [IntegrationEvent(false, false)] local procedure OnRunOnAfterRun(var DataExch: Record "Data Exch.") begin end; /// <summary> /// Integration event raised before inserting a column during bank statement import processing. /// Allows custom handling of column data before insertion into data exchange fields. /// </summary> /// <param name="DataExchLineDef">The data exchange line definition being processed.</param> /// <param name="EntryNo">The entry number of the data exchange record.</param> /// <param name="LineNo">The line number being processed.</param> /// <param name="NodeId">The XML node identifier.</param> /// <param name="Name">The column name.</param> /// <param name="ProgressWindow">The progress dialog window.</param> /// <param name="IsHandled">Set to true to skip the default column insertion processing.</param> /// <param name="Path">The XML path to the data.</param> /// <param name="Value">The column value to be inserted.</param> [IntegrationEvent(false, false)] local procedure OnBeforeInsertColumn(var DataExchLineDef: Record "Data Exch. Line Def"; EntryNo: Integer; LineNo: Integer; NodeId: Text[250]; Name: Text; var ProgressWindow: Dialog; var IsHandled: Boolean; Path: Text; Value: Text) begin end;}