Category: End User


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

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

One month ago, I get a requirement from customer, they need receive email and stored to corresponding document library to SharePoint intranet. Then I thought about incoming email configuration and tried to set it up.

I found an article from Microsoft about step by step guideline to enable incoming email and sync out email to SharePoint with a dedicated email account http://technet.microsoft.com/en-us/library/cc287879(v=office.14).aspx

But when I go throught this articles, I recognized that it’s not easy as I guess and require that you need a power domain permission to implement some steps such as Setup SMTP Server and connect Directory Management Service….

Actually, I got 2 times at least about the question “How can I sync my email to SharePoint library?” from my buddy and colleagues. So I would like write an addins for Microsoft Outlook 2010 to adapt with the customer requirement and share this setup package + source code so that some body find and may be helpfull for you.

The setup package allow install a new tab in Oulook ribbon to configure and sycn selected email to SharePoint 2010 server document library

Before install this add-ins, you need 2 SharePoint list.

– 1 Document Library to store all the Microsoft original basically message files (*.msg). In this article, I named it as “Email Library” so that all selected email from Outlook will be synced to SharePoint and stored in this document library.

– 1 Custom list (which I named “ReviewEmail” in this post), this library was hard coded some neccessary columns with corresponding data type as below

0.ReviewEmailList

  • Subject: Use to stored email subject. This is Multiple line of plain text field, it shouldn’t be single line of text because email subject can be longer than 225 characters
  • ReceiveDate: Date and Time
  • SentDate: Date and Time
  • FromEmail: Single line of text, used to store from email address
  • ToEmail: Since “To Email” may have multiple email addresses, so that I set it to multiple line of plain text field
  • EmailContent: Enhanced rich text (Rich text with pictures, tables, and hyperlinks)
  • FileUrl: Hyperlink. You can download original msg file from here.

1. Run the setup Outlook synchronize to Sharepoint add-ins wizard

0.1 Setup

2. After setup completed, you will see a new Ribbon tab from your outlook and allow you setup SharePoint connection

1.Configure

3. Setup synchronization SharePoint connection from Outlook

You will be asked for

  • SharePoint site url to corresponding SharePoint site/subsite where Email library and Review Email library belongs to
  • Username and Password to login SharePoint server
  • Email library: the library mentioned above
  • Review Email List: the custom list mentioned above to review email data.

2.SetupInfo

  • Then Click Connect button, it will try to connect and save your configuration data for next use.

2.1.SetupSuccess

4. Select with emails you to to sync to SharePoint and click Sync to Server ribbon button, in functionality, the add-ins will read your selected message to save to “Review Email” custom list and upload msg files to “Email Library

3.SelectMutipleEmail - And - SyncToServer

It will show you a simple text if successful, otherwise, an error message will be showed up.

4.SyncSuccess

5. Verify result

  • Selected email were uploaded to Email Library and named with a GUID

5.EmailLibrarySuccess

  • Message’s data was extracted to ReviewEmail custom list with a hyperlink to download msg file

6.ReviewEmailSuccess

See detail of Email was synced to SharePoint from Microsoft Outlook

7.ReviewEmailDetail

I have uploaded setup file and sourcecode to my dirve.

– Installation package https://drive.google.com/file/d/0B55FfAMp1BXddmp2b2NHSC1WdU0

– Source code https://drive.google.com/file/d/0B55FfAMp1BXdVGg0RjEtZnRON1U

Enjoy and hope it help.

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

In last SharePoint Saturday 6th event. I did a presentation about corporation social network and implementation in SharePoint 2013 platform. The agenda as below, I would like post it here so you can download whenever you want

  1. —Why do you need Social features?
  2. —What are company’s problems facing?
  3. —Why SharePoint 2013 but others?
  4. —Estimation for Investment
  5. —The ROI
Unfortunately, I have no time for the demo this time. So I give it to Youtube, sorry since there are no voice in this clip
You can find the series for this topic here

SharePoint 2013 Installation

SharePoint 2013 was released about Jul 2012. I did some test in some new and interesting features such as
– More social
– New Service Applications
– Modern (Metro) style solution
– SharePoint App and App Store
– OAuth Authentication Support
– SharePoint Duet
– New Versioning
– SharePoint 2013 and Infopath Office 15
– SharePoint and Biztalk integration
– ….
Today I would like to write article series about SharePoint 2013 preview version.
In this version, Microsoft provide 2 options for download
SharePoint Foundation 2013 Preview
Microsoft SharePoint Server 2013 Preview (Installation Key: 6RNT8-XV26M-GWH36-VMGQH-94MMH)
– And SharePoint Designer 2013 review version also introduced.

This article, I would like to walk through installation and trouble shooting. Before start, you should refer to hardwares and softwares requirements.
In totally, it required for 64bit platform with 64-bit edition of SQL Server 2008 R2 Service Pack 1 and Windows Server 2008 R2 Service Pack 1 (SP1) Standard, Enterprise, or Datacenter or the 64-bit edition of Windows Server 2012 Release Candidate Standard, Enterprise, or Datacenter.
If you got this error message on starting as below, Don’t forget to install Service Pack 1 if you have Windows Server 2008 R2 already, download at http://download.microsoft.com/download/0/A/F/0AFB5316-3062-494A-AB78-7FB0D4461357/windows6.1-KB976932-X64.exe

After completed Windows 2008 R2 SP1, it’s now ready to install Prerequisites

Use product key from MS site

Installation progress about 10-15 minutes

After intallation finished, system will ask you to start for Configuration Wizard, just say Yes to open PSConfig.  A message will be shown as below. Click Yes to confirm and start the wizard.

Input Database server and database name. Make sure Database access account have write permission on DB server.

Give the passphrase, this password will be used to add more front-end server to farm or uninstall

You should specify easy remember port number instead of default.

Configuration progress about 10minutes.

After finished configuration process, it will show you Central Administration page for initial farm configuration. A helper popup will show, select No to skip the introduction


In Initial Farm Configuration Wizard, I select “Cancel”, you can select “Start the Wizard” to make SharePoint setup all Service Application automatically, but in my experience, you should handle by your self to define data table name and avoid losing of memory from unused service applications

Finally, you have Central Administration page for SharePoint 2013 as below.

Next articles, we will go through setting up for important service applications.

SharePoint 2013 – Setup Secure Store Service

Hoang Nhut Nguyen

Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen

Last week, I setup my SharePoint Server 2010 on my laptop for development environment.
After finished all installation, I realized that I need test send mail functions. As you may know, I need to configure outgoing e-mail settings from SharePoint Central Administration with existed mail server, or I have to setup a mail server such as Microsoft Exchange or MDaemon,… but these installations required some technical knowledge about IT and not easy to complete it. More than that, it may required for licenses and make slow performance on my laptop for mail services.

The solution I used my Gmail account to send and receive email from my local SharePoint server via hMailServer, it is a free e-mail server for Microsoft Windows. It’s used by Internet service providers, companies, governments, schools and enthusiasts in all parts of the world.

It supports the common e-mail protocols (IMAP, SMTP and POP3) and can easily be integrated with many existing web mail systems. It has flexible score-based spam protection and can attach to your virus scanner to scan all incoming and outgoing email.

The benefits are:
– There is all free and not required for licenses fee
– Fast and and easy to setup
– Gmail is available and have good performance and security

In this post, I just introduce SMTP to send mail and let you try on POP3 and IMAP 😉
OK, Here we go

Firstly, we can download hMailServer from website, I also uploaded current lasted version to Mediafire

After finished download, run hMailServer-5.3.3.exe file, click Next to continue the installation wizard

If your local machine has database instant, click Next to continue the installation wizard, or you can use SQL Compact if don’t have database engine installation.

Click Next on next screen.

On next screen, select Create a new hMailServer database for the first installation

Select your database server type

Input your database server connection information as below

On next screen, select database service to ensure database service is running before hMailServer service is started

Click Close to finish the wizard

After finished the wizard, it prompts for password to be able manage hMailServer configuraiton

Check Run hMailServer Administrator and click Finish to continue configuration

On Conect screen, check on Automatically connect on start-up and click Connect

From left menu, navigate to SMTP, fill your host name to Local host name textbox and SMTP Relayer information. In this step, you have to provide your email account and password to login to Gmail

On RFC compliance, check  as below

Navigate Auto-ban and uncheck Enabled if you don’t use Auto-ban feature

Navigate to My computer under IP ranges, fill your local IP address or keep 127.0.0.1 in Lower IP and Upper IP. Make sure all check box as below

And same to Internet range

Finally, you should disable Firewall service to make sure you have no problems with connection issues

Next step, Login your SharePoint Central Administration. Go to System Settings and select Configure outgoing e-mail settings under E-Mail and Text Messages (SMS) section

Fill Mail settings with your hMailServer information and email address use to send email

To test send mail function, you can open any your web application and go to Site Permissions. Try to add a user and check on Send welcome e-mai to the new users as below

Finally, open mail box of this user and check result

It’s cool!!!

Hoang Nhut Nguyen
Email: nhutcmos@gmail.com
Skype: hoangnhut.nguyen
%d bloggers like this: