RTSXQuery Error : Class not registered.

The aforesaid error appears if the C:\WINDOW\SYSTEM32\DX-FUSION.DLL  is not registered automatically during installation due to lack of administrator rights.

Solution:-
1) Un-install the DX-Fusion module
2) Log-in as Administrator and re-install DX-Fusion.

In case, if you still face problems, contact Shweta Softwares by email at sales @ rtslink. com  (remove spaces)

How to transfer Tally data into MySQL ?

Steps to transfer Tally data into MySQL

1) Download and install DX-Fusion from :-
http://www.rtslink.com/images/dx-fusion-fe-v1.0.exe

2) Download and install MySQL driver from :-
http://www.rtslink.com/images/mysql-connector-odbc-3.51.27-win32.zip

3) Make changes in the c:\wamp\www\dx-fusion\dx-fusion.ini file

DATABASETYPE="MYSQL"

CONNECTIONSTRING="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=tally; User=root;Password=;Option=3;"

4) Start Internet Explorer and type out :-
http://localhost:90

5) Click on myphpadmin

6) Click on databases tab and create a database named Tally.

7) Start Tally, Open your Company and then select option "DX-Fusion >> Ctrl+K" to export Tally data into MySQL database

Tally to MySQL

DX-Fusion v1.0 Release 1.2 supports transfer of data from Tally into MySQL.

You must download and install the driver for MySQL from this link :-
http://www.rtslink.com/images/mysql-connector-odbc-3.51.27-win32.zip

Excel Reporting using DX-Fusion

Can DX-Fusion be used to export data from Tally into MS-Excel ?

Several users have raised this question. Though, this could had been implemented in DX-Fusion, we choose NOT to do it as the primary objective of developing this tool was to get Tally data in relational database (RDBMS) format.

PS: Excel is NOT a relational database management system.

However, as Excel is commonly used for reporting and there is lot of demand by users to add support for it, we are providing an alternative solution using which users can get the data into MS-Excel.

Pre-requisities
1) MS-Query (which generally gets installed when you install MS-Office)
2) DX-Fusion utility

Remarks:- It is  presumed that you have already downloaded and installed DX-Fusion utility. It is also presumed that you have already exported data from Tally into MS-Access.

Steps to get data in MS-Excel
1) Download and unzip the sample query file.

Remarks:-
This is a simple text-file which contains the SQL SELECT-Statements. The file must have extension as DQY.

2) Double-click on the dqy-file.

Remarks:-
a) This will retrieve data from MS-Access (tally.mdb file) into MS-Excel
b) Read the comments given in the dqy file for more information. You can use Notepad to view/edit the same.

Export Multiple Companies data into single database

DX-Fusion supports transfer of data from multiple companies in Tally ERP 9 into a single database.

Each company in Tally ERP 9 is assigned a unique Guid which is stored in field named COMPANYGUID. DX-Fusion uses this COMPANYGUID field in the various masters and voucher tables, which allows you to identify the records for a specific Company.

This way you can generate MIS reports based on one or more companies data.

Launch of DX-Fusion

We are pleased to launch our new product DX-Fusion today.

DX-Fusion is an utility that facilitates transfer of data from Tally into SQL Server, Access, Oracle and several other popular databases. You can download it from http://www.rtslink.com/dx-fusion/