1. CLICK HERE TO JOIN WHATSAPP CHANNEL FOR TDL PROGRAMS

Passing Custom XML tags to export records from Tally

Discussion in 'Tally Developer' started by sriharisivaraj, Mar 20, 2014.

    
  1. sriharisivaraj

    sriharisivaraj New Member


    Hi,

    I have an XML which will fetch the required fields from tally ledgers.I have posted the xml below.
    Is there any way to pass an extra xml tag with my specific data,so that I could get the same data back in the response from tally.

    <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>
    <VARIABLE>
    EXPLODEFLAG,SVEXPORTFORMAT,SVCURRENTCOMPANY,SVFROMDATE,SVTODATE,LedgerName
    </VARIABLE>
    <SET>EXPLODEFLAG:Yes</SET>
    <SET>SVEXPORTFORMAT:$$SysName:XML</SET>
    </REPORT>
    <FORM NAME ="List of Ledgers">
    <PARTS>
    List of Ledgers
    </PARTS>
    <XMLTAG>"List of Ledgers"</XMLTAG>
    </FORM>
    <PART NAME="List of Ledgers">
    <LINES>List of Ledgers</LINES>
    <REPEAT>List of Ledgers : Collection of Ledgers</REPEAT>
    <SCROLLED>Vertical</SCROLLED>
    </PART>
    <LINE NAME="List of Ledgers">
    <XMLTAG>"Ledgers"</XMLTAG>
    <Fields>VLedgerName</Fields>
    <Fields>VParent</Fields>
    </LINE>
    <FIELD NAME="VLedgerName">
    <USE>Name Field</USE>
    <SET>$Name</SET>
    </FIELD>
    <FIELD NAME="VParent">
    <USE>Name Field</USE>
    <SET>$Parent</SET>
    </FIELD>
    <COLLECTION NAME="Collection of Ledgers" ISMODIFY="No" ISFIXED="No" ISINITIALIZE="No" ISOPTION="No" ISINTERNAL="No">
    <TYPE>Ledgers</TYPE>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     
    sriharisivaraj, Mar 20, 2014
    #1


  2. Sumesh

    Sumesh New Member


    SIR,
    when i am using this code(a slight changes in mine) i am getting the like "<RESPONSE>Unknown Request, cannot be processed</RESPONSE>".can u help me to solve this?pls...
     
    Sumesh, Feb 27, 2015
    #2


  3. sriharisivaraj

    sriharisivaraj New Member


    Hi Sumesh,

    The xml which I provided is working fine.
    What changes have you made?

    you can post your xml in this thread or you can reach me @ srihari.prince74@gmail.com
     
    sriharisivaraj, Feb 27, 2015
    #3


  4. Sumesh

    Sumesh New Member


    this is my XML

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Data</TYPE>
    <ID>Voucher Register</ID>
    </HEADER>
    <BODY>
    <DESC>

    <TDL>
    <TDLMESSAGE>
    <REPORT NAME=My Report
    <FORMS>My report<FORMS> <REPORT>
    <FORM NAME=My report>
    <PARTS>My Report<PARTS> <FORM>

    <PART NAME=My Report>
    <LINES>My Report<LINES>
    <REPEAT>My Report : My Report Collection<REPEAT>
    <SCROLLED>Vertical<SCROLLED>
    <PART>
    <LINE NAME=My Report>
    <Fields>UDate<Fields>
    <Fields>UVoucherTypeName<Fields>
    <Fields>UVoucherNumber<Fields>
    <LINE>
    <FIELD NAME=UDate >
    <USE>Date<USE>
    <SET>$Date<SET>
    <FIELD>

    <FIELD NAME=UVoucherNumber>
    <USE>Number<USE>
    <SET>$VoucherNumber<SET>
    <FIELD>

    <FIELD NAME=UVoucherNumber>
    <USE>AmountOf<USE>
    <SET>$Amount<SET>
    <FIELD>

    <COLLECTION NAME=My Report Collection ISMODIFY=No ISFIXED=No ISINITIALIZE=No ISOPTION=No ISINTERNAL=No>

    <TYPE>Vouchers : Ledger<TYPE>
    <CHILDOF>ABEL AUTO SPARES(IRINGOLE<CHILDOF>
    <FETCH>*, LedgerEntries.*<FETCH>
    <COLLECTION>
    <TDLMESSAGE>
    <TDL>
    <DESC>
    <BODY>
    <ENVELOPE>;
     
    Sumesh, Feb 28, 2015
    #4


Share This Page