XmlPort 1220 Data Exch. Import - CSV
src/Layers/W1/BaseApp/System/DataExchange/DataExchImportCSV.XmlPort.al274 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.IO;using System.Reflection;xmlport 1220 "Data Exch. Import - CSV"{ Caption = 'Data Exch. Import - CSV'; Direction = Import; Format = VariableText; Permissions = TableData "Data Exch. Field" = rimd; TextEncoding = WINDOWS; UseRequestPage = false; schema { textelement(root) { MinOccurs = Zero; tableelement("Data Exch."; "Data Exch.") { AutoSave = false; XmlName = 'DataExchDocument'; textelement(col1) { MaxOccurs = Once; MinOccurs = Zero; XmlName = 'col1'; trigger OnAfterAssignVariable() begin ColumnNo := 1; CheckLineType(); InsertColumn(ColumnNo, col1); end; } textelement(colx) { MinOccurs = Zero; Unbound = true; XmlName = 'colx'; trigger OnAfterAssignVariable() begin ColumnNo += 1; InsertColumn(ColumnNo, colx); end; } trigger OnAfterInitRecord() begin FileLineNo += 1; end; trigger OnBeforeInsertRecord() begin ValidateHeaderTag(); end; } } } requestpage { layout { } actions { } } trigger OnPostXmlPort() var ErrorMessage: Text; begin if (not LastLineIsFooter and SkipLine) or HeaderWarning then begin ErrorMessage := LastLineIsHeaderErr; OnNoLinesFoundSetErrorMessage(ErrorMessage); Error(ErrorMessage); end; end; trigger OnPreXmlPort() begin InitializeGlobals(); end; var DataExchField: Record "Data Exch. Field"; DataExchEntryNo: Integer; ImportedLineNo: Integer; FileLineNo: Integer; HeaderLines: Integer; HeaderLineCount: Integer; ColumnNo: Integer; HeaderTag: Text; FooterTag: Text; SkipLine: Boolean; LastLineIsFooter: Boolean; HeaderWarning: Boolean; LineType: Option Unknown,Header,Footer,Data; CurrentLineType: Option; FullHeaderLine: Text; LastLineIsHeaderErr: Label 'The imported file contains unexpected formatting. One or more lines may be missing in the file.'; WrongHeaderErr: Label 'The imported file contains unexpected formatting. One or more headers are incorrect.'; DataExchLineDefCode: Code[20]; local procedure InitializeGlobals() var DataExchDef: Record "Data Exch. Def"; TypeHelper: Codeunit "Type Helper"; CRLF: Text[2]; begin DataExchEntryNo := "Data Exch.".GetRangeMin("Entry No."); "Data Exch.".Get(DataExchEntryNo); DataExchLineDefCode := "Data Exch."."Data Exch. Line Def Code"; DataExchDef.Get("Data Exch."."Data Exch. Def Code"); HeaderLines := DataExchDef."Header Lines"; ImportedLineNo := 0; FileLineNo := 0; HeaderTag := DataExchDef."Header Tag"; FooterTag := DataExchDef."Footer Tag"; HeaderLineCount := 0; CurrentLineType := LineType::Unknown; FullHeaderLine := ''; currXMLport.FieldSeparator(DataExchDef.ColumnSeparatorChar()); case DataExchDef."File Encoding" of DataExchDef."File Encoding"::"MS-DOS": currXMLport.TextEncoding(TEXTENCODING::MSDos); DataExchDef."File Encoding"::"UTF-8": currXMLport.TextEncoding(TEXTENCODING::UTF8); DataExchDef."File Encoding"::"UTF-16": currXMLport.TextEncoding(TEXTENCODING::UTF16); DataExchDef."File Encoding"::WINDOWS: currXMLport.TextEncoding(TEXTENCODING::Windows); end; CRLF := TypeHelper.CRLFSeparator(); case DataExchDef."Line Separator" of DataExchDef."Line Separator"::CR: currXMLport.RecordSeparator := CRLF[1]; DataExchDef."Line Separator"::LF: currXMLport.RecordSeparator := CRLF[2]; end; end; local procedure CheckLineType() begin IdentifyLineType(); ValidateNonDataLine(); TrackNonDataLines(); SkipLine := CurrentLineType <> LineType::Data; if not SkipLine then begin HeaderLineCount := 0; ImportedLineNo += 1; end; end; local procedure IdentifyLineType() begin case true of FileLineNo <= HeaderLines: CurrentLineType := LineType::Header; (HeaderTag <> '') and (StrLen(col1) <= HeaderTagLength()) and (StrPos(HeaderTag, col1) = 1): CurrentLineType := LineType::Header; (FooterTag <> '') and (StrLen(col1) <= FooterTagLength()) and (StrPos(FooterTag, col1) = 1): CurrentLineType := LineType::Footer; else CurrentLineType := LineType::Data; end; end; local procedure ValidateNonDataLine() var ErrorMessage: Text; begin if CurrentLineType = LineType::Header then if (HeaderTag <> '') and (StrLen(col1) <= HeaderTagLength()) and (StrPos(HeaderTag, col1) = 0) then begin ErrorMessage := WrongHeaderErr; OnInvalidHeaderSetErrorMessage(ErrorMessage); Error(ErrorMessage); end; end; local procedure TrackNonDataLines() begin case CurrentLineType of LineType::Header: begin HeaderLineCount += 1; if not HeaderWarning and (HeaderLines > 0) and (HeaderLineCount > HeaderLines) then HeaderWarning := true; end; LineType::Data: if (HeaderLines > 0) and (HeaderLineCount > 0) and (HeaderLineCount < HeaderLines) then HeaderWarning := true; LineType::Footer: LastLineIsFooter := true; end; end; local procedure HeaderTagLength(): Integer var DataExchDef: Record "Data Exch. Def"; begin exit(GetFieldLength(DATABASE::"Data Exch. Def", DataExchDef.FieldNo("Header Tag"))); end; local procedure FooterTagLength(): Integer var DataExchDef: Record "Data Exch. Def"; begin exit(GetFieldLength(DATABASE::"Data Exch. Def", DataExchDef.FieldNo("Footer Tag"))); end; local procedure GetFieldLength(TableNo: Integer; FieldNo: Integer): Integer var RecRef: RecordRef; FieldRef: FieldRef; begin RecRef.Open(TableNo); FieldRef := RecRef.Field(FieldNo); exit(FieldRef.Length); end; local procedure InsertColumn(columnNumber: Integer; var columnValue: Text) var savedColumnValue: Text; begin savedColumnValue := columnValue; columnValue := ''; if SkipLine then begin if (CurrentLineType = LineType::Header) and (HeaderTag <> '') then FullHeaderLine += savedColumnValue + ';'; exit; end; if savedColumnValue <> '' then begin DataExchField.Init(); DataExchField.Validate("Data Exch. No.", DataExchEntryNo); DataExchField.Validate("Line No.", ImportedLineNo); DataExchField.Validate("Column No.", columnNumber); DataExchField.Validate(Value, CopyStr(savedColumnValue, 1, MaxStrLen(DataExchField.Value))); DataExchField.Validate("Data Exch. Line Def Code", DataExchLineDefCode); DataExchField.Insert(true); end; end; local procedure ValidateHeaderTag() var ErrorMessage: Text; begin if SkipLine and (CurrentLineType = LineType::Header) and (HeaderTag <> '') then if StrPos(FullHeaderLine, HeaderTag) = 0 then begin ErrorMessage := WrongHeaderErr; OnInvalidHeaderSetErrorMessage(ErrorMessage); Error(ErrorMessage); end; end; [IntegrationEvent(false, false)] local procedure OnInvalidHeaderSetErrorMessage(var ErrorMessage: Text); begin end; [IntegrationEvent(false, false)] local procedure OnNoLinesFoundSetErrorMessage(var ErrorMessage: Text); begin end;}