Archives for January 2010

SharePoint 2010 Business Connectivity Services and Offline Synchronisation – Developer Video How-To

January 25, 2010 by Joel Jeffery

You can now find us on iTunes as “joelblogs tv” :o) and also on blip.tv.

Welcome to the second in my SharePoint 2010 series of how-to videos for developers. This one is all about Business Connectivity Services, the technology previously known as the Business Data Catalog.

The BDC in SharePoint 2007 was pretty cool. It allowed us to quickly create read-only forms from existing line of business, or back-end, systems. The technique also allowed us to index and then search data in these back-end systems in a structured way.

In this video, I’ll show how easy it is to work with SharePoint 2010 Business Connectivity Services. We’ll use SharePoint Designer 2010 to hook up with an old friend – the Northwind database – and bring a SQL table of Contacts into SharePoint.

We’ll also see how SharePoint does the hard work for us in creating not just read only, but all the CRUD operations – create, retrieve, update, delete. It also creates InfoPath and browser forms for us, without writing a single line of code. Lastly we’ll have a look at the offline functionality of the BCS and SharePoint Workspace, including the magic of conflict resolution.

SharePoint 2010 Business Connectivity Services – Developer How-To

SharePoint 2010 Solution Sandbox – Developer How-To

January 15, 2010 by Joel Jeffery

It’s been my pleasure over the last few weeks to teach SharePoint 2010 to an audience of developers for Microsoft during their Ignite event in Dublin.

One of my favourite features of the news development platform has got to be Sandbox Solutions and the User Code Service. This allows developers to write code, packaged up as a SharePoint .WSP solution, and deploy it at the site collection level in a security sandbox. This feature is aimed at hosted and multi-tenant SharePoint customers, and also the incredibly security conscious.

In this video walk through, I shows developers how to create a simple Microsoft SharePoint 2010 Sandbox Solution in Visual Studio 2010, I show what works and what doesn’t inside the Sandbox, and lastly how to write a custom validator for other developers’ solutions.

SharePoint 2010 Solution Sandbox – Developer How-To

#spthingaday

View on Instagram

Link to display lightbox

Instagram post 17912856886012897

#spthingaday 003 - Information Architecture. Folders are evil. Use metadata. #SharePoint, #Office365..
On a fileshare, all you have is path and filename. That's the only axis by which you can classify your stuff. So you nest folders, within folders, within folders. Then you pack the filename with extra bits of information - like the initials of the last editor, or the version number.
You don't need to do this in SharePoint. Use metadata.
Add columns to your libraries. Text columns, number columns, choice columns, managed metadata columns. Each file can have several of these values simultaneously. But a file can only live in one folder at a time.
Use metadata.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement

#spthingaday 003 - Information Architecture. Folders are evil. Use metadata. #SharePoint, #Office365..
On a fileshare, all you have is path and filename. That's the only axis by which you can classify your stuff. So you nest folders, within folders, within folders. Then you pack the filename with extra bits of information - like the initials of the last editor, or the version number.
You don't need to do this in SharePoint. Use metadata.
Add columns to your libraries. Text columns, number columns, choice columns, managed metadata columns. Each file can have several of these values simultaneously. But a file can only live in one folder at a time.
Use metadata.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement ...

14 0

View on Instagram

Link to display lightbox

Instagram post 17903287741076397

#spthingaday 010 - SharePoint Online. Modern Customisations. #SharePoint, #Office365.. If you're new to the SharePoint Modern UI, you might think "we can't customise this," or that they've closed the door on developers and power users.

While that may have seemed the case up until very recently, from November 2017 there have been some awesome changes to SharePoint Online that enable customisation - even if you're not a developer.

List and Library forms can now be customised in the browser to become PowerApps; cumbersome workflows can be replaced with Microsoft Flows and Flow Approvals; many JSLink and client side rendering customisations can be replaced with JSON Column Custom Formatting.

There's still a lot missing - and right now, only developers can fill in the blanks. Whilst you can still use SharePoint Classic pages for building search solutions, you'll need a developer if you want to build a Modern search experience.
Currently, we build ours using the SharePoint Framework to make Modern Web Parts that use the existing search and graph APIs.

Get in touch if you want to know more.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement

#spthingaday 010 - SharePoint Online. Modern Customisations. #SharePoint, #Office365.. If you're new to the SharePoint Modern UI, you might think "we can't customise this," or that they've closed the door on developers and power users.

While that may have seemed the case up until very recently, from November 2017 there have been some awesome changes to SharePoint Online that enable customisation - even if you're not a developer.

List and Library forms can now be customised in the browser to become PowerApps; cumbersome workflows can be replaced with Microsoft Flows and Flow Approvals; many JSLink and client side rendering customisations can be replaced with JSON Column Custom Formatting.

There's still a lot missing - and right now, only developers can fill in the blanks. Whilst you can still use SharePoint Classic pages for building search solutions, you'll need a developer if you want to build a Modern search experience.
Currently, we build ours using the SharePoint Framework to make Modern Web Parts that use the existing search and graph APIs.

Get in touch if you want to know more.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement ...

14 1

View on Instagram

Link to display lightbox

Instagram post 17909226352070174

#spthingaday 026 - SharePoint Server. Service Applications and MinRoles. #SharePoint, #Administration, #Architecture.. In a single server Farm, you might decide to have everything running on that one server.

On a multi-server Farm, services can be started or stopped on particular servers in your Farm to support scale out.

From SharePoint 2016 onwards, you can define MinRoles.
That's the smallest set of services that you require to be switched on for a tier of servers.
A MinRole can then be allocated to specific servers.
SharePoint now takes care of making sure the right services are started.

To load balance Services without MinRoles, you just start an instance of your Service on a new Server.

However, with MinRoles, you just need to associate your MinRole with the server.
SharePoint will then start and load balance the requisite Services without any further work on your part.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement

#spthingaday 026 - SharePoint Server. Service Applications and MinRoles. #SharePoint, #Administration, #Architecture.. In a single server Farm, you might decide to have everything running on that one server.

On a multi-server Farm, services can be started or stopped on particular servers in your Farm to support scale out.

From SharePoint 2016 onwards, you can define MinRoles.
That's the smallest set of services that you require to be switched on for a tier of servers.
A MinRole can then be allocated to specific servers.
SharePoint now takes care of making sure the right services are started.

To load balance Services without MinRoles, you just start an instance of your Service on a new Server.

However, with MinRoles, you just need to associate your MinRole with the server.
SharePoint will then start and load balance the requisite Services without any further work on your part.

#microsoft #microsoftoffice #microsoftsharepoint #microsofttraining #officetraining #freetraining #trainingvideos #contentmanagement #enterprisecontentmanagement ...

11 1