locked
Is it possible to bulk update a column on the data view of the Web part List on Sharepoint 2007 without writing any code? RRS feed

  • Question

  • I have a List in a data view. The user needs to enter/update value for a particular column. The data in the rest of the columns are pre populated from an excel sheet. Sometimes the user has to enter/update the same value in this column for multiple rows of data. Is there a way i can provide the user with an option to update all the rows at once. I am allowing the user to chose the value for the column from a drop down list.

    Is there a way i can allow the user to enter/ update multiple rows?

     

    Thursday, May 12, 2011 2:51 PM

Answers

  • Well.. what do you mean by "not writing any code?"  I'm assuming you mean managed code that has to be deployed as a solution? Otherwise the answer is no.


    If you mean you want to use something like jQuery then this is possible using SPServices (http://spservices.codeplex.com).  SPServices is a jQuery library that wraps SharePoint's Web Services in easy to call methods.

    You would utilize the "UpdateListItems" method to update multiple rows at once.  I have an example on my blog where I "clone" a list and all it's children, so the concept is very similar, instead of creating a lot of new entries "New" command, you will be updating a lot of existing entries "Update" command:

    http://sharepointhillbilly.com/archive/2010/11/22/using-spservices-amp-jquery-to-clone-a-parent-item-and.aspx

    There is also a lot of great documentation on the SPServices site. 

    Hope this helps,

    Mark


    The SharePoint Hillbilly Fewer Big Words... More Pretty Pictures... http://www.SharePointHillbilly.com
    • Marked as answer by Leoyi Sun Friday, May 20, 2011 9:42 AM
    Thursday, May 12, 2011 4:12 PM
  • Hi Sandeep,

    You can create your dataview as "Multiple item form". Users can then copy/paste the data in the fields and then click on "Save" button to save all the changes.

    Here's a screenshot of the the "Multiple item form" menu when inserting a  dataview (found it online on another site)

    http://nickgrattan.files.wordpress.com/2008/05/bulkedit4.jpg?w=700

     

    And, here's a screenshot of the dataview/dataform when it's inserted as "Multiple item form" (found it online on another site)

    http://www.endusersharepoint.com/blog/wp-content/uploads/2009/05/2009-05-25-DataViewWebPartEditing-01.png

     

    The above will make all the fields editable. If you don't want other columns to be editable, I believe you can dive into the xsl code and make changes to achieve that.

    Hope that helps...

     

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Leoyi Sun Friday, May 20, 2011 9:42 AM
    Saturday, May 14, 2011 3:27 PM

All replies

  • Well.. what do you mean by "not writing any code?"  I'm assuming you mean managed code that has to be deployed as a solution? Otherwise the answer is no.


    If you mean you want to use something like jQuery then this is possible using SPServices (http://spservices.codeplex.com).  SPServices is a jQuery library that wraps SharePoint's Web Services in easy to call methods.

    You would utilize the "UpdateListItems" method to update multiple rows at once.  I have an example on my blog where I "clone" a list and all it's children, so the concept is very similar, instead of creating a lot of new entries "New" command, you will be updating a lot of existing entries "Update" command:

    http://sharepointhillbilly.com/archive/2010/11/22/using-spservices-amp-jquery-to-clone-a-parent-item-and.aspx

    There is also a lot of great documentation on the SPServices site. 

    Hope this helps,

    Mark


    The SharePoint Hillbilly Fewer Big Words... More Pretty Pictures... http://www.SharePointHillbilly.com
    • Marked as answer by Leoyi Sun Friday, May 20, 2011 9:42 AM
    Thursday, May 12, 2011 4:12 PM
  • Hi Sandeep,

    You can create your dataview as "Multiple item form". Users can then copy/paste the data in the fields and then click on "Save" button to save all the changes.

    Here's a screenshot of the the "Multiple item form" menu when inserting a  dataview (found it online on another site)

    http://nickgrattan.files.wordpress.com/2008/05/bulkedit4.jpg?w=700

     

    And, here's a screenshot of the dataview/dataform when it's inserted as "Multiple item form" (found it online on another site)

    http://www.endusersharepoint.com/blog/wp-content/uploads/2009/05/2009-05-25-DataViewWebPartEditing-01.png

     

    The above will make all the fields editable. If you don't want other columns to be editable, I believe you can dive into the xsl code and make changes to achieve that.

    Hope that helps...

     

     


    Pman
    http://www.pmansLab.com/
    • Marked as answer by Leoyi Sun Friday, May 20, 2011 9:42 AM
    Saturday, May 14, 2011 3:27 PM
  • I think that this worth looking at http://www.endusersharepoint.com/2009/05/27/data-view-web-part-the-basics-%e2%80%93-multiple-edit-forms/

    You can edit and save multiple items, you can set which columns are editable. All using the ootb dvwp stuff.


    -tom daly
    Monday, May 16, 2011 2:20 PM