5. Relations Data Preparation Instructions
Type of information that goes in this tab of the template:
RELATIONS records are where you indicate links between any two CONTACTS in the database.
Types of links that might be recorded as relationships:
- Family relationships
- A contact being a member of a household
- Employer/employee relationship between an Organization and an Individual
- An individual who is a primary contact at an organization
For example, if a contact has a family member in your database, you could indicate that link with a RELATION record. The relationship then appears in both CONTACT's records.
RELATION records in Sumac do NOT record the dates for the start and end of a relationship in a reportable format. You would not want to save a relationship record to record someone’s employment history at a particular organization, for example, if the start and end or duration of their employment with that organization are important to you. This might be better suited to TIME DOCKET records in Sumac.
How the information entered in this tab will be handled:
- Every single row will be imported as a separate RELATION record.
- Every column in this tab represents a field in the RELATION record
in Sumac.
- If you do not track information that belongs in a particular column in
the template, leave that column blank.
Relation Type Forward/Reverse:
When you create a new relation type, you must provide descriptive text for the relationship in both directions – forward and reverse.
For example, if A is a parent of B (the forward relation), then B is a child of A (the reverse relation).
If you are editing information about a CONTACT A, and indicate that CONTACT A is related to CONTACT B in a certain way, then Sumac will know that CONTACT B has the reverse relationship with CONTACT A. This means that you only need to specify the relationship once, and Sumac knows it applies to both CONTACTS (though in the opposite way) (see picture below, row number 2 and 3)
Some relation types (e.g. friend of) may be the same
in both directions. In this case, enter the same text in both the Forward and
Reverse fields (see row number 4).
For example:
|
If a file has multiple rows that represent the same
relationship, import will result in duplication of the relationship records.
For example:
Contact A (ID) | Relation Type (Forward) | Contact B (ID) | Relation Type (Reverse) | Notes |
2345 | is parent of | 6789 | is child of | |
6789 | is child of | 2345 | is parent of |
Both rows represent the same relationship and have the same information but are mirrored. In this case both rows will be imported as Relations in Sumac.
Mandatory Fields
Mandatory Field(s) | Default Value Imported (If
no data present) |
Contact A | Contact A
IDs column needs to match Contact ID column in the Contacts Template. IF THERE ARE NO IDs THIS TEMPLATE IS NOT
APPROPRIATE FOR YOUR MIGRATION. |
Contact B | Contact B
IDs column needs to match Contact ID column in the Contacts Template. IF THERE ARE NO IDs THIS TEMPLATE IS NOT
APPROPRIATE FOR YOUR MIGRATION. |
Relation Type | Forward: is related to; Reverse: is related to. |
Example
Our products got an upgrade!
Some screenshots and help videos have been made using older versions of our products. Though your version's colours and themes may appear different than what you see here, the instructions, links and advice in this article are still accurate and useful!
Related Articles
2. Contacts Data Preparation Instructions
Type of information that goes in this tab of the template: This template is for ALL the records in your data that will end up as CONTACTS in Sumac. Here are some examples of what a CONTACT may be: an entity that makes DONATIONS and receives ...8. Pledges Data Preparation Instructions
Type of information that goes in this tab of the template: A PLEDGE is a promise from a CONTACT that the CONTACT intends to make one or more DONATIONS. A PLEDGE may include detailed payment instructions to enable you to collect the funds pledged. ...Health & Social Services Configuration Data Preparation Instructions
Introduction This page is meant to provide you with information on how to populate your health & social services case management specific data into the Health & Social Services build template that you downloaded from the template-based migration ...Shelters & Transitional Housing Configuration Data Preparation Instructions
Introduction This page is meant to provide you with information on how to populate your transitional shelter case management specific data into the Shelters & Transitional Housing build template that you downloaded from the template-based migration ...3. Donations Data Preparation Instructions
Type of information that goes in this tab: Records of any voluntary transfer of property without valuable consideration to the donor such as monetary gifts in-kind gifts gifts meant for auction securities and other monetary instruments Funds received ...
Societ Academy
Learn what you need to know, any time. Free!
- High quality training on demand - sessions are available every day, so you can access training that fits into your schedule.
- Training sessions that are easy to follow - helpful tips throughout each session, and access to training moderators ensure your questions get answered.
- A certificate of completion - you can request a certificate of completion for every session you attend.