GoLightly

Default SocialNetworkAllowView: Who should be allowed into your community

  #1  
Old March 16th, 2009, 02:56 PM
Dale John M.'s Avatar
Dale John M. Dale John M. is offline
Administrator
 
Join Date: Oct 2006
Posts: 80
Dale John M. is on a distinguished road
In order to properly control access to your social network, the people who should have access to your social network need to be identified from your iMIS database. We identify these people with a View called "SocialNetworkAllowView" (sometimes referred to as "SocialNetworkAllow").

View Creation
When you create this View/query, it should return the field "Id" for everyone you would like allowed in the community (including staff, board members, volunteers, members).

Sample View 1:
CREATE VIEW SocialNetworkAllowView as
SELECT NAME.ID
FROM NAME, NAME_DEMO
WHERE
NAME.ID = NAME_DEMO.ID AND
NAME.MEMBER_RECORD = 1 AND
NAME_DEMO.OPT_OUT_SOCIAL_NETWORKING <> 1

Sample View 2:
CREATE VIEW SocialNetworkAllowView as
SELECT Name.ID
FROM Name, Demo1
WHERE
Name.MEMBER_TYPE in ('AG', 'CG', 'CDMNC', 'STAFF', 'EG', 'LG', 'PG') AND
Demo1.OPT_OUT_SOCIAL_NETWORKING <> 1 AND
Name.EMAIL <> '' AND
Demo1.EXP_DATE >= getdate()

Ongoing Maintenance
Once the SocialNetworkAllowView is created and the bridge installation is complete, some members who have signed into your social network may "drop off" this View, and thus no longer be able to get into your community. This can happen because their membership has expired, or for some other reason. When a member is no longer included on the SocialNetworkAllowView, they will receive a message that says: "Your account has been suspended. Please contact us with any questions."

If you are the community manager and receive an inquiry from a member regarding why their social network account has been suspended, follow these steps to confirm that the person has dropped off the SocialNetworkAllowView:
  1. Find the person's profile in the Social Network
  2. Go to the person's "Edit Profile" page and copy their iMIS ID (is underneath their name in "Basic Directory Info")
  3. Click on Admin Tools (usually underneath your name in the upper right corner)
  4. In the left navigation visit "Import iMIS Profiles"
  5. "show" the Special Tools
  6. One of the Special Tools is "To check to see if a particular iMIS ID is in the SocialNetworkAllow". Enter the iMIS ID in the form box and click "Retrieve".
  7. You will be taken to a report that tells you whether this ID is in the "SocialNetworkAllowView".
Once you have confirmed that the person is not on the SocialNetworkAllowView, you will need to ask your internal IT staff or your Solution Provider to find out why the person's iMIS ID is not on this View any more.

See also Group Synchronization: How do I add participants from iMIS?

Last edited by Dale John M.; June 18th, 2010 at 09:03 AM.. Reason: Clarified that staff need to be included in this View
Reply With Quote
Reply

Tags
deployment , imis

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

 

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
version 2.31.25 :: go-008.golightly.com
Desktop View
Dale John McGrewDale John McGrew, 1st GradeEva KonigsbergEva Konigsberg, 1st GradeJill TempletonJill Templeton, 1st GradeJoe EvansJoe EvansJohn TempletonJohn Templeton, 3rd GradeJulia VcherashnyJulia Vcherashny, BabySarah GolightlySarah Golightly, 4 years oldTristan NaramoreTristan Naramore