Posts Tagged ‘google-apps’

Aggregate room and resource calendars for Overview


To publish an aggregate calendar of MS-Exchange ICS calendar subscriptions, use Google Calendar

If you manage many resources that many users need to share, you will want to give them an intuitive overview of the utilization. We manage room and equipment booking in MS-Exchange 2010, but both Exchange and Outlook/OWA/Office365 are not for everyone (to set up), and seem to lack a convenient way to publish an aggregation of the iCal feeds of the individual resources that can be published.

Enter Google calendar: Start with creating a new calendar which will hold your calendar aggregation, and make it public:





First add ICS-based internet calendar subscriptions to Google calendar:



We have prior ICS feeds arranged in MS-Exchange 2010 which are listed in the LRC calendar spreadsheet:


Open the calendar


Copy the URL form the address bar:


Insert it here:


Replace html at the end by ics.

Check “make calendar publicly accessible”


Access calendar settings


Change calendar name to part before @




You can rename these subscribed calendars, but this name will not carry over to the embedded calendar, see below:



Open the settings for the main calendar:

In the settings section “embed”, Click the “Customize” link to open the “Google Embeddable Calendar helper”:


Select the “Calendars to display”: this list contains the ICS-subscriptions you added earlier.

Unfortunately, the Google’s embeddable Calendar helper seems to “eat” the names you have given these calendars, and replace it by the default “Calendar” (there is no calendar name stored in the ICS, it seems), so you have to maintain a color legend manually (the color is permanently stored in the iframe HTML code snippet).

Also, you users have to manually match the color when they (de)select calendar subscriptions from the main calendar:


Embedding the iframe HTML snippet works in WordPress


as well as Drupal: image

This is just a (iframe with google calendar on test

Google Calendar embedded aggregated calendar won’t show calendar names?

  1. When I add "Calendars to Display" in the "Google Embeddable Calendar Helper" ,
  2. Google calendar lets me select calendars I  added from iCal sources,
  3. but it does not "remember" the names I have given these calendars, image
  4. displaying only the default name "Calendar",
    1. both in the "Google Embeddable Calendar Helper" image
    2. and in the iframe embed:  image
  5. rendering the aggregation feature useless (Which is which?).
  6. Is there a workaround or hidden feature like a “name parameter” in the embed query-string? What is it? I cannot find it in the Google Calendar API reference.

How to create a form on Google Apps

  1. If you want to collect input from others (including students outside of a course = Moodle), including recurring input from the same student (multiple submissions are the default andsingle submission limit can apparently only be enforced offwith JavaScript hacks)(.
  2. Do this to create a form in Google Apps:
  3. Here is what you can have your submitters see: imageimageimage
  4. Here is what you get:

The simplest OCR options you have here

  1. (Staff:) Using the departmental scanner which outputs PDF to a network share (that you can link from your desktop). The PDF is searchable at least
  2. (Staff & Students:) Using only your desktop, at work or at home:
    1. MS-Office
      1. OneNote 2007/2010: paste image, right-click to access context menu, “extract text”.  Example (you can see it is quick and simple, but not error-free): image
      2. Imaging components :TBA
    2. Google Apps can also OCR the files you upload to Google Docs.
      1. You first need to change the default settings. Choose from hard-drive icon for file uploads, context menu: “Settings” / “Convert text form uploaded PDF and image files”.
      2. You may want to upload an entire folder – then you need to either use Chrome or allow the install of a Java applet.
      3. You may want to use not have to deal with one Googledoc for each image you upload. So bind your scanned pages (unless your OCR software already allows this – I have been restricted to “Windows Scan and Fax”) to multi-page PDFs (imagemagick’s convert command can do it for free). Note that the max upload size in Google Docs is 2mb, which restricted me to about 10 pages per document (strangely, since I had scanned to b lack and white and very small size, but the PDF size grew, likely using a less efficient encoding  – might be able to optimize this).
      4. Google Apps uses the same OCR engine as Google Books. Not much formatting is being retained, in the below examples note the line breaks, but that is fine for me, since I am only after large chunks of text for further processing: image
      5. I have only tested English (largely current affairs) text, but was impressed with the OCR results.
        1. Also, where the OCR went wrong (2-times 4 per page; also some artifacts, my scans were not very clean: Google Apps seems to handle dark spots on the page better then unstraightened lines),
        2. the proofreading suggestions (as usual, right click to access) are very good (better than MS-Word’s when I downloaded the files).image
        3. Sometimes you have to consult the original image which conveniently gets put above the  OCR’ed: text. imageimage
        4. You can download the results as MS-Word files and within MS-Word, remove all the scan images using ^g. image

    Symptoms: When clicking on a a sharing link from a GoogleApps document, the recipients may be redirected to the standard Google login page, with their personal Google account user name. Even if they change this user name to their UNCC user name, they cannot log in (Error: wrong password).


    Resolution: Do not click on the sharing link in the email. Rather, go to and log in there. Find the new document shared with you in your documents list.