Resources For IT Professionals
Post an article
Wikis - Page Details
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Calendar Analytics for PowerPivot: Known Issues 2

Calendar Analytics for PowerPivot: Known Issues 2

Calendar Analytics for PowerPivot: Known Issues 2

This Wiki article documents some known issues with version 1.0 of Calendar Analytics.

There is a new Wiki article for version 2.0 Calendar Analytics.  The new Wiki article outlines new features, bug fixes, and Office 15 compatibility in version 2.0 found here: http://social.technet.microsoft.com/wiki/contents/articles/13338.calendar-analytics-for-office-15.aspx

You can download the latest version of Calendar Analytics from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=4c13a670-3356-4d4a-a24b-d33143004eb6

Table of Contents


"Exceptions downloading..." message box


ISSUE:
After clicking the Refresh Calendar button and walking through dialogs, a message box may appear after downloading calendar items:
"Exceptions downloading 3 of 427 meetings for: someone@extendedresults.com"

CAUSE:
The specified number of calendar items did not download correctly. Some unknown characteristic of the calendar item has caused Calendar Analytics to not download the item. One possible cause is that the calendar item does not have an Organizer specified, which is required by Calendar Analytics.

SOLUTION:
Click OK and continue by going to the PowerPivot tab and clicking Update All, and then go to the Data tab and click Refresh All. The specified number of meetings in the message box will not be included in the dashboard.


"The email address ________ is not the primary SMTP address." message box

ISSUE:
You entered in an alias in the Alias List dialog box, and when you click Next and the following error message displays

"The email address JohnD@somewhere.com is not the primary SMTP address."

CAUSE:
It is possible that the person that you entered has multiple email addresses.

SOLUTION:
Find out if they have an alternate email address, for example "John.Doe" rather than "JohnD".

User Feedback: I have both jane.doe@microsoft.com and janed as alias entered. No dice. Still returns either the message that my email address is "not the primary SMTP address" ...restarting computer didn't help.


Calendar Analytics fails to install after installation reboot

ISSUE:
You ran the CalendarAnalytics.exe setup program and prerequisites such as VSTO Runtime and .NET Framework has prompted you to reboot. After the reboot, an error message appears stating that Windows Installer cannot find the .MSI.

CAUSE:
In some instances, such as installing from a Shared drive or USB Drive, Windows Installer does not copy the .MSI to the Windows temp folder.

SOLUTION:
Re-run the CalendarAnalytics.exe setup program after the reboot.


"Days Out of Office" field on "What" worksheet is not accurate


ISSUE:
The "Days Out of Office" field on "What" worksheet does not always give the expected result.

CAUSE:
This field was misnamed. The appropriate field description is "Out of Office Meetings".

SOLUTION:
Select the cell with Days Out of Office and type "Out of Office Meetings".


ALERT: Incomplete Calendar Download


ISSUE:
You clicked the Refresh Calendar button on the What tab of the Calendar Analytics spreadsheet. You entered your email address as it is for the Exchange Server. You entered the the current month for your Start and End dates and did not enter any other alias. You then receive a box that the calendar download was incomplete and the following dates were skipped: all query dates are listed.

CAUSE:
There may be an issue with your Exchange Server 2010 and Exchange Web Services configuration.

SOLUTION:
Ensure that Microsoft Exchange Server 2010 is installed and configured correctly with Exchange Web Services. Please contact Exchange Server or Exchange Web Services support for assistance.



ERROR: Communication - Autodiscover service could not be contacted ...


ISSUE:
You entered your email address, checked the Office 365 box, and provided your password. After walking through the steps you received the error message "Communication - Autodiscover service could not be contacted..."

CAUSE:
There might be an issue with your Exchange Server 2010 and Exchange Web Services configuration.

SOLUTION:
Ensure that Microsoft Exchange Server 2010 is installed and configured correctly with Exchange Web Services. Please contact Exchange Server or Exchange Web Services support for assistance. You can also try installing Calendar Analytics on a different computer that is not on the same domain as your Exchange Server. For example, if you are @microsoft.com and your email address is an Office 365 account, try installing on a machine that is not on the REDMOND domain.



"Cannot implicitly convert type 'double' to 'string'." messagebox


ISSUE:
After clicking the Refresh Calendar button and walking through dialogs, a message box may appear while downloading calendar items stating: "Cannot implicility convert type 'double' to 'string'".

CAUSE: 
Excel is treating one of your "Categories" as a numeric data type rather than a string.

SOLUTION: 
Format all of the cells in the "Categories" worksheet as "Text" and try again.
, , , , , , , [Edit tags]
Leave a Comment
  • Please add 8 and 4 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 25 Jul 2013 12:10 PM

    Patris_70 edited Revision 29. Comment: deleted (en-US) title

  • 31 Mar 2012 5:23 AM

    Horizon_Net edited Revision 26. Comment: added language tags

  • 17 May 2011 10:43 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 24. Comment: Added entry for "Cannot implicility convert type 'double' to 'string'."

  • 17 May 2011 10:24 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 22. Comment: Added new entry for: "Cannot implicility convert type 'double' to 'string'."

  • 17 May 2011 10:24 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 23. Comment: Reverting to fix formatting.

  • 28 Apr 2011 5:57 PM

    Ed Price MSFT edited Revision 5. Comment: Removed white space mostly.

Page 1 of 1 (6 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 26 Apr 2011 4:38 PM

    Wow! Great job, Chris! Please write up any other insights from your CA+PP experience!

    Ed

  • Posted by
    on 28 Apr 2011 5:57 PM

    Ed Price MSFT edited Revision 5. Comment: Removed white space mostly.

  • Posted by
    on 4 May 2011 2:23 PM

    Regarding this issue noted above: "The email address ________ is not the primary SMTP address."  message box.  Using my internal email alias or external first.last@microsoft.com still gives me this error.  I'm on Direct Access, is that a restriction?

  • Posted by
    on 6 May 2011 4:11 AM

    Hi, this tool was exactly what i was lookking for, but even I have the "Incomplete Calendar Download

    " any sugestion on what to do?

  • Posted by
    on 8 May 2011 11:54 PM

    Pretty lame solution for the 'Incomplete Calendar Download'... :-/

  • Posted by
    on 17 May 2011 10:24 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 22. Comment: Added new entry for: "Cannot implicility convert type 'double' to 'string'."

  • Posted by
    on 17 May 2011 10:24 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 23. Comment: Reverting to fix formatting.

  • Posted by
    on 17 May 2011 10:43 PM

    Aaron Meyers [Extended Results, Inc] edited Revision 24. Comment: Added entry for "Cannot implicility convert type 'double' to 'string'."

  • Posted by
    on 19 May 2011 7:54 PM

    Agree with Tony Robyn "Pretty lame solution for the 'Incomplete Calendar Download' - I called tech support but that just made my phone ring :-(.

    Can you give us some detail on what versions/SP of Exchange this tool is known to work on ?. The download page specifies client side 9Excel 2010 etc) but not server side.

    We are in Aus, so would date/time settings on clients or servers have anything to do with it ?

    We have Exchange 2007 SP3 (Version 08.03.0159.002), Win7/Office2010 32bit.

    Any more clues / ideas welcome - I really want that graph of my meetings so i know how busy I am !

  • Posted by
    on 9 Jun 2011 12:40 PM

    Why does this required Exchange 2010 SP1 to work? I have Exchange 2007 and I get "The specified server version is invalid" from the SOAP call. In the packet it is sending <t:RequestServerVersion Version="Exchange2010_SP1" />

    Can't you add the version selection as a parameter?

  • Posted by
    on 8 Jul 2011 12:33 PM

    Please help, when I click "Refresh All in Calendar and Analytics Office365 enter my account and password, go to the Alias ​​field, always put anything and after that I try to connect and the following error appears:" Autodiscover service not be contacted . Please Ensures that you are connected to the Exchange by myemail@mydomain.com domain use, must share this email account and your Windows domain credentials "thanks!

  • Posted by
    on 31 Mar 2012 1:24 AM

    When people are tracking time what metric type to they need the most?

    When a contractor turns their time in every week what metric does the contract agency pay them off of?

    When a company ask you to assign your time to a project and they request you to track your time weekly what common metric type do they use?

    The number one most important results that anyone who is using any type of time tracking tool is?

    The answer for all these questions are the same:

    Total hours (Sum)for the time period requested under the pretty picture in the calendar tool under details!

    Next Question:

    Why would anyone in the details page add the totals from left to right to get the totals per day but not top to bottom to get the totals for the time period requested?

    How do you correct the mistake of this tool and add a permanent calculation that provides the totals for the time period on the details page under the pretty picture where it should be?

    I can get the totals from the power pivot in a new table….  This does not help me as I now have to do a bunch of manual work, copy paste, amateur nonsense as this is now turned to a manual tool.

  • Posted by
    on 31 Mar 2012 5:23 AM

    Horizon_Net edited Revision 26. Comment: added language tags

  • Posted by
    on 25 Jul 2013 12:10 PM

    Patris_70 edited Revision 29. Comment: deleted (en-US) title

Page 1 of 1 (14 items)