Robert J Wheeler - All Comments

re: Adding file shares to Enterprise Search

Dan Alexander — Wed, 24 Sep 2008 13:12:14 GMT

I've managed to configure my Enterprise Search to index a file share on a different server. How can I get SharePoint to use the filesystem properties such as "Keywords", "Categories" and "Description" fields within those files?

Posted on SharePoint Blogs

re: Building A Dynamic CAML Query

sondergaard — Mon, 30 Jun 2008 08:59:01 GMT

Great stuff!

Heads-up: Getting more conditions in a query is a bit tedious. Here's a good explanation:

sharepointsharpener.wordpress.com/.../several-ands-in-a-caml-query

Posted on SharePoint Blogs

re: Building A Dynamic CAML Query

yhyuiyui — Fri, 09 May 2008 10:21:55 GMT

yiyuiyiyui

Posted on SharePoint Blogs

re: Building A Dynamic CAML Query

Mike — Fri, 11 Apr 2008 15:18:37 GMT

I wrote them a while back.

Posted on SharePoint Blogs

http://www.sharepointblogs.com/wheeler/archive/2007/08/23/create-wizards-in-sharepoint.aspx

Sun, 23 Mar 2008 07:23:21 GMT

Pingback from www.sharepointblogs.com/.../create-wizards-in-sharepoint.aspx

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Kevin — Tue, 18 Mar 2008 11:56:18 GMT

In regards to indexing file shares on other domains, I can successfully MAP a drive from my SharePoint server to the other domain/share using an account on the remote domain. However, I STILL get "Access Denied" in SharePoint. Any ideas?

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Peter — Tue, 11 Mar 2008 23:58:11 GMT

It seems that this blog is as close as I have seen to getting an answer to the question "If you index documents on a shared drive, are the results security trimmed in the SharePoint search interface". But the answer still doesn't seem to be documented anywhere! If anyone can solve this mystery it would be greatly appreciated.

Posted on SharePoint Blogs

re: How To Access the Controls In A Master Page

Kerray — Mon, 10 Mar 2008 13:04:41 GMT

Thanks for this

btw it's the only link in google when looking for "sharepoint PlaceHolderMain-controls"

Posted on SharePoint Blogs

re: Building A Dynamic CAML Query

Dustin Frenton — Wed, 05 Mar 2008 20:44:44 GMT

I like the Staff Classes!

I've been looking them over quite a bit.

Were these custom or provided from somewhere?

Posted on SharePoint Blogs

SharePoint tips and tricks - 20 Feb 08 « Patrick’s Bytes

SharePoint tips and tricks - 20 Feb 08 « Patrick’s Bytes — Tue, 19 Feb 2008 17:17:16 GMT

Pingback from SharePoint tips and tricks - 20 Feb 08 « Patrick’s Bytes

Posted on SharePoint Blogs

re: SharePoint Backup Error

Drew — Tue, 12 Feb 2008 15:35:00 GMT

Operating system error 5 (Access is denied.).

BACKUP DATABASE is terminating abnormally.

Posted on SharePoint Blogs

re: Building A Dynamic CAML Query

Mike — Sat, 09 Feb 2008 00:54:18 GMT

Check these classes out:

using System;

using System.Collections.Generic;

using System.Text;

using Microsoft.SharePoint;

using System.Data;

using System.Xml;

using System.IO;

using Microsoft.SharePoint.Utilities;

using System.Collections.Specialized;

namespace Staff

{

public enum CamlConjunction

{

And, Or

}

public enum CamlOperator

{

Neq, Gt, Lt, Eq, DateRangesOverlap, Geq, Leq, Contains, BeginsWith, IsNotNull, IsNull

}

public interface ICaml

{

string Render();

}

public class ValueComparison : ICaml

{

ICaml FirstValue;

ICaml SecondValue;

CamlConjunction opera;

public ValueComparison(ICaml firstValue, ICaml secondValue, CamlConjunction conjunction)

{

FirstValue = firstValue;

SecondValue = secondValue;

this.opera = conjunction;

}

#region ICaml Members

public string Render()

{

StringBuilder sb = new StringBuilder("<");

sb.Append(opera.ToString());

sb.Append(">");

sb.Append(FirstValue.Render());

sb.Append(SecondValue.Render());

sb.Append("</");

sb.Append(opera.ToString());

sb.Append(">");

return sb.ToString();

}

#endregion

}

public class FieldRefValue : ICaml

{

CamlOperator opera;

string fieldName; FieldType fieldType; string value;

public FieldRefValue(string fieldName, FieldType fieldType, string value, CamlOperator opera)

{

this.fieldName = fieldName;

this.fieldType = fieldType;

this.value = value;

this.opera = opera;

}

#region ICaml Members

public string Render()

{

StringBuilder sb = new StringBuilder("<");

sb.Append(opera.ToString());

sb.Append("><FieldRef Name='");

sb.Append(fieldName);

sb.Append("' /><Value Type='");

sb.Append(fieldType.ToString());

sb.Append("' >");

sb.Append(value);

sb.Append("</Value>");

sb.Append("</");

sb.Append(opera.ToString());

sb.Append(">");

return sb.ToString();

}

#endregion

}

public enum FieldType

{

Text, Lookup, Number, DateTime, User

}

internal static class Util

{

internal static string DispFormUrl(SPList list)

{

SPWeb web = list.ParentWeb;

string url = list.DefaultViewUrl;

string siteUrl = web.Site.Url;

url = url.Remove(url.LastIndexOf("/") + 1);

url += "DispForm.aspx?ID=";

if (web.Site.ServerRelativeUrl != "/")

url = url.Remove(url.IndexOf(web.Site.ServerRelativeUrl), web.Site.ServerRelativeUrl.Length);

if (siteUrl.EndsWith("/"))

siteUrl = siteUrl.Remove(siteUrl.LastIndexOf("/"));

return web.Site.Url + url;

}

internal static string CombineUrls(string webUrl, string url)

{

string ret = webUrl.Trim();

if (!ret.EndsWith("/"))

ret += "/";

return ret + url;

}

internal static SPQuery CreateQuery(ICaml caml)

{

SPQuery ret = new SPQuery();

ret.Query = "<Where>" + caml.Render() + "</Where>";

return ret;

}

internal static SPQuery CreateQuery(ICaml caml, string[] ViewFieldNames)

{

SPQuery ret = new SPQuery();

ret.Query = "<Where>" + caml.Render() + "</Where>";

ret.ViewFields = ViewFields(ViewFieldNames);

return ret;

}

internal static SPQuery CreateQuery(string[] internalFieldNames)

{

SPQuery ret = new SPQuery();

ret.ViewFields = ViewFields(internalFieldNames);

return ret;

}

internal static void Log(Guid siteGuid, Guid webGuid, Exception ex, string title)

{

Log(siteGuid, webGuid, title, ex.Message, ex.Source, ex.StackTrace, "Exception");

}

internal static void Log(Guid siteGuid, Guid webGuid, string title, string message, string source, string stackTrace, string logType)

{

try

{

using (SPSite site = new SPSite(siteGuid))

using (SPWeb web = site.OpenWeb(webGuid))

{

SPList logList = web.Lists["NewsletterLog"];

SPListItem logItem = logList.Items.Add();

logItem["Title"] = title;

logItem["Message"] = message;

logItem["Source"] = source;

logItem["StackTrace"] = stackTrace;

logItem["LogType"] = logType;

logItem.Update();

}

catch { }

}

internal static string FormatValue(string rawValue)

{

string val = rawValue;

if (val.Contains(";#"))

{

try

{

val = val.Substring(val.IndexOf(";#") + 2);

}

catch { }

}

return val;

}

internal static string CreateQuery(string fieldName, FieldType fieldType, string value)

{

return "<Where><Eq><FieldRef Name='" + fieldName + "' /><Value Type='" + fieldType.ToString() + "' >" + value + "</Value></Eq></Where>";

}

internal static string CreateQuery(string fieldName, string value)

{

// SPQuery q = new SPQuery();

return "<Where><Eq><FieldRef Name='" + fieldName + "' /><Value Type='Text' >" + value + "</Value></Eq></Where>";

}

internal static string ViewFields(string[] internalFieldNames)

{

if (internalFieldNames.Length > 0)

{

StringBuilder ret = new StringBuilder();

foreach (string field in internalFieldNames)

ret.Append("<FieldRef Name='" + field + "' />");

return ret.ToString();

}

else

return string.Empty;

}

internal static string ViewFields(StringCollection internalFieldNames)

{

if (internalFieldNames.Count > 0)

{

StringBuilder ret = new StringBuilder();

foreach (string field in internalFieldNames)

ret.Append("<FieldRef Name='" + field + "' />");

return ret.ToString();

}

else

return string.Empty;

}

internal static bool GetFieldValueBool(SPListItem item, string fieldName)

{

bool res = false;

try

{

res = bool.Parse(item[fieldName].ToString());

}

catch { }

return res;

}

internal static string GetFieldValue(SPListItem item, string fieldName)

{

string res = string.Empty;

try

{

res = FormatValue(item[fieldName].ToString());

}

catch { }

return res;

}

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Peter Doyle — Thu, 20 Dec 2007 11:28:29 GMT

Any chance of seeing part 2 of teh blog?

Thanks.

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Johan — Mon, 15 Oct 2007 11:19:09 GMT

Thanx for an intressting blog!

when are you posting the second part?

I am waiting

/Johan

Posted on SharePoint Blogs

SharePoint 2007 Link love: 10-15-2007 at Virtual Generations

SharePoint 2007 Link love: 10-15-2007 at Virtual Generations — Mon, 15 Oct 2007 05:58:33 GMT

Pingback from SharePoint 2007 Link love: 10-15-2007 at Virtual Generations

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Steve Dalby — Fri, 05 Oct 2007 17:44:08 GMT

Wet my appetite for the next page

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Russ Hancock — Thu, 20 Sep 2007 08:10:29 GMT

Also waiting on the next bit Rob!

Cheers

Russ

Posted on SharePoint Blogs

re: Adding file shares to Enterprise Search

Andy Rosendahl — Fri, 07 Sep 2007 15:49:03 GMT

Hi Robert, I'm also waiting tensely for your announced next part. As Michael already described: It would be great if there's is a solution to avoid editing ACLs of countless folders. Isn't it possible to use some sort of backup previlege for granting read only access?

Andy

Posted on SharePoint Blogs

Dynamic CAML Query

Robert J Wheeler — Tue, 04 Sep 2007 23:14:08 GMT

Occasionally the need arises to build dynamic CAML queries in order to get items from a SharePoint list

Posted on SharePoint Blogs

Blogger Loser » Blog Archive » Dynamic CAML Query

Blogger Loser » Blog Archive » Dynamic CAML Query — Fri, 31 Aug 2007 09:08:02 GMT

Pingback from Blogger Loser » Blog Archive » Dynamic CAML Query

Posted on SharePoint Blogs

Dynamic CAML Query

Tech MOSS Team — Thu, 30 Aug 2007 14:10:04 GMT

In his recent post Robert J Wheeler has presented his way of dealing with building CAML queries dynamically

Posted on SharePoint Blogs

10 Links Today (2007-08-28)

10 Links Today (2007-08-28) — Tue, 28 Aug 2007 15:19:43 GMT

Pingback from 10 Links Today (2007-08-28)

Posted on SharePoint Blogs

SharePoint 2007 link love 08-28-2007 at Virtual Generations

SharePoint 2007 link love 08-28-2007 at Virtual Generations — Tue, 28 Aug 2007 10:23:21 GMT

Pingback from SharePoint 2007 link love 08-28-2007 at Virtual Generations

Posted on SharePoint Blogs

Blogger Loser » Blog Archive » Create Wizards in SharePoint

Blogger Loser » Blog Archive » Create Wizards in SharePoint — Mon, 27 Aug 2007 05:00:23 GMT

Pingback from Blogger Loser » Blog Archive » Create Wizards in SharePoint

Posted on SharePoint Blogs

re: Create Wizard Functionality With SharePoint Lists

Christa Ayer — Fri, 24 Aug 2007 15:38:38 GMT

Useful article! Please contact me if you're interested in writing for Advisor Guide to Microsoft SharePoint.

THX!

Christa Ayer

christa_ayer @ advisormedia.net

Posted on SharePoint Blogs