Corey Roth [MVP]

Good post. This comes from MS and their confusing terminology. They couldn't even keep it straight and the API means of site and web are different than in the UI.

Pingback from  Links (2/24/2008) « Steve Pietrek’s SharePoint Stuff

Pingback from  Links (2/24/2008) « Steve Pietrek’s SharePoint Stuff

Pingback from  Links (2/28/2008) « Steve Pietrek’s SharePoint Stuff

Pingback from  ASP.NET MVC Redux | Stuff I want to log

Pingback from  Pages tagged "tolerable"

Pingback from  Dew Drop - March 27 | Alvin Ashcraft's Morning Dew

Looking to activate multiple features on multiple sites.  Could you post an example of your solution.

Pingback from  Links (4/1/2008) « Steve Pietrek’s SharePoint Stuff

Very very useful. If you remove it from the gallery does it remove it from all the pages you have added it to?

I do not believe so.  You should know by now that nothing in SharePoint is automatic. :)

Pingback from  Links (5/7/2007) « Steve Pietrek - Everything SharePoint

Pingback from  Links (5/13/2008) « Steve Pietrek - Everything SharePoint

On the MSDN search forum, people often ask a question like this: "I have a document named 'Programming

Downloads Windows SharePoint Services 3.0 SP1 Virtual Disk mit Visual Studio Office SharePoint Server

Downloads Windows SharePoint Services 3.0 SP1 Virtual Disk mit Visual Studio Office SharePoint Server

I'm under the impression that checking the Delete Unmapped Properties doesn't do much either... I have some crawled properties wich are no longer used in lists, and no longer mapped, but still won't be deleted.

Isn't there any other way to force this?

Hi Corey, great article! I have a couple quick questions...above you say "If you want to go crazy and unsupported, you can also modify the schema.xml of the built-in DocumentLibrary feature and accomplish the same result for the out-out-the-box document library". --- What exactly is the path to get to that file, just so I modify the correct one? Also, do you have to reset iis or anything for it to work? Will this remove the explorer view from all existing doc libraries or only new ones? Thanks soo much for your help!

The default path for the builtin document library is C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\DocumentLibrary\DocLib.  It is a feature (that is hidden) so you would have to deactivate it and reactivate it on any site collection that you would want to use it on.  No IIS reset shouldbe required.  It will only remove it on new document libraries created.  Any existing ones you would have to remove manually from each library.

One last question...Ok, I removed the chunk of code above from the path you listed. Now, can you tell me which item I would need to deactivate and reactivate in each Site Settings. Also, when you go to deactivate an item it gives you the following warning "You are about to deactivate the Team Collaboration Lists feature.

If you deactivate this feature, any user data or customizations associated with this feature might be lost. In addition, any active features that depend on this feature might fail to function.

Deactivate this feature ". Will I loose anything by deactivating and reactivating it? Thank you sooo much for your help!

Heute geht aber die Post ab im SharePoint Land: da wird zum einen das Podcasting Kit for SharePoint (PKS)

Heute geht aber die Post ab im SharePoint Land: da wird zum einen das Podcasting Kit for SharePoint

The link didnt come through on some of the RSS feeds, so here it is again.

www.codeplex.com/WildcardSearch

Pingback from  Links (6/12/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Bookmarking the web - w24/2008 - double density design

Does this work with people search?

Ah excellent question about using it with people search.  Right now, the answer is no because people search uses PeopleCoreResultsWebPart instead of CoreResultsWebPart.  This should be relatively easy to implement though.  I'll log a feature for this on CodePlex.

Hi gr8 article, it helped me lot.

I am installed your Wild card search on our server. its working like a charm.

however I also deployed Facets Search, it was working with normal search. however with wild card search(codeplex.com/sct). and its giving following error:

Error while executing web part: Microsoft.Office.Server.Search.WebControls.SrhdcGenericException: Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information.

Thanks,

Nilang Shah

I get the feeling that at some point I will have to write a Search Facets web part that is compatible with wildcard search because the way the search facets web part works is that it does its own keyword query to get the list of facets.  Out of the box this poses a problem because even if it did work, it would actually be running a different query than what the WildcardSearchWebPart so the facets would actually be incorrect.  I'll note this as an issue.  Thanks.

Pingback from  Links (6/24/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Bookmarking the web - w26/2008 - double density design

wouldn't

var filteredList =

   from myClass in myClassList

   join otherClass in myClassList2

   on myClass.Id equals otherClass.Id

   select myClass;

do the same thing?

That is correct.  This is equivalent to a join.  I should have focused more on the other case of finding cases where items in one list are not in the other such as the following example.

       var filteredList = from myClass in myClassList

                          where !subQueryList.Contains(myClass.Id)

                          select myClass;

Pingback from  Links (7/10/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Another SharePoint Developer/Debugging Tips List « Solutionizing .NET

Pingback from  Links (7/15/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Links (7/17/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Bookmarking the web - w29/2008 - double density design

Pingback from  SharePoint Infrastructure Update - So Far So Good « The WorkerThread Blog

Pingback from  SharePoint Infrastructure Update - So Far So Good « The WorkerThread Blog

Personally, I like SmartPart but most of the times I find myself developing web parts as custom controls.

BTW, you can always get both the easy authoring experience of ASCXs and the powerful personalization provided by wp properties by writing your own web part as your user control's wrapper (just what Smart Part does indeed).

It's an easy way to expose user controls properties to the end user.

Just my 2 cents.

Claudio

Great Tip! Saved me a lot of time trying to figure out how to get that data out!

one correction in your code:

// add the row to the dataTable

   FillDataTable(fieldCollection, entityInstanceEnumerator.Current);

should have the dataTable as well! Like:

FillDataTable(dataTable, fieldCollection, entityInstanceEnumerator.Current);

Also, I'll post this in the forums, but do you have any suggestions on using the business data type picker dialog box to open, so the user can select the entity??

Good catch.  I refactored the code some as I was putting it in this blog post, so I missed that.

I am not sure about how to implement the picker.  I would probably have to do some research / reflector work to figure it out.

Very useful

My favorite links from the 4th week of August 2008

Top News Stories Microsoft Completes Small Business Server 2008, Preps for November Launch (Network World

Hi Corey,

That is really a magnificent webpart. You've hit the nail on the head as far as missing-functionality in Search. I have 2 comments:

1. I'm using a BDC Scope. Do you have any idea when you might include the Scope functionality?

2. I noticed when I use the wildcard (eg: appl*) the hit highlighting or bolding doesnt appear. It only appears for exact matches.

Great work.

Cheers.

My favorite links from the 4th week of August 2008

Hi Corey,

Great webpart.   :-)  I noticed that it does not display the RSS links either on the webpart, or the "Search Action Links" webpart when the wildcard webpart is on the page, even if you select the "Display RSS Link" option in the webpart configuration.   Is this a casualty of using Full Text Query, or am I doing something wrong?

Thanks.

Pingback from  Links (9/4/2008) « Steve Pietrek - Everything SharePoint

I noticed that I needed to add scope to the query recently myself.  I think I can get that working pretty quickly.   The highlighting definitely doesn't work when using this.  I think it is based off keywords, but I need to confirm by using the builtin advanced search web part.

I hadn't noticed the Search Action Links being missing until you pointed it out.  Let me do some more research and I'll log these items on CodePlex.

I have confirmed that when using the Advanced Search web part the RSS links button is not present either.  This tells me that the RSS link only supports keyword queries.  So it looks like this is by design on that web part.  Thanks.

Does this work with people search? :)

Top News Stories Cisco Takes Aim At Microsoft's Stronghold (bMighty) Small and midsize businesses

you are doing really gr8 job. keep it up.

will this web-part work with Faceted Search 2.5?

Thanks,

Nilang

folks, if you havent use ontalica that uses sharepoint, you may want to give it a try. we re giving out our version of wildcard. we can give you a trial version wich is good for 30 days.

in a nutshell, how you can improve the search by adding our product in sharepoint as follows:

Ontolica Search gives you consistent search across SharePoint 2007 and WSS sites.

It improves the users' search experience, leading them to the information they are looking for, by improving all basic search features in SharePoint 2007.

Ontolica Search provides you with a perfect overview of your metadata, and allows you to configure the search interface, enabling end-users to categorize and adapt search to individual needs.

By adding Ontolica Search, IT-professionals are saved months of reprogramming SharePoint 2007 to the specific needs of organizations using SharePoint.

Ontolica Search is extremely flexible and customizable, and has an abundance of clever and indispensable features.

See the complete

www.ontolica.com/.../Feature%20Overview.aspx

Unfortunately I have not identified a good way to handle people search (www.dotnetmafia.com/.../wildcard-search-with-moss-people-search.aspx).

Thanks for the comments.  It doesn't work with Faceted Search out of the box unfortunately.  From my understanding it reads the user's query from the querystring.  It could be possible to write an interface to connect the web parts, but would require development in both projects.  This is definitely something I would like to see done though.

@mosleh

I don't know much about blog etiquette but I would think advertising a similiar search product on the author's blog would be crossing the line. Especially when Corey is giving his product away for free to better the SharePoint community.

Corey

Thank you for great web part, I have a question: when this web part is added to results.aspx page "Did you mean...” stop working. Is it because keywords are set to null?

Yes, I believe that is the reason why.  I think the Search Summary web part only works with keyword queries.  

Pingback from  Links (9/18/2008) « Steve Pietrek - Everything SharePoint

Pingback from  Links (9/18/2008) « Steve Pietrek - Everything SharePoint

Nuevamente les traigo mas información para SharePoint! Developers : 1 - Using Wildcard Search Web

Hi,

I have installed MOSS Wildcard Search Web part onto my sharepoint server.

I have added, deployed the solution through Central Adminstration... and also activated the same thru Site Collection Features option in the site settings.

The wildcard search is working fine.

BUT I AM FACING A PROBLEM after installing the Wildcard Search Core Results web part, BEST BETS are not working.

Please do help me in this regard.

Thanks,

Owens Jesse

That is correct.  Best bets do not work with wildcard search (since they are keyword based).  More info here.  www.dotnetmafia.com/.../what-you-give-up-with-full-text-sql-queries-using-wildcard-search.aspx

Pingback from  Links (10/1/2008) « Steve Pietrek - Everything SharePoint

One of the most commonly asked for feature are wildcard searches. There is lots of solutions to provide

Is anyone talking to recruiters, software vendors, etc. to ask about sponsorship?

Trust in Corey to keep the best sharepoint tips coming. Thanks, Corey!

Thanks!  That Tony guy is pretty cool.

This event was GREAT fun ! I look forward to it next year :-)

Maybe we can get David to help us promote it :-)

Wish I could make it to this :-( Hopefully can next time !!

We have a whole year to work on him. :)

Fret not.  We'll be trying to do this monthly.

Hi there, I have installed, deployed and activated the wildcard search in my MOSS and no different results are generated on wildcard searches, it seems like it doesn't work since my faceted search still works fine, could anyone advise on this. This is how I installed it:

1) Stsadm -o addsolution ...... as in the readme (I had to run it from folder PACKAGE)

2) Deployed from MOSS admin - Solution Management

3) Activated from Site Collection Features

4) Added Webpart to Search Center

....... run queries with asterix without having any hit generated due to the asterix.

Thanks

Nice trip down memory lane. We use to have an About page that talked about how we came up with the term dotnetmafia. What happened to it?

Oh and yes the Copy Source As Html tool rocks. It is invaluable if you want to include code samples in your blog.

Make sure you modified the results.aspx page (as opposed to the default aspx page) in your search center.  Also be sure that you have removed the existing CoreResultsWebPart from your results page.

I believe the about page was on the old site.

Pingback from  Links (10/23/2008) « Steve Pietrek - Everything SharePoint

Hi Corey,

I have just tried this solution and it does work however, if you have a managed document library with versioning enabled and the checkout/check in options it bypasses this allowing you to edit the document without the version number changing?

Maybe I am doing something wrong but this is how it appeared on my first attempt.

I just did a few tests and it did update the version number for me.  I tried it with having major versioning enabled.  I also tried it with and without checkins required.  I was testing a Word 2007 document in this case.  What kind of document were you trying it with?  Thanks.

Pingback from  China & Tibet

Hi Corey,

I implemented your code, but unfortunately the document opens exactly the same without the Edit/Read option.  

In my code there is a <xl:choose> tag right after the close of the Title span; is this correct?

-GrandmasterPhil

Hi. i have a doubt about this post

You pass xml to a string, and my question is how i can put credentials in that string?

Because without the credentials, with that string i get error 401.

I have somehow attach the credentials

Thanks

André

Pingback from  Links (11/5/2008) &laquo; Steve Pietrek - Everything SharePoint

After I posted I realized, I was not clear enough on the location it needs to go in.  There are actually two srch-Title spans.  The first one is used when there are no search results.  Put it after the second one.  Thanks.

You have to provide credentials to the web service.  This line uses the credentials of the current account.  queryService.Credentials = System.Net.CredentialCache.DefaultCredentials;

You can also specify your own credentials if necessary.

yes, but i am trying acess from buddyscript (building an agent), and there is not possible have this lines. So i need to put that credentials in the string. is possible?

Thanks for reply

I am afraid I don't have any experience calling a web service from BuddyScript.  Calling the MOSS web service is just like calling any other web service when passing credentials.  I would look and see if there is a way to pass the credentials when calling a web service.  You can't pass them in via the XML string though.

Hi Corey,

But i can only found one srch-Title span. So where is the correct location to add in that bit of code?

Thank you!

Sorry, I was thinking of the srch-Description span.  Yes, there is only one srch-Title tag.  I usually put my link between the span and the xsl:choose that you mentioned.  

Also keep in mind the code I am adding adds a link to edit the document it doesn't change the default action of clicking on the title of the document.  If you want that action, you could add the onclick event from the code provided above on that link.

Hi Corey,

Thanks for that, so far all working good with office 2007.

but is your code work with Office 2003? Because in our organisation some of the machine still using office 2003 and It seems not not working well with it. It doesn't give you the read only or Edit option when you click on 'edit document'.

Thanks!

That is a good point.  I think the script for working with Office 2003 is a bit different.  I'll need to look around and see if I can find a machine to try it on.  Everything I have access to has been upgraded.

Pingback from  How to: Get the Item Id from a document URL | deleteblog.com

Corey,

I was recently turned onto these blogs to better understand what my customers are looking for.  I understand that this was directed at Microsoft but I just want to let you know that although it may not be free, there is a single product which addresses most of the issues that you presented.  Ontolica Search is a web part developed by SurfRay.  Although it doesn't fix everything you listed, it knocks out a large chunk.  Check it out at www.ontolica.com/.../Webcasts.aspx

Although it is not free, Ontolica Wildcard by SurfRay does not have any of these issues.  It was free at one time, but due to the number of people illegally modifying it and its reliability it is no longer free.  You can find it at www.ontolica.com/Ontolica%20for%20MOSS%202007.aspx

If you want to properly do a wildcard search in something more advanced such as people search, faceated or federated search you may need to move to something more robust like Ontolica Wildcard.  This is not free, but it does get around those issues as well as the RSS and Best Bets problem.  Corey has developed a good wildcard search if you only need basic google-like search functions.  

Pingback from  Links (11/30/2008) &laquo; Steve Pietrek - Everything SharePoint

Pingback from  Remote Development, Deployment, and Remote Debugging your first SharePoint 2007 Program &laquo; Stuff I geek with

Pingback from  Remote Development, Deployment, and Remote Debugging your first SharePoint 2007 Program &laquo; Stuff I geek with

Didn't I answer this for you today? I want credit :)

Hey Corey,

Did you decide whether or not you were going to put some time in and develop your own People Search web part to get around the sealed class?

Cheers

Gavin

Pingback from  Recent URLs tagged Infopath - Urlrecorder

I visited a customer which wanted the option to directly open a document from the search results for

Pingback from  Recent Links Tagged With "wildcard" - JabberTags

I am on a special project that requires I do a deep dive into SharePoint and fast.&#160; I told my director

I want to, but I just haven't had time to look at it.  I am pretty skeptical about getting this case to work, but it is a feature that I would love to see.

Se termina enero, y aqui les dejo un compilado de las mejores ULTIMAS noticias sobre el mundo SharePoint

@SharePointBuzz

Now available: 0.2.4.0 alpha for Orcas RTM - LINQ to SharePoint SPDiag Tool Released - Bob Fox&#39;s

Hi Corey

I am not able to implement the sorting i.e order by in the fulltextquery property. while executing the query, it shows the error query is malformed.

Please help me to resolve this issue on how to use the sorting in this wildcardsearch webpart.

Cheers

Kathir

I believe the reason it does this is because CoreResultsWebPart has functionality to automatically append an ORDER BY clause onto the string based on if the built in web part property is set to relevance or date.  I think it might be possible to work around this, so I am going to log it as a feature to look into.

I installed this as per the readme instructions.  I was able to add the webpart to my search results page, but nothing is ever returned, with or without a wild card search.  I have removed the core results web part as instructed.  I have not removed the paging and high confidence web parts.  Am I missing something?

Please disregard my previous message.  I did not have the 3.5 framework installed and therefore it was not working.  As soon as I installed the 3.5 framework results started to show in the webpart.  I have run into a new issue however.  The quick search seems to work fine, but I am unable to get the advanced search to work.  Do I need to do anything special for that to work?

Pingback from  ArgumentNullException when calling Enterprise Search Web Service &#8230;

Amen brother. I can't tell you how many SSPs I have rebuilt in the past two months.

Hi, It is interesting to see JQuery growing in the SharePoint space. For sure client APIs will enrich

Yes 3. is definitely required since I use LINQ to XML to query which managed properties you are using.  I'll take a look into the Advanced Search issue.  In the meantime, you can always create another results page for use with your advanced search and use the original CoreResultsWebPart.

Couldn't able to find the attachment. Pls share the sample code.

The attachment is linked at the bottom of this post.  www.dotnetmafia.com/.../859.ashx

Hi Corey,

Will this can be implemented for metadata property search with lookup columns too.

Corey

First, Thanks so much by this excellent web part.

In my job, we used MOSS in spanish, and your webpart is working very well.

Only exists one issue:

For the search results by the scope "This site:...." or "This list...", MOSS used the page osssearchresults.aspx (not results.aspx). I custom this page adding your webpart.

The problem is: The webpart don't filter by the scope and the search is made in all the site collection.

The wildcard is working, the problem is only the scope don't working

I edit osssearchresults.aspx in this way:

1) I add the register directive:

<%@ Register TagPrefix="WpNs0" Namespace="DotNetMafia.Office.Server.Search.WildcardSearch" Assembly="DotNetMafia.Office.Server.Search.WildcardSearch, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null"%>

2) I replace all the ocurrences of "SearchWC:CoreResultsWebPart"

by

"WpNs0:WildcardSearchCoreResultsWebPart"

I missing something?

It's an error:

Step 2) In the page exists two webparts "SearchWC:CoreResultsWebPart".

I replace the ocurrences of "SearchWC:CoreResultsWebPart"

by

"WpNs0:WildcardSearchCoreResultsWebPart"

ONLY in the second webpart.

Corey, I missing something aditional change?

Thanks

Pingback from  How to: Create a Scope for a custom List Template Type - Corey &#8230; &laquo;  live.exofire.net

I assume you have the latest version right?  I did make some changes to correct issues around scopes in the last build.  Not sure that you can get this web part to work on the OSSSearchResults.aspx in the way that you are.

Pingback from  Gaussian Blur Blog von Robert Vogel  &raquo; Diplomarbeit: Entwicklungsumgebung #1

Pingback from  Extending the Document Link Handler for MOSS 2007 Enterprise Search &laquo;  Devology Solutions Blog

Source: Corey Roth

Pingback from  Sharepoint Web Servisleri - Search/Query Web Servisi | YAZILIM KUL??B??

Hi Corey

Just what I needed, however, did you manage to find the code for Offfice 2003?

Cheers

So this week has been an eventful week for Microsoft, with the release of Visual Studio 2010 beta to MSDN subscribers overnight and also to the public on Wednesday....

Keith, someone provided me some JavaScript for that, but I can't seem to find it right now.  I'll keep looking.

Pingback from  SharePoint Search doesn&#8217;t have Wildcard searching &raquo; novolocus.com

Pingback from  SharePoint can have Wildcard searching&#8230; &raquo; Andy Burns&#8217; SharePoint Blog

Pingback from  SharePoint can have Wildcard searching&#8230; &raquo; Andy Burns&#8217; SharePoint Blog

Hi Corey,

Thank you for taking the time to try out BDC Meta Man Web Edition and write about your experiences.

You are correct currently BDC Meta Man Web Edition does not work with Web Services but this is something we are looking to include in later versions.

Thank you also for pointing out the issue with Tables with large columns  numbers - I will investigate this and look to resolve it for the next release.

Thanks again for taking the time to review and provide valuable feedback on BDC Meta Man Web Edition.

Best Regards,

Phill

I&#39;ve seen this error in numerous occasions now and even so many solutions on the web: &#39;please

Pingback from  News   Enterprise Search Roundup | Web 2.0 Designer

Pingback from  Twitted by coreyroth

Hi Corey,

I'm trying to display the title/guid of the document library in the search result, when a document returned.

The search is not returning the list guid/title, when list item or document is returned.

Is it possible to achieve this.  

Thanks,

Ram J

Pingback from  Twitted by coreyroth

No suprises that #SP2010 is the big hitter again this week. Also seems everyone is quiet...no doubt a lot of the MVPs are quietly off playing with SharePoint 2010 and it'll be nuts once it goes public after conference......

Hi all,

I added the code:

<div class="srch-Description">

       <a href="{$url}" onclick="return DispEx(this,event,'TRUE','FALSE','FALSE','SharePoint.OpenDocuments.3','0

','SharePoint.OpenDocuments','','','','1','0','0','0x7fffffffffffffff')">Edit Document</a>

   </div>

to my results.aspx. The "Edit Document" link became visible, but when I clicked the "Edit Document" exactly the same happened as before.

What do I have to do with the "CoreResultsWebPart".

Thanks in advance.

Greetings,

John

Pingback from  Twitted by coreyroth

Pingback from  Provision a WebPart using a SharePoint Feature. &laquo; More Soma Please&#8230;

Top This Week SharePoint Deployment survey

Pingback from  Calling the Enterprise Search web service from Silverlight 3 &#8230;&nbsp;|&nbsp;888 Phone Cards

TOP THIS WEEK Bad Practice #1: Not using Solutions for deploying artifacts to the server(s) Ben Curry, CISSP, SharePoint Server MVP

TOP THIS WEEK Bad Practice #1: Not using Solutions for deploying artifacts to the server(s) Ben Curry, CISSP, SharePoint Server MVP

John,

What version of Office are you using?  I've discovered that snippet only works with 2007.

Thanks,

Corey

Pingback from  Document Type Query: Okay for Horseshoes, Not for Real Life : Beyond Search

Hi Corey,

I use MS office 2007. The extension of the most files on the SP server are doc file. This weekend I uploaded some docx files and started a full crawl. Unfortunately it didn’t work. I see a popup which asked to save or open the file. I only added the code you provided to the “core results” webpart, which displayed the edit text in the search results.

Any other ideas?

Thanks in advance

Greetings,

John

Hmmm, that is interesting.  The JavaScript there is effectively just the same JavaScript that is used in the context menu when you edit a document in a document library (which I assume works fine for you).  Let me dig a little and see if I can find anything else.

Pingback from  Twitter Trackbacks for                 Using an Extension Method to check if an item exists in a SharePoint collection - Corey Roth -         [dotnetmafia.com]        on Topsy.com

Ok, I confirmed that you actually can add lookup columns via CAML using the path to the list. There are a few caveats but it does work. Here is my post

Pingback from  Ableiten von Inhaltstypen (ContentTypes): Bug im SharePoint | Gaussian Blur

Pingback from  Twitter Trackbacks for                 Using CAML to deploy a lookup column via Feature - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

This works well. - Until the connection is to a Sharepoint List. -- unlike column lookups in a sharepoint feature, infopath isn't smart enough to fix up a lists/foo reference.  I have been able to fix up the ListID Guid references using a featureEvent handler. I just finished testing the and deploying the solution and as soon as I can get it "cleaned" up for publcaton, I'll post the link,

Pingback from  Twitter Trackbacks for                 How to: Create a Site Collection at the root level of your Web Application - Corey Roth - DotNetMafia.com -         [dotnetmafia.com]        on Topsy.com

Top News Stories Google Sites API Opens SharePoint Escape Route (Information Week) In keeping with its

I just discovered another reason for doing all of this in CAML vs a feature handler -- MSDN Article 931414 -- it's not possible to update the title of a udcx file after it has been deployed; so it has to be done in CAML as shown above.

Pingback from  Error: Reference to undeclared namespace: ???ns1??? when trying to create a custom Document Information Panel

GuyO.

Actually I have discovered you can specify the list name for a SharePoint List in a .UDCX.  CHeck out this post.

www.dotnetmafia.com/.../specifying-a-list-by-name-in-a-udcx-file.aspx

Pingback from  Twitter Trackbacks for                 ShareHofbrau: Post SPC09 Event - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Here is a list of the extracurriculum activities at #SPC09. Make sure you add yourself on twitter to the #SPC09 twibe

Hi Corey,

This is an excellent blog. This has been very helpful for us, for one of our requirement.

We have deployed the webpart and its working fine,but the problem we are facing is, we want faceted search also with wild card search. But when wild card is installed, facets dont work.

I have gone through all blogs of yours which say the difference between the two.

Can you please provide a solution for this problem?Do you suggest code modifications?

MOSS2007 search functionality is missing a common requirement of a search engine in the wildcard searches. This is commonly raised when the People Search is implemented and End Users wish to search for a person by a few characters of their Title etc.

MOSS2007 search functionality is missing a common requirement of a search engine in the wildcard searches. This is commonly raised when the People Search is implemented and End Users wish to search for a person by a few characters of their Title etc.

Pingback from  VseWSS 1.3 CTP March 09 &#8211; Still Buggy &laquo;  Alex&#039;s SharePoint Blog

זהו חברים. מהיום ניתן להתחיל לחשוף את SharePoint 2010. אז מי שחשב שזו תהיה השקה בסגנון R2 ל-2007 בהחלט

Pingback from  Twitter Trackbacks for                 New ECM Features in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hmmm, better check this again.. The ListId element is a full-blown GUID including the curly braces, without the curly braces, InfoPath will cough up an invalid GUID error message when you attempt to use the it on an entirely new form.  -- The is some odd goings on when udcx file is used on the form from which it was created -- I suspect that with the connection or the data are being cached someplace.   Same goes with the named list -- try using it on an entirely new form -- InfoPath will complain about the invalid GUID when provided the udcx file with the list name...  I really wish that you were right about this...

Guy

Yeah I didn't think it would work either, but I have successfully deployed this and its working great for me.

Pingback from  Twitter Trackbacks for                 Checking to see if a list exists in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 Writing to the Property Bag using CAML in SP2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 Lots of Databases in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 Use those version numbers in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Video | Enjolt.com | Innovate for Success

This post was mentioned on Twitter by EUSP: RT @coreyroth: #SharePoint Post: ShareHofbrau: Post #SPC09 Event http://bit.ly/wNnIo [Cory, do you want this listed? http://bit.ly/Iye1y]

Pingback from  New ECM Features in SharePoint 2010 &laquo; Michael Nagy&#039;s blog

Pingback from  New Events in SharePoint 2010 &#8211; Corey Roth &#8211; DotNetMafia.com &#8211; Tip &#8230;

Pingback from  New Events in SharePoint 2010 &#8211; Corey Roth &#8211; DotNetMafia.com &#8211; Tip &#8230;

This post was mentioned on Twitter by coreyroth: #spc09 Post: So many more databases to keep track of (and backup)! http://tinyurl.com/yjs35n9 #sp2010

This post was mentioned on Twitter by coreyroth: #spc09 Post: Using BindingRedirect in solution packages. http://tinyurl.com/yhr5kyh #sp2010

This post was mentioned on Twitter by coreyroth: #SharePoint Post: New Events in SharePoint 2010 http://bit.ly/4tr1BI

This post was mentioned on Twitter by coreyroth: New ECM Feature Summary in SharePoint 2010. http://tinyurl.com/yg3yb6z #spc09 #sp2010

Thank you Michael for properly crediting my post.  I appreciate it.

Pingback from  Twitter Trackbacks for                 Keyword Syntax Additions in SP2010 Enterprise Search (Yes, even Wildcards!) - Corey Roth - DotNetMafia.com -         [dotnetmafia.com]        on Topsy.com

This post was mentioned on Twitter by coreyroth: #sp2010 Post: Keyword Syntax Additions in SharePoint 2010 Enterprise Search (Yes, even Wildcards!) http://tinyurl.com/ygrrdhv

Pingback from  Records management in SharePoint 2010 &#8211; early thoughts &laquo;  Thinking Records

SharePoint 2010 external list (BCS) for MOSS 2007 / WSS 3.0?

If you like the new SharePoint 2010 external list feature and the new Business Connectivity Services (BCS) and want to make use of something similar in SharePoint 2007 / WSS 3.0 to connect SharePoint lists (no web parts) directly to external data sourcees (with change workflow), please take a look at:

www.layer2.de/.../SharePoint-Business-Data-List-Connector.aspx

The shareware version is completely free for download and use.

Pingback from  Twitter Trackbacks for                 Will Virtualization die in SharePoint 2010 development? - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

I was at the conference (SPC), but some of what I heard was difficult to follow or even contradictory with regard to the development experience.  Thanks for putting this article together, Cory, and for clearing up a few things for me.

I've been an "MS guy" forever, but truth be told, I'll continue developing inside of VMware Workstation.  I followed VirtualPC as far as it would take me, but it hasn't been a viable option for my work for some time.  VMware Workstation works well, has all the nice little extras, and (most importantly) gives me the isolation I need between my host OS and my development guest.

I looked at all the prerequisites and extra stuff I'd need to develop right on top of Win7, and I just can't see myself "junking up" my host.  With a number of different clients and environmental needs, being able to work in VMs is a real benefit to me.  I'm willing to pay the small performance penalty for the "cleanliness" and isolation.  Adding in things like snapshots and mobility (V2V or V2P) also helps.

For some, though, I know that VMs are seen as a negative -- not a benefit.  For those folks, I think installing right onto Win7 is the answer to many of their questions.  Regardless of the route folks choose, their dev options are much better this time around!

I have to agree about not wanting to junk up your main machine.  Virtualization really does have its benefits in that regard.  Even if I do go a virtualization route, I may still have it installed locally, because sometimes I just need to try something real quick in SharePoint or I need a screenshot or something.  It would be nice not to have to fire up a VM in that regard.

I've been using Virtual PC for a while, not necessarily by choice but as that was available.  I've been thinking about trying out Sun Virtualbox and I have heard good and bad things about it.  @givenscj says it works pretty good and it does support 64 bit guests, so I think that probably warrants giving it a try.

If you think of it, Corey, please share your experiences with Virtualbox.  A couple of the guys on my team are also looking at it and poking at it with sticks, but I don't have any good intel from them just yet.

If nothing else, I'm glad that we (as developers) have a number of options available to us with the 2010 release -- native boot VHDs in Win7, virtualization products, or installing straight onto the OS.  Everyone works differently, and it looks like we're finally at a point where there are enough options to accomodate the different methodologies and paths used in the development process.  Amen  :-)

I wonder if this can be done using the new Client Object Model. If so, that would presumable be a simple but effective bit of javascript.

That's a very good point.  I need to check the client OM and see if those objects are available.

Great post mate, I'm sure you've seen my opinions on this so far. I've added you to the SPDevWiki page on building a SP2010 dev environment too.

wss.made4the.net/.../sharepoint-2010-is-one-greedy-beast%E2%80%A6and-will-block-adoption.aspx

wss.made4the.net/.../factors.aspx

Thanks for this feedback I've up'd the starting number to 10,000 rather than 100. I thought that it was in the scopes of the feature, but obviously not :-(

Will release new 1.0.0.1 shortly, got your picture library bug to fix yet!

spsource.codeplex.com/.../View.aspx

and Document Lib custom view one:

spsource.codeplex.com/.../View.aspx

Windows 2008 R2 isnt actually that bad as a desktop OS.  All our developers are using it along with hyper-v.  It means that a Virtual Machine is also portable from the 'desktop' to the server too.  Check out the following site for tips on how to 'desktopize' your win2k8r2 install www.win2008r2workstation.com

This post was mentioned on Twitter by coreyroth: #SharePoint Post: Will Virtualization die in SharePoint 2010 development? http://bit.ly/40Iwrd

Pingback from  Will Virtualization die in SharePoint 2010 development? &#8211; Corey &#8230; | VirtualizationDir - Top Virtualization Providers, News and Resources

Thanks for the info. Some more detailed info on Doc set @ <a href="manish-sharepoint.blogspot.com/.../document-sets-in-sharepoint-2010.html">Document Sets in SharePoint 2010</a>

and  <a href="manish-sharepoint.blogspot.com/.../taxonomy-services-and-managed-metadata.html">Managed Metadata in SharePoint 2010</a>

and  

Top News Stories Will Virtualization Die in SharePoint 2010 Development? (Dot Net Mafia) This is already

A conundrum for sure, but at least there are more options. Although, I heard that a VPC build is forthcoming to support 32-bit host and 64-bit SharePoint dev image with Win2k8. (Host BIOS change to support virtualization is needed as well) I use VMWare Workstation and I posted a build guide to demonstrate an alternative:  www.ranson.us/.../Post.aspx

I'm getting the same results as GuyO when using it on a new form. It worked great when connecting to an SP list, then converting, then editing the GUID to the list name. But it didn't work on a new form.

I'll probably manually edit the manifest.xsf and the schema files for the secondary data source, because this functionality is too important. But it's going to be a pain.

Found the 5 places where data surgery is required, to add a secondary data connection to a udcx that has the list name instead of the list id. aka Corey style udcx.

Create and add a <list name>.xsd to the project.

There's 3 within manifest.xsf.

Add an xsf:file element to xsf:package/xsf:files.

Add an xsf2:dataConnections element to xsf:extension/xsf2:solutionDefinition.

Add an xsf:dataObject to xsf:dataObjects.

Within sampledata.xml add an xd:DataConnection element.

If you're looking for sample elements, look at an existing udcx connection.

Top News Stories Microsoft Cuts Prices for Online Exchange, SharePoint Versions (TechFlash) Microsoft

Sun Virtualbox works good on my Vista 32 bit which is hosting the 64 bit guests( A Windows server 2008 & Ubuntu 64 bit server). This requires the processor should support Intel VT and it should be enabled in BIOS.

Virtual box is worth a try.

Main purpose for this inherited control is add "Microsoft Office SharePoint Server Single Sign On service".

Integrated Security is blocked by security reasons, but it is very easy method to unblock it: just assign AllowIntegratedSecurity to "True".

<SPControls:SPSqlDataSource AllowIntegratedSecurity="True" ...>...</SPControls:SPSqlDataSource>

And you can not to modify tagMapping manually.

BTW, msdn.microsoft.com/.../microsoft.sharepoint.webcontrols.spsqldatasource.allowintegratedsecurity.aspx

Hi Corey,

It is very interesting solution for wildcard search. Thank you for this.

Could you help me to install it on WSS. I've deployed and activated solution for site collection but in WSS there is no Search Center exists. How can I use installed web-part results?

Thanks a lot for advance.

very useful piece of information and stright to the point.

I'm afraid you can't use this web part in WSS search.  It was built for MOSS 2007.  However, you can install Search Server Express on top of your WSS install and use it on the Search Center there.  

Thanks,

Corey

Corey,

I'm in the process of deploying an Access 2007 application on a sharepoint 3.0 site.  However I am concerned about the lack of referential integrity and join type and how this will impact my data down the road.

Any suggestions?

Thanks,

Al

If you are migrating your application from Access to SharePoint today, it is true that there is no out-of-the-box solution for maintaining referential integrity or for doing joins.  You can get around this some, by writing some ItemEventReceivers that enforce the integrity for you but its still not an ideal situation.  As for the joins you can write two separate CAML queries and join the results together with LINQ.  Again, not really ideal.

SP2010 helps this a bunch because it does have support for maintaining integrity and the query syntax now supports joins.  

Pingback from  Twitter Trackbacks for                 Configuring Federated Search to display results from your Corporate Web Site - Corey Roth - DotNetMafia.com -         [dotnetmafia.com]        on Topsy.com

We've opted for Hyper-V, noting that this is a contentious issue, even internally.

The major benefit of virtualisation for us is that we can use identical virtual environments that are network-isolated, which is a big consistency gain and configuration efficiency for SharePoint team development. In short, the main benefits as I see it are export/import, snapshots and that Hyper-V is effectively free is you're already running a server OS. Obviously there are issues with graphics performance and a few other things, but they're not compelling enough at present to sacrifice the benefits of working with snapshot and import/export by reverting back to native development. While many of these things obtain with VMWare as well, the license costs are hard to justify for us when the only 100% clear gain is graphics performance.

I've been spelling these design choices our in a lot more detail in my blog recently if you're interested: tristanwatkins.com

Hi Corey.

First I want to say your job is really useful to me. Second, I have a little problem using this custom . I made a modification to the sql query, I'm using a CONTAINS predicate to find exact phrases in columns of documents. Here is a sample of my code:

if (keywordQuery.StartsWith("\"") && keywordQuery.EndsWith("\""))

               {

                   fullTextQuery.Append("CONTAINS('");

                   fullTextQuery.Append(keywordQuery);

                   fullTextQuery.Append("')");

                   if (Page.Request.QueryString["s"] == "Documentos")

                       fullTextQuery.Append(" AND IsDocument=1");

               }

Until this step there is no problem. My problem start when I try to make a simple query to match an exact phrase, "Microsoft Search Engines" for example. The webpart returns this error "Your search cannot be completed because of a service error. Try your search again or contact your administrator for more information"

Do you have any idea what could be my problem?

Thanks a lot.

Great post, good info, clear and simple.  

Corey,

Plae help me to install this web-part on Search Server Express age. I can't understand what I need to do.

Thanks for advance

I installed following the instructions and the jobs all executed properly, but the feature never shows up on my site and cannot be activated.

I am running WSS and Moss and have only one site collection.  I changed the server name variable to the path of my server (IE:http://servername).

Any thoughts?

If you are not seeing the feature listed under site collection features, I would verify that the package actually installed correctly.  Go to solution management and verify that the .wsp for wildcardsearch did not have an error.  You can also check your features folder in the 12 hive and verify that the WildcardSearch feature folder got deployed.

Pingback from  Twitter Trackbacks for                 Deploying a Web Part with Code Access Security in Visual Studio 2010 (SP2010) - Corey Roth - DotNetMafia.com         [dotnetmafia.com]        on Topsy.com

Pingback from  ARB Security Solutions  &raquo; Deploying a Web Part with Code Access Security in Visual Studio &#8230;

Great tip, thanks for sharing.

Correcting the URL's for Doc Sets

manish-sharepoint.blogspot.com/.../document-sets-in-sharepoint-2010.html

and for Managed Metadata Service

manish-sharepoint.blogspot.com/.../taxonomy-services-and-managed-metadata.html

Thanks for clearing this up.

Pingback from  Twitter Trackbacks for                 Programmatically Changing the UI Version in SP2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

This can also be done using PowerShell.

$site = Get-SPSite("http://portal")

$web = $site.OpenWeb()

$web.UIVersion = 3

$web.Update()

$web.Dispose()

$site.Dispose()

Thanks to Tobias Zimmergren for the tip.

Mo

Did you manage to solve this issue?

Pingback from  Dealing with InfoPath Form Templates in Visual Studio 2008 with TFS | Seslichatcity - Forum - Film izle - Programlar - Diziler - Bur??lar - Haberler - Mp3 - Oyun

I actually kind of forgot about it.  I will check.

Hi Corey,

I wouldn't recommend you to even try to do this :)

I lost a couple of days fighting with it using reflection, but couldn't do anything usefull.

The only solution to this would be to create brand new web part that would mimic all the behaviour of the PeopleCoreResultsWebPart (but also I'm not sure if this would be possible, since when you decompile PeopleCoreResultsWebPart you can see that the most of it's properties are of some internal types..).

I think we'll have to wait for SP 2010 for this 'cause I read somewhere that this class is not sealed anymore..

Cheers,

Damjan

Hi Steve,

I have done the same thing and facing some problem at the time of coping the document library created from this feature.

When I save the Doc lib using SaveAsTemplate() it save it properly in List Templates however when I use GetCustomListTemplates() it does not returns the the above saved template.

Can you please let me know that it there any property which i need to set.

Thanks !

Yes, I tried the same and did not get very far.  Unfortunately, with the last build of Beta 2 I tried, the PeopleCoreResultsWebPart is still in fact sealed.  The good news is people search supports phonetic searching and wildcards out of the box so maybe this will be a non-issue.

Hi Corey!

Great Webpart, many thanks for this. Unfortunaltely I have one problem. I installed it in our development environment and it worked fine. Unfortunately I an'T get it running on production! Adding the webpart to the search page results in this error:

"Unable to add selected Webpart(s). Wildcards Search Core Results Webpart: Could not load file or assembly or one of its dependencies. Access is denied.

Do you have any idea what could cause this error?

Many thanks for your help!

Regards

Alex

how can I add scope if I am just passing keywords to the search web service?

string qXMLString = "<QueryPacket xmlns='urn:Microsoft.Search.Query'>" +

           "<Query><SupportedFormats><Format revision='3'>" +

           "urn:Microsoft.Search.Response.Document:Document</Format>" +

           "</SupportedFormats><Context><QueryText language='en-US' type='STRING'>" +

           Keywords + "</QueryText></Context><Range><Count>25</Count></Range></Query></QueryPacket>";

Make sure you have .NET Framework 3.5 installed on your production server.  If you do confirm that the DLL actually got deployed to your bin folder on your particular web application.

It's actually pretty simple.  I am assuming Keywords is a variable containing your query.  If so you can add it by doing something like this.

Keywords += "Scope:\"My Scope\"";

Yeah!

Magic words “psconfig -cmd upgrade -inplace b2b -wait”

Pingback from  Twitter Trackbacks for                 Troubleshooting Sandboxed Solutions in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi CoreyRoth,

By default Microsoft SharePoint Foundation User Code Service is  not started. We have to start this service  before deploy a  sandboxed solutions on SiteCollection.

Hi CoreyRoth,

i am also facing same problem .

could you please suggest me how to fix it

Many Thanks in Advance

I try to implement the elements using your code and works perfectly but the title, this service title appears empty on infopath, any ideas about that?

How can I fix the empty title issue?

I've actually run into the Title field not being populated before as well.  For some reason it doesn't pick it up from the CAML.  However, it does not affect the usability of the .udcx file.

Very helpful post.

Thanks

Pingback from  Twitter Trackbacks for                 Adding and Deploying Solutions with PowerShell in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the         [dotnetmafia.com]        on Topsy.com

This post was mentioned on Twitter by sharepointbuzz: #SharePoint Adding and Deploying Solutions with PowerShell in SharePoint 2010: Visual Studio 2010 makes it really e... http://bit.ly/8i2lc1

Pingback from  Twitter Trackbacks for                 PowerShell basics for SharePoint 2010 (sp2010) - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitted by jderde

Great post Corey.  One thing to add is that you need to make sure that MOSS_Setup is has the right DB rights.  It needs to have dbuser, dbcreator, and dbsecurity roles in order to access the instance during setup.

Thanks! I was struggling for hours trying to resolve the webpart issue.

Pingback from  Twitter Trackbacks for                 Enterprise Search Web Parts are still Sealed! Unseal them! (SP2010) - Corey Roth - DotNetMafia.com - Tip of         [dotnetmafia.com]        on Topsy.com

Pingback from  Weird toolbar on Custom Document Library &raquo; Andy Burns&#8217; SharePoint Blog

You can also create site column lookup fields.  Just remember the same technique does apply.  Lookups seem to only be able to read from local lists; I wonder if this is the case with SP2010?  So if you create a site column lookup, the reference list will need to be in the root web. Be sure to create the site column with CAML so you can control the ID, or else you will have to resort to code to add the lookup field to the next list.  

I like lookup fields.  I can apply item security to them by simply tweaking the security of their reference list.  It's great!

I can run Foundation on bare metal - Win 7 with VS 2010 Beta 2, SPD 2010, with no problem on a 4 GB machine.  When I started all its services, I consumed about 1 GB and overall maybe 2 GB.  It was refreshing to see a SharePoint installation work on Win 7!  But I agree, Foundation is TINY compared to SP2010.  The hunt continues...

Also make sure that you select the Default transport (instead of that juicy looking Remote option) and attach to Common Language Runtime instead of Native.  The Native type doesn't load any useful debug symbols so your breakpoints will never be hit if you do that.

Pingback from  Safe mode did not start successfully. Could not load file or assembly &laquo;  Edward Wilde

Thanks for useful information. Check also how to create locations to show top news from google using federated search @ manish-sharepoint.blogspot.com/.../federated-search-in-sharepoint-2010_21.html

Hi Corey,

I use FullTextSqlQuery. It doesn't have SelectProperties.Add method. Is there a way to return custom properties for the metadata?

Thanks

Dan

Here's my code-

using (Microsoft.Office.Server.Search.Query.FullTextSqlQuery fquery = new Microsoft.Office.Server.Search.Query.FullTextSqlQuery(src))

       {

           fquery.StartRow = 0;

           fquery.RowLimit = 10;

           fquery.HighlightedSentenceCount = 3;

           fquery.EnableStemming = true;

           fquery.TrimDuplicates = false;

           fquery.KeywordInclusion = KeywordInclusion.AllKeywords;

           fquery.ResultTypes = ResultType.RelevantResults;

           string strcolumns = "Title, IsDocument,WorkId,Title,Author,HitHighlightedSummary,Size,Path,PictureThumbnailURL,CollapsingStatus,SiteName,Write,Description,ContentClass,HitHighlightedProperties";

           fquery.QueryText = "SELECT " + strcolumns + " FROM Scope() WHERE ";

           fquery.QueryText += " \"Scope\" ='All Sites' AND ";

           fquery.QueryText += " FREETEXT(defaultproperties,'Report', 'HR') ) ";

           fquery.QueryText += " ORDER BY Rank Desc";

           ResultTableCollection rtCol = fquery.Execute();

           ResultTable relevantResults = rtCol[ResultType.RelevantResults];

           DataTable dt = new DataTable();

           dt.Load(relevantResults, LoadOption.OverwriteChanges);

           gridSearch.DataSource = dt;

           gridSearch.DataBind();

       }

Good article.

Thanks!

When working with search if you want the Item ID I would just map a property to ows_ID?

Is this applicable to SP 2010 ; I can easily enable the audience targeting but in web part i aint able to find properties to select the users. It used to be very simple and straight forward in MOSS 2007.

That I will need to confirm.  I'll take a look at it sometime on my sp2010 image.

After looking around a bit, I am thinking that this will still be applicable.  The properties for audience targeting are showing up for me on my build.  You may have some other issue or you may need to set up profile synchronization.

Pingback from  SharePoint Single Point of Failure &raquo; A Busy Week in the SharePoint World

like it

Where are we supposed to write this code?

You can do this by creating a Sequential Workflow in Visual Studio 2008.

This versioning seems excellent news for all people deveoping stuff using Visual Studio and WSP Builder ...

Pingback from  Sharepoint 2010 Search Web Parts unsealed (partially)

Unfortunately, this did not solve the problem for me.  Thanks anyway.... the search continues.  :)

I would like to update an existing installation with same assemblies but with different public key. Is there a way to have existing web part on my pages to point to the "renamed" assemblies. I was thinking at writing a program to export web parts for each page, changing assembly reference then reimporting them. However this will create a new web part instance (GUID) on my page and blow up any web part connection. Any hint would be helpful.

This post was mentioned on Twitter by jthake: #SharePoint #Link: Enterprise Search Web Parts are still Sealed! Unseal them! (SP2010) - Corey Roth - DotNetMafia.c... http://bit.ly/6ncqPo

how to write my sql text when i want that the results contain a compelete sentences.

eg: the result must have the sentence 'i am from china',how can i do?    the product we used is Search Server 2008. thank you !

Thanks Corey. This really helped me. Keep the good work going :)

Corey ,Wonderful piece !.It boost my learning spirit.!

i've came to the same problem. i totally agre, this is really lame.

Just run as Administrator and it will work.

Hmm.  and this was Foundation?  I installed Foundation on Win7 and used Designer to try and create an External Content Type and got an error.  I was missing a certain Service Application.  It wasn't installed.  I will try again and get you the exact error message.  I was under the impression the BCS was only part of SP2010 Server but the BDC is available for Foundation users.  Thank you for writing up this post, BTW.

Yes.  It's definitely Foundation on this particular image.  If the Service App isn't in your list, you might try going through the setup wizard in Central Admin again and see if it creates it.  You might also be able to create it manually from the service app page, using the new button in the ribbon.

I have specify the following for 'Fixed Full Text Sql Query' (and everything else as default) but it returns nothing.

SELECT WorkId, Rank, Title, Author, Size, Path, Description, Write, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL FROM Scope() WHERE "scope"='Project Status'

However if I specify 'Fixed Keyword Query' for 'Fixed Keyword Query', it returns some records.

Can you please advice why is it so?

contentType:"Project Status"

Does 'Sort Order' works only when 'Fixed Full Text Sql Query' is specify?

Trishia,

If your query is not returning any results, I would recommend simplifying your query some first and then build it back up a piece at a time to see where something is not working.   Do you have a scope called "Project Status" or are you just trying to query on the content type of that name?

The custom sort order will work in a number of situations.  If you are using a Full Text SQL Query be sure and specify your sort order using the custom property and not directly in the query.  This is due to the way the CoreResultsWebPart assembles the query.

Worked like a charm - thanks so much!

Hi CoreyRoth,

i need to correct myself. I mean if i put the following, it returns some records.

Fixed Keyword Query = contentType:"Project Status"

Can I use custom sort order (Title) for this 'Fixed Keyword Query' without specifying a Full Text SQL Query?

Greate, but how do you actually change the master page in 2010? the option is not there anymore under site settings, you have to use designer for that now?

I have tried this and it works. the problem is when I try to use webcontrol which is created the classlibrary anything does display on page. do you have any idea?

here is my sample code:

<%@ Page Language="C#" AutoEventWireup="false" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>

<%@ Register Assembly="ClassLibrary1" Namespace="ClassLibrary1" TagPrefix="uc1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "www.w3.org/.../xhtml1-transitional.dtd">

<html xmlns="www.w3.org/.../xhtml" >

<head runat="server">

   <title></title>

</head>

<body>

   <form id="form1" runat="server">

   <div>

   <uc1:WebUserControl1 ID="WebUserControl11" runat="server" />

   <asp:PlaceHolder ID="ph" runat="server"></asp:PlaceHolder>

   </div>

   </form>

</body>

</html>

protected override void OnLoad(EventArgs e)

       {

           base.OnLoad(e);

           ph.Controls.Add(Page.LoadControl(typeof(ClassLibrary1.WebUserControl1), null));

       }

Ok.  I'm actually not sure if it will work with the Fixed Keyword Query or not.  I didn't write any specific code to handle that property, so there is a good chance it won't.

Great post... WebPrart works great...

Does anyone know a similar solution for PeopleSearch?

Pingback from  A Busy Week in the SharePoint World &laquo; The SharePoint Mechanic

Pingback from  Mechanical Properties and Performance of Engineering Ceramics and Composites III | Ceramic Engineering Addict

fantastic idea, install was clean (v1.0R5), but when I add the webpart, there is no actual search field to enter criteria into.  Suggestions?  Thank you in advance for even making this available to start with.

Which page did you add this web part to?  Typically, you will edit your existing results.aspx page (which should already have a searchbox).

Pingback from  What's Your &quot;Why?&quot;

Hi Corey,

We are using this webpart and it's working fine expect some issues..

Now a days my site which using this webpart are creating so many deadlocks in memory and i am not able to find reason. Then after locking a call in Microsoft they are suggesting that this wild card search web part using using core dll using Reflection and that is out of box of sharepoint model so it's creating deadlock.

Is there any way we can achieving same goal without using reflection ?

Regards,

Mehul

Hi,

I don't know your (Author's) name. But whomsoever you are. You had done amazing job. I am .Net Developer and using sharepoint since while but your articles are so nicely written that any new developer will find it very comfortable. Once again hats off to you and thanks for writting such wonderful articles. Keep up the good work.

Thanks,

Preet

Absolutely amazing...!! Marvelous.... No words to describe it...You have down superb job. People like you are required not only in SharePoint Community but required in world. Thanks for sharing such valuable knowledge.

Pingback from  Deploying Relational Lists using CAML in SharePoint 2010 &#8211; Corey &#8230; | Drakz Free Online Service

This solved my problem installing BizTalk Adapters for Enterprise Applications on Windows Server 2008. I ran:

install.exe /extract "<current folder>"

(Trying it with setup.exe in the same foilder didn't work)

Thanks for the great comments.  I'm glad people are finding it useful.

SharePoint 2010 External List (BCS) for MOSS 2007 / WSS 3.0?

If you like the new SharePoint 2010 external list feature and the new Business Connectivity Services (BCS) and want to make use of something similar in SharePoint 2007 / WSS 3.0 to connect SharePoint lists (no web parts) directly to external data sources without any programming or tools, please take a look at:

www.layer2.de/.../SharePoint-Business-Data-List-Connector.aspx

All list features are available, e.g. grouping, lookups.

You can start buiness workflow actions in SharePoint, if external data changes.

The shareware version is completely free for download and use.

Looks pretty cool, but it looks like Microsoft is making your product unneeded pretty soon.

Hi CoreyRoth,

So how should I build my fulltextquery so that I can do sorting by Title for Fixed Keyword Query = contentType:"Project Status"?

Many thanks.

There are some issues involving this approach for People Search.

www.dotnetmafia.com/.../wildcard-search-with-moss-people-search.aspx

@Trishia - I think you can use what you have and it would be something like...

SELECT WorkId, Rank, Title, Author, Size, Path, Description, Write, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL FROM Scope() WHERE ContentType='Project Status'

You would then use the custom sort property of the wildcard search web part to specify a sort order by title.

I'm trying to deploy to a remote server from my build server utilizing the command line, which will placed in CCNet file.  When I attempt stsadm -o addsolution -filename package\MyAssembly.wsp, I am receiving the ominous "Object not set to the instance of an object.  Solution was not added" msg.  Any ideas?

Hmmm, it sounds like there is something inside your solution package SharePoint doesn't like.  Unfortunately, you may have to sift through the logs in 12\LOGS to find out what the actual error is.

Pingback from  Sharepoint : Various way to develop WebPart in Sharepoint &laquo;  Nair&#039;s Blog

Pingback from  Sharepoint : Various way to develop WebPart in Sharepoint &laquo;  Nair&#039;s Blog

Pingback from  Sharepoint : Various way to develop WebPart in Sharepoint &laquo;  Nair&#039;s Blog

Well... you do what you always do with legacy code problems like this: you create your own wrapper class that uses same public interface as class you are wrapping. Wrapper class will be unsealed and allows extending. That's all you can do going nice way.

Of course... if you are brave code terrorist and you are very sure what you do then you can always to what you ever you want to do using reflection and dynamically created code. It is way more complex thing to do and harder to debug but at least on dynamic level you can create copy of sealed class and make it unsealed. I suggest you to find better method than this.

I forgot to mention quickest way. Take Reflector and disassemble sealed class. Add it to your project withoout sealed keyword. In this case you have to be ready to modify disassembly results because code that Reflector disassembles may be problematic.

The other option is more complex. Use ILDASM to generate IL file based on sealed class. Remove sealed keyword, change namespace and/or class name and create DLL using ILASM. You can reference this DLL from your projects.

Hi,

The external list which gets created has workflows option  disabled.Does that mean we cannot use sharepoint native workflows in this list.Any workarounds

Thanking You

John

Good comments.  The code terrorist way is actually the way the wildcard search web part works (via reflection).

wildcardsearch.codeplex.com

It's not pretty but it does work somewhat successfully.  I've only had one real case reported where it was a real performance issue.

Thanks. This is the information I was searching for. I ahvea n additional out of place query though. The .dwp or .webpart files that are provisioned using a WSP, go to which location within the filesystem?

They go into the web part gallery inside SharePoint.  You won't actually find them on the file system anywhere.

That seems to be the case.  It doesn't look like we can trigger a workflow off an external list.  There may be a way to get around it, but I'm not sure yet.  I do know that SharePoint workflows don't have to be associated with a list item any more in 2010, so that might be something to leverage.  I don't know if ItemEventReceivers fire for external lists either, but I suspect not.  I need to look into that.

Interesting. Yes, and the BDC just won't go away :D

Heh.  I have to say it's pretty nice to work with now.

I'm glad to see the list schema still supports the old way of provisioning a bdc column with projections. I might be able to use this fold meta data into the bcs data. That template 600. What is the type Id for the list template you threw away? I didn't think you could create a list instance without a corresponding template whether custom or not.

The xsllink is an exciting enhancement! That goes back to DVWP. In fact it looks like list views are now just DVWPs. No more CAML to describe the rending of a view -- those were evil.

I guess I didn't make that clear enough. I threw away the list template that I got from using the new list SPI.  XslLink is very cool.  Coincidently enough the SharePoint Product Team posted this last night describing how it works.

blogs.msdn.com/.../sharepoint-2010-list-view-blog-series-part-3-list-view-architecture.aspx(Microsoft+SharePoint+Products+and+Technologies+Team+Blog)

Thanks maxmorgan.....fixed me right up!

It's help me. thanks alot for your comments

I had this problem with I reset the password for the service account used to run the services.  You have to go to central admin, operations, services on server, click on Off Sharepoint Server Search and enter the new password.  Everything seemed to fix itself.

Do relational lists in Sharepoint server 2010 preserve all relational constraints? For example is it possible to define a primary key composed by 2 or more columns?

I'm searching also if it is possible, when you insert a new item in a list,  filter combo data considering the value set in another field. For exaple if you select the item "Canada" in the first combo box, is it possible to have a second combo box that updates it's data to match canadian towns?

Finally, the new feature that permits to see data from the parent list is available only in views or also when you insert a new item in a list?

Hi,

If you working in team site then the master page option will not be available under site settings publishing features are not enabled bu default.

You need to activate Publishing site features from site collection settings, then you will get that option.

That is a good point.  This also applies to MOSS 2007 as well.

Very useful piece of information and straight to the point. Thanks!

Pingback from  New Year and New Officers at the Tulsa SharePoint Interest Group | Explore Tech Answers

Do you know if this will work when content deployment is being used? Example, I have an authoring environment where multiple contributors can manage their own content. Upon completion of an approval workflow the published content is deployed to a read-only environment. Thanks and nice work!

I think it should, but you may need to put this code in the workflow itself.

Thanks

SPSite.Features.Add will always appear to succeed, even returning a valid SPFeature return value.

Yet if the calling process identity is not an SCA, it will actually silently and secretly fail.

Nice one, one question.how do i update all mysites scopes

External List seems cannot be used to trigger WF. It may because the data for  External List are saved in external data source but not SP.

However, we could create a WF for regular list to access data from  External List. There are couple papers talk about WF with External List.

blogs.msdn.com/.../using-sharepoint-workflows-with-business-connectivity-services-bcs.aspx

I am experiencing this exact issue. Could you please explain where we could find the Schema XML file. I have tried looking with SPD but to no avail.

In this case, the schema.xml is used in my custom document library's feature.  I also highly recommend being fairly current on service packs / updates if you are dealing with document information panels.

I put a ContentEditor web part on a page. Added text for a disclaimer statement. I exported the web part as disclaimer.dwp. I imported it into the web part gallery and added it to a page. Worked great. Now I want to add it to a site definition. Nothing I try works. HELP!!

If you want to add it to a site definition, I recommend putting it in a feature and then use feature stapling to attach that feature to your site definition.

Pingback from  ARB Security Solutions  &raquo; A simple way to programmatically create SharePoint security groups &#8230;

Oklahoma City SharePoint User Group Opportunities

Thanks for a nice post. I have been taking similar appraoches with 2007 in the past however with 2010 we can improve it a bit further.

The challenge with developing these utilities as winform applications is maintenance, by the end of the project we would have a basket full of utulities to automate different tasks.

With 2010 I think the best approach would be creating a cmdlet for the code you have given above. I haven't played with cmdlets yet but in theory beleive it is quite possible and then we could have a powershell batch file to prepare the sharepoint enviornment and one step would be calling this custom cmdlet to create groups with xml file provided.

Hassan

@Hassan - Yes, writing this as an stsadm command is a very good way to execute this code.  A feature also works as well.  Going forward with SharePoint 2010, you can write this as a powershell commandlet as well.

Pingback from  Steps To Install WSP file in STSADM &laquo; Dot Net Solutions

Pingback from  Query Active Directory

Pingback from  Sharepoint Active Directory

Partial name searching, such as the "Will" for "Williams" example that you gave is already available in SP2007. You just need to add the managed property in front of the criteria (LastName:Will).

A really easy solution is to build a web part that has input boxes for first name and last name and contains a button to execute the search. The web part can then pass the criteria along with the managed property data to the search results page.

We added a part like this to our portal homepage and with over 3000 searches for employees every day, I can't even imagine how many hours it has saved in 3 years.

Very interesting read, thank you so much for this insight. I am waiting to go live with SP2010 once it is released.

Nice article Corey! I think I'm having a similar scenario, just not sure which schema.xml to view & edit? When I searched there are a lot of schema.xmls files.

Pingback from  Sharepoint Active Directory

What about the number of cores - I am wondering between dual core with 6mb of cache and quad with 4mb of cache(in fact 2mb on die)?!

I'm no expert on cores, but I would lean towards the quad.

Thanks Buddy for this information. Was doing a setup for BDC and the article helped me figure out the issue. The crawler was missing the Execute permissions in BDC permissions.

Hi Corey, i am trying to  do something very similar and I came accross this excellent post..

I want to do something like this:

..  AND( (scope='myParam1' OR scope='myParam2' ) AND scope='myParam3') AND (publicationdate < 15January) AND publicationDate>30January

so my problem is logical OR and aND betwenn search scopes created in Central Administration and the content publication date.

As for the publication date - does all content has it? Fo example if i add a element to some list .. the query also should take it into consideration.. Administrators won't be inserting publication date of a row in some list.. that would be nonsense, so I have to implement it. Visitors can filter content puting two date boundaries

please advice...

Corey, in Sharepoint SetPropertiesOnHiddenObject() is obsolete and empty, the srho doesnt exist and the webpart won;t work :(

@Poupreh - Are you referring to SharePoint 2010?  If so yes, that is the case.  You can now override GetXPathNavigator(), I believe to make use of the SharedQueryManager object to do custom queries.  However, this only supports Keyword Queries.

Thanks for this post it helped me a lot!

I have the same problem, but then by using http instead of https.

When using http the workflow just won't start...

Not sure why though

Find the details at below url

weblogs.asp.net/.../sharepoint-logs-tacing-service-lost-trace-events.aspx

The Title field not being filled does matter. If you change or upload a new version of a UDCX to the Data Connection Library, and then want to Check In that file, SharePoint doesn't allow it: the Title is a required field. This check is ignored with feature activation, but not with a manual change.

Most annoying thing about this: manually entering the Title doesn't seem to work either.

Pingback from  Two Techniques for Deploying Sharepoint Content

Hi, Is there any trivial way to automate the publish of a form template to a sharepoint library?!

I tried a lot of things, but Infopath seems very complicated in allowing that.

The disclaimer here is that I don't want to use the Enterprise FormServerTemplates for which there are a lot of blog posts there in the internet. I don't want to use browser-enabled forms, I don't even need the form template to be signed or versioned. I JUST need a plain template, like word templates. I tried to find more on that:

williamvanstrien.blogspot.com/.../automatic-publish-infopath-forms-via.html , but he couldn't give me clear explanation what is XsnFeatureReceiver used for, and misleaded me even more!

Thank you for your time

Pingback from  Two Techniques for Deploying SharePoint Content

Pingback from  Two Techniques for Deploying Sharepoint Content

Pingback from  Two Techniques for Deploying SharePoint Content

Pingback from  Two Techniques for Deploying SharePoint Content

maxmorgan's magic words worked for me

Hi Corey, GetXPathNavigator resolves the scopes problem but it seems not to support dates comparison.. I wonder if there is any solution in which you could use your own advance query, display results using existing CoreResultsWebpart and paging them using existing PagingWebpart

Pingback from  Windows Azure for Noobs | Explore Groups Answers

I got the base listdata.svc link to work but when I try to do any additonal parameters I get 404 error.  Any ideas?

Pingback from  Twitter Trackbacks for                 Windows Azure for Noobs - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Great tip thanks Corey.  It's basically a problem with SharePoint that after you write a feature scoped to the SPWeb, how do you then control and configure that feature easily and cleanly?  This is a great way to do it - put parameters into the property bag and you can edit them in situ with SharePoint designer to control how the feature works.

Thanks,

Very helpful.

Don't forget to call dispose() on your query object or wrap the FullTextSQLQuery in a using statement as it holds open resources.

Pingback from  Twitter Trackbacks for                 Slides from my SharePoint Enteprise Search at OKC SharePoint Users Group - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Linkliste zu SharePoint 2010, Office 2010 und CRM ??? 10/04/01 &laquo; Sharepoint Infoblog

Pingback from  Linkliste zu SharePoint 2010, Office 2010 und CRM ??? 2010/04/01 &laquo; Sharepoint Infoblog

I can also confirm sometimes it isn't added, noticed that just this week. Thanks for @SPDevWiki mention ;-)

BTW top dev blog mate!

Here is another introduction post on Silverlight Client Object Model in SharePoint 2010. This will also helps the devs to understand and create applications.  Take a look at it.

praveenbattula.blogspot.com/.../sharepoint-2010-silverlight-client.html

Pingback from  Twitter Trackbacks for                 A quick guide to CoreResultsWebPart configuration changes in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Restart the Office Service in services control panel after specifying the new password in the LogOn section of the service properties.

Pingback from  SharePoint 2010 solution package deployment: sandboxed vs farm solutions) &laquo;  Uscatu&#039;s blog

Pingback from  Twitter Trackbacks for                 How to find a good SharePoint person for your next open position - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Presenting @ Oklahoma City SharePoint User Group

Excellent article - Interesting to see that the same problem with finding good SharePoint consultants exists also in US and not only in Sweden (we are constantly looking for new SP Dev specialists).

Thanks!

/Göran Husman

SharePoint Server MVP

Sweden

Pingback from  Twitter Trackbacks for                 SharePoint Post: Tulsa SharePoint Interest Group ??? How the SharePoint 2010 BCS will change your life         [dotnetmafia.com]        on Topsy.com

I agree with you, that it is probably a very good idea to hire a SharePoint expert who is active in the SharePoint community. So your approach to find new employees is obvious a good and easy one.

But I strongly disagree, that it is the only way. And I even disagree, that " If the person you are looking to hire, can’t be found on twitter, you probably don’t want them". There are excellent developers around, who do not blog, do not answer questions in forums and do not send tweets. Sharing your knowledge could make you a better developer or admin. But not every one is an author. Some developers are just readers, who use the information from blogs and forums AND don't like the flood of tweeds in twitter. To find an expert from the community is obvious easier, but they last mentioned type of developers are not necessarily the worsed ones. They are only hard to find.

Yeah, I knew that statement would probably stick in some people's minds as I was writing this.  Don't get me wrong. I know a lot of good SharePoint people that aren't on twitter, don't blog, don't go to user groups or anything.  I wish they would at least participate somewhere and I encourage them to regularly. :-)  

Twitter obviously isn't the only way to find good people and it certainly is an unconventional one.  The point I am trying to make is that to me, doing SharePoint work without twitter (and the other community areas) is almost like doing work without Google or Bing.  These are just too valuable of resources to pass up.

Amen!

I also find that there are lots of great devs who don't tweet, read blogs, write in forums, turn up to user groups as they see it as a 9-5 job and don't do ANYTHING extra. These guys can still be crack hot too.

Thanks. This save me a lot of time

Thanks. good tip!

Pingback from  Twitter Trackbacks for                 Slides from my talk on the SharePoint 2010 BCS at Tulsa SharePoint Interest Group - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

I just tweeted question about this a few weeks back! Great timing.

I completely agree, glad to have my suspicions confirmed.

It works great when you type in your query in the basic search box on the results page that has the WilCardSearch Webpart. But what if I want to enable wild card search for an Advance Search webpart located on another page? Is that possible?

Great Article.

Lets say I have created a web part on site A.  Now I wish to use the same webpart on another site B which can be on the same server, or different server.  What do you do in this case?

@Jasonat Well, you can take the .wsp file it packages and install it on the other server using stsadm or PowerShell.  You can also just update the server reference found when you click on the project and look at its properties and point it to the URL of the other site.

Pingback from  Twitter Trackbacks for                 Mapping Enterprise Search managed properties from the BCS in SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

This really helped me for the type of solution I needed and how I am developing for SharePoint.

Thank you very much for posting this.

My application continues to have this exception even when I change it to x64.  Any other things I should look at?

What if you want to display list items (e.g. News) that are also not documents? I would exclude here only the contentType folder.

Then I would consider using a custom scope and using the list item's content class.  For example.

www.dotnetmafia.com/.../how-to-create-a-scope-for-a-custom-list-template-type.aspx

ListData.svc does not work with external lists in SharePoint foundation 2010 - i get a 404.

Hi Coreyroth,

Can you please tell  me how to remove DataAppearance & advance Properties from this webpart. My boss is impress but he don't want that

Pingback from  Twitter Trackbacks for                 How to: Build a SharePoint 2010 PowerShell Cmdlet - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi, I got the same problem as you, and searching for a solution.

I'm getting the same error when trying to use Microsoft.SharePoint.Portal.WebControls.TagCloudWebPart

It works fine if i do it via the web ui, but fails when using the ONET.XML for my sites.

Any ideas?

This post was mentioned on Twitter by coreyroth: #SharePoint Post: How to: Build a SharePoint 2010 PowerShell Cmdlet http://bit.ly/b0l6ww

Well done!

I agree with most the things you said.

I must admit, even tho I am not a big fan of twitter I always make sure the sharepoint experiences from my blog are also posted as tweets. You know.... visibility. :)

I follow people (like jeremy thake for example) but not keywords, so I am missing the job pool here probably.

Pingback from  Error in SSP accessing any search settings page &laquo; A Berkut&#039;s Blog

The differance here is that one is a SharePoint webpart and the other is a .NET web part.

The .dwp is a SharePoint web part.  This would be one like the Content Editor.

The .webpart is a .NET framework.

The primary differances are that the SharePoint webparts are built with backwards compatibility and more functionality in the web parts communitcation area.  If you needed a web part that worked in WSS 2.0 and WSS 3.0, this would be your guy.

The later is one that most likely originated in Visual Studio.

nice tip ! never knew this one.

Pingback from  Twitter Trackbacks for                 SharePoint Post: Slides from my talks at SharePoint Saturday Houston #SPSHOU         [dotnetmafia.com]        on Topsy.com

Hello,

I tried to make a chart with out of box chart webparts in sharepoint 2010.but i cant find the option to make a total of particular column.

i want to make a chart in which the total funding amount is displayed yearly basis,country wise and department wise.

India        146000

Education total=40000

2008        30000

2010        10000

Finance        total=42000

2008        42000

Health        total=64000

2008        52000

2010        12000

Grand Total 146000

i want my data as a total sum department wise(Group by Department),for particular company,

so this total amount should display in pie chart.

i m using sharepoint custom list to connect the chart.

i tried with sharepoint 2010 but cant find any solution

please help me

Thanks n regards

Hiren

hiren.patel@bitscape.co.in

Corey, I want to use this as a People Search and I have it working from my homepage with the default site search as it passes the S= query string for scope.

However, when you use this with a people search box there are a few options to pass scope as an appended query string, etc. but it doesn't seem to work. any ideas?

For instance, let us take a State List which holds all the states of India. States are grouped under different zones i.e. North, South, East & West. If I need to retrieve all the States for North zone then my SP Query would look somewhat like,

SPQuery stateQuery = new SPQuery();

stateQuery.Query =

"<Where><Eq><FieldRef Name=\"Zone\"/><Value Type=\"Text\">North</Value></Eq></Where>";

SPListItemCollection stateCol = StateList.GetItems(stateQuery);

In the code above the StateCollection object gets populated with the States only related to North zone. You can then bind this collection to a GridView or DataList or any other similar controls to view the actual values.

www.mindfiresolutions.com/Sharepoint-SPQuery-30.php

Hi Roth,

This is nice article, I have requirement where I need to create custom edit form sharepoint list(ex: Tasks list),

how I can achieve this functionality(I cann't use sharepoint designer) apart from designer is there any approach, please let me know.

regards

anand

Hi Corey,

Will the webpart work on 64bit architecture? I have run through the install and cant find the feature under Site Collection Features or Site Features?

It should.  Check your Solutions page in Central Admin and confirm that the solution package installed successfully.

The second problem of Visitors

Hi Corey,

I checked the solution page and found and error with the solution.

Access to the path 'C:\WINDOWS\TEMP\tmp42F.tmp' is denied.

<servername> : Access to the path 'C:\WINDOWS\TEMP\tmp42F.tmp' is denied.

I have tried to deploy the solution several times with different Administrator accounts and no joy.

Do you have any idea what i may be doing wrong?

i have service running in MMC and in CA as well. still when I try to add a sandboxed web part i get error message like " The sandboxed code execution request was refused because the Sandboxed Code Host Service was too busy to handle the request."

Please help me.

Rock on

Pingback from  Twitter Trackbacks for                 Simple network configuration in Sun VirtualBox - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

on Sharepoint RTM (May 2010) :

I 've been looking at chart element for a day and a half and haven't figured it out. I have a list of items (each has a title, a region, a dept and amount).

I have a view grouped by a field (region, or dept for example) looks right.

Now I want the chart to show me the rolled up view and it is not working!

Nice,

Find the detail notes on the developer dashboard in my point of view, this also may help.

praveenbattula.blogspot.com/.../developer-dashboard-in-sharepoint-2010.html

thanks

-Praveen

Pingback from  Life is Just a Bowl of SharePoint ??? Part 11: Creating Web Applications and Site Collections | EndUserSharePoint 2010

Hello,

I tried this command to install a BCS solution

Install-SPSolution –Identity SharePointProject2.wsp –WebApplication http://sp2010 -GACDeployment

but I gives me the next error "

This solution contains no resources scoped for a Web appli

cation and cannot be deployed to a particular Web application."

I tried with

Install-SPSolution –Identity SharePointProject2.wsp

–GACDeployment and I doesn't do anything. I checked and the solution it's not installed :(,

Can you help me pls with this ?

Thx,

Thank you.

Its really help me to solve the error.

As a complete SharePoint newbie, I needed more detail for your instruction to "start by copying your compiled DLL into the Global Assembly Cache of your SharePoint server".

In order to install my assembly into the GAC, I had to sign it.  In Project Properties, on the Signing tab, check the option for Sign the assembly, and enter a filename ending with the .snk file extension.  I didn't use the option to enter a password.

Awesome instructions!  VS 2008 really did make deployment easier.  This is probably the only time I'll deploy the "ghetto" (i.e. manual) way, but I am glad I've done it to help with troubleshooting.

Thanks!

@StephanieDeHart  Thanks for the feedback!

You're right, I guess I did make the assumption that the developer has some prior experience doing .NET applications.  Thanks for the good comments.  I'll probably include that point when I update the post.

Pingback from  Twitter Trackbacks for                 www.dotnetmafia.com/.../intro-to-sharepoint-development-how-to-build-and-deploy-a-web-part.aspx         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 Wildcard Search Web Part for SharePoint 2010 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi, is that definition is common to all site colection or may i define the search scopes list for each site dropdown?

in our case there are a few sites under the root and we want to configure the search box of each to display a different  list of scopes (so the sites under those sites will inherit from the parent site)

Pingback from  Twitter Trackbacks for                 How to: Create a OpenSearch Provider for SharePoint - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Corey thanks for the post, but my site is still not crawling. I get no messages in the Logs just the error above and this in the event viewer:

The start address <http://mossdev01:55555> cannot be crawled.

Context: Application 'SharedServices1', Catalog 'Portal_Content'

Details:

The object was not found.   (0x80041201)

I know my search service is working as external sites are crawling. Any ideas?

Interesting.  I assume if you hit http://mossdev01:55555, the site comes up alright?  Have you confirmed that your content access account has access to the site?  Make sure it is isn't an administrator account.

Thanks Corey. I was looking to do just this and this was a great help. One quick question though, how do you delete any file type. In the ExtensionCollection, I do not see any delete method. But there must be a way to do that.

<style type=text/css>

table table table table b a {display:none;}

</style>

Thank, i was wondering if the only way to use linq to sql is to use visual studio.  I don't like to use designer and let it generate the code.

Pingback from  VseWSS 1.3 CTP March 09 &#8211; Still Buggy

Thanks.  Didn't think to edit the file.

Hi Corey Roth,

This a great post and it help me a lot.

I have a requirement to override the Search Action Link Webpart in People Search. I want to add two more managed property to the DropDown so that I can sort on that.

I want to add LastName and FirstName to the dropdown with the existing Relevance,social distance and name

Can you help on that

Thank you very much for this valuable information!!!

This sounds good?

What about ASP.NET applications?

Where we can find Platform Target to change it?

Regards

Pingback from  Twitter Trackbacks for                 Using SPMonitoredScope to monitor performance of your code - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Just a suggestion. May it be, that you use SPList.Items unintentionally? You should not use this property, execpt you want to get all items in the list back. This one of many SharePoint API flaws.

This works great thanks! But for some reason when I do a search at the home page with the "all sites" option which has this filter it is not work. But everywhere else it seems to be work. Any ideas?

The only difference I see is the URL gets appended with &s=All+Sites.

Perfect, your was the only site that I found had to the point solution to this problem! Took me hours to find it but eventually got there :-) Cheers - Mithun

Is there an option to use either and both?

Hey there --

Really useful article. How would we do this, for instance, in conjunction with something like Content Type?

Thanks!

--Dave

@Dave - Content Type should be more than doable.  Try adding a Category and setting the Mapped Property to ContentType.  I'll try it when I get a chance, but if you happen to try it out, let me know if it works.  Thanks.

Hello,

I've tried this feature myself and still facing the same old issue as with MOSS2007 with multi-valued columns.  When I add a managed property in the refinement panel it works fine as long as it's not multi-valued. If it is, the list of all the values appears as one element of the facets, all values being separated with ';'

Realle saved me there - thanks a bunch

Dug for 20 minutes before I figured this out.  Was trying to figure out what the little arrow was about on the files.   Good blog entry.

I have the same issue as above

This solution contains no resources scoped for a Web application and cannot be deployed to a particular Web application.

Hi Corey,

Great web part - thank you for all your effort! We have been using this in our Production environment. Works great except we could not get the relevance to work properly. Is there something we are missing?

To give you an example with SharePoint default functionality if I'm searching for a keyword and there is a site by that name what would come ahead of a document in a library, right? But after installing this solution this is not the case any more. Is anyone else having similar issue?

Thank you for any suggestion.

Bright Sky

Hi!

I have Fast Search SErver for Sharepoint 2010, and I´ve noticed that this phonetic people search just works al Mozilla or Safari, no Internet Explorer!!!

Which Browser do you use???

thanks!!!

Great job man! It's been invaluable for me for use with scoped lists. I drop it just above the scoped list and it works great. Thanks!

Hmm, I've had no issue using IE so far.

Excellent, glad it works for you.

@BrightSky I'm sure this is because wildcard search uses a full text sql query.  With SharePoint 2010, I don't think this will be an issue for you.

actually you just need an empty <fieldrefs></fieldrefs> tag, with no fieldrefs in it to work.

Oh my god - I just spent a few hours trying to find this solution! - The german translation of the error speaks of a hostwebsite (ridiculously the error message is in english)

Thank you very much for finally giving me this :)

Pingback from  Sharepoint 2010 People Search &laquo; Sladescross&#039;s Blog

Hi,

How can I search for both keywords as well as managed properties in keyword query? Is this correct?

keywordQuery.QueryText = string.Concat(keywords + string.Format(" +Color:\"{0}\"","Red"));

where 'keywors' contains the string to be searched in all results where color=red.

Hi Corey,

I have a set of document libraries which in turn have the same set of folders. Is it possible to display the available folders in the Refinement Web Part under a category?

Hi Corey, great post! I followed your instructions and I can get the page with the feed but the individual list items will not show up. I assumed this was a Firefox thing and tried to use the same url in Internet Explorer 7 but I can't even get the page to load in Internet Explorer. Any suggestions?

Thanks Corey, it helped in preparing for my interview.

Hi,

I am facing problems adding my new Metadata property into this. I created a site column called "Year", added this to a document lib, entered value for the column in each item and then did a full crawl (in fact did a Crawl index reset too before running the full crawl). Now, I added one more category titled "Year" and set its mapped property to "Year". I made sure that the "Use default.." checkbox is unchecked and set the no of categories to display to 10. I added this category before the "Managed Metadata Columns" category. After done all that, I don't see this category appearing in the Refinement Panel.

Any idea whether I have missed something?

Thanks,

SPWeb.Groups will allow you to pull out only the groups which have some / any kind of permissions defined within the site.

SPWeb.SiteGroups will pull out all the cross-site groups irrespective of any permission defined.

thank you for this, but can you pls explain what each parameter means?

Like

psconfig means re-provision

-cmd upgrade obviously upgrade (but what?), etc...

I'm not familiar with the end "-inplace b2b -wait"

thank you very much

Raphael

help me please my memory card not showing my data

the error is parameter is incorrcert

Thanks Corey, really good article and quite useful. You show me the light XD

Hi Corey,

Any ideas how to set SPGroup as target audience in the code in this post ???

THanks,

Good walkthrough, covers it all. It looks i have the same issue as Mark. http://<sharepoint-server>/_vti_bin/ListData.svc works!!

But if I go to sp2010/.../Tasks it shows me the RSS feed Tasks without any items.

If I make a list in designer I only get the properties and still no items. Any ideas?

Après quelques longues semaines d’absence, voici le retour du post récurrent “Lien de la semaine”. SharePoint

Introduction With SharePoint 2010 you can now extend the out of the box web parts, which essentially

Excellent.  Glad I could help. :-)

@Sid To do a group, I believe you would change the format string to ";;;;{0}" where {0} would be the name of the SPGroup.  It might be the Id of the group instead, but I can't remember.  Try it out and confirm.  Let us know what you get.  Thanks.

Good tip!    Thanks, Corey!

Pingback from  Creating Crawled Properties &laquo; i:0#.f|SharePoint|Development

How can I use the Earlier Than and Later Tahn expressions in the KeywordQuery.KeywordQueryText syntax?

@Tom Those are only supported in SharePoint 2010.  If you are using SharePoint 2010, you simply use the > or < operators.  For example "write < '6/3/0/2010".

That's a bad news!  

Is there any way to achieve a similar filter effect in SharePoint 2007?  I'm developing a web part that basically creates a property search programmatically - it needs to replicate some of the capability of the advanced search property restrictions - so a typical query would be DocumentDate "Earlier Than" 7/2/2010. (DocumentDate is a custom Managed Property with a datetime data type).

Here is the code I have so far:

using System;

using System.Runtime.InteropServices;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data;

using System.Drawing;

using System.Xml.Serialization;

using Microsoft.SharePoint;

using Microsoft.SharePoint.WebControls;

using Microsoft.SharePoint.WebPartPages;

using Microsoft.Office.Server;

using Microsoft.Office.Server.Search.Query;

namespace CustomWebParts

{

   [Guid("01482ed3-b90c-428d-bacd-706267645f89")]

   public class CustomDateSearch : System.Web.UI.WebControls.WebParts.WebPart

   {

       Label lblDateSearch;

       Label lblQueryResults;

       DropDownList ddlYear;

       Button btnSearch;

       DateTime dtToday;

       DateTime dtPastYear;

       DateTime dtPast2Years;

       DateTime dtPast5Years;

       String strPastYear;

       String strPast2Years;

       String strPast5Years;

       String strSelectedValue;

       DataGrid grdResults;

       public CustomDateSearch()

       {

       }

       protected override void CreateChildControls()

       {

           base.CreateChildControls();

           //DateTime Variables

           dtToday = DateTime.Today;

           dtPastYear = dtToday.AddYears(-1);          

           dtPast2Years = dtToday.AddYears(-2);

           dtPast5Years = dtToday.AddYears(-5);

           //String Variables

           strPastYear = dtPastYear.ToString().Remove(10);          

           strPast2Years = dtPast2Years.ToString().Remove(10);

           strPast5Years = dtPast5Years.ToString().Remove(10);

           //Label

           lblDateSearch = new Label();

           lblDateSearch.Text = "Year Range Search: ";

           this.Controls.Add(lblDateSearch);

           //Drop Down List

           ddlYear = new DropDownList();

           ddlYear.Items.Add(new ListItem(" Select a Search Option", "0"));

           ddlYear.Items.Add(new ListItem(" Past Year", strPastYear));

           ddlYear.Items.Add(new ListItem(" Past 2 Years", strPast2Years));

           ddlYear.Items.Add(new ListItem(" Past 5 Years", strPast5Years));            

           this.Controls.Add(ddlYear);

           //Search Button

           btnSearch = new Button();

           btnSearch.Text = "Search";

           btnSearch.Click += new EventHandler(cmdSearch_Click);

           this.Controls.Add(btnSearch);  

           //Test Label

           lblQueryResults = new Label();

           lblQueryResults.ForeColor = Color.Red;

           this.Controls.Add(lblQueryResults);

       }

       void cmdSearch_Click(object sender, EventArgs e)

       {

           strSelectedValue = ddlYear.SelectedValue.ToString();

           if (strSelectedValue != "0")

           {

               lblQueryResults.Text = " ";

               keywordQueryExecute(strSelectedValue);

           }

           else

           {

               lblQueryResults.Text = "  *You Must Select a Search Option!";

           }          

       }

       private void keywordQueryExecute(string strQueryText)

       {

           KeywordQuery kRequest = new KeywordQuery(ServerContext.Current);

           string strQuery = "DocumentDate:" + "6/29/2009";

           kRequest.SelectProperties.Add("Title");

           kRequest.SelectProperties.Add("SiteName");

           kRequest.SelectProperties.Add("HitHighlightedProperties");

           kRequest.SelectProperties.Add("Path");

           kRequest.SelectProperties.Add("Author");

           kRequest.SelectProperties.Add("Write");

           kRequest.SelectProperties.Add("DocumentDate");

           kRequest.SortList.Add("DocumentDate", Microsoft.Office.Server.Search.Query.SortDirection.Ascending);

           kRequest.QueryText = strQuery;

           //Configure the query to return relevant results

           kRequest.ResultTypes |= ResultType.RelevantResults;

           //Execute the query

           ResultTableCollection resultsTbls = kRequest.Execute();

           if ((int)ResultType.RelevantResults != 0)

           {

               ResultTable tblResults = resultsTbls[ResultType.RelevantResults];

               if (tblResults.TotalRows == 0)

               {

                   lblQueryResults.Text = " *No Search Results Returned!";

               }

               else

               {

                   //lblQueryResults.Text = tblResults.TotalRows.ToString();

                   ReadResultsTable(tblResults);

               }

           }

       }

       void ReadResultsTable(ResultTable rt)

       {

           //Create a Data Table

           DataTable relResultsTbl = new DataTable();

           relResultsTbl.TableName = "Relevant Results";

           //Create a Data Set, add the Data Table to the Data Set, Load Data into the Data Table

           DataSet ds = new DataSet("resultsset");

           ds.Tables.Add(relResultsTbl);

           ds.Load(rt, LoadOption.OverwriteChanges, relResultsTbl);

           //Add the Data Set to the Data Grid (Display)

           fillResultsGrid(ds);

       }

       private void fillResultsGrid(DataSet grdDs)

       {

           //Create an instance of the DataGrid and set its

           //DataSource property to the supplied DataSet

           grdResults = new DataGrid();

           grdResults.DataSource = grdDs;

           //Set the display properties in the data grid

           grdResults.GridLines = GridLines.None;

           grdResults.CellPadding = 4;

           grdResults.Width = Unit.Percentage(100);

           grdResults.ItemStyle.ForeColor = Color.Black;

           grdResults.ItemStyle.BackColor = Color.White;

           grdResults.ItemStyle.Font.Size = FontUnit.Smaller;

           grdResults.ItemStyle.Font.Name = "Tahoma";

           //Set the display properties in the data grid Header

           //grdResults.HeaderStyle.BackColor = Color.Navy;

           //grdResults.HeaderStyle.ForeColor = Color.White;

           //grdResults.HeaderStyle.Font.Bold = true;

           //grdResults.HeaderStyle.Font.Name = "Tahoma";

           //grdResults.HeaderStyle.Font.Size = FontUnit.Medium;

           //Turn off AutoGenerate for the columns so that not all columns are returned

           //grdResults.AutoGenerateColumns = false;

           grdResults.AutoGenerateColumns = true;

           //DataGrid configured to display only the desired columns

           //Site Name

           HyperLinkColumn colSite = new HyperLinkColumn();

           //colSite.HeaderText = "Site Name";

           colSite.DataTextField = "Title";

           colSite.DataNavigateUrlField = "SiteName";

           grdResults.Columns.Add(colSite);

           //***Hit HighlightedProperties is not showing up!!! - Bug Fix

           //Highlight

           BoundColumn colHighLight = new BoundColumn();

           //colHighLight.HeaderText = "HitHighlightedProperties";

           colHighLight.DataField = "HitHighlightedProperties";

           grdResults.Columns.Add(colHighLight);

           //Path

           HyperLinkColumn colPath = new HyperLinkColumn();

           //colPath.HeaderText = "Path";

           colPath.DataTextField = "Path";

           colPath.DataNavigateUrlField = "Path";

           colPath.ItemStyle.ForeColor = Color.Green;

           grdResults.Columns.Add(colPath);

           //Author

           BoundColumn colAuthor = new BoundColumn();

           //colAuthor.HeaderText = "Author";

           colAuthor.DataField = "Author";

           colAuthor.ItemStyle.ForeColor = Color.Gray;

           grdResults.Columns.Add(colAuthor);

           //Write - Created Date

           BoundColumn colWrite = new BoundColumn();

           //colWrite.HeaderText = "Write";          

           colWrite.DataField = "Write";

           colWrite.ItemStyle.ForeColor = Color.Gray;

           colWrite.DataFormatString = "{0:d}";

           grdResults.Columns.Add(colWrite);

           //DocumentDate

           BoundColumn colDocDate = new BoundColumn();

           //colDocDate.HeaderText = "DocumentDate";

           colDocDate.DataField = "DocumentDate";

           colDocDate.ItemStyle.ForeColor = Color.Gray;

           colDocDate.DataFormatString = "{0:d}";

           grdResults.Columns.Add(colDocDate);

           //Bound the data to the DataGrid

           grdResults.DataBind();

           Controls.Add(grdResults);

       }

   }

}

@Tom Try using a FullTextSqlQuery instead.  It allows you to do comparisons, but it may take some trial and error on your part.

www.dotnetmafia.com/.../how-to-use-the-moss-enterprise-search-fulltextsqlquery-class.aspx

Hi, I liked your article as its very informative, I came accross this one as I was looking for a solution to my problem.  

So I retried doing my external list and do this your way according to your post as I might have done somthing wrong along the way, everything seems to be fine but I still have my issue which is if I go the my external list now it gives me this error.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Do you knwo why its doing this?  I hope you could help.

I'm facing with the same issue as Herve; when i use a multi valued column in the refinement webpart,  the list of all the values appears as one element of the facets, all values being separated with ';'.

Do you have any idea to fix the problem ?

Same problem as Hervé and Veronique, multichoice fields shows up as value1;value2;value2 in the refinement control.

If i look at the source from the core search webpart i see that my multichoice fields are returned in the xml, but i cant set the refinement control to the those fields fieldname_multivalue.

Anyone got any trix up their sleves?

Is there a way to programmatically invoke your wild card search web part?  I was thinking of doing a wild card search - like "DocumentDate: *" and then filtering the results with a for loop before displaying in a Datagrid.

@Tom I don't think you could invoke it that way.  I think your best bet for the wildcard search is to use the FullTextSqlQuery and then you can bind it to your datagrid.

@Veronique @Jason @Herve Honestly, I haven't tried it with a multi-valued field yet.  I suspect it might be necessary to write a custom filter though.  I'll look into it when I get a chance.

Random question.. what made you decide to use VirtualBox for your VMs instead of Microsoft Virtual PC or VMWare?  

I'm wondering if I should consider switching.. I currently use Virtual PC on my work laptop and VMWare Fusion at home on my Mac.  

Pingback from  We Know Nothing  &raquo; Blog Archive   &raquo; People search not working in SharePoint 2010

How do you do this in SharePoint 2010?

The function below is obsolete in 2010;

Microsoft.Office.Server.ApplicationRegistry.GetLobSystemInstanceByName("MyInstance");

@Veronique, Jason and Corey. I'm still stuck with this issue. I've tried to implement my own custom filter generator but without any success ... more details on

social.msdn.microsoft.com/.../153190c2-de42-48c6-984c-a952971d5c7d

Pingback from  Twitter Trackbacks for                 Using PowerShell to import test users into Active Directory - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

I had the same error.

After restarting the office sharepoint search service from CA.

I restarted the "Office sharepoint search service"  from Control Panel. ,

Thanks

Asma

They also seem to have changed the default network card to one the Server 2008R2 doesn't seem to know.

It really hasn't taken Oracle very long to trash a brilliant product.  I wonder (I don't really as we all know) what there motivation could be for making it not work so well

Hi,

no matter what STS_* i put i get 0 result .

i have 22000 item crawled.

Any ideas?

Boy, am I glad I'm not the only one. I have been receiving the same performance issues on v 3.2.4. I'll download v 3.1.8 and will let you know how it goes.

Cheers

Hi Corey - I'd reeeaaaaallllly appreciate your help ;-)

2 questions:

1. I'm noticing the wildcard is not working at the beginning of the search term.  So if say I type "S29*", I get results, but if I type "*29", I do not get results.  Is there a specific property (or even piece of code) I can modify to rectify this?

2. I have a search scope that is all PDF documents.  Is there a way to make the wildcard  search prioritize  a specific column, in this case the document Title, so that matches on the title are prioritized over matches on the document's content?

Thanks much, and thanks for the great web part!

*Mike*

Pingback from  | Randomizzzer | Debugging SharePoint 2010 SandBoxed applications created in VS2010 |

Hey Corey,

You were right, I used the FullTextSQL Query Class along with the DATEADD function and I got the results I wanted.  My updated code is below:

using System;

using System.Runtime.InteropServices;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Data;

using System.Drawing;

using System.Xml.Serialization;

using Microsoft.SharePoint;

using Microsoft.SharePoint.WebControls;

using Microsoft.SharePoint.WebPartPages;

using Microsoft.Office.Server;

using Microsoft.Office.Server.Search.Query;

namespace CustomWebParts

{

   [Guid("01482ed3-b90c-428d-bacd-706267645f89")]

   public class CustomDateSearch : System.Web.UI.WebControls.WebParts.WebPart

   {

       Label lblDateSearch;

       Label lblQueryResults;

       DropDownList ddlYear;

       Button btnSearch;

       DateTime dtToday;

       DateTime dtPastYear;

       DateTime dtPast2Years;

       DateTime dtPast5Years;

       String strToday;

       String strPastYear;

       String strPast2Years;

       String strPast5Years;

       String strSelectedValue;

       String strSelectedItem;

       public CustomDateSearch()

       {

       }

       protected override void CreateChildControls()

       {

           base.CreateChildControls();

           //DateTime Variables

           dtToday = DateTime.Today;

           dtPastYear = dtToday.AddYears(-1);          

           dtPast2Years = dtToday.AddYears(-2);

           dtPast5Years = dtToday.AddYears(-5);

           //String Variables

           strToday = dtToday.ToString().Remove(9);

           strPastYear = dtPastYear.ToString().Remove(9);          

           strPast2Years = dtPast2Years.ToString().Remove(9);

           strPast5Years = dtPast5Years.ToString().Remove(9);

           //Label

           lblDateSearch = new Label();

           lblDateSearch.Text = "Year Range Search: ";

           this.Controls.Add(lblDateSearch);

           //Drop Down List

           ddlYear = new DropDownList();

           ddlYear.Items.Add(new ListItem("Select a Search Option", "0"));

           ddlYear.Items.Add(new ListItem("Past Year", strPastYear));

           ddlYear.Items.Add(new ListItem("Past 2 Years", strPast2Years));

           ddlYear.Items.Add(new ListItem("Past 5 Years", strPast5Years));            

           this.Controls.Add(ddlYear);

           //Search Button

           btnSearch = new Button();

           btnSearch.Text = "Search";

           btnSearch.Click += new EventHandler(cmdSearch_Click);

           this.Controls.Add(btnSearch);  

           //Test Label

           lblQueryResults = new Label();

           lblQueryResults.ForeColor = Color.Red;

           this.Controls.Add(lblQueryResults);

       }

       void cmdSearch_Click(object sender, EventArgs e)

       {

           strSelectedValue = ddlYear.SelectedValue.ToString();

           strSelectedItem = ddlYear.SelectedItem.ToString();

           if (strSelectedValue != "0")

           {

               lblQueryResults.Text = " ";

               fullTextSqlQueryExecute(strSelectedItem);

           }

           else

           {

               lblQueryResults.Text = "  *You Must Select a Search Option! " + strSelectedItem;

           }          

       }

       private void fullTextSqlQueryExecute(string strQueryText)

       {

           FullTextSqlQuery ftQuery= new FullTextSqlQuery(ServerContext.Current);

           if (strQueryText == "Past Year")

           {

               ftQuery.QueryText = "SELECT Title, Description, Write, HitHighlightedProperties, Author, Path, DocumentDate FROM SCOPE() WHERE DocumentDate >=DATEADD (Year, -1, GETGMTDATE())";

           }

           else if (strQueryText == "Past 2 Years")

           {

               ftQuery.QueryText = "SELECT Title, Description, Write, HitHighlightedProperties, Author, Path, DocumentDate FROM SCOPE() WHERE DocumentDate >=DATEADD (Year, -2, GETGMTDATE())";

           }

           else if (strQueryText == "Past 5 Years")

           {

               ftQuery.QueryText = "SELECT Title, Description, Write, HitHighlightedProperties, Author, Path, DocumentDate FROM SCOPE() WHERE DocumentDate >=DATEADD (Year, -5, GETGMTDATE())";

           }

           ftQuery.ResultTypes = ResultType.RelevantResults;

           ResultTableCollection oResultCollection = ftQuery.Execute();

           if ((int)ResultType.RelevantResults != 0)

           {

               lblQueryResults.Text = " Results Returned: ";

           }

           else

           {

               lblQueryResults.Text = " No Results Returned ";

           }

           // Execute the query and load the results into a datatable //

           ResultTable oResult = oResultCollection[ResultType.RelevantResults];

           DataTable dtResults = new DataTable();

           dtResults.TableName = "Result";

           dtResults.Load(oResult, LoadOption.OverwriteChanges);

           DataSet ds = new DataSet("All_Results");

           ds.Tables.Add(dtResults);

           DataGrid datagrid = new DataGrid();

           datagrid.DataSource = ds.Tables[0];

           //General Datgrid Formatting

           datagrid.GridLines = GridLines.None;

           datagrid.CellPadding = 4;

           datagrid.Width = Unit.Percentage(100);

           datagrid.ItemStyle.ForeColor = Color.Black;

           datagrid.ItemStyle.Font.Size = FontUnit.Smaller;

           datagrid.ItemStyle.Font.Name = "Tahoma";

           datagrid.AutoGenerateColumns = false;

           //Document Name Link

           HyperLinkColumn colDocNameLink = new HyperLinkColumn();

           //colSite.HeaderText = "Site Name";

           colDocNameLink.DataTextField = "Title";

           colDocNameLink.DataNavigateUrlField = "Path";

           datagrid.Columns.Add(colDocNameLink);

           //Document Name

           BoundColumn colDocName = new BoundColumn();

           //colSite.HeaderText = "Title";

           colDocName.DataField = "Title";

           datagrid.Columns.Add(colDocName);

           //Highlight (No Data Shows!)

           BoundColumn colHighLight = new BoundColumn();

           //colHighLight.HeaderText = "HitHighlightedProperties";

           colHighLight.DataField = "HitHighlightedProperties";

           datagrid.Columns.Add(colHighLight);

           //Path

           HyperLinkColumn colPath = new HyperLinkColumn();

           //colPath.HeaderText = "Path";

           colPath.DataTextField = "Path";

           colPath.ItemStyle.ForeColor = Color.Green;

           colPath.DataNavigateUrlField = "Path";

           datagrid.Columns.Add(colPath);

           //Author

           BoundColumn colAuthor = new BoundColumn();

           //colAuthor.HeaderText = "Author";

           colAuthor.DataField = "Author";

           colAuthor.ItemStyle.ForeColor = Color.Gray;

           datagrid.Columns.Add(colAuthor);

           //Document Date

           BoundColumn colDocDate = new BoundColumn();

           //colAuthor.HeaderText = "Author";

           colDocDate.DataField = "DocumentDate";

           colDocDate.DataFormatString = "{0:d}";

           colDocDate.ItemStyle.ForeColor = Color.Gray;

           datagrid.Columns.Add(colDocDate);

           //Bind and Add

           datagrid.DataBind();

           Controls.Add(datagrid);

       }      

   }

}

Thanks Corey!

Tom

@Tom Excellent!  Glad I could help.

@Remsal Unfortunately, the wildcard search web part doesn't work well with the Advanced Search web part.

@Mike So unfortunately, SharePoint 2007 doesn't support prefix matching like you are describing.  The only way to get that is to use FAST in SharePoint 2010.

As far as your PDF issue.  I think you could achieve that, but it would require you make some code changes to the Wildcard Search web part to tweak the Full Text SQL Query.

@Mark After further research, I have noticed performance improve some in 3.1.8.  A colleague of mine went all the way back to 2.2 to improve performance.  However, the latest thing I have noticed is that emulating one virtual CPU runs much better than emulating multiple.

Hey Corey,

Do you know how to add the document Icon to the search results\data grid?  

Tom

Thanks so much for the response, Corey.   Seems like we'll have to maybe create a new property with part number that excludes the prefix.

As far as the PDF issue, I'm happy to tweak the code in the web part.  ANy suggestions?  I know this is like asking for free consulting, so no worries if you don't have time for this ;-p

very best,

Mike

@Mike Get familiar with the Full Text SQL Query syntax.  It shouldn't take long, it's very similar to T-SQL.  Then, you can edit the code of the WildcardSearchWebPart and change the query so that it just searches the Title field.  It shouldn't be too difficult.

@Tom I'm not exactly sure how the CRWP gets it, but it uses a field called imageurl.  It's not listed as a managed proeprty but it may be reserved/hidden.  Otherwise try PictureThumbnailURL and see if that gets you anywhere.

THANKS!!!!!!

Hi,

Good article!

Do you know how to do this en vb.net?

ranouf

Sorry, one more question -- can specific custom managed properties or columns be specified in the Full Text SQL Query?  So I could specify to search, say, only "Title" and "MyCustomProperty"??

@Mike Yes that is correct.  You can specify multiple properties using AND/OR and have the query search just those properties.

Pingback from  Twitter Trackbacks for                 Slides from my talks at NWA TechFest - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hey Corey,

Using SearchCoder I can tell that PictureThumbnailURL just returns a null value.  This seems to be one of those many unsolved problems with MOSS customization as evidenced by the many unanswered Blogs out there, like these two below:

www.eggheadcafe.com/.../custom-search-document-ic.aspx

www.itweb.co.za/.../index.php

This blog seems to provide an answer, but I'm not sure how to incorporate the answer provided into the datagrid I'm using, here's the blog:

social.msdn.microsoft.com/.../a16429ce-345b-444f-a386-92718675536f

Anyway, I'm still stumped on this one, any code examples would be greatly appreciated.

Tom

Hi Corey, thanks so much for this greate web part & article.

But I am searching same soultion for "People Search"; yes as you said people search uses PeopleCoreResultsWebPart instead of CoreResultsWebPart.  

And as you said earlier, have you released this feature for People Search at Codeplex? if not, can you please let me know what would be the relatively easy to implement?

once again, thanks for the great web part & article.

Pingback from  Twitter Trackbacks for                 Speaking about PowerShell tonight at Tulsa SharePoint Interest Group - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

@Senthil Unfortunately, People Search can't be inherited and so there is no clear way to implement it in 2007.  There may be some hope for 2010, but that is yet to be determined.

I landed on this blog Googling high CPU util in virtualbox. I'm experiencing the same issue described here, but with a twist. i built a fresh Ubuntu 10.04 VM with VirtualBox on XP. At first, performance seemed find. On the third boot or so, cpu utilization spiked. Actually, the whole boot sequence slowed way down, even before getting to OS load.

The Host OS is idle. The only thing using any significant CPU is VirtualBox. There's no resource contention on the Host and I'm only running one VM.

So, to make things even weirder. I tried restarting the guest several times, and on one reboot, it came up speedy. CPU utilization in the guest was fine. I'm talking about a twenty second boot sequence instead of five minutes. I was able to reproduce this once more, but now I'm unable to get it to go fast again.

Very quirky indeed. I'm going to try downgrading to 3.18 and see if that's better.

Thanks, it resolve my issue :)

Right, so I've setup a VM in Virtual box 3.1.8. Emulating one CPU has worked ok but the performance could be better. I can hardly access SharePoint 2010 once I allocate multiple CPUs to the guest.

I then tried VMware Player and have received excellent performance with multiple CPUs. VMware Player is free but can only be used in a personal capacity (i.e. non-commercial)

The reason for not using Virtual PC is that it does not support 64-bit software. The VM I needed to create included Win 2008 R2 Enterprise, SharePoint 2010 Enterprise, SQL 2008 R2 Enterprise, PowerPivot add-ins for SharePoint and MS Office 2010.

@Mark I'm pretty much in the same boat.  I never had an issue on my previous VMs hosted on my last computer, but since i have received this new laptop and installed SharePoint on the same base VM as before, performance isn't great.  

One CPU is somewhat tolerable, but the CPU still spikes out easily (just by submitting a single page request).

So next on my list is try version 2.2 as my colleague had or try VMWare Player (which I'm not a huge fan of).

@Keren Scope Display Groups are defined at the site collection level.  Any sites under them can use those groups that you defined.

I decided to downgrade again to 3.0.14 and can I say the performance difference is significant.  3.0.14 performs way better than anything else I have tried so far.  My CPU utilization actually hits 0% at times.  I've never seen it below 30% ever on any of the other builds I have tried.  I'm hoping it stays that way, but it has been working pretty well so far today.

Pingback from  Twitter Trackbacks for                 Using Visual Studio 2010 SharePoint Templates to deploy a web part in SharePoint 2007 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi folks,

thanks a lot for sharing this. Does anybody know if this webpart allows for the display, in brakets, of the total number of hits per faced value (e.g. Excel (50) )?

Thanks

@Lorenzo Only if you are using FAST.

Pingback from  Twitter Trackbacks for                 Visual Web Parts in MOSS 2007 - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

I too changed the Service Account for the

Thank you, this is a very good tip!

Really it was a nice article attractive , I will try it .

any way thnx alot amn

Pingback from  Twitter Trackbacks for                 SharePoint Post: How to: Set Default Column Values on a folder programmatically         [dotnetmafia.com]        on Topsy.com

How would you specify specific doc types from the query?  E.g:

<QueryText language='en-US' type='STRING'>sharepoint filetype:'pdf'</QueryText>

This does not work!

Thanks Corey.

I've been spending way too much time on getting my custom master page to apply to my team sites.

I've turned on the publishing feature using feature stapling and that works fine but the master page that I've created (nothing more than a tweaked theme and two images) only ever render on the Site Settings page of my team sites.

If I open SharePoint designer and look at the Master Page gallery for a team site my custom master page isn't in there. Makes sense.

But why, if I go into the master page gallery from the team site (with publishing enabled) do I see the Site Collection master page gallery but can't apply my master page to the site properly.

I'm trying to create a duplicate environment to see if it's a problem with this specific build but I think the fact that I can't see the master page in the team site's local gallery is a big hint.

How do I get it there and how do I get this to propagate to all ne team sites?

Sorry for writing War & Peace.

N03L.

@Ian Enterprise Search does not like single quotes.  Replace with a quote (") and you should be good.  Since you're dealing with a string you will probably have to use \" to delimit it properly.

@N03L So you are deploying the master page via feature using the module element I assume?  That should work.  Have you checked the approval status on the page?  Maybe for some reason it's not checked in and approved.

Pingback from  Twitter Trackbacks for                 Bringing my PowerShell talk to Oklahoma City next Monday - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 Some handy keywords you might find useful in SharePoint Enterprise Search - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Using Visual Studio 2010 SharePoint Templates to deploy a web part &#8230; | Learn Visual Studio

Pingback from  VentsThoughtsAndIdeas  &raquo; MOSS 2007: The search service is currently offline. Visit the Services on Server page in SharePoint Central Administration to verify whether the service is enabled. This might also be because an indexer move is in progress

Pingback from  Twitter Trackbacks for                 SharePoint Buzz - How to: Change your namespace in a Silverlight application without breaking everything         [dotnetmafia.com]        on Topsy.com

really good post mate

Why not give it the correct name in the first place????

@michaud Well of course you can.  However, I've been in scenarios where people want the project folder names a certain way (i.e.: they set up a tree instead of naming it after the namespace).  And then again sometimes people just change their minds. :-)

Add-SPSolution can take the solution in the current folder if you specify the $(Get-ChildItem <path>) as the LiteralPath. For example:

Add-SPSolution -LiteralPath $(Get-Childitem mysolution.wsp)

@Martin Good to know.  Thanks for the tip.

@Chris @ynuska If your project doesn't have any features scoped for a specific web application, use the -AllWebApplications parameter instead of the -Url parameter.

Hi,

I'm really happy to found your information, that it is not all about me. My MSFT IW 2010-7a images are working *incredible* slow. 4 cores and 8GB attached :-/

Only reason that I didn't run Hyper-V is that my new HP 8540w seems to have an issue with i7 CPU running Hyper-V.

Throwing BSoD: “A clock interrupt was not received on a secondary processor within an allocated time”

I just need a working virtualization.. sigh

(=PA=)

Is the Central Administration -> Web Application General Settings located on the server box? or can I access it from a non local machine?

You can access it from a remote box if you know the URL and port to your central administration site.

According to the link "technet.microsoft.com/.../cc263093.aspx"

psconfig is for MOSS 2010 but I am facing this error on MOSS 2007 so guys is there any alternative command for MOSS 2007.

Thanks, Corey.  This is a help!

After setting this up, however, I'm not receiving any message when no results are found.  Any way I can rectify this?

Thanks in advance

Hello  i use SP Foundation 2010.

I have a problem with the search Webservice.

I become no results with this sourcecode

Where is the error?

Can you help me?

thx!

Suche123.QueryService test = new Suche123.QueryService();

           test.Credentials = CredentialCache.DefaultCredentials.GetCredential(new Uri(test.Url), "NTLM");

           test.PreAuthenticate = true;

if (!test.Status().Equals("ONLINE")) {

return;

}

               StringBuilder queryXml = new StringBuilder();

               queryXml.Append("<QueryPacket xmlns=\"urn:Microsoft.Search.Query\" Revision=\"1000\">");

               queryXml.Append("<Query domain=\"QDomain\">");

               queryXml.Append("<SupportedFormats>");

               queryXml.Append("<Format>");

               queryXml.Append("urn:Microsoft.Search.Response.Document.Document");

               queryXml.Append("</Format>");

               queryXml.Append("</SupportedFormats>");

               queryXml.Append("<Range>");

               queryXml.Append("<Count>50</Count>");

               queryXml.Append("</Range>");

               queryXml.Append("<Context>");

               queryXml.Append("<QueryText language=\"en-US\" type=\"STRING\">");

               queryXml.Append("");

               queryXml.Append("</QueryText>");

               queryXml.Append("</Context>");

               queryXml.Append("</Query>");

               queryXml.Append("</QueryPacket>");        

           string resultXml2 = "";

           var queryResults = new System.Data.DataSet();

            resultXml2 = test.Query(queryXml.ToString());

            queryResults = test.QueryEx(queryXml.ToString());

            DataGrid1.DataSource = queryResults.Tables[0];

           DataGrid1.DataBind();

@Raheel psconfig has been around a long time (including in 2007).  I would give it a try.  It seems to fix the issue for people a lot.

How can I use master pages to create a template in a wiki site? Do i have to switch to 2010 enterprise? It also seems that the only way I can add to the master pages is to upload a document where should create this document?

I am trying to create a wiki glossary.

Dear All,

I really appriciate the effort of CoreyRoth. I face same problem as you all. I made little chnage in the script and it is now working on version office 2007 as wel as on version office 2003.

<div class="srch-Description">

<a onclick="return DispEx(this,event,'TRUE','FALSE','FALSE','','0','SharePoint.OpenDocuments','','1','','1','0','0','0x7fffffffffffffff')" onfocus="OnLink(this)" href="{$url}">Edit Document</a>

   </div>

i'm trying to add a custom property which is a managed metadata. it's named "Product" and in the central admin managed properties i see it as "owstaxIdProduct". what is the syntax to add in the refinement panel web part? i tried to set that name as you did with "Author". what's the difference between "Title" to "Mapped Property"?

thanks

Hi Corey, do you know if it 's possible to configure a custom managed property and get that property to appear in the RSS XML-file? Or is RSS too rigid for that? thanks!

I haven't been able to figure out a way to get it to show up in the RSS results.  I think it may be possible but I need to look into it more.

@Somesh.  Thanks for the update on the script to work in Office 2003;

@keren.  I'm not sure if I am understanding your question right or not, but the Refinement Panel already has a managed metadata filter on it by default.  The field it uses is ows_MetadataFacetInfo

Pingback from  Twitter Trackbacks for                 Creating Enterprise Search Scopes with PowerShell - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

I've been experiencing the same problem, and came up with a workaround: stop and disable the SharePoint Server Search service. My development doesn't rely on search, so I'm okay for now.  CPU utilization and disk read/writes down to such a degree that the VM is actually comfortable to use.

Chris

Pingback from  Twitter Trackbacks for                 Missing Tag Cloud Web Part (and other Social Web Parts) after SharePoint 2010 Upgrade - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi Corey, thanks for this blog post, good stuf..

Do you know the powershell command/s to use to update the display groups after successfully creating a search scope?

Thanks,

Pete

@Peter I don't believe there is one.  I've got an idea though.  Give me a bit and I'll have something for you.

@Peter  Ok, you inspired me.  I created some cmdlets to create scope display groups.  Check out the following post.

www.dotnetmafia.com/.../introducing-the-sharepoint-powershell-community-toolkit.aspx

Pingback from  Twitter Trackbacks for                 Introducing the SharePoint PowerShell Community Toolkit - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Thanks Corey.  This looks fantastic.  I'll give it a whirl.  What a turnaround!

Corey, I downloaded the Codeplex tookit and tried it out, great stuff!  

I then went back and read your blog post on creating cmdlet's and had a crack myself at a couple for the toolkit if you'd like (and which have helped me out for my current work)...  I saw you noted them as possible Future Commands.   I've created : Remove-SPEnterpriseSearchQueryScopeDisplayGroupScope (simply removes a scope from a given display group) and Get-SPEnterpriseSearchQueryScopeDisplayGroup (returns a display group to work with).

Cheers

Pete

@Peter That's excellent.  I was actually planning on writing those two commands tonight so thanks for saving me the time. :-)

I don't have the code set up in TFS yet, so if you want to just post the snippets to a discussion on CodePlex or ping me on twitter and I'll shoot you my E-mail address and I'll get them included in the build.

Thanks,

Corey (@coreyroth)

Hi Corey, I've just added the code as a discussion on CodePlex... if you could run your eye over it and make any updates as you wish.

I made another small change to the New-SPEnterpriseSearchQueryScopeDisplayGroupScope cmdlet also, just to check if the scope already exists in the display group first.  I'll add this as a discussion item also.

// add the scope to the display group if it hasn't already been added

           if(!scopeDisplayGroup.Contains(scope))

               scopeDisplayGroup.Add(scope);

Thanks,

Pete

Pingback from  Twitted by JimPoshible

Has anyone tested 3.2.8 to see if this is fixed. I know you are all dying to leave your reliable 3.0.14 :)

@Nicholas Nope!  I haven't tried it yet.  Would love to have some of the 3.2.8 features but I am afraid to break what I have that is working. :-)  If anyone tries it, please give us a report.

I just tried it and it seems pretty good. Only issue is Oracle seems they can't get their head of their butt on the monitor issues. Only issue I have now is on a second monitor full screen does not work. But it does seem speedy with no thrashing. Woot!!!

@Nicholas Hey, that's good news!  Of course I thought that things were working good with specific versions before. :-)  I may still give it a try soon.  Thanks for the report.

Hello Corey,

Thanx for you article.

i have a requirement where i have to search data across multiple site collections. so thought of creating search scopes.but am facing an issue when defining the search scope for different site collections in our site. it is not showing any item count.

its working fine in my local environment but failed in production.

Do in need to activate any features?

Pls tell me what would be the issue.

@prathima How are you defining each scope? by using a URL to each site?  Do search results work normally if you don't use any scope?  If you are using alternate access mappings on your server then you may need to change the URL that you specify in the scope.

Pingback from  Twitter Trackbacks for                 Creating a Content Source Scope Rule using PowerShell - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Pingback from  Twitter Trackbacks for                 SharePoint PowerShell Community Toolkit Updated - Corey Roth - DotNetMafia.com - Tip of the Day         [dotnetmafia.com]        on Topsy.com

Hi,

I'm looking in changing max upload file size in SharePoint, but I don't want to set up on global level, but rather on site level or even better on list level. I want only for one list to be able to upload files bigger than 50mb. Is this possible?

Best regards,

Pingback from  Sharepoint Security Blog on: Charlie Smith: A simple way to programmatically create SharePoint security groups &#8211; Corey Roth &#8211; DotNetMafia.com &#8211; Tip of&#8230; | Social Networking &amp; Digital Collaboration news, tips, guides...

Hi!

Very good post, thank you for that. But still, you searched for Mike's phone number and didn't find any. Nor does this organization browser show any important information.

Is it possible to show phone numbers in search results or in organization browser somehow?

Thanks.

Allright, I got it. Search results will show phone numbers once they're indexed, but organization browser still doesn't.

Hmm.  I don't think there is anything built-in for that.  You might be able to write an ItemEventReceiver that checked the file size and reacted accordingly but that would be after the file got uploaded.

@Silver Yes, you should be able to show the phone number in your results after it is indexed as you mentioned.  I don't know of any way to customize the organization browser (not saying it isn't possible though).

Cory,

Great article!  With the information above I was able to add a new scope for a content source but I can't seem to get a subset of results back for just the specified content source/scope.  Instead I get results back from all content sources.  It is like it is ignoring my scope when I select it next to the search box in the Fast Search Center site.

I have enabled the scope dropdown in the UI and it shows my new scope.  I have verified that ContentSource is a Managed Property/Crawled Property (FAST SearchAdmin >> Managed Properties).  Any thoughts?  Here is the commands I used to create my scope and rule:

$searchapp = Get-SPEnterpriseSearchServiceApplication "FASTQuerySSA"

$scope = New-SPEnterpriseSearchQueryScope -Name "ContentSrcScope" -Description "A scope for a single content source" -SearchApplication $searchapp -DisplayInAdminUI $true

New-SPEnterpriseSearchQueryScopeRule -RuleType PropertyQuery -ManagedProperty ContentSource -PropertyValue "ContentSrc" -FilterBehavior Include -url http://sp2010.domain.com -scope $scope -SearchApplication $searchapp

So your content source is called ContentSrc correct? What does it look like in the UI, does the scope rule show created.  Is there an error next to the scope?  If so, does it go away after compiling the scope rules?  I haven't tested my script in FAST yet, but it should be the same.  I'll try it when I get a chance.

Update:  Even though I can see the new scope in my scopes drop down, when I run the command Get-SPEnterpriseSearchQueryScope the CompilationState is still QueryExpanded and it shows that theLastCompilationTime is 1/1/0001.  Meaning it hasn't been compiled yet.  Could this be my problem?  If so how do you force a compile?