locked
PSI Bulk Project update on Custom Field lookup tables. RRS feed

  • Question

  • Using PSI Is it possible to update project custom filed which has a lookup table. I tried but it throws the following exception

    An unhandled exception of type 'System.Web.Services.Protocols.SoapException' occurred in System.Web.Services.dll

    Additional information: ProjectServerError(s) LastError=CICOCheckedOutInOtherSession Instructions: Pass this into PSClientError constructor to access all error information

    Any Idea on this.


    VIKRAM

    Thursday, January 15, 2015 10:03 PM

Answers

All replies

  • Hello,

    If you are trying to update the lookup table values, see this PowerShell example:

    https://gallery.technet.microsoft.com/Update-Server-Lookup-table-bb1ae14f

    Paul


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

    • Marked as answer by PWMatherMVP Wednesday, October 12, 2016 8:28 AM
    Thursday, January 15, 2015 11:19 PM
  • Hi Paul,

    Thanks for replying. I am trying to update project custom fields using PSI. Custom Field are Lookup Field. Do you have anything on this.

    Thanks


    VIKRAM

    Friday, January 16, 2015 12:07 AM
  • Hi Vikram,

    You can still use Paul Mather's script as reference. One step I assume is missing in your code is to make sure the project is not checked out already by another user when you try to update the custom field.

    Your steps would be like:

    1. check if project checked out

    2. if not, check out and run the rest of the steps

    3. if yes, do nothing?

    Hope this helps

    Paul

    • Marked as answer by PWMatherMVP Wednesday, October 12, 2016 8:28 AM
    Saturday, January 17, 2015 6:43 PM