In the Entity picker when the user selects an entity the id appears in the text box next to the add bottom. Is this normal? Users are wating a more meaniful name like the ProductName which is show as one of the columns. Thanks. ...
We have a number of Actions defined in a BDC (Business Data Catalog) definition in SharePoint, and need to change the order they are displayed in the UI. Within the Action defintion, there is a Position field, which we are specifying, however, the UI wants to display everything in Alphabetical order, which isn't what we are after. An e...
Hi there, I'm trying to format a field in a BDC (Business Data Catalog) definition, in SharePoint, with a thousand separator. It doesn't appear to be possible in the BDC XML definition, and only possible through the SharePoint Designer(!). The fields I've got at present are System.Decimal, so it displays as 12345.98, but I'm wanting it...
Hello Friends, I am trying to connect to read Excel file data using BDC in SharePoint 2007. I have used the Microsoft ApplicationDefinitionDesigner.exe and created the following Application Definition file. I can test the Method instances and can import this file as well. But when I use this in Business Data List webpart, I am getting a...
We are planning to use BDC to read and probably write to a SQL Server content database on external server. I have heard that there are many security issues that you may run into or should be aware of before setting up BDC. has anyone faced or knows any security issues with BDC. Thanks. ...
how to Use BDC column in list as multi-select column in sharepoint 2010 ...
I would like my BDC ReadList()-operation to fetch objects based on email from a user claim. I tried using IClaimsPrincipal in a webpart, with no problem, but I can't get it to work in BDC model. Basically I would like to do something like this: ReadList() { 1. Get Claims object 2. Get email from claims object 3. Ask query with that em...
We have set up a BDC Profile Import for Sharepoint 2007 and it works well for 99% of the users. A handful fails with the "Exception occured when calling into BIL connector for import from non master data source" message in the crawl log, though The ULS logs reveal the following information: Exception Profile Import: Exception occured w...
Hi. I'm looking for BDC generator, I found great one: MOSS BDC Design Studio but is there any free BDC generator? ...
I have the following BDC method to insert new spending plans. I'm trying to return the last insert primary key so I can reference it in another table. Does anyone know how to return the last primary key inserted using the BDC? I know how to do it in SQL, but I can't see to figure out how to do it through SharePoint. <Method Name=...
I've created a BDC for Sharepoint 2007 to integrate data from a third party database. This all works fine but now I want to filter the search result depending on the current user. Anyone has a idea how this can be accomplished? ...
I am evaluating Microsoft Search Server 2010 Express for use in a .NET project. Based on this diagram http://www.microsoft.com/enterprisesearch/searchserverexpress/en/us/compare.aspx, I get the impression that if you have Search Server by itself, you get a smaller set of features than if you have Search Server and SharePoint 2010 install...
Hi, I have database in sql server 2008. I have installed the MOSS 2007 also configured the Sared services. I want to Use BDC concept to show the data on sharepoint pages by its web parts. What steps I have to follow for this? I searched for this also on several sites. But something XML with LOB I have to define. What is this exact. how c...
I get this error on MOSS 2007 Search Crawl logs: The parameter is incorrect. (Cannot use the Business Data Catalog from outside an Office Server context without explicitly setting the Shared Resource Provider by Name on the Business Data Catalog Sql Session Provider) ..when crawling BDC data sources, in this case is just pointing t...
I'm using a Business Data List that displays a list of programs. I want to be able to filter the list based on the audience / user viewing the page. Also, does anyone know if it's possible to retrieve the audience variable from within the XSL stylesheet? If so, I can probably apply the filter through that instead of the web part. ...
I am doing this in SharePoint 2010, but wouldn't be surprised if the problem exists in SharePoint 2007 and has the same solution. I have a runtime security trimmer on my BDC data. I was expecting the security trimmer to give me URLs based off of the "default" profile URL defined in the model. Unfortunately, that is not the case. It g...
I'm trying to filter a BDC list and my filter returns multiple values. When the BDC list is filtered it filters based on the first item and then ignores the remaining values. Has anyone run into this and how did you resolve it? #region ITransformableFilterValues Members public bool AllowAllValue { get { re...