Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

    Advertisements
  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand
  • Advertisements

Archive for November, 2012

My Site Report in Squadron

Posted by Paul on November 6, 2012

Welcome to the utility documentation for Squadron.

clip_image001

If you do not have Squadron for SharePoint 2010, you can download it from here:

http://squadron2010.codeplex.com

My Site Report

The My Site addin helps in generating My Site information of SharePoint 2010 site.

After executing the application click on the My Site item from the left pane:

clip_image003

Enter the URL of the site in the area provided:

clip_image005

Click the Execute button to generate the data. Please wait for few seconds for the activity to complete. You My Site entries will get generated as shown below (if everything goes fineJ)

clip_image007

Saving the Report

Squadron provides infrastructure to save the report. You can right click on the grid and choose the Export Data option as shown below:

clip_image009

You will be prompted to enter the CSV (Comma Separated Values) file location.

clip_image011

After saving, the file gets opened in the appropriate file handler in your machine.

clip_image013

Advanced Export

For advanced export option allowing selection of columns, please find the following link:

Advanced Export

References

http://squadron2010.codeplex.com

Summary

In this article we have explored how to generate the My Site Report using Squadron for SharePoint 2010.

Advertisements

Posted in C#, SharePoint | Tagged: , | Leave a Comment »

Advanced Export Feature in Squadron

Posted by Paul on November 6, 2012

Advanced Export Feature in Squadron

Welcome to the utility documentation for Squadron.

image

If you do not have Squadron for SharePoint 2010, you can download it from here:

http://squadron2010.codeplex.com

Advanced Export

The advanced export feature allows selection of columns while exporting. You can use the Export Data button on the right top end for this purpose.

image

In the appearing screen, choose the columns you would like to export:

image

You can even right click for Check All / Uncheck All options as shown below:

image

After choosing the necessary columns, choose the OK button. You should get the prompt for CSV file path.

image 

After saving, the file gets opened in the register file handler for CSV files.

image

This concludes our awareness with Advanced Export feature.

The Export Data screen can be used to save the log entries of the Squadron application. The log entries should help in analyzing report generation problems if any.

References

http://squadron2010.codeplex.com

Summary

In this article we have explored the Advanced Export feature of Squadron for SharePoint 2010 from Code Plex.

Posted in C#, SharePoint | Tagged: , | 1 Comment »

User Profile Report in Squadron

Posted by Paul on November 6, 2012

Welcome to the utility documentation for Squadron.

clip_image001

If you do not have Squadron for SharePoint 2010, you can download it from here:

http://squadron2010.codeplex.com

User Profile Report

After executing the application click on the User Profile item from the left pane:

clip_image003

Enter the URL of the site in the area provided:

clip_image005

Click the Execute button to generate the data. Please wait for few seconds for the activity to complete.

clip_image007

You User Profile entries will get generated as shown below (if everything goes fineJ)

clip_image009


Saving the Report

Squadron provides infrastructure to save the report. You can right click on the grid and choose the Export Data option as shown below:

clip_image011

You will be prompted to enter the CSV (Comma Separated Values) file location.

clip_image013

After saving, the file gets opened in the appropriate file handler in your machine.

clip_image015

References

http://squadron2010.codeplex.com

Summary

In this article we have explored how to generate the User Profile Report using Squadron for SharePoint 2010.

Posted in C#, SharePoint | Tagged: , | Leave a Comment »

Introducing Squadron – SharePoint 2010 Utility Addins

Posted by Paul on November 6, 2012

In this article I would like to introduce Squadron – a SharePoint 2010 Utility Addins application.

Following is the screen shot of Squadron:

clip_image002

You can select the item from the left pane and execute. In case of Help, click the Help button blinking.

Following is the download location of Squadron:

http://www.sharepointact.com/Squadron2010/publish.htm

Utility Addins

Following are the utility addins inside Squadron.

1. User Profile addin to generate User Profile information

2. My Site addin to generate My Site information

3. Site Size addin to generate Site Size information

4. WF Terminator to locate and terminate unwanted workflows

5. Stsadm command line environment

6. Empty List addin to empty / delete list & libraries

Please note that in future more utility plugins will be added.

clip_image004

I kept the name as Squadron because I liked the meaning in Word Web as “Squadron: A cavalry unit consisting of two or more troops and headquarters and supporting arms”

Squadron Architecture

The project named Squadron serves as the core application which dynamically loads the plugins.

clip_image006

MainForm

MainForm serves the user interface and serves as the container for plugins.

clip_image008

On form load the plugin DLL files are searched and the corresponding plugin classes are loaded.

AddinManager

AddinManager class uses Reflection to load the plugins from application folder.

clip_image009

SquadronAddin

AbstractAddin represents the abstract class for all plugin.

clip_image010

References

http://www.sharepointcto.com/Squadron/Default.aspx

Summary

In this article we have explore the tool (utility) named Squadron for SharePoint 2010. As time goes by I believe more and more utilities should appear in the tool plus new release for SharePoint 2013 binaries. Please stay tuned.

Posted in C#, SharePoint | Tagged: , | 2 Comments »

Introducing Squadron – SharePoint 2010 Utility Addins

Posted by Paul on November 6, 2012

In this article I would like to introduce Squadron – a SharePoint 2010 Utility Addins application.

Following is the screen shot of Squadron:

clip_image002

You can select the item from the left pane and execute. In case of Help, click the Help button blinking.

Following is the download location of Squadron:

http://www.sharepointact.com/Squadron2010/publish.htm

Utility Addins

Following are the utility addins inside Squadron.

1. User Profile addin to generate User Profile information

2. My Site addin to generate My Site information

3. Site Size addin to generate Site Size information

4. WF Terminator to locate and terminate unwanted workflows

5. Stsadm command line environment

6. Empty List addin to empty / delete list & libraries

Please note that in future more utility plugins will be added.

clip_image004

I kept the name as Squadron because I liked the meaning in Word Web as “Squadron: A cavalry unit consisting of two or more troops and headquarters and supporting arms”

Squadron Architecture

The project named Squadron serves as the core application which dynamically loads the plugins.

clip_image006

MainForm

MainForm serves the user interface and serves as the container for plugins.

clip_image008

On form load the plugin DLL files are searched and the corresponding plugin classes are loaded.

AddinManager

AddinManager class uses Reflection to load the plugins from application folder.

clip_image009

SquadronAddin

AbstractAddin represents the abstract class for all plugin.

clip_image010

References

http://www.sharepointcto.com/Squadron/Default.aspx

Summary

In this article we have explore the tool (utility) named Squadron for SharePoint 2010. As time goes by I believe more and more utilities should appear in the tool plus new release for SharePoint 2013 binaries. Please stay tuned.

Posted in C# | 2 Comments »

SharePoint 2010 Free eBook

Posted by Paul on November 5, 2012

Black Page - Yellow Title

 

(Click the image to download the book)

Book provides Basics to Advanced Topics coverage & Real World Scenarios to bet on your confidence!

Working on the commitment to make Best Resources available for SharePoint!

The Book is also available in Hard Cover at Amazon.

I have made sure to set the minimum rate for the maximum quality &  quantity.

Source Code: Download

Posted in C#, SharePoint | Tagged: , , | 48 Comments »

Available Now at Amazon!

Posted by Paul on November 5, 2012

Black Page - Yellow Title

Book provides Basics to Advanced Topics coverage & Real World Scenarios to bet on your confidence!

Working on the commitment to make Best Resources available for SharePoint!

The Book is available at Amazon for Purchase.

I have made sure to set the minimum rate for the maximum quality &  quantity.

Posted in C#, SharePoint | Tagged: , , | 37 Comments »

SharePoint & Power User – Bulk Data entry with Datasheet View

Posted by Paul on November 2, 2012

Do you know about the Datasheet View of Lists?

This was a new feature in SharePoint 2010 and continued in SharePoint 2013 as well.  This feature allows build data entering in a more convenient way.  Following is the screen shot of a List in the Datasheet view:

image

How to enable Datasheet View?

Let us see how to enable Datasheet view.   First, create a list named Job and add some text and number columns into it.

image

Click on the Create View link from the bottom of the page.  You will get the following page.

image

Choose the Datasheet View as shown above.

image

In the appearing page, enter a name for the view and choose the columns to be displayed.  You may choose to set this view as Default.

Click the OK button to save changes and your Job lists should look like below:

image

You may try adding data, copying / pasting, bulk delete, etc.

image

Additionally, we can fill one cell value to all others by clicking and dragging the cell boundary.

image

Possible Errors

While working with datasheet view, you might encounter the error: The selected cells are read-only.

image

Solutions

There could be different cases arising to the above error.  I would like to list the solutions one by one.

Case 1: Content Approval

If the list requires content approval, you might need to disable it working with datasheet view.

Solution: List > List Settings > Versioning Settings > Set Require Content Approval to False

 

Case 2: MS Access Components are not properly installed

The datasheet view is working through MS Access ActiveX control. 

Solution: You can verify the MS Office installation in the client side.

 

Case 3: Read Only Columns in the View

The view might contain other read-only columns creating problem while copying & pasting.

Solution: You can hide those columns in the Datasheet view  and try copy / paste with the required cells selected

 

image

From the above feature I believe we can agree the High Productivity Offers of SharePoint at the Least cost.  The same functionality if provided by an ASP.NET / Web developers could take several hours of work.  Thanks to SharePoint, we can provide quick Datasheet view for all our lists.

References

http://tinyurl.com/sp2010-views

Summary

In this article we have seen how to use the Datasheet view of SharePoint.  The points worth summarizing are:

  • Datasheet view provides a quicker solution to bulk data entry, copy / paste requirements
  • Datasheet view is a SharePoint 2010 feature
  • Datasheet view requires Internet Explorer, ActiveX for MS Access installed

Posted in C#, SharePoint | Tagged: , | Leave a Comment »

SharePoint & Power User – Bulk Data entry with Datasheet View

Posted by Paul on November 2, 2012

Do you know about the Datasheet View of Lists?

This was a new feature in SharePoint 2010 and continued in SharePoint 2013 as well.  This feature allows build data entering in a more convenient way.  Following is the screen shot of a List in the Datasheet view:

image

How to enable Datasheet View?

Let us see how to enable Datasheet view.   First, create a list named Job and add some text and number columns into it.

image

Click on the Create View link from the bottom of the page.  You will get the following page.

image

Choose the Datasheet View as shown above.

image

In the appearing page, enter a name for the view and choose the columns to be displayed.  You may choose to set this view as Default.

Click the OK button to save changes and your Job lists should look like below:

image

You may try adding data, copying / pasting, bulk delete, etc.

image

Additionally, we can fill one cell value to all others by clicking and dragging the cell boundary.

image

Possible Errors

While working with datasheet view, you might encounter the error: The selected cells are read-only.

image

Solutions

There could be different cases arising to the above error.  I would like to list the solutions one by one.

Case 1: Content Approval

If the list requires content approval, you might need to disable it working with datasheet view.

Solution: List > List Settings > Versioning Settings > Set Require Content Approval to False

 

Case 2: MS Access Components are not properly installed

The datasheet view is working through MS Access ActiveX control. 

Solution: You can verify the MS Office installation in the client side.

 

Case 3: Read Only Columns in the View

The view might contain other read-only columns creating problem while copying & pasting.

Solution: You can hide those columns in the Datasheet view  and try copy / paste with the required cells selected

 

image

From the above feature I believe we can agree the High Productivity Offers of SharePoint at the Least cost.  The same functionality if provided by an ASP.NET / Web developers could take several hours of work.  Thanks to SharePoint, we can provide quick Datasheet view for all our lists.

References

http://tinyurl.com/sp2010-views

Summary

In this article we have seen how to use the Datasheet view of SharePoint.  The points worth summarizing are:

  • Datasheet view provides a quicker solution to bulk data entry, copy / paste requirements
  • Datasheet view is a SharePoint 2010 feature
  • Datasheet view requires Internet Explorer, ActiveX for MS Access installed

Posted in C# | Leave a Comment »

How to get the SharePoint (w3wp.exe) Process Id?

Posted by Paul on November 1, 2012

Once in a while we need to know the Process Id of the SharePoint worker process. (w3wp.exe)

We can see this using the Task Manager.

image

To view the PID column you can use View > Select Columns dialog.

Challenge

Now you can see there are multiple w3wp.exe.  Which is the w3wp.exe of our web application.  (for eg: port 80)

To view this, you can use the following command.

appcmd.exe list wp

from the folder: C:\Windows\System32\inetsrv>

image

The second column in the result shows the Process Id. (6152, 6560, 7092)

image

  • AppCmd.exe is the single command line tool for managing IIS 7 and above. It exposes all key server management functionality through a set of intuitive management objects that can be manipulated from the command line or from scripts.
  • The process id can be used in Visual Studio > Debug > Attach to Process > Locate by Process id

References

http://tinyurl.com/sp2010-appcmd

I hope you like this quick tip.

Posted in C#, SharePoint | Tagged: , | Leave a Comment »