Category: IT Pro


After releasing of a series of Office apps for iOS such as Office365 Administration, PowerBI, Delve, Excel, Word, PowerPoint, OneDrive,…, As announced at the “Future of SharePoint” event on May 4th from Microsoft about they are working on the new SharePoint mobile app. On 21-Jun-2016, Office365 administrators got a official inform message about SharePoint mobile App for iOS release. With this app, Now you can untether and take your intranet with you in your pocket. Stay connected to important content, sites, portals and people from across your intranet while on the go. In the mean time, Microsoft is also working on Android and Windows Universal versions, which we expect to release before the end of this year. Below is some quick review about this product.

Avaialble for download
From 21-Jun-2016, the new SharePoint mobile app is available in the Apple App Store. It’s free download with your iCloud account.

IMG_1357.jpg

Cloud and Onpremise support
After download, You can install the SharePoint mobile app on your iPhone, iPad or iPod. You can then sign in with SharePoint Online or SharePoint on-premises (2103 & 2016 version support) from the welcome screen.

IMG_1377

Both SharePoint online and SharePoint Onpremise supported. 

The Sites tab
From this tab, SharePoint app list all sites that you visit frequently and sites you’re following. This sites come from different site collections. If you click on a site to see recent activity, recent files and the site’s assets (documents, lists, subsites, pages and more). If your webpage is not support to transfer to mobile view, you may got the unsupport message or you can change to desktop view by click on tool box menu at bottom.

IMG_1361

Access project site and check for all project document with mobile reable PDF and Office files. Vietnamese language was fully supported and display correctly.

You can also access left menu navigation and click on List menu to see all deployed applications as well as site content.

IMG_1368

Check for all deployed applications and site content

All SharePoint data were displayed as list view event if that application is standard list, Calendar, customized list, Links, or Tasks,… look like below

IMG_1370

Calendar with events were displayed as list view.

The Links tab
This tab list all sites which based on your permission or allowed for everyone in your company. If you are using Office365, this site come from available SharePoint site collection that created by SharePoint admin. For Office 365, I as expected for applications associated with subscription as such Microsoft Delve, Office 365 Video,… but I can not find them from list tab.

IMG_1381

Not much data for links and resources link SharePoint app – Links tab

The People tab
As a staff directory phonebook, but list tab only listed for people that you are working with such as your members, your supervisor or colleagues. By tap on a contact, you can see their personal info like Fullname, Jobtitle, Phone, Email,…

IMG_1379

People contact list and personal detail info

From the first look, this release of SharePoint mobile iOS app works well with Office 365 SharePoint Online. For SharePoint onpremise, administrator should improve functionality to make it compatible with SharePoint mobile app like resources as well as People directory. I didn’t test this app with SharePoint 2016. But from my point of view, this app bring to SharePoint users a good concept. While Microsoft improve this app and develop for Android and WinMobile, you can try to use it and give Microsoft your idea and feedbacks via:
User Voice: https://sharepoint.uservoice.com/
Twitter: http://www.twitter.com/SharePoint
Or you can email to me for helping on bring your idea to MVP community and Microsoft Product team.
Hoang Nhut NGUYEN
Skype: hoangnhut.nguyen
Email: nhutcmos@gmail.com

Office 365 users can now get started on the OneDrive experience on SharePoint Document Libraries.. This functionality was  launched into Office 365 libraries last week. The new menus for document are really what users have been seeing for years in their OneDrive and drives uniformity on SharePoint 2016. This new UI has been tested on OneDrive for Business and allows us to get a glimpse of the future plan for SharePoint.

Right now this function is optional to all business subscription, the new document library is actually turned offon  almost every sites automatically. Users can chose to utilize it in their respective groups then decide to revert it back or not after testing it it out. The new Office 365 menu sneak peek is available by clicking the “Check it out” button. Users can press the x to close it or check it out.

Continue reading

Recently I have the issue with Search Service Servicece Application on SharePoint 2013 onprimise. This issue make all Search Query webpart and any search feature on farm come to Unexpected error. From the Correlation ID,  ULS logs show the error message “Index lookup failed to work since no active index cell was available

After several hours investigated, the problem is recognized from Index Partition and SharePoint Search Host Controller service

Reason: The problem come from Search Service Application.
System have error with Index Partition components, so all content query from web pages and SharePoint sites can not render correctly to show.
To check this component, you can follow SharePoint Powershell script to check for Index Component State
PS > $ssa = Get-SPEnterpriseSearchServiceApplication
PS > Get-SPEnterpriseSearchStatus -SearchApplication $ssa -Text
screen0.png
Resolution: We tried to Reconfigure Indexing component from SharePoint Search Service Application and clean up error indexing content by following steps
Step 1: Check if Search Service Application Crawling and Indexing are Running or Paused.
You can run this command in the SSA management console to verify if the Search Service Application is paused.
$ssa.IsPaused() -ne 0
If ourput of this command returns False, the SSA is running. If this command returns True, the SSA is paused and you have to turn it to running. This article will tell you more about Paused reasons https://technet.microsoft.com/en-us/library/dn745901(v=office.15).aspx
Common error cases message: ‘Search Service Application’ is paused for with reason(s) other than Index Repartitioning.
If you don’t care about Paused reason, you can run below command try to force the SSA to resume:
$ssa.ForceResume($ssa.IsPaused())

If you still not get Resume SSA successful, just skip this step and go to Step 2

Step 2: Run Services.msc with Administrator permission and try to stop following services:
SharePoint Timer Service
SharePoint Search Host Controller
Step 3:  Delete all content of data directory from locationC:\Program Files\Microsoft Office Servers\15.0\Data\Office Server\Applications\Search\Nodes\[Hex ID\IndexComponentN\storage\data\* (noted that: If you installed SharePoint folder in other drive, just change C drive your your installed foder)

Then restart services “SharePoint Timer Service” and “SharePoint Search Host Controller”

Step 4: Reset Search Indexing content

  1. On the SharePoint Central Administration home page, in the Application Management section, click Manage service applications.
  2. On the Manage Search Applications page, click the Search service application for which you want to reset the search index.
  3. On the Search Administration page, under System Status, verify that the Administrative status of the Search service application is Running and not Paused.
  4. On the Search Administration page, in the Crawling section, click Index Reset.
  5. On the Index Reset page, verify that the Deactivate search alerts during reset check box is checked, and then click Reset Now.
  6. In the confirmation dialog box that appears, click OK to confirm that you want to reset the index.

Step 5: Start Full Crawl again.

Since we reset indexing conten, you need re-run full craw to make Search Service App crawl all configured content to make search data available

After finished steps, Search Topology should be works fine with green check as below

screen01.png

 

Root cause: The problem may come from Windows Update on Jan 2016, so SharePoint server was automatically run Windows update and installed for many packages from Microsoft. It may impacted to SharePoint Search Service and Index partition was interrupted.
screen1.png

Early of this morning 25/08/2015 in Vietnam time, Microsoft was introduced and public download for SharePoint Server 2016 Preview version. You can now download from SharePoint Download with trial product key for 6 months using NQTMW-K63MQ-39G6H-B2CH9-FRDWJ

I just download and setup it in Azure A3 Virtual Machine 7GB, 285GB Hard disk. It’s may lower than Microsoft’s recommendation for hardware requirement https://technet.microsoft.com/library/cc262485(office.15).aspx, but I would like to try host a single installation (DB + SharePoint) in one standalone server to see how on performance.

Continue reading

This is my presentation on LIFTIT. The topic is focused on: What are BI tools? Which options for Office 365, SharePoint online and features that enables you to find and visualize data, share discoveries, and collaborate in intuitive new ways. We will go throught Business intelligence capabilities currently supported in Office 365.
Business Intelligent in Office 365 PresentationBusiness Intelligent in Office 365

Business Intelligent in Office 365_2

Download Business Intelligent (BI) for Office 365 presentation

Hoang Nhut NGUYEN
SharePoint MVP Vietnam
Skype: hoangnhut.nguyen

Last month, I have worked on a requiremnt with public webiste which using Office 365  SharePoint Online and allow anonymous user submit/add data to a specific list.

As your know, When you enable anonymous access to a Web site, you allow anonymous users (and authenticated users who have not been granted access to the site) to browse the entire Web site, including any list, library, folder within a list or library, list item, or document that inherits its permissions from the Web site.

The issue come from Anonymous cannot submit a Contact Form or a Registration form. That mean, in technically, we can not save information to SharePoint for further requirements.

But happy to know that, there is a customized sandbox solution Wsp365.Anonymous.wsp to allow Administration grant Add/Edit permissions to Anonymous user for any custom list.

You can download the solution here, or codeplex, then upload it to https://yourpublicsite.sharepoint.com/_catalogs/solutions/Forms/AllItems.aspx, Active it.

Back to your list, your will see a new ribbon button.

anonymousaccess

Then you can grant appropriate permission as your expect

anonymousgrantaccess

 

Cheers,

Hoang Nhut NGUYEN

Last Friday, Microsoft announced about discontinued for Autohosted app model at http://blogs.office.com/2014/05/16/update-on-autohosted-apps-preview-program/

The program will officially end June 30, 2014 and if you have developed an Autohosted app,

So Microsoft encouraged you to move it to a provider hosted app model instead.

From the beginning, there are 3 types of application hosting In SharePoint 2013

  • Autohosted
  • SharePoint Hosted
  • Provider Hosted

apps

Incidentally, If you look for information on MSDN on Autohosted apps, you’ll see the following error:

image_thumb26

The goal of the Autohosted app model was to provide an easy way for developers to provision Azure resources such as web sites and SQL databases when deploying their custom apps.

Hoang Nhut NGUYEN

SharePoint is growing in VietNam, in 1 month, I met 2 CIO and 1 CEO in banking and reseller business domain. They are planning to build up a collaboration platform for their company. A frequently question but important was placed  – “Should we go with SharePoint on-premise or Office 365?”

In this post, I want to focus some limitations of SharePoint Online that I think they’re important to consider before make decisions

1. Storage

iStock_000006910539Small

Microsoft offer 3 packages with differences storage capability

– SharePoint Online for Office 365 Small Business
– SharePoint Online for Office 365 Midsize Business
– SharePoint Online for Office 365 Enterprise, Education, and Government

But in generally, let’s make a simple calculation for 10 users which suitable for these 3 packages

  • Team site storage = 10GB + 0.5GB per user
  • Public web site storage = 5GB
  • OneDrive for Business = 10 x 1TB = 10TB (Microsoft just upgrade OneDrive for business from 25GB to 1TB. And please keep in mind that OneDrive will be used for individual people, that mean you can not share it to any team site)
  • Maximum file size you can upload to SharePoint Online can be configured is 2GB per file.

2. Synchronization

onedrive

OneDrive (SkyDrive old name) can be synced with your desktop version. That mean from your desktop, you can configure to sync your folder with OneDrive as well as a Team Site library. And there are some numbers would be reminded:

  • Can not sync >20,000 items in both SharePoint Online Team Sites + OneDrive
  • Can not sync >5,000 items from SharePoint Onnline Team Sites Library

3. SharePoint Online Site Collection

When you buy a package of SharePoint online as mentioned above, you will get a Site collection with sites/subsites hierarchy. It’s designed numbers of site collection, sites/subsites for your package:

  • Small Business: a single Team Site Collection.
  • Midsize Business plans: limits 20 Team Site Collections.
  • Enterprise, Education, and Government:  limits to 10,000 Team Site Collections.

In all options, just single Public Web Site Collection can be created, 1TB for My sites, 2000 site/subsite per site collection

4. Development Limits

bigstockphoto_Construction_

Sandbox Solutions was designed to allow SharePoint developer can customize/develop on Office365/SharePoint Online. Some important limitation you have to consider when go with online solution

  • No access to file/folder. It mean you can not use IO API commands
  • Only be deployed at a site collection level scope (not farm scope)
  • No access to web.config
  • PDF Documents cannot be opened in the browser
  • Restrictions to access security
  • Cannot overuse system resources
  • Limited Server Object model http://msdn.microsoft.com/en-us/library/gg317460(v=office.14)

5. Connection

20131223091152-scitech87

Most important is the availability and stability of Vietnam connection to Office365.  We have faced with severals of time that we dropped connection by optical cable issues with providers in VietNam. All data will be difficult to reach and very slow connection to download/upload files. If you are decision maker, keep it in mind for the backup connnection solution. Your business in the cloud and make sure it’s always stay in touch.

Hoang Nhut Nguyen
Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen

Last week, I got some questions from SharePoint administrators which related to their users access SharePoint server from external connection but they can not see some contents.

And another questions on how to secure access connection to SharePoint server with https access, so any messages send and receive should be encrypted.

Actually, for the first concerns, we need make sure that SharePoint external mapping configuration must be setup correctly beside DNS configuration. And in another hand, external connection should be secured via SSL certificate with https access. This is the second concern. In this post, I will show you how to get it done and meet your expectation.

Creating Self-signed SSL certificate:

For https configuration, we need order a publish SSL certificate from SSL certificate provider such as VeriSign, GeoTrust, CyberTrust, … Or issued by themselves for their hosting domain.

On development/Intranet servers we can use Self signed certificates. By default, Self-signed SSL Certificates have expiry date of 1 year. You can further provide custom parameters to SelfSSL.exe and generate Self-signed SSL certificates.

Steps to Create Self-Signed Certificate:
1. Logon to your Web Front End Server

2. Click on the Start menu >> Administrative Tools, and then click on Internet Information Services (IIS) Manager.

3. Click on the server in the Connections column on the left, Double-click on Server Certificates.

4. In the Actions column on the right, click on Create Self-Signed Certificate…

ServerCertificates

5. Enter any friendly name (e.g.  “Intranet Certificate” and then click OK.

IntranetCertificate

6. This will now create a New Self Signed Certificate valid for 1 year listed under Server Certificates. The certificate common name (Issued To) will be the server name.

ListOfCertificates

Edit the Binding of the web application in IIS

1. In the IIS Manager Console: Expand the Server and Site nodes and click the website you want to assign the certificate to. Click on Bindings… in the right column.

EditBinding

2. Click on the Add… button in Site Bindings dialog box

Add

3. Change the Type to https and select the SSL certificate that you just created. Click OK.

Change

4. Now, you will see the binding for port 443 listed. Optionally, you can remove the HTTP binding in order to tighten the security. Click Close.

Binding

We can force the website to use ONLY HTTPS protocol by selecting SSL Settings of the website and then choose “Require SSL”

RequireSSL

 

 

Configure Access Mapping from SharePoint Administration

1.       Go to Alternate Access Mappings: Central Administration >> Application Management >>Alternate Access Mapping.

Access Mapping

2.       Select the web application in the right most drop down and click on “Add Internal URLs”

SelectWebApp

3.  Add a new URL with HTTPS, here I have added https://intranet.mydomain.vn and select a zone, here I have  selected Intranet zone. Then HarveyNash Intranet collection will show the list of URLs with zones.

AddUrl

 

For the external connection like Internet, just repeat step 2, 3 with corresponding  URL.

Hope it help!!!

Hoang Nhut Nguyen

Email: nhutcmos@gmail.com

Skype: hoangnhut.nguyen

One day, after the sweet dream, you come to the office and your intranet gone away. Do you ever have to face before?

– Your SharePoint server is interrupted and cannot wake up again

– Hard disk can not be recover or take a long time to get data back

– No data has been backup or it’s very old

– All daily working data are storing that intranet and can not access anymore

– BODs are crying or shouting and your mobile phone ringing

– …

Don’t let it happen for you. In this article, I would like tell you the backup and recovery strategy which I was archived for SharePoint farm in my company. Let’s see the below content.

Part 1 – STRATEGY OVERVIEW
1. Why backup SharePoint data
2. What data will be protected
3. Pros and Cons
– Farm Command Line Backup
– SQL Backups
Part 2 – FARM BACKUP AND RESTORE
1. Back up farm
2. Restore farm
Part 3 -. CONTENT DATABASE BACKUP AND RESTORE
1. Backup Content Database
2. Restore Content Database
Part 4 -. BACKUP SYSTEM FILES
1. Backup System Files
2. Restore System Files

Hoang Nhut Nguyen

Email: nhutcmos@gmail.com

Skype: hoangnhut.nguyen

%d bloggers like this: