Saturday, November 7, 2009

Tally to Relational database

Here's a sample XQuery that exports Tally data into multiple Relational tables viz

mvoucher.dbf - main voucher table
ledvouch.dbf - child table which contains ledger details
invvouch.dbf - child table which contains Inventory details

Download the XQuery to export Tally data into multiple relational tables
View the Instructions PDF file for exporting Tally data into multiple relational tables

PS:
a) Works with RTS-XQuery Freemium v1.0 Release 3.0 or higher
b) Please read the Instructions given in the PDF file (which is included in the zip-file).

Tuesday, November 3, 2009

Using Macros with RTS-XQuery Freemium

RTS-XQuery Freemium v1.0 Release 2.4 supports VBA macros. This facilitates easy and faster generation of Reports in MS-Excel (i.e Tally to Excel Reports).

Here's a sample :-

Party and StockItem wise Sales

This XQuery retrieves raw data from Tally and generates :-
a) Party-wise sales for each StockItem or
b) StockItem-wise sales for each Party

For more details, refer the Instructions-PDF file provided with the sample XQuery-files which can be downloaded from this link :- party-and-stockitem-wise-sales.zip

Sunday, October 25, 2009

RTS-XQuery Freemium

We are pleased to launch RTS-XQuery Freemium, a FREE utility to transfer data from Tally Software (or XML data-file) into MS-Excel, DBFs, Access, SQL-Server, MySQL and other popular databases.

Freemium = FREE + Premium

- RTS-XQuery Freemium Software is free for both commercial and personal use
- Support Services are available for a premium (i.e. chargeable basis)

For more information, please refer http://www.rtslink.com/rts-xquery-freemium/index.html