Creating project schedule for team and keeping track of the progress can be a nightmare but Microsoft Project Professional and SharePoint online can give some relief. This post will walk-through creating a new Ms Project project schedule and publishing it to the SharePoint site for team collaboration and later to track the change or progress.

Create and save project schedule to SharePoint task list

  1. Open Project professional 2013 and create a new project schedule
  2. Add resources. Please make sure the resource name (either email or display name) is similar to your SharePoint user display name or email format. Add custom fields if required so that you can publish those to SharePoint from project and make them available to your audience.


create a project using Microsoft Project Professional
  1. Save the project to SharePoint online by selecting an existing site or new site. Once you click Save it will save and sync with project professional.

Save project to SharePoint Online

  1. Now go to the project site and navigate to the Task list, you will find the tasks there. Once you provide permission to this task list your team members can see the tasks assigned to them.

Synced project-professional tasks on SharePoint Site


Tracking Project Progress

You can track the task progress by opening the project using project professional and running reports but in this case I am going to track by setting up a baseline. To do so please follow the steps below,

  1.  Open your project in project professional and click set baseline.. from project>set baseline tab

Set Project Baseline


  1. Choose the baseline settings from the dialog box and click OK. Note: you can create multiple baselines in one project.

Baseline options


  1. Save and sync the project (you can create these steps 1-3 during creating the project schedule)
  2. Now update some tasks.

Update task from SharePoint


  1. Open the project in project professional and choose "Tracking Gantt" from the view. You can then see the critical task and the progress of other tasks.

Project with critical path and baseline



SharePoint Online supports creating multiple projects under one master projects and tracking the progress of that project. You can create views with filter to restrict viewing tasks from the unassigned users. And also you can use the reporting functionality of project professional to get the insight of your project. Project Online provides this capability as well as lots of other functionality requires to manage enterprise projects in a collaborative environment.

Thanks for reading.

Reference: Create or update a baseline or an interim plan

Migrating from Gmail and Google apps email to Microsoft Office 365 Exchange is a very common case while adapting the Office 365. Many subscribers of Office 365 face problem on how to do the migration including email contents, contacts and calendar entries; though there are lots of information available on the internet. My objective here is to show a very straightforward approach for migrate from Google to Office 365; please continue reading. The migration process demonstrated here was done in 3 steps:

Step 1: Migrate Email Contents using IMAP

Step 2: Export and Import Contacts

Step 3: Import Calendar Entries

Here we go with the first step.

Step 1: Migrate Email Contents using IMAP

  • Login to your Gmail account and go to Settings>forwarding and POP/IMAP; then Enable IMAP(leave the default options), Click Save Changes.

Google apps enable IMAP


Google aps and Gmail IMAP server settings

  • Finally choose the recipient of the migration report and Automatic or Manual starting option of this migration batch. It will start synchronization when you start the batch job.
  • Once the Sync is done the administrator will get a report of this migration batch. If you go to your office 365 Outlook you can see the migrated contents there.

Now that email content is migrated we need to migrate contacts and calendar entries.

Step 2: Migrate contacts

Export Contacts from Google apps

  • Login to your Google apps(or Gmail) account and choose contacts; you can find all of your contacts here.
  • Click More>Export
Export contact from Gmail or Google apps

Export contact from Gmail  and Google apps

  • Now select All contacts or the specific group that you want to export and import to office 365 account; and then choose the Outlook CSV Format, Click Export.
Export gmail or google apps contacts as CSV

Export gmail or google apps contacts as Outlook CSV format

Import contacts into Office 365 email account

If you want to import into individual account then follow these steps:

  • Open your Outlook Web App using a web browser and click the gear icon at the top right hand side (right beside your name) and click "Options"
  • On the default options window click "Import contacts from and existing email account"
Import Contacts to Office 365 email

Import Contacts to Office 365 email

  • On the import contacts window click browse and choose the CSV file exported from Google apps account, click Next. Once this step is done your contacts will be imported on your email account.

Step 3: Migrate Calendar Entries

Copy the iCalendar URL

  • Again login to Google account and switch to calendar tab from the top navigation.
  • Select Calendar Settings from the calendar that you want to export to Office 365
Google apps calendar settings

Google apps calendar settings

  • Now scroll the page and from calendar address section click ICAL to get the URL of this calendar. Copy the URL.
ICAL of Google apps

ICAL of Google apps

  • Setup Outlook 2013 desktop program on your computer, connect with your Office 365 account and sync with Outlook web.

Import calendar entries

  • Open Outlook desktop program and click File>Open& Export>Import/Export.
Outlook Import-export

Outlook Import-export

  • Then choose Import an icalendar(.ics) or vCalendar file (.vcs), click Next.
Outlook desktop import icalendar

Outlook desktop- import iCalendar

  • Paste the URL of the ICAL of your Google apps calendar on filename and click "Open". Outlook will prompt you whether you want to import this calendar items to your existing calendar or to create a new calendar; choose import option. And it will import the calendar entries to your Office 365 account.

    migrated calendar entry

    migrated calendar entry


Once migrated everything user can keep using the Office 365 for Email, Contacts and Calendar. For migrating more than 10 mailboxes there are other approaches and industry standard migration tools available to consider based on scenario and price. Hope this post helps.

By default SharePoint 2013 lists allow you to quickly edit items by clicking "edit" from the view without opening it.

Quick edit is enabled

Quick edit is enabled


Now, if you want to disable this function follow these steps:

  1. Go to the list settings> Advanced settings page
  2. Scroll down and Under quick edit options just choose "No" and then click OK.quick-edit-option-no
  3. Now the view will look like the following screenshot.
    Quick edit is disabled

    Quick edit is disabled

    Hope this helps.

Where to look for it?

In SharePoint 2013 the "Manage Content and Structure" link is removed from the "Settings(gear icon at the top right hand-side)" and placed under Site Settings> Site Administration section as "Site Content and Structure"

content and structure under site administration

Content and structure under site administration

SharePoint 2013 Site Content & Structure

SharePoint 2013 Site Content & Structure

Not available there?

By default it's not available (at Teamsite) until you activate the "SharePoint Server Publishing Infrastructure" site collection feature from Site Collection Administration.

SharePoint Server Publishing Infrastructure

Activate Feature SharePoint Server Publishing Infrastructure

Hope this helps.