.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

sharepoint,datatypes of columns

Posted By:      Posted Date: September 30, 2010    Points: 0   Category :SharePoint


I want to change the default title filed datatype from single line to multiple lines .

Please suggest is it possible ?

View Complete Post

More Related Resource Links

How to create scrolling table for columns in a SharePoint Designer Data View


I have a fairly complex SharePoint Designer 2007 Data View they have added two more requirements.

1. Have the columns on the right side be able to scroll left to right as there is a large number of columns, while the first 3 columns on the left side stay locked in place.  This is only one list not two, and because of some other requirements I have it must remain to be just one list.

2. Then they also need to have scrolling up and down of the entire list with the headers locked in place.

The first requirement is more important than the second, but preferrably I need to do both.

I am new to XSL so not familar with the syntax. Is this something I can do on a custom Data View? Does anyone have any examples of how?

I have a drawing that show how it needs to look but I don't see an option here to upload a graphic.

So here is a link to my graphic example uploaded to my blog area: http://lindachapman.blogspot.com/  or just the image here: http://4.bp.blogspot.com/_aB01ue__NvQ/TGL42MOvrGI/AAAAAAAAAA4/c3xP4uCy4BU/s1600/Scrolling.png

I failed to mention that 3/4 of the columns are HTML Calculated fields wh

Creating List Definitions with Custom List Columns for SharePoint Server 2007

Learn to use Visual Studio 2008 Extensions for Windows SharePoint Services to create a SharePoint list definition that implements custom list columns.

Show wiki page library columns on wiki pages- SharePoint 2010

I created a wiki page library in SharePoint 2010 and added a few columns to the library. However, these columns do not show on the actual wiki pages as they did in SharePoint 2007. I looked through the library settings but didn't find anything to turn on this feature. Does anyone know how to do this or if this feature was even included in SharePoint 2010? Thanks.

Managed Metadata columns in Sharepoint Workspaces

Hello,   all our document lists use Managed Metadata columns. They are required also.    Sharepoint Workspaces list current values for these columns, but do not allow changing them. Thus effectively making Sharepoint Workspace unusuable, because we can't check-in new documents.   Am I missing something?

Query Sharepoint list, rich text columns returning HTML tags

Hi! So I have an issue that maybe someone of you have encountered as well. I am querying a Sharepoint list and creating a report from the data collected from this list. This all works fine except that one of the columns in this list is of the type "Multiple lines of text" and also supports "rich text" with different fonts, sizes and so on. This has the effect that the text returned from this column is wrapped in HTML tags that specifies how the text should be formatted. Naturally I do not want this HTML code to appear in my report so for now I have used custom code to do a string.replace and replaced for example <div></div> and <br> with "". However, this column also has url references to documents and these links shows up like this "/servername/site/subsite/Gemensamma%20dokument/Mwh.docx">http://servername/site/subsite/Gemensamma%20dokument/Mwh.docx There is some sort of double reference to the document that I guess like the HTML tags are embedded in the answer from the rich text column and this is not so easy to do a string replace on because the url varies with the different document and document names. My question really is if anyone of you have done a similar report that I am doing, and have encountered this fenomen with this sharepoint column and how you did to solve this? I have tried to creat

Sharepoint export to spreadsheet gives two extra columns in excel 2007 named as type and path, is th

When i export a list in excel 2007, it creates two extra columns named as type and path. At the same time this behaviour is not exhibited in office 2000. Is there any way to remove these two columns without using code ? Is there any configuration settings required for this, to remove it on the fly ? Thanks Ravish Verma

Lookup columns in a SharePoint Custom list

Hi, I would like to know the maximum lookup columns we can create in a SharePoint Custom list. Thanks and regards, Usha   

InfoPath 2007 - Publishing Creates multiple columns on SharePoint Form Library (GUIDS apparently are

I have been working this issue for 2 days now.  This has happened to me in the past and I was able to work through it.  It doesn't appear that this time I am going to be so lucky. Issue Description: When publishing an InfoPath form a new column is created that has the same name as the correct one, but a new GUID is created. Troubleshooting steps: I have read this article: http://www.delphi-ts.com/blogs/lozzi/post/2009/06/03/Duplicate-site-columns-in-MOSS-from-InfoPath-Forms.aspx   This was the solution the last time I had this problem.  However, no matter what I do, it is not working now.  I have a column named User Name which is the username of the person that submitted the InfoPath form for use with my Visual Studio workflow.  When the workflow kicks off, it reads this column and attempts to get the value.  The value is blank because a new column with the name User Name now exists and that is where the value is stored.  I attempted to fix it by remapping the GUIDs as described in the article.  I also reverted the code to a previous version from TFS.  None of these worked.   I now have 3 columns called User Name and I can remap the GUID to the second column and third column.  But when I try to map it to the first column (the one I need) it doesn't work. The first column that is circled is the correct column. 

Traversing Lookup Columns in a SharePoint View

I have a list with a lookup columns that references another list. This list, in turn, has a lookup column that references a third list. This represents a Child->Parent->Grandparent relationship.  I have a view of the child list and I want to filter the items based on a column in the grandparent list.  I know I can do this in code using LINQ to SharePoint, but is there a no-code solution? The Content Query web part infers that it can do this but I didn't see a way to implement this. Does anyone know of a way to accomplish this in SharePoint Designer or the SharePoint UI?

SharePoint ItemUpdating EventReceiver and Office 2007 documents -- columns not updated



We've created an ItemUpdating EventReceiver that sets various properties (columns in the library) on the document based on user selections in a couple other properties.  This code works fine and for all file formats in a Windows 2003 Server/MOSS 2007 environment.

In a Windows 2008/MOSS 2007 environment, however, when we upload MS Office 2007 documents (e.g. docx, xlsx, pptx) these updates are not made.  What's interesting is that the code does actually execute (we've compared logging statements for non-MS Office 2007 files to MS Office 2007 files, and all settings being equal, the code executes exactly the same way on both files, but when the library list view is refreshed, the pre-MS Office 2007 document HAS the values, but the MS Office 2007 documents do not!.

Anyone have any idea why this code is not able to "commit" the values to the documents?  Again, the code works fine (per our logging output), it's just that the values do "not take".....Is there something in the Windows 2008/MOSS 2007/Office 2007 "integration" that might be interferring or that would prevent values form being updated?

Why is Sharepoint 2010 standard search no searching within Document library columns



Environment : SharePoint 2010 Enterprise version, using regular search and NOT Fast Search

Standard search is configured and running succesfully and returns results by searching in documents and columns of lists\ calendars and everything else except for Document librarie's columns may it be text or lookup datatype, any clue?



SharePoint 2010 Load Testing Kit - a csv file contain at least three columns


I'm following this page.
Load Testing Kit (SharePoint Foundation 2010)


I've created a csv file in the format:

I run this command
C:\Program Files\Microsoft\SharePoint 2010 Administration Toolkit\Load Testing K
it>ltk.exe -source C:\inetpub\logs\LogFiles -output visualstudiosolution -userli
st c:\temp\users.csv

And received this message

[10/1/2010 3:04:50 PM] [Error] :
Exception Type [System.InvalidOperationException]: Message[The user list should
be a csv file contain at least three columns, which are username, password and p
stack trace:    at Microsoft.Office.Server.AdministrationToolkit.LoadTestingKit.
   at Microsoft.Office.Server.AdministrationToolkit.LoadTestingKit.Engine.Framew
orkEngine..ctor(CommandLineArguments arguments)
   at Microsoft.Office.Server.AdministrationToolkit.LoadTestingKit.Common.Comman
dLineUtility.HandleCommandLine(String[] args)
   at Microsoft.Office.Server.AdministrationToolkit.LoadTestingKit.Program.Main(
String[] args)\n

Here's a snippet from loadtestkingkit.log


Auto Populating SharePoint List Columns based on value in one column

   I have a SharePoint List where I want to auto populate the value of some of the columns from another List based on a field "Title" which is primary & unique....
   I want to auto populate them when clicking "New Item"  and entering data... you put the "Title" value and it should match the Title value from another List and auto-populate some the columns...

   Please any idea would be highly appreciated....

Thanks in advance

SharePoint 2010 Date Columns are not Indexing (or searchable)


I have a 2010 Record Center.  Indexing and search functions seem to be working.  However, searching dates does not produce results.  The date column is marked for indexing.  Crawling is working and I do get other text type results.  I have tried switching the column to Date & Time in the detailed column settings.  With or withouth the time, it does not come up in the results. 

There is an interesting twist.  On SOME, the search returns the AllItems.aspx PAGE (not the document or list item itself) that it resides on with the searched date highlighted in the result item description.

North to the Future

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Easy way to migrate site columns and content types from moss 2007 to sharepoint 2010?

Choice columns in SharePoint List



I have created a simple list with a "Choice" column, i have three entries in my dropdown

First Entry

Second Entry

Third Entry.

When user creates a new item, default value in the drop down  is blank, i want user must select a value, so i have selected "Required value" option for tihs column, no if user try to save with blank value in the dropdown, a requried field error is displayed.

Is it possible if i add "Please select a value" in the drop down as first value.

Using Infopath 2010 to customize a SharePoint 2010 list with columns using Managed Metadata


Hello All-

I would like to customize the "new" form on a SharePoint list that has some columns that use managed metadata term sets as options.  Unfortunately, when I do so, I get the message:

"InfoPath cannot generate a form template for the SharePoint list."

The following fields in the SHarePoint list are not supported because of their data type and will not be available in InfoPath Designer:

-MyColumnName (TaxonomyFieldTypeMulti)

This error message seems to be pretty self explanatory, but it boggles my mind that this would be the case.  Can I really not customize my list "new" form in Infopath if I am using columns with managed metadata?  Any workarounds?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend