Lightening Conductor
Web Part:
Requirement:
Recently we came across a small requirement of “Export to
Excel” functionality for the SharePoint List/Library view where only Selected
columns to be exported into Excel using OOB(out of the Box Solution).
Solution:
Using Lightning Tool Conductor web part, you can easily achieve
this and was helpful where we need OOB solutions for joining two lists.
Brief Description about Lightening Tool Conductor Web
part:
SharePoint Cross Site Collection Rollup Web Part:
The
Lightning Conductor Web Part is a very easy to configure SharePoint List and
Library rollup Web Part that can rollup SharePoint Content from across multiple
site collections and web applications.
Unlike the Content Query Web Part (CQWP), the Lightning
Conductor Web Part can aggregate SharePoint content from anywhere within your
SharePoint farm. Instead of writing XSL to display multiple columns of
information from SharePoint Lists, you can also configure a view with the
Lightning Conductor Web Part without writing any code at all.
Rolling up SharePoint Content is easy with the Lightning
Conductor Web Part. Using the Configuration Wizard, you can build your query
within minutes to rollup SharePoint Content. You can choose where the content
will be aggregated from, and filter by List Type, and Content Type. You can
direct relevant content to your users by using the SharePoint Audience
Targeting feature.
Once
you have configured your Query, you can build your view without writing any
XSLT. Simply choose the columns that you wish to display, setup filters, apply
formatting, setup pagination and you are ready to display your rolled up
content.
Building your view allows you to display multiple columns
easily. For example, instead of just displaying the title column from your
SharePoint Task Lists, you can display Title, Due Date, Status and Priority.
With the Lightning Conductor Web Part, you can display your
results by using the SPGridView easily or you can brand and build in your own
features using XSLT, jQuery or Javascript. Within the Lightning Conductor Web
Part, you will find pre-built views for displaying Calendar list items within a
calendar, and a branded example of rolling up from Announcements lists.
When clicking a list item, you will never be taken away from
the page containing the Lightning Conductor Web Part no matter where in the
SharePoint farm your content resides. This allows users to use the data as
though it belonged to the site that they are currently viewing.
Pros and Cons of Using LCWP:
Pros:
- Lightning Conductor Web Part, has an Export to Excel/CSV function, which does not export the item type and path (Default columns), but rather only the columns which are displayed within the web part
- Easy to select and configure anywhere in the site collection. For e.g.: You can add it in sub site to access root site collection list/library.
- Multiple Lists/Libraries can be easily combined and configure with the use of Linked Data Sources in SP Designer.
- Item link can be given to any column in the List without using SP Designer.
Cons:
- Inner join of lists/libraries cannot be done
- · Cannot customize the web part using SP Designer.
For More Information You can contact Technical Support of
this 3rd party tool vendor at “Lightning Tools support@lightningtools.com”
Link to Lighting Tool Conductor Tools for SharePoint: http://lightningtools.com/
