+ Post New Thread
Page 3 of 3 FirstFirst 123
Results 31 to 36 of 36
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,313
    Thank Post
    293
    Thanked 889 Times in 667 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
    4
    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.

  4. #34
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,497
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    Resurrecting this one slightly, but how did people get on with the SIMS extracts? As well as the email aspects, we are also Google Classroom so are keen to get class groups created so teachers can invite entire classes.

    It doesn't need to be simple to set up, I'm happy to put some work in (although know very little about Powershell) but it does need to be automated and not require (much) additional work from the admissions staff...

  5. #35
    jumpinjamez's Avatar
    Join Date
    May 2006
    Location
    UK
    Posts
    258
    Thank Post
    140
    Thanked 24 Times in 16 Posts
    Rep Power
    28
    Quote Originally Posted by enjay View Post
    Resurrecting this one slightly, but how did people get on with the SIMS extracts? As well as the email aspects, we are also Google Classroom so are keen to get class groups created so teachers can invite entire classes.

    It doesn't need to be simple to set up, I'm happy to put some work in (although know very little about Powershell) but it does need to be automated and not require (much) additional work from the admissions staff...
    We have found that just getting the teachers to create a class and then give the students the code to join works just fine. Not being able to add multiple teachers to a class is an issue.

  6. #36
    enjay's Avatar
    Join Date
    Apr 2007
    Location
    Reading, Berkshire, UK
    Posts
    4,497
    Thank Post
    282
    Thanked 196 Times in 167 Posts
    Rep Power
    76
    Quote Originally Posted by jumpinjamez View Post
    We have found that just getting the teachers to create a class and then give the students the code to join works just fine. Not being able to add multiple teachers to a class is an issue.
    Thanks, but we also want to have email groups for the classes, so will need them in Google Apps for that.



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, 03:23 PM
  2. Google Apps Sync for Microsoft Outlook
    By cbsc in forum Internet Related/Filtering/Firewall
    Replies: 3
    Last Post: 17th June 2011, 11: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, 01:52 PM
  4. Google Apps Schools
    By dave.81 in forum Internet Related/Filtering/Firewall
    Replies: 22
    Last Post: 5th April 2011, 12:28 AM
  5. Google Apps with Outlook Sync
    By enjay in forum Internet Related/Filtering/Firewall
    Replies: 0
    Last Post: 25th January 2011, 10: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
  •