Update Project Server 2010 / 2013 Lookup table with values from a text file

This PowerShell script will add lookup table values from a text file into the specified lookup table. The values to add will need to be in a list in a text file

4.7 Star
2,498 times
Add to favorites
Project Server
E-mail Twitter del.icio.us Digg Facebook
  • How to update existing Look Up values?
    1 Posts | Last post September 27, 2017
    • I am finding code samples for adding a new row or deleting row from lookup table. But how can i update the value of existing row in a lookup table?
  • Error After running the Script
    1 Posts | Last post August 27, 2014
    • Hi, Thank you so much for the script. We are getting an error when updating the table. Error updating the Lookup table, see the error below:
      Exception calling "UpdateLookupTables" with "4" argument(s): "Unhandled Communication Fault occurred". 
      Can you help us in resolving this?
      Thanks and Regards
  • Can we use this script to delete rows?
    2 Posts | Last post January 10, 2013
    • The script is great and is giving me lots of ideas. We've been having a nasty problem where we are stuck with a multi-level lookup table with lots of unique values (<6000). The web control that would let me delete some of them is so slow, it's unusable. I was wondering if this script could be made to do the opposite and take a list of value from a file and delete them. That would be awesome. 
      Great contribution!
    • Hello, thanks for the good feedback. Yes this script could be reworked to delete lookup table values but you will need to be careful when deleting lookup tables values if those values are in use as you will then need to edit those entities to set the correct values.