I added a new user to my existing subscription, but my subscription end date shifted by less than a year. What happened?

Every user in a subscription must have the same end date. Adding a user license to an existing subscription will license the new user through the original expiration date of the subscription. Any additional time will be applied to all existing user licenses, and will extend the subscription’s overall end date.

For example, customer has an Office 365 subscription with 100 seats. However, in month 10, customer adds 100 additional seats. The expiration date for all 200 seats is now 5 months past the expiration date of the first 100 seats. The calculation is as follows: (100 seats x 10 months) / 200 seats

Capture

 

How to rename Status Approval column?

In many projects we have the same request from end users: “To rename Status Approval column”. As you already know, this column is not visible in List Settings and therefore it cannot be changed as many other columns. But here is a simple trick:

  • Open “List Settings” and edit some column (eg. Created)
  • In the address bar at the end of URL, you will see the field name (&Field=Author)
  • Replace this value with &Field=Status%Approval
  • Hit enter and you will get the edit field for existing label
  • Change and confirm!

01.10.2014? New Office 365 plans will be available

On October 1, 2014, Microsoft will release three new Office 365 plans tailored to meet the needs of small and midsized businesses (SMBs), ranging from 1 to approximately 250 employees.

The new plans are:

  • Office 365 Business – The full Office applications – Outlook, Word, Excel, PowerPoint, OneNote and Publisher, with 1TB of OneDrive for Business cloud storage to access, edit and share your documents across your Windows PC, Mac, iPad, Windows tablet and smartphone.
  • Office 365 Business Essentials – The core cloud services for running your business – business class email and calendaring, Office Online, online meetings, IM, video conferencing, cloud storage and file sharing and much more.
  • Office 365 Business Premium – Get everything from both the Office 365 Business and Business Essentials plans.

July-9_image-1

This new lineup will replace our current plans for SMBs over time – Small Business, Small Business Premium and Midsize Business (more on that below). The current Enterprise plans will remain the same.

How to disable Sync Button for SharePoint Document libraries

By default, OneDrive for Business is used to sync the documents of a SharePoint document library down to local computer for offline access. Any user that has access to the document library has the option to Sync one or more libraries. In some cases company rights and policies request to disable this option for all users. If you log into your SharePoint site, and click on a document library, you should see a Sync button on the top right corner.

 

Sync

 

 

If you want to hide that button, or just disable in global settings, you need to click the gear in the top right and go to Site Settings. Choose link that says Search and offline availability.

 

You will see a line that says Offline Client Availability, and set the the option to no, then hit OK

 

That’s it.

Uptime table

Availability % Downtime per
year
Downtime per
month
Downtime per
week
90% 36.5 days 72 hours 16.8 hours
95% 18.25 days 36 hours 8.4 hours
97% 10.96 days 21.6 hours 5.04 hours
98% 7.30 days 14.4 hours 3.36 hours
99% 3.65 days 7.20 hours 1.68 hours
99.5% 1.83 days 3.60 hours 50.4 minutes
99.8% 17.52 hours 86.23 minutes 20.16 minutes
99.9% 8.76 hours 43.8 minutes 10.1 minutes
99.95% 4.38 hours 21.56 minutes 5.04 minutes
99.99% 52.56 minutes 4.32 minutes 1.01 minutes
99.995% 26.28 minutes 2.16 minutes 30.24 seconds
99.999% 5.26 minutes 25.9 seconds 6.05 seconds
99.9999% 31.5 seconds 2.59 seconds 0.605 seconds
99.99999% 3.15 seconds 0.259 seconds 0.0605 seconds

Unlicenced O365 product with red bar notification?

You have activated O365 paid licences, but after some time red bar notification is present in all Office applications? Let me explain the easiest way to fix that problem:

  1. Close all Microsoft Office applications
  2. Run Word as “Administrator” (right-click and choose Run as admin)
  3. Navigate to File > Account > User Info and choose “Sign out”, then “Sign In” again
  4. Restart Word

How to wrap menu items in SharePoint 2013 global navigation?

This is a quick post to show the code snippet I used to wrap the global navigation items in SharePoint 2013. You can also use custom CSS code in order to get some space between navigation lines and items. First, open default masterpage of your site collection and find the following:

<SharePoint:AspMenu
   ID="TopNavigationMenu"
   Runat="server"
   EnableViewState="false"
   DataSourceID="topSiteMap"
   AccessKey="<%$Resources:wss,navigation_accesskey%>"
   UseSimpleRendering="true"
   UseSeparateCss="false"
   Orientation="Horizontal"
   StaticDisplayLevels="2"
   AdjustForShowStartingNode="true"
   MaximumDynamicDisplayLevels="2"
   SkipLinkText="" />

and replace with the code below:

<SharePoint:AspMenu
   ID="TopNavigationMenu"
   Runat="server"
   EnableViewState="false"
   DataSourceID="topSiteMap"
   AccessKey="<%$Resources:wss,navigation_accesskey%>"
   UseSimpleRendering="false"
   UseSeparateCss="false"
   Orientation="Horizontal"
   StaticDisplayLevels="2"
   AdjustForShowStartingNode="true"
   MaximumDynamicDisplayLevels="2"
   SkipLinkText=""
   ItemWrap="true"
   RenderingMode="List" 
   cssClass="mycss"/>

As you can see, the only diference is:

ItemWrap="true"
RenderingMode="List"
cssClass="mycss"

Create custom CSS file with the following content:

.mycss .level1
{
margin-left: 10px;
margin-right: 20px;
}
.mycss .level2
{
margin-left: 10px;
margin-right: 20px;
}
.mycss .level3
{
margin-left: 10px;
margin-right: 20px;
}

How Office 365 manages DNS records for mail service?

When you set up Office 365,  you might have a choice between managing your own DNS records at your DNS hosting provider and having Office 365 create and manage the DNS records for your domain.  I definitely recommend letting  your existing hosting provider or domain registrar to manage your records, because in case you decide to host MX records outside of Office 365 , it will not be possible. Simply, you can’t change your DNS records to host email outside of Office 365.

Enable XML attachments on Exchange Online

    1. Right click on the PowerShell Console icon and chose the option: Run as administrator.
    2. To change the Execution policy open the Microsoft Online Services Module for Windows PowerShell and type the command:
      Set-ExecutionPolicy unrestricted
    3. For creating the remote connection we will need to use  a set of three PowerShell commands. Each command perform different task and include variable that serve as a “container” for information such as: user credentials, URL etc. Execute the following command: 
      $cred = Get-Credential
      $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://ps.outlook.com/powershell/ -Credential $cred -Authentication Basic –AllowRedirection
      Import-PSSession $Session
    4. A pop out windows will appear. Type your credentials by using the UPN (user Principal name) format. User should have global administrator rights in the office 365 environment. To view all the allowed file type, you can use this command:
      (get-OwaMailboxPolicy OwaMailboxPolicy-Default).AllowedFileTypes
    5. To allow a specific file type (such as .xml file), use this command: 
      Set-OwaMailboxPolicy OwaMailboxPolicy-Default -AllowedFileTypes  @{add= '.xml'} Get-OwaMailboxPolicy | Set-OwaMailboxPolicy -BlockedFileTypes @{Remove = ".xml"}
      Get-OwaMailboxPolicy | Set-OwaMailboxPolicy -AllowedFileTypes @{Add = ".xml"}
      Get-OwaMailboxPolicy | Set-OwaMailboxPolicy -BlockedMimeTypes @{Remove = "text/xml", "application/xml”}
      Get-OwaMailboxPolicy | Set-OwaMailboxPolicy –AllowedMimeTypes @{Add = "text/xml", "application/xml”}
    6. Disconnect the remote connection with the following command:
      Remove-PSSession $Session