XML & PHP integartion

Discussion in 'Free Source Codes' started by Muhaimin Sheik, Nov 4, 2019.

    
  1. Muhaimin Sheik

    Muhaimin Sheik New Member


    Hello admin and TDL devs. I'm using php integration in tally. I got lot of data. I post sample Code for get Stock inventory items.

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <REPORTNAME>stock category summary</REPORTNAME>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>

    But, i want to all party ledger name lists in the xml format. Is there any way ? Please help me some one.
    Check the below code what i tried to get ledger list

    <ENVELOPE>
    <HEADER>
    <TALLYREQUEST>Export Data</TALLYREQUEST>
    </HEADER>
    <BODY>
    <EXPORTDATA>
    <REQUESTDESC>
    <STATICVARIABLES>
    <!--Specify the FROM DATE here-->
    <SVFROMDATE>20191001</SVFROMDATE>
    <!--Specify the TO DATE here-->
    <SVTODATE>20200331</SVTODATE>
    <SVEXPORTFORMAT>\$\$SysName:XML</SVEXPORTFORMAT>
    <!--Specify the LedgerName here-->
    <LEDGERNAME>CASH</LEDGERNAME>
    </STATICVARIABLES>
    <!--Report Name-->
    <REPORTNAME>List of Ledgers</REPORTNAME>
    </REQUESTDESC>
    </EXPORTDATA>
    </BODY>
    </ENVELOPE>


    Thanks in advance.
     


  2. teja varma

    teja varma Active Member


    to retrieve all ledger:
    Code:
    
    
    
    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>Export</TALLYREQUEST>
    <TYPE>Collection</TYPE>
    <ID>List of Ledgers</ID>
         </HEADER>
        <BODY>
            <DESC>
    <STATICVARIABLES>
    </STATICVARIABLES>
            </DESC>
        </BODY>
    </ENVELOPE>
     


  3. Muhaimin Sheik

    Muhaimin Sheik New Member


    First i would like to thank you for the answering my quesion @teja varma. I was tried couple of days and then posted my query here. Before your answering i got the solution already.Check the below code it's also will give same data. Sharing is caring...! Thanks..!

    <ENVELOPE>
    <HEADER>
    <VERSION>1</VERSION>
    <TALLYREQUEST>EXPORT</TALLYREQUEST>
    <TYPE>COLLECTION</TYPE>
    <ID>Remote Ledger Coll</ID>
    </HEADER>
    <BODY>
    <DESC>
    <STATICVARIABLES>
    <SVEXPORTFORMAT>$$SysName:XML</SVEXPORTFORMAT>
    </STATICVARIABLES>
    <TDL>
    <TDLMESSAGE>
    <COLLECTION NAME="Remote Ledger Coll" ISINITIALIZE="Yes">
    <TYPE>Ledger</TYPE>
    <NATIVEMETHOD>Name</NATIVEMETHOD>
    <NATIVEMETHOD></NATIVEMETHOD>
    </COLLECTION>
    </TDLMESSAGE>
    </TDL>
    </DESC>
    </BODY>
    </ENVELOPE>
     


Share This Page