Right File Auditor

This is a tool that will help verify and audit data in data files.

Right File Auditor is a verification and audit tool for data files. This tool is able to help you save data correctly. It will help perform checks by implementing user defined rules. It is able to perform data type checks. Column to column dependency checks and regular expression matching are some of the other checks it can do. In a typical database, thus, you should be able to specify things like hire date field will have to be less than the release date field. `Discount` field similarly can be checked for a range of discounts you are offering, it could be say between 0 and 50% for example. Some data formats that are well known could also be checked automatically. These include URL, e-mail, IP address, phone number, ZIP code, SSN, etc. Some eight basic checks and some dozen sub-checks are available for use.

This could be a very handy tool when data is imported from external sources such as public storage, partners, agents etc. It’ll be also helpful during manual data entry, though the data entry programs should implement these range checks inside them. This tool can still act as insurance against any problems with inconsistent data. The files imported should conform to tab-delimited, comma separated values and file with custom separators formats; as these are the ones supported on the application. Reporting feature ensures that a data transfer session was completed without problems or what were the problems, if not. The report will tell you the table position where the problem occurred and the nature of the problem. This verification report can be in HTML, plain text or Excel compatible formats. Built in reports let you review the audit rules. In the console version of the program the data verification can be scheduled and run automatically.

The Right File Auditor is a verification and audit tool for data files. This easy to use tool helps you to save data correct by performing a few user defined checks like data type checks, column-to-column dependency check or regular expression matching. For example, you can specify that 'Hire Date' column must be less than 'Release Date' and 'Discount' must be a number between 0 and 70. Also, the program supports a few well known data formats like URL, e-mail, IP address, phone number, ZIP code, SSN, etc.
The Right File Auditor is most suitable to verify manually entered data and files received from external sources: public storages, partners, agents, etc.
The tool supports three source file formats: tab-delimited, comma separated values and file with custom separators. The auditor creates HTML, plain text or Excel compatible data verification report. The verification report contains position (row number and column name) and detailed description for each found data problem.
Try out free demo version of the tool right now!