What does Data Genie do?

How does it work?

Key Features

Getting started

Third party tools

Technical information




You are provided with a pretty and powerful user-friendly interface to input new data or change existing data. Each field is clearly shown with its name and any options (e.g. drop-down list, protected field etc) - you simply type in the new value and when finished hit the ‘save’ button.


You can change an existing record by finding the record (see searching later), make the necessary changes and hit ‘save’ – you are asked before overwriting. All changes are stored in an audit log and this is available for you to browse through to see what changes were made. The audit log contained details of the date/time, record number, user id and what fields were changed – showing the before and after value

In order to save time when adding new data, simply call up a similar record, alter the fields that need changing and then type ‘ADD’.

Depending on user settings, you will be allowed to erase records


As you enter data it is shown in the lower half of the screen as a listview. (Screenshot) This view can be sorted by any column – it may be displayed more ‘prettily’ as an html report (screenshot) and then printed – all by the click of the mouse button.

If you double click on any record it will be displayed in the data-entry interface as mentioned above

If you right click on any record you can see all the changes that have been made to that record form the history file

The user has full control over this listview – you can control which columns to be shown and which to be hidden

As we will see, the result of any search are also shown in this listview - with a description at the bottom of the list – of filter in use

There is a quick way to browse though each record of the list by using the “previous” and “next” options


DG allows you to search through data in three ways.
  1. Simple search
    A quick search box is provided that allows you to search for a keyword through all of the fields in your system
  2. Advanced search
    With advanced search you can specify exactly what fields to search in and the relationship between the field and the search
  3. Saving search
    You can save advanced searches and then run the search by selecting the search from the menu.


There are 3 types of report. In each case the report may be viewed, sent to the printer, saved as CSV file (for input into Excel) or exported as a PDF file.

  1. Preview of the data in question – this is simply a formatted view of the data in the listview. The user can choose which variables are to be included and what filters to be in effect
  2. User-defined - The report wizard allows you to define various types of (sorted) reports with a “counting” mechanism to show subtotals. The definition of these reports may be saved – new ones can be created from the saved report definitions
  3. Pre-specified report - This will have been set up using a report wizard and is invoked with a single mouse click


DG allows you to import and export data in CSV format.

Multiple projects

With DG you can easily work with multiple projects. Projects can be imported and exported with data included so that you can exchange projects with other DG users.

Web sharing

If you have staff working in different offices then DG can link to a web database to share data.


A variety of options can be adjusted from a built in options manager.
Copyright © Data Genie - www.data-genie.com - All rights reserved
Data Genie is a product of Mark IT - Web design by Exceed IT