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


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Asad Ali
Fauzul Azmi
Post New Web Links

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

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :SharePoint
 
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?
 


View Complete Post


More Related Resource Links

list of employees - custom list or managed metadata term set ?

  
Hi all, I am working on a intranet site for a small company with 25 employees. They want to create a site for tracking employee training. Most of the items on this site are going to be associated with an employee entity. What is the best way to manage the employee entity ? should I create a custom list called employee or should I create a term set called employee containing the names of all 25 employees ? In a related question is it possible to add a "people picker" field to a custom list ? ( e.g. Training schedule list ) I note that for 'assign to' columns SharePoint provides a dialog which enables you to browse and select users from active directory. Is there a way to add similar lookup functionality to a custom list in SharePoint ? thanks and regards, Counie  

Managed Metadata Term Set Update

  
Is there a way to update a term set by importing over the current terms?

How to add custom properties to terms in the SharePoint 2010 managed metadata term store?

  

There is a "Term.CustomProperties" collection to get the collection of custom property objects for the current Term object from the read-only dictionary.
But where and how to define and set custom properies for terms? This dictionary seems to be read-only by default.

Any help / documentation would be appreciated. / Frank


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?

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?

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  

"BDC Metadata Store is Currently Unavailable" when navigating to the External Content Types object i

  
After installing SharePoint 2010 Beta and Sharepoint Designer 2010, opening Designer and navigating to the External Content Types object results in the following error:"The Business Data Connectivity Metadata Store is currently unavailable."Anyone else having this experience?ThanksMark

Deploying taxonomy term store and managed meta column from development machine to production machine

  
Hi, In my development environment, I created a taxonomy term store by importing a CSV file. I also created a site column of type "managed meta data" based on that term store. Now, I want to migrate to production environment. What is the best way to do this? When I generate the schema of my site column, it looks like this: <Field Type="TaxonomyFieldTypeMulti"    DisplayName="Article Type"    List="{d8b20e4f-ce12-4def-b59d-d44da2c13234}"    WebId="eef74e7c-a852-4c89-b811-e31b86853641"    ShowField="Path1033"    Required="FALSE"    EnforceUniqueValues="FALSE"    Group="Custom Columns"    ID="{47f78411-65fa-43c9-8cb8-68955aea1256}"    SourceID="{eef74e7c-a852-4c89-b811-e31b86853641}"    StaticName="Article_x0020_Type"    Name="Article_x0020_Type"    Version="4"    Mult="TRUE"    Sortable="FALSE"> <Default></Default> <Customization> <ArrayOfProperty> <Property> <Name>SspId</Name> <Value xmlns:q1="http://www.w3.org/2001/XMLSchema" p4:type="q1:string" xmlns:p4="http://www.w3.org/2001/XMLSchema-instance">99d

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.


No update method in external list

  

I've successfully created an external content type and external list with read list, read item and delete methods with SharePoint Designer.

But the edit/update and the new item method is not automatically created. I can see those two missing methods in the SharePoint Designer but not on the aspx page in SharePoint. What I'm doing wrong?


Cannot copy the value of a managed metadata column from one list to another

  

I have a problem when trying to copy a value of a managed metadata column from one list to another by a Sharepoint Designer (SPD) Workflow

I have two lists. "Locations" and "Employees". "Locations" has a Content Type integrated that has a Site Column of the type managed metadata named "Geographic Location". This Managed Metadata column describes the geographic location from continent down to the city name. I also have a Content Type for the "Employee" list. This one contains a lookup column "Location Abbreviation" on the title column of the "Locations" list and the same managed metadata column "Geographic Location". Now my Workflow is created to work with the Content Type "Employee" and goes like this:

Set current item:Geographic Location to Locations:Geographic Location (where Current Item:Location Abbreviation equals Locations:Location Abbreviation (Lookup Value (As Text)))

But the workflow always reports "Error occured". The message is:

"The workflow could not update the item, possibly because one or more columns for the item require a different type of information."

But is is very unlikely that this message is useful as both columns use the same Site Column. Do you have any Ideas?


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?


How to add/append metadata stored within the Sharepoint Term Store to a crawled item

  

Hi All,

I need someone to explain to me how to add/append metadata stored within the Sharepoint Term Store to a crawled item (i.e., can it only be done via External Content Type?). Bascially i need to know if there is any Out of the box solution for this?

 

Much appreciated.

 

Regards,

Hanif.


Hanif

How can I make my Visual Studio Workflow update my External List that I created in SPD

  

I am creating a workflow VS2010 that can write to regular SP Lists however, when I try to have it write to my External List it does not work?

Thanks


Leland Usher SharePoint Developer/Administrator

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?


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

  

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.

Categories: 
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