Thursday, June 5, 2008

Ask Questions

You can ask your questions and queries as a comment to this post. We will try to reply in its comment and so on.

Update: we stop receiving question as we have a lot question pending with answer.
we will reopen ask question soon.

SharepointKings Team


Anonymous said...

i have a query.

i am Using FBA.

i want to sync default SharePoint calendar list with my outlook.
after "connect to outlook" the calendar is available in outlook--> calendar--> other calendar--> site name - calendar.

but after synchronizing when i add any item in calendar it should automatic sync with my outlook, but it’s not and it shows error

"You do not have permission to view this SharePoint List (Team Portal - Calendar). Contact the SharePoint site administrator. HTTP 302"

and calendar item is not available is not available.

I’m using win 2003 server with SharePoint 2007 and outlook 2007 and it is development pc not on the internet.

Jayesh Prajapati said...

have have try to simulate your problem in my machine,I works here,let me know have you persist cookie in your machine.cookie should be present in your you said your are using FBA..

Jayesh Prajapati said...

or this kind of error come when you currently not login to your site and then try to open Outlook,and click on send recive or F9 in outlook you will face this kind of error specially in case of FBA...

Anonymous said...

How can I find Min and Max value of ID column in Document Library?
Is there any straight forward and fast way to do this? I have more than 1 lac records in document library..

Malay Vasavada said...


All you can do is, have two queries. first query fetch listitems in ascending order by ID and second query fetch listitems in descending order by ID.

After fetching them, take ID column from both. you will have Min and Max ID's.

Have a happy ID Getting :)

Amar said...

Hi Malay,

We cannot save a site with size greater than 10485760 bytes as a template.

Can you please help me to deal with this issue?


Malay Vasavada said...

Hi Amar,

In MOSS 2007 you can change that limit using stsadm execute the following command :

stsadm -o setproperty -pn max-template-document-size -pv 40000000

Where where max-template-document-size is in Bytes.


Kirti Prajapati said...

I have 2 custom list with same fields
List 1 : "HR Candidates"
Title,Source,Assigned to.....these are the fields
List 2 : "Marketing Candidates"
Having same fields as list 1.

Now i want to consolidate these 2 list in one list name "AllListRecords" and want to put all the records in this list.

My problem is how can i consolidate these 2 lists in one by using ItemAdded/ItemUpdated Event Handlers.

once the consolidation is done .... how can i made the reflection in "AllListRecords" if new record inserted in any of the list (List1 or List2), how can i update/delete the records and get the refreshed result in "AllListRecords".

Reply me ASAP

Kirti Prajapati said...

can i rename the "Title" field to "Name" in Sharepoint Custom List ???

Parth Patel said...

@Kirti "Name" is the reserve word for sharepoint.
you can change name of title but not with "Name" try another name.

Kirti Prajapati said...

how can i do "Auto-Refresh a SharePoint webpart" after 5 seconds of first load of whole sharepoint page ????
I know about the "Auto-Refresh a SharePoint Page"

I need solution for particular webpart.....

Parth Patel said...

use AJAX
here is the link for help

Amarendra said...

Can you please give me information on how to implement a custom site map (left navigation menu ) in a sharepoint site.

My scenario is like this.. we have an application where i've created sitemap for providing leftnavigation control.
I have to deploy the same application on to a sharepoint site.
I want to use the same sitemap in sharepoint also...
I put the below code on custom the master page. But it is taking Default sharepoint sitemap.

asp:SiteMapDataSource runat="server" ID="SPXmlContentMapProvider"/
asp:TreeView ID="NavigationTree" runat="server" DataSourceID="SPXmlContentMapProvider" SkinID="Arrows" EnableTheming="true"

ParentNodeStyle Font-Size="Large" ForeColor="#BAA44E"
RootNodeStyle Font-Size="Large" ForeColor="#BAA44E"


Please provide me with some workaround for this..

Thanks in advance,

Amarendra said...

Hi Sharepoint Kings,

Can you please give me information on how to implement custom site map (left navigation menu) in a sharepoint site.

My scenario is like this.. we have an application where i've created sitemap for providing leftnavigation control.
I have to deploy the same application on to a sharepoint site.
I want to use the same sitemap in sharepoint also...
I put the below code on custom master page. But it is taking Default sharepoint sitemap.

Please provide me with some workaround for this..

Thanks in advance,

Anonymous said...

Jayesh Prajapati said...

Hi Amarendra,
open your master page in SharePoint Designer 2007. and there you can customized left navigation bar.make sure that your control ID should not be chahged.

SharePoint Team.

Amarendra said...

Hi Jayesh,

Here I'm creating a new custom master page. But even then to create a left menu, we need to give SiteMapDataSource.
As you are saying that we can customize the left navigation, can you please provide the code/example for that.. if you can provide that here...that would be fine..else you can also please send me a mail to


Jayesh Prajapati said...

Hi amaredra,
try this steps in your test site and finally when it works then aply it on your site.
1.Open your site in SharePoint Designer 2k7.
2.Then,Left side select folder "_catalogs".
3.under it "masterpage" folder. contains "default.master". "default.master" in designer.
6.Try to find out control "SharePoint:AspMenu" with id "QuickLaunchMenu" and delete it and put your treeview control sameid with "QuickLaunchMenu" and tree view datasource give DataSourceId="QuickLaunchSiteMap"
7.and for style sheet you can add your style in core.css or you can crate your put your own css file in sharepoint designer.

SharePointKings Team.

Hat said...

Greetings. I've found thishandy little Content Editor Webpart using JavaScript that removes Sat/Sun from the Calendar (

The problem I have is once you remove Sat/Sun, the columns for the remaining days expand. Pics available on blog link above.

I've been told I need additional JavaScript to reduce the column size. Anyone have expierence doing this?

Kind Regards

will said...

Hi. I'm currently working on setting up a mock MOSS 2007 portal on one of my company's servers. I have two web applications associated with my portal, the central administration and a content web application. The problem that I'm facing now is that when I try to create a new web application, I get just a page that says "Unknown Error." I was able to create web applications, but I must have done something to bar me from doing any more creating. Also my web application for content is down too. Does any one have any ideas how I could go about finding the problem, and solving it? I have access to the server SharePoint is on. Thanks!


Parth Patel said...

@will to find out error
in web.config of your application (center admin) change folowing things
find "CallStack=" and change its value to false and
find "customErrors" and change its mode to "On".
by changing this you can get .net error page, not sharepoint custom error page.

so that you can find out what is the error then we can do something.

remember to change it back again :) after testing.

will said...

Both CustomerError mode =0n and CallStack = false when I pulled up web.config. I still got the "unknown error" when I tried to open the "create new web application." Anything else I can do to find out what the error is? Isn't there a log that records all errors in the database somewhere? Thanks!


Parth Patel said...

hay will
when you create a web app SP will ask for port and it will generate folder with the port name in most probebly "C:\Inetpub\wwwroot\wss\VirtualDirectories".

so you need to change web.config only on central admin. let's say central admin site in 10000 then change web.config in 10000 folder only.

then definattly you will get some other error then "Unknown error"

will said...

hey parth,
On our server running sharepoint (we only have one server running it) I went through the following path: C:\Inetpub\wwwroot\wss\VirtualDirectories\ to the central admin web application folder. The values were already what you wanted me to change them to, but once I had callstack ='true' I got the following:

A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.ReadPacket(Int32 bytesExpected)
at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
at System.Data.SqlClient.TdsParserStateObject.ReadByte()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SharePoint.Utilities.SqlSession.OpenConnection()
at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
at Microsoft.SharePoint.Administration.SPDatabase.GetExists(SqlConnectionStringBuilder connectionString)
at Microsoft.SharePoint.Administration.SPDatabase.GenerateRandomName(SqlConnectionStringBuilder& suggestedConnectionString)
at Microsoft.SharePoint.ApplicationPages.GlobalAdminPageBase.get_DefaultContentDatabaseName()
at Microsoft.SharePoint.ApplicationPages.ExtendVirtualServerPage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Sorry for the big post. If you can help in anyway we would greatly appreciate it, since this has been bothering us for a while. Thanks!


Jayesh Prajapati said...

Hi will,
while installing MOSS 2007 fist you need to create a new user or use existing user whose password set to never expired.and add this user in administrators group now open database server and assign this user in dbcreator role and admin role in SQL Server login with this user and install sharepoint. I think you might have change your password after installing sharepoint MOSS.that may be the cause..


Manoj Iyer said...

Hi will,

Do go through this post. you will find a good way to See the "Logs".

will said...

Hey Guys,
So the problem was that the sa account was locked and I had to unlock it on my server. Now I have a question regarding web applications. I'm working on a single server and have two web applicatons: my central admin and my portal80 that has various types of content. I created a new web application and I created a site collection to go along with it. I can see the web application name and collection site list on central admin, but whenever I try to navigate to the actual site in my browser, I get nothing. Am I allowed to have more than two web applications on a single server like this? Is it because the server might not be big enough to house all three? I would greatly appreciate any help on this topic. Thanks!


Jayesh Prajapati said...

Hi will,
Can you explain what input you have provided while creating new web application and How you have created new site collection under newly created web application?

like you have named web application "abc" at port 90 and now your url will be http://localhost:90/ this "/(slash)" indicate your root site collection.

its better you provide us your mail id and screen shots what you did.

SharePointKings Team.

will said...

Hey guys,
I need help making my sharepoint (MOSS 2007) websites available for internal users (users that have network accounts) to access externally (when they're not in the network). I've looked everywhere on the web, and I'm a little confused, since it seems like there are a lot of ways. I saw something that said I need to publish my sites through ISA 2006. Is this the way to go? Can you direct me to the right place to learn exactly what to do? Thanks!


Kirti Prajapati said...

How can i create an Event Calendar Webpart in moss 2007. Should be customize webpart which contains events description on particular date. and after clicking on event that event should be synchronized with local pc's outlook messenger...
So how can i do this...can you help me for this ???

Anonymous said...

Dear Kings,

I have come across what must be a commonly felt limitation to standard sharepoint form controls.

Where I want to populate a field with data from another sharepoint list.

1. There is no capability to search within that list to find the required value (makes long lists difficult to handle)

2.There is no capability to filter the list to restrict values displayed.

3. there is no capability to display more than one column from the list.

I would be most grateful if you could suggest ways to address these shortcomings.


Steve (UK)

Anonymous said...

SUBJECT: Backup and restore using stsadm


I used stsadm to create a backup of my sharepoint site collection as:

stsadm -o backup -url -filename C:\spbackup -overwrite

Then I created a new web application thru central admin site with the host header

Now, I restored using stsadm as:

stsadm -o restore -url -filename C:\spbackup -overwrite

QUESTION: The above command did not restore any of my original site collections. I am

guessing it did not even backup my original content database. What can I do?

When I took a backup using central admin site, the folder size was about 20 MB. But using

stsadm, the file size is only 170 Kb.

Any ideas?

p.s. I am using WSS 3.0


Jayesh Prajapati said...

can you try to backup using local machine url.
like in your case suppose your webapplication is on port 2020.
then your url will be http://localhost:2020/projects
stsadm -o backup -url "http://localhost:2020/projects" -filename "c:\test.bak" -overwrite

and see the size.
and while creating new webapplication dont give hostheader in advance after restore backup you can give hostheader...

and let me know is there any alternate access mapping in this webappication?


Parth Patel said...

@Steve (UK)

According to your question,
Whatever you found about lookup column is correct.

And the simple answer is with the SharePoint Lookup column most of the custom business requirement will not achieved.

But you can always create a custom control to achieve this kind of custom business logic.

NikVad said...

i am using wss 3.0 and i want the drop down menu and so i have attached the "SpsiteMapprovider" object, but i am getting the menu arranged in alphabetical order which is not intended. how can i fix this?

ques no 2: i also want to block access to a particular site but give access to its subsites which appear as a drop down menu. please help me with this.

gowri said...

I am using FBA. My requirement is to show full name (first name and last name) instead of user id wherever it appears.
For example "login name" in welcome menu, "Modified By" column in document library.
When I use windows authentication it is proper. Like in this way i want it in FBA.

Ajith George said...

Hi jayesh,
i m Ajith here, your team mate at A G tech. hi i have a doubt regarding sharepoint search.

Can we set alerts to site collection administrator while indexing of a particular child site fails due to some reasons,

we can see the errors in crawl logs but i want to know whether it can be set as an alert to that particular site administrator...

waiting for your response........

Ajith George said...

Hi jayesh.......

can we configure in sharepoint giving acces permission for users from two diff domain with same name.....

eg : Sharepoint portal abc is used by two companies, company A has got a domain called Agroup, can we add users from company B with the same domain name Agroup existing with them,

mail me @

Anonymous said...

I am testing WSS 3.0, wanted to know if I can send email to site users from Sharepoint. I can see option from Site Settings --> Advanced permissions --> All People --> Action --> E-Mail Users

But I do not see this option from Site Permissions. Is there way to get "E-Mail Users" to drop down list in action?


Anonymous said...

Where can I find resources or case studies for how to set up or restructure the taxonomy and Information Architecture for our geographically dispersed company. We have offices in Europe, Africa, Asia and America with the Corporate office being in America. We have regional information which doesnt need to be seen by all users.

Jayesh Prajapati said...

do you want your business solution in MOSS 2007?
then MOSS 2007 is specially ment for collobration purpose,collobration of corporation and all in secure,controlled and managable way.
write us on to know more...

will said...

Hey guys,
I'm having trouble logging on to the virtual server that hosts our stand alone installation of MOSS 2007. It initially said that my domain account was locked, and I got one of the IT admins to unlock, and I was able to go on the server for the day. The next day, Active Directory totally locked my account, and I couldn't log on to the network until an IT admin unlocked my account again. Then later that day, I tried remotely logging in back to the virtual server, and it told me that my account was locked again! Does anyone have any explanations why my account keeps getting locked in Active Directory? Is Sharepoint somehow causing this? Any links or help is greatly appreciated. Thanks!


Anonymous said...

Hi will,
you can solve your problem through this link,unfortunatly it's paid
you can check it out

Manoj Kumar Sriram said...

hi patel,

Even I have experienced the same problem, am using WSS3.0. In People and groups, when i selected all the users and through ACTIONS when i try to send email, its stays calm, nothing is happening. But when i select them individually to certain selection of members only it goes. whether it is an Bug in sharepoint or any settings has to be changed?

any help???

Jeff said...

I have a basic publishing site on MOSS 2007 with a blog subsite. I would like to be able to display the latest blog post in a web part on the front page of the main site. What's the easiest way to do this?

Kirti Prajapati said...

My Query is :

I have one custom List in MOSS 2007 with different fields.

Now i want to hide some fields on the basis of user permission , let me elaborate more :
suppose user X is logged-in to the sharepoint site and now that logged -in user may able to see only few fields from all the fields from custom list. So how can i make this kind of permission for particular user.

kancharla said...

Hi just now i have seen the site . Really i was impressed with work done by the administrator. i have some doubts on sharepoint. which are not cleared since long. i hope that i'll get the solutuins fot them.

in my site i am gettings my breadcrumb like
testing siite-> userpages-> newpage.aspx
testing site= site name
userpages= documentary name
newpage.aspx= aspx page in sharepoint document librart

now i want to hide the userpages( document libtaty ) namr in bread crub . can any one please help me to sort out the issue.........

thanks in advance

Parth Patel said...

Hi kancharla

For removing bread crumbs the best way is remove that in master page .

But the problem it will remove from entire farm.

To solve that use custom master page for your web app.

then find this tag in master page “PlaceHolderTitleBreadcrumb”

then comment whole “asp:ContentPlaceHolder” control whose id is “PlaceHolderTitleBreadcrumb”

your problem might be solved…

Alejandro said...

Tricky issue in Lockup Field!

Hi there,

I am emailing you regarding a tricky issue, I hope you could help me in it.

I am working on a project and dealing with so many lists, and of course there are so many "Lookup Fields" between those lists.

Now I want to transfer these lists to a new environment which already has data and I have no idea how to handle that because I don't want to override the data and of course I want to keep the connections between these Lookup Fields, How can I do that ???

Somehow my problem is pretty close to this entry:

So far, the only way I know how to do that is to export the data to Excel and use Access 2007 to import again so its about how to create Lookup fields with the APIs. I have actually tried several times but never gotten around to do it in another better way, do you have any idea or another option/suggestion or code make me able to handle this issue?

I look forward to hearing from you soon please!


Manoj Iyer said...

Hi Alex,

It would be great if you could come up with an exact example for your query.

Question: You mentioned that the new environment has data and connections. So what does the new environment not possess? Is there any structure change between the lists at the old and new environment?

Question: If your query is pretty close to the one you mentioned in the URL i.e.
“if I try to save the list as a temple (with it's contents) and move it to the
production server the lookup fields are gone”

Then it’s simple.
You will have to programmatically create LookUp Fields and set the connections between these Lookup Fields.

This can be easily achieved by a Utility called LookUp Generator.

Thanks and Regards,
SharePointKings Team.

Hemal said...

Can anybody give me sharepoint intervew questions.? Or any site on which I can find them?

Manoj Iyer said...

Hi Hemal,

Good that you asked about sharepoint interview questions.
We really appreciate your comments.

SharePointKings has compiled a set of most common/tricky Sharepoint interview questions.

The post will be made on 19th of November 2008.

This post will consist of Sharepoint interview questions and the best answers to them.

Have a great day ahead !!.

-SharePointKings Team.

Anonymous said...

could I know where to find and place the commands (Readsecurity & WriteSecurity) for SPList?


Parth Patel said...

for Readsecurity & WriteSecurity of SPList
you can use this code depend upon your requirement.

Most of the time this code will be used while deployment when you create new list instance.
And for one click deployment,
you can write and execute this kind of code snippet to setting some properties of some element of you portal.

For that you can create a feature with feature receiver class so that on activation of that feature this kind of code will execute and
This thing you want can be done in this way.

Anonymous said...

I want to edit a custom field's value programaticaly. which PSI methode should I use for that?
and what procedure needed to be followed?

Anonymous said...

Hi, your blog is a big help, so thanks.

Something i haven't come across is how to customise the breadcrumbs so it doesn't display the 'Pages bit of the path where I store the pages of a site. eg
Home>Tasks>Completed Tasks>Pages>Completed Task 1

I want people to just click on 'completed tasks' to get to the above level of a page instead of going to the document library 'Pages'. In Sharepoint the asp id for the breadcrumbs is

What I want the path to look like is thus:
Home>Tasks>Completed Tasks>Completed Task 1


Canberra, Australia

Parth Patel said...


If you have only this problem of removing only “pages” from breadcrumb then there is one temporary solution.
Removing pages tag from breadcrumb

Here is the script you can write this script on each aspx page in that pages gallery.

<script language="javascript" type="text/javascript"> var isNS = (navigator.appName == "Netscape") ? 1 : 0; if(navigator.appName == "Netscape") document.captureEvents(Event.MOUSEDOWN||Event.MOUSEUP); function mischandler(){ return false; } function mousehandler(e){ var myevent = (isNS) ? e : event; var eventbutton = (isNS) ? myevent.which : myevent.button; if((eventbutton==2)||(eventbutton==3)) return false; } document.oncontextmenu = mischandler; document.onmousedown = mousehandler; document.onmouseup = mousehandler; </script>
<script language="javascript" type="text/javascript">
function ModifyBreadCrum()
var oP = document.getElementsByTagName("span");
for(var i=0;i<oP.length;i++)
if(oP[i].id.indexOf("PlaceHolderTitleBreadcrumb")!= -1)

var innersting = oP[i].innerHTML;
var myNewString = innersting.replace(">pages</A></SPAN><SPAN> &gt;", "></A></SPAN><SPAN>");
oP[i].innerHTML = myNewString;

var tp = oP[i].childNodes;
for(var j=0;j<tp.length;j++)

Again we are not sure how robust this solution, this is just a temporary solution that you can do for time being.

Note: please check the values form java script by using alert and replace tag according to your need.

Sharepoint Kings Team

Anonymous said...

Thank you Parth for answering the breadcrumbs problem :-) It worked!

Anonymous said...


You posts are really very helpfull.
you guys talk straight,clear with a lot of easy to understand examples.

One suggestion
I will be great if you guys can start a thread that will help preparing for Certifications in SharePoint.


Anonymous said...

i am using FBA.

How can i use Connect with Outlook?


Adrienne said...


I need to limit the display of items in the announcements web-part.
I know I can do this by expiry date and 'current view' when the announcements list is shown as a web-part, but I have it as a data view instead (so I can have borders).

How do I limit the display of announcement items by expiry date? Should I used the data filter option, if so, what kind of parameter to use? eg to have 'don't display item if more than 14 days old'. Preferable to have a parameter setting for each item, eg one item to hide after 2 days, another one after a month etc.

Thank you,


Jayesh Prajapati said...

in case of FBA to connect with out look you need to store cookie in your default cookie in FBA not stored in machine it maintain in your browser,so try to store cookie it will help you out..

SharePointKings Team.

Adrienne said...

Hello again,
the fix for hiding an item in the breadcrumb using java script works well (see my post from Decmber 1) in Explorer, however, when viewing in Firefox, the breadcrumb bit doesn't hide.
And this is with both setting the Firefox browser to allow java script and disable java script.
Could you please advise how to hide the breadcrumb item as viewed in Firefox.

Thank you,


mah said...

i have a sharepoint 3.0 project on my pc which is connected with local network. my pc is an application server, it has active directory and all the necessary sharepoint software. i have created a sharepoint project. now i want to deploy it in a server from where users from all around the globe can access it. How can I do This?

Adrienne said...


just in case anyone else had the same trouble (javsacript in Firefox not work), I got the answer from a colleague

the line you need to replace (I think) is:....
GAh it won't let me post code in this comment!

Please email me at if you need to know the answer

Netta said...

I want to set a global policy where every time someone uploads or creates a document in the share point he will need to enter some basic meta data about the document (like it's security level and type)
not just on a site level but the entire portal.
we had a policy like that at the 2003 version but it stopped working once we migrated to Moss2007. how to I set it up again ?

Anonymous said...

I want the data of current published major version of document from document version history how can I get the version of document which is current published major version from all version of document in document library can anyone suggest me on this I am using the following line of code which get the all version of document
SPSite Osite = new SPSite("http://pc135/Docs");

SPWeb Oweb = Osite.OpenWeb();

SPDocumentLibrary List = (SPDocumentLibrary)Oweb.Lists["Documents"];

SPQuery query = new SPQuery();

query.Query = "SP Querry here";

SPListItemCollection SpCollection = List.GetItems(query);

foreach (SPListItem ListItem in SpCollection)
if (ListItem.HasPublishedVersion == true)
SPListItemVersionCollection Objversion = ListItem.Versions;

DataTable DT = new DataTable();

if (Objversion.Count > 1)
foreach (SPListItemVersion Ver in Objversion)
int VID = Ver.VersionId;
DateTime date = Ver.Created;
String VersionText = Ver.VersionLabel;
SPListItem ObjItem = Ver.ListItem;


Anonymous said...

Nice Blog with a nice way to interact with others.

i have a small question
i want to extract a javascrip file from an external assembly and write it somewhere accessible to my sharepoint site,

how to do that?

thanks in advance,


LoonyToonz said...

Hi There,

We have a WSS 3 server in production, and an external developer has created a web app which our management team have decided they want i hosted in the SharePoint site.
Obviously we need to test this without it breaking the live site.
I thought I could back up the live site, and then create a new webapplication on the server and restore the site into the new web application with new databases etc, Test this thoroughly and then add the developed web application and test again.
Unfortuantely I have been having problems finding out what I need to do.
To backup the entire Live SherPoint site, and restore it onto a new web application on the same server (new port, IIS folders, SQL databses etc) and test it.

Any help would be appreciated.

Parth Patel said...

This below comment is from "Adrienne Gross" we are thank ful for sharing this effort.

the line you need to replace is:

var myNewString = innersting.replace(">Pages</A></SPAN><SPAN> >", "></A></SPAN><SPAN>");

You might try:

var myNewString = innersting.replace(new RegExp(">Pages</A></SPAN><SPAN> >", "i"), "></A></SPAN><SPAN>");

.replace() is case sensitive & Firefox is probably changing the case of the text you’re trying to match.

Anonymous said...

Howdy kings! I was curious what if any books/videos/tutorials you would recommend to learn to start creating SharePoint Workflows, or modifying existing SharePoint Workflows created in SharePoint Designer (createing/editing using Visual Studio). I just started with SharePoint development a couple of weeks ago, and as of now I am doing simple tasks like batch-editing, modifying, and setting permissions of documents in document libraries.

Anonymous said...

I am trying find the equivalent of
frm.FindField(fieldName).fRequired =true in WSS 3.0. My requirement is to change the "Required" flag of a field based on values in another field. In 2.0 you can do that using javascript:

frm.FindField(fieldName).fRequired =true

Is there a way to achieve the same in WSS 3.0?

murugaratham said...

Hi SharePoint Kings,

I have a requirement to generate some "render-time" buttons with their appropriate event handlers.

Microsoft's documentation keeps telling me to render than in the CreateChildControls(), but the business logic require me to do a "Render(System.Web.UI.HtmlTextWriter writer)" (create button + handler there) but when the codes are being fired, the buttons appear just fine, however with no handlers. A few days of searching haven't been fruitful. Please help.

Reena said...

Does anyone know how can I find the user who is modifying the document library in the Itemupdating event

Adrienne said...


I have a sub-sub site and the pages within this are missing a link in the breadcrumb "GlobalNavigationSiteMap' Sitemap path.

It should go:


But instead it goes:

I have checked the site structure, and a sub-sub site at the same level has the correct links in the path. I tried copying that asp bit and pasting it into the master page of the bad site, but still not work.
Should I edit the node template? If so, how?
I also tried pasting in Parent level to display '2' but that didn't work either.



Anonymous said...

I have a question. I have a lookup field as a column in a list, and when I look at the contents of the column in SQL Server, it looks like this: ↓ ъ䅃㒳ꅉ
The field it is populating it in is an nvarchar datatype. I've tried to convert or cast it into different datatypes so I can see the contents, but this doesn't work. Could you help me please?? Thanks!!!

Anonymous said...

So i understand that we need to use feature stapler/staplee to customize the creation of the new My Site. Is that the same thing as changing the left menu of My Site and how to control what the users can do under My Site?

Thanks for the help,


Hi Guys,

I have reset the timeout value in our companyweb to zero in an effort to not have it close down after 30 minutes. So now i can't get into companyweb because every time i open up the site it closes immediately. Is there another way i could get to the default master file without going via the compayweb url? I need to edit the master file so that companyweb stays open.

Thank you to whoever helps me.

Karin said...

Hi Kings,

I have a question concerning the routing of a SharePoint-Site.

Here the scenario: my company has various locations in different countries. However, there exists only one SharePoint Site with many subsites.

Now the question:
Is it possible to link the users on the basis of their usernames (which indicate their location) to the proper subsite? How can I realize this?

Best regards and thanks in advance,

Anonymous said...

I have lots of pages in my document library. There is a previous screen arrow and a next screen arrow to navigate. Suppose the user is in the 50th page and wants to go directly to either the first document library page or the last document library page, how do you do it?

SharePoint Kings said...


try declare SPContext same as httpcontext mentioned in this link

we had not tried it but it should work.

waiting for your reply

SharePoint Kings said...


for your requirement you can create a hidden web part and put it in Master page.
which will find second level site title (or what ever you want to remove) and fire a javascript which will find specific breadcrumb and make display none.

that's the only temporary solution which we had right now.

will update you soon.

SharePoint Kings said...


you can detect user on page load of your default site with (SPContext.Current.Web.User) and redirect that user to respective sub site.

Viraj Vashi said...

I have one custom list whose name is ‘Defects’ and in that custom list i have one lookup control whose name is ‘Project Name’(Which comes from Project details list) and one more column i have which is ‘Assigned To’(which is people picker). I want to display display users in ‘Assigned To’ column based on Project name column.

For better understanding…
Project name: Lookup control(Dropdown list)
Assigned To: People picker

SharePoint Kings said...


Sharepoint will not give this kind of facility you have to create custom control for this.

giriraj said...

I Have a query,
How can i Hide the documents ,based on the user permissions ,using object model...or is there any way to do in outof box

Anonymous said...

I ould like to view all content posted on a specific date for historical analytics. Is this possible? Can I adjust the View on the Site and Content Structure to allow for this?

Thank you!!

Steve.Ferrier said...

I am trying to create an attendance management list for HR, which informs a vacation balance list (or view)for employees.

At the beginning of the year, everyone gets 15 or 20 days vacation, which is tracked in a field called [vaca_entitlement]. We have a policy that personnel can carry over up to 10 vacation days from the previous year, but must be used by 3/31. This is tracked in a field called [carrover].

So I need to 1) setup the value of carryover to reset to 0 value after 3/31; 2) Configure [VL]field to subtract from [carry over]first, IF the value is more than 0, and it is between 1/1 and 3/31, otherwise it would subtract from [vaca_entitlement] field.

Is this possible? If so, how?

Arth said...

Hi All,
If i say i have my credentials as :
UserName: XYZ
Password: BlahBlah

and if i want to log in to sharepoint Site to do that????
Please revert asap...


The Dude said...


In a workflow task form, how can I check if the document related to the task is checked out?


Share your SharePoint Experiences with us...
As good as the SharePointKings is, we want to make it even better. One of our most valuable sources of input for our Blog Posts comes from ever enthusiastic Visitors/Readers. We welcome every Visitor/Reader to contribute their experiences with SharePoint. It may be in the form of a code stub, snippet, any tips and trick or any crazy thing you have tried with SharePoint.
Send your Articles to with your Profile Summary. We will Post them. The idea is to act as a bridge between you Readers!!!

If anyone would like to have their advertisement posted on this blog, please send us the requirement details to