Table 1220 Data Exch.

Base Application, System.IO

src/Layers/W1/BaseApp/System/DataExchange/DataExch.Table.al200 lines, Copyright (c) Microsoft Corporation. MIT

namespace System.IO;using Microsoft.EServices.EDocument;using System.Utilities;table 1220 "Data Exch."{    Caption = 'Data Exch.';    Permissions = TableData "Data Exch." = ri,                  TableData "Data Exch. Field" = rimd;    ReplicateData = false;    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        field(2; "File Name"; Text[250])        {            Caption = 'File Name';        }        field(3; "File Content"; BLOB)        {            Caption = 'File Content';        }        field(4; "Data Exch. Def Code"; Code[20])        {            Caption = 'Data Exch. Def Code';            TableRelation = "Data Exch. Def";        }        field(5; "Data Exch. Line Def Code"; Code[20])        {            Caption = 'Data Exch. Line Def Code';            TableRelation = "Data Exch. Line Def".Code where("Data Exch. Def Code" = field("Data Exch. Def Code"));        }        field(6; "Table Filters"; BLOB)        {            Caption = 'Table Filters';        }        field(10; "Incoming Entry No."; Integer)        {            Caption = 'Incoming Entry No.';            TableRelation = "Incoming Document";        }        field(11; "Related Record"; RecordID)        {            Caption = 'Related Record';            DataClassification = CustomerContent;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "Data Exch. Def Code")        {        }    }    fieldgroups    {    }    trigger OnDelete()    var        DataExchField: Record "Data Exch. Field";    begin        DataExchField.SetRange("Data Exch. No.", "Entry No.");        DataExchField.DeleteAll();    end;    var        ProgressWindowMsg: Label 'Please wait while the operation is being completed.';        TxtExtTok: Label '.txt', Locked = true;        XmlExtTok: Label '.xml', Locked = true;        JsonExtTok: Label '.json', Locked = true;    procedure InsertRec(FileName: Text[250]; var FileContent: InStream; DataExchDefCode: Code[20])    var        DataExchLineDef: Record "Data Exch. Line Def";        OutStream: OutStream;    begin        Init();        Validate("File Name", FileName);        "File Content".CreateOutStream(OutStream);        CopyStream(OutStream, FileContent);        Validate("Data Exch. Def Code", DataExchDefCode);        DataExchLineDef.SetRange("Data Exch. Def Code", DataExchDefCode);        if DataExchLineDef.FindFirst() then            Validate("Data Exch. Line Def Code", DataExchLineDef.Code);        Insert();    end;    procedure ImportFileContent(DataExchDef: Record "Data Exch. Def"): Boolean    var        DataExchLineDef: Record "Data Exch. Line Def";        RelatedRecord: RecordID;    begin        RelatedRecord := "Related Record";        DataExchLineDef.SetRange("Data Exch. Def Code", DataExchDef.Code);        if DataExchLineDef.FindFirst() then;        Init();        "Data Exch. Def Code" := DataExchDef.Code;        "Data Exch. Line Def Code" := DataExchLineDef.Code;        "Related Record" := RelatedRecord;        DataExchDef.TestField("Ext. Data Handling Codeunit");        CODEUNIT.Run(DataExchDef."Ext. Data Handling Codeunit", Rec);        if not "File Content".HasValue() then            exit(false);        Insert();        exit(true);    end;    procedure ImportToDataExch(DataExchDef: Record "Data Exch. Def"): Boolean    var        Source: InStream;        ProgressWindow: Dialog;    begin        if not "File Content".HasValue() then            if not ImportFileContent(DataExchDef) then                exit(false);        ProgressWindow.Open(ProgressWindowMsg);        "File Content".CreateInStream(Source);        SetRange("Entry No.", "Entry No.");        if DataExchDef."Reading/Writing Codeunit" > 0 then            CODEUNIT.Run(DataExchDef."Reading/Writing Codeunit", Rec)        else begin            DataExchDef.TestField("Reading/Writing XMLport");            XMLPORT.Import(DataExchDef."Reading/Writing XMLport", Source, Rec);        end;        ProgressWindow.Close();        exit(true);    end;    procedure ExportFromDataExch(DataExchMapping: Record "Data Exch. Mapping")    var        DataExchDef: Record "Data Exch. Def";    begin        DataExchMapping.TestField("Mapping Codeunit");        DataExchDef.Get("Data Exch. Def Code");        DataExchDef.TestField("Reading/Writing Codeunit");        DataExchDef.TestField("Ext. Data Handling Codeunit");        if DataExchMapping."Pre-Mapping Codeunit" > 0 then            CODEUNIT.Run(DataExchMapping."Pre-Mapping Codeunit", Rec);        CODEUNIT.Run(DataExchMapping."Mapping Codeunit", Rec);        if DataExchMapping."Post-Mapping Codeunit" > 0 then            CODEUNIT.Run(DataExchMapping."Post-Mapping Codeunit", Rec);        CODEUNIT.Run(DataExchDef."Reading/Writing Codeunit", Rec);        CODEUNIT.Run(DataExchDef."Ext. Data Handling Codeunit", Rec);        if DataExchDef."User Feedback Codeunit" > 0 then            CODEUNIT.Run(DataExchDef."User Feedback Codeunit", Rec);    end;    procedure GetFileExtension(): Text    var        DataExchDef: Record "Data Exch. Def";    begin        DataExchDef.Get("Data Exch. Def Code");        case DataExchDef."File Type" of            DataExchDef."File Type"::Xml:                exit(XmlExtTok);            DataExchDef."File Type"::Json:                exit(JsonExtTok);            else                exit(TxtExtTok);        end;    end;    procedure SetFileContentFromBlob(TempBlob: Codeunit "Temp Blob")    var        RecordRef: RecordRef;    begin        RecordRef.GetTable(Rec);        TempBlob.ToRecordRef(RecordRef, FieldNo("File Content"));        RecordRef.SetTable(Rec);    end;}