Changes

Database - Data Cleaning

1,463 bytes added, 13:06, 2 April 2012
no edit summary
==='''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'''===
7,528
edits