When I was designing my database structure I could not find the option to set an identity column. You can find this option in the Data Type properties:

Select the datatype (int) and click “Edit”.

Click the “Edit” button.

Select “Identity” and click “Ok” twice.

Share

This is the recap of the session of Olse Can Criekinge at SharePoint Saturday Belgium

What is Office365?

-          Exchange, Lync, SharePoint and Office in the cloud.

-          Part of the modern office

Do’s

-          Know what you are describing to.

-          Understand identities

• o   Cloud identities
• o   Federated identities

-          Adfs is more than federated users

• o   Enabled users to access spo and the onprem installation with same credentials

-          Is your organization ready for O365? Use the OnRamp tools

-          Check your network, check the network requirement documents online.

-          Check out Azure

-          Decide what you will do online and on premises

-          Need to connect with external users?

Don’t’s

-          Do not not look into O365

Share

• Migration
• Business driven

Different setups

• One way outbound scenario: the office365 cannot query the on premises setup.
• One way inbound scenario: SPO can query on premises environment through dmz.
• Bidirectional topology: both can query each other.

Building blocks

Share

• The Microsoft vision is to get the BI to everyone
• There a 3 kinds of BI:  personal BI (user context, local machine), team BI (team context, power users, SharePoint), corporate BI (org. Context, structured data models, dashboards, SQL Server)
• The focus in this session is on corporate BI
• Complex business logic and security
• Needs team of IT resources
• The data is king and must be accurate to be trusted by users.
• 
• the example uses a combination of PerformancePoint dashboard (the show the filters) and Excel services to visualize the data.
• The best tool for printing reports is SSRS.
• You can schedule the reports and receive then in you inbox daily for example.

This was a nice session with a real live example of using BI with SharePoint.

Share

• why you should create mobile sites? In 2013, now, more mobile devices Will Be visiting your website than desktop devices.
• how you can do this?
• You need to identify your content already in html
• Hide irrelevant content on mobile pages with css
•  There are two options: create other page for mobile or use media queries.
• you need to set device channels
• create masterpage, start from a minimal page not a blank page.
• with design manager link the masterpage
• only for publishing sites
• Design manager is the tool to brand your SP sites.

Responsive design?

• use media queries
• min. IE9 or use a js library for older browsers
• never use with but use max-with in your media query
• use the bootstrap cuss for responsive navigation

Share

Share

How can you organize your meetings now? Well you can use OneNote and a combination of a few lists. Let’s start.

First you create a new empty site (site actions > new site).

In this site you create a new custom list with the name “Meetings”. This list only have to contain one column: Title. In this list we will keep track of all the meetings on this subject.

Next we create a document library where we will store the OneNote notebook. To create a new notebook you launch OneNote and create a new notebook.

When you create a new notebook make sure you save it to the newly created document library on your SharePoint site.

Now it’s up to you to organize the notebook but I’ll prefer this approach:

• create a new section for each meeting instance
• create a new page in a section for each meeting agenda item
  • you can create additional pages and use the subpage option to arrange the page under the meeting agenda item page.

In the SharePoint site I also create a list “Agenda” where everyone (depends in the permissions of course) can add agenda items.

This is how we organize our meetings nowadays.

Share

In our code we used

Dim list As SPList = SPContext.Current.Web.Lists(listname)

to access the listitems. Although we run the code with elevated permissions we still connected to the list with the current user’s context. That was wrong. We had to create a new instance of SPSite (and dispose it of course!). That solved our performance issue, the code was not 250% faster and our users were happy.

Using adminconnection As New SPSite(SPContext.Current.Web.Url)

Do you want to know more about working with large lists? You can find some articles here:

• Manage lists and libraries with many items
• Designing large lists and maximizing list performance
• Working with Large Lists in SharePoint 2010 – List Throttling

Share

• a free workspace up to 5 users
• unlimited number of projects
• Version control (TFVC or Git)
• Work item tracking
• Agile planning tools
• Feedback management
• Build (in preview at the time of writing)
• Test management (in preview at the time of writing)

When I registered my code was already on a local installation of TFS so I had to move it to another space. I use a global Windows Account (company account) as administrator to do this. I move my files (using Visual Studio) with the Source Explorer. When I opened Visual Studio then next day I noticed that I was still connected to the TFS with the global (migration) account although I logged off and logged in with my personal account. Somehow Visual Studio remembered that initial account and connected with that one. Some googling learned me that the default account was stored into the Credential Manager. You can access that via the Configuration Panel.

I had to look for the right server entry in the Credential Manager and edit that value. Now my problem is solved and Visual Studio connects with the personal account to my TFS!

Share

The user wanted to collect some data in a list and send that input page to another user. We solved this with some basic InfoPath magic.

The list contains a few columns and one of them is a lookup column to a list that stores all the users that you can inform. That lookup lists also contains the name (title column) and email of each user.

To start we edit the list form in InfoPath:

In InfoPath, add a new field to the main data connection. I called this field “EmailStudent”

The next step is adding a button to send the email.

When we click the button I want to send the document to the email of the user that I’ve selected in the form. We do this by making a rule.

First we need to create a new data connection to send the email.

In the following screens you can add the email details. Select that you want to send only the current view. Not as attachments.

Now you can finish the rules:

There are 2 actions in the rule:

1. set the hidden field with the value of the email of the selected user.

The trick is to select the email field from the data source that contains the list of users.

2. send the form by email.

Now you have to click “ok” a few times to confirm the settings and you are ready to test the form.

This is the result after publishing the form to SharePoint is this:

When clicking the send button the server sends the email to the selected user.

Share