Assorted SharePoint Thoughts....

Set/Update Content Type of new upload file in document library

2011-12-15T09:37:00.000-08:00

using (SPSite site = new SPSite(SiteSubSite))
{
using (SPWeb web = site.OpenWeb())
{
web.AllowUnsafeUpdates = true;
//Create file Stream object using save local file
FileStream fstream = File.OpenRead(sourceFilePath);
byte[] content = new byte[fstream.Length];
fstream.Read(content, 0, (int)fstream.Length);
fstream.Close();

SPFile file = web.Files.Add(targetDocumentLibraryPath, content, true);

SPContentType spPdf = file.Item.ParentList.ContentTypes[ContentType.Name.ToString()];

file.Item["ContentTypeId"] = spPdf.Id;
file.Item["Content Type"] = spPdf.Name;
file.Item.SystemUpdate();
file.Update();

}
}

Error: "Cannot open database "WSS_Content_...." requested by the login. The login failed. Login failed for user ... "

2011-12-15T08:32:00.000-08:00

Today I am converting word to PDF file using Word Automation Service, its throw error like "Cannot open database "WSS_Content_...." requested by the login. The login failed. Login failed for user ... "

Solution :

I have open IIS manager and click on the Application pool. Selected respected site's pool and apply valid user authentication over there. After reset IIS and checked my feature.

Its Working...

Enjoy...

Enable Riboon Button for specific list and single item selection

2011-12-11T06:50:00.000-08:00

Programmatically add Custom action in SharePoint 2010

2011-12-11T06:20:00.000-08:00

If you need to create a ribbon button that applies to a specific list in a farm deployment scenario you must write some code in a feature event receiver to create an SPUserCustomAction class as so:
SPList list = web.Lists["SomeList"];SPUserCustomAction action = list.UserCustomActions.Add();action.Title = "Do Something";action.Description = "Sample ribbon button";action.ImageUrl = "/_layouts/images/centraladmin_backupandrestore_granularbackup_32x32.png";action.Location = "CommandUI.Ribbon.ListView";action.Sequence = 0;action.Url = "javascript:DoAction();";action.CommandUIExtension =@"<CommandUIExtension xmlns='http://schemas.microsoft.com/sharepoint/'> <CommandUIDefinitions> <CommandUIDefinition Location='Ribbon.Documents.Manage.Controls._children'> <Button Id='Sample.DoSomething.Button' Command='Sample.DoSomething' Image32by32='/_layouts/images/centraladmin_backupandrestore_granularbackup_32x32.png' Image16by16='/_layouts/images/centraladmin_backupandrestore_granularbackup_32x32.png' Sequence='0' LabelText='Do Something' Description='Sample ribbon button' TemplateAlias='o1' /> </CommandUIDefinition> </CommandUIDefinitions> <CommandUIHandlers> <CommandUIHandler Command='Sample.DoSomething' CommandAction='javascript:DoAction();' EnabledScript='javascript:EnableDoAction();'/> </CommandUIHandlers></CommandUIExtension>";
action.Update();

Hide Ribbon in SharePoint 2010

2011-12-11T06:04:00.000-08:00

f you have a to disable / hide the SharePoint 2010 ribbon in list forms (such as New / Edit / Display forms), one of the easiest ways is to do it through CSS.

As SharePoint 2010 provides great flexibility with list forms, we can easily modify whatever is required in a particular form for a particular list.

Click "Edit List" icon in the ribbon and it will fire up SharePoint Designer. Open the form where the ribbon needs to be hidden, right click it and choose "Edit File in Avdanced Mode".

The below is div in which the ribbon resides.

...

</div>

Now to hide the ribbon, add this to the page.

#s4-ribbonrow{ display:none; }

</style>

Custom Ribbon Menu in SharePoint 2010

2011-12-11T02:42:00.000-08:00

Feature.xml

<Feature xmlns="http://schemas.microsoft.com/sharepoint/"

Id="031FE880-77CF-4A84-8C5C-7324229EDC6D"

Title="List Document Merge Custom Ribbon Button"

Scope="Web"

Description="List Document Merge Custom Ribbon Button"

ImageUrl="DOC32.GIF">

</ElementManifests>

</Feature>

RibbonButton.xml

<CustomAction

Id="ListDocumentMergeCustomRibbonButton"

RegistrationId="101"

RegistrationType="List"

Location="CommandUI.Ribbon"

Sequence="5"

Title="Merge Documents"

Rights="ViewListItems" xmlns="http://schemas.microsoft.com/sharepoint/"

<Button

Id="Ribbon.Documents.New.ListDocumentButton"

Alt="Merge Documents"

Sequence="5"

Command="ListDocumentMerge_Test_Button"

Image32by32="/_layouts/images/DOC32.GIF"

Image16by16="/_layouts/images/DOC32.GIF"

LabelText="Merge Documents"

TemplateAlias="o1" />

</CommandUIDefinition>

</CommandUIDefinitions>

<CommandUIHandler

Command="ListDocumentMerge_Test_Button"

CommandAction="~site/_layouts/ListDocumentMerge/DocumentMerge.aspx?List={ListId}&ID={SelectedItemId}" />

</CommandUIHandlers>

</CommandUIExtension>

</CustomAction>

</Elements>

Programatically show processing screen ( Using SPLongOperation )

2011-12-09T07:00:00.001-08:00

http://howtosharepoint.blogspot.com/2010/04/how-to-programatically-show-processing.html

The type ‘System.IO.Packaging.Package’ is defined in an assembly that is not referenced. You must add a reference to assembly ‘WindowsBase’

2011-12-07T09:30:00.000-08:00

While I was working with the Open Office XML SDK 2.0, after I added the reference to the DocumentFormat.OpenXml assembly and tried to build the application I ran into this error message.

The type ‘System.IO.Packaging.Package’ is defined in an assembly that is not referenced. You must add a reference to assembly ‘WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′

Turns out, all you need to do to fix it is to just add another reference to WindowsBase assembly that is found in the .NET Tab.

Use Cross-Site List using SharePoint Designer 2010

2011-10-29T04:02:00.001-07:00

http://blog.concurrency.com/sharepoint/sharepoint-2010-cross-site-content-rollup-using-sharepoint-designer-2010-and-a-dataview-web-part/

Get User Login Name from SP User/Group Column in Sharepoint

2011-10-17T06:14:00.000-07:00

SPFieldUser field = item.Fields["Approver"] as SPFieldUser;

if (field != null)

{

SPFieldUserValue fieldValue = field.GetFieldValue(item["Approver"].ToString()) as SPFieldUserValue;

if (fieldValue != null)

{

string str= fieldValue.User.LoginName;

}

How to display all versions in a SharePoint list view page

2011-10-01T20:57:00.000-07:00

http://stefan-stanev-sharepoint-blog.blogspot.com/2009/08/how-to-display-all-versions-in.html

Programmatically get custom list and document library Version History

2011-10-01T20:54:00.000-07:00

private void GetVersionHistory()
{
try
{
using (SPSite site = new SPSite(SPContext.Current.Site.Url.ToString()))
{
using (Microsoft.SharePoint.SPWeb web = site.OpenWeb())
{
Guid id = new Guid(this.Request.QueryString["ListId"].ToString());
SPList objList = web.Lists[id];
DataTable dtPhoto = new DataTable("dtPhoto");
site.AllowUnsafeUpdates = true;
web.AllowUnsafeUpdates = true;

if (objList.BaseType == SPBaseType.DocumentLibrary)
{
char[] sep = { '' };
char[] sepHash = { '#' };
SPListItem item = objList.GetItemById(Convert.ToInt32( this.Request.QueryString["ItemId"].ToString()));
string strname = item["Name"].ToString();
foreach (SPFile file in objList.RootFolder.Files)
{
if (file.Name == strname)
{
dtPhoto.Columns.Add("Version");
dtPhoto.Columns.Add("Modified");

dtPhoto.Columns.Add("Modified By");
dtPhoto.Columns.Add("Comments");
DataRow dtrow;

dtrow = dtPhoto.NewRow();
dtrow["Version"] = file.UIVersionLabel;
dtrow["Modified"] = item["Modified"].ToString();

string[] str1 = item["Modified By"].ToString().ToString().Split(sepHash);

dtrow["Modified By"] = ( str1[1].ToString());
dtrow["Comments"] = file.CheckInComment;

dtPhoto.Rows.Add(dtrow);

SPFileVersionCollection filecollection = file.Versions;
if (filecollection.Count > 0)
{

foreach (SPFileVersion v in filecollection)
{

dtrow = dtPhoto.NewRow();
dtrow["Version"] = v.VersionLabel;
dtrow["Modified"] = v.Created;
string[] str = v.CreatedBy.ToString().Split(sep);

dtrow["Modified By"] =GetUserName( str[1].ToString());
dtrow["Comments"] = v.CheckInComment;

dtPhoto.Rows.Add(dtrow);

}
if (dtPhoto != null && dtPhoto.Rows.Count > 0)
{
gvVersion.DataSource = dtPhoto;
gvVersion.DataBind();

}
else
{
trversion.Visible = false;
gvVersion.Visible = false;

}
return;
}
}
}
}
else
{

#region

SPQuery objQuery = new SPQuery();
objQuery.Query = "<Where><Eq><FieldRef Name=\"ID\"/><Value Type=\"Counter\">" + this.Request.QueryString["ItemId"].ToString() + "</Value></Eq></Where>";
SPListItemCollection objItemColl = objList.GetItems(objQuery);

foreach (SPListItem objItem in objItemColl)
{
SPListItemVersionCollection objVerisionColl = objItem.Versions;
if (objVerisionColl.Count > 0)
{
dtPhoto.Columns.Add("Version");
dtPhoto.Columns.Add("Modified");
dtPhoto.Columns.Add("Modified By");
dtPhoto.Columns.Add("Comments");

DataRow dtrow;

//Navigate to each version of the ListItem
foreach (SPListItemVersion objVersion in objVerisionColl)
{
SPListItem objLstItm = objVersion.ListItem;
char[] sep = { ',' };
char[] sep1 = { ';' };
dtrow = dtPhoto.NewRow();
dtrow["Version"] = objVersion.VersionLabel;
dtrow["Modified"] = objLstItm.Versions.GetVersionFromLabel(objVersion.VersionLabel)["Modified"].ToString();
string[] strtest = objLstItm.Versions.GetVersionFromLabel(objVersion.VersionLabel)["Modified By"].ToString().Split(sep);
string[] str11 = strtest[0].Split(sep1);
string s = str11[1].ToString().Replace("#", "");
dtrow["Modified By"] = s;
dtrow["Comments"] = "";

dtPhoto.Rows.Add(dtrow);
}
}
}
#endregion

}

if (dtPhoto != null && dtPhoto.Rows.Count > 0)
{
gvVersion.DataSource = dtPhoto;
gvVersion.DataBind();

}
else
{
trversion.Visible = false;
gvVersion.Visible = false;

}

}
}
}
catch (Exception)
{

}
}

Show username instead of "System Account" in SharePoint

2011-07-14T23:36:00.001-07:00

Many times when you login to a SharePoint site you will see at the right hand side top corner "Welcome System Account" instead of your username. Sometimes we need to really get rid of this system account and display proper username.

Here are the two ways which could help you accomplish this task:

Solution one :

· Go to Central Administration / Application Management.

· Click Policy for Web Application.

· Select your web app and click your account in the list.

· In the Edit Users page, clear the Account operates as System checkbox.

· That should fix this particular problem.

Solution two:

· Go to Central Administration / Operations.

· Select Service Accounts

. Select your web application

· Change the application pool identity for your Web application

Access denied by Business Data Connectivity

2011-06-20T07:09:00.000-07:00

http://www.zimmergren.net/archive/2010/05/08/access-denied-by-business-data-connectivity-solution.aspx

http://sharepoint-2010-world.blogspot.com/2011/02/solution-to-access-denied-by-business.html

http://www.mikhaildikov.com/2010/05/access-denied-by-business-data.html

SharePoint 2010 - i:0#.w|domain\username issue in User

2011-06-12T03:20:00.000-07:00

Hi Friend,

Yesterday When I fetched user name through object model, I am getting user name like i:0#.w|domain\username. Because It is possible in claim based authentication in sharepoint.

To Solve this problem, decode the account name.

using Microsoft.SharePoint.Administration.Claims;

SPClaimProviderManager mgr = SPClaimProviderManager.Local;

string strDecodedLoginName = "";

strDecodedLoginName = mgr.DecodeClaim(strLoginName).Value;

The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.System.Web.Services in sharepoint 2010

2011-06-08T08:27:00.000-07:00

Hi Guys,

Today I am connect to SharePoint web service from external machine but I am getting error "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.System.Web.Services ".

I searched on Google and found below solution.

//Trust all certificates
System.Net.ServicePointManager.ServerCertificateValidationCallback =
((sender, certificate, chain, sslPolicyErrors) => true);

SMTP Detail From Central Administration

2011-05-31T23:48:00.000-07:00

Hi Friends,

You will get SMTP configuration detail from central admin which is useful in webpart or workflow for email trigger.

using Microsoft.SharePoint.Administration;

string smtpServer = SPAdministrationWebApplication.Local.OutboundMailServiceInstance.Server.Address;

string smtpFrom = SPAdministrationWebApplication.Local.OutboundMailSenderAddress;

Custom workflow action appearing in action list but not showing Workflow UI

2011-03-25T10:30:00.000-07:00

I created for SharePoint Designer 2010 in Visual Studio 2010. My custom action appears in Designer in the action list just like it's supposed to, but when I click on it it does not appear in the workflow. I don't get any error messages throughout the development process, and Designer seems to have no trouble with knowing the action is there and there is an assembly associated with it.

Solution :

I have checked application web.config file and found that <authorizedType Assembly="DocToPDFActivity, Version=1.0.0.0, Culture=neutral, PublicKeyToken=2478de059b6051f4" Namespace="DocToPDFActivity" TypeName="*" Authorized="True" /> is configure in it.

So Just i have added it and reset IIS.

After I have checked Workflow action UI and it appears.

Cheers.

Word To PDF - Sharepoint 2010

2011-03-04T22:26:00.000-08:00

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

http://www.microsoft.com/resources/msdn/en-us/office/media/video/office.html?cid=office-video&VideoID=e784efe4-bf2a-4777-b15f-b5a59cecfe64&from=mscomoffice

Error occurred in deployment step 'Recycle IIS Application Pool': Cannot connect to the SharePoint site. Error occurs while deploying SharePoint solut

2011-03-04T22:20:00.000-08:00

In Visual Studio 2010 while deploying SharePoint solutions, sometime we see this error
“Error occurred in deployment step 'Recycle IIS Application Pool': Cannot connect to the SharePoint site. If you moved this project to a new computer or if the URL of the SharePoint site has changed since you created the project, update the Site URL property of the project.”

This is because we forgot to mention the Site URL where we are going to deploy this solution. After specifying site URL, deployment went well.

Site URL will be your SharePoint site i.e. http://MOSS:2000.

How To Write Exception error In Sharepoint Log File

2011-02-13T23:16:00.000-08:00

Add Microsoft.Office.Server dll in your project, you can find this dll under “\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI\”.

The log files are found under \Common Files\Microsoft Shared\Web Server Extensions\12\Log\. Following line of code is used to write exception in sharepoint default log file.

Microsoft.Office.Server.Diagnostic.PortalLog.LogString(“Exception – {0} – {1} – {2}”,”Log Message”,ex.Message,ex.StackTrace);

Create Custom WCF service for MOSS 2010 and Use it as External Content Type

2011-02-12T02:17:00.000-08:00

Hi Friends,

Below are some links which have nice article regarding WCF Service and deploy BCS Service in sharepoint 2010.

http://www.c-sharpcorner.com/UploadFile/gaikwaduc/2842/

http://malikhan.wordpress.com/2010/01/11/business-connectivity-services-bcs-using-wcf-sharepoint-designer-2010/

http://weblogs.asp.net/sreejukg/archive/2010/12/15/create-and-consume-wcf-service-using-visual-studio-2010.aspx

http://sharepointlink.blogspot.com/2010/03/host-wcf-data-service-in-sharepoint.html

http://sharepointlink.blogspot.com/2010/03/host-wcf-services-in-sharepoint-2010.html

http://www.codefornuts.com/2010/04/building-and-deploying-wcf-service-to.html

Disable SharePoint DataTime Control Event

2011-02-09T05:27:00.000-08:00

((TextBox)(dtduedate.Controls[0])).Attributes.Add("onKeyPress", "DisbleEnterKey();");

SharePoint DateTime control returning current date when no date is selected

2011-02-05T08:11:00.000-08:00

In WSS 3.0/4.0, I am using sharePoint DateTime control. I retrieve the date selected by the user using SelectedDate property of the sharePoint DateTime control.

The issue is that even when the user has not selected any date in the sharePoint DateTime control, the SelectedDate property of the sharePoint DateTime control returns current date.

Solution :

if (dt.IsDateEmpty)
{
objdt = DBNull.Value;
}
else
{
objdt = dt.SelectedDate.ToString();
}

Parser Error in sharepoint

2010-12-28T20:15:00.000-08:00

Today I have faced parser error in SharePoint when someone has changed compat.browser file in SharePoint designer.

After searching in Google, I found that some of file App_Browsers folder was corrupted. I have deleted file from folder and reset IIS. My site is working fine.

Custom Webservice in Sharepoint

2010-12-16T09:17:00.000-08:00

http://malikhan.wordpress.com/2009/08/07/creating-custom-webservice-in-sharepoint-2007/

SharePoint search using FullTextSqlQuery

2010-12-04T21:45:00.000-08:00

//SharedServices2 refers to the Shared Service Provider servicing
ServerContext context = ServerContext.GetContext("SharedServices2");
FullTextSqlQuery qrySearch = new FullTextSqlQuery(context);
//Specifies the results set containing the main search results from
//the content index matching the search query.
qrySearch.ResultTypes = ResultType.RelevantResults;
//Sremming : expansion of searches to include plural forms and
//other word variations :-)
qrySearch.EnableStemming = true;
qrySearch.TrimDuplicates = false;
qrySearch.QueryText = "SELECT URL, Title, Size, Write, HitHighlightedSummary FROM SCOPE() where \"scope\"='NTFS Archive' And FREETEXT(*,'" + TextBox1.Text.Trim() +
"')";
ResultTableCollection results = qrySearch.Execute();
ResultTable resultTable = results[ResultType.RelevantResults];
// Data Table to Store Search Results
DataTable dtResults = new DataTable();
dtResults.Load(resultTable, LoadOption.OverwriteChanges);

Sharepoint 2010 Solution Installer

2010-11-20T05:17:00.000-08:00

http://netindonesia.net/blogs/andriyadi/archive/2010/02/27/sharepoint-2010-solution-installer.aspx

Unable to cast object of type 'Microsoft.SharePoint.Administration.SPWebApplication' to type 'Microsoft.SharePoint.SPSite

2010-11-12T08:57:00.000-08:00

Today I have found error "Unable to cast object of type Microsoft.SharePoint.Administration.SPWebApplication' to type 'Microsoft.SharePoint.SPSite" during deploy moss 2010 solution.

I have set scope as "Site" and due to that above issue is occured.
I have changed scope as "WebApplication" and rebuild it and after deploy it.
So Its working Fine and solution is deployed successfully.

Cheers.

Workflow Custom Activity in MOSS 2010

2010-11-12T08:52:00.000-08:00

http://www.zimbio.com/VisualStudio/articles/qMY82wdzeBR/Walkthrough+3+SharePoint+Designer+Workflows
http://sharepointbloggin.com/2010/02/10/walkthrough-3-sharepoint-designer-workflows-imported-to-visual-studio-2010/

an unhandled exception occurred in the silverlight application sharepoint 2010

2010-11-04T07:14:00.000-07:00

I guess it's a product bug. Just Enable the Security Validation from Manage Web Applications --> General Settings (from ribbon).

Silverlight Application is unable to connect to the WCF endpoint configured by the product for enabling Client Object Model, if Security validation is set to Off.

Enjoy...

Could not load type ‘System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=3.5.0.0, Culture=neutral,

2010-10-05T09:55:00.000-07:00

I wanted to use the new REST services in SharePoint 2010. But when I navigated to the ListData.svc service. I got the following error:

Could not load type ‘System.Data.Services.Providers.IDataServiceUpdateProvider’ from assembly ‘System.Data.Services, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089′.

does not provide many hints to what is causing this error. Most sites suggest to install ADO.NET Data Services v1.5 CTP2, but I already had.

I have found solution from one of sharepoint blog which asking to install dll patch on sharepoint server.

For Windows 7 AND Windows Server 2008 R2Download the ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 7 and Windows Server 2008 R2.

After installing the version of the System.Data.Services.dll file is 3.5.30729.5004.

For Windows 2000, Windows XP, Windows Vista, Windows Server 2003 AND Windows Server 2008Download the ADO.NET Data Services Update for .NET Framework 3.5 SP1 for Windows 2000, Windows Server 2003, Windows XP, Windows Vista and Windows Server 2008.

After installing the version of the System.Data.Services.dll file is 3.5.30729.4466.

Configure My Site in MOSS 2010

2010-09-20T07:10:00.000-07:00

http://sharepointgeorge.com/2010/configuring-my-site-sharepoint-2010/

MOSS 2010 Services and configuration

2010-09-20T07:03:00.000-07:00

http://www.astaticstate.com/2010/07/how-to-create-local-sharepoint-2010.html

User Profile Synchronization error MOSS MA not found

2010-09-17T08:59:00.000-07:00

I had this problem and found that the Forefront Identity Management Service was not running I went into Start -> Administrator Tools -> Services and started it and everything worked !

I can confirm that the resolution to this issue is to restart the following services:
- Forefront Identity Manager Service
- ForeFront Identity Manager Synchronization Service

Through Services in Administrative Tools (or services.msc in Run command).

Powerpoint and WordViewer services not found in MOSS 2010

2010-09-12T03:29:00.000-07:00

Hi friend,
I have checked my central administration and found that powerpoint and word viewer services are not installed on server. I have googling and found that Microsoft Web Application patch is needed for this service.

Below are some reference link which have mentioned how to install and configure powerpoing and word viewer services on central admin.

http://technet.microsoft.com/en-us/library/ff431687.aspx
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=27d81b1c-18ae-4983-8e1c-224bb747eb99&displaylang=en
http://support.microsoft.com/kb/2028346
http://www.sharepoint24x7.com/tag/sharepoint-foundation-2010/

MOSS 2010 Application Service

2010-09-11T08:53:00.000-07:00

(1) Access Services View/Edit/Interact with Access 2010 DB’s in the browser Cache
(2)Business Data Connectivity Access LOB data DB
(3)Excel Services View/Edit/Interact with Ecel 2010 files Cache
(4)Managed Metadata Service Access managed taonomy hierarchies, keywords, and social tagging infrastructure as well as Content Type publishing across site collections DB
(5)PerformancePoint Provides the capabilities of PerformancePoint Services Cache
(6)PowerPoint View/Edit/Broadcast PowerPoint presentations in a web browser Cache
(7)Search Crawls content, produces inde partitions, serves search queries DB
(8)Secure Store Services Provides single sign-on authentication to access multiple applications or services DB
(9)State Service Provides Temporary Storage of user session data for SharePoint Server components DB
(10)Usage and Health Data Collection Collects farm wide usage and health data and provides the ability to view various reports DB
(11)User Profile Adds support for My Sites, Profile pages, Social Tagging, and other social computing features DB
(12)Visio Graphics Service Viewing and refreshing of Visio diagrams in the browser BLOB cache
(13)Web Analytics Provides Web Service interfaces

Performance Point Service in MOSS 2010

2010-09-11T08:48:00.000-07:00

http://blogs.msdn.com/b/performancepoint/archive/2009/11/24/deploying-performancepoint-2010-soup-to-nuts.aspx

Request for permission of type 'Microsoft.Office.Access.Server.Security.AccessServicesPermission,

2010-09-09T11:02:00.000-07:00

Below are steps to solve above problem

(1) Modify the C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config file on the Reporting Services server. Under the node, under the node, add the ADS data extension. For example:
<Extension Name="ADS" Type="Microsoft.Office.Access.Reports.DataProcessing.AdsConnection, Microsoft.Office.Access.Server.DataServer, Version=14.0.0.0, Culture=Neutral, PublicKeyToken=71e9bce111e9429c"/> -->

(2)Modify the rssrvpolicy file on RS server.

Add the following XML code in the file under the node.

<PermissionSet class="NamedPermissionSet" version="1" Name="ReportExpressionsDefaultPermissionSet">
<IPermission class="SecurityPermission" version="1" Flags="Execution" />
<IPermission class="Microsoft.Office.Access.Server.Security.AccessServicesPermission, Microsoft.Office.Access.Server.Security,
Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" version="1.0" Flags="CalculationCallback" />
</PermissionSet>

(3) In the node, find the following line and change PermissionSetName from “Execution” to “ReportExpressionsDefaultPermissionSet”

<CodeGroup class="UnionCodeGroup" version="1" PermissionSetName="Execution" Name="Report_Expressions_Default_Permissions"
Description="This code group grants default permissions for code in report expressions and Code element. ">

You tried to use an extension for the data 'ADS' not registered for this report server or not supported in this edition of Reporting Services

2010-09-09T09:50:00.000-07:00

(1) Go

C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config

(2)Remove the comment markers () off of the Data Extension for ADS.

(3) Once the comments were removed from the ADS extension, the SQL reports began working immediately.

Integration Reporting Services with MOSS 2010

2010-09-09T09:47:00.001-07:00

http://blogen.siderys.com/2010/02/installing-reporting-service.html
http://phase2.com/blog/?p=1320

Adding Custom Actions to the Ribbon UI in SharePoint 2010 Using SharePoint Designer 2010

2010-08-22T02:13:00.000-07:00

http://www.endusersharepoint.com/2010/02/19/adding-custom-actions-to-the-ribbon-ui-in-sharepoint-2010-using-sharepoint-designer-2010/

MOSS 2010

2010-08-15T05:13:00.000-07:00

MOSS 2010 Installation Step Link :
http://www.khamis.net/blog/Lists/Posts/Post.aspx?List=6c8a23d1%2D47ea%2D47e5%2Db56f%2D2bc57cb95b93&ID=48
Configure User Profile Synchronization Service : http://www.sharepointdevwiki.com/display/spadmin2010/15+-+Configure+User+Profile+Synchronization+Service://

SQL Server 2008 :
http://www.sql-server-performance.com/articles/dba/Steps_to_Install_SQL_Server_2008_p1.aspx

Sharepoint designer : Workflow is not start automatically

2010-06-08T07:01:00.000-07:00

I’ve been playing with SharePoint Designer Workflows heavily for the past few days. Suddenly I came across the problem of these workflows does not start automatically though I select the option to start the workflow when an item is created or modified in a list or library.
Browse the web and found the reason of installing Windows SharePoint Services 3.0 Service Pack 1 which caused the problem. This behavior occurs because a security fix in Windows SharePoint Services 3.0 SP1 prevents declarative workflows from starting automatically under the system account.

You could fall in to 1 of the 3 scenarios given below while you faced this problem…
1) The Windows SharePoint Services Web application runs under a user's domain account.
2) The user logs in by using this domain account.
3) The site displays the user name as System Account.
Answer / Solution
Set the application pool to use a different user account than System Account.
Step by Step Guide.
1) Open SharePoint Central Administration.
2) Go to Operations Tab.
3) Under Security Configurations click on Service Accounts.
4) Select “Web application pool” option button.
5) In the web service drop down box select “Windows SharePoint Services Web Application”.
6) And in the Application pool drop down, select the application pool you want.
7) Next select the “Configurable” option button and then type the user name and password of a user having rights to assign to an application pool.

8) Go to command prompt and type iisreset /noforce
9) Make sure to test the workflow log-in in to SharePoint other than System Account.

Using SharePoint Calculated Columns to Display Current Month List Items

2010-05-31T22:19:00.000-07:00

Created First Day Of Month
=DATE(YEAR([Created]),MONTH([Created]),1)
Created Last Day Of Month
=DATE(YEAR([Created]),MONTH([Created])+1,1)-1

I then added the below filters to view:

Richtextbox in sharepoint

2010-05-31T04:30:00.000-07:00

<%@ Register TagPrefix="SharePointSD" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral,PublicKeyToken=71e9bce111e9429c" %>

<SharePointSD:InputFormTextBox runat="server" ID="RichTextBox" ValidationGroup="CreateCase" Rows="8" Columns="40" RichText="true" RichTextMode="FullHtml" AllowHyperlink="true" TextMode="MultiLine" />

Microsoft.SharePoint.SPListItem.PrepareItemForUpdate + SPWorkflowTask.AlterTask + Task not updated

2010-05-30T04:59:00.000-07:00

Hi Guys,

Today I have tried to updated task list item in workflow but everytime i was getting Microsoft.SharePoint.SPListItem.PrepareItemForUpdate error when updated item.

I have used taskcontenttype for aspx task form in my workflow. I have updated task using SPWorkflowTask.AlterTask but not solved my problem.

Solution :

Put FieldRefs in contentType XML.

<?xml version="1.0" encoding="utf-8"?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">
<ContentType ID="0x01080100DB4541EA29924902A6635A9D335C698B"
Name="SOP Issue WF Content Type1"
Group="SOP Issue"
Description="SOP Issue WF Content Type Task"
Version="0"
Hidden="FALSE">
<FieldRefs>

</FieldRefs>
<XmlDocuments>
<XmlDocument NamespaceURI="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
<FormUrls xmlns="http://schemas.microsoft.com/sharepoint/v3/contenttype/forms/url">
<New>_layouts/SOPIssueWF/Task1EditForm.aspx</New>
<Display>_layouts/SOPIssueWF/Task1EditForm.aspx</Display>
<Edit>_layouts/SOPIssueWF/Task1EditForm.aspx</Edit>
</FormUrls>
</XmlDocument>
</XmlDocuments>
</ContentType>
</Elements>

How to get current logged in user in sharepoint object model

2010-05-27T02:28:00.000-07:00

using (SPSite site = new SPSite(SPContext.Current.Web.Url.ToString()))
{
using (Microsoft.SharePoint.SPWeb web1 = site.OpenWeb())
{
using (Microsoft.SharePoint.SPWeb web = SPControl.GetContextWeb(Context))

{

SPUser currentuser = web.CurrentUser;

}
}
}

MOSS 2007 Problem : Cannot connect to the configuration database.

2010-05-18T07:40:00.000-07:00

Hi Guys,

During my work with MOSS 2007,i had some performance issues regarding the SQL Server instance services which is running the configuration and Data for MOSS sites.

I had closed this service bymistake and when i'm trying to open the central administration site or any site i got this message in the IR:

"Cannot connect to the configuration database."

To resolve this : go to your services and start this service:
"SQL Server (MSSQLSERVERS)"

This Tip is enough to continue your work with your MOSS sites.

Hope this helps

Error message when you try to upload a large file to a document library on a Windows SharePoint Services 3.0 site: "Request timed out"

2010-05-04T09:28:00.001-07:00

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

Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser.

2010-04-19T23:35:00.000-07:00

Today I am facing save conflict problem when i am updating list item during itemupdating event.

I have found solution after Research.

using (SPSite oSiteCollection = new SPSite(properties.WebUrl.ToString()))
{
using (SPWeb oWebsiteRoot = oSiteCollection.OpenWeb())
{
int count = 0;
oWebsiteRoot.AllowUnsafeUpdates = true;

SPList list = oWebsiteRoot.Lists[properties.ListId];
SPListItem oItem = list.GetItemById(properties.ListItemId);
if (oItem["Request_x0020_Counter"] != null && oItem["Request_x0020_Counter"].ToString() != string.Empty)
{
count += Convert.ToInt32(oItem["Request_x0020_Counter"].ToString()) + 1;
}
else
{
count += count + 1;
}
properties.AfterProperties["Request_x0020_Counter"] = count;

}
}

PDF Convertor for SharePoint

2010-04-16T06:54:00.000-07:00

Hi Guys,

I have uploaded word to pdf feature in codeplex. Please find attachment in source code tab in below link.

Link : http://word2pdf.codeplex.com/

Programmatically update workflow history on specific list

2010-04-15T05:20:00.000-07:00

using (SPSite site = new SPSite("http://MOSS:5858"))

{

using (Microsoft.SharePoint.SPWeb web = site.OpenWeb())

{

web.AllowUnsafeUpdates = true;

SPList historyList = web.Lists["Workflow History"];

SPListItem item = historyList.Items.Add();

item["Description"] = "testing";

item["WorkflowInstance"] = "{7CF46B1F-42C8-4E0A-80D3-EBEFD670AC63}";

item.Update();

}

}

Programmatically Update Hyperlink in sharepoint list

2010-04-15T03:04:00.000-07:00

SPFieldUrlValue linkUrl = new SPFieldUrlValue();
linkUrl.Description = "Completed";
linkUrl.Url = "http://www.google.co.in"
item["WF Status"] = linkUrl;

MOSS 2007 Script Collection

2010-04-10T22:22:00.000-07:00

http://www.powershell.nu/2009/09/08/moss-2007-script-collection/

Errors were found when compiling the workflow.The workflow files were saved but cannot be run.

2010-04-05T06:16:00.000-07:00

I have installed third party feature on sharepoint after that this problem is created.

Solution :

Check web.config file authorizedTypes section.

Sharepoint Shortcut Name

2010-03-31T23:04:00.001-07:00

BDC = Business Data Catalog and Backup Domain Controller

BI = Business Intelligence

CA = Central Administration and Certificate Authority

CMS = Content Management Server

DMZ = Demilitarized Zone

ECM = Enterprise Content Management

ECS = Excel Calculation Server

KPI = Key Performance Indicators

IIS = Internet Information Services

ISA = Internet Security and Acceleration Server

MMC = Microsoft Management Console

MOSS = Microsoft Office SharePoint Server 2007

O12 = Office 12

OFS = Office Forms Server

OSS = Office SharePoint Server, Office Server System and Open Source System

PDC = Primary Domain Controller

PKI = Public Key Infrastructure

RFC = Request for Comments

SPS = SharePoint Portal Server

SSL = Secure Sockets Layer

STS = SharePoint Team Services

SSP = Shared Services Provider

TLS = Transport Layer Security

URL = Uniform Resource Locater

URN = Uniform Resource Name

URI = Uniform Resource Identifier

VS = Virtual Server 2005, Virtual Server and Visual Studio

VSS = Visual Source Safe, Volume Shadow Copy Service

WA = Web Application

WAS = Web Application Stress tool

WCM = Web Content Management

WSS = Windows SharePoint Services, Web Storage System and Windows Server System

WWF = Windows Workflow Foundation and Worldwide Wrestling Federation

SharePoint jQuery: Setting View Column Width

2010-03-24T22:35:00.000-07:00

A very common request for changes to SharePoint list views is how to set the column width. This is not possible to do using the ootb "List Settings", and the common suggested fix is to use SharePoint Designer (SPD) and convert the view into an "XSLT Data View": How can I manage columns widths in list views? Most large companies do, however, prevent the use of SPD.

With jQuery there is no need to use SPD or to convert the view. In the following example jQuery will change the width of the two columns "Status description" and "Type of Work" by changing their CSS style attribute.

Start by looking up the HTML markup for the two table headers using View-Source. I'm using jQuery filters that look for the TH elements using a CSS class selector and a content filter. Then add a Content Editor web-part (CEWP) to your page and enter this script in the source editor:


<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.2.6/jquery.min.js" type="text/javascript"></script>
<script type="text/javascript">
$(function(){
$("TH.ms-vh2-nograd:contains('Status description')").css("width", "150px");
$("TH.ms-vb:contains('Type of Work')").css("width", "150px");
});
</script>

This solution contains no resources scoped for a Web application and cannot be deployed to a particular Web application

2010-03-23T02:22:00.000-07:00

Scenario:
You scoped your solution to WebApplication and trying to deploy the solution to a particular Web Application

Error:
This solution contains no resources scoped for a Web application and cannot be deployed to a particular Web application.

OR

This solution contains no resources scoped for a Web application and cannot be retracted from a particular Web application.

Reason:
Its because of the parameters passed to STSADM , basically features included in the solution does not contain an assembly which can be scoped to a particular Web Application. What ever assemblies are part of solution are suppose to go GAC and that makes solution a candidate for Global deployment.

Resolution:
Before you read the resolution below: Here's a comment that seems to be more better solution

"Better fix your solution by adding some dummy element that will make the solution deploy-able to a web application. If you have multiple web applications in your farm, usually you don't want to deploy your feature to all of them."

If that is not possible

Remove the URL parameter from STSADM. Do not use the Url parameter with the STSADM command while deploying or retracting such a solution

stsadm -o deploysolution -name SolutionFileName -local stsadm -o retractsolution -name SolutionFileName -local

How to get display form URL of a list item

2010-03-22T04:37:00.000-07:00

using Microsoft.SharePoint;
using Microsoft.SharePoint.Utilities;

SPListItem item = GetItem(); // some code to get a list item
SPList list = item.ParentList;
SPWeb web = list.ParentWeb;

string webUrl = web.Url;
string dispUrl = item.ContentType.DisplayFormUrl;
if(dispUrl == "")
dispUrl = list.Forms[PAGETYPE.PAGE_DISPLAYFORM].Url;
bool isLayouts = dispUrl.StartsWith("_layouts/",StringComparison.CurrentCultureIgnoreCase);
dispUrl = String.Format("{0}/{1}?ID={2}",webUrl,dispUrl,item.ID);
if(isLayouts)
dispUrl = String.Format("{0}&List={1}",dispUrl,SPEncode.UrlEncode(list.ID+""));

As a result, you will get full display form URL of a list item. However, if you want to get just a “clickable” URL, to place in some hyperlink, you don’t need to write so much code. You may create URL by using only an address of a list display form. SharePoint will analyze provided ID of an item then and redirect your request to appropriate page. You may code just:

SPListItem item = GetItem(); // some code to get a list item
SPList list = item.ParentList;
SPWeb web = list.ParentWeb;
string webUrl = web.Url;
string dispUrl = list.Forms[PAGETYPE.PAGE_DISPLAYFORM].Url;;
dispUrl = String.Format("{0}/{1}?ID={2}",webUrl,dispUrl,item.ID);

Troubleshooting SharePoint Alerts

2010-03-21T23:48:00.000-07:00

Below is good link for sharepoint alerts.

http://sharepointalert.info/troubleshooting-sharepoint-alerts/

SharePoint DateTime Control Date Format

2010-03-17T21:42:00.000-07:00

Normally Sharepoint Datetime control take MM/dd/yyyy date format by default. If your sharepoint site regional settings is different then its mandetory to change date time control property to set original date format for sharepoint control.

<SharePoint: DateTimeControl runat="server".... />

Put

LocaleId="2057"

before the /> bit at the end.

Sharepoint 2010 Key Improvements from MOSS

2010-03-17T01:52:00.001-07:00

Thanks to Sushant

Date Time Control In Sharepoint

2010-03-14T23:38:00.000-07:00

<%@ Register TagPrefix="SharePointSD" Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c" %>
<div>
<table>
<tr>
<td style="width: 100px">
Start Date</td>
<td style="width: 100px">
<SharePointSD:DateTimeControl runat="server" ID="dteDemo1" DateOnly="True">
<asp:TextBox runat="server" MaxLength="45" CssClass="ms-input" ID="dtpDateTimeIdentifierTextBox1">
</asp:TextBox>
</SharePointSD:DateTimeControl>
</td>
<td style="width: 100px">
End Date</td>
<td style="width: 100px">
<SharePointSD:DateTimeControl runat="server" ID="dteDemo2" DateOnly="True">
<asp:TextBox runat="server" MaxLength="45" CssClass="ms-input" ID="dtpDateTimeIdentifierTextBox2">
</asp:TextBox>
</SharePointSD:DateTimeControl>
</td>
</tr>
<tr>
<td style="width: 100px">
</td>
<td colspan="3">
<asp:CompareValidator id="cv" runat="server" ForeColor="red" Type="date" Operator="GreaterThan" ErrorMessage="End Date shoule be greater than start date"

ControlToCompare="dteDemo1$dteDemo1Date" ControlToValidate="dteDemo2$dteDemo2Date" ></asp:CompareValidator></td>
</tr>

</table>

</div>

Free Weather Web part

2010-02-10T01:37:00.000-08:00

using System;
using System.Collections;
using System.Configuration;
using System.IO;
using System.Net;
using System.Web;
using System.Web.Caching;
using System.Web.UI;
using System.Web.UI.WebControls.WebParts;
using System.Xml;

public partial class Weather : System.Web.UI.UserControl
{
protected int _HttpTimeout = 30;
protected DateTime _InstallDate;
protected string _LicenseKey = "";
protected string _Location = "USGA0029;INXX0102;INXX0130";
protected bool _ShowDetails;
protected bool _Units = false;
public static string licenseInfo = "";
protected void Page_Load(object sender, EventArgs e)
{
weathercontrol();
}
protected void weathercontrol()
{
string str = "";
string str2 = "";
int num = 1;
string str3 = this._LicenseKey;

if (num == 0)
{
}
else
{
if (!string.IsNullOrEmpty(this._Location))
{
string[] strArray2 = this._Location.Split(new char[] { ';' });
string str4 = "f";
if (this._Units)
{
str4 = "c";
}
foreach (string str5 in strArray2)
{
string key = "YahooWeather" + str5 + str4;
string str7 = null;
try
{
str7 = (string)HttpContext.Current.Cache[key];
}
catch (Exception exception)
{
Label1.Text=("Cache Fetch Error:" + exception.Message);
}
if (str7 == null)
{
try
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create("http://weather.yahooapis.com/forecastrss?p=" + str5 + "&u=" + str4);
request.Timeout = this._HttpTimeout * 0x3e8;
WebResponse response = request.GetResponse();
StreamReader reader = new StreamReader(response.GetResponseStream());
str7 = reader.ReadToEnd();
reader.Close();
response.Close();
}
catch (Exception exception2)
{
Label1.Text=("Error accessing the Yahoo weather service:" + exception2.Message);
return;
}
try
{
HttpContext.Current.Cache.Add(key, str7, null, DateTime.Now.AddHours(1.0), Cache.NoSlidingExpiration, CacheItemPriority.Normal, null);
}
catch (Exception exception3)
{
Label1.Text=("Cache Add Error:" + exception3.Message);
}
}
try
{
XmlDocument document = new XmlDocument();
document.LoadXml(str7);
XmlNodeList list = document.SelectNodes("rss/channel/item/title");
string innerText = "";
string str9 = "";
foreach (XmlNode node in list)
{
innerText = node.InnerText;
if (innerText.StartsWith("Conditions for"))
{
innerText = innerText.Substring(14);
}
int index = innerText.IndexOf(" at");
if (index > 0)
{
str9 = innerText.Substring(index + 4);
innerText = innerText.Remove(index);
}
}
XmlNodeList list2 = document.SelectNodes("rss/channel/item/link");
string str10 = "";
foreach (XmlNode node2 in list2)
{
str10 = node2.InnerText;
}
string attribute = "";
foreach (XmlElement element in document.GetElementsByTagName("yweather:units"))
{
attribute = element.GetAttribute("temperature");
}
string str12 = "";
foreach (XmlElement element2 in document.GetElementsByTagName("yweather:condition"))
{
str12 = element2.GetAttribute("code");
}
string str13 = "";
string str14 = "";
if (this._ShowDetails)
{
foreach (XmlElement element3 in document.GetElementsByTagName("yweather:atmosphere"))
{
str13 = element3.GetAttribute("humidity");
}
foreach (XmlElement element4 in document.GetElementsByTagName("yweather:wind"))
{
str14 = element4.GetAttribute("speed");
}
}
string str16 = str + "<table border=0 cellpadding=2 cellspacing=0 width='20%'>";
//str = ((str16 + "<tr bgcolor=#f3f3f3><td colspan=2><strong><a href='" + str10 + "' target=_blank>" + innerText + "</a></strong></td>") + "<td align=right><font color=#2797C7>" + str9 + "</font></td></tr>") + "<tr bgcolor=#bcbcbc height=1><td colspan=3></td></tr>" + "<tr bgcolor=#fbfbfb>";
str = ((str16 + "<tr bgcolor=#f3f3f3><td colspan=3><strong>" + innerText + " </strong></td>") + "</tr>") + "<tr bgcolor=#bcbcbc height=1><td colspan=3></td></tr>" + "<tr bgcolor=#fbfbfb>";

foreach (XmlElement element5 in document.GetElementsByTagName("yweather:condition"))
{
str = str + "<td valign=top width=110 align=center style='border-right:1px dotted #D0D0D0;color:#808080'><br />";
string strimage = "http://l.yimg.com/a/i/us/we/52/" + str12 + ".gif";

str = str + "<img src='" + strimage + "'><br />";

//str = str + "<img src='" + this.Page.ClientScript.GetWebResourceUrl(base.GetType(), "WeatherWebpart.Gif." + str12 + ".gif") + "'><br />";
str16 = str;
str = str16 + "<span style='font-size:14pt; font-family:arial,helvetica; line-height:18pt; color:#333333; font-weight:bold'>" + element5.GetAttribute("temp") + "°" + attribute + "</span><br />";
str = str + "<span style='color:gray'>" + element5.GetAttribute("text") + "</span>";
if (this._ShowDetails)
{
str = str + "<br />Humidity:" + str13 + "%";
str = str + "<br />Wind:" + str14 + " mph";
}
str = str + "</td>";
}
//foreach (XmlElement element6 in document.GetElementsByTagName("yweather:forecast"))
//{
// str = str + "<td width=110 valign=top align=center style='border-right:1px dotted #D0D0D0'>";
// string str15 = element6.GetAttribute("day").Replace("Sun", "Sunday").Replace("Mon", "Monday").Replace("Tue", "Tuesday").Replace("Wed", "Wednesday").Replace("Thu", "Thursday").Replace("Fri", "Friday").Replace("Sat", "Saturday");
// str = str + "<font color=#808080><b>" + str15 + "</b></font><br />";
// string strimage = "http://l.yimg.com/a/i/us/we/52/" + element6.GetAttribute("code") + ".gif";
// str = str + "<img src='" + strimage + "'><br />";

// //str = str + "<img src='" + this.Page.ClientScript.GetWebResourceUrl(base.GetType(), "WeatherWebpart.Gif." + element6.GetAttribute("code") + ".gif") + "'><br />";
// str16 = str;
// str = str16 + "<span style='font-size:8pt; line-height:12pt; color:black; font-weight:bold'>" + element6.GetAttribute("low") + "°" + attribute + ".." + element6.GetAttribute("high") + "°" + attribute + "</span><br />";
// str = str + "<span style='color:gray'>" + element6.GetAttribute("text") + "</span>";
// str = str + "</td>";
//}
str = str + "</tr></table><br/>";
}
catch (Exception exception4)
{
Label1.Text=("Error parsing the Yahoo XML document:" + exception4.Message);
return;
}
}
}
else
{
str = "Please specify a location";
}

Label1.Text = str;
//if (str2 != "")
//{
// Response.Write("<br>" + str2);
//}
}
}
}

Upload file from Document library to FTP Server

2009-11-29T23:09:00.000-08:00

protected void PhotoUploadProcess()
{
try
{
// Get Current user and his last name
SPUser user = SPContext.Current.Web.CurrentUser;
username = user.Name;
smtpTo = user.Email;
strarray = username.Split(sepcomma);
userLastname = strarray[0].ToString();
//SPSecurity.RunWithElevatedPrivileges(delegate()
//{

//sharepoint site and web object
using (SPSite site = new SPSite(SPContext.Current.Site.Url.ToString() + "/Test"))
{
using (Microsoft.SharePoint.SPWeb web = site.OpenWeb())
{
SPList lstphoto = web.Lists["Test"];
web.AllowUnsafeUpdates = true;
string folderName;
int plenth = userLastname.Length - 1;
folderName = "Test" + "/" + userLastname.Substring(0, userLastname.Length - plenth);
SPFolder ImageFolder = web.GetFolder(folderName);

// Check whether sub folder is exist or not. If not, create folder in doc lib in user's last name first character format.
if (!ImageFolder.Exists)
{
SPFolderCollection myFolderCollection = web.GetFolder("PFPhyPic").SubFolders;
myFolderCollection.Add(userLastname.Substring(0, userLastname.Length - plenth));

}

// File input stream to read image and save it into document library
if (fileupload.PostedFile.ContentLength > 0)
{

Stream fStream;
SPFileCollection files = ImageFolder.Files;
fStream = fileupload.PostedFile.InputStream;
// Read file in a byte array
byte[] MyData = new byte[fStream.Length];
fStream.Read(MyData, 0, (int)fStream.Length);
strImagename = "123456.jpg";

SPFile filedata = files.Add(strImagename, MyData, true);
Int32 id = filedata.Item.ID;
strImagepath = SPContext.Current.Site.Url.ToString() + "/" + filedata.ServerRelativeUrl;

//update unique name
SPListItem lItemUser = null;
lItemUser = lstphoto.Items.GetItemById(id);
lItemUser["UniqueName"] = lblUID.Text;
lItemUser.Update();

lblMsg.Text = "Photo is uploaded successfully.";
btnCancel.Text = "Next =>";
// SPUtility.SendEmail(SPContext.Current.Web, false, false, useremailid, "Test Email", "Test");

//copy file to local server

try
{
System.IO.Directory.CreateDirectory("C:/FTPLOCALCOPY\\");
strlocalpath = @"C:/FTPLOCALCOPY/" + strImagename;

FileStream fs = new FileStream(strlocalpath, FileMode.Create);
BinaryWriter binaryWriter = new BinaryWriter(fs);

binaryWriter.Write(MyData);
binaryWriter.Close();

}
catch (Exception ex)
{

}

}

}
}
//});

}
catch (Exception ex)
{
lblMsg.Text = ex.Message.ToString();

}
}

public void uploadFileUsingFTP(string CompleteFTPPath, string CompleteLocalPath, string UName, string PWD, string domain)
{
try
{

//Create a FTP Request Object and Specfiy a Complete Path
FtpWebRequest reqObj = (FtpWebRequest)WebRequest.Create(CompleteFTPPath);

//Call A FileUpload Method of FTP Request Object
reqObj.Method = WebRequestMethods.Ftp.UploadFile;

//If you want to access Resourse Protected You need to give User Name and PWD
reqObj.Credentials = new NetworkCredential(UName, PWD, domain);

//FileStream object read file from Local Drive
FileStream streamObj = File.OpenRead(CompleteLocalPath);

//Store File in Buffer
byte[] buffer = new byte[streamObj.Length + 1];

//Read File from Buffer
streamObj.Read(buffer, 0, buffer.Length);

//Upload File to ftp://localHost/ set its object to nothing

reqObj.GetRequestStream().Write(buffer, 0, buffer.Length);

//Close FileStream Object Set its Value to nothing

streamObj.Close();

streamObj = null;

reqObj = null;
}
catch (Exception ex)
{
lblMsg.Text = ex.Message.ToString();

}

}

send an e-mail with attachment from SharePoint

2009-11-25T22:37:00.000-08:00

One of the ways to send an e-mail from SharePoint as developer, is to make use of the “SPUtility.SendEmail” classes. But unfortunately I did not find any possibility to include an attachment with the help of these classes.

I have used SPAdministrationWebApplication for used shaerpoint email credential and send email with attachement through system.net class.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.SharePoint;
using System.IO;
using Microsoft.SharePoint.Utilities;
using System.Net.Mail;
using Microsoft.SharePoint.Administration;
using System.Net;

//Get the Sharepoint SMTP information from the SPAdministrationWebApplication
string smtpServer = SPAdministrationWebApplication.Local.OutboundMailServiceInstance.Server.Address;
string smtpFrom = SPAdministrationWebApplication.Local.OutboundMailSenderAddress;

//Create the mail message and supply it with from and to info
MailMessage mailMessage = new MailMessage(smtpFrom, smtpTo);

//Set the subject and body of the message
mailMessage.Subject = "Test";
mailMessage.Body = "test email .";

//Download the content of the file with a WebClient
WebClient webClient = new WebClient();

//Supply the WebClient with the network credentials of our user
webClient.Credentials = CredentialCache.DefaultNetworkCredentials;

//Download the byte array of the file
byte[] data = webClient.DownloadData(imagepath);

//Dump the byte array in a memory stream because
//we can write it to our attachment
MemoryStream memoryStreamOfFile = new MemoryStream(data);

//Add the attachment
//mailMessage.Attachments.Add(new System.Net.Mail.Attachment(memoryStreamOfFile, insert_filename_attachment, insert_content_type));
mailMessage.Attachments.Add(new System.Net.Mail.Attachment(memoryStreamOfFile, ImageName));
//, insert_content_type));

//Create the SMTP client object and send the message
SmtpClient smtpClient = new SmtpClient(smtpServer);
smtpClient.Host = "hostname";

//Delivery mothod which get attachement which size is more than 1 MB and immediately send email to user
smtpClient.Port = 2095;
smtpClient.DeliveryMethod = SmtpDeliveryMethod.PickupDirectoryFromIis;
smtpClient.Send(mailMessage);

Hopy this stuff is useful for every developer.

Sharepoint Development: Object Model vs Web Services

2009-11-24T04:11:00.000-08:00

When you've to develop a custom solution based on WSS/MOSS, I see that sometimes there are doubts on what technology to use in order to interop with the Sharepoint platform: should I use the Sharepoint Object Model APIs or should I use Sharepoint Web Services?

Use the Sharepoint Object Model if your code will be executed on a Sharepoint server farm machine. This is the best way if the final application will run on the Sharepoint server or if you're developing a Sharepoint WebPart.

To work with the Sharepoint Object Model, Right-click your Visual Studio project and add a reference to the Microsoft.SharePoint.dll located on the following directory:

C:\program files\common files\microsoft shared\web server extensions\12\isapi

If you're planning to develop a custom application that needs to interact with Sharepoint from a remote client, the best way is to use Sharepoint Web Services (the object model is not designed to support Remoting).

Using SPQuery to filter lists by User & Group Column

2009-11-14T22:02:00.000-08:00

If you want to filter a list based on the value in the look up field that is of type ‘Person or Group’, We have to consider the following options:

Filter by the User Name.
Filter by SPUser ID Property
Filter by Domain User account

Filter by the User Name:

By default the settings for the ‘Person or Group’ column will have the following settings.

The Show Field will have the “Name with Presence” selected.

When we run a SPQuery search on the list using the following code we will be able to filter the list based on the fullname of the user.

 using (SPSite oSite = new SPSite("http://moss:80"))

          {

              using (SPWeb oWeb = oSite.OpenWeb())

              {

                  oList = oWeb.Lists["Project Tasks"];

                  SPQuery query = new SPQuery();

                  query.Query = "<Where><Eq><FieldRef Name='AssignedTo' /><Value Type='User'>Tushar Parikh</Value></Eq></Where>";

                  SPListItemCollection items = oList.GetItems(query);



            }

         }

Filtering by SPUser ID :

If you want to filter the list based on the SPUser ID then follow the steps below.

Add an additional attribute ‘LookupId’ for the queried field in your CAML query

<FieldRef Name='AssignedTo' LookupId='TRUE'/>

using (SPSite oSite = new SPSite("http://moss:80"))

           {

               using (SPWeb oWeb = oSite.OpenWeb())

              {

                  oList = oWeb.Lists["Project Tasks"];

                  SPQuery query = new SPQuery();

                  query.Query = "<Where><Eq><FieldRef Name='AssignedTo' LookupId='TRUE'/><Value Type='User'>7</Value></Eq></Where>";

                 SPListItemCollection items = oList.GetItems(query);

               }

         }

Filtering by Domain User Account :

If you want to filter the list based on the Domain User Account then follow the steps below.

Change the ‘Show Field’ Settings of the Person or Group lookup column to ‘Account’

Modify your code to include the domain account in the filter value.

using (SPSite oSite = new SPSite("http://moss:80"))

{

using (SPWeb oWeb = oSite.OpenWeb())

{

oList = oWeb.Lists["Project Tasks"];

SPQuery query = new SPQuery();

query.Query = "<Where><Eq><FieldRef Name='AssignedTo' /><Value Type='User'>komal\tparikh</Value></Eq></Where>";

SPListItemCollection items = oList.GetItems(query);

}

}

Feature 'GUID' for list template 'XXX' is not installed in this farm. The operation could not be completed

2009-11-01T06:53:00.001-08:00

Feature 'GUID' for list template 'XXX' is not installed in this farm. The operation could not be completed.
We had a client receiving this message when accessing a site, and clicking Site Actions/Manage Content and Structure.

Install the Application Template Core Solution into the farm.

Link to Application Template Core Solution from Microsoft:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C1039E13-94DA-4D7D-8CAE-3B96FA5A4045&displaylang=en

How to Install the Application Template Core solution (from Microsoft TechNet)
1. Download the Application Template Core solution to the server.
2. Double-click the .exe file to extract the files.
3. Open a Command Prompt window.
Note:

To open a Command Prompt window, click Start, point to All Programs, point to Accessories, and then click Command Prompt.
4. Type stsadm -o addsolution -filename \ApplicationTemplateCore.wsp, where is the location you extracted the Application Template Core files to, and then press ENTER.
5. Type stsadm -o deploysolution -name ApplicationTemplateCore.wsp -allowgacdeployment, and then press ENTER.
Note:

Additional attributes may be required based on your Windows SharePoint Services 3.0 configuration. For more information about available attributes, type stsadm -help deploysolution, and then press ENTER.
6. Type stsadm -o copyappbincontent, and then press ENTER.

Move Wss 3.0 site to Moss 2007 -> error : version problem

2009-10-31T04:36:00.000-07:00

Hi guys,

Today, i am trying to restore wss 3.0 site into moss 2007. My wss 3.0 site's version is 12.0.0.6421 and new moss server site's version is 12.0.4518. During restore time, i get error message regarding version.

Cause : Your backup is from a different version of Windows SharePoint Services and canno
t be restored to a server running the current version. The backup file should be
restored to a server with version '12.0.0.6421' or later.

Solution :
(1) Install wss 3.0 sp2
(2) Install Moss 2007 sp2
(3) Reset IIS

After installation, moss 2007 version is same displayed as wss 3.0.

(4) Restore you wss 3.0 site to moss 2007.
(5) Browser your web application.

SharePoint 2007 Versions

2009-10-31T04:35:00.000-07:00

The first approach is to open a web browser and got to the site settings page (Site Actions > Site Settings > Modify All Settings).

The second approach is against the databases. Open SQL Server Management Studio, Connect to the server, new query, run the following:

SELECT [VersionId]
,[Version]
,[Id]
,[UserName]
,[TimeStamp]
,[FinalizeTimeStamp]
,[Mode]
,[ModeStack]
,[Updates]
,[Notes]
FROM [SharePoint_Config].[dbo].[Versions]
WHERE VersionId = '00000000-0000-0000-0000-000000000000'
ORDER BY Id DESC

This returns (columns reduced for readability):

VersionId	Version	Id	UserName	Updates
00000000-0000-0000-0000-000000000000	12.0.0.6219	4	MOSS\user	3
00000000-0000-0000-0000-000000000000	12.0.0.4518	1	MOSS\user	2

The top row is the latest version. The query is performed on the SharePoint Configuration database. If you have called this database something instead of "SharePoint_Config" change the query to reflect this.

You can also look at the versions for Content Databases, by changing the database name. For example: FROM WSS_Content_MySites.[dbo].[Versions]

How to find the level of SharePoint you are running

2009-10-31T04:32:00.000-07:00

Using SharePoint Central Administration Web site SharePoint HTML Site Settings admin pages or IIS Manager, on the web sites properties HTTP Headers tab, virtual servers once extended will show the following version numbers:
MOSS 2007¹ or WSS 3.0 Cumulative update (KB956056 & KB956057) 12.0.0.6327
MOSS 2007¹ or WSS 3.0 Infrastructure Update (KB951695 & KB951297) 12.0.0.6318
MOSS 2007¹ or WSS 3.0 post-SP1 hotfix (KB948945) 12.0.0.6303
MOSS 2007¹ or WSS 3.0 post-SP1 hotfix (KB941274) 12.0.0.6301
MOSS 2007¹ or WSS 3.0 post-SP1 hotfix (KB941422) 12.0.0.6300
MOSS 2007¹ or WSS 3.0 SP1 12.0.0.6219
MOSS 2007¹ or WSS 3.0 October public update 12.0.0.6039
MOSS 2007¹ or WSS 3.0 August 24, 2007 hotfix package 12.0.0.6036
MOSS 2007¹ or WSS 3.0 RTM 12.0.0.4518
MOSS 2007¹ or WSS 3.0 Beta 2 TR: 12.0.0.4407
MOSS 2007¹ or WSS 3.0 Beta 2: 12.0.0.4017
Office 12 (PDC image - pre-beta): 12.0.0.3111 (This version of Office does not have a support link in the Add/Remove programs dialog box).

¹To confirm that a particular service pack is install on SharePoint Server you must either check the version numbers of specific dlls as specified in the related Microsoft Knowledge Based article or select the Show Updates check box in Add and Remove Programs.

WSS 2.0 SP3 6.0.2.8165
WSS 2.0 SP2 KB900929 + KB924881 6.0.2.8117
WSS 2.0 SP2 rollup KB900929 6.0.2.8000
WSS 2.0 SP2 6.0.2.6568
WSS 2.0 SP2 Beta = R2: 6.0.2.6551
WSS 2.0 SP1 + KB887981 6.0.2.6411
WSS 2.0 SP1: 6.0.2.6361
WSS 2.0 Unservice packed: 6.0.2.5530

To confirm that service packs are installed, especially with SharePoint Server 2007, goto Control Panel -> Add and Remove Programs
Select the product and then click: Click here for support. The versions will
be displayed as follows:

	Windows SharePoint Services 3.0	Microsoft Office SharePoint Server 2007
post-SP1 hotfix (KB948945)	12.0.6303.5000	12.0.6303.5000
SP1	12.0.6219.1000	12.0.6219.1000
RTM	12.0.4518.1016	12.0.4518.1016
Beta 2 TR	12.0.4407.1005	12.0.4407.1005
Beta 2	12.0.4017.1006	12.0.4017.1006

	Windows SharePoint Services 2	SharePoint Portal Server 2003
SP3	11.0.8173.0	11.0.8168.0
post SP2 rollup	11.0.8000.0	11.0.8126.2
SP2	11.0.7969.0	11.0.8126.0
R2 WSS SP2 beta	11.0.6551.0
SP1+KB887981	11.0.6411.0
With Service Pack 1	11.0.6361.0	11.0.6715.0
Unserviced pack	11.0.5608.0	11.0.5704.0

Server Error: http://go.microsoft.com/fwlink?LinkID=96177

2009-10-31T04:27:00.000-07:00

In order to protect MOSS 2007 using DPM 2007 SP1, a few updates/ hotfixes need to be applied on MOSS 2007 server. One of the hotfix is "Windows SharePoint Services 3.0 post-Service Pack 1 hotfix package: January 31, 2008 (KB941422)". You may get details on this Knowledge Base from here: http://support.microsoft.com/kb/941422

After installing the update on MOSS 2007 server, you might experience that the MOSS web site is no more accessible but with a blank page and "Server error: http://go.microsoft.com/fwlink?LinkID=96177" on it. After some troubleshooting and we solve the problem by running this command on the MOSS 2007 front-end web server:

stsadm –o upgrade –inplace [-url <http://mosswebsite URL>] forceupgrade

PSCONFIG.EXE -cmd upgrade -inplace b2b -wait -force

IISRESET

This normally will happen even when you upgrade from WSS 3.0 to MOSS 2007 or install MOSS service pack 1 or Moss Service pack 2.

How does SharePoint automatically logged a user in?

2009-10-30T04:01:00.000-07:00

Hi guys,

Here is the steps for automatic logged in sharepoint site when open it.

(1) Open IE browser.
(2) Go to Tools->Internet Options.
(3)Click on Security Tab.
(4)Click on Trusted Sites.
(5)Click on Custom Level. So security settings pop up is open.
(6)Go to User Authentication tab and select Automatic Logon with current user name and password.

How to enable Search on your MOSS 2007 Site

2009-10-28T07:17:00.000-07:00

Hi guys,

If you want to Enable Search facility on your sharepoint 2007 site,follow these steps:

Go to the Site Settings and under Site Administration Click on Search Visibility Link.

Update the seeting as shown on the attached image.

even after you enable the search visibility on your site and if you start search for a keyword on your site pages it will not work until the Crawling process will be run.

How can i Configure My Crawling process on MOSS 2007 ?

Open your central administration site: click on Share Services link under Share Services Administration.

Click on Search Settings -> Content Sources and Crawl Schedules -> Edit the Content Source which is exist.

Update your crawling services as you want and as per your organization needs.

Hope this helps....

Active search functionality in WSS using STSADM

2009-10-12T06:31:00.000-07:00

stsadm -o spsearch -action start -databaseserver SERVERDB -databasename WSS_Search_SERVERDB

Show Currency with different locate in Sharepoint Data View Web Part

2009-10-06T21:20:00.000-07:00

Suppose you’d like just a single DVWP to display numbers (either currency or regular numbers) in a different locale than the host site. This trick lets you do just that.

1. Open the page you need to customize with Sharepoint Designer. Switch to code view. Perform a search to find the tag xsl:decimal-format. Change the whole line with:

<xsl:decimal-format name="European" decimal-separator="," grouping-separator="." minus-sign="-" NaN="error" />

2. Now, locate your <xsl:value-of select=”@Total”/> and replace it as follows:
<xsl:value-of select="format-number(@Total, "€#.###,00;-€#.###,00", "European")"/>

WSS 3.0: When trying to search on sharepoint site, Getting message “No results matching your search were found.”

2009-10-06T04:06:00.000-07:00

1. Symptom –
=============

–>When you are trying to perform search on your SharePoint site on your sharepoint server, you are getting following error message:

No results matching your search were found.
Check your spelling. Are the words in your query spelled correctly?
Try using synonyms. Maybe what you’re looking for uses slightly different words.
Make your search more general. Try more general terms in place of specific ones.
Try your search in a different scope. Different scopes can have different results.

–>Windows SharePoint help search is working fine and it gave results when we searched for “SharePoint”

–>Unable to get results on the SharePoint site

2. Cause –
==========

–>Issue due to windows Updates

3. Resolution –
================

–>We created a registry entry in the following location

HKLM\System\CurrentControlSet\Control\Lsa

–>Created a new DWORD key named “DisableLoopbackCheck” and modified the value to 1

–>We performed Full Crawl by the command

stsadm -o spsearch -action fullcrawlstart

–>We performed Search and it worked successfully

Retrive SPList Item using LINQ in Sharepoint

2009-09-08T22:46:00.000-07:00

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;

namespace linqtest
{
public class SPLINQ : System.Web.UI.WebControls.WebParts.WebPart
{
protected override void Render(System.Web.UI.HtmlTextWriter writer)
{
base.Render(writer);
SPList taskList = SPContext.Current.Web.Lists["Tasks"];

// Get items, order by title alphabetically and assign to taskListItems
var taskListItems = from SPListItem tItem in taskList.Items
orderby tItem.Title
ascending select tItem;

foreach (SPListItem taskItem in taskListItems)
writer.WriteLine(taskItem.Title + "
\n");
}
}
}

Call ModalPopupExtender from Codebehind in .net

2009-08-24T21:55:00.001-07:00

<head runat="server">
<title>Untitled Page</title>
<script>
function PopupModal ()
{
var modal = $find('modalPopupExtender1');

if (modal)
{
if (modal.show)
{
modal.show();
}
else
{
alert("nope!");
}
}
else
{
throw modal;
}
}
function onOk()
{
}
</script>
</head>
<body>
<form id="form1" runat="server">

<asp:ScriptManager runat="server" ID="ScriptManager1" EnablePageMethods="true" LoadScriptsBeforeUI="true"> </asp:ScriptManager>
<asp:Button ID="button1" runat="server" Text="Server_Click" OnClick="button1_Click" />
<asp:Button ID="buttonNull" style="display:none;" runat="server" />
<asp:UpdatePanel ID="updPanel1" runat='server'></asp:UpdatePanel>

<asp:Panel runat="server" ID="Panel1" Width="500" Height="500" style="display:none;"
BackColor="#fafad2" BorderColor="black" BorderStyle="solid" BorderWidth="1px">

<asp:panel runat="server" ID="Panel3" Width="100%" Height="27" BackColor="red">
DragHandle
</asp:panel>

<asp:Button ID="OKButton" runat="server"/>
<asp:button ID="CancelButton" runat="server" />
</asp:Panel>

<cc1:ModalPopupExtender ID="ModalPopupExtender" runat="server"
BehaviorID="modalPopupExtender1"
TargetControlID="buttonNull"
PopupControlID="Panel1"
BackgroundCssClass="modalBackground"
OkControlID="OkButton"
OnOkScript="onOk()"
CancelControlID="CancelButton"
DropShadow="true"
PopupDragHandleControlID="Panel3" />

Here is the code behind:

protected void button1_Click(object sender, EventArgs e)
{
//Do stuff

ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowPopup", "window.setTimeout('PopupModal()',50);", true);
}

SharePoint 2010 Key Features

2009-08-20T00:20:00.001-07:00

http://www.codeproject.com/KB/sharepoint/SharePoint_2010.aspx

Sharepoint 2010 has following new features

Better support for Internet facing sites
More security features & flexibility in managing permissions
Email management for users
Faster search
More storage options such as SAN, NAS, RAID etc. (currently only SQL)
Improved taxonomy management
Better Dashboards and reports
Records and archiving policies
Easy to use templates
More commands
Microsoft Groove is renamed as ‘SharePoint Workspace Manager’
Integration with other CMS products
Improved infopath form capabilities
More workflow types
Native support for Mozilla Firefox 3.0 and Opera
Better support for Mobile devices
Easy migration from SPS2003 and MOSS 2007
Snapshot
Backup and Restore
Granular recovery at item level

Setup and Install SharePoint 2007 Server (MOSS) on Virtual PC

2009-08-20T00:18:00.000-07:00

http://www.codeproject.com/KB/sharepoint/Install_SharePoint_on_VPC.aspx

Hiding the Search Box When Printing

2009-07-20T09:13:00.000-07:00

* Open the master page in SharePoint Designer
* Add the following style either to a CSS file included in the master page or as a style within the master page itself:

@media print{
.HideForPrinting
{
display:none;
}
}

* Locate the delegate control used to display the search box and add the code shown in italics:

<asp:ContentPlaceHolder id=”PlaceHolderSearchArea” runat=”server”>
<span class=”HideForPrinting”>
<SharePoint:DelegateControl runat=”server” ControlId=”SmallSearchInputBox”/>
</span>
</asp:ContentPlaceHolder>

This defines a span that uses the style HideForPriting, the content of which will be hidden when the page is printed.

Change size of Rich Text Editing Control

2009-07-20T09:02:00.000-07:00

When using the rich text column type in SharePoint lists the edit control has a fixed width of 384 pixels. This is often too small for easy editing.

If you need to change the width for a single form, open the form in SharePoint Designer and add a style defining ms-rtelong at the top of the content place holder in which the form is displayed with new dimensions, e.g.

<asp:Content ContentPlaceHolderId=”PlaceHolderMain” runat=”server”>

<style type=”text/css”>
.ms-rtelong {
width:700px;
height:600px;
}
</style>

How to access inetpub root folder using programatically in sharepoint

2009-07-14T03:55:00.000-07:00

Here i have mentioned how to access inetpub root folder using object model.

using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;

string filename = web.Site.WebApplication.IisSettings[SPUrlZone.Default].Path.FullName.ToString() + @"\_app_bin\layouts.sitemap";

it will give filename like "C:\Inetpub\wwwroot\wss\VirtualDirectories\5858\_app_bin\layouts.sitemap"

Call Javascript on Page Load in Sharepoint Application Page

2009-07-07T02:25:00.000-07:00

http://blogs.msdn.com/sharepoint/archive/2007/06/21/using-javascript-to-manipulate-a-list-form-field.aspx

Customize Edit Page and Redirect page after update using java script

2009-07-07T02:11:00.000-07:00

1. In Sharepoint Designer take your EditForm.aspx and copy it.
2. Rename it
3. Open this new form and click on the PlaceHolderMain (leave your ListFormWebPart on the page)
4. In the ListFormWebPart scroll down the properties in the xml which describes the webpart and change to false. For some reason the form will not work unless you leave the original on the page.
4. Click on Insert->Sharepoint Controls->Custom List Form
5. Choose the appropriate List and select Edit Form
6. Sharepoint generates the form for you.

To customize the save button, find the following control on the page Sharepoint:SaveButton

1. Delete the SaveButton
2. Add

input type="button" value="Save" name="btnSave" onclick="javascript: {ddwrt:GenFireServerEvent('__commit;__redirect={Thanks.aspx}')}"

instead
3. This button allows the form to be saved and redirects to back to that page.

Delete Title Column in custom list sharepoint

2009-07-03T06:30:00.000-07:00

Title column in custom list could be confusing in sharepoint. When you create any new custom list, Tital column is default column in list. You can't delete it but rename column name.

There is no way to Hide or Delete “Title” Column from List Settings User Interface. You can hide it by deselecting this column in your View but then you cannot edit the item as you wouldn’t have any Column linked to edit menu.

he only way to hide the “Title” Column is by writing a Custom List Definition, remember every Custom List MUST have this column as this is included in the Global ONET.xml (for Type “0″ List).

<Field ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Name="Title" ReadOnly="TRUE" Required="FALSE" Hidden="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="Title">
</Field>
<Field ID="{82642ec8-ef9b-478f-acf9-31f7d45fbc31}" Name="LinkTitle" Hidden="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitle">
</Field>
<Field ID="{bc91a437-52e7-49e1-8c4e-4698904b2b6d}" Name="LinkTitleNoMenu" Hidden="TRUE" SourceID="http://schemas.microsoft.com/sharepoint/v3" StaticName="LinkTitleNoMenu">
</Field>

World Clock Webpart

2009-06-29T05:33:00.001-07:00

Today, I have released world clock webpart on codeplex.
You can download it from below link.
http://worldclock.codeplex.com/

After download, read document and installed it on MOSS Server.

It looks like below.

Free - SharePoint Text Size Zoom Feature

2009-06-26T01:46:00.001-07:00

Sharepoint Text Size zoom functionality is useful in organization for low resolution projector.

Here i have mentions step to integrate with sharepoint site.
(1) Open Sharepoint Site in sharepoint Designer .
(2) Open _catalogs folder and create new folder "JS"
(3) Add new javascript into that rename as TextSize.js
(4)Open Javascript and add below code into js and save it.

function FontSizeChange_SetAllDocumentFontSize(size)
{
FontSizeChange_ChangeAllElements(document, size);

for(var i = 0; i < document.frames.length; i++)
{
FontSizeChange_ChangeAllElements(document.frames[i].document, size)
}
}

function FontSizeChange_RestoreDefault()
{

FontSizeChange_ReloadWindow(true);
}

function FontSizeChange_ReloadWindow(refresh)
{
if(refresh)
{
var url = window.location.href;
if(url.indexOf("#") == url.length - 1)
{
window.location.href = url.substring(0, url.length - 1)
}
else
{
window.location.href = url;
}
}
else
{
window.location.reload();
}
}
function FontSizeChange_ChangeAllElements(doc, size)
{
FontSizeChange_SetFontSizeByTagName(doc, "div", size);
FontSizeChange_SetFontSizeByTagName(doc, "span", size);
FontSizeChange_SetFontSizeByTagName(doc, "input", size);
FontSizeChange_SetFontSizeByTagName(doc, "a", size);
FontSizeChange_SetFontSizeByTagName(doc, "td", size);
FontSizeChange_SetFontSizeByTagName(doc, "th", size);
FontSizeChange_SetFontSizeByTagName(doc, "select", size);
FontSizeChange_SetFontSizeByTagName(doc, "font", size);
FontSizeChange_SetFontSizeByTagName(doc, "textarea", size);
FontSizeChange_SetFontSizeByTagName(doc, "IE:MENUITEM", size);
}

function FontSizeChange_Increase()
{
var font=document.getElementById('txtFont').value;
if(font <20)
{
document.getElementById('txtFont').value=parseInt(document.getElementById('txtFont').value) + 1;
}

var fontSize = font.toString() + "px";
FontSizeChange_SetFontSize(fontSize);

}

function FontSizeChange_SetFontSize(size)
{
FontSizeChange_SetAllDocumentFontSize(size);

}

function FontSizeChange_Decrease()
{
var font=document.getElementById('txtFont').value;
if(font > 8)
{
document.getElementById('txtFont').value=parseInt(document.getElementById('txtFont').value) - 1;
}

var fontSize = font.toString() + "px";
FontSizeChange_SetFontSize(fontSize);

}

function FontSizeChange_SetFontSizeByTagName(doc, tag, size)
{
var elements = doc.getElementsByTagName(tag);
for(var i = 0; i < elements.length; i ++)
{
elements[i].style.fontSize = size;
}
}

(5) Open Master page and add below script.

<script language="javascript" src="../JS/TextSize.js" type="text/javascript"></script>

(6) Also add below code into master page top corner.

<a title="Decrease Text Size" href="javascript:FontSizeChange_Decrease();"><asp:image runat="server" ID="imgdecrease" ImageUrl="_layouts/IMAGES/_size_small.gif" ></asp:image></a>

<a title="Default Text Size" href="javascript:FontSizeChange_RestoreDefault()"><asp:Image ID="imgdefault" runat="server" ImageUrl="_layouts/IMAGES/_size_medium.gif"></asp:Image></a>

<a title="Increase Text Size" href="javascript:FontSizeChange_Increase();"><asp:Image ID="imgincrease" runat="server" ImageUrl="_layouts/IMAGES/font_size_large.gif" ></asp:Image></a>

<input id="txtfont" type="hidden" value="12" >

Add image as per your requirement.

After complete this procedure, feature is look like below.

Cheers it and enjoy it.

Hide Sharepoint Site Action for non authentic user group

2009-06-17T02:52:00.000-07:00

Sharepoint Site Action hiding is easy for non authenticate user. It is possible using sharepoint designer and after that only administrator's view Site Action button in sharepoint web application.

Open Sharepoint Designer and find SiteAction control in master page. Add SPSecurityTrimmedControl before that.

<SharePoint:SPSecurityTrimmedControl runat="server" PermissionsString="ManageWeb" >

<SharePoint:SiteActions runat="server" AccessKey="<%$Resources:wss,tb_SiteActions_AK%>" id="SiteActionsMenuMain" ..........>
............
</SharePoint:SiteActions>

</SharePoint:SPSecurityTrimmedControl>

SharePoint DateTime Control Validation

2009-06-16T21:08:00.000-07:00

<wssawc:DateTimeControl ID="dteDemo" runat="server" DateOnly="true" ></wssawc:DateTimeControl>

<asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ErrorMessage="Please select activity date." ControlToValidate="dteDemo$dteDemoDate" ValidationGroup="Activity" Display="None"></asp:RequiredFieldValidator>

<asp:CompareValidator id="vdate" Display="None" runat="server" ControlToValidate="dteDemo$dteDemoDate" Type="date" Operator="dataTypeCheck" ErrorMessage="Please enter an valid date." vallidationGroup="Activity"></asp:CompareValidator>

Automatic take sharepoint site backup using batch file and scheduler

2009-06-16T06:03:00.000-07:00

It is not possible to schedule sharepoint backup from sharepoint central admin site.
Below is process to take backup using batch file and after running schedule on specific time.

1. Open notepad and paste below code.

@echo off

@SET STSADM="c:\program files\common files\microsoft shared\web server extensions\12\bin\stsadm"

cd c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN

@echo off

md "%DATE:/=_%"

stsadm -o backup -url "http://localhost:8080" -filename "E:\MOSS_Backup\%DATE:/=_%.bak"

echo completed

2. Save it as AutoBackup.bat (Change your site name )

Set Task schedular for this batch file and take backup on schedule time.

Send Document as Attachement Feature

2009-05-26T02:14:00.000-07:00

Send document as attachment feature is useful in ECB menu to send email with current document as attachment.

You can download full code from codeplex.
http://trushar82.codeplex.com

Feature is look like below snap.

Custom Action link in listedit page in sharepoint

2009-05-18T04:06:00.000-07:00

Feature.xml

<Feature Id="90CCFF3E-0874-441b-B430-1920BAF59B08"
Title="My Permission Link"

Version="1.0.0.0"
Scope="Web"
Hidden="false"
DefaultResourceFile="core"
xmlns="http://schemas.microsoft.com/sharepoint/">
<ElementManifests >
<ElementManifest Location="element.xml" />
</ElementManifests>
</Feature>

element.xml

<?xml version="1.0" encoding="utf-8" ?>
<Elements xmlns="http://schemas.microsoft.com/sharepoint/">

<CustomAction Id="39C18565-C185-4353-8025-E15859E3C4F3"
GroupId="Permissions"
Location="Microsoft.SharePoint.ListEdit"
Sequence="100"
Title="My Permission Link"
>

<UrlAction Url="_layouts/custom/MyRecycleBinItems.aspx" />

</CustomAction>
</Elements>

If you want add link in general settings then add GroupId as GeneralSettings.

Sharepoint Control - Object Model

2009-05-14T22:04:00.001-07:00

Below is link which one use sharepoint object model as well as web part.

Sharepoint WebControl

Set current date in sharepoint DateTimeControl using Object Model

2009-05-11T07:02:00.000-07:00

Below is a code to set current date in sharepoint dateTimeControl using object model.

dtdemodate.selectedDate=Now.Today.date.Tostring();

Export To Excel in Sharepoint

2009-05-11T06:53:00.000-07:00

Today I have facing problem in my user control web part when i exported grid view data into excel.

Error is like "control not load at form server tag".

I have created new ASPX page and generate grid and write code for export to excel.
After put this control into sharepoint 12 hive folder like "_Layout".

I have added Page View web part in page and added property link like "http://localhost/_layout/exportToExcel.aspx".

So its working fine.
Put following code in ASPX page.

public override void VerifyRenderingInServerForm(Control control)

{

}

Upload File/Document in DocLibrary/List using Sharepoint Object Model

2009-05-05T00:35:00.000-07:00

using (SPSite site = new SPSite("http://localhost"))
{

using (SPWeb web = site.OpenWeb())
{

SPList list = web.Lists["MyList"];
web.AllowUnsafeUpdates = true;
SPListItem item = null;
item = list.Items.Add();

item["Title"] = "Test by Tushar";
string fileName = "";
if (File1.PostedFile != null)
{
Stream fStream = File1.PostedFile.InputStream;

byte[] contents = new byte[fStream.Length];
fStream.Read(contents, 0, (int)fStream.Length);
fStream.Close();
fStream.Dispose();

SPAttachmentCollection attachments = item.Attachments;
fileName = Path.GetFileName(File1.PostedFile.FileName);
attachments.Add(fileName, contents);

}

item["FileName"] = fileName;
item.Update();

}