DataMite

What is DataMite?
DataMite is the ideal solution to extract data from report files with an all-in-one tool that is easy to use. Its report-mining and data translation visual tools allow you to extract data from files without any programming. Import data from any sources, extract the data you need, build a visual query in minutes, create a nicely layed out report and an export file visually in no time. It is that easy!
DataMite supports a wide variety of file formats including: fixed-length, comma-delimited, Microsoft Access databases, Microsoft Word documents, Microsoft Excel spreadsheets, Dbase files, Lotus 123 spreadsheets, XML files, HTML files, PDF files, RichText files and many more.
DataMite can simplify your life, here are some examples where it has been used saving precious time to users:
- Translate EDI ANSI X12 files to Microsoft Access database. It all runs transparently without the user's intervention. DataMite can be automated via multiple command line parameters.
- Several XML files contained PO information that need to be converted to a comma-delimited text file (CSV).
What do you get with DataMite?

Import data from many different file formats including:
- Fixed-length files.
- Comma-delimited files.
- Microsoft Access databases.
- Microsoft Word documents.
- Microsoft Excel spreadsheets.
- DBase files.
- Lotus 123 spreadsheets.
- XML files.
- PDF files.
- HTML files.
- And many more...

Visually build SQL queries to filter and modify your data.
Build as many queries as you want visually on the screen. No need to learn SQL syntax.
If you are good with SQL, you can simply edit the code without using the visual query builder tool.
Update, Insert and Delete queries are supported allowing you to modify the data right after the extraction process.

Build simple or complex reports in minutes.
Reports are edited in bands just like any word processor.
You can align the field output values very easily. It's all visual, what you see is what you get. You can also print out values from different functions, like %date, %time, %pageno, %count, %sum(field), and more...
Using the same technology you can create customized export files, fixed-length or delimited.

Export the data to wide range of file formats including:
- Comma-delimited file.
- Microsoft Access database.
- Microsoft Word table document.
- Microsoft Excel spreadsheet.
- DBase database.
- Lotus 123 spreadsheet.
- Rich-text format table document.
- HTML file.
- XML file.
- PDF file.
You can also use our visual export editor where you can define the structure of your file visually.

Customize your extraction behavior with very powerful scripts.
The syntax for programming can be choosen on a per-project basis. You get the choice of two different syntaxes: Basic or Pascal.
Theres more!
- Automate any procedure (import, print, export...) via multiple command line parameters.
- DataMite comes with different project demos for quick learning.
- Buying DataMite, you get excellent support and frequent updates.
Requirements:
DataMite is compatible with Windows 95/98/2000/2003 Server/XP/NT 4. You will need 16 MB of RAM and 3 MB of hard drive space.
The syntax for programming can be choosen on a per-project basis. You get the choice of two different syntaxes: Basic or Pascal.
Theres more!
- Automate any procedure (import, print, export...) via multiple command line parameters.
- DataMite comes with different project demos for quick learning.
- Buying DataMite, you get excellent support and frequent updates.
Requirements:
DataMite is compatible with Windows 95/98/2000/2003 Server/XP/NT 4. You will need 16 MB of RAM and 3 MB of hard drive space.




