1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

ODBC connectivity period wise data extraction

Discussion in 'Tally Developer' started by girish nair, Jan 31, 2014.

    
  1. girish nair

    girish nair New Member


    Has anybody faced this issue. Extracting data from tally for a particular period thru ODBC. for e.g all ledger balances from jan-june period. Kindly advice.
     
    girish nair, Jan 31, 2014
    #1


  2. Maulik Patel

    Maulik Patel Active Member


    By XML Request?
     
    Maulik Patel, Jan 31, 2014
    #2


  3. girish nair

    girish nair New Member


    Tried but the formatting is not proper.
     
    girish nair, Jan 31, 2014
    #3


  4. Maulik Patel

    Maulik Patel Active Member


    Mr. Girish Nair,
    You can try this xml. It will give you ledger details for creditors with specified date period.


    Code:
    <ENVELOPE>
  <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Simple Trial balance</ID>
  </HEADER>
  <BODY>
    <DESC>
      <STATICVARIABLES>
        <EXPLODEFLAG>Yes</EXPLODEFLAG>
        <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
        <SVFROMDATE TYPE="Date">01-Apr-2013</SVFROMDATE>
        <SVTODATE TYPE="Date">31-Mar-2014</SVTODATE>
      </STATICVARIABLES>
      <TDL>
        <TDLMESSAGE>
          <REPORT NAME="Simple Trial balance">
            <FORMS>Simple Trial balance</FORMS>
            <TITLE>"Trial Balance"</TITLE>
          </REPORT>
          <FORM NAME="Simple Trial balance">
            <TOPPARTS>Simple TB Part</TOPPARTS>
          </FORM>
          <PART NAME="Simple TB Part">
            <TOPLINES>Simple TB Details</TOPLINES>
            <REPEAT>Simple TB Details : Simple TB Ledgers</REPEAT>
            <SCROLLED>Vertical</SCROLLED>
            <COMMONBORDERS>Yes</COMMONBORDERS>
          </PART>
          <LINE NAME="Simple TB Details">
            <FIELDS>Name</FIELDS>
            <Fields>ClosingBalance</Fields>
          </LINE>
          <FIELD NAME="Name">
            <USE>Name Field</USE>
            <SET>$Name</SET>
          </FIELD>
          <FIELD NAME="CLOSINGBALANCE">
            <USE>Amount DrCr Title Field</USE>
            <SET>$ClosingBalance</SET>
          </FIELD>
          <COLLECTION NAME="Simple TB Ledgers">
            <TYPE>Ledger</TYPE>
            <SORT>Default : $Name</SORT>
            <ChildOf>$$GroupSundryCreditors</ChildOf>
            <BelongsTo>yes</BelongsTo>
          </COLLECTION>
        </TDLMESSAGE>
      </TDL>
    </DESC>
  </BODY>
</ENVELOPE>
     
    Maulik Patel, Jan 31, 2014
    #4


Share This Page