XMLPORT export one record - two nodes

CenterDCenterD Member Posts: 37
edited 2013-06-11 in NAV Three Tier
Is it possibel to make 2 nodes from one record when exporting

Something like this:

Root element text <root>
pc1 element table <Post Code>(Post Code)
Code element field Post Code::Code
pc2 element table <Post Code>(Post Code)
City element field Post Code::City

The above wont compile.

Comments

  • [StaWho][StaWho] Member Posts: 3
    Hi

    Not if you have two nodes with the same name. Below compiles OK:
    OBJECT XMLport 50005 Test
    {
      OBJECT-PROPERTIES
      {
        Date=11/06/13;
        Time=10:33:04;
        Modified=Yes;
        Version List=;
      }
      PROPERTIES
      {
      }
      ELEMENTS
      {
        { [{5C5F560A-45A9-4044-9727-D07AC10588EE}];  ;Root                ;Element ;Text     }
    
        { [{FEAB65DD-4A7F-47ED-9A2D-6C7A59D403E5}];1 ;pc1                 ;Element ;Table   ;
                                                      VariableName=<Post Code1>;
                                                      SourceTable=Table225 }
    
        { [{0A576FFA-7481-42D1-9895-9509D13DBD99}];2 ;Code                ;Element ;Field   ;
                                                      DataType=Code;
                                                      SourceField=<Post Code1>::Code }
    
        { [{E5E03F68-BF8E-4615-B72F-92C6858F65EA}];1 ;pc2                 ;Element ;Table   ;
                                                      VariableName=<Post Code2>;
                                                      SourceTable=Table225 }
    
        { [{F916C363-5D39-4F48-89C7-A4152D03DF21}];2 ;City                ;Element ;Field   ;
                                                      DataType=Text;
                                                      SourceField=<Post Code2>::City }
    
      }
      EVENTS
      {
      }
      REQUESTPAGE
      {
        PROPERTIES
        {
        }
        CONTROLS
        {
        }
      }
      CODE
      {
    
        BEGIN
        END.
      }
    }
    
Sign In or Register to comment.