Nick Grattan's Blog

About Microsoft SharePoint, .NET, Natural Language Processing and Machine Learning

Bulk Editing of SharePoint List Items

with 5 comments

Imagine you have a list with a “Confirm” yes/No field and you want a user to be able to view items and click a Check box on those items which are completed and click a Save button:

Bulkedit1

This saves the user opening each item in turn, changing the “Confirm” field and saving the item. This can be done using the SharePoint Designer and using a DataView. To do this:

  • Select File + New + Page to create a new ASPX page.
  • Choose “Create from Master Page…” and click OK and OK again to use the default master page..
  • Save the page as “BulkEdit.aspx” in the list’s folder, e.g. “ConfirmList” where the existing AllItems.aspx file exists.
  • “Create Custom Content” for “PlaceHolderMain” using the quick link:

Bulkedit2

  • Open the “Data Source Library” pane and click the list, e.g. “ConfirmList” and select Show Data:

Bulkedit3

  • Select the Insert Selected Fields as… button in the Data Source Details panel and select Multiple Item Form:

Bulkedit4

  • From the “Common Data View Tasks” menu select Edit Columns and remove all columns bar “Title” and “Confirm” (or whatever columns you want displayed).

You will now set the “Title” column to be read-only so that only the “Confirm” check box is editable.

  • Single click a “Title” edit box and click the “Common FormField Tasks” button (the greater than sign) and select “Text” from the “Format as” list.
  • Save the file.
  • To test, navigate to the page, e.g. TestSite/Lists/ConfirmList/bulkedit.aspx.

Also take a look at http://office.microsoft.com/en-us/sharepointdesigner/HA101191141033.aspx, this uses an XML file as the data source rather than a SharePoint list.

Written by Nick Grattan

May 13, 2008 at 12:13 pm

5 Responses

Subscribe to comments with RSS.

  1. […] Bulk Editing of SharePoint List Items […]

  2. And 2 years later I stumble accross this great post… Thanks!

    j4gg3d

    April 23, 2010 at 2:26 pm

  3. Thanks for nice and effective post!

    SH Pavel

    November 26, 2010 at 2:40 am

  4. Thank you so much it solved my issue

    haritha

    July 12, 2013 at 1:18 pm

  5. Hi, this would solve a mojor issue for me. But I don’t get what you are using: when you create the aspx page and Custom Content, are you in Sharepoint designer. I’m using SP designer 2013 and cannot see this quick link you are refering to. Thank you.

    Kulon

    March 7, 2014 at 1:02 pm


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: