edit business data column in datasheet view

SharePoint - Business Data Catalog

- Previous
  - 1
    - steps for creation of Workflow in visual studio Can any one tell me steps to create workflows in visual studio or any link thanks in advance. Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 2
    - ViewProfile (Action) not showing in BDC Data List Hello Guys, I've created BDC data list and BDC Related Data List to acheive Master/Detail scenario. I've used to create MSN search action in XML definition file using BDC Meta Man. But I'm not able to view 'ViewProfile' or "MSN Search' actions is BDC Data List, but i can able to view BDC related Data List. I'd appreciate if you folks can help me to solve this issue. Thanks, Johnson Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 3
    - Does SharePoint support URL transformation? I have an extranet SharePoint site with a web part which contains links to content on a back-end server, which is not accessible outside the firewall. I know that other portal servers (Plumtree in particular) are able to transform the URL's from the back-end server, so that subsequent requests to retrieve the content on the back-end server are gatewayed through the portal server. Thus the existence of the back-end server is hidden from the user. Does anyone know if SharePoint supports a similar or equivalent functionality Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 4
    - Create Site Column Definition for Business Data Type I am trying to create a site column definition for a column to contain business data, and I want to include this column in a site content type so that it may be re-used throughout the site. For nearly all of the lists and document libraries in this site, there is a consistent need to reference data contained in an external application database. I have successfully created the Application Definition file and I am able to query the SQL Server database using the BDC object model. In fact, I am doing this through several custom application pages. I have defined the custom site columns and the custom site content type and have deployed them "successfully" to the site through a Feature. When I visit the site columns listing from Site Settings, I see the Business Data column in the list - furthermore, when I click on the column in the site columns list and view the details of the column it appears to be set up correctly inside of MOSS. It shows the appropriate Entity and Instance when I view it, and also shows the appropriate Display field and secondary fields as defined. There are a couple of interesting behaviors, though, when I actually try to work with this column or content type in the site. The first odd behavior is that when I attempt to add an item to a list that has the associated content type, there is an error when the page attempts to render the appropriate BDC Field control and the BDC Control is disabled: "An error occurred while retrieving data from a system. Administrators, see the server log for more information." Checking the Logs leads me to this entry: 09/05/2007 15:34:57.03 w3wp.exe (0x0BF0) 0x0FD0 SharePoint Portal Server Business Data 8u7q Exception System.ArgumentOutOfRangeException: Parameter name: name at Microsoft.Office.Server.ApplicationRegistry.MetadataModel.ApplicationRegistry.GetLobSystemInstanceByName(String name) at Microsoft.SharePoint.Portal.WebControls.BusinessDataFieldControl.SetExtendedDataOnPicker(ItemPicker picker) at Microsoft.SharePoint.Portal.WebControls.BusinessDataFieldControl.CreateChildControls() What I gather from this (correctly or incorrectly) is that the application instance is not being passed into this control correctly. Another interesting behavior is when I try to modify the column definition within the MOSS user interface, and I click the "OK" button to save, I get the following error: Value cannot be null. Parameter name: value at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase) at Microsoft.SharePoint.Portal.WebControls.BusinessDataField.OnUpdated() at Microsoft.SharePoint.SPField.UpdateCore(Boolean bToggleSealed) at Microsoft.SharePoint.SPField.Update() at Microsoft.SharePoint.ApplicationPages.FieldEditPage.BtnOk_Click(Object sender, EventArgs e) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) I am not sure what is causing this. The last odd behavior that I encounter is when I reverse the order of the two previous behaviors and attempt to modify the Business Data Column first - I still get the error, but then when I attempt to add an item to a list, the BDCField control appears to work correctly. I still can't seem to modify the field once it has been created, though. Does anyone have any ideas regarding this behavior If so, could you please assist me I am including the definition of the columns and content types below. Please review and let me know if there is anything I am missing: Here are the defined site columns: <Field ID="{58dd212f-510a-41f1-ba00-f9c59663bdaf}" SourceID=" http://schemas.microsoft.com/sharepoint/v3 " Name="CAMA" StaticName="CAMA" DisplayName="CAMA" Type="BusinessData" Required="TRUE" BaseRenderingType="Text" SystemInstance="PubsInstance" Entity="PropertyInfo" BdcField="ParcelId" Profile="" HasActions="False" SecondaryFieldBdcNames="PropAddress: PropCity" SecondaryFieldWssNames="CAMA_x003a__x0020_Property_x0020:CAMA_x003a__x0020_Property_x00200" SecondaryFieldsWssStaticNames="CAMA_x003a__x0020_Property_x0020:CAMA_x003a__x0020_Property_x00200" RelatedField="PropertyInfo_ID" RelatedFieldBDCField="" RelatedFieldWssStaticName="PropertyInfo_ID" Group="PVA Columns"/> <Field ID="{0d3d0936-a8a8-4c3f-ac9e-2636cb95e566}" SourceID=" http://schemas.microsoft.com/sharepoint/v3 " Name="PropertyInfo_ID" StaticName="PropertyInfo_ID" DisplayName="PropertyInfo_ID" Type="Text" Hidden="TRUE" ReadOnly="TRUE" BdcField="PropertyInfo_ID" Group="PVA Columns"/> <Field ID="{3299d6d5-8986-4b23-8b39-3527bce05039}" SourceID=" http://schemas.microsoft.com/sharepoint/v3 " Name="CAMA_x003a__x0020_Property_x0020" StaticName="CAMA_x003a__x0020_Property_x0020" DisplayName="CAMA: Property Address" Type="Text" ReadOnly="TRUE" BdcField="PropAddress" Group="PVA Columns"/> <Field ID="{fc40165e-4f8e-4778-b93e-b8f401e67d86}" SourceID=" http://schemas.microsoft.com/sharepoint/v3 " Name="CAMA_x003a__x0020_Property_x00200" StaticName="CAMA_x003a__x0020_Property_x00200" DisplayName="CAMA: Property City" Type="Text" ReadOnly="TRUE" BdcField="PropCity" Group="PVA Columns" /> Here is the content type as defined in the Elements.xml: <ContentType ID="0x0100B6160E4B2AB8FB4FBA81BA7DFE5D9941" Name="PVA Item" Description="Create a new PVA list item." Version="0" Group="PVA Content Types" > <FieldRefs> <FieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Required="True" Name="Title" DisplayName="Title" Sealed="TRUE" /> <FieldRef ID="{58dd212f-510a-41f1-ba00-f9c59663bdaf}" Name="CAMA" Required="FALSE" DisplayName="CAMA" /> <FieldRef ID="{0d3d0936-a8a8-4c3f-ac9e-2636cb95e566}" Name="PropertyInfo_ID" ReadOnly="TRUE" /> <FieldRef ID="{3299d6d5-8986-4b23-8b39-3527bce05039}" Name="CAMA_x003a__x0020_Property_x0020" ReadOnly="TRUE" DisplayName="CAMA: Property Address" /> <FieldRef ID="{fc40165e-4f8e-4778-b93e-b8f401e67d86}" Name="CAMA_x003a__x0020_Property_x00200" ReadOnly="TRUE" DisplayName="CAMA: Property City" /> </FieldRefs> </ContentType> I greatly appreciate anyone's interests to help me resolve this issue. Thanks, Shane Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 5
    - Save a Site Template including sub-sites I know the question seems to answer itself, but I figured it wouldn't hurt to ask... If I've created a top-level site, and for various navigation reasons, created 6 or 7 sub-sites under it, and I then want to "templatize" the whole set (top + sub-sites), so that when a new site is created off the template, they get an empty top+sub-sites. How can I do it I'm using MOSS 2007, and don't see where the standard "Save site as template" option allows you to include sub-sites. I haven't used stsadm.exe, but in looking over the documentation, I don't see where it does quite what I want, either. Is there a third-party tool that can do this I'm also using SharePoint Designer, but that doesn't seem to offer anything additional in this regard... Any help is appreciated! Thanks, Todd Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 6
    - can't find my site virtual directory hi all, i'm developing custom web part and i need to register it as a safe control but i can't find any folder within this path: c:\Inetpub\wwwroot\wss\VirtualDirectories represents my site or site collection i mean that this path : C:\Inetpub\wwwroot\wss\VirtualDirectories contains just 2 folder named : 80 and 32859 and the 80 is used for the default site adn the other for the central administration site, can any body help me to fine where to register and deploy my assemply regards Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 7
    - Regarding List and data display Hi, I am trying to do a search functionlity using VB.NET by exporting some data from the sharepoint Portal server. I have successfully imported the list from sharepoint. It is display all the table names from a particular web site into a drop downlist control. After that On selection a particular table name i need to display the column names and data inside that. I don't have any clue how to accomplish this task....leaving me frustrated only.. Any help or suggestions will be apppreciated million times... Cheers Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 8
    - People search on user profiles imported from AD Hi I configured a full Active Directory import in the Shared Services Administration->User profiles and properties and I was able to get all the AD users imported into the server, however, whenever I search for people, I don't get any results back. Assuming there's a relationship bewtween the two, how do I link Search People to User profiles , or, if these things are unrelated, how do I Search People imported from AD Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 9
    - Sample required For Simple Scenario ? Hi all I need to provide a demo with the following features Want to have a wotkflow (say 2 level approval) start from sahrepoint and then send email to person to whome the arproval is assigned now from outlook the approval can approve or reject the request. Can any one share some code sample for this simple scenario. Best Regards Razi Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 10
    - SharePoint Authentication Prompts... Hello all! After exhaustive research I can't tell why SharePoint repeatedly asks me for my password. We are running WSS 2.0 using Windows Authentication and every time a user attempts to access a site they are prompted to enter their password. Adding the root of the SharePoint URL to the Trusted Sites works fine but this is less than convenient with our user base. Could this have something to do with the alias that our operations team is using Instead of: ServerName/Site we have SharePoint.Internal/Site Pre-emptive thanks! Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 11
    - Install options greyed out I'm installing Sharepoint Server 2007 on a Windows 2003 R2, SP2 server that already has SQL2005 and Sharepoint Services 3.0 installed. I start the installation and after the license agreement screen, it skips the screen allowing me to select Advanced installation and goes straight to the screen with the radio button installation choices and Stand-Alone is selected. The other two options, Complete and Web are greyed out. I want to install the first server of a Sharepoint Farm and not the stand-alone install. Any ideas FYI - I've downloaded the ISO from MVLS site AND tried the disk from my TechNet Media kit. Same result from both installs. Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 12
    - WSS3.0:run a repair on the installation: follow directions+reboot;follow directions+run configuration Wizard the configuaration wizard says it fails due to an error: Microsoft.Sharepoint.PostSetupConfiguration.PostSetupConfigurationTaskException thrown. neither local, online nor online live help are of service. am newbie + need step by step instructions to troubleshoot issue Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 13
    - The form has been closed error / form cannot be found Hey I am getting this message when trying to start a workflow on a sharepoint IP forms project Error Log Exception occurred during request processing. (User: XXX\Jackson, Form Name: , IP: , Request: http://portalsites-test2/_layouts/IniWrkflIP.aspx List=3f3aea57-9808-4d6f-8ae8-658677abc7d4&ID=2&TemplateID={79cf7b35-6830-4c20-885a-eb8f519bc298}&Source=http://portalsites-test2/sites/it-appdev/TestSite/DocumentTest/Forms/AllItems.aspx , Form ID: , Type: InfoPathLocalizedException, Exception Message: The specified form cannot be found.) Page error The form has been closed. Does anyone know how to start finding out what is causing the error. My Feature is activated, the form file is in the feature directory. Everything looks right. Is there a way to see in sharepoint what forms are attached to a workflow feature Thanks! Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 14
    - Permissions for web part pages The default welcome page for my SharePoint portal is a web part page. I would like to have some of the users be able to modify their personalized view by adding and removing web parts. The problem is I haven't been able to figure out the correct combination of permissions so that users can edit their personalized view of the web part page without being able to edit the shared view of the web part page. Does anyone know which permissions will achieve this Thanks, Cynthia Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 15
    - Unknown Error in WebPart - Too less Memory? Hi there, if the problem, that I'm getting an "unknown error" if I execute my WebPart. It contains some long runnings methods, and I it builds some komplex objects in the cache. I 've following ideas - SQL Server Timeout - Are WebParts restricted for not complex oprations with less memory Any ideas - George - Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 16
    - Any MS folks monitoring the unanswered postings in this forum? There's seems to be a very large percentage of the postings in this forum that are being left unanswered. Are there any MS folks monitoring the unanswered postings in this forum Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
- Next
  - 1
    - Start a New Workflow Can I remove / hide the "Approval" and "Collect Feedback" workflow in the "Start a New Workflow" page Tks in advance! Best Regards, Mar Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 2
    - List 'View Item' in my views don't work I have several Lists in my SharePoint site that I maintain. I updated one of the DispForm.aspx pages for one of the lists and now I can't seem to view an individual item from the allitems.aspx or any other views created for the list. I am able to edit and item by selecting 'Edit Item' from the dropdown of the record. If I manuall type in the url .....DispForm.aspx ID=1 it does work which means the page is available but the link within the view is broken. The views for all the other list work just fine. Could you tell me how I might be able to relink my views to the DispForm.aspx Thanks Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 3
    - Is it necessary to restart IIS after installing the Feature in Sharepoint Hi Technocrats... Hi Am creating new feature in Sharepoint. But I am in bit Confusion regarding restarting IIS after installing the Feature. Is it necessary to restart IIS after installing the Feature in Sharepoint Plz give me a Solution. Thanx, Srinivas Kajuluri. Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 4
    - Lost access to sharepoint mysites Hi there im using sharepoint 2007 and have set up Enterprise edition on the normal port 80. Due to another application needing the original port 80, i created a new site with site collection on another port, and stopped the port 80 site. As shown below http://servername:42392/default.aspx Setting up other sites on this box under this site works great, though i want to use the mysite feature still. When i try to access mysite, and this is for any user i get this error, Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /MySite/_layouts/MySite.aspx This is because the URL it is point to is still the site on port 80, which has been stopped, an example is http://servername/MySite/_layouts/MySite.aspx instead of http://vburdwweb01:42392/MySite/_layouts/MySite.aspx Is there a way to change which sites the mysite pages point to Or is there a way to view the mysites without using the original site Any help would be awesome, I'm so stuck with this! Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 5
    - Help on Sharepoint Hello , I am a sales guy in a company which is into providing sharepoint services and products..i have to make calls to the customers to get their requirements and all..i am not yoo much of a technical guy..so i want to know what all information should i know before i call a customer coz i dont want to look like a fool if a customer asks me any question and i end of goofing...so give me some links which do not talk to much in technical terms something general which u think i will need to know..some tips which u think will help.. thanks in advance Saurabh Choudhary fooxhingh@gmail.com Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 6
    - Calendar date format Can anyone tellme how to change the calendar date format It is currently using the american date format and I want to change it to UK. Does it use the servers regional options If so these look to be correct. Any advise on this would be greatly appreciated. Many Thanks in advanced. Wendy Ewens Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 7
    - How to set my workflow from "in progress" to "complete" Hi: I wrote a workflow using Sharepoint designer. When I processed a form with this workflow, it seemed that everything was good, and the system would open a task automatically and allowed me to input my option. But when I finished this process, I found the workflow was still showing "in progress" instead of " Complete". What should I do so this workflow will become "complete" On Sharepoint Designer, I found a command named "set field in current item". When I double-clicked on the word "field", a list of different items showed up. However, I could not find "task status" on the list. Can somebody please help me I really appreciate your help. Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 8
    - File Upload web part Hi, Can anyone guide me as in how to develop a FileUpload web part with a Browse Button. Or is this readily available in Sharepoint Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 9
    - Does SharePoint support URL transformation? I have an extranet SharePoint site with a web part which contains links to content on a back-end server, which is not accessible outside the firewall. I know that other portal servers (Plumtree in particular) are able to transform the URL's from the back-end server, so that subsequent requests to retrieve the content on the back-end server are gatewayed through the portal server. Thus the existence of the back-end server is hidden from the user. Does anyone know if SharePoint supports a similar or equivalent functionality Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 10
    - Tree View Control Left Navigation(Sites + Pages) MOSS. Hi all, I need tree view control navigation(roll up navigation) to my site. It should show both Pages and Subsites...... i already tried and wasted lot of time... Please any one help how to do it.... Or is there any third party tools available need very urgent..... please help me out... thanks Praveen. Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 11
    - Gradual Upgrade from WSS 2.0 to 3.0, cannot find an existing configuration database on the server When running the SharePoint Products and Technologies Configuration Wizard, I select that I'd like to connect to a server farm (so that I can do a gradual upgrade). When I type my database server name, it says it can't find any configuration databases there. There are actually two config databases on this server I have: verified I have access/rights to the config database I can make an odbc connection What else should I do to try to fix this Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 12
    - Approval workflow failed to start Hi there, i am having the OOB approval wokflow in MOSS 2007 , it starts whenever users want's to publish major versions. i have enabled both version controlling in the document library, namely "pages",(coz it's a publishing site i am working on) where all the pages are stored. but whenever i click the "submit for approval" button the workflow initialization window shows up, but after i click on start it says that workflow creation is in progress but then it fails. what could be the reason Am i missing something or else there is something extra i need to start a workflow in a publishing site i am using MOSS 2007 and .net framework 3.0 please help... thanks in advance Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 13
    - SSL - Login - MOSS 2007 I have a web portal built on MOSS 2007, I have a login control which available on all pages headers. I want to activate teh secure link on the login. shall I do any thing in my code or i have only to work on the IIS only or on both Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 14
    - How to connect MOSS 07 to external Website? Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 15
    - Workflow fails to start I have a problem getting a workflow to start on an item. This is a WF workflow on a list set to start when a new item is added to the list. This works perfectly, if I add items manually using the webinterface. However when using this code: SPSite mySiteCollection = new SPSite("http://localhost"); SPWeb listweb = mySiteCollection.AllWebs["Websitename"]; listweb.AllowUnsafeUpdates = true; this.Web.AllowUnsafeUpdates = true; SPListItem item = listweb.Lists["Listname"].Items.Add(); item["SomeId"] = this.something.Id; item["AnotherValue"] = this.something.Id; item.Update(); to add items to the list from another page, it does not work. The item gets generated, the rows get filled, but the workflow fails to start, claiming "error starting workflow, process will be repeated" (my translation, original in german). The logs show nothing, and there is no indication, that there is another try starting the workflow. Whats going wrong here Any help is appreciated. Yours, Bjorn Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies
  - 16
    - WPSC on Internet Facing MOSS site Hello! I'm working on an Internet facing Sharepoint 2007 site that has a custom masterpage. I've followed the directions here recommended by microsoft on how to exclude the bulky core.js and other javascript files for anonymous internet users to speed up the download size of our homepage. That setup was working fine until we added a XML Web Part to our publishing home page. Apparently, the XML Web Part injects javascript onto the page that calls WPSC.Init(document);. Now when you browse to the page anonymously, you get a javascript error saying WPSC is undefined - which makes sense because I'm not registering the javascript files on the page for anonymous users. I've tracked down that WPSC is actually defined in ie55up.js, but I don't know how to register only this script to the page. Anyone have any suggestions on how to fix the javascript error I'm currently getting on the page Jeremy Tag: SharePoint - Business Data Catalog edit business data column in datasheet view SharePoint Products and Technologies

Daren Coles

Hi all

Is it possible to edit a business data column in the data sheet view Currently when our users try and edit the values in a business data column in the data sheet view they get a read-only popup message.

cheers

Re: SharePoint - Business Data Catalog edit business data column in datasheet view

Daren Coles

For anyone else looking into this, the official response from Microsoft is that Business data Columns cannot be edited in datasheet view. They are read-only in this view.

Re: SharePoint - Business Data Catalog edit business data column in datasheet view

Magnus Lundqvist

When I go in to "Edit in Data sheet" I expect to be able to edit the item, not just the title. This is a bug!

Re: SharePoint - Business Data Catalog edit business data column in datasheet view

Qazi Mobeen

You can't edit the rows in datasheet view, if you want to provide the edit functionality for an entity, you have to write the custom business data action for that entity and provide a web part which will implement update/edit functionality for your entity.

Hope this helps you out!

Regards,

Qazi.

Re: SharePoint - Business Data Catalog edit business data column in datasheet view

Daren Coles

thanks for your reply Qazi - the requirement given to me was to allow users to perform bulk editing of items, which is one of the main uses of DataSheet view. Implementing a custom action still means they are restricted to editing one item at a time.