Technology Learnings: 2015

Thursday, 15 January 2015

Item expiration reminders in SharePoint using workflow

http://markeev.com/Articles/item-expiration-reminders-in-sharepoint-using-workflow.aspx

Set the default open behavior for browser-enabled documents (Office Web Apps when used with SharePoint 2013)

http://technet.microsoft.com/en-us/library/ee837425(v=office.15).aspx

Manage Excel Services trusted file locations (SharePoint Server 2013)

http://technet.microsoft.com/en-us/library/jj219699(v=office.15).aspx

Wednesday, 14 January 2015

Tuesday, 13 January 2015

Quiz Application in Sharepoint

Try to develop this quiz application

You will learn about Data view web part, Parameters passing, Filter, and Session Variables (like getting current user name in Xsl variables) in SharePoint designer

http://blogs.technet.com/b/brenclarke/archive/2009/04/14/creating-a-quiz-web-application-using-sharepoint-designer.aspx

On clicking this link you will see Part1 of the application.

Scroll down the page for the remaining parts.

Showing Project Status in List

http://thinketg.com/creating-a-stoplight-color-coded-status-in-a-sharepoint-2013-list/

Sending SMS alerts in Sharepoint 2010

Like emails, we can send alerts to mobile also

http://techwirenews.com/2011/10/26/alerts-in-microsoft-sharepoint-2010/

Entity Framework 5.0- no need of transformation

In Entity Framework 5.0 no need of transformation ,Data classes can be generated automatically for transformation

Please find the link

http://msdn.microsoft.com/en-us/data/jj206878

Move workflow into production environment

Follow the below steps to move workflow into production environment site,

1. In the Development environment open the SharePoint Designer and export the workflow you want using “Export to Visio”.

2. Rename the vwi files by adding ".zip" extension, now open the zip file and remove the "workflow.xoml.wfconfig.xml" because it contains the details about the associated list, once you remove the file from the zip folder, the association between the workflow and the list will be removed and the workflow can be associted with any other list.

3. After removing the "workflow.xoml.wfconfig.xml" file from the zip folder, then again Rename the zip folder by adding ".vwi" extension.

4. Open SharePoint designer in the production environment and open the site.

5. Now Click on Workflows.

6. Click the “Import from Visio” option from the ribbon and select the altered ".vwi" extension file.

7. System will open the imported Workflow.

Click on Save and then Publish

http://blogs.msdn.com/b/sharepointdesigner/archive/2012/08/30/packaging-list-site-and-reusable-workflow-and-how-to-deploy-the-package.aspx

How to fix an out of sync password issue in SharePoint 2010

SharePoint 2010 now stores service account passwords in the config database. So if you attempt to change the password in the AD and on the services that use it this will break SharePoint.

To fix this issue do the following

Logon to the SharePoint 2010 server as an admin, preferably as the account used to install SharePoint
Open up the SharePoint PowerShell command prompt
Set-SPManagedAccount -UseExistingPassword -Identity DOMAINA\SPSAdmin

Where DOMAINA\SPSAdmin is service account that had it's password changed in the AD

You will then be prompted for the existing\new password for "DOMAINA\SPSAdmin"
Run "Repair-SPManagedAccountDeployment" to verify the passwords are now in sync
Next do an IISRESET command
Run Repair-SPManagedAccountDeployment to verify that you do not get this message:
Repair-SPManagedAccountDeployment : The password for the account DOMAINA\spsadmin, as currently stored in SharePoint, is not the same as the current password for the account within Active Directory. To fix this with PowerShell, run Set-SPManagedAccount -UseExistingPassword.

The Set-SPManagedAccount -UseExistingPassword command will update the config database and service using by this account.

SharePoint 2010 also support automatic password management for service accounts. See Configure automatic password change for details on this feature.

Useful blog:

http://info.izzy.org/Blog/archive/2010/08/04/how-to-fix-an-out-of-sync-password-issue-in-sharepoint-2010.aspx

Service Accounts password change in AD

If we are using service account and password has been changed in AD for service accounts then sites won’t work service unavailable and page can’t be displayed will be showing , at that time need to set the passwords as below.

1) To update the password from the Central Administration GUI > Security > General Security > Configure Managed Accounts and click edit on the relevant managed account and then select Change password now and then select Use existing password. Enter the password that was entered in AD and click OK.

2) Reset the IIS

Seting up Single box SharePoint 2013 Virtual Machine

http://wp.ahcheng.com/2013/04/21/setting-up-a-single-box-sharepoint-2013-virtual-machine/

Passing multiple parameters to filter

http://www.signaturesterling.com/blog/post/Multiple-Parameter-List-Filter-in-SharePoint-Designer-2010.aspx

SharePoint Server 2010 installation on windows 7

http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx

SP 2013 Certification syllabus

http://www.microsoftvirtualacademy.com/training-courses/developing-microsoft-sharepoint-server-2013-core-solutions-jump-start

Calculated Column

http://msdn.microsoft.com/en-us/library/bb862071.aspx

Adding Hyperlink to Document Library

http://techtrainingnotes.blogspot.in/2007/08/sharepoint-adding-hyperlinks-to-doc.html

Enhanced rich Text field in Document Library

http://www.sharepointsingh.com/2010/07/add-multiline-rich-textenhanced-rich.html

RolluP SubSite Content to Main Content

http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=76

Interesting JS Link

http://sharepointandetc.blogspot.com/2014/06/working-with-jslink.html

Resolve Infopath issue for SHarePoint 2013

Registry Updates required in users VM:

----------------------------------------------------------------------------

The workaround from the case I worked on is:

Delete/rename the following keys:

HKEY_CLASSES_ROOT\SharePoint.OpenDocuments.4

HKEY_CLASSES_ROOT\SharePoint.OpenDocuments.5

(Always remember to back up your registry when you make changes)

Also, you can apply this fix in the support document below:

http://support.microsoft.com/kb/2798395

Modify the following key:

HKEY_CLASSES_ROOT\SharePoint.OpenDocuments\CurVer

With default value:

SharePoint.OpenDocuments.3

Sharepoint 2013 Bamboo Navigation

http://community.bamboosolutions.com/blogs/sharepoint-2013/default.aspx?Sort=MostViewed&PageIndex=1

The Text Filter Web Part – Without Having To Filter Exact Text

http://www.wonderlaura.com/Lists/Posts/Post.aspx?ID=77

SharePoint List filter wildcard search on multple columns .. LIKE

http://gustavogarciadotnet.blogspot.com/2011/01/sharepoint-list-filter-wildcard-search.html

Creating a SharePoint Information Management Policy in 10 Steps

http://www.dynamics101.com/2013/03/sharepoint-information-management-policy/

SharePoint – wildcard / free text searching the List View web part

http://blog.pentalogic.net/2014/05/sharepoint-wildcard-free-text-search-list-view-web-part/

Create Cascading Dropdown in Browser enabled InfoPath form using InfoPath 2010

http://blogs.msdn.com/b/bharatgupta/archive/2013/03/07/create-cascading-dropdown-in-browser-enabled-infopath-form-using-infopath-2010.aspx

SharePoint 2010 Search list using OOTB Text filter Web Part

http://www.sharepointbreak.com/2013/09/25/sharepoint-2010-search-list-using-ootb-text-filter-web-part/

SharePoint 2010 autocomplete textbox containing listitems

http://tomvangaever.be/blogv2/2011/07/sharepoint-2010-autocomplete-with-list-items/

Dropdown options are displayed in the wrong place. (IE only)

http://sharepoint.stackexchange.com/questions/73825/dropdown-options-are-displayed-in-the-wrong-place-ie-only

SpServices

http://spservices.codeplex.com/wikipage?title=%24().SPServices.SPCascadeDropdowns

Custom Rule for Telephone Field in Infopath form

https://digitalmacgyver.wordpress.com/2012/02/02/custom-rule-for-telephone-field-in-infopath-201-form/

Cascading dropdowns in SharePoint text fields – populated by lookup in another list

http://spjsblog.com/2010/06/15/cascading-dropdowns-in-sharepoint-text-fields-populated-by-lookup-in-another-list-version-2/

Setting Jquery UI Auto complete on SharePoint Text Filter

http://babasharepoint.blogspot.com/2014/02/setting-jquery-ui-auto-complete-on.html

Adding an image + link via calculated column on a list with HTML (Directory List Solution)

http://sharepointhannah.wordpress.com/2014/06/11/adding-an-image-link-via-calculated-column-on-a-list-with-html-directory-list-solution/

Calculated Column left align header

http://sharepoint.stackexchange.com/questions/53146/calculated-column-left-align-header

What Every SharePoint Admin Needs to Know About Host Named Site Collections

http://blogs.msdn.com/b/kaevans/archive/2012/03/27/what-every-sharepoint-admin-needs-to-know-about-host-named-site-collections.aspx

SharePoint 2010 Filtering list results with auto-complete text search

http://stackoverflow.com/questions/15510002/sharepoint-2010-filtering-list-results-with-auto-complete-text-search

Clearing up the confusion with Host Named site collections and Path Based site collections

http://www.wictorwilen.se/clearing-up-the-confusion-with-host-named-site-collections-and-path-based-site-collections

Host-named site collection architecture and deployment (SharePoint 2013)

http://technet.microsoft.com/en-us/library/cc424952%28v=office.15%29.aspx

Edit list forms using InfoPath 2010 in SharePoint Designer

https://support.office.com/en-nz/article/Edit-list-forms-using-InfoPath-2010-in-SharePoint-Designer-f86cf514-9a11-4613-a479-12a1a0132d22?ui=en-US&rs=en-NZ&ad=NZ

Not all column types can be used in Calculated or Lookup columns (plus a trick to add back four of them!)

http://techtrainingnotes.blogspot.com/2012/01/sharepoint-not-all-column-types-can-be.html

How to-Make-SharePoint-List-Form-Fields-Read-Only-Without-InfoPath

http://blogs.c5insight.com/Home/entryid/457/How-to-Make-SharePoint-List-Form-Fields-Read-Only-Without-InfoPath

How to perform insert, update, delete and select rows in ASP.NET gridview control using stored procedure

http://www.dotnetgallery.com/kb/resource10-How-to-perform-insert-update-delete-and-select-rows-in-ASPNET-gridview-c.aspx.aspx

sqlhelper.cs source code..

http://krishankayat.blogspot.com/2013/02/sqlhelpercs-source-code.html

Encrypt and Decrypt QueryString Parameter Values in ASP.Net using C# and VB.Net

http://www.aspsnippets.com/Articles/Encrypt-and-Decrypt-QueryString-Parameter-Values-in-ASPNet-using-C-and-VBNet.aspx

GridView Paging and Sorting

http://www.codeproject.com/Articles/67520/GridView-Paging-and-Sorting

ASP.NET GridView Tips and Tricks Collection

http://www.devcurry.com/2010/11/aspnet-gridview-tips-and-tricks.html

How to Make SharePoint-List-Form-Fields-Read-Only-Without-InfoPath

http://blogs.c5insight.com/Home/entryid/457/How-to-Make-SharePoint-List-Form-Fields-Read-Only-Without-InfoPath

How to display a popup window (DialogMessage) via code behind c#?

https://social.msdn.microsoft.com/Forums/office/en-US/c742df27-e0de-47ce-b7b1-c2e10cbc557a/how-to-display-a-popup-window-dialogmessage-via-code-behind-c?forum=sharepointdevelopment

Encrypt and Decrypt a String in c#

https://social.msdn.microsoft.com/Forums/vstudio/en-US/d6a2836a-d587-4068-8630-94f4fb2a2aeb/encrypt-and-decrypt-a-string-in-c

How to enable Users to Close Status Messages and Notifications

https://pholpar.wordpress.com/2014/03/06/how-to-enable-users-to-close-status-messages-and-notifications/

You cannot view a list in Datasheet view after you install the 64-bit version of Office 2010

http://support.microsoft.com/kb/2266203

Fix for Datasheet View Issue / Error in SharePoint 2010

http://amatterofdegree.typepad.com/a_matter_of_degree/2010/11/fix-for-datasheet-view-issue-error-in-sharepoint-2010.html

Exporting and Importing SharePoint Designer 2010 List Workflow

http://blogs.technet.com/b/wkng/archive/2012/08/21/exporting-and-importing-sharepoint-designer-2010-list-workflow.aspx

Sum Calculated Columns

http://blog.metrostarsystems.com/2012/12/03/jennys-sharepoint-tip-sum-calculated-columns/

SharePoint 2010 Pie Chart with Counts

https://www.nothingbutsharepoint.com/2011/08/04/sharepoint-2010-pie-chart-with-counts-aspx/

Sharepoint workflows show as rejected eventhough everyone has approved

http://sharepoint.stackexchange.com/questions/41370/sharepoint-workflows-show-as-rejected-eventhough-everyone-has-approved

Upgrading from SharePoint 2010 to SharePoint 2013 Step by Step

http://blogs.msdn.com/b/alimaz/archive/2012/07/17/upgrading-from-sharepoint-2010-to-sharepoint-2013-step-by-step.aspx

Displaying a PowerPoint presentation in a SharePoint web part

http://www.mssharepointtips.com/tip.asp?id=1076

Approval Workflow Any user to Approve

http://sharepoint.stackexchange.com/questions/73332/approval-workflow-any-user-to-approve

How to implement reusable workflows on multiple lists in SharePoint 2010

http://www.mssharepointtips.com/tip.asp?id=1095

How To: Hide Left Side Navigation on Home Page

http://erikswenson.blogspot.com/2010/08/how-to-hide-left-side-navigation-on.html

Understand and Configure Metadata Navigation and Filtering

http://www.boostsolutions.com/blog/understand-and-configure-metadata-avigation-and-filtering/

Using Document Templates with Lists and Content Types in SharePoint

http://whitepages.unlimitedviz.com/2011/02/using-document-templates-with-lists-and-content-types-in-sharepoint/

Opening Document in Client Applications

https://social.technet.microsoft.com/Forums/en-US/29582c92-f7df-45c1-b0cf-3a377adf829d/opening-document-in-client-applications?forum=sharepointgeneralprevious

Creating dashboards in Sharepoint 2010 – Tutorial

http://www.learningsharepoint.com/2010/07/10/creating-dashboards-in-sharepoint-2010-tutorial/

On publishing infopath 2010 form loses control properties - dropdown control data binding setting

http://stackoverflow.com/questions/5837978/on-publishing-infopath-2010-form-loses-control-properties-dropdown-control-dat

Image Carousel/Slider in SharePoint 2010

http://www.codeproject.com/Articles/544663/Image-Carousel-Slider-in-SharePoint

Know the site template used for the SharePoint site

http://praveenbattula.blogspot.com/2010/08/know-site-template-used-for-sharepoint.html

How to determine your site template

http://www.shareesblog.com/?p=234

SharePoint Designer 2010 workflow on the specific folder of library

http://stackoverflow.com/questions/22829699/sharepoint-designer-2010-workflow-on-the-specific-folder-of-library

Sending Attachments via SharePoint 2010 Workflow

http://collaborationnation.blogspot.com/2013/06/sending-attachments-via-sharepoint-2010.html

SharePoint 2010 Client Object Model: Introduction

http://www.codeproject.com/Articles/399156/SharePoint-Client-Object-Model-Introduction

SharePoint 2010 - SharePoint Object Model

http://www.c-sharpcorner.com/UploadFile/40e97e/sharepoint-2010-sharepoint-object-model/

Send e-mail in a workflow

https://support.office.com/en-us/article/Send-e-mail-in-a-workflow-11d5f9dd-955f-412c-b70f-cde4214204f4?ui=en-US&rs=en-US&ad=US

Modifying external list forms with infopath 2010

http://lightningtools.com/uncategorized/modifying-external-list-forms-with-infopath-2010/

Managing SharePoint Designer 2010

https://support.office.com/en-us/article/Managing-SharePoint-Designer-2010-e12d76ce-83f7-4dde-864c-6c1e210399b6?ui=en-US&rs=en-US&ad=US

Manage Permissions

https://support.office.com/en-us/article/Manage-permissions-for-a-list-library-folder-document-or-list-item-9d13e7df-a770-4646-91ab-e3c117fcef45?ui=en-US&rs=en-US&ad=US

Data View conditional formatting using SharePoint Designer

http://blog-sharepoint.blogspot.com/2009/05/data-view-conditional-formatting-using.html

Connecting web parts with a selector and a detail pane (SharePoint 2010 version)

http://blog.splibrarian.com/2012/05/21/connecting-web-parts-with-a-selector-and-a-detail-pane-sharepoint-2010-version/

Connected Web Parts in SharePoint 2010 - an Architectural Framework

http://www.dotnetcurry.com/showarticle.aspx?ID=678

Connectable Web Parts in SharePoint 2010

http://www.c-sharpcorner.com/uploadfile/DipalChoksi/connectable-web-parts-in-sharepoint-2010/

Adding and Deploying Solutions with PowerShell in SharePoint 2010

http://www.dotnetmafia.com/blogs/dotnettipoftheday/archive/2009/12/02/adding-and-deploying-solutions-with-powershell-in-sharepoint-2010.aspx