Hello, I'm actually working at MOSS 2007 project where I have to import data from an external data source (WebService) via an application in the Business Data Catalog. The application definition was created with BDC Meta Man and was imported successfully into the Business Data Catalog without any errors. I've first tested the external...
I'm new to MOSS. How do you set up/apply a filter using the MS BDC editor? I have run across a few samples but they don't go into any detail. ...
Hello, I’m using SharePoint (Business Data List web part) with the BDC. I use this to bring back data from the database, nice and simple. However, when I do a search I receive a number of results being paged by the web page. This takes a while to bring back any search results (even when navigating between the paged data). I’m guessing ...
I have a server whose AD account got crazy; log on would take hours and not all DCs showed the computer account. Now it only boots if disconnected from the network. I am trying to remove it from the domain but get aa timeout or if it is connected I get an error message "A remote procedure call is already in progress for this thread". I d...
I am just starting to create our Business Data Catalog(s) for our practice management system and I am running into an issue w/ our staff table. Background: I am using Business Data Catalog Definition Editor to create my ADF. I am using the RevertToSelf Authentication Mode. I have tried a few other tables and they seem to work just...
I create a BDC entry for a web service that exposes a catalog of publications. Each publication has a collection of authors. When I display the data in Bussiness Data List the column "Authors" displays "BDC.Authors[]". Ho do I get Sharepoint 2007 to display the last names, seperated by a ","? ...
I created a BDC entry using the editor delivered with the SharePoint 2007 SDK. On my local installation there is no problem. When the sysadmin tries to import it into the staging farm, he gets the following error message: Application definition import failed. The following error occurred: There was an error downloading 'http://...
I'm looking at designing some core information systems at a new company I'm working at (described one of my ideas here http://stackoverflow.com/questions/908705/workflow-system) I've thought a bit more, and am strongly considering using sharepoint for a lot of the heavy lifting seeing as it comes with so much out of the box. However, I...
Can anyone point to any good 'beginners walkthroughs' for the Business Data Catalog in MOSS 2007 Enterprise? It seems to be very powerful, but all the official guides assume preexisting knowledge. ...
I would like to change database column names of a BDC list webpart using an XSL file. My SQL query is "Select BATCH_ID...", I want to change that column name "BATCH_ID" to "ID" using XSL. I also want to know how $ColName_0 is getting populated with the value 'BATCH_ID'? Inside the dvt.headerfield template it is sorting and adding sor...
How can I write a log for sharepoint BDC List webpart? I want to know that which sql query bdc list webpart send to the database. Like I am filtering webpart on "Test". So, what would be the sql query? Either SELECT * FROM TABLE WHERE A='TEST' OR SELECT @ FROM TABLE? Is there any way to check what request sharepoint send to my Oracle da...
I am adding BDC List Web Part programmaticaly in the Sharepoint. I want to edit view using code too. Like "Retriever items that meet these criteria" and allow Paging...I tried to do using following code... BusinessDataListWebPart consumer = new BusinessDataListWebPart(); consumer.View.AllowPaging = true; consumer.V...
I want to provide "Query Value" to the BDC List WebPart from (Provider) businessdata filter webpart. I get fllowing error when i try to connect. "The provider connection point (BusinessDataFilterWebPart) and the consumer connection point "BusinessDataListWebPart" do not use the same connection interface." Following is my code snippet. ...
Pagination (Next button) doesn't work for custom BusinessDataListWebPart. I am adding BusinessDataListWebPart using code. Everything works fine. I can see 20 data raw at the same time but when I click "Next Button", I can not see next 20-40 data. A postback occurs, but the pageindex never changes. I am using following code to add Busi...
Hello, I am getting some problems in the BDC applications. When I import some BDCs application I get an empty error and my BDC applications in Central Administration file has no Version and no data. If I try to anything on it, I get Access Denied. Help! I am trying to delete it, because i already fixed the BDC file. Screenshots are h...
I want to use the List Data retrieval web service in sharePoint to query a list for it's records. Do I use the dsQuery or ptquery objects? What is the difference? ...
I am working on a PerformancePoint 2007 project. I have a bunch of Excel spreadsheets, and I need to get at the data. The users need to continue to enter data, they have Excel 2003, and I won't be here forever. If the users had Excel 2007 I could just use Excel Web Services in MOSS 2007, but that's a no go. What are your recommendati...
We currently have some c# code that runs and imports data from a number of opml feeds and stores it in several sql server tables. We are working in a moss environment and I am thinking the Business Data Catalog may be able to be utilised to make this process more robust/efficient. Can anyone suggest if it can? ...
I am trying to create my own application definition xml file for the SharePoint BDC, mostly because I want to become more familiar with the concepts. My application uses an in-house Oracle database, and it contains only one entity which is intended to just retrieve a subset of columns from a single database table. The entity ("Analytic...
I have added a column called Customer to my documents library, this is a business data column. What I want to do is relate a document to multiple customers by entering customer codes into this box. Currently I can add 'FLC' for example, but I want to put 'FLC, MFT, SAL' for a specified document as it relates to many customers. Any id...