Archive

Posts Tagged ‘google-apps’

Aggregate room and resource calendars for Overview

Calendar_Language_Resource_Center_UNC_Charlotte_-_2014-03-26_20.10.30

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:

clip_image002

clip_image003

clip_image004

clip_image005

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

clip_image006

clip_image007

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

clip_image008

Open the calendar

clip_image009

Copy the URL form the address bar:

clip_image010

Insert it here:

clip_image011

Replace html at the end by ics.

Check “make calendar publicly accessible”

clip_image012

Access calendar settings

clip_image013

Change calendar name to part before @

clip_image014

clip_image016

clip_image017

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

clip_image018

clip_image019

Open the settings for the main calendar:

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

clip_image020

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:

clip_image022

Embedding the iframe HTML snippet works in WordPress

clip_image023

as well as Drupal: image

This is just a (iframe with google calendar on wordpress.com) 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