Thursday 31 January 2013

Character Limit in RichText Box in Infopath 2010 with SharePoint 2010

How to limited character  enter in Rich Textbox in InfoPath 2010 with SharePoint 2010.

1. At first take one rich text box in Infopath 2010.
2. Add Rule in  Rich Textbox, then select "Validation". Rule type=Validation
3. Set a condition,
      The expression= string-length(.)>10
4.Insert screen tip: "Character Limit to 10"
5.Ok

Wednesday 2 January 2013

How to configure SharePoint Solution Packages WSP (web solution package)

Following Steps:-


Step 1: Retract Solution (if solution packages is already developed in server).

stsadm -o retractsolution -name example.wsp -url http://server-name/sites/site-name -immediate

Step 2: Delete Solution (if solution packages is already developed in server).

stsadm -o deletesolution -name example.wsp

Step 3: Add the solution.

stsadm -o addsolution -filename E:example.wsp

Step 4: Deploy the solution.

stsadm -o deploysolution -name example.wsp -url http://server-name:port/sites/site-name/ -immediate -allowCasPolicies

Step 5: Go to Site Collection features and select the wep part for (Active or Deactive).

Convert list or library sharepoint data into excel sheet using JavaScript.

Following Steps:-
1-Take one content editor web part,
2-Put below code with all details.


'input class="ms-rteThemeBackColor-5-4" onclick="location.href='/site/site-name/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=list-name;View=view-name; CacheControl=1'" type="button" value="Export to Excel"/ /'

In Simple:-
{siteurl}/_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List={GUID of list}&View={GUID of view}&CacheControl=1