Bulk Import tool – (401) Unauthorized error #ProjectServer #PS2010 #SP2010
Before i proceed, please note that Bulk Import tool was released along with the release of Project Server 2010 and to be used with Project Server 2010. Till date, i am not sure, if Bulk Import tool without modification will work with Project Server 2013. This issue, and its resolution, is for Project Server 2010 environment.
Some time back Andrew Lavinsky had discuss Bulk Import tool feature in great detail through his blog, a blog worth every minute of your time. Please go through these blog posts if you are interested to use Bulk Import tool:
My post is to highlight the following issue you may come across while trying validating Site URL:
via All about Enterprise Project Management (EPM) http://khurramjamshed.blogspot.com/2013/12/bulk-import-tool-401-unauthorized-error.html
   The author of the blog has an extensive experience of working as an EPM Consultant. Currently he is located in Dubai, UAE and working for Microsoft partner organization as Project Server specialist. He has a thorough experience of providing Project Management technical/functional consultancy to all sort of organizations. He is a certified PMP, a Project Server MCITP, and also received a MS community contributor award 2011.
This article has been cross posted from khurramjamshed.blogspot.com/ (original article) |
SharePoint (and Project Server) Shenanigans 
Note there’s also some issue with access to the top level site in the Web Application. I’ve found in some circumstances, that’s the only site that would work with the Bulk Import Tool. As that’s typically locked down to everyone but admin, this is probably not a major issue.
For 2013 – there’s an OOTB option with workflow on lists to do the same (see my blog post from last week or so)…..and for Bulk Editing, there are apps in the App Store.