How to create xml from excel....(xml schema)

Discussion in 'Free Source Codes' started by Jenny, Nov 14, 2022.

    
  1. Jenny

    Jenny Active Member


    I create a xml schema for generate xml from excel but not export xml...
    Anyone can help me please...

    Code:
    <ENVELOPE>
    <HEADER>
    <VERSION></VERSION>
    <TALLYREQUEST></TALLYREQUEST>
    <TYPE></TYPE>
    <ID></ID>
    </HEADER>
    <BODY>
    <DESC>
    </DESC>
    <DATA>
    <TALLYMESSAGE>
    <VOUCHER DATE="" COSTCENTRENAME="" TAGNAME="" TAGVALUE="" VCHTYPE="" ACTION="" REMOTEID="">
    <DATE></DATE>
    <NARRATION></NARRATION>
    <VOUCHERTYPENAME></VOUCHERTYPENAME>
    <VOUCHERNUMBER></VOUCHERNUMBER>
    <REFERENCE></REFERENCE>
    <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME></LEDGERNAME>
    <COSTCENTRENAME></COSTCENTRENAME>
    <ISDEEMEDPOSITIVE></ISDEEMEDPOSITIVE>
    <AMOUNT></AMOUNT>
    <BILLALLOCATIONS.LIST>
    <NAME></NAME>
    <BILLTYPE></BILLTYPE>
    <AMOUNT></AMOUNT>
    </BILLALLOCATIONS.LIST>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME></LEDGERNAME>
    <ISDEEMEDPOSITIVE></ISDEEMEDPOSITIVE>
    <AMOUNT></AMOUNT>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME></LEDGERNAME>
    <ISDEEMEDPOSITIVE></ISDEEMEDPOSITIVE>
    <AMOUNT></AMOUNT>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME></LEDGERNAME>
    <ISDEEMEDPOSITIVE></ISDEEMEDPOSITIVE>
    <AMOUNT></AMOUNT>
    </ALLLEDGERENTRIES.LIST>
    <ALLLEDGERENTRIES.LIST>
    <LEDGERNAME></LEDGERNAME>
    <ISDEEMEDPOSITIVE></ISDEEMEDPOSITIVE>
    <AMOUNT></AMOUNT>
    </ALLLEDGERENTRIES.LIST></VOUCHER>
    </TALLYMESSAGE>
    </DATA>
    </BODY>
    </ENVELOPE>
    
     


  2. Sai Vineeth

    Sai Vineeth Active Member


    I didn't understand what you actually want

    But

    If you want to get data from Tally (Export) use theses xmls - Masters and Vouchers export XMLS
    If you want to send data to Tally (Import) - Will be added after some time
     
    Last edited: Nov 15, 2022
    Jenny likes this.


  3. Jenny

    Jenny Active Member


    Actually i want to send data to tally..i already xml (purchase & purchase return) i want to add cost centre in that xml...so wwhen i import xml to excel and add costcentre after that xml not export. in excel showing some error...any idea for that
     


  4. Sai Vineeth

    Sai Vineeth Active Member


    I added voucher with cost center import xml
     


Share This Page