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

Tally ERP 9 to SQL Server

Preface
Getting data from Tally ERP 9 into SQL Server
Download VB6 program

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.

Home \| RTSLink \| Downloads \| Contact Us \| Buy \| FAQ
Designed by Indiatimes Webuild - vSplash	© 2008. Shweta Softwares. All rights reserved.