Fields in your netFORUM Enterprise database map to associated fields in Higher Logic. The tables in this article list the field mappings that are used in the Higher Logic Thrive Community integration with netFORUM Enterprise.
Contact
Alternative Contact Id |
HigherLogic_MemberDetails.MemberId |
Age |
HigherLogic_MemberDetails.Age |
Birthday |
HigherLogic_MemberDetails.Birthday |
Member Since |
HigherLogic_MemberDetails.MemberSince |
Member Expires On |
HigherLogic_MemberDetails.MemberExpiresOn |
Designation |
HigherLogic_MemberDetails.Designation |
Primary Email Address |
HigherLogic_MemberDetails.EmailAddress |
Prefix Code |
HigherLogic_MemberDetails.PrefixCode |
First Name |
HigherLogic_MemberDetails.FirstName |
Middle Name |
HigherLogic_MemberDetails.MiddleName |
Last Name |
HigherLogic_MemberDetails.LastName |
Informal Name |
HigherLogic_MemberDetails.InformalName |
Gender |
HigherLogic_MemberDetails.Gender |
Ethnicity |
HigherLogic_MemberDetails.Ethnicity |
Suffix Code |
HigherLogic_MemberDetails.SuffixCode |
OrganizationName |
HigherLogic_MemberDetails.CompanyName |
Title |
HigherLogic_MemberDetails.Title |
Parent Contact Id |
HigherLogic_MemberDetails.ParentMemberKey |
Primary Contact Contact Id |
HigherLogic_MemberDetails.PrimaryContactLegacyContactKey |
Exclude From Directory |
HigherLogic_MemberDetails.ExcludeFromDirectory |
Do Not Email |
HigherLogic_MemberDetails.DoNotEmail |
Is Organization |
HigherLogic_MemberDetails.IsOrganization |
Bio |
HigherLogic_MemberDetails.Bio |
Website URL |
HigherLogic_MemberDetails.WebsiteUrl |
Profile Image URL |
HigherLogic_MemberDetails.ProfileImageURL |
Facebook URL |
HigherLogic_MemberDetails.FacebookURL |
LinkedIn URL |
HigherLogic_MemberDetails.LinkedInURL |
Blogger URL |
HigherLogic_MemberDetails.BloggerURL |
Twitter URL |
HigherLogic_MemberDetails.TwitterURL |
Other Social URL |
HigherLogic_MemberDetails. |
Contact Phone
NOTE: The # symbol in the following table represents any number from 1–4.
Formatted Number |
HigherLogic_MemberDetails.Phone# |
Phone Type |
HigherLogic_MemberDetails.Phone#Type |
Contact Address
Address Line 1 |
HigherLogic_MemberDetails.Address1 |
Address Line 2 |
HigherLogic_MemberDetails.Address2 |
Address Line 3 |
HigherLogic_MemberDetails.Address3 |
City |
HigherLogic_MemberDetails.City |
State/Province |
HigherLogic_MemberDetails.State |
Postal Code |
HigherLogic_MemberDetails.Postal Code |
Country Code |
HigherLogic_MemberDetails.Country |
Contact Demographic
Demographic Text Value |
HigherLogic_CustomDemographics.DemographicValue |
Demographic Id |
HigherLogic_CustomDemographics.DemographicKey |
Data Type |
if HigherLogic_CustomDemographics.IsFreeForm NOTE: 1 = "text field"; other value and blank = "pick list" |
Demographic Type Id |
HigherLogic_CustomDemographics.DemographicTypeKey |
Demographic Type Value |
HigherLogic_CustomDemographics.DemographicTypeValue |
Contact Group
Communities
Group Id |
HigherLogic_MemberCommunityGroups.GroupKey |
Group Name |
HigherLogic_MemberCommunityGroups.GroupName |
Group Type |
"Community Group" |
Group Sub Type |
HigherLogic_MemberCommunityGroups.GroupType |
Role |
HigherLogic_MemberCommunityGroups.RoleKey |
Initial Join Date |
HigherLogic_MemberCommunityGroups.SinceDate |
Begin Date |
HigherLogic_MemberCommunityGroups.BeginDate |
End Date |
HigherLogic_MemberCommunityGroups.EndDate |
Security Groups
Group Id |
HigherLogic_MemberSecurityGroups.GroupKey |
Group Name |
HigherLogic_MemberSecurityGroups.GroupName |
Group Type |
"Security Group" |
Group Sub Type |
HigherLogic_MemberSecurityGroups.GroupType |
Role |
HigherLogic_MemberSecurityGroups.RoleKey |
Initial Join Date |
HigherLogic_MemberSecurityGroups.SinceDate |
Begin Date |
HigherLogic_MemberSecurityGroups.BeginDate |
End Date |
HigherLogic_MemberSecurityGroups.EndDate |
Contact Education
NOTE: Fields with an asterisk (*) are not presented in the default views but they are supported.
From Year |
HigherLogic_MemberEducation.FromYear |
To Year |
HigherLogic_MemberEducation.ToYear |
School Name |
HigherLogic_MemberEducation.SchoolName |
City |
HigherLogic_MemberEducation.City |
State |
HigherLogic_MemberEducation.State |
Country |
HigherLogic_MemberEducation.Country |
Degree |
HigherLogic_MemberEducation.Degree |
Field Of Study |
HigherLogic_MemberEducation.FieldOfStudy |
Advisor *
|
HigherLogic_MemberEducation.Advisor |
Dissertation *
|
HigherLogic_MemberEducation.Dissertation |
Degree Year |
HigherLogic_MemberEducation.DegreeYear |
Is Highest Degree Attained *
|
HigherLogic_MemberEducation.IsHighestDegreeAttained |
Contact Job History
Company Name |
HigherLogic_MemberJobHistory.CompanyName |
Title |
HigherLogic_MemberJobHistory.Title |
City |
HigherLogic_MemberJobHistory.City |
State |
HigherLogic_MemberJobHistory.State |
Country |
HigherLogic_MemberJobHistory.Country |
Website URL |
HigherLogic_MemberJobHistory.WebsiteUrl |
Is Present |
HigherLogic_MemberJobHistory.IsPresentString NOTE: Yes = "true"; No and blank = "false" |
Start Date |
HigherLogic_MemberJobHistory.StartDate |
End Date |
HigherLogic_MemberJobHistory.EndDate |
Lists
Lists can be retrieved using both dynamic queries, as well as communities from the HigherLogic_MemberCommunityGroups view.