Difference between revisions of "Database - Data Cleaning"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "In the section '''Database - Data Cleaning''', the following functionality occurs: # Remove duplicate records # Remove blank records # Remove redundant / Orphan records # Sing...") |
Philip Lacey (talk | contribs) |
||
| Line 10: | Line 10: | ||
==='''Remove Duplicate Records'''=== | ==='''Remove Duplicate Records'''=== | ||
| + | *Choose the campaign. | ||
| + | *Choose the fields on which to base this removal of records on, from the list provided. | ||
| + | *The duplicate records that match the fields chosen, will now be removed from the database. | ||
| + | *Click Delete Duplicates. | ||
| + | |||
| + | ==='''Remove Blank Records'''=== | ||
| + | *Choose the campaign. | ||
| + | *Choose the fields on which to base this removal of records on, from the list provided. | ||
| + | *The blank records that match the fields chosen, will now be removed from the database. | ||
| + | *Click Delete Blanks. | ||
| + | |||
| + | ==='''Remove redundant / orphan records'''=== | ||
| + | *Choose the campaign. | ||
| + | *Delete the redundant / orphan records from the database. | ||
| + | *Newer records that have been uploaded will not be deleted. | ||
| + | |||
| + | ==='''Single Field Update - All records'''=== | ||
| + | *Choose the campaign. | ||
| + | *Select the fields to update the records. | ||
| + | *Enter the value to replace the current contents of this field in the text box provided. | ||
| + | *Update all records in this campaign. | ||
| + | |||
| + | ==='''Data Field - Case Management'''=== | ||
| + | *Choose the campaign. | ||
| + | *Select the fields to include. | ||
| + | *Reformat the fields that have been selected for this campaign by clicking on the Reformat fields button. | ||
| + | |||
| + | ==='''Data Field - Convert Title to Numeric'''=== | ||
| + | *Choose the campaign. | ||
| + | *Choose the field in which to convert to numeric. | ||
| + | *Choose whether the fields uprecognised records will be wiped, byt choosing True or False. | ||
| + | *Choose whether the report generated will show on the screen if it failed. | ||
| + | *Click on Reformat fields. | ||
| + | |||
| + | ==='''Convert County to Numeric'''=== | ||
Revision as of 13:06, 2 April 2012
In the section Database - Data Cleaning, the following functionality occurs:
- Remove duplicate records
- Remove blank records
- Remove redundant / Orphan records
- Single Field Update - All records
- Data Field - Case Management
- Data Field - Convert Title to Numeric
- Data Field - Convert County to Numeric
- Campaign - Consolidate
Contents
1 Remove Duplicate Records
- Choose the campaign.
- Choose the fields on which to base this removal of records on, from the list provided.
- The duplicate records that match the fields chosen, will now be removed from the database.
- Click Delete Duplicates.
2 Remove Blank Records
- Choose the campaign.
- Choose the fields on which to base this removal of records on, from the list provided.
- The blank records that match the fields chosen, will now be removed from the database.
- Click Delete Blanks.
3 Remove redundant / orphan records
- Choose the campaign.
- Delete the redundant / orphan records from the database.
- Newer records that have been uploaded will not be deleted.
4 Single Field Update - All records
- Choose the campaign.
- Select the fields to update the records.
- Enter the value to replace the current contents of this field in the text box provided.
- Update all records in this campaign.
5 Data Field - Case Management
- Choose the campaign.
- Select the fields to include.
- Reformat the fields that have been selected for this campaign by clicking on the Reformat fields button.
6 Data Field - Convert Title to Numeric
- Choose the campaign.
- Choose the field in which to convert to numeric.
- Choose whether the fields uprecognised records will be wiped, byt choosing True or False.
- Choose whether the report generated will show on the screen if it failed.
- Click on Reformat fields.
