Flat File Checker Publisher's description
from Bulat Yapparov
Flat File Checker (FlaFi) is a simple and intuitive tool for validation of structured data in flat files (*.txt, *.csv, etc.).
Flat File Checker (FlaFi) is a simple and intuitive tool for validation of structured data in flat files (*.txt, *.csv, etc.). It is the best application to change they way you validate data and make processes easy and efficient.
FlaFi's intuitive interface makes it easy to translate business rules into Flat File Schema that defines validation criteria. You don't need any product specific knowledge to start using the application, which is often the case with ETL software.
FlaFi is essential to ensure painless data exchange without errors.
It minimises effort
* data quality with virtually no manual involvement
* interface specification for data exchange created on-the-go
* successful data exchanges with no repetitive interactions with the external data providers (as long as they screen the data against your Schema prior to supply)
and saves time
* minimum turnaround time due to guaranteed quality of each data supply
* faster set-up of new exchange processes
Why Flat File Checker?
Users like it and help to make it better - try it and let us know what you think:
* Chris - I've been using FFC for over 2 months now and it's working great. I've got it auto checking files before sending to our customers. I've got about 20 different FFC schemas checking 20 different file types. In two months we've check around 1000 files and FFC caught 3 bad files out of the 1000. This is fantastic as I would have 3 very upset customers if we had not caught these exceptions.
* Sinha - In searching for open source importer in SourceForge and come across your Flat File Checker, which is FANTASTIC and required for any importer team.
Rich rule builder - build complex data rules:
GUI Rule Builder Sample
View full screenshot
* Join constraints with logical operators: And, Or, Not;
* Restrict conditions with Where clause;
* Compare Fields;
* Regular Expressions;
* VB Expressions.
Relational Links - validate file as part of interconnected data set.
Database Queries - validate data in the file against the data stored in databases
* Make your own query templates with parameters;
* Customisable user interface.
Merge duplicates - quick way to merge duplicates without information loss:
* Unique constraint on one or several columns;
* Fast processing.
Action on errors - comprehensive set of action options is available for erroneous records
* Move or Copy line to another file;
* Replace error with other value;
* Merge several rows into one.
What's New in This Release:New Features:
В· Data Sources area was converted from list to tree with 2 types of nodes - sources and fields. 2. Fields area was replaced by data rules builder. This means users don't need to open column details form to edit data rules.
В· Data preview form fails due to PowerPack reference
System Requirements:No special requirements.
Program Release Status: Major Update
Program Install Support: Install and Uninstall