Articles about European Sharepoint Hosting Service
Posts tagged sharepoint hosting

European SharePoint 2013 Hosting :: Resolving The Business Data Connectivity Metadata Store is currently unavailable
Jun 18th
Trying to create a external content type by using the Microsoft SharePoint 2010 Designer I got the error “The Business Data Connectivity Metadata Store is currently unavailable”
Cause
This was caused by the fact that I had installed a “PowerPivot” SharePoint 2010 installation and during the installation you do not run the SharePoint 2010 Configuration Wizard.
Solution
First ensure all update are installed, by using Microsoft Windows Update, then go to the Microsoft SharePoint 2010 Central Administration page and click on Configuration Wizards:
Run the wizard, make sure the Business Data Connectivity Service is checked.
After running this wizard I still got the same exception, this was caused by some services where not running, check if all services are running: Central Administration > Manage services on server:
After starting some services, see screendump the error was resolved

Europe SharePoint Server 2013 Hosting :: How to Setup Managed Metadata Service Application on SharePoint Server 2013
May 13th
In this post I will tell you how to configure Managed Metadata Service Application on SharePoint Farm. The Managed Metadata’s primary purpose is to provide you with a central location to store metadata (commonly defined as data about data) that can be utilised throughout any site within your SharePoint farm.
Here we start configuration of metadata server.
1) Open Central Administration, Go to Application Management >> Manage Service Application >> Click on New >> Select Managed Metadata Service.
You can give name to service whatever you want, I’ve given “Managed Metadata Service” for more clarity.
and Database name as Managed_Metadata.
Give AppPool name “SharePoint – Managed Metadata Service”
I’ve used svcMetadata service account for Application Pool Identity.
Click on OK.
Once the service is created you can see it listed on Managed Service Application Page.
Now we need to start Metadata Service from SharePoint Services on Server page.
for that go to Central Panel >> Under System Settings >> Manage Services on the server.
Start “Managed Metadata Web Service”
Go back to Manage Application Service and Open Metadata Service Application
This will launch the below screen which is referred to as the Term Management Tool.

European SharePoint 2013 Hosting :: Using Metadata and SharePoint Search in SharePoint 2013
Feb 27th
Over time, we quickly realize that knowledge can be difficult to find within an organization. Having a dedicated knowledge repository can be very helpful, but the true knowledge in your company usually goes beyond a dedicated place to store articles and documents. SharePoint is great for capturing knowledge through documents, blogs, wikis, discussion boards, social newsfeeds and other content, but this knowledge often gets lost over time, especially as new content is added throughout your environment. How do we harness this knowledge so that it becomes more relevant and useful for the users of your system?
One of the key foundations to a good knowledge management system in SharePoint is the definition of content types and managed metadata. This provides a global structure that can be used across your SharePoint environment and provides consistency when searching for information in SharePoint, no matter where your content lives.
Using Enterprise Keywords is an easy way for users to tag content with Metadata that doesn’t fit in the structured taxonomy. Using the Managed Metadata Service, these Enterprise Keywords can easily be moved into the formal taxonomy if and when it makes sense.
To pull all of this content together, SharePoint Search can be used to return content from across your organization into a single location. The search results page allows users to further refine their results using both your structured and non-structured metadata. A simple example of this may be in finding all training documents related to a particular topic, no matter which department they originated from.
Tapping into the knowledge of the people within your organization can provide amazing benefits. Users can complete their SharePoint profile in order to manually add skills and experience that is relevant to their job. SharePoint Search can use this information to return the relevant people for your query.
Search in SharePoint 2013 can also determine the relationship between people and the documents they have authored, making it even easier to find the right person with the skills or experience you are looking for without the need for users to keep their profile constantly up to date.
SharePoint Search out-of-the-box will provide some ranking of the results based on relevance. With some additional configuration, search can provide very specific ranking for your organization. This may be based on the age of the content, the feedback (ratings) of content received by peers, the source of the content, or even the popularity of the content.
With some initial planning and configuration, users can see the true potential in using SharePoint for finding knowledge throughout the organization.

European SharePoint 2010 Hosting :: Microsoft Office and SharePoint 2010 Collaboration
Feb 26th
Of the Four Promises of SharePoint – 1. Enable Collaboration, 2. Manage Information, 3. Automate Processes and 4. Manage Business Performance – SharePoint provides many capabilities for 1. Enabling Collaboration.
When collaborating on a document, it is common to email that document to one or more colleagues to update. However, it can get very confusing determining who has the most up to date version of the document or how to reconcile updates across all the emailed versions.
The first step towards a more efficient collaboration is to work on the same content stored in a central location. However, only one person can make their updates at a time. You might be familiar with this type of SharePoint collaboration that uses the check in and check out document feature within SharePoint document libraries. This process fine for infrequently updated documents, but it can be inefficient when you have to wait for another person to check in their document before you can make your edits or on the occasion when that person might forget to check the document back into the library altogether.
You can come closer to a real-time collaboration by scheduling a virtual meeting with virtual meeting software like Microsoft LiveMeeting or GoToMeeting. However, this is not truly real-time collaboration since only one person can physically be in control of updating the document over the virtual meeting.
So how can you achieve true real-time collaboration while leveraging your current Microsoft Office and SharePoint infrastructure?
The current version of SharePoint 2010 (and SharePoint Online on Microsoft Office 365) and Office 2010 provide co-authoring capabilities for real-time collaboration. SharePoint 2010 Office Web Apps provide online versions of the popular Office applications of Word, Excel, PowerPoint and OneNote.
If you open an Excel spreadsheet or OneNote in Office Web App stored on SharePoint 2010 document library, the Office Web App will also allow your colleagues to open the same file at the same time via Office Web App to make updates. When others join, you will see a notification that they have joined in editing the document at the same time.
When using the Office Web App for Excel, the quantity of editors is indicated in the lower right corner of your status bar. Click on the down arrow to view editors by name.
If you and your colleagues have the Office 2010 desktop applications, you can also co-author Word, PowerPoint and OneNote documents stored in a SharePoint 2010 library. When they make updates, you will see their changes highlighted with their initials.
Number of editors is visible in bottom status bar in Word 2010 desktop application. Click to view editors by name.
To enable this capability within the documents of a SharePoint library you will need to:
- Either enable SharePoint 2010 Office Web Apps within SharePoint 2010 (or SharePoint Online on Microsoft Office 365) or have the Office 2010 desktop applications installed
- Store the Office documents within the SharePoint 2010 document library**
- Enable Contribute or higher permissions for the participants to update documents within the SharePoint 2010 document library
- Turn off Check In/Check Out capability in the document library
- If you are collaborating with OneNote notebook documents, turn off document versioning (or limit it to a limited number of major versions)
That is it! You can start achieving true real-time collaboration with your colleagues.

European SharePoint 2013 Hosting :: SharePoint 2013 Project WebPart
Feb 14th
This article is about the Project Summary webpart in SharePoint 2013.
Introduction
The Project Summary web part in SharePoint 2013 displays the events and tasks. By default this web part will be available in the home page of the project sites. In this article I will create a new page where I will add the Project Summary web part. I have created the following tasks list in the site.
Tasks List
I have a tasks list named Tasks that has the following tasks (Task, Task5 and Task3 are added to the timeline):
CustomTasks List
I have one more tasks list named CustomTasks that has the following tasks and the tasks that are added to the timeline:
Create a new page
1. Add a new page for the Project Summary web part.
2. Click on “Add a page”.
3. Enter the page name and then click on “Create”.
4. Click on the “Insert” tab in the ribbon interface and then click on “Web Part”.
5. Click on “Content Rollup” in the “Categories” section then select “Project Summary” and then click on “Add”
6. A Project Summary web part is added successfully.
7. Edit the web part in the web part properties; select the Primary Task List as Tasks from the drop down, under the Headlines section,ensure the Timeline, late and upcoming options are selected.
8. Click on Ok.
Project Summary web part
1. Once the Project Summary web part is added you can find the following details in the web part:
2. The left side web part will display the countdown to the closest due date for the task.
3. Next to the countdown, the web part displays the timeline if there are any tasks added to the timeline and if the timeline check box is selected in the web part properties.
4. In the Tasks list that we have selected as the primary task list, a few tasks (Task, Task5 & Task3) are added to the timeline, so the timeline is displayed next to the countdown.
5. A few tasks are not added to the timeline; those are displayed as late (Task2) and upcoming (Task4).
6. If none of the tasks are added to the tasks list or if the Timeline option is not selected in the web part properties then you will be able to see only the late and upcoming events in the web part.
7. To view the late and upcoming tasks, click on the next button in the top right side.
Include Lists in Late and Upcoming panel
1. We can include the other lists to include the late and upcoming events & tasks panel.
2. Navigate to the page where we have added the Project Summary web part.
3. Edit the page and then edit the web part.
4. In the web part properties click on edit link that is available next to the late option.
5. Select the other tasks list that must be added in the late panel.
6. Click on Ok.
7. Similarly click on the edit link that is available next to the upcoming option
8. Select the other tasks list that mut be included in the upcoming panel.
9. Click on Ok.
10. Click on Ok in the web part properties window.
11. Save the page.
12. Now we are able to see all the late & upcoming events in the web part as shown in Figure below
Thus in this article you have seen about the Project Summary web part in SharePoint 2013.
Europe SharePoint Server 2013 Hosting :: Comparison Between SharePoint Excel 2010 with SharePoint Excel 2013
Dec 1st
In this post, I want to show you the different between Excel Services in SharePoint 2010 with Excel Services SharePoint 2013.
SharePoint Excel Services 2012
Excel Services 2012 in Microsoft SharePoint 2012 is a tool that allows users to share data-connected Excel and PowerPivot workbooks to the SharePoint 2010 or SharePoint 2013 site. SharePoint Excel Service s 2012 enables you to publish Excel 2010 workbooks, manage and share them according to your business needs and allow users to render these Excel workbooks in browser.
SharePoint Excel Services 2012 overview
SharePoint 2012 Excel Services are usually used as a business intelligence tool which enables connecting Excel workbooks to external data sources, create reports and them publish these workbooks to a SharePoint document library. If the external data connection is established all the data refreshes while rendering the Excel workbook in a browser and this allows broad sharing of reports. Additionally a bit of companies can provide such great feature as auto-refresh data.
SharePoint Excel Services 2010 features
SharePoint 2010 Excel Services consists of Excel Calculation Services, the Excel Web Access Web Part, and Excel Web Services for programmatic access. They provide the following capabilities for users:
- set the settings for security, load balancing, session management, memory utilization, workbook caches, and external data connections;
- define which document libraries are trusted by Excel Services and store workbooks with their global settings in those locations;
- use an extensive list of trusted data providers and add your own ones to it;
- add own user-defined function assemblies.
Users can take advantage of SharePoint Excel Services 2010 in the following scenarios:
- Users can save Excel 2010 workbooks or PowerPivot workbooks to a SharePoint 2010 document library to give other users browser-based access to the server-calculated version of the Excel workbook. It
s could be possible to sort, filter, expand, or collapse PivotTables, and pass in parameters the Excel-based data. Users don
t need to have Microsoft Excel 2010 installed to view the Excel workbook. They will always view the latest version of an Excel workbook, and they can interact with it in a browser. And, additionally administrator can set security permissions to limit what access is provided to which user. - Users can build business intelligence (BI) dashboards by using Microsoft Excel 2010 and SharePoint 2012 Excel Services together with the Excel Web Access Web Part and use Microsoft Excel workbooks as a data source in PerformancePoint Services can.
- Users can use Web-service – based interface with the server in addition to browser-based interface. A published Excel workbook can be accessed programmatically by any application that uses Web services. Using that interface the web service applications can change values, calculate the workbook, and retrieve the updated workbook according to the security permissions set for this workbook.
- Users can easily build reports. When data-connected workbooks published in the SharePoint 2010 site and they are available through SharePoint Excel Services 2010, you can share reports that you have created in Microsoft Excel 2010 throughout the organization. This is one of the most useful features of SharePoint 2010 Excel Services.
Compare SharePoint Excel Services 2012
All these great capabilities which were available with the Enterprise edition of SharePoint 2010 are still available in the Enterprise edition of SharePoint 2013.
Excel Services 2013 updates
Microsoft SharePoint 2013 introduces the new capabilities in SharePoint Excel Services and new enhancements to existing technologies:
- SharePoint Excel Services 2013 lets users create a new kind of user-defined functions (UDFs) —ECMAScript (JavaScript, JScript) UDFs. Such UDFs run either in a Microsoft Excel 2013 workbook that is hosted in an Excel Web Access Web Part on SharePoint 2013 or in an embedded on a host webpage workbook.
- New SharePoint 2013 Excel Services Interactive View which generates Excel table and chart views on-the-fly, in the browser, from an HTML table hosted on a web page using HTML, JavaScript, and Excel Services. This new Excel Interactive View allows you to use the analytical power of Excel on any HTML table on any web page without having Microsoft Excel installed.
- Microsoft SharePoint Enterprise 2013 now uses the Open Data Protocol (OData) to get information about Excel Services 2013 resources in addition to REST API which were introduced in SharePoint Enterprise 2010.
These new capabilities will certainly make your development efforts much easier.
So, if you have interested with Business Intelligence or SharePoint Excel Services, please visit to the company site to get more details about the pricing, plans of the hosted Excel services page.