Home > Khurram Jamshed > Bulk Import tool – (401) Unauthorized error #ProjectServer #PS2010 #SP2010

Bulk Import tool – (401) Unauthorized error #ProjectServer #PS2010 #SP2010

A quick note to share the Bulk Import tool issue i came across while working in NLB environment.

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:

The remote server returned a error: (401) Unauthorized.

Now if you are in NLB environment, and you are accessing your PWA using NLB URL, you will come across an error as mentioned above. 
Resolution is quite simple, though it took me a while to figure it out, you need to use your original PWA URL to access your PWA. Open Bulk Import tool now, ensure that you URL you are entering in also based on original PWA URL, click validate – and this time it work.
Hopefully this will help to some out there – happy importing new projects for analysis as a new year is not far away 🙂

via All about Enterprise Project Management (EPM) http://khurramjamshed.blogspot.com/2013/12/bulk-import-tool-401-unauthorized-error.html

Khurram Jamshed
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)

  1. December 18, 2013 at 14:31

    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.

  1. No trackbacks yet.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: