.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

How to setup metadata relationship in sharepoint 2010

Posted By:      Posted Date: October 12, 2010    Points: 0   Category :SharePoint

Hi experts,

We have a requirement where there are 3 different properties

lets say

country - which has dropdown list with (US,Canada,UK) value

City - which has dropdown list with(detriot,Newyork,Toronto,London)

ZipCode - which has dropdown list with(12345,34fn8,23456)

Now we would like to setup a relationship such that when the user select country = US they should see only option of detroit and newyork as city and once the appropriate city is selected they should see the related zipcode

How can we achieve this?


View Complete Post

More Related Resource Links

A Brief Introduction to Enterprise Metadata Management for SharePoint Server 2010 Developers

Learn about some basic developer tasks that you can use as basic building blocks for more powerful and complex metadata solutions.

Video: SharePoint 2010: ECM and Enterprise Metadata

SharePoint 2010 now supports metadata everywhere, and this video shows you how to use this new capability to tag all of your SharePoint content and data. (Length: 20:38)

Is it possible to define metadata at Office 2007/2010 when saving to the SharePoint 2010 library

I have succesfully saved Excel 2007 document  to the document library. I wonder if it is possible to define meta data with client? Otherwiser end-user need to anyway open the SharPoint library and add metadata information there.  Example metadata is like "category".   Kenny_I

Publish Office 2007 documents with metadata to SharePoint 2010?

Hi. I have SharePoint 2010 Enterprise based Intranet solution. We are publishing office 2007 documents to various document libraries there. When uploading documents normally to the document library, I can enter managed metadata to the documents which are later sorted and filtered by this metadata. But how can I enter metadata at the point where I'm publishing the document(Publish->Document Management Server)? I can get the document management pane to show my metadata -column in word as a textbox after the document is published, but the textbox is colored grey and says that I should modify that data on the server i.e. from sharepoint.

Sharepoint 2010 - The Managed Metadata Service or Connection is currently not available. The Applica

So I've already installed hot fix http://support.microsoft.com/kb/976394.  Rebooted server and I still get this message.  The account being used is part of local adminstrators group and has full connection permissions for managed metadata service.  Is there anything else I'm missing or needs to be done?

SharePoint Designer 2010: Business data connectivity metadata store is unavailable

Running SharePoint Server 2010 RTM. Fresh install in production not via the wizard but a vanilla install and bringing services up one by one. Just brought up the Business Data Connectivity Service. Other services currently up are Managed Metadata Service and User Profile Service. Two web applications with services deployed to both web applications. The scenario below holds true when connecting to a site on either web application. 1) Open a site, i.e., root portal site, in SharePoint Designer 2010 2) Click External Content Types. Error returned: "The Business Data Connectivity Metadata Store is currently unavailable" is returned. 3) Click Ok then click New | External Content Type. Error returned "THe server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults...". The Business Data Connectivity Service status in Central Administration is Started. Any ideas?

Sharepoint 2010, Constant prompt for credentials to edit office documents in a fqdn setup


Is there a solution to resolve the constant "Prompts" For user id's and passwords when a person tries to open/launch/edit office documents from sharepoint 2010.

My setup: sharepoint fqdn in the domain sp.domainname.local, The sharepoint server is a member of this internal domain. In dns I have local zone of sp.domainname.com with a cname that points to the internal sharepoint server. There is no issue in users accessing the server both internal and external, The issue arises when Office documents are launched from SP2010.

In central admin I have configured the alternate access mappings to be http://sp

I have also tried putting the fqdn dns name of the sharepoint server in IE8 trusted zone but
no luck, I still get credential prompts.

I think the issue might be that Office does not see that the files are coming from the fqdn of sp.domainname.com so hence the prompts.

Trying to fix this as right now its a total pita. I found some previous posts on this issue with SP2007 but found nothing that really addresses this in SP2010.

Thanks Paul

Import Word docs with Metadata into SharePoint 2010 from Windows Server 2003


I need to import 700 Word docs (2003 & 2007) from Windows Server 2003 into a SharePoint Server 2010 library.  I only have a test server to work with right now and want to do as much pre-work before we launch the actual server. 

My goal: When we launch the shpt server, import all docs into a library so that columns propagate with metatdata automatically.

I'm not sure what the best approach is...

Can I can open each doc and add custom properties (maybe with InfoPath) to import as metadata, then import managed metadata through the term store tool and have it associate with the manually entered custom properties? I don't fully understand managed metadata, which might pose a problem.  And before I start importing terms, I thought I should find out if I've completely misunderstood how taxonomies work.

Or I have an excel spreadsheet with info about each doc in columns that can act as metadata. I could upload this as a list then associate each doc with the list.  But it seems wiser to enter the metadata into the documets.  

Is it possible to update my docs in advance so that uploading goes smoothly? I have help now for data entry that I won't have later.

I have no resources to spend on tools, and have to figure out and build this&nbs

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office comp

I am encountering this error during setup. The server previously had WSS 3.0 and the Group Board Workspace. I uninstalled those and installed sharepoint foundation 2010. Initially It was up and running but I was receiving errors trying to load the group space template, so I uninstalled SPF2010. cleaned up the registry pointers to the old WSS3.0 and Groupboard Workspace and tried to reinstall. Now I get the error

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office components failed to complete successfully.

Looking into the issue it appears that setup cannot install the embedded sql server, since the logs indicate a dbwrap error. There are no "pendingfilerename" operations which fixed this problem for some. I tried to install as a farm but it won't allow me to use a local admin account.  I also looked at the sql configurations and the windows internal database is running.

Any ideas how to I can remove the windows internal database and reinstall SF2010?

setup error sharepoint 2010 Windows 7 product ID


Windows 7 Pro trying to install 2010 in standalone. I started with an ISO image, burnt it to a cd and copied all of the files here c:\SharePointFiles . manually Installing the prerequisites.

When I run setup.exe I get the error: The Product ID spcified was not found on your machine

My config.xml file has this line added: <Setting Id="AllowWindowsClientInstall" Value="True"/>

I also put in the Product key in the config.xml. I cant seem to find much help online with this error. I tried to copy the config.xml to the same directory as the setup.exe and that did not help either.

Anyone have any ideas what direction I should take? I have pretty much read this thread to death: http://msdn.microsoft.com/en-us/library/ee554869(office.14).aspx and that has not seemed to shed any light on the matter. Anyone? I'm several hours into Googling and still running into the same issue no matter what I do.

Appreciate any help - Thanks!!

how to confugure sharepoint 2010 standard search to search Metadata as well.




sharepOint 2010 Standard search ( not using FAST)

my search results are returning results only from documents but does not search within the metadata, strangly i dont see an way to do this.

any suggestions is highly appreciated.



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

SharePoint 2010 Search Service - does not escape forbidden signs in Managed Metadata fields



I´m using SharePoint 2010s Search Service to get items from a list. In the list I have managed metadata field for Item. When I search on Item "Item 1 & 2" I get xml that is incorrect. SharePoint does not escape the &. (The mapping is correct so when I search on an item not containg & it returns correct xml.)

But if I in my description field writes "A description & some more text" then & is escaped.

Anyone seen this before? Is there some way to configure the search service to escape forbidden signs to return none broken xml?


Sharepoint 2010 Missing Managed Metadata Service


According to the following MS article, the Tags feature is linked to the Managed Metadata Service, which is required to use Tags. For some reason I cannot find this feature as described in the article where it specified Managed Metadata Service is located in the Application Management section. What should I check to make sure this feature/service can be enabled?



Any guide to setup Exchange 2010 with Sharepoint 2010?

Any guide to setup Exchange 2010 with Sharepoint 2010?

Should I use Virtualisation to setup development envrironment for Sharepoint 2010 or directly set it


Hi All,

I have a new laptop with following specs:

- 64 bit , Quad processor, 8GB memory, Windows 7 Home premium.

Please guide me weather to use virtualisation technology to setup sharepoint 2010 development envrionment or should I directly install it on the laptop without creating virtual machine using Virtual Box.

I am learning Sharepoint 2010 and so need to setup development environment along with SSRS 2008 server R2 for reporting. Please tell me the best option to go with






How to setup Sharepoint 2010 development environment on windows home premium 7 using Virtual Box for



PC Specs:

- 64-bit, quad processor, 8GB RAM, Windows 7 Home Premium laptop.

I need to :

- setup Sharepoint 2010 development environment using Virtual Box.

- Setup SSRS 2008 R2 for reporting services.

I I have gone through several blogs and post but am not able to understand a clear sequence of what am I supposed to do. Please Please help me setup my machine in a way I can use it for my personal use and also use it for Sharepoint development.

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