Archive
Room and Equipment handling using MS-Exchange Resource Mailboxes: Configuration with OWA instead of PowerShell
- As once can easily find documented for MS-Exchange 2007, if you are the owner of the mailbox, you can use the OWA-feature “open other mailbox”.

- As impersonated user for this mailbox
, you can access the “Options / Settings”: - for the “resource” scheduling

- for its “calendar”

- This is maybe not as much fun as PowerShell’s Set-MailboxCalendarSettings and set-CalendarProcessing (click as you go, no batching), but easier on your MS-Exchange admin
and especially practical for quick modifications and tests,
LRC Outlook/Exchange 2010 Resource Calendaring: LRC resources in the Global Address List (GAL)
- You will find an equivalent of the LRC bookable resources list in Outlook’s/O’WA’s Global Address List.
- In the GAL,you can filter by recipient type:
- for LRC resources, especially other than rooms, it is easier to filter by name(all LRC resource names start with “LRC”) – the result,
LRC Outlook/Exchange 2010 Resource Calendaring: How to cancel meetings in OWA
- View instead a short screencast how to cancel meeting requests in OWA.
- Or: You start out with a meeting request conversation like this, showing:
- a request send from account LRC help (example)
- an accepted meeting response from the resource (e.g. the room) account
- to cancel that meeting, you can go to your (!) calendar in OWA,
- select (click on) the meeting and choose “delete”
- either from the context menu after right-click the meeting
- or from the ribbon after selecting the meeting
- if the meeting was repeating/recurring, you will be given the option to
- either from the context menu after right-click the meeting
- select (click on) the meeting and choose “delete”
- you can also just open the meeting and choose from the top menu the “Cancel meeting” button, then press menu button: “Send update”:
- After the cancellation has gone through, this is how the results will look like in the e-paper trail:
LRC Outlook/Exchange 2010 Resource Calendaring: How staff view resource “Calendars from your organization” in OWA
- Note: Students that have not been specifically invited to share a calendar, must use (staff may also) this approach to view calendars, to avoid a permission problem .
- Staff can load resource calendars, but as somebody who books the resource (except where you still cannot book/schedule/sign up: Tutors), you normally neither need nor want to (unless you manage the resources).
- To preview the free/busy schedule of the resource, use the scheduling assistant instead.
- To make sure that you have booked the resource, load your OWN calendar instead: Since it is you who “meets” with the resource, your meeting will be reflected on there. If you also loaded the resource’s calendar, you would see your “meeting” twice. A meeting always appears in the calendar of all “participants” – only that, other than for resource calendars, you normally do not view the calendar of the other participants who are “human resources”(or maybe you are, at least in the scheduling assistant, but not with details beyond “busy”).

- You may want to load the resource calendar to learn details about the other “meetings”of the resource (e.g. which conflicting meeting organizer you can contact in an emergency, or to know how many tentative meeting requests are already pending for a tutor). Below is how:
Our Office 2010 & Office365/Live@Edu/Live not yet @Edu/Ninermail Upgrade: A running log
- Just logging some notes, observations, issues, step-by-step instructions…
- Office 2010ff install (office2010-full-install-labadmn.wmv [all links are to the folder only, choose screencast by name):
- 0:00-2:00: you can easily install Office 2010 from the ISO file without physical CD media, if you first install the free Magic Disc, then from the system notification tray, mount the ISO file to the , open the pseudo-drive from Explorer, which starts the installer through Autorun
- 2:00-4:00: since we do not want frozen imaged lab computers to ask for the installation media “on first run”of Office features, we choose button:customize, tab:installation options: “run all from Computer” (top – level selection is sufficient, rest of video is looking around), then button:upgrade
- Lots of waiting ensues…
- At the end, 28:55, “Microsoft office professional plus 2010 encountered and error during setup”, also the installer complains once about another instance running, then 38:12 asks for rebooting,
- Office 2010 first run (office2010first-run-excel-web-app-test.wmv):
- after reboot, the installation seems to have completed
- changing Office update policies seems to be not allowed
- file /save&send / save to web / windows live / log in / browse to a folder / give a filename:
- type something, save and exit
- in web browser, open windows live:
- log in, go to menu:SkyDrive, browse to the folder, find the file, click on it to view in browser,
- from top menu, choose edit in browser, type something, save,
- from top menu choose edit in excel, wait for download to open, type something, save&close,
- go back to web browser, open the update document from the right users (lab staff).
- sharing with windows live
- first uncc-LRC needs to make some friends:
- eventually, we want the staff of the uncc-LRC be able to use these online extensions of the most common tools in our work environment, MS-Windows and MS-Office. For this, we need to wait until live@edu/ninermail is up, so that we can invite lab staff using their @uncc.edu email addresses
- for testing purposes, I have invited myself and the lab coordinator using their personal Hotmail/live addresses
- friends need to accept the invitation email – and even on Hotmail/live mail, look for them in their Junk mail folder (this has been one of the unresolved mysteries of inter-office politics at Microsoft since at least 2007).
- second, in SkyDrive, share your files with these friends, and with the right permissions
a sharing policy, per folder, needs to be decided upon - uncc-non-secure permissions: all view, friends edit:
- uncc-secure-settings: only friends view and edit (shall we limit editing to some friends? permanent staff?)
note that some granularity of permissions is already supported, like
- folder:”secure”- “friends”:”can add,edit,delete”
- folder:”secure”- “friends”:”can read”
- folder:”secure”- “some friends”:”can add,edit,delete”
note that you can give read, but not write access to files beyond the circle of your friends (“friending” within the organization should, however, become are more acceptable option when/if live@edu will allow for @uncc.edu accounts, and interesting, since it offers disintermediation for office network admin tasks).
you can add files through a standard web-interface, or a more advanced Active-x control (looks like your mileage may still widely vary outside of Internet Explorer which is even more confusing when the ActiveX interface is offered in Firefox, but shows glitches). Note, however, that opening a local file in Office 2010 and save&share to SkyDrive is more attractive – however, will you in MS-Office see the folders that are merely shared with you to add to? Does not look like it. Stay tuned…
. one can still upload the spreadsheet from the web browser, then, also from a web browser, click “open in excel”. From then on, one can open it ore easily from the excel File / history shortcut. I am still working on figuring out how to map SkyDrive folders to local drives (it worked for one set, but other mappings run into problems: Is this because MS allows only one windows live identity to be mapped to your local windows account?) - To publish (possible embed in a web page) spreadsheets with Excel Web App, you can choose:
- SkyDrive menu: add files
- add an existing file
- or SkyDrive menu: “new”
- Excel web app ribbon menu: “Open in Excel”
- Copy/Paste your content and Save, Close
- Excel Web app menu “
Share”/ “Embed”:i - Adjust your options in this sharing dialog:
- To embed, take the html-code (you can increase the max width beyond 640 outside of this dialog) and paste it into your web publishing program
- Gotcha: To be embeddable, the spreadsheet needs to be in a public folder, or else:
- To move the file, use the “move”option in the file details pane to the right:
- This setting should make it work:
- And interestingly, it does, automagically: You do not have to update the embed code. It seems the link within the embed code goes to a “file” which has the “folder” it is in not as a path (in the link), but as an attribute:
- To move the file, use the “move”option in the file details pane to the right:
- SkyDrive menu: add files
- to share a file: Examples for MS-office live file collaboration
- MS-Excel
- Do not use the “embed” link from SkyDrive, e.g. https://r.office.Microsoft.com/r/rlidExcelEmbed?su=10634757809471938&Fi=SD25C841818181C2!133: this opens in read-only even if I am logged in (in Firefox and in Excel)( as a friend with editing rights)
- use the “edit” link from SkyDrive, e.g https://skydrive.live.com/edit.aspx?cid=0025C841818181C2&resid=25C841818181C2%21133: “edit in browser” attempts first opening in browser (Firefox – not asking for permissions, since I am logged in as friend with editing permissions), unsupported features redirect to excel 2010, opening in “protected view“ – but can enable editing.
- Note that when opening in excel 2010, you lose the concurrency that excel web app offers – thus, only 1 LRC assistant can have the online spreadsheet open to make update to the film collection (we have one barcode scanner equipped PC only anyway, so use this one for editing the film-collection.xlsx)
- MS-PowerPoint
- here is a folder link from where you can click on ""open in PowerPoint":
https://skydrive.live.com/redir.aspx?cid=0025c841818181c2&resid=25C841818181C2!115 - this may take time:
- here is the ""edit in browser"" link https://skydrive.live.com/edit.aspxcid=0025C841818181C2&resid=25C841818181C2%21146
- here is a folder link from where you can click on ""open in PowerPoint":
- MS-Excel
- to delete a file on SkyDrive:
- in detail view, hover over the file row
- click on the blue info button at the right end of the file row
- in the property pane that opens up on the right, click “delete”.
- MS-Word
- Just in case you were wondering about the underlying WEBDAV: You cannot paste the “open in word” link into a MS-Word 2010 file open dialogue (you used to be able to paste WebDAV links form the Blackboard Content System into MS-Word’s File-Open, but those were fully qualified URIs to MS-Word-files without JavaScript trickery), or else:
- As of 9/27/2011, I also now managed to get in to SkyDrive with my university credentials, for how, see here: Skydrive@uncc.edu
- first uncc-LRC needs to make some friends:
- Natural language features testing in MS-Office 2010 is being logged here.
Calendaring: How students can view the LRC schedules
- As of Fall 2011, this is obsolete. View instead the new and improved procedure.
- Calendars you can subscribe to:
|
Ind.Instr.Spanish |
webcal://calendars.office.microsoft.com/pubcalstorage/6d826ffz2216669/COED_434-Tutoring-Spanish_Calendar.ics |
|
Tutors French |
webcal://calendars.office.microsoft.com/pubcalstorage/6d826ffz2216669/COED_434-Tutoring-French_Calendar(1).ics |
|
Tutors Russian |
webcal://calendars.office.microsoft.com/pubcalstorage/6d826ffz2216669/COED-434-Tutoring-Russian-2_Calendar.ics |
|
Tutors Portuguese |
webcal://calendars.office.microsoft.com/pubcalstorage/m8qcbqfz1289583/COED-434-Tutoring-Portuguese_Calendar.ics |
|
Tutors Japanese |
webcal://calendars.office.microsoft.com/pubcalstorage/m8qcbqfz1289583/COED-434-Tutoring-Japanese_Calendar.ics |
|
Lab Assistants |
webcal://calendars.office.microsoft.com/pubcalstorage/6d826ffz2216669/COED_434-Lab_Assistants_Calendar.ics |
|
Director Free/Busy |
webcal://calendars.office.microsoft.com/pubcalstorage/m8qcbqfz1289583/Plagwitz_Thomas_Calendar.ics |
- How?
“You can subscribe to published calendars if you use a program that supports the WebCal protocol, such as Outlook, Windows Live Calendar, Google Calendar, or Apple iCal” (MS-Office online Help), as well as Yahoo Calendar.
Is Windows Live Calendar available to everyone with a Windows Live ID?
Yes, the Windows Live Calendar is available to all Windows Live ID accounts. To learn more about setting up and maintaining your calendar, open Windows Live Calendar Help. (Microsoft Live Services for Moodle User FAQ)
Windows Live ID = UNCC Live@edu ID
Using the “webcal://”-links (to be posted also on the LRC website), students will be able to view live LRC schedules from live@edu (and many other applications that support the iCalendar format, like listed on
http://blogs.office.com/b/microsoft-outlook/archive/2007/08/08/publishing-a-calendar-using-office-online.aspx or here):
-
Application
Publisher
Open Source Applications Foundation
Novell & GNOME
Facebook.com
Google
iCal and iCal Server
Apple Computer
The Kontact Team
IBM
Microsoft
Microsoft
Microsoft
Microsoft
Sun
Zimbra
-
How to set this up, taken from the Windows Live help:
-
Sign into Windows live (or later live@edu) with your Windows live (or later live@edu) ID.
-
On the toolbar, go to Calendar.
-
Click Subscribe.
-
Select Subscribe to a public calendar, and then, in the Calendar URL box, paste the “webcal://” link from the LRC website for the tutoring hours or other LRC schedule that you want to keep an eye on. You begin the link either with “webcal:” or “http:”. Note, however, that trying to subscribe to “webcalS” will result in this error:

-
In the Calendar name box, type a name for the calendar.
-
Next to Color, select a color for the calendar.
-
Click Subscribe to calendar, and then click Done. Result:
- This calendar will be live, i.e. every subscriber will see any updates the LRC makes (like for late-breaking changes and cancellations of tutoring hours). Note however, that synchronization is not instantaneous. Give it up to 30 minutes, under normal circumstances.

