Why Flat File Checker?
Users like it and help to make it better - try it and let us know what you think:
- Chris - This program is a great idea and something I've been looking for a while. I think you've got a solid rules based checking engine within the program, areas that I see for improvement surround the execution portion. I'm slowly learning! Great app!
- 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:
- 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
- Delete
- Move or Copy line to another file;
- Replace error with other value;
- Merge several rows into one.
Transform data exchange process - share data specifications with your partners to streamline your work:
Open Source - No license fee. Easy to create custom data rules
- Application is distributed under GNU General Public License (GPL).
- Extend original code in Visual Studio Express which license is also free.
Specification on-the-go - no need to make a separate document
Command line - execute Flat File Schema from batch file
- Short command does it all.
