Error: Error: Attempted to use an object that has ceased to exist

• The number of columns exceeded in a view

             Create a new view using:

              siteurl/_layouts/ViewType.aspx?List=ListID     

• corrupted web part

               Add ?contents=1 to go to the maintenance page and delete the unwanted web part from the page.

                 

 

Differences between Task List and Workflow Task List

Task List:
Use the Tasks list to keep track of work that you or your team needs to complete. 
By default it doesnt send email to the assignees.

Workflow Tasks:
This system library was created by the Publishing feature to store workflow tasks that are created in this site. 
By default it Send email to the assignees.

To change the default setting:
Advanced Settings> Uncheck the send email option.

Nintex 2010: In-Line Functions

In-line Functions used in Nintex 2010 Regular expressions
fn-AbsReturns the absolute value of a number.
Example
fn-Abs({WorkflowVariable:Number})
Arguments
Number The number to return the absolute value of.
fn-Currency
Represents a numeric value as a currency formatted text.
Example
fn-Currency({WorkflowVariable:Cost})
Arguments
Number A variable containing a numeric value.
fn-DateDiffDays
Determines the number of days between two dates.
Example
fn-DateDiffDays({WorkflowVariable:StartDate}, {WorkflowVariable:EndDate})
Arguments
Start date The starting date and time to calculate the difference between.
End date The end date and time to calculate the difference between.
fn-DateDiffHours
Determines the number of hours between two dates.
Example
fn-DateDiffHours({WorkflowVariable:StartDate}, {WorkflowVariable:EndDate})
Arguments
Start date The starting date and time to calculate the difference between.
End date The end and time date to calculate the difference between.
fn-DateDiffMinutes
Determines the number of minutes between two dates.
Example
fn-DateDiffMinutes({WorkflowVariable:StartDate}, {WorkflowVariable:EndDate})
Arguments
Start date The starting date and time to calculate the difference between.
End date The end and time date to calculate the difference between.
fn-DateDiffSeconds
Determines the number of seconds between two dates.
Example
fn-DateDiffSeconds({WorkflowVariable:StartDate}, {WorkflowVariable:EndDate})
Arguments
Start date The starting date and time to calculate the difference between.
End date The end and time date to calculate the difference between.
fn-FormatDate
Represents a date time value in text of a specific format.
Example
fn-FormatDate({WorkflowVariable:MyDate}, d)
Arguments
Date A variable containing a date value.
Format string Text describing how the date time value should be formatted. Information on how to format the value can be found on this page: Standard Date and Time Format Strings and this page Custom Date and Time Format Strings.
fn-Insert
Adds text in to a larger string.
Example
fn-Insert({WorkflowVariable:Text}, 4, {ItemProperty:Title})
Arguments
Text The text to modify.
Start position The character position to insert the new text at. The first character in the string is at position 0.
New text The additional text that will be added at the start position.
fn-Length
Returns the number of characters in a string.
Example
fn-Length({WorkflowVariable:Text})
Arguments
Text The string to count the characters of.
fn-Max
Returns the greater of two numbers.
Example
fn-Max({WorkflowVariable:Number1}, {WorkflowVariable:Number2})
Arguments
Number 1 The first number to compare.
Number 2 The second number to compare.
fn-Min
Returns the lesser of two numbers.
Example
fn-Min({WorkflowVariable:Number1}, {WorkflowVariable:Number2})
Arguments
Number 1 The first number to compare.
Number 2 The second number to compare.
fn-NewGuid
Generate a globally unique identifier.
Example
fn-NewGuid()
fn-PadLeft
Returns the provided string right aligned and padded to the total length with a specific character.
Example
fn-PadLeft({WorkflowVariable:Text}, 6)
fn-PadLeft({WorkflowVariable:Text}, 6,-)
Arguments
Text The string to pad.
Length The target total length of the padded result.
Character Optional. The character to pad the original string with. A space character is used by default.
fn-PadRight
Returns the provided string left aligned and padded to the total length with a specific character.
Example
fn-PadRight({WorkflowVariable:Text}, 6)
fn-PadRight({WorkflowVariable:Text}, 6,-)
Arguments
Text The string to pad.
Length The target total length of the padded result.
Character Optional. The character to pad the original string with. A space character is used by default.
fn-Power
Raises a number to the specified power.
Example
fn-Power({WorkflowVariable:Number}, {WorkflowVariable:Power})
Arguments
Number The number to raise to the power.
Number The power to raise number to.
fn-Remove
Removes a section of text in a larger string.
Example
fn-Remove({WorkflowVariable:Text},xxx,{ItemProperty:Title})
Arguments
Text The text to modify.
Start position The character position from which to remove the following characters. The first character in the string is at position 0.
Length Optional. The number of characters from the start position to remove. All remaining characters will be removed by default.
fn-Replace
Replaces a section of text in a larger string.
Example
fn-Replace({WorkflowVariable:Text},xxx,{ItemProperty:Title})
Arguments
Text The text to modify.
Old value The text to search for and replace.
New value The text to replace Old value with.
fn-Round
Rounds a decimal value to the nearest integer.
Example
fn-Round({WorkflowVariable:Number})
Arguments
Number The decimal number to round.
fn-SubString
Extracts a portion of text from a string.
Example
fn-SubString({WorkflowVariable:Text},5,10)
Arguments
Text The text to extract a value from
Start index The position in the text of the first character to retrieve. The first character in the string is at position 0.
Number of characters The number of characters to retrieve from the start index.
fn-ToLower
Formats text in a string to all lower case.
Example
fn-ToLower({WorkflowVariable:Text})
Arguments
Text The string to convert to all lower case.
fn-ToTitleCase
Formats text in a string to title case.
Example
fn-ToTitleCase({WorkflowVariable:Text})
Arguments
Text The string to convert to title case.
fn-ToUpper
Formats text in a string to all upper case.
Example
fn-ToUpper({WorkflowVariable:Text})
Arguments
Text The string to convert to all upper case.
fn-Trim
Removes leading and trailing whitespace from a string.
Example
fn-Trim({WorkflowVariable:Text})
Arguments
Text The text to remove leading and trailing whitespace characters from.
fn-XmlEncode
Encodes a string to make it safe for viewing in html.
Example
fn-XmlEncode({WorkflowVariable:Text})
Arguments
Text The text to encode.
fn-XmlDecode
Decodes a html safe string to regular text.
Example
fn-XmlDecode({WorkflowVariable:Text})
Arguments
Text The text to decode.

                                                Source: Nintex Connect

SharePoint 2013: New Features and Comparison with SharePoint 2010

SharePoint 2013:

New Features

After attending the Microsoft Presentation today, I noted some of the new features added to newest version of SharePoint 2013.

·         Instead of six pillars in 2010, they have the following 4 features:

Organize, Discover, Build and Manage

·         Search:

Combination of the SharePoint OOTB search and FAST search. It is called “SharePoint search”

·         Whenever you create new site/list/libraries you can define the policy, terms, templates and Retention Policy.

·         HTML 5 compatible

·         Device Channel:

In SP 2010, there was mobile and SharePoint version but in 2013, there are device channel options for android, ios with some additional features.

·         Short URL to any site/list/libraries. We don’t have to go through the additional steps to configure the hyperlink

·         Hover and Preview documents in Search Results, Doc Libraries, lists etc. you have the capability of editing and sharing in the preview itself.

·         Synchronization with SkyDrive(Available on the top Right corner of each page)

·         Navigation: We can edit and modify on the same location without going to the Site Actions>Site settings.

·         Edit with Dreamweaver (Master Page and CSS) and import the HTML code and apply in SharePoint.

·         Drag and Drop Master Page components and apply the changes.

·         Site Action moved again to right top side from left.

·         SharePoint 2013 is all about Application. Instead of creating a list in 2010, you create a list app in 2013. This feature is really cool.

·         Central Administration is exactly the same. They slightly changed the look and feel.

·         Apps Catalog to buy and install apps in SharePoint.

·         Instead of 14 Hive, SP 2013 has 15 Hive.

·         No In-Place Migration available, they recommend “Database move migration approach”

·         Social Networking (MySite, Discussion board, etc.) has been changed significantly. It works as the concept of Facebook, twitter, etc.

·         In SharePoint Designer 2013, there is only code section instead of having both Design and Code section (2010). They removed this because customization has been made ease on the same location itself.

·         Web Apps use their own farm instead of sharing on top of SharePoint.

·         No significant changes in the SharePoint OOTB workflows.

·         Video Search as in YouTube.

Note: Based on the note taken from the meeting with Microsoft.
Disclaimer:  All information, statements, and opinions contained in this blog are my own. They do not represent any other company or organization opinion(s).

SharePoint 2010 Column Validation for EMail

Formula:
1.Insert the following formula in the column validation section:
=AND(
 ISERROR(FIND(" ", [Email],1)),
 IF(ISERROR(FIND("@", [Email],2)),
  FALSE,
  AND(
   ISERROR(FIND("@",[Email], FIND("@", [Email],2)+1)),
   IF(ISERROR(FIND(".", [Email], FIND("@", [Email],2)+2)),
    FALSE,
    FIND(".", [Email], FIND("@", [Email],2)+2) < LEN([Email])
   )
  )
 )
)
Source: http://thechriskent.com/2012/08/16/validate-email-address-columns-in-sharepoint/

2.Add a calculated column with the formula below:
=(LEN(LEFT([Email],FIND("@",[Email])-1))>0)
+(LEN(RIGHT([Email],LEN([Email])-FIND(".",[Email],FIND("@",[Email]))))>0)
+(LEN(MID([Email],FIND("@",[Email])+1,FIND(".",[Email],FIND("@",[Email]))-FIND("@",[Email])-1))>0)
+(ISERROR(FIND(" ",[Email]))=TRUE)
=4
Type: Number or Integer
Reference:
http://sharepointsolutions.com/sharepoint-help/blog/2011/12/how-to-validate-an-email-address-using-column-validation-in-sharepoint-2010/

Configure Send to Connection in SP 2010

Central Administration>
    General Application Settings>
           Under External Service Connections
                  Configure send to Connections

Check the Allow sites to send to connections outside the site subscription and in Send To Connections

In Connection Settings section give the following

Display Name : Display name in the drop down you want it to appear.

Send To URL :
(http://test/RC/default.aspx)

Check the box allow manual submission from send to menu

Send To Action :

Now, if you click on the the drop down of any document, you will see the option to directly send the documents to above destination.

Recommendate: To send documents to Record Center from other sites

Display all the items created in current month

In calculated fields you can use the following formulas to get first day of month and last day of month.

First Day of Current Month Formula=DATE(YEAR([Created]), MONTH([Created]), 1) 

Last Day of Current Month Formula =DATE(YEAR([Created]), MONTH([Created])+1,1)-1 

Current Month:

Filter: First day <[Today]

          Last Day>[Today]

Resource Throttling

List View Threshold: Number of items to display at one view (users). For managing Large Lists.
List View Threshold for Auditors and Administrators: For Auditors and Admins
List View Look up Threshold: For Workflow status column limit, Look up column limit
List Unique Permissions Threshold: Unique Permissions limit

Multiple File Upload Error

The reason for this issue is 'Microsoft.mshtml.dll' has not been deployed in GAC (Global Assembly Cauche "C:\WINNT\assembly"). This dll file available in the "C:\Program Files\Microsoft.NET\Primary Interop Assemblies".

 

Follow one of the following deployment procedure.

 

1) Use GacUtil command tool

    gacutil /i "C:\Program Files\Microsoft.NET\Primary Interop Assemblies\Microsoft.mshtml.dll"

 

2) Open two explorer windows. One for "C:\WINNT\assembly" and another for " C:\Program Files\Microsoft.NET\Primary Interop Assemblies" and then drag and drop the 'Microsoft.mshtml.dll' to the first window.

Some quick sharepoint troubleshooting settings

 

Function	Add to the URL	Notes
Add Web Parts Pane	?ToolPaneView=2	Add to the end of the page URL; WILL ONLY WORK IF THE PAGE IS ALREADY CHECKED OUT
Create New Site Content	/_layouts/create.aspx
List Template Gallery	/_catalogs/lt
Manage Site Collection Administrators	/_layouts/mngsiteadmin.aspx
Manage Sites and Workspaces	/_layouts/mngsubwebs.aspx
Manage People	/_layouts/people.aspx
Manage User Permissions	/_layouts/user.aspx
Master Page Gallery	/_catalogs/masterpage	Also includes Page Layouts
Modify Navigation	/_layouts/AreaNavigationSettings.aspx
Recycle Bin	/_layouts/AdminRecycleBin.aspx
Site Column Gallery	/_layouts/mngfield.aspx
Site Content Types	/_layouts/mngctype.aspx
Site Content and Structure Manager	/_layouts/sitemanager.aspx
Site Settings	/_layouts/settings.aspx
Site Template Gallery	/_catalogs/wt
Site Usage Summary	/_layouts/SpUsageWeb.aspx
User Alerts	/_layouts/sitesubs.aspx
View All Site Content	/_layouts/viewlsts.aspx
Web Part Gallery	/_catalogs/wp
Web Part Page Maintenance	?contents=1	Add to the end of the page URL
Workflows	/_layouts/wrkmng.aspx

InfoPath form hide/disable fields based on the SharePoint Group Members

http://www.sharepointbasic.com/2011/11/infopath-form-hidedisable-fields-based.html

CAML Builder and AD Explorer

U2U CAML Builder

http://www.u2u.be/Tools/SharePointCamlQueryBuilder.aspx

CAML Designer

http://karinebosch.wordpress.com/my-articles/caml-designer/

AD Explorer:

http://technet.microsoft.com/en-us/sysinternals/bb963907.aspx

ULS Logs:

http://archive.msdn.microsoft.com/ULSViewer

XML Tool Box:
Generates XPATH:
http://www.xmltoolbox.com/index.html

Regular Expression+ Nintex+ SharePoint

To Remove Date and TimeStamps and RACF from the approver comments:

Input: Approver Comments
Function: "Replace By"
Store in :Variable(single line of text)

For racf:

^\(.+\)\s

For TimeStamps:

^.*[\S].*[\s]

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

http://regexlib.com/CheatSheet.aspx?AspxAutoDetectCookieSupport=1

Build URL String for Document Library/Lists

To View the Properties of the List:

<a href="{url}"><strong>View</strong>

To Edit the Properties of the List:

<a href="{concat(sitename,substring-before(substring-before(substring-after(url,sitename),'.'),'/DispForm'),'/','EditForm.aspx','?ID=',listitemid)}"><strong>Edit</strong></a>

To View the Properties of Document Library:

<a href="{concat(sitename,'/',substring-before(substring-after(substring-after(url,sitename),'/'),'/'),'/Forms/DispForm.aspx?','ID=',listitemid)>

To Edit the Properties of Document Library:

<a href="{concat(sitename,'/',substring-before(substring-after(substring-after(url,sitename),'/'),'/'),'/Forms/EditForm.aspx?','ID=',listitemid)>

Group a SharePoint List by Created Month Name and Year

Create a calculated column and insert the below formula:

=TEXT(Created,"MMMM")&"-"&YEAR(Created) This column will show you the month and year based on the "Created" column.
=TEXT([Column Name],"MMMM")&"-"&YEAR([Column Name])