Tag Archive: SharePoint 2010


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

Ribbon button is a new feature in SP2010. It’s looks nice from a editors point of view and all WebParts seems controlled by the contextual ribbon panel.

But in customer sides, some times they don’t really need ribbon and want to hide Ribbon,Site Actions,Left Navigation,Bread Crumb,… in a single or more than one page.


Before

After

We can do it easy by many way.

1. The easy way to do so is using a content editor webpart and edit the content in html source mode and copy and paste the below CSS classes.

<style type=”text/css”>
#s4-ribbonrow { display:none } /*For Top ribbon*/
#s4-leftpanel { display:none } /*For Left navigation*/
.s4-ca { margin-left:0px;background:transaparent} /*to keep the margin starting from the left or else you will find a blank space if you use only the above class*/
.s4-breadcrumb-top { display : none } /*For Breadcrumb*/
#s4-titlerow { display:none } /*For Top bar*/
</style>

2. Use SPSecurityTrimmedControl you can define who should see the ribbon for page and webediting. We need to implement this control in your MasterPage, wrap any controls (in this case, the whole div that contains the ribbon) in:

<Sharepoint:SPSecurityTrimmedControl runat=”server” Permissions=”ManageWeb”>
//Your controls here
</SharePoint:SPSecurityTrimmedControl>

More info about this control and its parameters here:
http://fusionovation.com/blogs/mbell/archive/2008/09/18/security-trimmed-controls-in-sharepoint.aspx

3. Use code behind, other sites lack this functionality as does SharePoint Foundation. However, the code to do the hiding is simple:

public void HideRibbonForAnon()
{
SPRibbon current = SPRibbon.GetCurrent(this.Page);if (current != null && !this.Page.Request.IsAuthenticated)
{
current.CommandUIVisible = false;

SiteActions actions = SiteActions.GetCurrent(this.Page);

if (actions != null)
{
actions.Visible = false;
}
HideStatusBar();
}
}

internal void HideStatusBar()
{
string script =
“document.onreadystatechange=fnRemoveAllStatus; function fnRemoveAllStatus(){removeAllStatus(true)};”;
this.Page.ClientScript.RegisterClientScriptBlock(typeof(HideTheRibbon), “statusBarRemover”, script, true);
}

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

Since released a beta version of Office 2010, you can forget the illegal versions on the Internet because you got a better offer from Microsoft now.

Office 2010 Beta testing is expected to finally begun. Technology enthusiasts who want to use the program in any way trying to get to beta. For this purpose, a non-secure versions sharing sites to reach the joy that employees have a story. Microsoft has opened to the public beta test program. Weeks before the fall releases on the Internet, published in this new version has bugs and security vulnerabilities.

To download SharePoint 2010 beta, you to start with a Windows Live account, as the company’s official site can download the Office 2010 with 32 and 64-Bit. This address together with the Microsoft Office 2010 SharePoint Server 2010, Visio 2010, Project 2010, Microsoft Office Mobile 2010 and Office Web Apps (Office web applications) you can download the beta versions.

Note:
If you gave the link with download messages from friends who said I wish I had friends. Now we have a situation like this. Because download link will be send to my e-mail address I have to enter the license key and I could not take all for coming.

The download process is quite simple, actually. Let me tell you make a step by step procedures, respectively.

First;
1. Com to address http://www.microsoft.com/2010/en/Basic.aspx
2. Choose Office 2010 or SharePoint 2010
3. On the following page, choose Download Trial
4. Then on the next page from drop-down on the page saying, we select the appropriate version of ourselves
5. Microsoft page will send out an email to your email address, going through the process of downloading from the link and install full featured software for 180-day trial

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

Today is a busy day for me. I’m so tired after comeback from BarCamp SaiGon but I have alot of things and many things has been updated for me.

Several days before, I just tried to estimate prices of SharePoint Enterprise Solution, and I would like share to all of you my experiences.

Firstly, to calculate prices of SharePoint solution is very complicated, require to integrate multiple of Microsoft products with many features and many prices of license. Beside that, we need concern more than about purpose of usage, type of company, Microsoft relationship or vendors…

All that things we need answer the question: “How much we need to pay for SharePoint solution planning?”. More than that, you need all employees of your company use FAST Search features, for example, its necessary to pay more than for this feature,  for hosting application servers…

Ok, so we start with licensing policy. If we apply for SharePoint 2010 environment, there’re 2 situation for your company maybe:

  • Server + CAL licenses for internal users – use for intranet purpose. In this case, we need to by for CAL (Client Access License) for each end user to access to SharePoint server. If you need Enterprise features, you need buy for Standard CAL before upgrade to Enterprise CAL.
  • Internet site server licenses for external users – In this case, we need buy license for each server run with SharePoint 2010 on farm. In this solution, we no need to buy CAL and Internet Sites Standard licsence allow all sites run on one unique domain.


FAST Search License

FAST Search provide optimized performance for search features but you need to pay license for each FAST Search server. Of course, you can use only one server for all license. For example, If we need to setup Intranet for your company and public one website, we can apply SharePoint 2010 Server for SharePoint 2010 Internet Site in only one server. About License FAST Search, we can use for SharePoint 2010 server, with this way, we can reduce prices for hardwares but we need license for SharePoint Server and FAST Search.

About the prices, I just mention about SharePoint licenses and don’t count for others software (MS Offices, Windows Server, SQL Server for example. You can refer to attached file for details of all MS products license prices).


*You need buy Standard CAL first, after that you can buy for Enterprise CAL  

Let I try solution with Standard Licsence and Internal use only, we have 3 server in farm

  • Web Front-End (WFE)/Application server
  • SQL server
  • SharePoint 2010 server
  • 1.000 user

Prices: 2 x 4800$ = 9.600$ (SharePoint 2010 Server) + 1.000 user x 93,5$ = 93.500$
If we need FAST Search on one server (21.800$), Enterprise CAL (82,6$ /user) to access and use this features.
Sum are: 9.600$ + 93.500$ + 21.800$ + 82,6$ x 1000 = 207.500$.

In another solution, we have a server run with SharePoint 2010 to build up a website and public to Internet. We also have 3 server in farm:

  • WFE/Application server
  • SQL server
  • SharePoint 2010 server

SharePoint license: 2 x 11.700$ = 23.400$ ( SharePoint 2010 Internet Site Standard)
FAST Search license for SharePoint 2010 Internet Site Enterprise: 2 x 42.000$ = 94.000$.

Above is example for SharePoint license estimation, for more details Microsoft products license fee you can refer to Microsoft Prices Table

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

This article describes how to make SharePoint sites externally accessible for mobile devices. There are three methods for enabling external access.

  • Virtual private network server A virtual private network (VPN) server that supports Secure Sockets Layer (SSL), such as Microsoft Forefront Unified Access Gateway (UAG), enables you to publish SharePoint sites across the corporate firewall. After you publish the SharePoint site outside the firewall, you must configure an alternative access mapping for it. The SharePoint site must also belong to a zone that allows cross-firewall access. For more information about cross-firewall access, see Configure cross-firewall access.
  • Mobile proxy server Mobile proxy servers, such as Microsoft System Center Mobile Device Center and Blackberry Enterprise Server, help mobile devices work within the IT infrastructure of a company. To access a SharePoint site from outside the corporate firewall, the mobile proxy server must pass the mobile browser’s HTTP headers directly through to SharePoint Server.
  • Direct Internet access The SharePoint site can be placed on the extranet. This option supports only basic authentication. We recommend using a combination of technology and policy safeguards, such as SSL, with any Internet-facing servers.

Configure cross-firewall access

After the SharePoint site is published outside the firewall, you must add the site to a zone that allows cross-firewall access. A cross-firewall access zone is used to generate external PC and mobile URLs in mobile alert messages, and enables users to send an externally accessible URL when they click the E-mail a link button on the ribbon.

To configure a cross-firewall access zone

  1. In Central Administration, click System Settings.
  2. On the System Settings page, under Farm Management, click Configure cross firewall access zone.
  3. On the Cross Firewall Access Zone page, in Web Application, in the Web Application list box, select the Web application that is published across the firewall.
  4. In Cross Firewall Access Zone, in the Zone selection for cross firewall access list box, select the zone that is published across the firewall.

Configure Forefront Unified Access Gateway for Office Mobile

Forefront Unified Access Gateway (UAG) provides a gateway for remote employees, mobile workers, partners, and other third parties to access corporate applications and resources. For more information about UAG, see Forefront Unified Access Gateway (UAG) and SharePoint publishing solution guide.

The following procedures describe specific settings that are required to support Microsoft Office Mobile on Windows Phone 7 and Windows Phone 6.5.

To skip parsing of the response bodies

  1. On the UAG server, start the Forefront UAG Management application.
  2. In the navigation pane, click HTTPS Connections, and then click the trunk name.
  3. On the Portal tab, click the Edit button that is located on the right side of the Do not parse the response bodies to these requests text.
  4. In the URLs without body parsing dialog box, under Servers, click Add.
  5. Enter the name of the server running SharePoint Server. For example, if the server URL is https://contoso, enter the server name as contoso.
  6. In the URLs without body parsing dialog box, under URLs, click Add.
  7. In the Add URLdialog box, add the following URLs:
    • .*/_vti_bin/webs\.asmx
    • .*/_vti_bin/lists\.asmx
  8. Click OK.

To enable rich client applications to bypass trunk authentication

  1. On the UAG server, start the Forefront UAG Management application.
  2. In the navigation pane, click HTTPS Connections, and then click the trunk name.
  3. In the Applications list, select the SharePoint Server application, and then click Edit.
  4. On the Portal Link tab, select the Allow rich clients to bypass trunk authentication check box.

Users can access SharePoint sites by using a mobile browser or by using Microsoft SharePoint Workspace Mobile 2010. Users must configure a Forefront UAG address on their mobile device before SharePoint Workspace Mobile 2010 can be used to access a SharePoint site. Users must know how to configure their mobile device and the URL of the UAG trunk.

To configure the UAG settings on the Windows Phone device (end users)

  1. On the mobile device, start SharePoint Workspace Mobile.
  2. Tap Menu, tap Settings, and then tap Configure Forefront UAG Server.
  3. In the Forefront UAG address box, type the URL of the UAG trunk.
  4. Enter the domain user name and password.
  5. Tap OK.

From Microsoft

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

When we try to create SharePoint 2010 project with Sequential or State Machine Workflow project template from Visual Studio 2010 – there’re only option allow you will get is to deploy such workflow to the farm. It’s not available if you want to develop solution for the cloud.

However, there is a way to workaround depend on the level of customization you need for your workflow.

1. Open your target site by SharePoint Designer 2010.

2. Click Workflows under Site Objects and click on the ribbon Reusable Workflow button.

3. Set your workflow a name, after that SharePoint Designer will open a UI allow you to create the workflow by adding workflow activities into steps.

Now you can create your sequence workflow, but you need transfer this workflow to Visual Studio and deploy it with the rest of your solutions as below steps:

1. Click Save as Template ribbon button to create the base for your workflow,

2. This step will save WSP file workflow solution to the Site Assets library (at ~site/SiteAssets/)

3. Download a WSP file and open with Visual Studio 2010.

4. From Visual Studio 2010 project, click Import SharePoint Solution Package.

5.  Now you will specify type of your solution, which you can set as Sandbox solution and give the file path for the your sandbox solution.

After your solution has been imported to VS 2010, you can to make changes to it and add new workflow activities in Visual Studio. When finished, you can build the project again for WSP file or include it as a part of your overall deployment.

%d bloggers like this: