Home / Products / DX-Fusion / Tally ERP 9 into SQL Server

Tally ERP 9 to SQL Server




Preface


This document is for Software developers who wish to get data from Tally ERP 9 into their database using VB6, VB.NET, C# or any other programming language.

The sample program provided underneath is written in VB6. It uses the free utility DX-Fusion to get the Tally ERP 9 data into SQL Server. However, with some minor modifications (i.e. connection string) you can get the data in any other database. 

Getting data from Tally ERP 9 into SQL Server using VB / VB.NET / C# / PHP etc


It is presumed that you have already downloaded and installed the DX-Fusion Free Edition utility.

Steps :-

1) Create a new database named 'Tally' in SQL Server.
2) Specify proper connection string in 'c:\wamp\www\dx-fusion\dx-fusion.ini file' to connect to your SQL Server database.
3) Start Tally ERP 9 and open your Company which contains some data.
4) Create a program in VB6 (or any other programming language of your choice).
5) Place a button on the Form / Window.
6) In the button click event, use HTTP Post to send a post-xml-request to the DX-Fusion Server
    at http://127.0.0.1:90/dx-fusion/upload.php

6a) XML request to be sent to DX-Fusion Server (for Masters):
<!-- This is the request format which must be sent to the DX-FUSION server -->
<!-- You must specify proper values for tags given below -->

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<STATICVARIABLES>

<!-- Specify the MASTER Type here -->
<RTS_SVMASTERTYPE>GROUP</RTS_SVMASTERTYPE>

<!-- Specify the MASTER Name here -->
<RTS_SVMASTERNAME>Fixed Assets</RTS_SVMASTERNAME>

<!-- Specify the ACTION here -->
<RTS_SVACTIONTYPE>CREATE</RTS_SVACTIONTYPE>

<!-- Must be set to Yes always -->
<REDIRECTREQUESTTOTALLY>YES</REDIRECTREQUESTTOTALLY>

<!-- If the Tally Server and DX-Fusion Server are on the same machine -->
<!-- then keep 127.0.0.1 else specify the IP address for Tally Server -->
<TALLYSERVERIP>127.0.0.1</TALLYSERVERIP>
<TALLYSERVERPORT>9000</TALLYSERVERPORT>
</STATICVARIABLES>
<REPORTNAME>RTSExportData</REPORTNAME>
</REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>

6b) XML request to be sent to DX-Fusion Server (for Vouchers):
<!-- This is the request format which must be sent to the DX-FUSION server -->
<!-- You must specify proper values for tags given below -->

<ENVELOPE>
<HEADER>
<TALLYREQUEST>Export Data</TALLYREQUEST>
</HEADER>
<BODY>
<EXPORTDATA>
<REQUESTDESC>
<STATICVARIABLES>

<!-- Record-type -->
<RTS_SVMASTERTYPE>VOUCHER</RTS_SVMASTERTYPE>

<!-- Specify the MASTERID here -->
<RTS_SVMASTERID>1</RTS_SVMASTERID>

<!-- Specify the ACTION here -->
<RTS_SVACTIONTYPE>CREATE</RTS_SVACTIONTYPE>

<!-- Must be set to Yes always -->
<REDIRECTREQUESTTOTALLY>YES</REDIRECTREQUESTTOTALLY>
<RTS_SVMULTIPLERECORDS>No</RTS_SVMULTIPLERECORDS>

<!-- If the Tally Server and DX-Fusion Server are on the same machine -->
<!-- then keep 127.0.0.1 else specify the IP address for Tally Server -->
<TALLYSERVERIP>127.0.0.1</TALLYSERVERIP>
<TALLYSERVERPORT>9000</TALLYSERVERPORT>
</STATICVARIABLES>
<REPORTNAME>RTSExportData</REPORTNAME>
</REQUESTDESC>
</EXPORTDATA>
</BODY>
</ENVELOPE>


Download VB6 program


Here's a sample program wirtten in VB6 which uses the free utility  DX-Fusion to get data from Tally ERP 9 into MS SQL Server
Download VB6 program to get Tally ERP 9 data into SQL Server.


Tags:
DX-Fusion, Tally to SQL-Server, Tally ERP 9
Tally is a registered trademark of Tally Solutions FZ LLC.

Valid HTML 4.01 Transitional