SharePoint MIX

MS to pull the plug on InfoPath

noreply@blogger.com (PM) — Tue, 18 Feb 2014 19:18:00 +0000

Alright, guess my post's topic says it all. So, it's true, loud and clear, Microsoft is going to discontinue InfoPath from the next release of SharePoint. MS did launch the InfoPath 2013 along with the suite of other products on SharePoint 2013 and they will support the product for the next 10 years i.e., 2023.

Want to read more on this, click here: http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/

Can't get SPContext inside Event Receiver

noreply@blogger.com (PM) — Sat, 24 Aug 2013 20:19:00 +0000

Just recently came to know about this, thought I might share my learning. It is basically by design that you cannot get the SPContext inside the event handlers. This might leave you wondering then how should you proceed?

Well, you can of course use event properties passed as argument to the handler to get reference to current web, site, or the list item, etc.

Example below:

public override void FeatureActivated(SPFeatureReceiverProperties properties)
{
SPWeb web = properties.Feature.Parent as SPWeb;
//Some code with web
}

How to hide the quick launch and left panel in SharePoint

noreply@blogger.com (PM) — Sat, 25 May 2013 06:37:00 +0000

While working on a recent assignment for creating a custom master page, the left side quick launch area needed to be hidden. So, I put the below statement in my masterpage's associated CSS file to override the coreV4.css default behavior:

.s4-ca{

margin-left:0px;

}

Saved my css changes in the SharePoint Designer and checked my changes, while it looked fine on the IE 8+, on Mozilla browser, my page content was coming out / exceeding the right boundary as I was making a centered masterpage.

I used Mozilla's Toggle Tools under developer tools menu and found that the left panel was still occupying space on left and making the page content shift to the right. To fix the space occupied by the left panel, I put the below statement in the custom CSS and it did the trick on Mozilla. Do not forget to save the changes to the CSS after you have made the modifications and then refresh the page.

#s4-leftpanel{

width:0px!important;

}

You can even try

#s4-leftpanel{

width:display:none;

}

Add Custom CSS to your SharePoint MasterPage

noreply@blogger.com (PM) — Wed, 15 May 2013 17:28:00 +0000

As often it happens, we have to customize the look-n-feel of the v4.master to achieve the styles as expected by customer. At this point, we end up designing a custom CSS and then associate it within the MasterPage. The steps for doing that are explained below:

Use an SP2010 control called cssregistration and add a line below the existing csslink:
Existing line: runat="server" Version="4" />
Now, add the above mentioned control by putting the line: ="server" name="/Style%20Library/Scripts/style.css" After="coreV4.css" />

What this does is basically it tells the SharePoint to load your custom CSS after the load of the default Corev4.css. This way your styles will supersede the default styles.

Fix the Max Controls Issue in SharePoint

noreply@blogger.com (PM) — Sat, 11 May 2013 11:26:00 +0000

While working with SharePoint MasterPages, sometimes, you might see this peculiar issue, "This page allows a limit of 200 controls, and that limit has been exceeded" and ponder over what could have caused it.

The real source for this exception to be thrown is in the web.config file,

MaxControls

="200" CallStack="true" DirectFileDependencies="10" TotalFileDependencies="50" AllowPageLevelTrace="false" />

So, this is about the limit that Microsoft has typically placed in a SharePoint Web Application's web.config, the SafeMode section has a MaxControls attribute that's set to 200 by default.

Going past this threshold limit may cause stability issues for the page. This could have been caused accidentally while you were adding some custom controls on the Masterpage.

To fix this, do not try to edit the web.config Max Controls setting to a higher number as that is not recommended although for smaller enterprises it might be permissible. However, at large corporations, this would not be allowed by their IT department.

Rather, you should take out a few controls from the MasterPage by editing it in the SharePoint Designer (SPD) and do an IISReset, your page starts working again. This should save your day again.. :)

Steps to consume Aspose Cells license in Code

noreply@blogger.com (PM) — Thu, 09 May 2013 19:47:00 +0000

Recently, I got the chance to use Aspose.Cells in one of my project. Once, you have procured the Product license key which is typically in a .txt file, you can register the license in 4 simple steps:

Get rid of any reference to the evaluation period version of the DLL (if used) from your solution
Add a folder in the VS2010 Solution and just add a folder and place the required license file (Aspose.Cells.Lic)
Make the client license as a part of the VS2010 solution by going to the license property in Visual Studio and choosing In the Properties dialog box, locate the Build Action property. By default, this property is set to Content. Click the property and change the Build Action property to Embedded Resource
Before starting the use of the available tool in the visual studio webpart, you need to write the below code atleast once in the code and refer to the correct DLL.
This method can be called on the Page_Load of the Visual Webpart code behind (.cs) file. For more details, use the below mentioned URL to the Aspose team:
http://www.aspose.com/docs/display/cellsnet/Licensing

//Instantiate the License class
Aspose.Cells.License license = new Aspose.Cells.License();

//Pass only the name of the license file embedded in the assembly
license.SetLicense("Aspose.Cells.lic");

MCTS Finally - End of issues with MCP ID

noreply@blogger.com (PM) — Thu, 13 Oct 2011 19:49:00 +0000

Long time ago..actually 2 years back, during TechEd 2009, I knew I was on my way to becoming a Microsoft Certified Technology Specialist (MCTS) as I had cleared the required certifications-

However, as it happens, the person who was filling-in data on the computer for my certification accidentally created another MCP ID rather than continuing with my previous ID. I was unaware of this during and even after the exam for a long time.

When I realized this, I lost all the joy of clearing my 3rd MS certification and I let it be then. Also, I dumbly provided my then organization email address which was later discontinued by Windows Live services.

Fortunately, today things had to take a different turn, when I saw from one of my colleague the UX for the new MCP site. I decided I got to fix this stuff and earn my MCTS badge. So I looked up the Microsoft site and found the helpline numbers here:
http://www.microsoft.com/learning/en/us/help/service-asia-pacific.aspx#tab2 (for India)

The helpdesk executive was patient and she understood my issue. She was able to rectify my problem by keeping my older MCP ID and merging the result from the newer one to this. She was polite to update all contact details and replaced my old organization ID.

Voila, there I have it now.. :)

I really hope this helps someone who might have faced a similar issue with MCP ID.

Planning to write MS Certification 70-576

noreply@blogger.com (PM) — Wed, 12 Oct 2011 18:51:00 +0000

Designing and Developing Microsoft SharePoint 2010 Applications

It has been quite sometime since I last wrote any MS certification. I am planning to write the 70-576 on the latest SP 2010 soon. Lets see how it goes..

Some helpful items could be found at the below links for preparations:

http://channel9.msdn.com/learn/courses/SharePoint2010Developer/

http://joelblogs.co.uk/2010/09/01/top-tips-for-passing-sharepoint-exams-70-667-70-668-70-573-and-70-576/

Bye, I gtg now..studies ;)

SharePoint 2010 SP1 released and Office Sept CU available

noreply@blogger.com (PM) — Thu, 22 Sep 2011 15:20:00 +0000

SharePoint 2010 SP1 was released on 28th June 2011 and it is available for download.

It is important to have your systems updated with the latest service packs and subsequently with the cumulative updates (CU) which MS typically releases each month.

Some important points to note before going ahead with the installation:

Do read the known issues published on the TechNet: http://support.microsoft.com/kb/2532126
Be aware about the order to follow in case of these updates:

Update SharePoint Foundation first with SP1 and then install the CU
Then SharePoint Server with SP1 and then install June CU

If you have a farm installation, then run “psconfig –cmd upgrade –inplace b2b -wait” on every server in the farm following the final update installed else run the same command on your standalone box
To verify if the updates have been installed properly, check the Central Administration à System Settings à Manage Servers In Farm
Or, in PowerShell, write (get-spfarm).buildversion

It should display 14.0.6029.1000 after SharePoint Server 2010 SP1. Hope this helps folks trying to keep their SP2010 boxes up-to-date.

For any other assistance, go through SharePoint 2010 Team Blog here

Fix Configuration of the Document ID feature

noreply@blogger.com (PM) — Wed, 21 Sep 2011 18:57:00 +0000

With SP2010, Microsoft has tried to provide an excellent and helpful feature for uniquely identifying a document within a site collection called DocumentID.
Well, you might ask the rationale behind this tiny change from MS side..right?

Basically, with the previous version of SharePoint product i.e. MOSS 2007, if the user moved a document within a site collection, lets say from one document library to another or the folder containing the file has been renamed or your site URL has been modified in someway, then you would typically face a situation which in IT is called a Broken Link or simply put a bad url :(.

Hence, in the site collection features, you would typically get an option to activate/deactivate the Document ID Service

Document ID Service

Once you have this activated, you would expect the Document ID column to show up when you try to add a new document to a library, unfortunately there is another catch here. You might see this message, "Configuration of the Document ID feature is scheduled to be completed by an automated process." as highlighted in the image below:

This message is shown because the timer job called Document ID enable/disable job has been activated. Once the job completes at the scheduled time, the message will go away or else you may run the timer job and put it to completion forcibly by clicking "Run Now". However, I can assure you that even after the previous step, there is no certain time when the Document ID would show up if you go for a new document upload.

Document ID enable/disable Job

One v.important note that if your doc lib was already having some documents, you would need to explicitly perform some action for this new column of Document ID to show up..for example Check-in/Check-out of docs.

Do try this out and explore this cool stuff from SharePoint 2010!

ASP.net WebParts Vs SharePoint WebParts - Which one to choose?

noreply@blogger.com (PM) — Sat, 19 Feb 2011 14:58:00 +0000

And we are back! Well, it has been a very busy time for me over the last 8 months, anyhow moving on.

Well, this might be a question which should have popped-up in the head of any beginner in SharePoint probably with some .net background.

Well, an interesting point is that SharePoint 2007 is based on top on ASP.net 2.0 framework. Hence, for folks who are well versed with ASP.Net 2.0 and plan to move on to MOSS/SPS should definitely start with "HelloWorld" kind of webparts using System.Web.UI.WebControls.WebParts.WebPart as a reference.

This enables:

Usage on websites developed on ASP.net 2.0 and also on SharePoint based portals
Getting familiarized with Windows SharePoint Services 3.0 classes as a starting point

However, the hard truth remains that sooner or later, developers working on MOSS or SPS would need to move on to Microsoft.SharePoint.WebPartPages.WebPart in their code.

It obviously has it's own advantages:

Enables cross-page connections
Enables connections between webparts placed in different webpart zones on the same SharePoint page
Helps in migrating webpart code to WSS 3.0 based webparts
Utilize the SharePoint offerred data caching mechanism

Signing off here..enjoy coding!

Bonjour!!

noreply@blogger.com (PM) — Fri, 27 Aug 2010 05:59:00 +0000

Yes exactly that is what has happened!!

A business trip in Paris has made me extremely busy these days, due to which I really wanted to but have not been able to spend time on the blog.

I assure y'all that I will be back, till then Au revoir

Increase SharePoint Upload Limit

noreply@blogger.com (PM) — Sat, 03 Jul 2010 21:27:00 +0000

Are you facing issues when trying to upload files of size above 50 MB to your SharePoint 2007 document library?

Well, I have tried to list down how you can fix those issues and ultimately increase the SharePoint Upload Limit:

First, increase the Maximum Upload Size for a specific web application.

Go to the Central Administration > Application Management > Web Application General Settings
Specify the new maximum upload size for your webapplication. For now, we are setting it to 256MB. It could be even set upto 2GB.

Your second step should be to try increasing your default chunk size of large files by trying this STSADM command:

Stsadm.exe –o setproperty –pn large–file–chunk–size –pv

This basically denotes the chunk of data that can be read from SQL Server at one time.
The -pv which determines the property value stands for the upload size in bytes (B).
It could be set to a maximum of 2GB i.e. (2,147,483,648 B).
Do an IISRESET

Next, in web.config file of your particular web application, under the httpRuntime tag in system.web section, increase the upload limit to match the value that you set earlier in central administration. You also need to add the execution timeout to allow more time before the upload operation times out as shown in the example below:

httpRuntime executionTimeout="300" maxRequestLength="256000"

where

300 means 5 minutes as execution time out
256000 allows uploading 256 MB files.

After the above changes, MOSS would allow files of more than 50 MB to get uploaded easily. Incase you still face challenges, check if the file you are trying to upload, is it a blocked file type e.g. EXE, DLL, etc.

Hope this helps you.

Add PDF Icon to SharePoint Library

noreply@blogger.com (PM) — Thu, 24 Jun 2010 19:21:00 +0000

Quite obviously, we come across many occassions where PDF files are uploaded to SharePoint 2007 Libraries or Lists.

While we can easily see the images of our regular Word, Excel, PowerPoint documents, however the PDF documents look empty without the trademarked image.

Well, no problem, who says we can't have it. It is fairly simple, so let us see how:

Get the appropriate Adobe PDF icon image (preferrably a gif) from here
Save that image confirming with SharePoint images standard such as icopdf.gif. Place the image where Office document icons exist by-default. Check out this 12 Hive path of your MOSS 2007 installation:
Drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Images
Now that we have successfully placed the image, we need to inform SharePoint about our modification. For doing this, we need to add an entry to the DocIcon.xml file which sits in the Drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Template\Xml path
Open the docicon.xml with any editor such as Visual Studio or even Notepad. Under ByExtension section, add a key/value pair as given below:
Mapping Key="pdf" value="icopdf.gif"
Note: Take a backup copy of the DocIcon.xml prior to the changes (to be on the safe side). Also, the XML start-end tags are removed as the post wouldnt allow it easily. Kindly take care in your case.
Save changes to Docicon.xml file. Perform an IISRESET command to finalize the same.

Refresh & check the same list or library page to notice the changes take effect.
Briefly, what this does has done is, if SharePoint sees any file (new/old) with an extension .pdf, it would display the PDF icon against the file as it does for Office documents.

Hope y'all find this information helpful. Cyaaa..and..stay tuned!!

SharePoint Timer Job stuck at Deploying

noreply@blogger.com (PM) — Sat, 19 Jun 2010 06:15:00 +0000

Dealing with SharePoint solution packages and solution deployment stuck at "Deploying" status!!

Well don’t panic, here is just what the doctor ordered:

Check the Timer Job Status for the solution deployment in Central Administration. There could be entries with “Failed” as the job status.
Lets try to set things right by running stsadm -o execadmsvcjobs command.
Note that in a farm environment, you need to run the above command on all the servers.
As a next step, try restarting the OWSTIMER Service on all boxes in the farm.
If the above steps do not help the solution deployment. You may try retracting the solution using Retract solution command or through the Central Admin's Solution Management.
stsadm.exe -o retractsolution -name
For your knowledge, retracting a solution creates another “deployment job”.

Now if retracting the solution does not work, do not try to Force Delete the solution as that would throw an exception, "The solution cannot be removed when job is scheduled or running"
Get a list of all the pending & active deployments on your MOSS Farm using
stsadm -o enumdeployments command.
Make a note of the GUID of the various solutions on the command window as this would be required in next step.
As a last nail in the coffin, we now need to simply cancel the solution deployment by passing the GUID of the solution as shown below
stsadm -o canceldeployment -id "job id string here"

After performing the above steps, you would be able to either put the SharePoint Timer Job into completion or atleast remove the solution package being stuck in deployment.

If the problem still persists (esp. in the MOSS 2007 Farm environment), you might need to remove/detach a defective WFE from the farm and then retry deployment.

I have tried to put together the steps which have worked for me, hope this post helps you all too.

Dotnet Cleanup Tool

noreply@blogger.com (PM) — Mon, 07 Jun 2010 18:32:00 +0000

This is not a promotion but sharing my learning about an awesome tool for fixing old..stuck-up..incomplete..DotNet framework installations.

I personally learnt about it while coming across one of the blogs.

Do try it to remove the .NET Framework 1.0, 1.1, 2.0, 3.0 and 3.5 This would even help you if you want to go ahead with a clean install of .Net 4.0

Try .Net Cleanup Tool

HTH.

SharePoint DateTime Format Conversions

noreply@blogger.com (PM) — Sun, 06 Jun 2010 20:18:00 +0000

SharePoint 2007 uses ISO8601 DateTime format internally. It understands either of 2 possible notations for DateTime:

YYYY-MM-DDThh:mmTZD or
YYYY-MM-DDThh:mm:ssTZD
where,

understandably YYYY being 4-digit year, MM for 2-digit month number, DD for day of month
T stands for start of time.
Following that denotes the time which could be "hh:mm" (hours-mins) or "hh:mm:ss" (hours-mins-seconds)
Z indicates the Coordinated Universal Time (UTC)

On many occassions during MOSS 2007 development, we are required to convert from DateTime to ISO8601 DateTime or vice-versa. So, I decided to post on how this could be achieved.

Convert from DateTime to ISO8601 DateTime (C#):

DateTime date = DateTime.Now;
string isoDate = SPUtility.CreateISO8601DateTimeFromSystemDateTime(date);

When you are trying to insert or modify some DateTime fields to or from a SPListItem, you could use the code given above to format values into ISO 8601.
You can build the CAML query for the SPQuery object as shown below:
Example:

Note: Don't forget to add reference of Microsoft.SharePoint.Utilities in your class file before building your project.

Convert from ISO8601 to DateTime (C#):

DateTime date = DateTime.Parse("2010-06-15 00:00:00");
string sysDate = date.ToString("MM/dd/yyyy");

Note: In above example, the ISO DateTime string is converted to DateTime equivalent using DateTime.Parse method.

Also, incase you want to change the Site Collection date format:

Go to "Site Settings" & navigate to "Modify All Site Settings"
Click on Regional Settings under Site Administration
Change the time zone. Save the changes.

This brings us to the end of this lengthy post. Hope it helps you SharePoint folks, goodbye for now.

Resolve MachineToApplication error in web.config

noreply@blogger.com (PM) — Sat, 05 Jun 2010 09:26:00 +0000

Sometime, when you are trying move your SharePoint application from your Staging to Production environment, did you come across this ugly error:

Parser Error Message: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

I am sure, this is enough to spoil the party just when you are expecting your SharePoint website to be up-n-running in the live environment. Now the question comes, "How do we fix this darn thing?"

Well for that, you could try the below suggestions. If you read the error message carefully, it has 2 hints already in it.

Hint #1: virtual directory not being configured as an application in IIS

Resolution: Make sure you have correctly configured your web application in IIS Manager. If it is a simple folder in wwwroot directory, you should "convert" it into web application.

Open IIS manager
Find your folder, right-click -"Properties"->"Create" button
Recycle the application pool

Hint #2: c:\inetpub\wwwroot\webservices\...\web.config line XX where XX stands for line number in web configuration file

Resolution: If you do a find for line XX in your web.config, you are sure to reach this line,

For fixing this, comment this line in this fashion and then save the web.config:

Try accessing your site after the above modifications, it should work fine now.

That's all folks!! (for now :D), please let me know if this helped.

.Net 4.0 Framework Evolution

noreply@blogger.com (PM) — Thu, 03 Jun 2010 19:33:00 +0000

As you must be aware that Microsoft has unveiled its latest Dotnet Framework 4.0, I just thought I should add some information and provide download links for .Net framework 4.0.

4.0 is a superset of older versions of framework but it is independent of 3.5 or any other older frameworks. It is a standalone package.It is independent due to its brand new CLR.

The framework is constantly reviewed by MS. If you see the evolution of the framework, the 2.0, 3.0, 3.5 had been on the same CLR but it was much different from previous 1.1 Framework. The versions which followed 1.1 had vast modifications. And, now 4.0 has comeout as a new offspring as shown below:

There are various products such as Visual Studio 2010, SPS2010, BizTalk 2010, etc.. which are already based on this new 4.0 framework.So fire up your engines and try your hands by downloading the latest .Net 4.0 Framework Offline Setup package from this link download

Find the IP Address of the SharePoint 2007 User

noreply@blogger.com (PM) — Tue, 01 Jun 2010 17:21:00 +0000

Suppose you have a SharePoint website that is being accessed by a lot of users everyday (~1K users daily).

Now for some reason or the other you want to capture the client IP address of the end user accessing your MOSS web application.

Purposes could be like:

Reporting/Logging user IP address
Security purposes
Filtering content based on the client IP address
Getting the location of the user based on the client IP address
so on..

You could simply use HttpContext.Current.Request.UserHostAddress to get the IP address of a user.

This could be easily used in both ASP.Net applications as well as SharePoint development projects.

Difference between SPWeb.Users, SPWeb.AllUsers, SPWeb.SiteUsers

noreply@blogger.com (PM) — Sat, 29 May 2010 07:44:00 +0000

MOSS 2007 offers 3 different user collections in the SPWeb object.

SPWeb.Users
This represents the collection of users or user objects who have been explicitly assigned permissions in the Web site . This does not return users who have access through a group.

Example (C#):
SPUserCollection users = web.Users;
SPWeb.AllUsers
This gives us the collection of user objects who are either members of the site collection or who have atleast navigated to the site as authenticated members of a domain group in the site.

Example (C#):
SPUserCollection users = web.AllUsers;
SPWeb.SiteUsers
This is the collection of all users that belong to the site collection.

Example (C#):
SPUserCollection users = web.SiteUsers;

These terms tend to confuse us unless we really know the differences between each one of them.

So I thought it would be nice to write an article stating which is what. Hope this information helps you SharePoint 2007 developers.

How to Fix Central Administration: Service Unavailable Issue?

noreply@blogger.com (PM) — Sun, 16 May 2010 06:29:00 +0000

While working on MOSS Servers, you all must have faced 2 common issues quite frequently

You receive a "Cannot connect to the configuration database"
Service Unavailable

Basically, the configuration database is where SP stores all information about the SharePoint 2007 installation and the server farm, hence, it is required for the Central Administration to work fine.

Suddenly while you are in the middle of your important SharePoint deployment or configuration, either of these issues will prop up and eat up lengthy hours. Even the easiest solutions to all SharePoint problems i.e. IISReset or Server restart also do not end your miseries.

Hence, I decided, lets apply TRY-CATCH-FINALLY on these issues for once-n-for-all here.

For Issue#1:

Try to run the SharePoint configuration wizard once, follow these steps for the same:

Click Start, click Run, type cmd in the Open box, and then click OK.
Change to the following directory:
system drive\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\Bin
Run the following command:
psconfig -cmd upgrade -inplace b2b

The above steps should fix the issue, but if your problem still persists, then check the event logs of your server. Checking those logs will let you know issues such as -

Is your SQL server agent running?
Credentials (app pool permissions) used for connecting to SQL Server is working or failing?
Facing any network issues to be able to connect to DB?
(this only applies if the SQL is applied on a separate box from MOSS 2007)
so on..

For Issue#2:

If even after carrying out the above suggestions, you are not able to track down the problem, then you could unprovision Central Administration and then reprovision it.

This could be easily done via an STSADM command given below:

stsadm.exe -o provisionservice -action start -servicetype Microsoft.SharePoint.Administration.SPWebService -servicename WSS_Administration

I sincerely hope this helps you all in fixing this critical MOSS 2007 Central Administration issue.

How to backup a DLL from GAC to another directory?

noreply@blogger.com (PM) — Tue, 04 May 2010 19:18:00 +0000

Recently, one of my friends came up with a requirement where she wanted to take a backup of an existing .Net assembly that was already deployed in Global Assembly Cache (GAC) earlier.

When she asked me this question..I thought to myself that this should not be so tough..well it proved so too at the end.

Finally, this is how it could be done (well..one way of achieving this!!)

If you go to Windows Run Assembly you will see this screenshot

Now, go to the Command Prompt on your system and type
cd windows\assembly ENTER (Key)

Next, type GAC in the CMD prompt, hit ENTER

Suppose, you want to copy "Extensibility" DLL from GAC to another directory, then type cd Extensibility (you can type Ex and press Tab on your keyboard to navigate faster) to enter the folder hierarchy.

Note: This would be your custom DLL instead of "Extensibility"

Press cd + Tab (keyboard) and hit ENTER again.

Once there, we need to copy!!

In CMD window, type: copy extensibility.dll C:\myCustomDir. Hit ENTER key

Go and check in that directory, you will find the Extensibility dll nicely lazing around..

Hope this post helps you all SharePoint 2007 & Dotnet developers as well as admins in doing this simple but at times life-saving act.

Extracting data from Sharepoint Version table

noreply@blogger.com (PM) — Sat, 24 Apr 2010 06:29:00 +0000

When using SharePoint 2007, if we turn the Version Control settings to On for a List/Library, then different versions of the file or listitem get stored in the Content DB.

There are multiple ways to retrieve this information:

Using MOSS 2007 API
Via Versions.asmx - An OOB SharePoint Webservice
Or Querying the Docs & DocVersions table directly in using T-SQL statements

Now through SP API, you can try something like this -->
SPWeb web = new SPSite("your site url").OpenWeb();

SPList lib = web.Lists["your library"];

foreach (SPListItem item in lib.Items)

{

SPFile file=item.File

SPFileVersionCollection versions = file.Versions;

//Add your code to loop through the version collection & add custom logic here..

}

Coming to WebService approach:

SharePoint has a Versions.asmx web service to work with versions in document libraries.

For introduction, check out how to utilize this to get some information :
http://www.c-sharpcorner.com/UploadFile/klaus_salchner@hotmail.com/SharePointWS11152005045049AM/SharePointWS.aspx

Incase, you want to go ahead querying the SQL tables directly, then you could try a query as below:

SELECT DocVersions.version
FROM Docs INNER JOIN DocVersions ON DocVersions.Id = Docs.Id

Although it is not recommended that you query the SP DB directly. Any modifications or changes to the Content DB tables in unsupported.

Also the data is stored in UTF-8 Encoded format. After the query runs, it returns some data like this:
UIVersion

512
1024
1536
2048
512
1024
512

The above data is difficult to interpret in terms of Version numbers. Anyway, just to let you know

512 = version 1,
1024 =version 2,
1025 =version2.1,
2048= version 3,
1=version 0.1
and so on..

I guess the pattern is clear to you. Hope this article helps you.

SharePoint List Title Column

noreply@blogger.com (PM) — Sat, 17 Apr 2010 10:37:00 +0000

Generally there are 2 things we like to do with our SharePoint custom list Title field viz. Rename or Hide
Before we do this, be aware of the importance of Title field

It gets the context menu by default
Hence, if you hide it then, basically all the Context menu functionality is removed
As a result, you need to put the Edit button in all of your views just to edit the item
You also need to place your custom code to re-associate context menu

If you still want to continue, then moving on to Renaming Title.

Go to the List settings
Click on the Title field
Save your changes

If you are looking for hiding your title field, then do the following :

Go to the List settings
Click the Advanced Settings link
Next, selecting the Yes option button for the management of content types on this list
Click on the Item link in the Content Types section
Now, click on the name Title link and change the Column Setting to Hidden.
Save your changes by clicking OK

This article gave simple configuration settings for hiding or renaming List Title field. Hope this helps