Two interesting SharePoint 2013 Features

This shouldn’t count as a post, but just digging around SharePoint 2013 preview to see what’s new.

Rating settings now includes Likes as well as Star Ratings

Advanced settings now allows the ability to Reindex list

Changes changes. Interesting.

“Send” emails to a SharePoint Task List

A colleague and I were looking to have a quick way to manage tasks between the two of us. We had previously just used email. But since most of our workload is using SharePoint, we figured we’d drink our own medicine and see if we could improve the workflow.

Things we wanted to accomplish:

  1. a running history of all of our tasks in SharePoint
  2. quick access (no filling out forms online)
  3. be able to assign tasks to each other
  4. save emails as attachments of tasks, to track requests as they come in

Setting up a task list in SharePoint is quite straightforward, but making it easy and fast to manage took a little bit of thinking. Luckily, everything can be done out of the box, and I’ll show you how here.

Step 1 – Setup the task list

Go to Site Actions > More Options and create a Tasks list.

I created a few views of my tasks and put them on my dashboard so we can see all our active tasks, and the tasks we’ve recently completed.

Step 2 – Connect to Outlook

Go to your task list and click Connect to Outlook in the ribbon. You’ll be prompted (most likely) with several alerts asking you to confirm the connection. After that, if you go to Tasks in Outlook you’ll see your connected SharePoint task list right beneath your local task list. You can create tasks just like you would normally do in Outlook, and they should sync with the SharePoint list.

But that only got us halfway there. All of our requests come by email, so we wanted to avoid re-typing each task. We wanted a way to “send” the email into the task list.

 

Step 3 – Copy emails to the task list

Problem solved! Right click on the email you want to use to originate a task and click on Move > Copy to Folder

A window will come up with all of the options of where you can copy the email. If you scroll to the bottom of the list you should see a folder called SharePoint Lists. Expand that folder and you’ll see your SharePoint task list that has been connected to Outlook.

Click OK and a new task window will pop up with the body of the email in the task description. You can assign the task to yourself or anyone else that has access to the SharePoint list. Also, just to confirm you are assigning that task to the shared list, look in the footer of the window and you should see something to the effect of: In Shared Folder: SharePoint Tasks.

BONUS: If you want to save an email that has an attachment, first double-click the email message to open it in a new window. From there, if you follow the above steps of moving it to the task list folder, it will save the email message as an attachment to the task, including all attachments in the email itself.

How to import Data into SharePoint 2010 using Lightning Tools Data Masher

This post will cover how to import data into SharePoint 2010 from your database using Lightning Tools Data Masher.

Step 1 – Activate Feature

Make sure the Data Masher Menu Items feature is activated in your site features.

Step 2 – Create a new import

Next, click on Site Settings > Create Data Masher Import

Step 3 – Settings

Now for the fun part!
Input the connection string to your database and click Connect to Data Source. At this point, more options will appear below. Choose your table from the database (in my case it’s a community directory SQL view).
Next, give the import a title and description (both are required).
Then choose whether to create a new list from this import (easiest way) or to import the data into an existing list (more tricky, as you have to map each column). If you choose to create a  new list, your list will have the name of the database table you are importing. Choose the columns you would like to import by CTRL + clicking each column name.
Finally, choose how frequently you would like your list updated and click Save.

Step 4 – Results

If everything was successful you should be presented with a list (after the job runs the first time…which may not be immediate) that has all of your freshly imported data.

SharePoint Question: Global Navigation

Ok, this is less of a “how-to” and more of  ”how-to?”

I have a requirement to create a global navigation with each parent item also being the first child in its drop-down menu.

Here’s the site structure:

  • Grade 1 Team Blog
    • Homeroom 1-1 Blog
    • Homeroom 1-2 Blog
  • Grade 2 Team Blog
    • Homeroom 2-1 Blog
    • Homeroom 2-2 Blog

And I want the menus to look like this (bit of a strange requirement, but the claim is that people will not know the parent item is an actual blog):

  • Grade 1 (links to Grade 1 Team blog)
    • Grade 1 Team (also links to Grade 1 Team blog)
    • Homeroom 1-1
    • Homeroom 2-2

Any thoughts?

SharePoint Themes (free and premium) @NBBranding

Looking for master pages & themes for your SharePoint 2010 installation? While still in its infancy, check out nothing but branding. A collaboration between Mark Miller of EUSP and GSoft Group, this site covers branding of SharePoint in their blog, while selling premium (and a free one) themes for SharePoint. It seems like a promising project, and I’m looking forward to seeing where it goes.

Celebrating 100 downloads of SP Document Navigator!

I’m happy to announce that in the first month of SharePoint Document Navigator‘s life it has seen over 100 downloads on CodePlex! It’s been really interesting to watch people use and improve on the original code. I’m eager to improve on the first release, and am looking forward to hearing more and more feedback on the solution.

If you’ve used SP Document Navigator for a project and want to share with the world, let me know!

Launch of new SharePoint 2010 public-facing website: International School of Beijing

Greetings from China, where we’ve just launched a public-facing website built in SharePoint 2010! It is for the International School of Beijing, and was built in SharePoint so that the website and internal portal (one of my other projects) speak the same language. This will make for easier management, training, and usability for people who have already been using the school’s internal portal. It took us a while to get past a few glitches, but it’s finally out!

Visit the site now: International School of Beijing

Key elements of this site:

  • Custom publishing content type to keep things clean
  • Use of CQWPs on the home page to rollup slideshow images, as well as useful links at the bottom
  • Built with an HTML5 element’ed Master Page, and should be backwards compatible up to IE7
  • jQuery Cycle plugin used for the home page slideshow

So, it’s a fairly straightforward site, and of course could be accomplished without using SharePoint, but I’m proud of what came out in the end. It took a core team of 3 people to push it out the door, with a few more people involved in the planning and launch. This is the first step in a bigger re-branding project that the school is going through, so expect design changes to happen throughout the year.