locked
Is there any type of "bulk edit" function or something already written in powershell? RRS feed

  • Question

  • I have a custom field that need to be change (to an attribute already on the look-up table) on many projects.  Is there any type of bulk edit function for custom fields?

    Thank you,

    Sandy Strong

    Thursday, January 14, 2016 4:20 PM

Answers

All replies

  • Hi Sandy,

    Since you are trying to change only one Custom Field, you could potentially write a SQL script to change the field value for all the items. Powershell would not be required as such.

    Thanks, A

    • Proposed as answer by Abhijit Wadagole Thursday, January 14, 2016 10:53 PM
    • Unproposed as answer by PWMatherMVP Friday, January 15, 2016 8:19 AM
    Thursday, January 14, 2016 10:53 PM
  • Hi Sandy,

    I used PSI to update project custom field values for single project.

    You can create a console application and loop through all the projects. It might be possible using power shell as well but I never tried it.

    Hope this helps.

    Thanks,

    Vedika Sawant

    Friday, January 15, 2016 7:33 AM
  • Yeah PowerShell will work but you will need to either use the PSI or CSOM. CSOM is only available in 2013. Or look at the SharePoint add-ins for PS 2013:

    https://store.office.com/bulk-edit-WA104148561.aspx

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com | CPS | MVP | Downloads

    Friday, January 15, 2016 8:21 AM
  • Thank you all for your help.
    Monday, January 18, 2016 4:00 PM