Trail Blazer Knowledge Base:


Home : Database User Managment : Mass Update - Changing or Clearing Fields

Knowledge Base







User:

Password:



Article ID: KB74
Keyword Name: Edit, List, Removing, Setting, User, En Masse, Automated, Automatically
Created: December 11, 2013
Viewed: 5036

Mass Update - Changing or Clearing Fields


Overview

This article will walk you through the process of updating or clearing fields in mass on a specific list of data.



Steps to Change or Clear a Field

Run a query to bring up the list of the records you want to perform a mass update on.  In this example I will search from the address search window by a particular precinct, with the intention to update that precinct (this could be a plausible situation because precinct boundaries tend to change over time – in my case there is a spelling error I wish to correct.)

NOTE: Instead of performing these en mass updates in the Address List you can perform it in the voter/donor list, the images below display how this would look:

Img 1 of 2 (Voter > Edit > Set Fields)

Img 2 of 2 (Donor > Edit > Set Fields)


Under the Application Menu follow Voter/Donor > Addresses and navigate to the District tab.  Here I selected the Precinct Name “ARAGO TWP.”  I want to change these records to match the other precinct name of “ARAGO TWP” minus the (.) so that it conforms.





Once the list is populated select the Edit drop-down from the search tool strip and select Set Fields.





Locate the field name you would like to update.  Now you can either enter the new name or click the drop down and select <Clear> to clear the data in that field for each of the records in the list.  In this example the Precinct Name is updated from “ARAGO TWP.” to “ARAGO TWP” with no (.).





Click [OK]; you will be prompted with a warning, Click [OK] to perform Mass Update.  In this case 4 records will be updated.