XBASE (DBF) to Tally
Looking for a software utility to transfer data from your XBase (Visual Foxpro;
Foxpro 2x; DBase) DBF's into Tally software.
Try out UDIMagic.
XBase (DBF) files have been in use since eighties. These are light-weight databases
which are quite popular with programmers developing Applications for small and medium-sized
enterprises. Some of the popular DBF formats are:-
b) Foxpro 2.x
c) Visual Foxpro tables (DBFs) and Database (DBC)
UDIMagic professionl edition allows to fetch data from your DBF's
and send it directly to Tally. And all this happens by merely writing few SQL-SELECT
statements and XML-tags.
- Works with Visual Foxpro; Foxpro 2.x; DBase and other Xbase DBF
- Supports Tally 6.3 or higher versions
- DBF-to-Tally feature is available in the UDIMagic professional-edition only (UDIMagic
How do I transfer data from
DBF files into Tally ?
The above task involves three main things:-
Xbase (DBF) Information
1) Xbase (DBF) information
(Specify the folder which contains the DBF files OR Connection-string
for DBC files)
2) SQL-SELECT statements
(Writing SQL-SELECT statements to fetch data from the DBF's)
3) XML tags
(Writing XML tags required by UDIMagic to process the data and send
it to Tally)
Though use of UDIMagic does not require any programming knowledge, you need to have
basic understanding of SQL (Structured query Language).
The first thing you need to do is to specify XBase (DBF) Infomation.
Follow the steps given underneath:-
a) Start UDIMagic.
b) Next, select "Advanced Usage" option (available in professional version).
c) Next, select the Database-type as "Visual Foxpro/Fox 2.x/XBase"
d) Next, click on the button "SETTINGS"" and specify the "FOLDER" which contains
the DBF files.
a) The UDIMagic Demo version comes with a sample DBF named "Ledger.dbf" (created
in Fox 2.x)
For DBC files
Writing SQL-SELECT statements to fetch data from XBase
Those using Visual Foxpro Database (DBC) files need to specify the Connection string
instead of the folder path. Plus, you need to download and install VFPOLEDB from
the Microsoft site.
Sample Connection-string for using Visual Foxpro
This process involves :-
a) Plan-out which DATA is to be transferred from DBF's to Tally
b) Identify the tables (Masters and Vouchers) that contain the required data
c) Write SQL-queries to fetch data
Writing XML tags required by UDIMagic to identify data retrieved
from Xbase (DBFs)
SQL-queries are generally written in a Text file (having .qry extension). You can
use any TEXT-editor (like Notepad) to view/edit the SQL-query files.
UDIMagic allows you to write multiple SQL-SELECT statements in a Query (qry) file.
Sample file :-
<SQL>.........your SQL-SELECT statement1..........</SQL>
<SQL>.........your SQL-SELECT statement2..........</SQL>
As you can see, each SQL-SELECT statement is to be enclosed in <SQL>....</SQL>
tag. This allows you to have multiple queries in a single Query (txt) file.
UDIMagic processes these queries one-by-one in the order in which they appear in
the query-file. It contructs a result-data-set which can be visualized as Columnar
format comprising of Rows and Columns. The first field in the result data-set can
be accessed using COLUMNREFERNCE A, the second field in the result data-set can
be accessed using COLUMNREFERENCE B and so on. This has been discussed in the next
In the previous section, we had seen how to fetch data from the XBase (DBFs). In
this section, we shall focus on how to write
XML tags to identify the data and send it to Tally.
What are these XML tags and why are they required ?
To import data into Tally, you need to tell UDIMagic what data you have and
where is it stored. This is done using XML tags.
Let's take an example to understand it.
Step 1: Write a SQL-query to fetch data from Ledger table (Ledger.dbf
created in Fox 2.6) as given below:-
name, groupname AS parent,opbal*-1 AS openingbalance FROM ledger WHERE optype='Dr'
SELECT name, groupname AS parent,opbal*1 AS openingbalance FROM ledger WHERE
The result of the above SQL-query can be visualised as follows:-
Ankur Salt Ltd
ABG Shipyard Ltd
Mundra Port Ltd
Step 2: Write XML tags to identify and send the data to Tally
<PARENT COLUMNREFERENCE ="B"/>
<OPENINGBALANCE COLUMNREFERENCE ="C"/>
- Fetch data from DBF using SQL-SELECT statements
- Write XML tags required by UDIMagic to process the data and send it to Tally.
Sample Xbase (DBFs)
Ledger Master table
UDI-Magic Demo version
UDI-Magic Home Page
UDI-Magic Articles and sample
UDIMagic, Visual Foxpro to Tally, Foxpro 2.x to Tally, DBF to Tally, Fox 2.x, VFP, Excel