Archive
Attachment is missing from an e-mail message #SharePoint #SP2007 #SP2010 #SP2013
At a client recently, we were having the issue of emails being sent to a list but the attachments were not appearing with the email.
In this scenario, it was working if we sent it directly to the list email address, but if we forwarded from Exchange via a contact, no attachments came through.
Anyway, it would appear the following needs to be set:
If attachments are missing from email messages that are sent to a SharePoint document library, it might be because you associated the document library with an email address. When you do this, Directory Management Service may not add the following two attributes to the user associated with the email address:
-
internet Encoding = 1310720
-
mAPIRecipient = false
- Full details are below.
Windows SharePoint Services 3.0 / Microsoft Office SharePoint Server 2007
- http://support.microsoft.com/kb/926891
- http://technet.microsoft.com/en-us/library/cc287879(v=office.12).aspx#section8
SharePoint Foundation 2010 / SharePoint Server 2010
SharePoint Foundation 2013 / SharePoint Server 2013
More #SharePoint / #ProjectServer 2010 Service Pack 2 details #SP2010 #PS2010
So I see my fellow bloggers Paul and Khurram posted about Service Pack 2 for SharePoint and Project Server 2010.
Having looked around the blog-o-sphere, I came across some extra information that I believe will be useful to all:
Known issues when you install Office 2010 SP2 and SharePoint 2010 SP2
http://support.microsoft.com/kb/2687520
In particular if you are installing Office 2010 SP2 on Windows Server 2003 (SP2) you will need to install this patch first: http://support.microsoft.com/kb/925336
For SharePoint Server SP2 on Windows Server 2008 R2, you need to be careful of your custom XSL views from SharePoint Designer. Apparently they break but the fix is already available and it is recommended to install the June 2013 CU (or later) on top of the SP2
Links for June 2013 CU for SharePoint 2010:
The Full Server Packages for June 2013 CU are available through the following links:
- Download SharePoint Foundation 2010 June 2013 CU
- Download SharePoint Server 2010 June 2013 CU
- Download SharePoint Server 2010 with Project Server June 2013 CU
After installing the fixes you need to run the SharePoint 2010 Products Configuration Wizard on each machine in the farm.
Locations of all the SP2 download packages around SharePoint, Project Server, FAST, Office Web Apps, Office 2010 products etc…
Next up is that we of course need to consider the different products that we have installed in our farms. Do we have FAST or Office Web Apps?
This link will help: http://support.microsoft.com/kb/2687522
Further links are available here, including Office, Project, Visio, SharePoint Designer and the CSOM binaries:
- http://support.microsoft.com/kb/2687521/en-us
- http://blogs.msdn.com/b/joerg_sinemus/archive/2013/07/24/sharepoint-server-2010-sp2.aspx
- I haven’t seen a service pack 2 for the language packs yet, but will update if it comes up soon.
Changes for SharePoint / Office 2010 SP2 that are not in Cumulative / Public Updates
Handily Microsoft have also released a spreadsheet detailing the changes and additions as part of Service Pack 2. Be aware that these are not included in any previous CU / PU.
http://support.microsoft.com/kb/2687453
Ok, hopefully you will all find the above useful. Till the next time…
DATEADD DAY parameters and the float based values #SQL #SSRS #SharePoint #CPSReportLink
Just a quick one. Recently bug fixing an issue with an SSRS report that calculated the date and time an SLA was due and highlighted fields accordingly.
The Setup
A choice field in SharePoint determining the expected SLA with values as follows:
- 0.5 days
- 1 day
- 2 days
- 3 days
- 5 days
- 10 days
- 15 days
- 20 days
- 30 days
- 60 days
- What I am trying to achieve
- The values are inside SQL (thanks to CPS ReportLink) as a string value but I need to work out based on a start SLA date and time, when the target SLA date and time is.
- So I need to strip “day” / “days”, convert to a float and then run a dateadd function to determine my target date.
- In SSRS we will then compare that to today and create a nice RAG indicator in some form or another.
- The Issue
- The DATEADD function doesn’t appear to like a float based number. In fact it rounded 0.5 down to 0 making the start date the same as the target date. This ultimately raised an issue in the UAT process I am going through today at a client.
The Original SQL
DATEADD(day, CONVERT(float, REPLACE(REPLACE(wss_SLA_String, ‘days’, ”), ‘day’, ”)), CONVERT(datetime,[wss_SLA Start Time_DateTime])) as [Target SLA Finish]
The Resolution
So given that I am on-site and the developers who created the SQL are nicely on holiday, I have had to roll up the sleeves and delve in.
So taking my developers original concept, rather than working with days, if we convert it down to hours, we get the desired result without any CASE co-fuffle in the SQL. (Co-fuffle – official word of the day @ SPandPS.com)
Update the stored procedure and bob’s your uncle, we are set and another UAT issue checked off the list.
The Updated SQL
DATEADD(HOUR, CONVERT(float, REPLACE(REPLACE(wss_SLA_String, ‘days’, ”), ‘day’, ”)) * 24, CONVERT(datetime,[wss_SLA Start Time_DateTime])) as [Target SLA Finish]
And lastly, a shameless plug
So how did you get SharePoint list data into a database for reporting without breaking the rules and going directly to the content database, I hear you ask…
Why I used CPS ReportLink of course.
It copies data from a list into a database and keeps everything in sync for easy reporting using the standard Business Intelligence tools provided as part of SharePoint (Excel Services, PerformancePoint etc…) / SQL Server (SSRS, PowerView etc…)
Full details here:
http://www.cps.co.uk/What-We-Do/Documents/ReportLink%20for%20SharePoint%20and%20Project%20Server.pdf
That’s it!, Keep SharePoint’n
#ProjectServer #PS2010 and #SP2010 Service Pack 2 Released #PPM
   I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
Service Pack 2 has been released for Office 2010, this includes Project Server 2010 and SharePoint 2010. For links to all Office 2010 SP2 updates see the office update site below:
http://technet.microsoft.com/en-us/office/ee748587.aspx
Project 2010 SP2: http://support.microsoft.com/kb/2687457
Project Server 2010 SP2: http://support.microsoft.com/kb/2687452
SharePoint 2010 SP2: http://support.microsoft.com/kb/2687453
For a full list of fixes, download the following Excel file:
For more information see the following blog post:
#ProjectServer #PS2013 / #PS2010 Last Modified and Last Published fields in PWA #SP2013 #PPM #ProjectOnline
|
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
A query that has been asked by several of our clients in the past is: “The last modified date field in PWA is not updating”. In most scenarios the Last Published and Last Modified fields will match in the Project Center as shown below:
This is because the Project Center views look at the published data and both these fields will get updated with a publish. If you modify (save but not publish) a project from Project Professional or PWA the Last Modified date will not update which may cause confusion. If you click the project to go to the project details you will see the status bar does show the correct Last Modified date:
Incorrect in the Project Center view:
There are scenarios where the Last Modified date will update and show a later date than the Last Published date, for example if you modify the project information then save the project:
To avoid any confusion to PWA users I would recommend not displaying the Last Modified date in Project Center views.
#ProjectServer #Excel report with SQL Temporary Tables #PS2010 #PS2013 #SQL
|
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
I came across an issue a while back and meant to blog about it but forgot until a colleague of mine today mentioned the same issue. This jogged my memory of the fix so I thought it was a good time to write the post. The issue isn’t Project Server related but the reports and queries we were creating were for Project Server.
If your SQL query in an Excel file uses temporary tables Excel will throw an error like the one seen below:
For the search engines the error is below:
The query did not run, or the database table could not be opened.
Check the database server or contact your database administrator. Make sure the external database is available and hasn’t been moved or reorganized, then try the operation again.
The error will occur if you have the select statement in the connection file definition command text or even calling a SQL stored procedure from the command text. The same fix applied to both, at the start of the select statement add “SET NOCOUNT ON” as shown below:
Now Excel will execute the query and return the data as expected. 
#ProjectServer #PS2013 Manage Alerts #SP2013
|
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
A question I see and hear quite frequently is “Where has Manage My Alerts options gone in 2013?”. These have now moved the the PWA Settings page:
The two links for Manage My Alerts and Reminders and Manage My Resources’ Alerts and Reminders only appear once the SMPT server details have been enabled for the PWA instance. When the PWA notifications are removed from the PWA instance the two links are removed:
To enable notifications and enter the SMTP details, navigate to the Project Server Service Application in Central Admin, click Manage from the drop down menu next to the PWA site:
Enable the notifications and enter the SMTP server details on the Alerts and Reminders page. Once set, the two Manage Alerts links will appear on the PWA Sever Settings page under the Personal Settings heading. These links are permission controlled though.
How to backup deployed solutions
Recently I had the need to backup all the solutions deployed to a test system before a code refresh, to achieve this I used the simple piece of PowerShell below.
$dirName = "C:\Solutions"
foreach ($solution in Get-SPSolution)
{
$filename = $Solution.SolutionFile.Name
$solution.SolutionFile.SaveAs("$dirName\$filename")
}
To run the PowerShell script simply create the folder c:\Solutions, or set another location in the script and run with Farm credentials or equivalent.
Happy SharePointing !
Business Intelligence in the cloud, phew thank goodness… #Office365 #BI #SharePoint #PowerBI
So the Worldwide Partner Conference is going on in Houston at the moment and as much as I would love to be there, unfortunately projects here in London have to continue. Still early starts and watching the world go by in Pret (coffee shop for those outside of the UK) is always interesting before the hub-bub of the day starts.
Anyway, as with every year at WPC, there are always exciting announcements and this year is no different. We can hail this as official business intelligence in the cloud day!
Now many of the projects I work on consider Office 365 as a platform, however the more enterprise you go, the more the requirements tend to need some level of business intelligence. I was excited before with the release of SQL Reporting Services Online, however as functional as it is, limitations and costs current pose this solution to be only for the fully cloud invested.
My new hopes for BI in the cloud however seem to be starting to be answered in the form of Power BI for Office 365.
Using the capabilities already available on premise (Data Explorer, GeoFlow, Power Pivot and Power View) with tweaking, some re-branding and a little bit of mobile love (mobile apps to be available also (Windows 8, RT and iPad, HTML5) it looks like we may have an answer.
This to my mind almost completes the Office 365 capabilities to truly propel the cloud for use in the projects I get involved in. (Project Management, Business Intelligence, Intranets, ECM solutions).
I urge you all to read up on the following and register for the preview coming “later this summer”. I have a feeling this is going to be major!
Details:
- Main Announcement Blog: http://blogs.office.com/b/office-news/archive/2013/07/08/announcing-power-bi-for-office-365.aspx
- What powers Power BI in Office 365 (O365 Blog): http://blogs.office.com/b/office365tech/archive/2013/07/07/what-powers-power-bi-in-office-365.aspx
- Introducing Power BI (SQL Server Blog): http://blogs.technet.com/b/dataplatforminsider/archive/2013/07/08/introducing-power-bi-for-office-365.aspx
- Register your interest here: http://office.microsoft.com/en-us/excel/power-bi-FX104080667.aspx
- Download the preview add-ins for Excel here: http://office.microsoft.com/en-us/excel/power-bi-download-add-in-FX104087144.aspx
- Tutorial: http://blogs.msdn.com/b/powerbi/archive/2013/07/07/getting-started-with-pq-and-pm.aspx
As I try things out, I will post my findings and any limitations I come across, but hopefully with the new OData / REST capabilities of Excel and SSRS, we should be able to have some fun with SharePoint list data!
Enjoy…
#ProjectServer #PS2013 #Excel Pivot Table limitation
|
I am a Project Server and SharePoint consultant but my main focus currently is around Project Server.
I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article) |
Just a quick post to highlight a limitation / issue with Excel Pivot Tables that I hadn’t seen before, details below.
This particular Pivot Table uses a Data Model that contains two OData feeds from Project Server 2013, one for Project details and one for Task details. The connections can been seen below:
The relationship has been set up as follows:
I have added Programme, Project Name, Task Name and Task Start to the Pivot Table. Programme and Project Name are from the Projects table and Task Name and Task Start are from the Tasks table. The Project Name is filtered to just one project:
Looking at the Pivot Table, it looks the CPS Test project has many tasks but in fact this project only has 4 tasks:
To resolve the issue you have to add a numerical field from the Tasks table to correct the aggregation:
Hope that helps 
SharePoint (and Project Server) Shenanigans 
You must be logged in to post a comment.