SedonaOffice Data Cleanup
Template for Table-by-Table Valid Data Entry Check
Problems in SedonaOffice are often caused by the introduction of bad data into the database. Sometimes the software allows for bad data entry, but more often the bad data has been imported through the API, an approved import tool, a conversion project, or a third party import. It is the intention of the SedonaOffice support department to generate scripts which can be run universally against any SedonaOffice database to find, and sometimes correct, bad data. These scripts will be generated slowly over time for each data table, and the scripts for one table can be used as a starting point for support staff looking to add scripts for additional tables.
Please see attached documents for data cleanup scripts on the following tables:
