Codeunit 1214 Map DataExch To Intermediate

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/MapDataExchToIntermediate.Codeunit.al148 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.Utilities;codeunit 1214 "Map DataExch To Intermediate"{    TableNo = "Data Exch.";    trigger OnRun()    begin        ProcessAllLinesColumnMapping(Rec);    end;    var        TempNameValueBuffer: Record "Name/Value Buffer" temporary;        TargetTableFieldDefinitionMustBeSpecifiedErr: Label 'You must specify a target table for the column definition.';    [Scope('OnPrem')]    procedure ProcessAllLinesColumnMapping(DataExch: Record "Data Exch.")    var        DataExchLineDef: Record "Data Exch. Line Def";    begin        // TempNameValueBuffer - used to "keep track" of node id - record No. relation for determining parent/child relation        TempNameValueBuffer.Reset();        TempNameValueBuffer.DeleteAll();        DataExchLineDef.SetRange("Data Exch. Def Code", DataExch."Data Exch. Def Code");        DataExchLineDef.SetRange("Parent Code", '');        if DataExchLineDef.FindSet() then            repeat                ProcessColumnMapping(DataExch, DataExchLineDef);            until DataExchLineDef.Next() = 0;    end;    local procedure ProcessColumnMapping(DataExch: Record "Data Exch."; DataExchLineDef: Record "Data Exch. Line Def")    var        DataExchField: Record "Data Exch. Field";        ChildDataExchLineDef: Record "Data Exch. Line Def";        CurrentLineNo: Integer;    begin        DataExchField.SetRange("Data Exch. No.", DataExch."Entry No.");        DataExchField.SetRange("Data Exch. Line Def Code", DataExchLineDef.Code);        if not DataExchField.FindSet() then            exit;        CurrentLineNo := -1;        repeat            InsertRecordDefinition(DataExchField, DataExchLineDef, CurrentLineNo);            InsertDataValues(DataExchField, DataExchLineDef, CurrentLineNo);        until DataExchField.Next() = 0;        // Process Child Line Definitions        ChildDataExchLineDef.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code");        ChildDataExchLineDef.SetRange("Parent Code", DataExchLineDef.Code);        if not ChildDataExchLineDef.FindSet() then            exit;        repeat            ProcessColumnMapping(DataExch, ChildDataExchLineDef);        until ChildDataExchLineDef.Next() = 0;    end;    local procedure InsertRecordDefinition(DataExchField: Record "Data Exch. Field"; DataExchLineDef: Record "Data Exch. Line Def"; var CurrentLineNo: Integer)    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";    begin        // Check if definition is already inserted        if CurrentLineNo = DataExchField."Line No." then            exit;        // Find the table definition we need to write to.        DataExchFieldMapping.SetRange("Data Exch. Def Code", DataExchLineDef."Data Exch. Def Code");        DataExchFieldMapping.SetRange("Data Exch. Line Def Code", DataExchLineDef.Code);        DataExchFieldMapping.SetRange("Table ID", DATABASE::"Intermediate Data Import");        DataExchFieldMapping.SetFilter("Column No.", '>0');        if DataExchFieldMapping.IsEmpty() then            Error(TargetTableFieldDefinitionMustBeSpecifiedErr);        CurrentLineNo := DataExchField."Line No.";        // Save Node ID / Line No relation        AddNodeIDLineNoPair(DataExchField."Node ID", CurrentLineNo);    end;    local procedure InsertDataValues(DataExchField: Record "Data Exch. Field"; DataExchLineDef: Record "Data Exch. Line Def"; LineNo: Integer)    var        DataExchFieldMapping: Record "Data Exch. Field Mapping";        IntermediateDataImport: Record "Intermediate Data Import";        TransformationRule: Record "Transformation Rule";        ParentLineNo: Integer;    begin        if DataExchField."Column No." < 1 then            exit;        // Skip if no mapping        if not DataExchFieldMapping.Get(             DataExchLineDef."Data Exch. Def Code", DataExchLineDef.Code,             DATABASE::"Intermediate Data Import", DataExchField."Column No.")        then            exit;        IntermediateDataImport.Init();        IntermediateDataImport.Validate("Data Exch. No.", DataExchField."Data Exch. No.");        IntermediateDataImport.Validate("Table ID", DataExchFieldMapping."Target Table ID");        IntermediateDataImport.Validate("Record No.", LineNo);        IntermediateDataImport.Validate("Field ID", DataExchFieldMapping."Target Field ID");        if TransformationRule.Get(DataExchFieldMapping."Transformation Rule") then            IntermediateDataImport.SetValueWithoutModifying(TransformationRule.TransformText(DataExchField.GetValue()))        else            IntermediateDataImport.SetValueWithoutModifying(DataExchField.GetValue());        IntermediateDataImport.Validate("Validate Only", DataExchFieldMapping.Optional);        if DataExchField."Parent Node ID" <> '' then begin            TempNameValueBuffer.SetRange(Name, DataExchField."Parent Node ID");            TempNameValueBuffer.FindFirst();            Evaluate(ParentLineNo, TempNameValueBuffer.Value);            IntermediateDataImport.Validate("Parent Record No.", ParentLineNo);        end;        OnBeforeIntermediateDataImportInsert(DataExchField, DataExchLineDef, TempNameValueBuffer, IntermediateDataImport);        IntermediateDataImport.Insert(true);    end;    local procedure AddNodeIDLineNoPair(NodeID: Text[250]; LineNo: Integer)    var        ID: Integer;    begin        TempNameValueBuffer.Reset();        ID := 1;        if TempNameValueBuffer.FindLast() then            ID := TempNameValueBuffer.ID + 1;        Clear(TempNameValueBuffer);        TempNameValueBuffer.ID := ID;        TempNameValueBuffer.Name := NodeID;        TempNameValueBuffer.Value := Format(LineNo);        TempNameValueBuffer.Insert(true);    end;    [IntegrationEvent(false, false)]    local procedure OnBeforeIntermediateDataImportInsert(DataExchField: Record "Data Exch. Field"; DataExchLineDef: Record "Data Exch. Line Def"; var TempNameValueBuffer: Record "Name/Value Buffer" temporary; var IntermediateDataImport: Record "Intermediate Data Import")    begin    end;}