1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Is it possible to "wrap" the repeating fields inside a custom xml tag like <RECORDS>?

Discussion in 'Tally Integration' started by Azad, Nov 12, 2020.

    
Tags:
  1. Azad

    Azad New Member


    Hello friends,

    Code:
    <ENVELOPE>

    <HEADER>
        <VERSION>1</VERSION>
        <TALLYREQUEST>Export</TALLYREQUEST>
        <TYPE>Data</TYPE>
        <ID>TT Trial Balance</ID>
    </HEADER>
    <BODY>
        <DESC>
            <STATICVARIABLES>
                <EXPLODEFLAG>Yes</EXPLODEFLAG>
                <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
                <SVFROMDATE>01/04/2019</SVFROMDATE>
                <SVTODATE>31/03/2020</SVTODATE>
            </STATICVARIABLES>
            <TDL>
                <TDLMESSAGE>
                    <REPORT NAME="TT Trial Balance" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
                        <FORMS>Simple Trial balance</FORMS>
                    </REPORT>
                    <FORM NAME="Simple Trial balance">
                        <TOPPARTS>Simple TB Part</TOPPARTS>
                        <HEIGHT>100% Page</HEIGHT>
                        <WIDTH>100% Page</WIDTH>
                    </FORM>
                    <PART NAME="Simple TB Part">
                        <TOPLINES>Simple TB Title,Simple TB Details</TOPLINES>
                        <REPEAT>Simple TB Details : Simple TB Ledgers </REPEAT>
                        <SCROLLED>Vertical</SCROLLED>
                        <COMMONBORDERS>Yes</COMMONBORDERS>
                    </PART>
                    <LINE NAME="Simple TB Title">
                        <USE>Simple TB Details</USE>
                        <LOCAL>Field : Default : Type : String </LOCAL>
                        <LOCAL>Field : Default : Align : Centre </LOCAL>
                        <LOCAL>Field : Simple TB Name Field : Set as: "Particulars" </LOCAL>
                        <LOCAL>Field : Simple TB Amount Field: Set as: "Amount" </LOCAL>
                        <BORDER>Flush Totals</BORDER>
                    </LINE>
                    <LINE NAME="Simple TB Details">
                        <LEFTFIELDS>Simple TB Name Field</LEFTFIELDS>
                        <RIGHTFIELDS>Simple TB Amount Field</RIGHTFIELDS>
                    </LINE>
                    <FIELD NAME="Simple TB Name Field">
                        <USE>Name Field</USE>
                        <SET>$Name</SET>
                    </FIELD>
                    <FIELD NAME="Simple TB Amount Field">
                        <USE>Amount Field</USE>
                        <SET>$ClosingBalance</SET>
                        <BORDER>Thin Left</BORDER>
                    </FIELD>
                    <COLLECTION NAME="Simple TB Ledgers">
                        <TYPE>Ledger</TYPE>
                    </COLLECTION>
                </TDLMESSAGE>
            </TDL>
        </DESC>
    </BODY>
</ENVELOPE>
    The above code will give the following result
    Code:
    <ENVELOPE>
<SIMPLETBNAMEFIELD>ADVANCE OTHERS</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>-10.00</SIMPLETBAMOUNTFIELD>
<SIMPLETBNAMEFIELD>Audit Fee</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>10000.00</SIMPLETBAMOUNTFIELD>
<SIMPLETBNAMEFIELD>Audit Fee Payable</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>10000.00</SIMPLETBAMOUNTFIELD>
<SIMPLETBNAMEFIELD>BANK CHARGES</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>-1568.39</SIMPLETBAMOUNTFIELD>
<SIMPLETBNAMEFIELD>BOOKS &amp; PERIODICALS</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>-9489.43</SIMPLETBAMOUNTFIELD>
<SIMPLETBNAMEFIELD>BUSINESS PROMOTION</SIMPLETBNAMEFIELD>
<SIMPLETBAMOUNTFIELD>2000.00</SIMPLETBAMOUNTFIELD>
</ENVELOPE>
    Is it possible to "wrap" the repeating fields inside a custom xml tag like <RECORDS>? The desired output should look like

    Code:
    <ENVELOPE>
<RECORD>
    <SIMPLETBNAMEFIELD>ADVANCE OTHERS</SIMPLETBNAMEFIELD
    <SIMPLETBAMOUNTFIELD>-10.00</SIMPLETBAMOUNTFIELD>
</RECORD>
<RECORD>
   <SIMPLETBNAMEFIELD>Audit Fee</SIMPLETBNAMEFIELD>
   <SIMPLETBAMOUNTFIELD>10000.00</SIMPLETBAMOUNTFIELD>
</RECORD>
<RECORD>
   <SIMPLETBNAMEFIELD>Audit Fee Payable</SIMPLETBNAMEFIELD>
   <SIMPLETBAMOUNTFIELD>10000.00</SIMPLETBAMOUNTFIELD>
</RECORD>
<RECORD>
   <SIMPLETBNAMEFIELD>BANK CHARGES</SIMPLETBNAMEFIELD>
   <SIMPLETBAMOUNTFIELD>-1568.39</SIMPLETBAMOUNTFIELD>
</RECORD>
<RECORD>
   <SIMPLETBNAMEFIELD>BOOKS &amp; PERIODICALS</SIMPLETBNAMEFIELD>
   <SIMPLETBAMOUNTFIELD>-9489.43</SIMPLETBAMOUNTFIELD>
</RECORD>
<RECORD>
   <SIMPLETBNAMEFIELD>BUSINESS PROMOTION</SIMPLETBNAMEFIELD>
   <SIMPLETBAMOUNTFIELD>2000.00</SIMPLETBAMOUNTFIELD>
</RECORD>
</ENVELOPE>

    Thanks and Regards,
    Azad
     
    Azad, Nov 12, 2020
    #1


  2. Himanshu-2002

    Himanshu-2002 Active Member


    Yes, By adding Xml tag to the line... We can achieve this
     
    Himanshu-2002, Nov 13, 2020
    #2


  3. Azad

    Azad New Member


    Thanks for the reply.

    Can you be little more elaborate please? I am getting an error which says "TDL Error" No FIELDS or LINES

    I tried the following

    <LINE NAME="Simple TB Details">
    <RECORD>
    <LEFTFIELDS>Simple TB Name Field</LEFTFIELDS>
    <RIGHTFIELDS>Simple TB Amount Field</RIGHTFIELDS>
    </RECORD>
    </LINE>
     
    Azad, Nov 13, 2020
    #3


  4. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Try with Singular...rather than Plural.
     
    Amit Kamdar, Nov 13, 2020
    #4


  5. Azad

    Azad New Member


    Sorry, I didn't get you properly. Is it possible to get a sample code or something
     
    Azad, Nov 13, 2020
    #5


  6. Himanshu-2002

    Himanshu-2002 Active Member


    I means to say that Modify the Line Name in Tally and add XML tag to it

    Example:
    [Line: Example Line ]
    XML Tag : "My New Tag "
     
    Himanshu-2002, Nov 13, 2020
    #6


  7. Azad

    Azad New Member


    Thank you very much Himanshu.

    The code I used is as follows

    Code:
    <LINE NAME="Simple TB Details">
      <XMLTag>RECORD</XMLTag>
      <LEFTFIELDS>Simple TB Name Field</LEFTFIELDS>
      <RIGHTFIELDS>Simple TB Amount Field</RIGHTFIELDS>
</LINE>
     
    Azad, Nov 13, 2020
    #7


Share This Page