.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

Best of all worlds. External Lists vs. Managed Metadata vs. Choice Columns

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :C#

Hello All,

I have items I would like to store in Sharepoint lists and am having a hard time finding the best way to do this.

The criteria are:

1. Need a rapid way to enter information (such as is possible with datasheet view)

2. Need certain columns in the content type to be consistent.. Either from an External Lists (from our LOB system) or managed metadata.

Those two criteria seem to be at odds with each other. Using an external list would really be nice because I can keep certain field’s relational data intact, however I can't use datasheet view. Datasheet view is important because it allows copy and paste/tab through data entry when many rows must be entered.

View Complete Post

More Related Resource Links

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns become read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug?

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?

Update Managed Metadata Field with using Lists.asmx service

Hello! I am trying to update Managed Metadata Field with using Lists.asmx. I know that I must use this format WSSID;#VALUE|GUID. But I don't Know how I can get WSSID and VALUE Guid! Can I get them with using lists.asmx! Thanks!!

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns are read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug? Should I be able to edit them in 2010 and were they editable in 2007 version. Please help. thanks. I came across this other post which suggests that functionality is not available ? pls someone confirm. Mass-editing metadata when documents are uploaded (individually or in bulk) to MOSS 2010  

Add managed metadata column to list - access denied + terms not visible in lists


Firstly the following is not a problem for users given "Full Control" (and possibly other permission levels might work) at the web application level in central admin.

For any other user with permissions set at site collection level, even "site owners" (full control) , these problems arise.

  1. When adding managed metadata columns to a new document library list, clicking save results in multiple access denied errors getting logged (as seen using UlsViewer) and an exception is raised (sharepoint error page)
  2. In existing document library lists managed metadata column headings are displayed in list views but the terms text is not displayed.
This problem shows up even if the logged on user is the term set owner.  "Available for tagging" is enabled, submissions policy is closed.
Looking at http://<the-site-domain>/Lists/TaxonomyHiddenList/AllItems.aspx and then checking list permissions I can see that "All Authenticated Users" has Read permission level.
Integrated windows authentication - NTLM + Claims Based Authentication is the only authentication method used. It's an intranet site. 

Thanks in advance for any help.

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?

Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns


I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i c

Auto-Update Managed Metadata Term Store from External DB or List

Hi all,

I have been able to import terms using the .CSV file within the MMSA Term Store, but is there a way to auto-update the terms from an external list. Example: An external database already has terms and adds terms on a regular basis. Is there a method for updating the Term Store automatically when terms are added in the external source. Perhaps creating a SharePoint List populated with external data and somehow linking this up to the Managed Metadata terms? I know that System keywords are added to the term store when a user tags an item, but is there a way to tie into this functionality for managed metadata?

How to maximize use of managed metadata in the document library?

We are creating new Intranet portal based on SharePont 2010 and we have document library with 100-200 documents. Old Intranet is based on previous version of SharePoint. End-users did not like the usability of the document library as it was hierarchical. Users needed to know, which was the folders and its subfolder to find out where is the document. We are currently investigating if we can solve this problem by using managed metadata. We know how to define term set and how to give metadata to the document, but we don't know what is the most usable way to utilizem them in the document library. Let say that end-user would like to see all documents that has managed metadata "User Guide". How to configure document library so that users see only those documents. Not all our users are skilled and we have to provide very intuitive way to search relavant documents to them. Some predefined metadata dropdown would be great.Kenny_I

Setting Managed MetaData default values on site creation

I am working on a project where the requirement is to have specific document content types.  I have therefore create a site columns feature which creates all my columns, I have a Site Contentypes feature which creates all my content type and I have list templates based on my content types.  I also have created a couple of Site definition features which create specific list instance based on my list template As part of my content types I have created a few Managed Metadata fields which I wanted to set defaults for on the creation of my sites.  I have therefore created a feature which is right at the end of the WebFeatures section in my ONET.xml.  This features enumerates through all lists, looking for specific column names(managed metadata columns) and looks to set these to specific values.  The code to set the default value on the field is: TaxonomyField documentCategoryField = (TaxonomyField)library.Fields["Document Category"]; if (documentCategoryTerm != null) { documentCategoryField.DefaultValue = documentLibraryDefault.ToString(); documentCategoryField.Update();                                                     }                         &n

Provision DocumentLibrary with Managed Metadata column

Via the SharePoint 2010 UI I've created a DocumentLibrary and added a new column of type Managed Metadata. I've associated a TermSet with this column and all works fine. Now I need to create a deployment package in Visual Studio 2010. It is easy enough to create the Document Library. I've followed the below steps 1. Create empty SharePoint 2010 project 2. Added new Empty Element to the project. In the Elements.xml I have <Field ID="{15712E76-A603-43AB-885E-CE48BD216381}" Type="TaxonomyFieldTypeMulti" Name="DocTags" DisplayName="DocTags" ShowInDisplayForm="TRUE" ShowInEditForm="TRUE" ShowField="Term1033" Required="FALSE" StaticName="DocTagsInternal" Group="NotSure"/> 3. Added ContentType to the project. Added FieldRef elements to the Element.xml 4. Added List Definition From Content Type and associated it with the above Content Type. 5. Created a List Instance of the above List Definition. 6. Build and Deploy. 7. Associate the column with a Term Set. 8. Add Document to the Document Library. I can select a Term from the applicable TermSet, but when I save the document I get: Failed to get value of the "DocTags" column from the "Managed Metadata" field type control.  See details in log. Exception message: Invalid field name. {00000000-0000-0000-000

Need to link multiple External Content List items to a single document metadata column

I have an external content list - for my purposes, the data isn't any fancier than a list of terms provided by a web service (read only - I don't need update/delete functionality). I want to be able to link any subset of those terms to a single document metadata column (in other words, I need it to work like a normal content list that is defined to allow multiple values in a column) but SharePoint doesn't let me do that on an ECL. I need the content list to be externally driven since more values are going to be added to an outside system over time, but I think it's possible that I may not need a full-fledged ECL list to make this work this way in SharePoint. Just to clarify: I don't need the metadata values in my documents to maintain a PERSISTENT link to the web service (if someone changes an underlying value in the web service DB, it doesn't need to be updated in the document table too). I just want SharePoint to offer up an updated set of source values from the web service if somebody goes in and edits the document metadata. Any ideas for how I can make this work?

search on managed metadata column values

I am trying to search on a managed metadata column in a list.  I have the managed metadata as a mapped property (these are automatically set up actually). I have a column frequency (daily, weekly, monthly, yearly) I can enter a search box owstaxIdFrequency=#a132a333-39f1-4737-9ad4-a932482e025f   //this is the taxonomy guid for Daily.  This shows results. How do I search on the word "Daily" in the frequency column?  (I just want to figure it out on a simple search first meaning just using one search box)   I noticed that there are extra maped columns for managed metadata columns (owstaxIdFrequency also has owstaxIdFrequencyx0020Tag, I tried owstaxIdFrequencyx0020Tag="Daily", but it didn't work)

Moving Managed metadata

If i create a managed metadata taxonomy structure in my test environment how can i get this copied into my production system? TIA DeanDean MCTS-SQL 2005 Business Intelligence

External Lists and Infopath forms issue with Secondary Data Sources

I've followed this tutorial for creating and customising forms for external data (http://blogs.msdn.com/infopath/archive/2010/03/11/customize-an-external-list-form-in-infopath-2010.aspx).  The only difference being that my seconday data source is not an XML file (I've tried database connection and existing sharepoint lists both internal and external) When running the design checker I get the message "Additional Data connections not supported" and my form won't publish.  Any ideas?

Is it possible to implement your own version of the Managed Metadata Service?

Hi, It would be nice to provision a new instance of the Managed Metadata Service where the service is not implemented by Microsoft.SharePoint.Taxonomy.MetadataWebServiceApplication, but a custom provider. Is it possible to expose your own service as a Managed Metadata Service?

Multilanguage managed metadata filter

Hi, I wonder, how to create filter for view, using managed metadata in multiple languages. For example I have list with managed metadata column "color" with content "red", "yellow"... When I switch the language to german, it changes to "rot", "gelb" and so on for all other languages. Now I want to filter all list items with red color. But it doesn't work in other languages. So question is, how to set value of the managed metadata column? If it is "red", I switch to german language and it doesn't work. When I set "red" or "rot" it works, but it is nonsense set all filters for all languages and change it every time you add new language pack (we need 15 languages). Is there any possibility to filter items by key and not actuall value in actuall language? Thanks.  
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