SharePoint Zen/sharepoint-zen/The ROXORITY.com Blog on SharePoint Tools, Web and Software DevelopmentMon, 08 Mar 2010 21:02:31 +0000Copyright (C) 2005 - 2010 ROXORITY Ltd. All rights reserved.en-USSquarespace Site Server v5.9.2 (http://www.squarespace.com/)Filtering SQL Data View Web Parts in SharePointCascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsXSL Data ViewsPhilipp Schumann [ROXORITY]Mon, 08 Mar 2010 19:31:28 +0000/sharepoint-zen/filtering-sql-data-view-web-parts-in-sharepoint.html295127:3023144:6947280SharePoint's XSLT Data View Web Parts do support incoming Web Part Connections, but they are a fragile bunch. Connecting a Filter provider Web Part to List View Web Parts is straightforward. Connecting to a List-bound XSLT Data View can be a tad more tricky depending on circumstances, but still fairly easy. Connecting to an SQL-bound Data View requires a few Serious Setup Steps. This walkthrough helps you through it.

]]>
/sharepoint-zen/rss-comments-entry-6947280.xml
SharePoint Value Range Filtering: the New, Simplified WayCascading, Multiple-Value List FiltersFilterZenMOSSRange / Value-Span FilteringSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Thu, 25 Feb 2010 17:12:03 +0000/sharepoint-zen/sharepoint-value-range-filtering-the-new-simplified-way.html295127:3023144:6833757One reason for FilterZen's popularity is its range-filtering capabilities.

Think about the out-of-box filtering and search capabilities of SharePoint: drilling down into a specific sub-range, whether in date-time terms ("show me data between March and August") or in numeric terms ("show me sales between 100 and 500"), if you don't want to Modify your List View everytime you want to see certain data sub-ranges, then neither the built-in Advanced Search nor the built-in Column header drop-down filter menus will take you there.

FilterZen made this possible, but until today this involved a number of redundant manual set-up steps. The more steps there are, or the more repetetive those are, the more there is scope for mistakes and omissions. As we saw how popular range filters are, we decided to save you even more hassle and time and further streamline the process for you...

]]>
/sharepoint-zen/rss-comments-entry-6833757.xml
SharePoint List Filtering by User Group MembershipCascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Wed, 24 Feb 2010 12:14:52 +0000/sharepoint-zen/sharepoint-list-filtering-by-user-group-membership.html295127:3023144:6813449A FilterZen user enquired about the following requirement:

I have three SharePoint groups called Branch1, Branch2 and Branch3. What I want to have happen is that when user of Branch1 hit my list they only see Branch1's records. When Branch2 users connect they only she Branch2's records and so on.

An interesting filtering requirement that we wanted FilterZen (our SharePoint Filter Web Part) to support fully. Starting with build 3.6.0.10 (the newest available for download at the point of writing), this can now be achieved with any User Filter.

]]>
/sharepoint-zen/rss-comments-entry-6813449.xml
Export to CSV with SharePoint List item version history: new in ExportZen 1.3ExportZenList Data ExportMOSSSharePointVersioningWSSPhilipp Schumann [ROXORITY]Tue, 23 Feb 2010 14:10:35 +0000/sharepoint-zen/export-to-csv-with-sharepoint-list-item-version-history-new.html295127:3023144:6801171ExportZen 1.3 was just released and this update now supports exporting the full version history of your exported SharePoint List items or Document Library records!

]]>
/sharepoint-zen/rss-comments-entry-6801171.xml
How to: schedule or batch-invoke SharePoint CSV exportsBatch Automation / .NET ProgrammabilityExportZenList Data ExportMOSSSchedulingSharePointWSSPhilipp Schumann [ROXORITY]Mon, 22 Feb 2010 19:59:37 +0000/sharepoint-zen/how-to-schedule-or-batch-invoke-sharepoint-csv-exports.html295127:3023144:6790148In a perfect world, we would already offer you a "proper" SharePoint Timer Job to schedule CSV exports of List data. Don't worry, this is on the medium-term product roadmap. Until we get there, there is another way which I want to show you today. So good news: you can start scheduling with this Right Now. This involves only a few setup steps that a later, integrated SharePoint Timer Job would be able to take care of fully. Overall, no rocket science is to be expected, though.

]]>
/sharepoint-zen/rss-comments-entry-6790148.xml
SharePoint List Filtering by Date Spans: a Stepwise TutorialCascading, Multiple-Value List FiltersFilterZenMOSSRange / Value-Span FilteringSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Sun, 21 Feb 2010 19:32:11 +0000/sharepoint-zen/sharepoint-list-filtering-by-date-spans-a-stepwise-tutorial.html295127:3023144:6779075FilterZen power user and SharePoint consultant Harry Parsonage (of , California) wrote this step-by-step walkthrough on how to set up date-range filters for work with SharePoint Lists, and invited us to share it with the public. This tutorial will be a real time-saver for newcomers to FilterZen (especially until we finalize a much simplified Date Range Filter Wizard user interface for this often-needed use case, which is on the medium-term roadmap). As so often, once you know the basic steps, you can click your filters together in under 5 minutes; however, figuring those out for the first time takes some experimentation and can quickly take much longer than anticipated. Harry, thanks a lot for this invaluable contribution to your fellow SharePoint power filterers!

]]>
/sharepoint-zen/rss-comments-entry-6779075.xml
It's all Give-and-Take: introducing our free Lite editionsExportZenFilterZenPeopleZenROXORITYSharePointUploadZenWeb PartsPhilipp Schumann [ROXORITY]Fri, 29 Jan 2010 06:55:19 +0000/sharepoint-zen/its-all-give-and-take-introducing-our-free-lite-editions.html295127:3023144:6459139 Effective today, we're changing our licensing model from Commercial-only to a Free-and-Commercial hybrid, and I'm very happy and excited to announce this.

We streamlined our previous three commercial editions (Standard, Professional and Enterprise) into two (Basic and Ultimate) and added a freeware edition called Lite. Starting today, each of our current and future SharePoint add-ons, Web Parts, tools and solutions will always be also offered in an unlimited freeware Lite edition, no strings attached...

]]>
/sharepoint-zen/rss-comments-entry-6459139.xml
How to do PeopleZen CSS CustomizationsEmployee ViewMOSSPeople SearchPeopleZenSharePointStaff DirectoryTeam ListingUser ProfilesWeb PartsPhilipp Schumann [ROXORITY]Sun, 10 Jan 2010 18:16:51 +0000/sharepoint-zen/how-to-do-peoplezen-css-customizations.html295127:3023144:6284896/sharepoint-zen/rss-comments-entry-6284896.xmlAn 'Upcoming Birthdays' Web Part in 10 minutesCascading, Multiple-Value List FiltersEmployee ViewFilterZenMOSSPeople SearchPeopleZenRange / Value-Span FilteringSharePointStaff DirectoryTeam ListingUser ProfilesWeb PartsPhilipp Schumann [ROXORITY]Sun, 27 Dec 2009 16:04:14 +0000/sharepoint-zen/an-upcoming-birthdays-web-part-in-10-minutes.html295127:3023144:6150323Who doesn't love birthday calendars? So let's add one to your team site! Out of the box, SharePoint does not offer much help with that assignment. What are your options?

]]>
/sharepoint-zen/rss-comments-entry-6150323.xml
Month and Year Drop-Downs for Advanced Date Range Filtering in SharePointCascading, Multiple-Value List FiltersFilterZenMOSSRange / Value-Span FilteringSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Sun, 06 Dec 2009 19:29:29 +0000/sharepoint-zen/month-and-year-drop-downs-for-advanced-date-range-filtering.html295127:3023144:6002898When we introduced you to FilterZen's value range filtering capabilities for SharePoint List Views, Data Views and other Web Parts back in June, we showed you the simplest possible solution that uses Date Filters. As you probably know, Date Filters can send date or date/time values, optionally in a specific locale and format, and optionally offering a SharePoint Date Picker for end-users to make a selection. With the above solution in place, you can let your users choose the bounding start and end dates to form the filter range just by making your Date Filters interactive from their settings pane.

Sometimes, however, that is not quite the user experience you want to deliver for date range filtering. For example, users may prefer just selecting from readily populated drop-down lists bounding start and end months rather than picking the 1st and 31st dates via That Nuisance of a Date Picker. Just two days ago we received a request to that effect:

]]>
/sharepoint-zen/rss-comments-entry-6002898.xml
Wild-card search with SharePoint (WSS or MOSS) Filter Web PartsCascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsWildcard List Search with CAML operatorsXSL Data ViewsPhilipp Schumann [ROXORITY]Wed, 19 Aug 2009 19:24:14 +0000/sharepoint-zen/wild-card-search-with-sharepoint-wss-or-moss-filter-web-part.html295127:3023144:4943912Wild-card search in SharePoint can be tricky to implement. When you're dealing with List or Business data in List Views, Business Data Lists, Data Form or Data View Web Parts, you can easily achieve the desired effect of wild-card search by simply creating any kind of filter using the FilterZen Filter Web Part and then setting the filter operator from the default kind ("Equals") to the "Contains" operator. Here's how...

]]>
/sharepoint-zen/rss-comments-entry-4943912.xml
Using value-range filtering and CAML operators in Filter Web PartsCascading, Multiple-Value List FiltersFilterZenMOSSRange / Value-Span FilteringSharePointWSSWeb PartsWildcard List Search with CAML operatorsXSL Data ViewsPhilipp Schumann [ROXORITY]Fri, 19 Jun 2009 21:21:20 +0000/sharepoint-zen/using-value-range-filtering-and-caml-operators-in-filter-web.html295127:3023144:4383066Version 3.0 of FilterZen introduced advanced support for sending multiple filter values to connected List View and Data View Web Parts. One intriguing use case that inspired this capability was a requirement to filter a Date/Time column based on a certain date range, i.e. only setting an interval such as "between 1st January 2008 and 30th April 2008" and filtering a view on column data falling into this range.

With FilterZen, you can achieve this easily by configuring a FilterZen Filter Web Part as follows...

]]>
/sharepoint-zen/rss-comments-entry-4383066.xml
Highlights in FilterZen 2.6Cascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Tue, 19 May 2009 22:43:38 +0000/sharepoint-zen/highlights-in-filterzen-26.html295127:3023144:4035389We've just pushed out FilterZen 2.6, which introduces outstanding support for the Microsoft Office SharePoint Server (MOSS) 2007 Enterprise Edition Business Data Catalog (BDC). So what's new in this release, among from a number of small performance and usability improvements and some impressive bug fixes?

]]>
/sharepoint-zen/rss-comments-entry-4035389.xml
New in FilterZen 2.4: SQL Data FiltersCascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Tue, 12 May 2009 23:03:34 +0000/sharepoint-zen/new-in-filterzen-24-sql-data-filters.html295127:3023144:3965097We're excited to announce the newest update to FilterZen, the ultimate Filter Web Part for SharePoint. Among minor bug fixes and optimizations, this service release 2.4 introduces a brand-new, highly useful filter type: SQL Data Filters.

]]>
/sharepoint-zen/rss-comments-entry-3965097.xml
FilterZen How To: Create and Set Up Web Parts ProgrammaticallyBatch Automation / .NET ProgrammabilityCascading, Multiple-Value List FiltersFilterZenMOSSSharePointWSSWeb PartsWildcard List Search with CAML operatorsPhilipp Schumann [ROXORITY]Tue, 28 Apr 2009 11:52:13 +0000/sharepoint-zen/filterzen-how-to-create-and-set-up-web-parts-programmaticall.html295127:3023144:3823640We've quietly launched the newest release of FilterZen yesterday — without much fanfare yet, until this web site has been completely updated content-wise — a fantastic release that finally pushed the tool from being the URL Filter Web Part for SharePoint to being the Filter Web Part for SharePoint. URL filtering is still supported and got even better, but now there's a wealth of other highly useful filter types in there, many new powerful capabilities, and yet it's all still available in just one single Web Part, reducing complexity and clutter in your Web Part catalog.

We received one enquiry about programmatically creating and setting up the Web Part: a use case that was intriguing enough to warrant the following (code-heavy) tutorial.

]]>
/sharepoint-zen/rss-comments-entry-3823640.xml