.NET’s Browse Maintenance functionality makes data cleansing a cinch
Posted on: January 20, 2010 | By: SuperUser Account | QAD Business Process
Data validation for an implementation or in everyday business can be a very painful and time consuming endeavor. One way to simplify this process is to write custom browses that pull specific data in the various functional areas. You can add only the specific fields of data that need to reviewed, which greatly simplifies things for users. These browses can then be run by each individual user that is required to validate specific data.
Writing custom browses allows end users to access MFG/Pro at their own convenience and run the specific browse that you have created just for them. You could even name it after them to further simplify things. Once they’ve run their browse they can validate the necessary data that exists within the database. The file can also be exported to excel for further review. Once thoroughly reviewed, any necessary changes can then be made directly in the database or the exported and cleansed spreadsheet can be used as a template to load via the normal CIM process.
This process can repeat for as long as necessary to make sure the database holds pertinent information. This solution is simple, but can really ease the data cleansing process, especially for users that are new to the functionality of MFG/Pro or technically challenged in general.