.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
Fauzul Azmi
Asad Ali
Post New Web Links

Create Lookup Site Column based on External List (SharePoint 2010)

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

I've got an External List and I want to create a Site Column, which is Lookup to a column in my external list. If I tick any of the columns in 'Add a column to show each of these additional fields' and click OK i get the following error message:

[NullReferenceException: Object reference not set to an instance of an object.]
  Microsoft.SharePoint.SPBusinessDataField.IsInDefaultView() +58
  Microsoft.SharePoint.SPBusinessDataField.CreateSpFieldForBdcType(String bdcName, Boolean hidden, Boolean readOnly, Boolean idField, SPAddFieldOptions op) +809
  Microsoft.SharePoint.SPBusinessDataField.AddNeededSecondaryFields(String wssNames, String[] oldNames, String[] newNames, SPAddFieldOptions op) +315
  Microsoft.SharePoint.SPBusinessDataField.OnAdded(SPAddFieldOptions op) +240
  Microsoft.SharePoint.SPFieldCollection.AddFieldAsXmlInternal(String schemaXml, Boolean addToDefaultView, SPAddFieldOptions op, Boolean isMigration, Boolean fResetCTCol) +759
  Microsoft.SharePoint.SPFieldCollection.Add(SPField field) +61
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.Save() +513
  Microsoft.SharePoint.ApplicationPages.FieldNewPage.BtnOk_Click(Object sender, EventArgs e) +46
  System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
  System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +139
  Syste


View Complete Post


More Related Resource Links

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

How can create site in sharepoint foundation 2010 based on WSS 3.0 template(.stp file)

  
Hi,   I  want  to migrate wss3.0  site into sharepoint foundation 2010 site . earlier we  were creating site based on .stp file  in WSS 4.0 . but now we  have   to build same site in sharepoint foundation 2010. I followed  the old way  intall the .stp file  and  based on that trying to create new  site  but getting some error  old version template is not supporetd my this version. how could  l able to create  site  in sharepoint foundation 2010 based on wss 3.0 template . Please help Thanks in advance Jandel Singh

Sharepoint 2010 Create Lookup List

  

New to Sharepoint 2010, and have little to no experience with Sharepoint 2007.

What I currently have is a page called "Customer List" that has a list of clients all entered with the wiki-type formatting. [[client name]]

This is what I'm after: Create a Customer List in a manner that it will create a link for a Customer Page/Site that can be edited with all their pertinent information. Being able to use the Customer List as a lookup source for the Issue Tracking module we're setting up.

Not necessarily married to using the wiki formatting. It's something that is currently in place. Ideally, we'd like to be able to go tot he Customer List, add a new entry, and it could automatically create a new Customer Profile Page based on a template we design. Then, once that customer is created, it automatically will add their name to the list that the Issue Tracking uses for the Customer lookup.

 


cross-site list lookup using sharepoint 2010

  

Hi All,

Just want to ask how can I cross-site list lookup using sharepoint 2010.

 I’ve created two Sites. TestSite1 that has a list called List1 and TestSite2 that has a list called List2. The problem is when I tried to create a lookup column in List2 so I could see the List column in TestSite1 I could not find it.

How can I do this using the OOTB SharePoint 2010?

 

Thank you in advance.

Quick Note: Create Custom List Definitions in SharePoint 2010

  
In this exercise, you create a custom list definition in Microsoft SharePoint 2010 and then create an event receiver that is triggered when the list is used.

Problem with Retrieving data from lookup column using SharePoint 2010 Linq Concept

  
Hi I am working with sharepoint linq concept. When I am giving a query with lookup column It's working fine.  But when i am trying to retrieve the data from a look up column to spgridview. I was unable to get the output. Here is the above code which i have worked.   string strTitle = string.Empty; string strStatus=string.Empty; var context = new LinqSampleDataContext(SPContext.Current.Web.Url); EntityList<SharePoint2010ConceptsItem> Concept = context.GetList<SharePoint2010ConceptsItem>("SharePoint 2010 Concepts"); var query = from cs in Concept where cs.Status.Title.ToString()!="Completed" select new { cs.Title, cs.Id, //cs.Status }; sgvConcepts.DataSource =query; sgvConcepts.DataBind();   Any help me plz how to retrieve the data from a lockup column.bvnprasad

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

Cannot access parent site list from subsite in XSLt List View webpart in sharepoint designer 2010

  
Hi    We are using sharepoint 2010  for internet facing sites for our big client in healthcare domain .  I am using XSLT list view webpart in sharepoint designer 2010 for retrieving contents from sharepoint list & displaying it by using XSLT List view webpart in publishing sites. We are having lot of list in rootsite collection, If i am creating pages by using XSLt list view webpart in root site collection I can access the list,View and Display in Pages by XSLT List view webpart. Now the requirement is i have to access the list in roosite collection(parent site) from subsites.  In Sharepoint designer 2010, while i am inserting XSLT list view webpart, i could not find datasource to access the list that exist in rootsite collection(Parent site) from subsite. Below is the the code i am using for accessing the list& view from parent site & creating the pages in parent site by using xslt list view webpart,now i wants to access parent site list from subsite by using XSLT list view webpat in subsite pages.  Pls let me know what i have to change in the code level <WebPartPages:XsltListViewWebPart runat="server" Description="The list for the conditions details" ListDisplayName="" PartOrder="2" Default="FALSE" HelpLink="" AllowRemove="True" IsVisible="True" All

Create a Site template with subsites in Sharepoint Server 2010

  
Hi, I'm with my first SharePoint project, and we are using server 2010 as a Document Management system. The thing is our company has about 300 customers, and we have to create 300 site collections, 1 per customer.  For each site collection, I use the blank site template, and it's very simple page, as I just need a document library in the home page, and then I need to create a subsite called "cases" and the inside profiles, the users create a document library for each case. For subsite I mean, I create a new site and I choose the option to share the top menu, so basically the site has 2 tabs. So basically what I need is a template that has 2 tabs, Home and Cases. Home with a document library in home and Cases empty. Is there a simple way to achieve this? I guess maybe I have to edit some XML files to create a Site Template. If this is the case, can someone point me to the right documentation. Second, I need to create a Visual Basic project so that the final user has a form, and he just inputs the Customer Name and the code must automatically create a new site with the template I metioned before. I guess that once I have the template this won't be very hard to achieve, as I have seen this SPSite class. The question is, can I have the template with the 2 tabs, o maybe I have to use 2 templates, and write code to create the home site and the Cases Subsite.. Ple

Create site template and adding subsite using site template is broken in sharepoint 2010

  
I am trying to create a site template base on an existing site and try to use the new site template to generate other sub-sites.  It sounds simple and the code is not that difficult to follow; however, Microsoft has made it impossible to accomplish by having a bug in their template creation process.   //Generate web template from existing website using (SPSite site = new SPSite("http://localhost")) { SPWeb web = site.OpenWeb("/barrington/accounting"); web.SaveAsTemplate("NewDepartmentTemplate", "NewDepartmentTemplate", "NewDepartmentTemplate", true); }   //Generate sub site using the new template using (SPSite site = new SPSite("http://localhost")) { SPWeb web = site.OpenWeb("/barrington/accounting"); SPWebTemplate tp = null; foreach (SPWebTemplate wt in web.GetAvailableWebTemplates((uint)1033)) { if (wt.Title == "NewDepartmentTemplate") { tp = wt; break; } } if (tp != null) { SPWeb newWeb = web.Webs.Add("NewDepartment", "NewDepartment", "NewDepartment", (uint)1033, tp, false, false); } } Error: Microsoft.SharePoint.SPException was unhandled   Message=The content type name '$Resources:_FeatureId367b94a9-4a15-42ba-b4a2-32420363e018,DataSourceContentTypeName;' cannot contain: \  / : * ? " # % < > { } | ~ & , two consecutive per

Excel External Table Data can only create new SharePoint List when Exporting from Excel?

  
I have a SQL Query that I refresh everyday in Excel. I want to be able to export this list over to a SharePoint list right after my refresh in Excel but I can only Export to a SharePoint list only once. If I try to export again to the same list then it will give me the error "The specified list name is already in use on this server. You must rename the list before publishing it to the server." I have web parts that have connections to this list and I do not want to export my Query to a new SharePoint list everyday. Does anyone know a way around this issue?

SharePoint 2010 Claims Based Authentication - anonymous site is prompting for CBA auth when opening

  
Hi, I have CBA setup successfully on my sites.  One site is setup for anonymous access and I have disabled "client integration" on that web application. I have a list of MS Office documents on a wiki.  When I click on one I am asked to either save or open or cancel.  Saving works fine but when I choose open, it launches the associated MS Office app.  I am then prompted for a login from CBA.  I can click cancel and the logon screen appears again.  After clicking cancel the 2nd time the document appears in the MS Office app, Word in this case. My question is how do I prevent my users from being prompted for a CBA login when clicking on these files and opening them in the native app on their machine?      --TR

SharePoint 2010 Claims Based Authenticaton site working but search is broken

  
Hi, I have SP 2010 sucessfully installed on a Windows 2008 R2 server with SQL Server 2008 R2.  I created local machine accounts for the following: MACHINE\mssqlservice MACHINE\sp_admin MACHINE\sp_search MACHINE\sp_farms I have setup 2 sites with public facing internet access as well as local sites. I have CBA working properly on both sites from both public and private access. My problem is that when I go to search, I am constantly redirected to an error page. I have checked all SP services on the server and they are all running as MACHINE\mssqlservice That account has proper access to all sites as well as all DB's. My search is crawling and I get one error from a long named PDF file in my site, which is OK.   My questions is if my CBA is working fine and my search is crawling, why I am not getting a results page when I search from the sites:   Here is the error I get:   Error Internal server error exception:   Troubleshoot issues with Microsoft SharePoint Foundation. Correlation ID: 5a03b730-42c2-48c9-a220-3b9d052481de Date and Time: 9/9/2010 4:45:07 PM   I am kind of stuck at this point and am not sure how to proceed.  Any help would be appreciated.        --TR

Access list from other site-sharepoint 2010

  
i am building a SharePoint site with many sub sites , in a publishing sub site i need to display a data view of a list that exists in other site how do i do it through Share-point designer 2010 or is there way using Visual Studio 2010 .Please provide me the best solution.  Thanks in advance.

How to create global list in SharePoint 2010

  

Hello All,

I want to create global list which can be acessible to all the sub-sites in the SharePoint

Structure

RootSite

----- Site 1

------------Site 1.1

------ Site 2

-------------Site 2.1

And so on,

I want to create list in which I can insert an item from any of the site from my site collection.


Creating a Site Column that Looks up an External List causes error when saving site as a template.

  

I'm not sure what the best practice is here, but I'm having a major issue trying to save sites as templates and I think I narrowed it down as to what the issue is.

When I try to save a site as a template, it creates the solution package, but it doesn't activate it.  When I try to activate it manually, I get the following error:

Feature definition with Id e9431ed5-27b1-4c33-9eeb-81b4ace9d372 failed validation, file 'test1ListInstances\ElementsFields.xml', line 481, character 231: The 'SystemInstance' attribute is not allowed.

I opened up the solution package and looked at the ElementsFields.xml file.  I traced the line to this:

<Field Type="BusinessData" DisplayName="Acme People Name" Required="FALSE" EnforceUniqueValues="FALSE" Group="Custom Columns" ID="{55b3bbba-a7e3-4698-9946-648a6b726e9e}" SourceID="{026904fd-f2d0-4e57-a239-c6da838458fa}" StaticName="Acme_x0020_People_x0020_Name" Name="Acme_x0020_People_x0020_Name" SystemInstance="ACME" EntityNamespace="http://????????:28241" EntityName="People" BdcField="FullName" Profile="" HasActions="True" SecondaryFieldBdcNames="0" RelatedF

SharePoint 2010 Approval workflow based on list criteria

  

Hello All

I have been requested to create an Approval workflow for a list with 3 columns - Title, Category and Price. The Category field has 3 options - Minor, Moderate and Major.

If the Category is Minor the approval is sent to the Project Manager, and after approval it is sent to the Manager for approval.

How can I accomplish this using SharePoint Designer 2010? Can I modify the OOTB approval workflow, if yes how?

What other options do I have? This is really urgent.

Thank you for any responses.

Cheers

Yoshi

 


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