+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 33 of 33
Cloud Services Thread, Google Apps School Directory Sync in Technical; I don't know of a way to automate CMIS reports other than a script language and direct access to the ...
  1. #31


    Join Date
    May 2009
    Posts
    3,289
    Thank Post
    290
    Thanked 885 Times in 663 Posts
    Rep Power
    341
    I don't know of a way to automate CMIS reports other than a script language and direct access to the DB. If you run a report in CMIS, you can then export to CSV or onto the clipboard and then past to excel. That will quickly become tiresome!

  2. #32

    Join Date
    Jul 2014
    Location
    Portsmouth
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Yeah, it has to be automated - I'm lazy!*

    *in that techie way of spending a day hacking out code to save time.

  3. #33

    Join Date
    Apr 2008
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by pcstru View Post
    I don't know of a way to automate CMIS reports other than a script language and direct access to the DB. If you run a report in CMIS, you can then export to CSV or onto the clipboard and then past to excel. That will quickly become tiresome!
    Just a quick answer to this - We run CMIS here and using a few PowerShell scripts can scheduled task our groups and class groups are automated. Its not graceful but it works.
    The steps we follow.
    - We use PS clear out existing members of Class Groups (I just couldnt find a cmdlet to append group membership)
    - Then PS to hit the CMIS DB and using a query get all the Class Group members
    - Add the members to the groups
    - Any empty class groups are then deleted.
    - Any new class groups are mail-enabled and set to security - universal
    - GADS then uploads a sync

    Only time we have an issue is the start of the year when we need to up the change limit in GADS as the bulk changes are over the 5% protection setting.

SHARE:
+ Post New Thread
Page 3 of 3 FirstFirst 123

Similar Threads

  1. Google Apps sync with Active Directory?
    By googlemad in forum How do you do....it?
    Replies: 3
    Last Post: 3rd April 2012, 02:23 PM
  2. Google Apps Sync for Microsoft Outlook
    By cbsc in forum Internet Related/Filtering/Firewall
    Replies: 3
    Last Post: 17th June 2011, 10:36 AM
  3. New version of the Google Apps Directory Sync tool
    By ianniow in forum General Chat
    Replies: 3
    Last Post: 12th May 2011, 12:52 PM
  4. Google Apps Schools
    By dave.81 in forum Internet Related/Filtering/Firewall
    Replies: 22
    Last Post: 4th April 2011, 11:28 PM
  5. Google Apps with Outlook Sync
    By enjay in forum Internet Related/Filtering/Firewall
    Replies: 0
    Last Post: 25th January 2011, 09:12 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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