Resources‎ > ‎

Scripts

Here are all the scripts that North Canton City Schools uses to talk with the Google API, MySQL, SIS, and Active Directory.  These scripts are constantly changing, but you will find the stable versions on this page.  My scripts were designed to run on *nix systems and they have been tested on Linux and OS X.  YMMV on Windows

The additional apps listed here are all dependencies for the scripts.  Some require building from source.

With the exception of the gdata library, all scripts on here are as is and should be considered beta unless otherwise stated.  Please use with caution.

For questions you can reach me at:  john _at_ northcantonschools.org.  I will try to answer any questions as soon as possible.
SelectionFile type iconFile nameDescriptionSizeRevisionTimeUser
ċ

View
adtool is a unix command line utility for Active Directory administration. Features include user and group creation, deletion, modification, password setting and directory query and search capabilities.  Requires build from source.  Jun 9, 2011, 9:56 AM John Fano
ċ

Download
This is the skeleton of the cache tables. It will create a database named ga_cache and 5 tables: groups, users, orgs, nicks, postini.  Create a users and give them at least update, insert, delete, and select rights to all tables.  2k v. 3 Jun 9, 2011, 10:05 AM John Fano
ċ

View
This is Google's gdata Python library for connecting to the Google API. You must have this installed to use any of the other Python scripts on this page.  You also must have API access enabled on your Apps Domain.  Jun 9, 2011, 8:22 AM John Fano
ċ

Download
This is my custom module library. It has all the modules that are used by my Apps sync script. Please consider this alpha software. Extract all files to a single directory and then add that directory to your python path using a .pth file.  16k v. 1 Jun 10, 2011, 4:01 AM John Fano
ċ

View
The scripts rely on MySQL for local cache tables. The help with execution speed as all the Apps Domain information is cached locally so less API calls are made.  Jun 9, 2011, 8:48 AM John Fano
ċ

View
This is the Python ODBC connector that we use to talk to our SIS. On *nix systems you will need to have FreeTDS installed and using version 8.0 to speak with MS SQL 2005+.  Jun 9, 2011, 8:40 AM John Fano
ċ

View
This module must be installed. For Windows system, Google for the installer. It's not maintained by the project. For all three platforms you will need MySQL installed.  Jun 9, 2011, 8:38 AM John Fano
Comments