ARTICLE

Squadron - Empty List Addin

Posted by Jean Paul Articles | SharePoint 2010 November 24, 2012
In this article we can explore a new Addin inside Squadron for SharePoint 2010 tool.
Reader Level:

Empty List Adding

The Empty List Addin can be applied for:

  1. Lists
  2. Libraries

The Addin performs the following:

  1. Empty the list or library by deleting all items
  2. Delete the list or library
The Addin is a quick utility as it helps, in one click, emptying/deleting of multiple lists/libraries.

img13.jpg

Squadron is a SharePoint 2010 tool containing multiple addins.  You can download the tool freely from Code Plex using the following URL:


http://squadron2010.codeplex.com/


img1.jpg

After downloading & installing you can run the Squadron tool from Start Menu > Squadron.

img2.jpg

EMPTY Operation


Click on the Empty List item from the left pane. You will get the following screen with Lists & Libraries listed:

img3.jpg

img13.jpg

The Lists & Libraries are selected based on the URL, Hidden properties.  You can change the URL from the URL text box given.
Now we are going to perform the EMPTY operation.  Please note that all the entries in the selected lists will be deleted.  You an manually select the list/library to perform the EMPTY operation.

To select all the lists/libraries use the context menu associated with Check All / Uncheck All.


img4.jpg


After selecting the list, click on the Empty Selected button from the right hand side.

img5.jpg

Please note that the selected Tasks list contains the following data before the operation:

img6.jpg

On clicking the Empty Selected button, you will get the following prompt:

img7.jpg

You can click the Yes button to continue if you are sure about deleting all the items in the selected list.  Now returning to the SharePoint list you will see the items are deleted.

img8.jpg

This concludes our EMPTY operation.

img13.jpg

The Show Count check box shows the item count of each list or library.

The Show Hidden check box shows the hidden lists & libraries (including Quick Launch and System); see:

  img9.jpg

DELETE Operation

Now we can try the DELETE operation. Please note that the DELETE operation deletes the selected lists and libraries. To perform this operation I prefer using a temporary site with lists & libraries.

img10.jpg

After selecting the items, click the Delete Selected button. You will get the following confirmation dialog:

img11.jpg

On confirming yes, the selected items are deleted. You will see the items missing in the next refresh.

img12.jpg

 

Code

The following is the code for the EMTPY operation:

private void PerformEmpty()

{

    using (SPSite site = new SPSite(SquadronContext.Url, SquadronContext.GetUserToken()))

    {

        using (SPWeb web = site.OpenWeb())

        {

            foreach (string title in NameList.CheckedItems)

            {

                SPList list = web.Lists[title];

                int count = list.Items.Count;

                for (int x = list.Items.Count - 1; x >= 0; x--)

                {

                    list.Items[x].Delete();

                }

                 SquadronContext.WriteMessage(title + " EMPTY performed by deleting " + count.ToString() + " items");

            }

        }

    }

    SquadronContext.WriteMessage("Performed Empty operations.");

}

The following is the code for the DELETE operation:

private void PerformDelete()

{

    using (SPSite site = new SPSite(SquadronContext.Url))

    {

        using (SPWeb web = site.OpenWeb())

        {

            foreach (string title in NameList.CheckedItems)

            {

                SPList list = web.Lists[title];

                try

                {

                    list.Delete();

                SquadronContext.WriteMessage(title + " DELETE done.");

                }                catch (Exception ex)

               {

                   SquadronContext.WriteMessage("DELETE Exception for " + title + " " + ex.ToString());

               }

           }

       }

    }

    SquadronContext.WriteMessage("Performed DELETE operations.");

    RefreshList();

}

References

http://squadron2010.codeplex.com/

Summary

In this article we have explored the EMPTY & DELETE operations of Squadron for SharePoint 2010 tool.  I repeat that this tool is free for use and in the long run there should be more and more utilities incorporated.

COMMENT USING