1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

How to fetch more than one column value using TDL reports

Discussion in 'Tally Integration' started by Noor Hussain Ladkhan, Oct 11, 2012.

    
  1. Noor Hussain Ladkhan

    Noor Hussain Ladkhan New Member


    Dear Experts,

    I am using the below TDL to fetch a list of Ledgers. But it is fetching only Ledger Name, I have added TDL code for fetching Parent Ledger also but I am not getting it in the response xml. For your reference the TDL which I am using is below. Please let me know where I am going wrong. Any help is greatly appreciated.
    Code:
    <ENVELOPE>
    <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>List of Ledgers</ID>
    </HEADER>
<BODY>
<DESC>
<TDL>
<TDLMESSAGE>
<REPORT NAME="List of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <FORMS>List of Ledgers</FORMS>
  </REPORT>
<FORM NAME="List of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <TOPPARTS>List of Ledgers</TOPPARTS>
  <XMLTAG>"List of Ledgers"</XMLTAG>
  </FORM>
<PART NAME="List of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <TOPLINES>List of Ledgers</TOPLINES>
  <REPEAT>List of Ledgers : Collection of Ledgers</REPEAT>
  <SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <LEFTFIELDS>List of Ledgers</LEFTFIELDS>
  </LINE>
<FIELD NAME="List of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <SET>$Name</SET>
  <XMLTAG>"NAME"</XMLTAG>
  </FIELD>
<PART NAME="List of Ledger" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
<TOPLINES>List of Ledger</TOPLINES>
<REPEAT>List of Ledger : Collection of Ledgers</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Ledger" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <LEFTFIELDS>List of Ledger</LEFTFIELDS>
  </LINE>
<FIELD NAME="List of Ledger" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <SET>$Parent</SET>
  <XMLTAG>"PARENTNAME"</XMLTAG>
  </FIELD>
 
<COLLECTION NAME="Collection of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
  <TYPE>Ledger</TYPE>
  </COLLECTION>
  </TDLMESSAGE>
  </TDL>
 
</DESC>
</BODY>
    And the corresponding response is as follows

    Code:
    <LISTOFLEDGERS>
<NAME>AKRUTI ENTEPRISES</NAME>
<NAME>Basic Excisable Duty</NAME>
<NAME>Cash</NAME>
<NAME>Cess</NAME>
<NAME>COSMOS INDUSTRIAL CORPORATION</NAME>
<NAME>Higher Secondary Cess</NAME>
<NAME>MAITREYA SALES</NAME>
<NAME>MEGA ENGINEERING PVT.LTD</NAME>
<NAME>M.VAT8%</NAME>
<NAME>My Supplier</NAME>
<NAME>Profit &amp; Loss A/c</NAME>
<NAME>Purchase</NAME>
<NAME>Sales</NAME>
<NAME>VASAV PRECISION ENGINEERING PVT.LTD</NAME>
</LISTOFLEDGERS>
    Thanks and Regards,
    Noor Hussain
     
    Noor Hussain Ladkhan, Oct 11, 2012
    #1


  2. Niraj Kumar

    Niraj Kumar New Member


    A little bit simplified version -

    Code:
    <ENVELOPE>
    <HEADER>
            <VERSION>1</VERSION>
            <TALLYREQUEST>Export</TALLYREQUEST>
            <TYPE>Data</TYPE>
            <ID>List of Ledgers</ID>
    </HEADER>
<BODY>
<DESC>
<TDL>
<TDLMESSAGE>
<REPORT NAME="List of Ledgers">
  <FORMS>List of Ledgers</FORMS>
  </REPORT>
<FORM NAME="List of Ledgers">
  <TOPPARTS>List of Ledgers</TOPPARTS>
  <XMLTAG>"List of Ledgers"</XMLTAG>
  </FORM>
<PART NAME="List of Ledgers">
  <TOPLINES>List of Ledgers</TOPLINES>
  <REPEAT>List of Ledgers : Collection of Ledgers</REPEAT>
  <SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Ledgers">
  <LEFTFIELDS>List of Ledgers</LEFTFIELDS>
  </LINE>
<FIELD NAME="List of Ledgers">
  <SET>$Name</SET>
  <XMLTAG>"NAME"</XMLTAG>
  </FIELD>
<PART NAME="List of Ledger">
<TOPLINES>List of Ledger</TOPLINES>
<REPEAT>List of Ledger : Collection of Ledgers</REPEAT>
<SCROLLED>Vertical</SCROLLED>
</PART>
<LINE NAME="List of Ledger">
  <LEFTFIELDS>List of Ledger</LEFTFIELDS>
  </LINE>
<FIELD NAME="List of Ledger">
  <SET>$Parent</SET>
  <XMLTAG>"PARENTNAME"</XMLTAG>
  </FIELD>
 
<COLLECTION NAME="Collection of Ledgers">
  <TYPE>Ledger</TYPE>
  </COLLECTION>
  </TDLMESSAGE>
  </TDL>
 
</DESC>
</BODY>
</ENVELOPE>
     
    Niraj Kumar, Feb 4, 2013
    #2


  3. Nakul Sargur

    Nakul Sargur New Member


    I am trying to fetch the ledger details from Tally.
    I want to get the response XML like below.
    Code:
    <LISTOFLEDGERS>
<LEDGERENTRY>
<NAME>Be Soft Drinker, Inc.</NAME>
<EMAIL-ID>info@gmail.com</EMAIL-ID>
<PARENT>Sundry Debtors</PARENT>
  </LEDGERENTRY>
  <LEDGERENTRY>
<NAME>Sleep Well hotels, Inc.</NAME>
<EMAIL-ID>info@sleepwell.com</EMAIL-ID>
<PARENT>Sundry Debtors</PARENT>
  </LEDGERENTRY>
</LISTOFLEDGERS>
    That is i want to enclose each iteration of collection data inside a parent tag so that it is easy to read the XMl from DOM parser. Pls let me know how can i do this
     
    Nakul Sargur, Jul 27, 2013
    #3


Share This Page