Codeunit 9610 XSD Parser
src/Layers/W1/BaseApp/System/XML/XSDParser.Codeunit.al1,079 lines, Copyright (c) Microsoft Corporation. MIT
namespace System.Xml;using Microsoft.Bank.Statement;using System;using System.IO;codeunit 9610 "XSD Parser"{ trigger OnRun() begin end; var TempAllXMLSchemaElement: Record "XML Schema Element" temporary; TempStackXMLSchemaElement: Record "XML Schema Element" temporary; TempXMLSchemaRestriction: Record "XML Schema Restriction" temporary; XMLDOMManagement: Codeunit "XML DOM Management"; CouldNotFindAllSchemasMsg: Label 'Some required schemas are missing.\\Load the schemas one by one to include the required schemas.'; GenerateDefinitionAgainQst: Label 'Do you want to generate the XML schema elements again?'; OverrideExistingDataExchangeDefQst: Label 'A data exchange definition already exists. Do you want to replace the existing data exchange definition?'; SEPACAMTDataLineTagTok: Label '/Document/BkToCstmrStmt/Stmt/Ntry', Locked = true; ReferenceElementTypeTok: Label 'Reference', Locked = true; ExtensionElementTypeTok: Label 'Extension', Locked = true; CouldNotFindRelatedSchema: Boolean; [Scope('OnPrem')] procedure LoadSchema(var XMLSchema: Record "XML Schema") begin if XMLSchema.Indentation = 0 then GenerateMainSchemaDefinition(XMLSchema) else LoadDependentSchemaSeparately(XMLSchema); end; local procedure GenerateMainSchemaDefinition(var XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; DefinitionXMLSchema: Record "XML Schema"; NamespaceMgr: DotNet XmlNamespaceManager; "Schema": DotNet XmlDocument; SchemaPrefix: Text; CurrentID: Integer; begin LoadSchemaXML(XMLSchema, NamespaceMgr, Schema, SchemaPrefix); DefinitionXMLSchema.Copy(XMLSchema); DefinitionXMLSchema.Code := StrSubstNo('%1:1000', XMLSchema.Code); DefinitionXMLSchema.Indentation := 1; DefinitionXMLSchema.Insert(); ParseSchemaReferences(NamespaceMgr, XMLSchema, Schema, SchemaPrefix); CurrentID := 1; Clear(XMLSchemaElement); ParseChildXMLNodes(Schema.DocumentElement, SchemaPrefix, XMLSchemaElement, DefinitionXMLSchema, NamespaceMgr, 0, CurrentID); InitializeTempBuffers(XMLSchema); ExpandDefinitions(XMLSchema); UpdateXMLSchemaElementProperties(XMLSchema); if CouldNotFindRelatedSchema then Message(CouldNotFindAllSchemasMsg) end; local procedure LoadSchemaXML(var XMLSchema: Record "XML Schema"; var NamespaceMgr: DotNet XmlNamespaceManager; var "Schema": DotNet XmlDocument; var SchemaPrefix: Text) var InStr: InStream; begin XMLSchema.TestField(Code); XMLSchema.CalcFields(XSD); XMLSchema.TestField(XSD); XMLSchema.XSD.CreateInStream(InStr); XMLDOMManagement.LoadXMLDocumentFromInStream(InStr, Schema); NamespaceMgr := NamespaceMgr.XmlNamespaceManager(Schema.XmlDocument().NameTable); PopulateNamespaceManager(NamespaceMgr, Schema.DocumentElement, XMLSchema."Target Namespace", SchemaPrefix); UpdateTargetNamespaceAliases(XMLSchema, NamespaceMgr); end; procedure ExtendSelectedElement(var XMLSchemaElement: Record "XML Schema Element") var ChildXMLSchemaElement: Record "XML Schema Element"; TempCurrentXMLSchemaElement: Record "XML Schema Element" temporary; LastXMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema"; CurrentID: Integer; SchemaPrefix: Text; begin if (XMLSchemaElement."Defintion XML Schema Code" = '') or (XMLSchemaElement."Definition XML Schema ID" = 0) then exit; XMLSchema.Get(XMLSchemaElement."XML Schema Code"); InitializeTempBuffers(XMLSchema); TempAllXMLSchemaElement.SetRange("XML Schema Code", XMLSchemaElement."Defintion XML Schema Code"); TempAllXMLSchemaElement.SetRange(ID, XMLSchemaElement."Definition XML Schema ID"); TempAllXMLSchemaElement.FindFirst(); TempCurrentXMLSchemaElement.Copy(TempAllXMLSchemaElement); TempCurrentXMLSchemaElement.Insert(); SchemaPrefix := ''; LastXMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); LastXMLSchemaElement.FindLast(); CurrentID := LastXMLSchemaElement.ID + 1; ExtendElementDefinitionType(TempCurrentXMLSchemaElement, XMLSchemaElement, 0, XMLSchema, CurrentID, SchemaPrefix); ChildXMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); ChildXMLSchemaElement.SetRange("Parent ID", XMLSchemaElement.ID); if ChildXMLSchemaElement.FindSet() then repeat UpdateSelectedProperty(ChildXMLSchemaElement, XMLSchemaElement."Sort Key", XMLSchema); until ChildXMLSchemaElement.Next() = 0; XMLSchemaElement."Defintion XML Schema Code" := ''; XMLSchemaElement."Definition XML Schema ID" := 0; XMLSchemaElement.Modify(); end; local procedure LoadDependentSchemaDefinition(var XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; NamespaceMgr: DotNet XmlNamespaceManager; "Schema": DotNet XmlDocument; SchemaPrefix: Text; CurrentID: Integer; begin LoadSchemaXML(XMLSchema, NamespaceMgr, Schema, SchemaPrefix); ParseSchemaReferences(NamespaceMgr, XMLSchema, Schema, SchemaPrefix); CurrentID := 1; Clear(XMLSchemaElement); ParseChildXMLNodes(Schema.DocumentElement, SchemaPrefix, XMLSchemaElement, XMLSchema, NamespaceMgr, 0, CurrentID); end; local procedure ExpandDefinitions(XMLSchema: Record "XML Schema") var TempRootXMLSchemaElement: Record "XML Schema Element" temporary; ParentXMLSchemaElement: Record "XML Schema Element"; CurrentID: Integer; begin TempRootXMLSchemaElement.Copy(TempAllXMLSchemaElement, true); TempRootXMLSchemaElement.SetRange("Parent ID", 0); TempRootXMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); TempRootXMLSchemaElement.SetRange("Node Type", TempRootXMLSchemaElement."Node Type"::Element); CurrentID := 1; if not TempRootXMLSchemaElement.FindSet() then exit; repeat Clear(ParentXMLSchemaElement); ParentXMLSchemaElement.Indentation := -1; ExtendElementDefinition(TempRootXMLSchemaElement, ParentXMLSchemaElement, 0, XMLSchema, CurrentID, ''); until TempRootXMLSchemaElement.Next() = 0; end; local procedure ImportFile(var CurrentXMLSchema: Record "XML Schema"; FilePath: Text): Boolean var OutStream: OutStream; InStream: InStream; File: File; begin if not File.Open(FilePath) then exit(false); File.CreateInStream(InStream); CurrentXMLSchema.XSD.CreateOutStream(OutStream); CopyStream(OutStream, InStream); exit(true); end; local procedure PopulateNamespaceManager(var NamespaceMgr: DotNet XmlNamespaceManager; XmlNode: DotNet XmlNode; var TargetNamespace: Text; var SchemaPrefix: Text) var Attribute: DotNet XmlAttribute; Prefix: Text; begin if not IsNull(XmlNode) then foreach Attribute in XmlNode.Attributes do begin if StrPos(Attribute.Name, 'xmlns') = 1 then if StrPos(Attribute.Name, ':') > 0 then begin Prefix := CopyStr(Attribute.Name, StrPos(Attribute.Name, ':') + 1); NamespaceMgr.AddNamespace(Prefix, Attribute.Value); if Attribute.Value = 'http://www.w3.org/2001/XMLSchema' then SchemaPrefix := Prefix; end else if Attribute.Value = 'http://www.w3.org/2001/XMLSchema' then begin SchemaPrefix := 'unamedXSDSchemaNamespace'; NamespaceMgr.AddNamespace(SchemaPrefix, Attribute.Value); end; if StrPos(Attribute.Name, 'targetNamespace') = 1 then TargetNamespace := CopyStr(Attribute.Value, 1, MaxStrLen(TargetNamespace)); end; end; local procedure UpdateTargetNamespaceAliases(var XMLSchema: Record "XML Schema"; NamespaceMgr: DotNet XmlNamespaceManager) var Prefix: Text; begin foreach Prefix in NamespaceMgr do begin if NamespaceMgr.LookupNamespace(Prefix) = XMLSchema."Target Namespace" then if XMLSchema."Target Namespace Aliases" = '' then XMLSchema."Target Namespace Aliases" := CopyStr(Prefix, 1, MaxStrLen(XMLSchema."Target Namespace Aliases")) else XMLSchema."Target Namespace Aliases" += CopyStr(' ' + Prefix, 1, MaxStrLen(XMLSchema."Target Namespace Aliases")); XMLSchema.Modify(); end; end; local procedure ParseSchemaReferences(NamespaceMgr: DotNet XmlNamespaceManager; XMLSchema: Record "XML Schema"; "Schema": DotNet XmlDocument; SchemaPrefix: Text) begin ParseSchemaReferenceDefinition(StrSubstNo('./%1:include', SchemaPrefix), NamespaceMgr, XMLSchema, Schema); ParseSchemaReferenceDefinition(StrSubstNo('./%1:import', SchemaPrefix), NamespaceMgr, XMLSchema, Schema); end; local procedure ParseSchemaReferenceDefinition(XPath: Text; NamespaceMgr: DotNet XmlNamespaceManager; XMLSchema: Record "XML Schema"; "Schema": DotNet XmlDocument) var ImportXMLSchema: Record "XML Schema"; ExistingXMLSchema: Record "XML Schema"; LastXMLSchema: Record "XML Schema"; ReferencedXMLSchema: Record "Referenced XML Schema"; FileManagement: Codeunit "File Management"; XmlNodeList: DotNet XmlNodeList; XmlNode: DotNet XmlNode; SchemaLocation: Text; DefinitionFileFound: Boolean; NameSpacePrefix: Text; TopElementCode: Text; begin if not XMLDOMManagement.FindNodesWithNamespaceManager(Schema.DocumentElement, XPath, NamespaceMgr, XmlNodeList) then exit; foreach XmlNode in XmlNodeList do begin SchemaLocation := GetSchemaLocation(XmlNode, XMLSchema); TopElementCode := XMLSchema.GetTopSchemaCode(XMLSchema); ExistingXMLSchema.SetRange(Path, SchemaLocation); ExistingXMLSchema.SetFilter(Code, StrSubstNo('%1*', TopElementCode)); if not ExistingXMLSchema.FindFirst() then begin ImportXMLSchema.Init(); ImportXMLSchema.Path := CopyStr(SchemaLocation, 1, MaxStrLen(ImportXMLSchema.Path)); ImportXMLSchema."Target Namespace" := GetAttribute('namespace', XmlNode); // Include takes parents root namespace if (ImportXMLSchema."Target Namespace" = '') and (StrPos(XPath, 'include') > 0) then ImportXMLSchema."Target Namespace" := XMLSchema."Target Namespace"; LastXMLSchema.SetFilter(Code, StrSubstNo('%1:*', TopElementCode)); LastXMLSchema.FindLast(); ImportXMLSchema.Code := IncStr(LastXMLSchema.Code); ImportXMLSchema.Indentation := 2; ImportXMLSchema.Description := CopyStr(FileManagement.GetFileName(SchemaLocation), 1, MaxStrLen(ImportXMLSchema.Description)); DefinitionFileFound := ImportFile(ImportXMLSchema, SchemaLocation); ImportXMLSchema.Insert(); if DefinitionFileFound then LoadDependentSchemaDefinition(ImportXMLSchema) else CouldNotFindRelatedSchema := true; end else ImportXMLSchema := ExistingXMLSchema; NameSpacePrefix := NamespaceMgr.LookupPrefix(ImportXMLSchema."Target Namespace"); ReferencedXMLSchema.Init(); ReferencedXMLSchema.Code := XMLSchema.Code; ReferencedXMLSchema."Referenced Schema Code" := ImportXMLSchema.Code; ReferencedXMLSchema."Referenced Schema Namespace" := CopyStr(NameSpacePrefix, 1, MaxStrLen(ReferencedXMLSchema."Referenced Schema Namespace")); if ReferencedXMLSchema.Insert(true) then; end; end; local procedure ParseChildXMLNodes(CurrentXMLNode: DotNet XmlNode; SchemaPrefix: Text; var ParentXMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema"; NamespaceMgr: DotNet XmlNamespaceManager; NestingLevel: Integer; var CurrentID: Integer) var XMLNode: DotNet XmlNode; ListOfElements: DotNet GenericList1; begin if CurrentXMLNode.HasChildNodes then begin ListOfElements := ListOfElements.List(); foreach XMLNode in CurrentXMLNode.ChildNodes() do if XMLNode.Name = StrSubstNo('%1:attribute', SchemaPrefix) then ParseXMLNode(XMLNode, SchemaPrefix, ParentXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel, CurrentID) else ListOfElements.Add(XMLNode); foreach XMLNode in ListOfElements do ParseXMLNode(XMLNode, SchemaPrefix, ParentXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel, CurrentID); end; end; local procedure ParseXMLNode(CurrentXMLNode: DotNet XmlNode; SchemaPrefix: Text; var ParentXMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema"; NamespaceMgr: DotNet XmlNamespaceManager; NestingLevel: Integer; var CurrentID: Integer) var LastXMLSchemaElement: Record "XML Schema Element"; XMLNodeType: DotNet XmlNodeType; begin if CurrentXMLNode.NodeType.Equals(XMLNodeType.Element) then case CurrentXMLNode.Name of StrSubstNo('%1:element', SchemaPrefix), StrSubstNo('%1:group', SchemaPrefix), StrSubstNo('%1:extension', SchemaPrefix): begin InsertElementDefinition( LastXMLSchemaElement, CurrentXMLNode, ParentXMLSchemaElement.ID, XMLSchema, SchemaPrefix, CurrentID); ParseChildXMLNodes(CurrentXMLNode, SchemaPrefix, LastXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel + 1, CurrentID); end; StrSubstNo('%1:attribute', SchemaPrefix): begin InsertAttributeDefinition( LastXMLSchemaElement, CurrentXMLNode, ParentXMLSchemaElement.ID, XMLSchema, CurrentID); ParseChildXMLNodes(CurrentXMLNode, SchemaPrefix, LastXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel + 1, CurrentID); end; StrSubstNo('%1:complexType', SchemaPrefix), StrSubstNo('%1:simpleType', SchemaPrefix): if NestingLevel = 0 then begin InsertElementDefinition( LastXMLSchemaElement, CurrentXMLNode, ParentXMLSchemaElement.ID, XMLSchema, SchemaPrefix, CurrentID); ParseChildXMLNodes(CurrentXMLNode, SchemaPrefix, LastXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel + 1, CurrentID); end else ParseChildXMLNodes(CurrentXMLNode, SchemaPrefix, ParentXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel + 1, CurrentID); StrSubstNo('%1:restriction', SchemaPrefix): ParseRestrictions(CurrentXMLNode, ParentXMLSchemaElement, NamespaceMgr, XMLSchema, SchemaPrefix); StrSubstNo('%1:annotation', SchemaPrefix): exit; else ParseChildXMLNodes(CurrentXMLNode, SchemaPrefix, ParentXMLSchemaElement, XMLSchema, NamespaceMgr, NestingLevel + 1, CurrentID); end; end; local procedure ParseRestrictions(CurrentXmlNode: DotNet XmlNode; var TempXMLSchemaElement: Record "XML Schema Element" temporary; NamespaceMgr: DotNet XmlNamespaceManager; XMLSchema: Record "XML Schema"; SchemaPrefix: Text) var XMLSchemaRestriction: Record "XML Schema Restriction"; LastIndex: Integer; begin XMLSchemaRestriction.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaRestriction.SetRange("Element ID", TempXMLSchemaElement.ID); if XMLSchemaRestriction.FindLast() then LastIndex := XMLSchemaRestriction.ID + 1 else LastIndex := 1; XMLSchemaRestriction.Init(); XMLSchemaRestriction."XML Schema Code" := XMLSchema.Code; XMLSchemaRestriction."Element ID" := TempXMLSchemaElement.ID; XMLSchemaRestriction.ID := LastIndex; LastIndex += 1; XMLSchemaRestriction.Value := GetAttribute('base', CurrentXmlNode); XMLSchemaRestriction.Type := XMLSchemaRestriction.Type::Base; XMLSchemaRestriction.Insert(); ParseRestrictionDefinitions( TempXMLSchemaElement.ID, StrSubstNo('./%1:enumeration', SchemaPrefix), CurrentXmlNode, NamespaceMgr, XMLSchema, LastIndex); ParseRestrictionDefinitions( TempXMLSchemaElement.ID, StrSubstNo('./%1:pattern', SchemaPrefix), CurrentXmlNode, NamespaceMgr, XMLSchema, LastIndex); end; local procedure ParseRestrictionDefinitions(ID: Integer; XPath: Text; var CurrentXMLNode: DotNet XmlNode; NamespaceMgr: DotNet XmlNamespaceManager; XMLSchema: Record "XML Schema"; var LastIndex: Integer) var XMLSchemaRestriction: Record "XML Schema Restriction"; XMLNode: DotNet XmlNode; XMLNodeList: DotNet XmlNodeList; i: Integer; begin if not XMLDOMManagement.FindNodesWithNamespaceManager(CurrentXMLNode, XPath, NamespaceMgr, XMLNodeList) then exit; for i := 1 to XMLNodeList.Count do begin XMLNode := XMLNodeList.Item(i - 1); if not IsNull(XMLNode) then begin XMLSchemaRestriction.Init(); XMLSchemaRestriction."XML Schema Code" := XMLSchema.Code; XMLSchemaRestriction."Element ID" := ID; LastIndex += 1; XMLSchemaRestriction.ID := LastIndex; XMLSchemaRestriction.Type := XMLSchemaRestriction.Type::Value; XMLSchemaRestriction.Value := GetAttribute('name', XMLNode); if XMLSchemaRestriction.Value = '' then XMLSchemaRestriction.Value := GetAttribute('value', XMLNode); XMLSchemaRestriction.Insert(); end; end; end; local procedure ExtendElementDefinition(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var LastXMLSchemaElement: Record "XML Schema Element"; begin case CurrentDefinitionXMLSchemaElement."Node Type" of CurrentDefinitionXMLSchemaElement."Node Type"::Element, CurrentDefinitionXMLSchemaElement."Node Type"::Attribute: begin InsertXMLSchemaElementFromDefinition( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, LastXMLSchemaElement, XMLSchema, CurrentID, SchemaPrefix); InsertRestrictions(LastXMLSchemaElement, CurrentDefinitionXMLSchemaElement, XMLSchema); ExtendElementDefinitionType( CurrentDefinitionXMLSchemaElement, LastXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); end; CurrentDefinitionXMLSchemaElement."Node Type"::"Definition Node": begin InsertRestrictions(ParentXMLSchemaElement, CurrentDefinitionXMLSchemaElement, XMLSchema); ExtendElementDefinitionType( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); end; end; end; local procedure ExtendElementDefinitionType(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) begin if not ParentXMLSchemaElement.Selected then if DetectDefinitionLoop(CurrentDefinitionXMLSchemaElement) or (ParentXMLSchemaElement.MinOccurs = 0) then begin ParentXMLSchemaElement."Defintion XML Schema Code" := CurrentDefinitionXMLSchemaElement."XML Schema Code"; ParentXMLSchemaElement."Definition XML Schema ID" := CurrentDefinitionXMLSchemaElement.ID; ParentXMLSchemaElement.Modify(); exit; end; PushDefinitionOnStack(CurrentDefinitionXMLSchemaElement); case CurrentDefinitionXMLSchemaElement."Data Type" of '': ExtendNestedElementDefinition( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); ReferenceElementTypeTok: ExtendReferenceElementDefinition( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); ExtensionElementTypeTok: ExtendExtensionElementDefinition( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); else ExtendTypeElementDefinition( CurrentDefinitionXMLSchemaElement, ParentXMLSchemaElement, NestingLevel, XMLSchema, CurrentID, SchemaPrefix); end; PopDefinitionFromStack(CurrentDefinitionXMLSchemaElement); end; local procedure ExtendNestedElementDefinition(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var TempNextXMLSchemaElementDefintion: Record "XML Schema Element" temporary; begin if GetChildElementsForComplexType(CurrentDefinitionXMLSchemaElement, TempNextXMLSchemaElementDefintion) then repeat ExtendElementDefinition( TempNextXMLSchemaElementDefintion, ParentXMLSchemaElement, NestingLevel + 1, XMLSchema, CurrentID, SchemaPrefix); until TempNextXMLSchemaElementDefintion.Next() = 0; end; local procedure ExtendReferenceElementDefinition(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var TempNextXMLSchemaElementDefintion: Record "XML Schema Element" temporary; begin if GetReferencedElementDefinition(CurrentDefinitionXMLSchemaElement, TempNextXMLSchemaElementDefintion, SchemaPrefix) then ExtendElementDefinitionType( TempNextXMLSchemaElementDefintion, ParentXMLSchemaElement, NestingLevel + 1, XMLSchema, CurrentID, SchemaPrefix); end; local procedure ExtendExtensionElementDefinition(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var TempNextXMLSchemaElementDefintion: Record "XML Schema Element" temporary; NewSchemaPrefix: Text; begin if GetReferencedElementDefinition(CurrentDefinitionXMLSchemaElement, TempNextXMLSchemaElementDefintion, NewSchemaPrefix) then ExtendElementDefinition( TempNextXMLSchemaElementDefintion, ParentXMLSchemaElement, NestingLevel + 1, XMLSchema, CurrentID, NewSchemaPrefix) else UpdateSimpleType(ParentXMLSchemaElement, CurrentDefinitionXMLSchemaElement."Node Name"); if GetChildElementsForComplexType(CurrentDefinitionXMLSchemaElement, TempNextXMLSchemaElementDefintion) then repeat ExtendElementDefinition( TempNextXMLSchemaElementDefintion, ParentXMLSchemaElement, NestingLevel + 1, XMLSchema, CurrentID, SchemaPrefix); until TempNextXMLSchemaElementDefintion.Next() = 0; end; local procedure ExtendTypeElementDefinition(var CurrentDefinitionXMLSchemaElement: Record "XML Schema Element"; var ParentXMLSchemaElement: Record "XML Schema Element"; NestingLevel: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var TempNextXMLSchemaElementDefintion: Record "XML Schema Element" temporary; begin if GetTypeDefinition(CurrentDefinitionXMLSchemaElement, TempNextXMLSchemaElementDefintion) then repeat ExtendElementDefinition( TempNextXMLSchemaElementDefintion, ParentXMLSchemaElement, NestingLevel + 1, XMLSchema, CurrentID, SchemaPrefix); until TempNextXMLSchemaElementDefintion.Next() = 0 else UpdateSimpleType(ParentXMLSchemaElement, ParentXMLSchemaElement."Data Type"); end; local procedure UpdateSimpleType(var XMLSchemaElement: Record "XML Schema Element"; NewSimpleType: Text) begin if XMLSchemaElement."Simple Data Type" = '' then begin XMLSchemaElement.Validate("Simple Data Type", CopyStr(NewSimpleType, 1, MaxStrLen(XMLSchemaElement."Simple Data Type"))); XMLSchemaElement.Modify(true); end; end; local procedure InsertElementDefinition(var LastXMLSchemaElement: Record "XML Schema Element"; XmlNode: DotNet XmlNode; ParentID: Integer; XMLSchema: Record "XML Schema"; SchemaPrefix: Text; var CurrentID: Integer) var XMLSchemaElement: Record "XML Schema Element"; begin XMLSchemaElement.Init(); AssignKeyToXMLSchemaElement(XMLSchemaElement, XMLSchema, CurrentID); XMLSchemaElement."Node Name" := GetElementName(XmlNode); if XmlNode.Name = StrSubstNo('%1:element', SchemaPrefix) then XMLSchemaElement."Node Type" := XMLSchemaElement."Node Type"::Element else XMLSchemaElement."Node Type" := XMLSchemaElement."Node Type"::"Definition Node"; XMLSchemaElement."Data Type" := GetElementType(XmlNode); XMLSchemaElement."Parent ID" := ParentID; XMLSchemaElement.Choice := StrPos(XmlNode.Name, 'choice') > 0; SetMinAndMaxOccurs(XMLSchemaElement, XmlNode); XMLSchemaElement.Insert(); LastXMLSchemaElement := XMLSchemaElement; end; local procedure InsertAttributeDefinition(var LastXMLSchemaElement: Record "XML Schema Element"; XmlNode: DotNet XmlNode; ParentID: Integer; XMLSchema: Record "XML Schema"; var CurrentID: Integer) var XMLSchemaElement: Record "XML Schema Element"; begin XMLSchemaElement.Init(); AssignKeyToXMLSchemaElement(XMLSchemaElement, XMLSchema, CurrentID); XMLSchemaElement."Node Name" := GetElementName(XmlNode); XMLSchemaElement."Node Type" := XMLSchemaElement."Node Type"::Attribute; XMLSchemaElement."Data Type" := GetElementType(XmlNode); XMLSchemaElement."Parent ID" := ParentID; if GetAttribute('use', XmlNode) = 'required' then XMLSchemaElement.MinOccurs := 1; XMLSchemaElement.MaxOccurs := 1; XMLSchemaElement.Insert(); LastXMLSchemaElement := XMLSchemaElement; end; local procedure GetAttribute(AttributeName: Text; var XMLNode: DotNet XmlNode): Text[250] var XMLAttributeNode: DotNet XmlNode; begin XMLAttributeNode := XMLNode.Attributes.GetNamedItem(AttributeName); if IsNull(XMLAttributeNode) then exit(''); exit(CopyStr(Format(XMLAttributeNode.InnerText), 1, 250)); end; local procedure SetMinAndMaxOccurs(var XMLSchemaElement: Record "XML Schema Element"; XmlNode: DotNet XmlNode) begin if GetAttribute('minOccurs', XmlNode) <> '' then Evaluate(XMLSchemaElement.MinOccurs, GetAttribute('minOccurs', XmlNode)) else XMLSchemaElement.MinOccurs := 1; case GetAttribute('maxOccurs', XmlNode) of '': XMLSchemaElement.MaxOccurs := XMLSchemaElement.MinOccurs; 'unbounded': XMLSchemaElement.MaxOccurs := 999999999; else Evaluate(XMLSchemaElement.MaxOccurs, GetAttribute('maxOccurs', XmlNode)); end; end; local procedure UpdateXMLSchemaElementProperties(XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; begin XMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaElement.SetRange("Parent ID", 0); if XMLSchemaElement.FindSet() then repeat UpdateSelectedProperty(XMLSchemaElement, '', XMLSchema); until XMLSchemaElement.Next() = 0; end; local procedure UpdateSelectedProperty(var CurrentXMLSchemaElement: Record "XML Schema Element"; ParentSortKey: Text[250]; XMLSchema: Record "XML Schema") var ChildXMLSchemaElement: Record "XML Schema Element"; begin CurrentXMLSchemaElement."Sort Key" := StrSubstNo('%1 %2', ParentSortKey, Format(1000 + CurrentXMLSchemaElement.ID)); CurrentXMLSchemaElement.Modify(); if (CurrentXMLSchemaElement.MinOccurs > 0) and (CurrentXMLSchemaElement."Defintion XML Schema Code" = '') then begin CurrentXMLSchemaElement.Selected := true; CurrentXMLSchemaElement.Modify(); ChildXMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); ChildXMLSchemaElement.SetRange("Parent ID", CurrentXMLSchemaElement.ID); if ChildXMLSchemaElement.FindSet() then repeat UpdateSelectedProperty(ChildXMLSchemaElement, CurrentXMLSchemaElement."Sort Key", XMLSchema); until ChildXMLSchemaElement.Next() = 0; end; end; local procedure GetElementName(var XMLNode: DotNet XmlNode): Text[250] var ElementName: Text; begin ElementName := GetAttribute('name', XMLNode); if ElementName = '' then ElementName := GetAttribute('ref', XMLNode); if ElementName = '' then ElementName := GetAttribute('base', XMLNode); exit(ElementName); end; local procedure GetElementType(var XMLNode: DotNet XmlNode): Text[250] var ElementType: Text; begin ElementType := GetAttribute('type', XMLNode); if (ElementType = '') and (GetAttribute('ref', XMLNode) <> '') then ElementType := ReferenceElementTypeTok; if (ElementType = '') and (GetAttribute('base', XMLNode) <> '') then ElementType := ExtensionElementTypeTok; exit(ElementType); end; local procedure GetChildElementsForComplexType(DefinitionXMLSchemaElement: Record "XML Schema Element"; var ReferenceXMLSchemaElement: Record "XML Schema Element"): Boolean begin TempAllXMLSchemaElement.Reset(); // Get root definition TempAllXMLSchemaElement.SetRange("XML Schema Code", DefinitionXMLSchemaElement."XML Schema Code"); TempAllXMLSchemaElement.SetRange("Parent ID", DefinitionXMLSchemaElement.ID); if not TempAllXMLSchemaElement.FindSet() then exit(false); repeat ReferenceXMLSchemaElement.Copy(TempAllXMLSchemaElement); ReferenceXMLSchemaElement.Insert(); until TempAllXMLSchemaElement.Next() = 0; ReferenceXMLSchemaElement.FindFirst(); exit(true); end; local procedure GetReferencedElementDefinition(DefinitionXMLSchemaElement: Record "XML Schema Element"; var ReferenceXMLSchemaElement: Record "XML Schema Element"; var SchemaPrefix: Text): Boolean var XMLSchema: Record "XML Schema"; ReferencedXMLSchema: Record "Referenced XML Schema"; NameWithoutNamespace: Text; NamespaceLength: Integer; begin NamespaceLength := StrPos(DefinitionXMLSchemaElement."Node Name", ':'); if NamespaceLength > 0 then begin // Process Import Namespaces SchemaPrefix := CopyStr(DefinitionXMLSchemaElement."Node Name", 1, NamespaceLength - 1); NameWithoutNamespace := CopyStr(DefinitionXMLSchemaElement."Node Name", NamespaceLength + 1); XMLSchema.Get(DefinitionXMLSchemaElement."XML Schema Code"); if XMLSchema."Target Namespace Aliases" <> SchemaPrefix then begin ReferencedXMLSchema.SetRange("Referenced Schema Namespace", SchemaPrefix); ReferencedXMLSchema.SetRange(Code, DefinitionXMLSchemaElement."XML Schema Code"); if not ReferencedXMLSchema.FindSet() then exit(false); end else begin if not (SchemaPrefix = 'cac') then exit(false); TempAllXMLSchemaElement.Reset(); TempAllXMLSchemaElement.SetRange("XML Schema Code", DefinitionXMLSchemaElement."XML Schema Code"); TempAllXMLSchemaElement.SetRange("Parent ID", 0); TempAllXMLSchemaElement.SetRange("Node Name", NameWithoutNamespace); if TempAllXMLSchemaElement.FindFirst() then begin ReferenceXMLSchemaElement.Copy(TempAllXMLSchemaElement); ReferenceXMLSchemaElement.Insert(); exit(true); end; exit(false); end; end; if NamespaceLength = 0 then begin // Check part of the same schema if NameWithoutNamespace = '' then NameWithoutNamespace := DefinitionXMLSchemaElement."Node Name"; TempAllXMLSchemaElement.Reset(); TempAllXMLSchemaElement.SetRange("XML Schema Code", DefinitionXMLSchemaElement."XML Schema Code"); TempAllXMLSchemaElement.SetRange("Parent ID", 0); TempAllXMLSchemaElement.SetRange("Node Name", NameWithoutNamespace); if TempAllXMLSchemaElement.FindFirst() then begin ReferenceXMLSchemaElement.Copy(TempAllXMLSchemaElement); ReferenceXMLSchemaElement.Insert(); exit(true); end; // Process Include Statement ReferencedXMLSchema.SetRange(Code, DefinitionXMLSchemaElement."XML Schema Code"); ReferencedXMLSchema.SetRange("Referenced Schema Namespace", ''); if not ReferencedXMLSchema.FindSet() then exit(false); end; repeat TempAllXMLSchemaElement.Reset(); TempAllXMLSchemaElement.SetRange("XML Schema Code", ReferencedXMLSchema."Referenced Schema Code"); TempAllXMLSchemaElement.SetRange("Parent ID", 0); TempAllXMLSchemaElement.SetRange("Node Name", NameWithoutNamespace); if TempAllXMLSchemaElement.FindFirst() then begin ReferenceXMLSchemaElement.Copy(TempAllXMLSchemaElement); ReferenceXMLSchemaElement.Insert(); exit(true); end; until ReferencedXMLSchema.Next() = 0; exit(false); end; local procedure GetTypeDefinition(DefinitionXMLSchemaElement: Record "XML Schema Element"; var ReferenceXMLSchemaElement: Record "XML Schema Element"): Boolean begin TempAllXMLSchemaElement.Reset(); // Get Type Definition TempAllXMLSchemaElement.SetRange("XML Schema Code", DefinitionXMLSchemaElement."XML Schema Code"); TempAllXMLSchemaElement.SetRange("Parent ID", 0); TempAllXMLSchemaElement.SetRange("Node Name", DefinitionXMLSchemaElement."Data Type"); TempAllXMLSchemaElement.SetRange("Node Type", DefinitionXMLSchemaElement."Node Type"::"Definition Node"); if not TempAllXMLSchemaElement.FindFirst() then exit(false); ReferenceXMLSchemaElement.Init(); ReferenceXMLSchemaElement.Copy(TempAllXMLSchemaElement); ReferenceXMLSchemaElement.Insert(); exit(true); end; local procedure InsertRestrictions(var ActualXMLSchemaElement: Record "XML Schema Element"; DefinitionXMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema") var XMLSchemaRestriction: Record "XML Schema Restriction"; XMLSchemaRestriction2: Record "XML Schema Restriction"; LastRestrictionID: Integer; begin TempXMLSchemaRestriction.SetRange("XML Schema Code", XMLSchema.Code); TempXMLSchemaRestriction.SetRange("Element ID", DefinitionXMLSchemaElement.ID); TempXMLSchemaRestriction.SetRange(Type, TempXMLSchemaRestriction.Type::Base); if not TempXMLSchemaRestriction.FindFirst() then exit; ActualXMLSchemaElement.Validate( "Simple Data Type", CopyStr(TempXMLSchemaRestriction.Value, 1, MaxStrLen(ActualXMLSchemaElement."Simple Data Type"))); ActualXMLSchemaElement.Modify(); TempXMLSchemaRestriction.SetRange(Type, TempXMLSchemaRestriction.Type::Value); if not TempXMLSchemaRestriction.FindSet() then exit; XMLSchemaRestriction2.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaRestriction2.SetRange("Element ID", ActualXMLSchemaElement.ID); if XMLSchemaRestriction2.FindLast() then LastRestrictionID := XMLSchemaRestriction2.ID + 1 else LastRestrictionID := 1; repeat XMLSchemaRestriction.Init(); XMLSchemaRestriction.Copy(TempXMLSchemaRestriction); XMLSchemaRestriction.ID := LastRestrictionID; LastRestrictionID += 1; XMLSchemaRestriction."Element ID" := ActualXMLSchemaElement.ID; XMLSchemaRestriction.Insert(); until TempXMLSchemaRestriction.Next() = 0; end; local procedure InsertXMLSchemaElementFromDefinition(DefinitionXMLSchemaElement: Record "XML Schema Element"; ParentXMLSchemaElement: Record "XML Schema Element"; var XMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema"; var CurrentID: Integer; SchemaPrefix: Text) var PrefixLength: Integer; begin XMLSchemaElement.Copy(DefinitionXMLSchemaElement); AssignKeyToXMLSchemaElement(XMLSchemaElement, XMLSchema, CurrentID); XMLSchemaElement."Node Name" := DefinitionXMLSchemaElement."Node Name"; PrefixLength := StrPos(XMLSchemaElement."Node Name", ':'); if XMLSchemaElement."Node Type" = XMLSchemaElement."Node Type"::Element then if (SchemaPrefix <> '') and (PrefixLength = 0) then XMLSchemaElement."Node Name" := StrSubstNo('%1:%2', SchemaPrefix, XMLSchemaElement."Node Name"); XMLSchemaElement."Parent ID" := ParentXMLSchemaElement.ID; XMLSchemaElement.Indentation := ParentXMLSchemaElement.Indentation + 1; XMLSchemaElement.Insert(); end; local procedure AssignKeyToXMLSchemaElement(var XMLSchemaElement: Record "XML Schema Element"; XMLSchema: Record "XML Schema"; var CurrentID: Integer) begin XMLSchemaElement."XML Schema Code" := XMLSchema.Code; XMLSchemaElement.ID := CurrentID; CurrentID += 1; end; procedure ShowAll(var XMLSchemaElement: Record "XML Schema Element") begin XMLSchemaElement.ModifyAll(Visible, true); XMLSchemaElement.SetRange(Visible); XMLSchemaElement.SetRange(Selected); end; local procedure GetSchemaLocation(CurrentXmlNode: DotNet XmlNode; XMLSchema: Record "XML Schema"): Text var FileManagement: Codeunit "File Management"; SchemaLocation: Text; FilePath: Text; begin SchemaLocation := ConvertStr(GetAttribute('schemaLocation', CurrentXmlNode), '/', '\'); FilePath := FileManagement.CombinePath(FileManagement.GetDirectoryName(XMLSchema.Path), SchemaLocation); exit(FilePath); end; procedure SelectMandatory(XMLSchemaElement: Record "XML Schema Element") begin XMLSchemaElement.SetRange("XML Schema Code", XMLSchemaElement."XML Schema Code"); XMLSchemaElement.SetRange("Parent ID", 0); if XMLSchemaElement.FindFirst() then begin XMLSchemaElement.Validate(Selected, true); XMLSchemaElement.Modify(); end; end; procedure DeselectAll(var XMLSchemaElement: Record "XML Schema Element") begin XMLSchemaElement.ModifyAll(Selected, false); end; procedure HideNotMandatory(var XMLSchemaElement: Record "XML Schema Element") var xXMLSchemaElementID: Integer; LevelVisible: array[100] of Boolean; begin xXMLSchemaElementID := XMLSchemaElement.ID; XMLSchemaElement.SetCurrentKey("Sort Key"); LevelVisible[1] := true; if XMLSchemaElement.FindSet() then repeat XMLSchemaElement.Visible := (XMLSchemaElement.MinOccurs > 0); if XMLSchemaElement.Indentation > 0 then if not LevelVisible[XMLSchemaElement.Indentation] then XMLSchemaElement.Visible := false; LevelVisible[XMLSchemaElement.Indentation + 1] := XMLSchemaElement.Visible; XMLSchemaElement.Modify(); until XMLSchemaElement.Next() = 0; XMLSchemaElement.SetRange(Visible, true); if XMLSchemaElement.Get(XMLSchemaElement."XML Schema Code", xXMLSchemaElementID) then; end; procedure HideNotSelected(var XMLSchemaElement: Record "XML Schema Element") begin XMLSchemaElement.SetRange(Selected, true); end; local procedure LoadDependentSchemaSeparately(var XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; MainDocumentXMLSchema: Record "XML Schema"; NamespaceMgr: DotNet XmlNamespaceManager; "Schema": DotNet XmlDocument; SchemaPrefix: Text; CurrentID: Integer; begin LoadSchemaXML(XMLSchema, NamespaceMgr, Schema, SchemaPrefix); ParseSchemaReferences(NamespaceMgr, XMLSchema, Schema, SchemaPrefix); CurrentID := 1; Clear(XMLSchemaElement); ParseChildXMLNodes(Schema.DocumentElement, SchemaPrefix, XMLSchemaElement, XMLSchema, NamespaceMgr, 0, CurrentID); if not Confirm(GenerateDefinitionAgainQst) then exit; MainDocumentXMLSchema.Get(XMLSchema.GetTopSchemaCode(XMLSchema)); RemoveDefinitions(MainDocumentXMLSchema); InitializeTempBuffers(MainDocumentXMLSchema); ExpandDefinitions(MainDocumentXMLSchema); UpdateXMLSchemaElementProperties(MainDocumentXMLSchema); if CouldNotFindRelatedSchema then Message(CouldNotFindAllSchemasMsg) end; local procedure RemoveDefinitions(var XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; XMLSchemaRestriction: Record "XML Schema Restriction"; begin XMLSchemaRestriction.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaRestriction.DeleteAll(true); XMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaElement.DeleteAll(true); CouldNotFindRelatedSchema := false; TempStackXMLSchemaElement.Reset(); TempStackXMLSchemaElement.DeleteAll(); TempAllXMLSchemaElement.Reset(); TempXMLSchemaRestriction.Reset(); TempAllXMLSchemaElement.DeleteAll(); TempXMLSchemaRestriction.DeleteAll(); end; procedure CreateDataExchDefForCAMT(var XMLSchemaElement: Record "XML Schema Element") var XMLSchema: Record "XML Schema"; DataExchDef: Record "Data Exch. Def"; begin XMLSchema.Get(XMLSchemaElement."XML Schema Code"); if DataExchDef.Get(XMLSchema.Code) then begin if not Confirm(OverrideExistingDataExchangeDefQst) then exit; DataExchDef.Delete(true); end; DataExchDef.InsertRec(XMLSchema.Code, XMLSchema.Description, DataExchDef.Type::"Bank Statement Import", 0, 0, '', ''); DataExchDef."File Type" := DataExchDef."File Type"::Xml; DataExchDef."Reading/Writing Codeunit" := Codeunit::"Import Bank Statement"; DataExchDef.Modify(); CreateDataExchColumnDefinitions(XMLSchema, DataExchDef); Commit(); PAGE.RunModal(PAGE::"Data Exch Def Card", DataExchDef); end; procedure CreateDataExchColumnDefinitions(XMLSchema: Record "XML Schema"; DataExchDef: Record "Data Exch. Def") var DataExchColumnDef: Record "Data Exch. Column Def"; XMLSchemaElement: Record "XML Schema Element"; DataExchLineDef: Record "Data Exch. Line Def"; SchemaContext: Text; ColumnNo: Integer; FullPath: Text; ElementName: Text; begin XMLSchemaElement.SetRange("XML Schema Code", XMLSchema.Code); XMLSchemaElement.SetRange(Selected, true); XMLSchemaElement.FindSet(); DataExchLineDef.SetRange("Data Exch. Def Code", DataExchDef.Code); if not DataExchLineDef.FindFirst() then begin DataExchLineDef.InsertRec(DataExchDef.Code, DataExchDef.Code, DataExchDef.Name, 0); DataExchLineDef."Data Line Tag" := SEPACAMTDataLineTagTok; DataExchLineDef.Modify(); end; DataExchColumnDef.SetRange("Data Exch. Def Code", DataExchDef.Code); DataExchColumnDef.SetRange("Data Exch. Line Def Code", DataExchLineDef.Code); DataExchColumnDef.DeleteAll(true); SchemaContext := XMLSchema.GetSchemaContext(); repeat if XMLSchemaElement.IsLeaf() then begin ColumnNo += 1; FullPath := XMLSchemaElement.GetFullPath(); ElementName := FullPath; if StrPos(FullPath, SchemaContext) > 0 then ElementName := DelStr(FullPath, StrPos(FullPath, SchemaContext), StrLen(SchemaContext)); DataExchColumnDef.InsertRecordForImport( DataExchDef.Code, DataExchLineDef.Code, ColumnNo, CopyStr(ElementName, 1, MaxStrLen(DataExchColumnDef.Name)), CopyStr(XMLSchemaElement."Node Name", 1, MaxStrLen(DataExchColumnDef.Description)), true, DataExchColumnDef."Data Type"::Text, '', ''); DataExchColumnDef.SetXMLDataFormattingValues(XMLSchemaElement."Simple Data Type"); DataExchColumnDef.Path := CopyStr(FullPath, 1, MaxStrLen(DataExchColumnDef.Path)); DataExchColumnDef.Modify(); end; until XMLSchemaElement.Next() = 0; end; local procedure PushDefinitionOnStack(var TempDefinitionXMLSchemaElement: Record "XML Schema Element" temporary) var LastID: Integer; begin TempStackXMLSchemaElement.Reset(); TempStackXMLSchemaElement.SetCurrentKey(ID); if TempStackXMLSchemaElement.FindLast() then LastID := TempStackXMLSchemaElement.ID else LastID := 1; TempStackXMLSchemaElement.Copy(TempDefinitionXMLSchemaElement); TempStackXMLSchemaElement.ID := LastID + 1; TempStackXMLSchemaElement.Insert(); end; local procedure PopDefinitionFromStack(var TempCurrentDefinitionXMLSchemaElement: Record "XML Schema Element" temporary) begin TempStackXMLSchemaElement.Reset(); TempStackXMLSchemaElement.SetRange("XML Schema Code", TempCurrentDefinitionXMLSchemaElement."XML Schema Code"); TempStackXMLSchemaElement.SetRange("Node Name", TempCurrentDefinitionXMLSchemaElement."Node Name"); TempStackXMLSchemaElement.SetRange("Node Type", TempCurrentDefinitionXMLSchemaElement."Node Type"); TempStackXMLSchemaElement.SetRange("Data Type", TempCurrentDefinitionXMLSchemaElement."Data Type"); TempStackXMLSchemaElement.SetCurrentKey(ID); TempStackXMLSchemaElement.FindLast(); TempStackXMLSchemaElement.Delete(); end; local procedure DetectDefinitionLoop(var TempCurrentDefinitionXMLSchemaElement: Record "XML Schema Element" temporary): Boolean begin TempStackXMLSchemaElement.Reset(); TempStackXMLSchemaElement.SetRange("XML Schema Code", TempCurrentDefinitionXMLSchemaElement."XML Schema Code"); TempStackXMLSchemaElement.SetRange("Node Name", TempCurrentDefinitionXMLSchemaElement."Node Name"); TempStackXMLSchemaElement.SetRange("Node Type", TempCurrentDefinitionXMLSchemaElement."Node Type"); TempStackXMLSchemaElement.SetRange("Data Type", TempCurrentDefinitionXMLSchemaElement."Data Type"); exit(TempStackXMLSchemaElement.FindFirst()); end; local procedure InitializeTempBuffers(XMLSchema: Record "XML Schema") var XMLSchemaElement: Record "XML Schema Element"; XMLSchemaRestriction: Record "XML Schema Restriction"; MainDefinitionSchemaCode: Code[20]; begin MainDefinitionSchemaCode := StrSubstNo('%1:1000', XMLSchema.Code); TempAllXMLSchemaElement.Reset(); TempAllXMLSchemaElement.DeleteAll(); TempStackXMLSchemaElement.Reset(); TempStackXMLSchemaElement.DeleteAll(); XMLSchemaElement.SetFilter("XML Schema Code", StrSubstNo('%1:*', XMLSchema.Code)); if XMLSchemaElement.FindSet() then repeat TempAllXMLSchemaElement.Copy(XMLSchemaElement); if TempAllXMLSchemaElement."XML Schema Code" = MainDefinitionSchemaCode then TempAllXMLSchemaElement."XML Schema Code" := XMLSchema.Code; TempAllXMLSchemaElement.Insert(); until XMLSchemaElement.Next() = 0; TempXMLSchemaRestriction.Reset(); TempXMLSchemaRestriction.DeleteAll(); XMLSchemaRestriction.SetFilter("XML Schema Code", StrSubstNo('%1:*', XMLSchema.Code)); if XMLSchemaRestriction.FindSet() then repeat TempXMLSchemaRestriction.Copy(XMLSchemaRestriction); if TempXMLSchemaRestriction."XML Schema Code" = MainDefinitionSchemaCode then TempXMLSchemaRestriction."XML Schema Code" := XMLSchema.Code; TempXMLSchemaRestriction.Insert(); until XMLSchemaRestriction.Next() = 0; end;}