Techno Freak

After Installation of Moss SP2 Site Collection Display Message "Access Denied"

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 02 Nov 2009 11:52:00 +0000

After Installation of Moss SP2 Site Collection Display Message "Access Denied"

If you are installed Moss 2007 SP2 on your server then It may possible some site collection Admin part display message "Access Denied"

Even if you are try to Access site collection with Site Administator Priviledge then also it display message Access Denied.I don't know what is reason behind this but this problem occured after installation of Moss SP2 .

This problem is occured because It locked your site collection automatically ... So Nobody can access site collection Admin Part.

Solution of this problem is you have to modify setting of Site Collection locks through Central Admin.

Steps How to Unlock Site Collection :

Step 1 : Go to Central Admin

Step 2 : Click On Application Management

Step 3 : Click Site Collection quotes and locks

Step 4 : Select Site Collection and Check Not Locked Radio Button.

Step 5 : Smile

The great pleasure in life is doing what people say you cannot do

From Pritesh Public Profile

Sharepoint People Picker Control

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Fri, 30 Oct 2009 16:01:00 +0000

This post I am using share point People Picker control in aspx page and try to retrieve value of user and domain ID of user.

Below Screen of People picker control :

Download People Picker Code From Here

Everyone thinks of changing the world

but no one thinks of changing himself.

-Leo Tolstoy

From Pritesh Public Profile

Sharepoint Date Time Control in ASP.Net Application Page

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Fri, 30 Oct 2009 15:47:00 +0000

Here in this article I am using sharepoint Date Time Control in Asp.Net Application Page.

you can select date and time from sharepoint control and then seprate value of date and time .

Below is screenshot of How Sharepoint People Picker Control work in ASPX Page.

Download Source Code From Here

Every time you get angry, you poison your own system.

From Pritesh Public Profile

Multi-Value Cascading Parameters Don't Update Correctly in Sharepoint Integrated Reporting Services

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Fri, 30 Oct 2009 15:06:00 +0000

Problem :
Multi-Value Cascading Parameters Don't Update Correctly in Sharepoint Integrated Reporting Services

Description :
We have Reporting Services running in Sharepoint Integrated mode. We have a report which uses cascading parameters, as follows:

Parameter 1: a multi-value drop down
Parameter 2: a multi-value drop down which is dependent on the choices in Parameter 1.

When you chose a value for Parameter 1, the page reloads, but the drop down list for Parameter 2 does not update.

A crude workaround is to get the user to click "Apply" which causes the report to be generated based on the (possibly invalid) values selected for Parameter 2. This then causes Parameter 2 to be updated based on the choices of Parameter 1.

With serveral cascading parameters this results in a fairly nasty user experience, but it does at least work.

Solution :
This Problem is resolved in update 3 of SQL Server 2005 SP2 [Check this: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=281612].

As of my knowledge we are on 9.00.3042 build. This is SQL Server 2005 SP2.
This cumulative update would take us to 9.00.3186 [http://support.microsoft.com/kb/939537].

I suggest you to install the latest service pack of RS2005. This is SP3: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en [Microsoft SQL Server 2005 Service Pack 3]

"What you feed your mind with will rule your life."

From Pritesh Public Profile

Maximum number of Application Pools in IIS 6.0

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 28 Oct 2009 06:45:00 +0000

Good Article Links of IIS 6.0 Application Pool

http://blogs.msdn.com/webtopics/archive/2009/01/22/maximum-number-of-application-pools-in-iis-6-0.aspx
http://www.windowsnetworking.com/articles_tutorials/Working-Application-Pools-Internet-Information-Server.html#
http://www.developer.com/article.php/10915_2245511_2/IIS-and-ASPNET-The-Application-Pool.htm

Cheers

Pritesh Gandhi

Change Default Ok Button to Cusomized Button in Moss 2007

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Thu, 15 Oct 2009 10:05:00 +0000

Here in this post you can modified default share point OK button to Customized OK Button using Sharepoint Designer.

Orginal Sharepoint Ok Control :

<SharePoint:SaveButton runat="server" ControlMode="New" id="savebutton2" OnUnload="openWindow()"/>

Modified Sharepoint OK Control with JavaScript :

<input id="savebutton2" onclick="javascript: {ddwrt:GenFireServerEvent('__commit;__redirect={DisplayMessage.htm}')}" runat="server" type="button" value="Save" />

10000 Hits of My Blog

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Tue, 13 Oct 2009 06:53:00 +0000

Celebrating 10K Hits of My Blog

Wish You Many Many

Happy Diwali

Happy New Year

Cheers

Pritesh Gandhi.

Understanding and Creating Customized and Uncustomized Files in Windows SharePoint Services 3.0

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 12 Oct 2009 08:31:00 +0000

This article is useful for

Uncustomized Vs Customized
Ghosted Vs UnGhosted
SitePages Vs Application Pages
Advantages and DisAdvanctages of Creating Customized Pages
Advantages and DisAdvanctages of Creating UnCustomized Pages

Architecture of Customized and Uncustomized

How to implement Features

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

Cheers

Pritesh Gandhi

Every time you get angry, you poison your own system.

Alternate Access Mappings Article

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 30 Sep 2009 12:08:00 +0000

Good Article about AAM (Alternate Access Mappings )

Here is link of Troy Starr Article :

What every SharePoint administrator needs to know about Alternate Access Mappings (Part 1 of 3)

What every SharePoint administrator needs to know about Alternate Access Mappings (Part 2 of 3)

3 Part Missing ....

If any body found link of 3 Article then please send me link

In a day, when you don't come across any problems,

you can be sure that you are travelling

in a wrong path - Swami Vivekananda

From Pritesh Public Profile

Sharepoint Calculated Columns with Date

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 23 Sep 2009 07:34:00 +0000

Date Time Format of Calculated Columns in Sharepoint

Here Some Example How to Convert DateTime Format into Various Date And Time Format :

Some Good Tricks of Play with Sharepoint Date Time Field :

For Example

// Convert Value in dddd-mm-yyyy format

=TEXT([TODAY],"dddd-mm-yyyy")

//Retrive only Month in Text Value

=CHOOSE(MONTH([Created]),"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec")

// Year Only Display without Comma

=TEXT(YEAR([Start Date]),"000")

//Only Month , Year , Date

=Month([START DATE])

//Find Out Quarter of Date

=ROUNDDOWN(((INT(MONTH([Start Date]))-1)/3),0)+1

Original Article : El Blanco's Office 2007 Blog

It`s not important to hold all the good cards in life.
But it`s important how well you play with the cards which you hold.

From Pritesh Public Profile

Accessing Server Controls Using JavaScript + PASS ID Value in JavaScript

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 21 Sep 2009 08:20:00 +0000

How to Access Server Side ASP.Net Controls in JavaScript

For Example if you want to Access Server Control TextBox in JavaScript ...

Just write below Code :

ASP.Net Server Control

<asp:textbox id="MyTest" runat="server" text="Sample"/>

JavaScript Code :

document.getElementById('<%=MyTest.ClientID%>').value;

Second Alternative Way is :

document.forms[0]['MyTestTest'].value;

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

PASS ID Value in JavaScript

<input onclick="getIDValue(this)" ID="txttemp" type="textBox" />
 



Function Of JavaScript
 
function getIDValue(idValue)
{
  // Retrieve Value OF ID 
  alert(idValue.id)
}



Pain is temporary. It may last a minute, or an hour, 
or a day, or a year,but eventually it will subside and 
something else will take its place.If I quit, 
however, it lasts forever.
From Pritesh Public Profile

Sharepoint Webcontrols

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Sat, 19 Sep 2009 12:57:00 +0000

How to use sharepoint webcontrols in asp.net Application

In this article you can use sharepoint web control in asp.net application.

Here is the orginal post How to use share point web control in asp.net application : http://www.hezser.de/blog/archive/2007/04/29/how-to-use-the-sharepoint-web-controls.aspx

Download PDF file From Here :

Sharepoint Web Controls

IF u win u need not to have explain, if u loose, u should not b there to explain

- Hitler.

From Pritesh Public Profile

Uncustomized vs Customized Pages in SharePoint

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Sat, 19 Sep 2009 12:27:00 +0000

In this Article display clear diffrence between sharepoint defaul page and customized page .

Nice Article

Here is the orginal post of Susan Henry : http://www.endusersharepoint.com/2009/09/11/uncustomized-vs-customized-pages-in-sharepoint/

Cheers

Pritesh Gandhi

First Courier From Google .....

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Sat, 19 Sep 2009 11:34:00 +0000

Cheers .....

Believing everybody is dangerous
but believing nobody is more dangerous.

- Abrahman Lincoln

From Pritesh Public Profile

Web Part Management Page

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Thu, 17 Sep 2009 05:38:00 +0000

It’s well known, but mostly to remind myself – if you’ve got a web part that causes problem on a page (like the yellow screen of death) and you want to remove it, add the following to your :
url?contents=1
Takes you to the Web Part Maintenance Page. I can never remember the bit you add to the URL
Refer URL : http://www.novolocus.com/2009/08/28/web-part-management-page/

If you judge People you have no time to love them.
- Mother Teresa.

From Pritesh Public Profile

Distinct Value In DataTable

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 16 Sep 2009 09:18:00 +0000

Hi All,

Query : I have some records in my Datatable. I want to remove all the duplicate records from my datatable.

Solution :

DataView dvRoomNo = new DataView(dtRoomNo.DefaultView.ToTable(true, "ColumnName"));

" If Calculus and algebra were required to be great investor, I'd have to go back to delivering newspapers " - Warren Buffet

From Pritesh Public Profile

ENJOY THE KILLER SHAYRI'S

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Thu, 10 Sep 2009 05:05:00 +0000

Saap Ne Piya Bakri Ka Khoon...
.
.
Waah! Waah!
.
.
Saap Ne Piya Bakri Ka Khoon...
Good Afternoon! Good Afternoon! Good Afternoon!!

Tere Pyaar Mein Paagal Ho Gaya Peter...
.
.
Waah! Waah!
.
.
Tere Pyaar Mein Paagal Ho Gaya Peter...
Ab Hero Honda Splendor, 80 km Prati Litre...!!

__________________________________________________________________

Bahaar Aane Se Pehle Fizaa Aa Gayii ...
.
.
Waah! Waah!
.
.

Bahaar Aane Se Pehle Fizaa Aa Gayii ...
Phool Ko Khilne Se Pehle Bakri Kha Gayii .. !!

__________________________________________________________________

Aatma Chhod Gayii Shareer Puraana ...
.
.
Waah! Waah!
.
.
Aatma Chhod Gayii Shareer Puraana ...
Didi Tera Devar Deewana .. !

2 Cockroach Gaana Gaa Rahe Thhe : "Aashiq Banaaya
Aapne" ..

.
.
Dono Marr Gaye ...

.
.
.
Because Gaana "HIT" Tha ..
__________________________________________________________________

Yashomati Maiyya Se Bole Nandlala ...
.
.
Waah! Waah!
.
.
Yashomati Maiyya Se Bole Nandlala ...
"Maa, Tata Sky Laga Daala To Life Jhingalala ..!!"

__________________________________________________________________

Hoton Pe "Haan" Hai ...
Dil Mein "Naa" Hain ....
.
.
Waah! Waah!
.
.
Hoton Pe "Haan" Hai ...
Dil Mein "Naa" Hain ...
Shashi Kapoor Kehta Hai: "Mere Paas Maa Hai ..."

__________________________________________________________________

Aapki Surat Mere Dil Mein Aise Bass Gayii Hai ...
.
.
Waah! Waah!
.
.
Aapki Surat Mere Dil Mein Aise Bass Gayii Hai ...
Jaise Chhote Se Darwaaze Mein Bhens Phass Gayii Hai .. !!

woh aaye hamari mehfil me gana gane ke liye...
woh aaye hamari mehfil me gana gane ke liye...
aaaaa
aaa
aaaa

===========================================

Go not to the temple ...

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Sat, 22 Aug 2009 21:03:00 +0000

Go not to the temple ...

Go not to the temple to put flowers upon the feet of God,
First fill your own house with the fragrance of Love.

Go not to the temple to light candles before the altar of God,
First remove the darkness of sin from your heart.

Go not to the temple to bow down your head in prayer,
First learn to bow in humility before your fellowmen.

Go not to the temple to pray on bended knees,
First bend down to lift someone who is down trodden.

Go not to the temple to ask for forgiveness for your sins,
First forgive from your heart those who have sinned against you.

-- Rabindranath Tagore

Transfer Sharepoint Designer Workflow to One Server To Another Server

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 17 Aug 2009 10:33:00 +0000

Happy Janmashtmi & Happy Independence Day

Applying a Share Point Designer Workflow to multiple Lists

Transfer Share point Designer Workflow to One Server To Another Server

Above Both Solutions is Here :

This Post is useful when you have to transfer Share Point Designer workflow from Test Environment to Production Environment.

Here is the original post Nick Grattan’s SharePoint Blog :
http://nickgrattan.wordpress.com/2007/10/17/applying-a-sharepoint-designer-workflow-to-multiple-lists/

I have added few more steps because if you are transfer Sharepoint Designer workflow to Test To Production Server then You need to update List Id in .xoml file which is main file of SharePoint Designer Workflow .Below Screen shot of .xoml file.

The problem is that you cannot from this interface bind the workflow to other lists.

You might be tempted to use the “Save List as Template” option in the List’s settings, and then create a new list based on this template to create a list that uses the workflow. The problem is that the workflow is still bound to the list from which the new list is based, and an error will probably be generated whenever you try to start an instance of the workflow – the steps will try to reference items etc. in the original list.

In SharePoint Designer you can expand out the files associated with a workflow:

The “.xoml.wfconfig.xml” file contains information on the list the workflow is bound to using the List’s ID (a GUID):

The file “.xoml.rules” contains the ‘conditions’ you program for the workflow and the “.xoml” file contains the ‘actions’. The “.aspx” form is displayed when the workflow is started manually.

To re-use a workflow in another list:

1. Create a new workflow on the new list.
2. Create at least one step, one condition and one action in this workflow. This ensures that the files shown above are created and they will be replaced by the next operations.
3. From the original workflow open the .xoml file as XML and copy the entire contents to the clipboard.
4. Open the .xoml file for the new workflow and replace the entire contents with the copy from (3).
5. Repeat this operation for the xoml.rules file.
6. Find old List Id and Replace with New List Id in .xoml file.Below screenshot

7. Double click the .xoml file for the new workflow to open the workflow in the Workflow Designer and click Check Workflow to verify no errors and then click Finish to ensure the workflow is saved.
8. Ready To Rock With new workflow .... Smile ...

References :

http://nickgrattan.wordpress.com/2007/10/17/applying-a-sharepoint-designer-workflow-to-multiple-lists/

http://www.realworldsql.com/post/2008/03/Sharepoint-Designer---Copy-Workflow-from-one-list-to-another.aspx

	“No nation is perfect, it needs to be made perfect” . . . Happy Independence day.
From Pritesh Public Profile

Mumbai Meri Jaan !!!!

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 17 Aug 2009 05:01:00 +0000

Mumbai Meri Jaan !!!!

Click Here To Enlarge Image

Create a custom Approval workflow using SharePoint Designer

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Fri, 31 Jul 2009 11:13:00 +0000

Create a custom Approval workflow using SharePoint Designer

!!! Happy Friendship Day !!!!

This workflow is useful for 3 levels of approval required to filing form. Only form is visible when 3 levels approval completed.If any one Reject the form then Mail Sent to Created by user that your list entry is rejected for some reason.

Below some basic steps to creating approval workflow.

Step 1: It starts when a new item is created, modified or user can start workflow manually also.

Step 2: Created Workflow variable. Below Workflow variable description.

• TQM 25 Approval ID: This variable holds the ID of the task used to collect data from the approver.
• Approval: This variable holds the value of the “Approval” field in the task used to approve or reject the request.
• Comments: This variable holds the value of the “Comments” field in the task used to approve or reject the request.
• Collect: Task List Item ID Created for Task List.

Step 3: For First level Approval Task user is fill form on submission mail will go to person mentioned in field “Your Excellence Enabler”. Task is assigned to person whose name is mentioned in Your Excellence Enabler field. No condition is checked for Assigning task.

Actions Steps:

• Create a new approval task to be completed by the approver. This is implemented as “Collect Data from a User”. Task Id store in local workflow variable.

• Set workflow variable value whether user approved or Reject item. [ Refer Step 4 ]

• Same way store user comments on local workflow variable. [ Refer Step 5 ]

Step 4: Set Workflow Variable value as Approved or Reject.

Step 5: Set workflow variable comments value.

Step 6: So the action that we are going to use is the 'Collect Data From User' action.
1. The data that needs to be collected
2. The user that needs to provide the data, the human resource manager
3. A variable to collect, task ID.
Step 6.1 Click on Collect data new wizard will open

Step 6.2: we need to collect data from user so here we can add Approve / Reject Checkbox and comments multiline textbox.

Step 6.3 Final output of collect data.

Step 7: Once first level task is assigned to “your Excellence Enabler”. Mail Sent to Excellence Enabler to approve and Reject task.

Step 8: if Excellence Enabler Approve Task then Approval Mail sent to Created By and if Reject task then Rejection Mail Sent to Created By.
o On Approved of Excellence Enabler next task is assigned to Champion Approval.

o On Reject workflow is stopped.

Step 9: Same as Step 7

Step 10: Once All Approval completed Entry is display on list.

Once Again Happy Friendship Day Week Month Year Life time
Pritesh Gandhi

	# I like walking in the rain , becoz nobody can see my tears. # The Most Wasted day in life ,is the day ,in which we have not laughed. # Nothing is permenent in this world, not even your troubles... ! -- Charlie Chaplin
From Pritesh Public Profile

Reference URL :

http://www.u2u.info/Blogs/Kevin/Lists/Posts/Post.aspx?ID=39

http://cycogeek.fiesta25.com/blogs/cycogeek/page/Create-Custom-Approval-Workflow-with-SharePoint-Designer.aspx

How to know which User Submitted Survey and Which user does not?

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Mon, 20 Jul 2009 13:01:00 +0000

How to know which User Submitted Survey and Which user does not?

Smile ,

This article is useful to know which user submitted complete survey and which user doesnot complete survey.

Just simply put condition on u list query "tp_level = 255" for getting all non-submitted (incomplete) responses. The below query just gives you the result for “ALL NON SUBMITTED (INCOMPLETE) responses”; for getting all submitted responses query will change to “tp_level = 1”.

Query Example

Non Submitted Response
=============================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 255

FOR Submitted Complete Survey
===================================
Select userdata.tp_author,
(Select tp_Title from UserInfo where UserInfo.tp_ID=userdata.tp_author and tp_siteID='SiteID') As UserName
from USERDATA
where tp_ListId like 'LISTID'
and tp_level = 1

	If you cannot love a person whom you see, Then How can you love GOD whom you have never seen -- Mother Teresa
From Pritesh Public Profile

Implement Bar Chart in Custom Sharepoint List Using Google Charting API

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 15 Jul 2009 13:40:00 +0000

Implement Bar Chart in Custom Sharepoint List Using Google Charting API

Here is the orginal post thatClaudio Cabaleyro did:
http://www.endusersharepoint.com/?p=1539

Screenshot of Bar Chart in Custom Sharepoint List ,

-: Download Zip File From Here :-

Just One Day Remaining to My BirthDay

Cheers
Pritesh Gandhi

	I love everything that's old: old friends, old times, old manners,old books, old wines
From Pritesh Public Profile

Cascading Drop Down List (With Filter) - Custom Field Control

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Thu, 09 Jul 2009 07:20:00 +0000

Cascading Drop Down List (With Filter) - Custom Field Control

: Download Code From Codeplex Here :

: Site For Reference :

The excellent SharePoint - Cascading Drop Down Lists provided by DataCogs is a great way to create relationships between fields/columns in SharePoint lists.

DataCogs Solution Page:
http://datacogs.com/datablogs/archive/2007/08/26/641.aspx

This was further enhanced by Patrick Tisseghem to allow a grandchild dropdown. Visit Patrick's Page at:
http://blog.12thwave.com/?p=7

Expanding on Patrick's modified version to allow a grandchild dropdown list, I've added the functionality to filter the items in the dropdown.

Also, the "Required Field" validation was not validated accurately and this has been taken care of in my modified source.

========================================================

Title : Re-Using SharePoint controls
Site URL : http://community.zevenseas.com/Blogs/Robin/archive/2009/07/03/re-using-sharepoint-controls.aspx
Desc : This post is going to be a summary of some of some the SharePoint controls I regularly use in my solutions. Cool thing about re-using the controls that are already out there is, that saves time in re-inventing the wheel and you don’t have to worry about keeping the look&feel consistent ;)

Cheers
Pritesh Gandhi
NIGHT IS LONGER FOR THOSE WHO DREAM...........
AND DAY IS LONGER FOR THOSE WHO MAKE THEIR DREAMS COME TRUE!!!!!!!!!

How to Get DataBase Name,Database Owner and Database size in a single Query ...

pritesh.b.gandhi@gmail.com (Pritesh Gandhi) — Wed, 08 Jul 2009 11:09:00 +0000

How to Get DataBase Name,Database Owner and Database size in a single Query ...

Nice Solution is Here

SELECT
A.NAME,
STR(CAST(SUM(SIZE) AS NUMERIC)*8192/1048576) AS 'DATA FILE(S) SIZE IN MB',
FLOOR(B.BACKUP_SIZE/1048576) AS 'BACKUP SIZE IN MB',
convert(sysname,DatabasePropertyEx(a.name,'Recovery')) as 'Recovery Mode'
,suser_sname(a.sid) as 'dbowner'
FROM (SELECT
MAX(BACKUP_START_DATE) AS BACKUP_START_DATE,
DATABASE_NAME
FROM MSDB..BACKUPSET
WHERE TYPE = 'D'
GROUP BY DATABASE_NAME) X
INNER JOIN MSDB..BACKUPSET B ON X.DATABASE_NAME = B.DATABASE_NAME
AND B.BACKUP_START_DATE = X.BACKUP_START_DATE
RIGHT OUTER JOIN MASTER..SYSDATABASES A ON A.NAME = B.DATABASE_NAME
INNER JOIN MASTER..SYSALTFILES C ON A.DBID = C.DBID
AND GROUPID != 0
WHERE A.DBID > 4
GROUP BY
A.NAME,
B.BACKUP_SIZE,
a.sid
ORDER BY A.NAME

	When your Dream turn to Dust, It's time to vacunm
From Pritesh Public Profile