Trail Blazer Knowledge Base

 

Home : Household Management : Splitting 'Couples' into Separate Records En Masse using the Built-In Utility

Knowledge Base







User:

Password:



Article ID: KB174
Keyword Name: Relationship, Household, Management, Cleaning, Family, Multiple, Spouse, Husband, Wife
Created: July 20, 2016
Viewed: 15335

Splitting 'Couples' into Separate Records En Masse using the Built-In Utility




Click Here to view this article as a PDF.





Author: Joel Kristenson

Last Updated: 2016-07-20






Overview


This article walks through the steps to split ‘individual’ records in your database that are currently being used to track a ‘couple’ (ex: Bob and June Smith) into their own separate individual records.


The utility used in this example allows you to run this operation en masse, instead of performing it one-by-one.  Once this operation is complete you can link the separate records together through a household relationship for the purpose of thank-you letters and other communications.



http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip: We highly suggest that you track each individual of a household as their own separate records in the database, and then link them through a household relationship.  This can be effective for many reasons such as tracking if one member is the main donor, one or the other may have different attributes, and especially if one member has passed away and you want to hide them with a not attribute.








Steps


Navigate to the Contacts (Voters/Donors) list under the Application Menu.



Use an sql wildcard lookup to run a search for individual contacts that have either the word ‘and’ in their First Name field, or the ampersand (&) symbol.  You’ll also need to add a ‘/n’ in the Last Name field because it’s *required* that these individual records have a list name present in order for this operation to work.  My example is below which produced 20 contacts that were tracking a ‘couple’ in an individual record card.




http://www.us-cert.gov/sites/default/files/images/tip-icon.pngTip:  If this is a task you think you’ll need to come back to, or perform again the future, it’s a good idea to save this query as one of your favorites for future use.



To bring up the ‘splitting’ utility follow File > Utilities > Split Couples into Separate Contacts…



Click [OK] to proceed if you’re 100% that you want to go forward with the splitting of couples in the list.



You’ll get a popup message when the operation is complete, click [OK] to finish.  In my example all 20 couples were split into separate records.



If you run the same search query as used in the first steps the count should now equal zero (if you ran the operation on the entire list), my example is shown below.



Take a look at the related resources below to learn about householding and other similar tools in Trail Blazer.



















Related Resources


Article: Managing Households – Creating, Deleting and Re-Creating

Article: Households – Creating, Deleting, Re-creating

Article: Household Automatic vs User Managed

Article: Household Record Count

Article: Household Records when Last Names are Different

Article: Household Export

Article: Find Possible Duplicates

Article: How to Find Duplicate Contact Records by Identical *Primary* Email Address, and Automatically Merge them Together

Article: SQL Wildcards

Video: Households – What To Do B4 Householding!!

Video: Households – Delete and Recreate

Video: Households – Drag n Drop

Video: How to Manage Duplicates






Trail Blazer Live Support


http://www.somebodysattic.org/images/phone%20icon_lower%20rez.jpg  Phone:  1-866-909-8700

http://sisyphus-js.herokuapp.com/assets/email_icon-0f32f4da45c2822cbb02fb36f9b9429e.png   Email:  support@trailblz.com

   Facebook: https://www.facebook.com/pages/Trail-Blazer-Software/64872951180

   Twitter: https://twitter.com/trailblazersoft



* As a policy we require that you have taken our intro training class before calling or emailing our live support team.


Click here to view our calendar for upcoming classes and events.  Feel free to sign up other members on your team for the same training.


* After registering you’ll receive a confirmation email with the instructions for how to log into the GoToMeeting session where we host our live interactive trainings.


* This service is included in your contract.



 

Are you ready to learn more? Contact Us