GoLightly

Default Group Synchronization: the number of Chapter members is not correct

  #1  
Old March 4th, 2010, 01:35 PM
Dale John M.'s Avatar
Dale John M. Dale John M. is offline
Administrator
 
Join Date: Oct 2006
Posts: 82
Dale John M. is on a distinguished road
What if you link a Social Network group with an iMIS Chapter (using the Group Synchronization tool), and the number of members returned doesn't match the number you are expecting?

For example, here is what happened with one of our clients.
  • According to Web Services: 997 Active members were found in iMIS
  • According to their membership manager: 623 members were expected for that Chapter.

A mismatch between the members you see in the iMIS interface and what Web Services returns can happen when the chapter membership specified in the Name table doesn’t match the membership specified in the Subscriptions table. The way iBO/Web Services works is that it pulls from the Subscriptions table only.

These numbers get out of sync because the Subscriptions table is not being updated when the Name table is being updated.

The solution is two-fold:
  1. Find out where in the daily use of iMIS the Name table is being updated without the Subscriptions table updating correctly at the same time. Make sure the Subscriptions table gets updated when the Name table gets updated.
  2. Run an update script that adds/updates entries in the Subscriptions table based on the Name table.

Last edited by Dale John M.; December 5th, 2011 at 09:56 AM..
Reply With Quote
Reply

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 - 2018, Jelsoft Enterprises Ltd.
version 2.36.1 :: gl-005-app.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