| Resources | ||
|
||
| Current Release | ||
|
||
| News |
|
Custom Software and Training, located in Wenatchee, WA., is a provider of customized software and/or training services for businesses all over the US. We offer a wide range of software services including custom applications, websites, data cleaning/validation tools, reporting tools, and system integration software. Our training services include group or individual training, live or by phone, and can be for a variety of common computer applications.
The DVTool, or Data Validation Tool, is a simple validator tool that helps you comb through existing data, that must be provided in a tab delimited format, and shows a report of the errors found in each record. The tool reads in information and creates a data validation schema which is then editable by the user. When the validation process is run, the tool checks each piece of data against the schema definition to determine if the data is valid. The tool currently allows for string, number (int), and date/time validation. In the string type, you are also allowed to specify "allowed values" which can include any number of possible valid entries to check for. For the int (number) field, you may specify an acceptable range of values, or leave blank if all numbers are valid. It is also programmed to be smart about name, email, phone or zip code fields. All you have to do is use "name","email","phone" or "zip" somewhere in the field name, and it will verify that data against the standard patterns.
You will be amazed, if you run this tool every evening and then inform the staff that entered the data what records had errors, how quickly you can train your staff to produce less errors each day. They will learn that it's far easier to check the information for errors BEFORE submitting the form, than it is to get a report from their supervisor on how many errors they entered and have to go back in to the record to fix them. Some companies have noticed an 80% decrease in record errors produced by their staff people over just a few months of using this type of tool.
Use DVTool to build and maintain multiple schemas to handle all your data validation needs. If you are a Tapestry user, you can use some of our prepackaged schema definitions (which you may customize) to validate your Tapestry data.
The DVTool is written entirely in Java and requires the Java 6 Runtime Environment (minimum). The download includes a zip file of the executable jar file and other necessary resources. The zip file can be unzipped at any convenient location, and running the application is as simple as double clicking on the jar file. If you have problems with running the application, please contact us and we'll be glad to help. We ask users of the tool to register with the website so that we can manage our users and make sure you get informed if the product gets updated or website moved.
If you need any assistance in using this program, or would like to report bugs or make feature suggestions, please contact us via our Contact page.