Office 365 Compliance

There are a lot of questions around how is Office 365 compliant with various Regulatory and Compliance needs. Following a nice table that explains this in detail.

 

Office 365 Compliance Table

Office 365 Compliance Table

Nilesh Mehta | CEO

NGenious Solutions Inc. | www.ngenioussolutions.com

Expert SharePoint Consultants

 

Office 365 – Access denied uploading files to master page gallery

Yesterday I received a distress call from a client stating they were not able to upload any html files or master pages. So we immediately jumped in to site permissions to see if the user had appropriate permissions. Interestingly user was site collection administrator and still could not upload files. He had been able to do so a few months ago. That means, something had changed with Office 365.

Upon some research online, I came across the following article:

https://support.office.microsoft.com/en-us/article/Turn-scripting-capabilities-on-and-off-1f2c515f-5d7e-448a-9fd7-835da935584f?CorrelationId=365c212d-8b7e-45b9-b285-84416dd95952&ui=en-US&rs=en-US&ad=US

How to disable scripting from the SharePoint admin center

How to disable scripting from the SharePoint admin center

Sounded bizarre on why the setting for “Custom script” would impact upload of a file, but decided to test it.

and voila!!! that’s what it was. After having to wait for about 12 hours, I was able to go and upload files to master page gallery again.

Love Office 365, but I hope Microsoft will be able to announce issues like this more proactively and provide better error message that help us understand how to resolve these issues.

Cheers,

Nilesh Mehta | CEO
NGenious Solutions Inc.
www.ngenioussolutions.com
www.ngenioussolutions.com/blog

Information about upcoming changes to SharePoint Online Public Website

Office 365 SharePoint online had a component built in that allow you to have one public facing web site that you could your for your business website (www.company.com). However, Microsoft will no longer be offering that functionality as of Jan 1st 2015.

It is disappointing to see that go away. It was never full fledged SharePoint functionality, but at least it meant that the small business could use the same platform for their public facing web site and their collaboration together. Looks like small and medium business will have to go back to finding other solutions to host their company web sites.

Like to support article: http://support2.microsoft.com/kb/3027254

Here is the content from the web site:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Starting in January 2015, Microsoft is making changes to the SharePoint Online Public Website feature. Exisiting customers of this feature will continue to have access for another two years. New customers who subscribe to Office 365 after the changeover date won’t have access to this feature. Moving forward, Office 365 customers will have access to third-party offerings that will enable them to easily integrate their public presence with their Office 365 service. More information about these solutions will be made available in January 2015.

Why is Microsoft making this change?

As part of the evolution of the Office 365 service, we periodically evaluate the capabilities of the service to make sure that we’re delivering the utmost value to customers. Although it was a difficult decision to discontinue the SharePoint Online Public Website feature, this change lets us focus on future investments while we broaden our partnership with industry leaders.

What does this change mean for existing customers of Office 365 plans?

Office 365 customers who currently use the SharePoint Online Public Website feature will continue to have access to the feature for a minimum of two years after the changeover date. Moving forward, customers will have the option to subscribe to third-party solutions for public website functionality. Customers should plan to move to one of these third-party solution within the next two years.

What does this mean for new customers of Office 365 plans?

Starting on the changeover date, we will no longer offer the SharePoint Online Public Website feature to new customers. New customers who subscribe to Office 365 after the changeover date won’t have access to this feature. Instead, they will have the option to subscribe to third-party solutions by using links from Office 365.

How will this change be communicated to Office 365 customers?

All Office 365 administrators who have provisioned SharePoint Online will receive a notification in the Office 365 Message Center.

Overview of third-party offerings

What are the third-party solution offerings?

Office 365 customers will have access to industry-leading tools and services that are provided directly from third-party solution providers for building and managing your online presence. We will provide more information about the third-party solutions in January 2015.

How does the new third-party solution offering compare to existing SharePoint Online Public Sites?

The existing SharePoint Online Public Website feature was designed for customers who need only a basic online presence. These new solutions will provide more robust tools and solutions that are required to deliver, support, and manage a fuller online presence.

Which countries and languages will be available?

We will provide more information in January 2015 about about the countries and languages that will be available.

Implications for new customers

Will the price for affected Office 365 offers be reduced?

No. This change is aligned with our commitment to deliver a superior productivity experience in Office 365. Therefore, the change won’t affect the pricing of Office 365. Third-party solutions, when they are available, will be offered at discounted pricing rates for Office 365 customers.

We will provide more information in January 2015 about third-party solutions.

Can I use other website hosting services or must I use the partners that Microsoft refers?

Yes. Customers can use any external website hosting service and aren’t limited to the third-party solutions that will be provided in Office 365. These particular third-party solutions, when they are available, will be offered at discounted rates to Office 365 customers.

Implications for existing customers

What is our guidance to customers for existing SharePoint Online Public Websites?

There is no immediate change for existing customers. Office 365 customers who currently use the SharePoint Online Public Website feature will continue to have access to the feature for a minimum of two years after the change. Moving forward, customers will have to plan to move to one of the third-party solutions offered or to a different solution of their choice.

When will the existing SharePoint Online Public Websites be discontinued?

Microsoft will support SharePoint Online Public Websites for existing customers for a minimum of two years after the change. As per our policy about disruptive service changes, we will provide at least one year of notice before we make any significant changes to the Office 365 service.

I currently use SharePoint Online Public Websites. How do I switch to one of the new third-party solutions?

We will provide more information in January 2015.

Will customers or users lose any content when they make the transition?

All content and data migration is currently a manual process to be completed by the customer. To avoid disruption and data loss, customers should back up all content and data from the SharePoint Online Public Website before they switch to any new solution or service. This will minimize potential disruptions.

We will provide more information in January 2015.

I have subscriptions to Office 365, but I haven’t provisioned SharePoint Online yet. Will I still have access to SharePoint Online Public Websites after this change?

No. If you haven’t used SharePoint online yet, the situation will be the same as if you were a new customer. To be considered as an existing user of the SharePoint Online Public Website feature and maintain access for two years after the changeover date, you must take action by the end of January 2015. Our guidance going forward is to use the third-party options after they become available.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Cheers,

Nilesh Mehta

Creation of quick alphabetical ladder in SharePoint

Output result:
We will be getting a filtered data like below, filtered on top of title starting with alphabet.
SharePoint View

OOB SharePoint View

Creation Process:

Step 1) Create a calculated column named <<Initial>> in the list having below formula:

=IF(OR(LEFT(Title)<”a”,LEFT(Title)>”z”),”other”,LEFT(Title))

Above formula, will extract initial letter from the title text.

SharePoint Filtered View

SharePoint Filtered View

Step 2) Create a ladder to show:

<table cellpadding=4 cellspacing=0>
<tr>
   <td><a href=”#” onClick=”showAll(); return false;”>All</a></td>
   <td><a href=”#” onClick=”setFilter(‘a’); return false;”>A</a></td>
   <td><a href=”#” onClick=”setFilter(‘b’); return false;”>B</a></td>
   <td><a href=”#” onClick=”setFilter(‘c’); return false;”>C</a></td>
   <td><a href=”#” onClick=”setFilter(‘d’); return false;”>D</a></td>
   <td><a href=”#” onClick=”setFilter(‘e’); return false;”>E</a></td>
   <td><a href=”#” onClick=”setFilter(‘f’); return false;”>F</a></td>
   <td><a href=”#” onClick=”setFilter(‘g’); return false;”>G</a></td>
   <td><a href=”#” onClick=”setFilter(‘h’); return false;”>H</a></td>
   <td><a href=”#” onClick=”setFilter(‘i’); return false;”>I</a></td>
   <td><a href=”#” onClick=”setFilter(‘j’); return false;”>J</a></td>
   <td><a href=”#” onClick=”setFilter(‘k’); return false;”>K</a></td>
   <td><a href=”#” onClick=”setFilter(‘l’); return false;”>L</a></td>
   <td><a href=”#” onClick=”setFilter(‘m’); return false;”>M</a></td>
   <td><a href=”#” onClick=”setFilter(‘n’); return false;”>N</a></td>
   <td><a href=”#” onClick=”setFilter(‘o’); return false;”>O</a></td>
   <td><a href=”#” onClick=”setFilter(‘p’); return false;”>P</a></td>
   <td><a href=”#” onClick=”setFilter(‘q’); return false;”>Q</a></td>
   <td><a href=”#” onClick=”setFilter(‘r’); return false;”>R</a></td>
   <td><a href=”#” onClick=”setFilter(‘s’); return false;”>S</a></td>
   <td><a href=”#” onClick=”setFilter(‘t’); return false;”>T</a></td>
   <td><a href=”#” onClick=”setFilter(‘u’); return false;”>U</a></td>
   <td><a href=”#” onClick=”setFilter(‘v’); return false;”>V</a></td>
   <td><a href=”#” onClick=”setFilter(‘w’); return false;”>W</a></td>
   <td><a href=”#” onClick=”setFilter(‘x’); return false;”>X</a></td>
   <td><a href=”#” onClick=”setFilter(‘y’); return false;”>Y</a></td>
   <td><a href=”#” onClick=”setFilter(‘z’); return false;”>Z</a></td>
   <td><a href=”#” onClick=”setFilter(‘other’); return false;”>Other</a></td>
 </tr>
</table>

Step 3) Add below simple JavaScript snippet, It will filter on click of letters:

<script language=”javascript”>
var strUrl = location.href;
var strFilterField = ”Initial”;
 function showAll()
 {
       if(strUrl.indexOf(“?”) > -1)
   {
     strUrl = strUrl.split(“?”)[0];
   }
   location.href = strUrl;
 }
 function setFilter(strValue)
 {
   if(strUrl.indexOf(“?”) > -1)
   {
     strUrl = strUrl.split(“?”)[0];
   }
   location.href = strUrl + ”?FilterField1=” +  strFilterField + ”&FilterValue1=” + strValue;
 }
</script>
Step 4) Finally, On click on alphabets data will be displayed:
Final Result in SharePoint View

Final Result in SharePoint View

Cheers :) Happy Coding \m/

Rupesh Singh

Use below source code to insert JQuery and SP Services from developer console:

Step 1) Open developers console tool from any browser and enter below scripts to register JQuery and SP Services.

var jq1 = document.createElement(‘script’);
jq1.src = “//ajax.googleapis.com/ajax/libs/jquery/1.10.2/jquery.min.js”;
document.getElementsByTagName(‘head’)[0].appendChild(jq1);
 var jq2 = document.createElement(‘script’);
jq2.src = “//cdnjs.cloudflare.com/ajax/libs/jquery.SPServices/2014.01/jquery.SPServices.min.js”;
document.getElementsByTagName(‘head’)[0].appendChild(jq2);

Step 2) Now, It will appear in page source:

 

Developer Console Toolbar

Developer Console Toolbar

Step 3) Now, you can use SPServices easily from developer console.

Use SP Services from console tool

Use SP Services from console tool

Enjoy Debugging :)

Cheers,

Rupesh Singh

 

Cannot read or write to SharePoint

Recently we were working at a client location and added a new search server to the farm. No issues there. Server was added to the farm over the weekend.

Come Monday morning, we start seeing that all of a sudden people cannot add or edit any data within SharePoint. We also found out that there was only one database in question, hosting a single site collection about 70 GB in size that was running in to issues.

When this generally happens we normally look at the database side to see if things are well. Most of the time the SQL Server is running out of disk space or the database is in read only mode, thereby not allowing users to add or edit data.

However, interestingly enough not the case this time. Nothing in the SharePoint logs either on why this wasn’t working properly. After scratching the heads for a while, we went back looking in to the database server and looked at the specific database that was causing issues. It seems that the database in concern was running in “SQL 2000 Compatibility” mode as opposed to running in “SQL 2005 Compatibility” mode.

As soon as we flipped it back to the SQL 2005 Compatibility mode, things started working properly.

Something new to know, right :)

Cheers,

Nilesh