Lightening Conductor Web Part:for SP2010

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 3^rd party tool vendor at “Lightning Tools support@lightningtools.com”

Link to Lighting Tool Conductor Tools for SharePoint: http://lightningtools.com/