How to pass custom parameters to BCS .NET connector?

I've been developing a BCS .NET connector for connecting sharepoint search to custom web service. I'm now facing a problem that I must somehow pass the URL to the web service as a configurable setting (as opposed to setting hard-coded into the connector .NET
code itself) to connector's .NET code. What would be the easiest way to do this?

I found out that the external system link created for my connector in sharepoint central administration opens a view that says:
"There are no configurable properties."
Is it possible to somehow add a setting to be configured here?

Note that I've also found out that adding appSettings-section into C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\Root\web.config can be used to pass parameters to the connector, but this doesn't seem to work when the connector
is used by search crawler (mssdmn.exe).

So, what is the recommended way to pass custom parameters to BCS .NET connectors?

More Related Resource Links

I have a complex customized list and I need to pass parameters of two fields so that when the 'Questionnaire' is completed and subsequentially opened after initial submission, it will retrieve the Number and GUID automatically in respective
fields. I send an email out with a link to the 'Form' that carries the parameters. I am trying to use the following javaScript but am unsure as to where to place this on the SharePoint page for it to work.

ANY HELP is APPRECIATED!!

<script type="text/javascript">

function loadFormVars()
{
getQuerystring('CustodianGUID', 'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_ff46_1'); ///replace
customerGUID and form field name
getQuerystring('MatterNo",
'ctl00_m_g_d08916d8_7224_4665_be72_2de381f45985_FormField11_ctl00_ctl00_TextField'); ///replace customerGUID
and form field name

I have written a custom filter provider webpart which implements ITransformableFilterValues to pass parameter value to moss report viewer webpart.

However, this interface only allows to pass one parameter. Please can someone guide me through correct resource which allows my custom filter provider webpart to pass multiple parameters to report viewer. E.g if my report has 5 parameters then my filter provider webpart should allow me to make connection with report viewer and pass all 5 parameters.Bhavesh

I have an SSRS report. I created it using BIDS and it uses a Sql Server Analysis Service data source. The data source query is an MDX query with one parameter: @region, a default value has been set for this parameter. The value which @region takes looks like [USA].[Northeast].[New Hampshire].[Coos County].

The MDX query goes like this:

Select ....

FROM MySSASDataSource

WHERE StrToMember(@region)

This report runs properly inside BIDS or through web browser after deployment. In my report manager at http://localhost/Reports, I am able to view this report by selecting the value for the @region parameter from a dropdownlist, which contains such values as

Coos CountyCheshire CountySullivan CountyStrafford County... ...

I know that we can pass query parameters to SSRS through the URL. I have successfully done so with relational database which uses regular SQL. But, I have not succeeded in passing this @region parameter of my MDX query through the URL.

Hi All,
I have a page containing a link to to MS Excel spreadsheet (I am able to assume that Excel is available as this is an intranet page). All works fine until I want to pass a parameter into the spreadsheet.
Normally I would do this with /e but this will not work I am starting Excel through a link.
Any ideas how I would pass the parameters into Excel?
(also - there may be multiple requests for the spreadsheet at any time with differing parameters!!)
Thanks

Hi
I'm trying to solve a bigger problem we have in babysteps, and I guess after days of searching and trying I simply need to ask for help.
The big picture is, that we're trying to put a Form Action Button (via Sharepoint Designer 2007) above a custom DataForm DispForm.aspx which is supposed to navigate to a NewForm.aspx where the Title Field is supposed to be prefilled with a parameter from
the DispForm and the user should be able to add information to the item before it is saved.
I found several explanations from people on the internet, but nothing really worked.
The first babystep would be to get the parameter through the button into the url of the new item.
<
input
type
=
"button"
value
=
"Zugriff Beantragen"
name
=
"btnFormAction0"
onclick
=
"javascript: {ddwrt:GenFireServerEvent('__redirect={../Zugriff Beantragen 2/NewForm2.aspx?test={ItemID}')}"
/>
That's the code for my button. Somebody wrote that should definitely work because SharePoint is able to replace {ItemID} with the actual ID of the item. Well.... it kind of doesn't. What I get as the end of the new URL is exactly "...?test={ItemID}"
I tried with different names for the ID, I added an @ before those ... no change.
I read somewhere about javascript.functionName() which should work with all parameters of the item, but

The reason that I would like to consider this functionailty is because my table architecture is complicated and I do not want to modify my master table to accept all of this data where some of the data should be normalized into sub tables. Has anyone
see evidence of the stored-procedure parm approach? Is this best accomplished through VS 2010 or can I do it through SPD?
Thanks

Hi All,
I created a custom error page and update using webApp.UpdateMappedPage(SPWebApplication.SPCustomPage.Error, CustomErrorPage).
Its working fine and my custom error page is show if error is occurred.
OR
We redirect using SPUtility.RedirectToErrorPage("my message");
But I am not able to find my exception details at my custom error page.
Is there any way to pass the exception details and other custom information to custom error page?

I wrote a custom search connector (.NET assembly) so that external ECM repositories can be indexed using either search service application (sharepoint or FAST). However, the indexer process only calls my code one request at a time which isn't
going to be fast enough in most cases. I tried setting up a crawl impact rule, but still only a single request at a time. If I change the impact rule to slow the crawl down, it works. If I set the impact rule to handle 8 concurrent requests,
it ignores it.
Anybody have an idea on how I can get it to call my connector concurrently?Dan Hunsinger

Hi All,
I have a page library with custom column, lets call it "FormCourseId". On that page I have data view which retrieves data from custom list filtered by page column "FormCourseId".
In parameter wizard creates the following tag
<ParameterBinding Name="ListCourseId" Location="Form(FormCourseId)" DefaultValue=""/>
Then I try to use that parameter in XSLT of data view as a filter creteria.
<xsl:param name="CourseId"></xsl:param>
It does not work for me. If I change data view parameter source from Form to
Query String and pass parameter as url one it works fine.
What is wrong with page column parameter binding?
May be if FormCourseId column is not presented in form layout as a field(I do not need to show that field in user form of the page) it could not be treated as form parameter?

Hi, I have some report and plenty of parameters inside that report. One of parameter contains values stored inside dropdown
list (that are downloaded from db). Is there any way I can set the maximum length of that dropdown control? The problem is that when I expand drop down list I have a horizonal scrollbar because some values inside that dropdown list are too long. How can I
customize this parameter and dropdown control so there will be no horizontal scrollbar and values inside it will always be visible?

I'll start out by saying that I am kind of new to the Wizard control. What drew me to it, was the fact I didn't need to pass variables between pages with the traditional methods. Now I am faced with a situation where I may have to use those methods.On Step 2, I have a handful of LinkButtons that look similar to this... <asp:LinkButton ID="LinkButton113" CssClass="ListingItem" OnClick="boxChanger" runat="server" Text="Tree Services">Tree Services</asp:LinkButton> The sub boxChanger is this... Sub boxChanger(ByVal sender As Object, ByVal e As System.EventArgs) Dim s As LinkButton = CType(sender, LinkButton) Dim hd1 As HiddenField hd1 = CType(TemplatedWizardStep2.ContentTemplateContainer.FindControl("hdLinkItem"), HiddenField) hd1.Value = s.Text Wizard1.ActiveStepIndex = 2 End Sub I figured I could hide the item in a hidden field control before transfering over to the next page by changing the activestepindex. That's not the case. The first trip through the steps, I never retrieve the value in Step 3 from the hiddenfield. However, if I called boxChanger to get to Step 3, use the previous button (buttons are visible on Step 3) to change index back to Step 2, then c

This works great for 1 parameter
SqlDataSource1.SelectParameters("City").DefaultValue = Me.Page.Title
But I can't figure out how to pass in two parameters in a single statement (See the Select Parameters Below) Two paremeters (City, and Classification) If i set the page title to say "Bismark Charters" Bismark = City & Charters = Classification
<SelectParameters>
<asp:ControlParameter ControlID="CharterGridView" DefaultValue="" Name="Classification"
PropertyName="SelectedValue" Type="String" />
<asp:ControlParameter ControlID="CharterGridView" DefaultValue="" Name="City"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>The parent page title is used to populate the "City" Defaultvalue I tried using a new page element: Description="" to populate the "Classification" DefaultValue but Descriptipon is not a member of the page element eventhough it will not cause a runtime error.Anyone have any Ideas how to do this?
</SelectParameters
>

Using RS2005, how should multivalue parameters be stored in a database field so that a data driven subscription can properly read and use them?ÃÂ I have so far had no luck using syntax of:
1)ÃÂ ÃÂ parm1, parm2
2)ÃÂ parm1,parm2
Do single qutoes need to explicitly wrap the values?ÃÂ Can you please provide an example and a SQL INSERT statement using parm1 and parm2 to demonstrate what to store in the database field?ÃÂ
Thanks!!

Hello,Can someone help me with this. I have a custom control that I have created. I want to be able to pass in a Javascript snippet for a callback function. I am able to do this by passing a string back. The problem is that in the Javascript, I need to reference another server control that is not related to my custom control. So, I need to be able to pass in the ClientID of that control for use in the Javascript. Here is a snippet of what I am trying to do:<asp:CheckBox ID="chkStartDate" runat="server" /><cc:MyNewControl id="MyControl1" runat="server" OnClientOnChangeEvent="toggleCheckBox('<%= chkStartDate.ClientID %>');" /> Now, I realize that '<%= chkStartDate.ClientID %>' will not be parsed. But, I need it to be parsed so the OnClientOnChangeEvent property of my custom control can take any Javascript for use as a callback. In this instance, I need to pass in the ClientID of the control for the Javascript function to find the control to work with; and this seems to be the one issue that I don't know how to handle. I would appreciate any help offered for this.Thanks in advance.