Post
Ask Question
Yogesh Sharma

Yogesh Sharma

  • NA
  • 144
  • 44.6k

Export SQL Server Table Data to Tally XML Formats Using C#

Feb 20 2016 2:08 AM
Dear all friends,
 
Can i export sql server table data to tally xml format....
 
Tally XML Format look like as below :
 
<ENVELOPE>
<HEADER>
<TALLYREQUEST>Import Data</TALLYREQUEST>
</HEADER>
<BODY>
<IMPORTDATA>
<REQUESTDESC>
<REPORTNAME>All Masters</REPORTNAME>
<STATICVARIABLES>
<SVCURRENTCOMPANY>SIDDHARTH ENTERPRISES - (from 1-Apr-2015)</SVCURRENTCOMPANY>
</STATICVARIABLES>
</REQUESTDESC>
<REQUESTDATA>
<TALLYMESSAGE xmlns:UDF="TallyUDF">
<VOUCHER REMOTEID="7f6c050d-c06b-43ec-9eba-32265570ef0a-00002f2f" VCHKEY="7f6c050d-c06b-43ec-9eba-32265570ef0a-0000a4ab:00000050" VCHTYPE="Sales Order" ACTION="Create" OBJVIEW="Invoice Voucher View">
<ADDRESS.LIST TYPE="String">
<ADDRESS>RAJMOHALL</ADDRESS>
<ADDRESS>INDORE</ADDRESS>
</ADDRESS.LIST>
<BASICBUYERADDRESS.LIST TYPE="String">
<BASICBUYERADDRESS>RAJMOHALL</BASICBUYERADDRESS>
<BASICBUYERADDRESS>INDORE</BASICBUYERADDRESS>
</BASICBUYERADDRESS.LIST>
<OLDAUDITENTRYIDS.LIST TYPE="Number">
<OLDAUDITENTRYIDS>-1</OLDAUDITENTRYIDS>
</OLDAUDITENTRYIDS.LIST>
<DATE>20150601</DATE>
<PARTYNAME>SACHIV KRISH UPAJ MANDI SAMITEE</PARTYNAME>
<VOUCHERTYPENAME>Sales Order</VOUCHERTYPENAME>
<VOUCHERNUMBER>1</VOUCHERNUMBER>
<REFERENCE>1</REFERENCE>
<ISOPTIONAL>Yes</ISOPTIONAL>
<LEDGERENTRIES.LIST>
<LEDGERNAME>SACHIV KRISH UPAJ MANDI SAMITEE</LEDGERNAME>
<ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE>
<ISPARTYLEDGER>Yes</ISPARTYLEDGER>
<ISLASTDEEMEDPOSITIVE>Yes</ISLASTDEEMEDPOSITIVE>
<AMOUNT>-24.00</AMOUNT>
</LEDGERENTRIES.LIST>
<ALLINVENTORYENTRIES.LIST>
<STOCKITEMNAME>PF=CCWS-0020-01-DW</STOCKITEMNAME>
<ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE>
<RATE>2.00/NOS</RATE>
<AMOUNT>24.00</AMOUNT>
<ACTUALQTY> 12 NOS</ACTUALQTY>
<BILLEDQTY> 12 NOS</BILLEDQTY>
<BATCHALLOCATIONS.LIST>
<ORDERNO>1</ORDERNO>
<TRACKINGNUMBER/>
<AMOUNT>24.00</AMOUNT>
<ACTUALQTY> 12 NOS</ACTUALQTY>
<BILLEDQTY> 12 NOS</BILLEDQTY>
<ORDERDUEDATE>31-Mar-2016</ORDERDUEDATE>
</BATCHALLOCATIONS.LIST>
<ACCOUNTINGALLOCATIONS.LIST>
<LEDGERNAME>Sales</LEDGERNAME>
<AMOUNT>24.00</AMOUNT>
</ACCOUNTINGALLOCATIONS.LIST>
</ALLINVENTORYENTRIES.LIST>
</VOUCHER>
</TALLYMESSAGE>
<TALLYMESSAGE xmlns:UDF="TallyUDF">
</TALLYMESSAGE>
</REQUESTDATA>
</IMPORTDATA>
</BODY>
</ENVELOPE>
  
So, any one can suggest me how can i handle this type of task...
 
 

Answers (3)