Archive

Archive for the ‘e-infrastructure’ Category

Bugs in MS-Calendaranalytics?

  1. Is there an Off-by-1 bug in MS-Calendaranalytics pivot chart?
    1. I am hovering (as an example) over the first name in the upper list which displays the right name as tooltip, the first name in the second listimage
    2. I guess I could learn DAX to fix this one myself, but what I have found myself doing is copy/paste the legend control from underneath, which does not exhibit this apparent bug, as a screenshot over the wrong legend (Seems strangely inadequate!).
  2. Cannot run visual basic macro because of a syntax errorimageVersion 1 on Excel 2010 (64-bit) on Windows 7 (64-bit). Restarting (Excel/Windows) made this go away.
  3. This stopped working on load from one day to the next, without the file getting saved and updated in between: System.Runtime.InteropServices.COMException (0x80070490): Element not found. (Exception from HRESULT: 0x80070490)
    at Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IHostItemProvider.GetHostExtender(String extenderType, String extenderCookie, IntPtr& extenderObject)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.Office.Tools.IHostItemProvider.GetHostExtender(Type primaryType, String primaryCookie)
    at Microsoft.Office.Tools.Excel.ControlSiteImpl..ctor(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, UInt32 officeVersion, Control control, _OLEObject extenderControl, Boolean isDynamic)
    at Microsoft.Office.Tools.Excel.FactoryImpl.Microsoft.Office.Tools.Excel.Factory.CreateControlSite(IServiceProvider serviceProvider, IHostItemProvider hostItemProvider, String primaryCookie, String identifier, Object containerComponent, Control control)
    at Microsoft.Office.Tools.Excel.Controls.Button..ctor(Factory factory, IHostItemProvider hostItemProvider, IServiceProvider serviceProvider, String cookie, String extenderCookie, Object container, String identifier)
    at ExchangeAnalytics.Sheet4.InitializeControls() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 169
    at ExchangeAnalytics.Sheet4.Initialize() in C:\tfs\Exchange Analytics\ExchangeAnalytics\ExchangeAnalytics\What.Designer.cs:line 55
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.ExecutePhase(ExecutionPhases executionPhases)
    at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.ExecuteCustomization.Microsoft.VisualStudio.Tools.Office.Runtime.Interop.IExecuteCustomization2.LoadEntryPoints(IntPtr serviceProvider)

File renaming utilities

When working with foreign language (learning) digital media files electronic repositories, typical problems include having to:

  1. adding metadata information to the filename
  2. handling of foreign language characters in filenames across operating and file systems, including code pages

A good file renaming  utility can work wonders in such situations.

I have been using the excellent BRU (Bulk rename utility) for a while, and always liked its flexibility – which is apparent from in its (initially somewhat intimidating) UI:

Now I found to my surprise, and confirmed with the help of the support forum, that the foreign language character support is lacking from BRU’s Regular Expression implementation.

Enter Renamer, another file renaming utility, which features a stable and beta version, pdf documentation and a wiki.

As you can see in the following screenshot, Renamer makes it possible, using Unicode character codes in Regular Expressions, to replace e.g. all Mandarin characters in a filename.

Renamer also has in-built support for common tasks like cleaning up filenames by stripping common tags, transliterating foreign alphabets or adding file numbering (serializing).

Both utilities are free and highly recommended, but also see TBA:part II for limitations.

UPDATE:

image

Configuring UNCC staff (MS-Exchange 10) email on Android 4.1.2

Screenshot_2014-03-15-15-17-08Screenshot_2014-03-15-15-16-31

Screenshot_2014-03-15-15-19-37image

May come in useful not only during initial setup… I had trouble sorting out the webpages addressing different versions, and translating the picture-less instructions, an so have others when they come to the LRC  for help. May this help some.

Our Drupal now allows Add to Calendar links.

  1. Neat: Click on the calendar icon at the end of the date line:
  2. image
  3. When prompted, Click open (which will stat your default file association for ICS files, likely MS-Outlook):
  4. image
  5. if necessary, add a suitable reminder, and click””save&close”image
  6. Your appointment, with location, will be put in your calendar and come alive when you need the reminder(and where, if you connect your other, home and mobile devices to MS-Exchange): image
  7. But as of yet, not everybody seems to be using this handy facility (I find myself manually copying over info into manually created appointments).
  8. Unfortunately, this is still only a static ICS file, not a subscription which would be automatically updated in your calendar if the originator/organizer changes the schedule.

Why meeting organizers should cancel meetings from their calendar and not by email

  1. Because cancelling from the calendar like in video2 here sends  the meeting participants not only a (0)message, which includes a handy “Remove from calendar” button,
  2. but also – in case they fail to see the message – a (1) “Cancelled” indicator on their calendars,
  3. while third parties who want to schedule a meeting with the meeting participants, see those participants (including an Rooms that “participate”) as (2) free/available during the time slot of the cancelled meeting,
  4. as you can see in this example: image

Windows Live Writer can once again load more than 500 WordPress posts without “Invalid Server Response”

Evidence:

image

Version (recently updated – thank you! This bug bugged me a lot, I am chatty):Version 2012 (Build 16.4.3522.110). Not sure it is not server-related, but consider upgrading on download.live.com if you still see this error on the metaWeblog.getRecentPosts from XmlRpc server: image

Have patience if you see “No free/busy information could be retrieved” on Room mailbox

When trying to schedule a room, I am now seeing this: image

When ctrl-right clicking: image, I get this as my connection status:

image

Becomes available after a long while:

image

What can I tell my users how long is the wait currently usually is?

What a delegate in MS-Outlook/MS-Exchange is and does

  1. Definitions:
    1. I would say: S/he can act on your behalf, while you keep in the loop and others see who s/he is acting on behalf of which disintermediates (e.g. saves tags like “This message is sent on behalf of [you]”: The message will appear to originate from you, as it ought to – imagine e.g. that users want to search their email for “from:[you]”).
    2. Looking for guidance, I find Cornell.edu has generally good instructions for their similar Outlook/Exchange environment, so I also quote them:
      1. Just as an assistant can help you manage your paper mail, your assistant can use Outlook to act on your behalf”.
      2. “If your manager has granted you delegate access, you have the ability to act "on behalf of" him or her. Depending on exactly how much access they’ve given you, you may be able to respond to meeting requests, send out meeting invitations, and handle their email messages.”
    3. Find more information on delegates here for the source.
  2. Sounds interesting? Next steps:
    1. How you can set up a delegate
    2. what does the delegate see/do