33 comments

  1. we don’t have AD synch with office 365 and we would like to update Manager properties for all the users in sharepoint online. I was run the tool to update manager value but got error. please help on this.

    1. Can you please be a little bit more specific what error you got? To update the manager attribute please make sure that you have the property formatted correct.
      You should specify the full claim user name. For example:
      i:0#.f|membership|stefan.bauer@myoffice365.com

      The first part specifies the claim that should be used while the second part is the Account Name.

  2. Hi, Thanks for the userful article. I downloaded the tool buts it giving me acception after successfully authenticating
    Unhandled Exception: System.Web.Services.Protocols.SoapException: Server was una
    ble to process request. —> Object reference not set to an instance of an objec
    t.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClie
    ntMessage message, WebResponse response, Stream responseStream, Boolean asyncCal
    l)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodN
    ame, Object[] parameters)
    at n8d.UserProfileBulkImport.UserProfileWS.UserProfileService.GetUserProperty
    ByAccountName(String accountName, String propertyName)
    at n8d.UserProfileBulkImport.UserProfileUpdater.Update()
    at n8d.UserProfileBulkImport.Program.Main(String[] args)

  3. Thanks Stefan, it is working now. I was using wrong separator in import file instead of tab.

    It’s a nice little tool. Appreciate you putting it up on internet.

  4. Thanks for this Stefan.

    I’m afraid I’m just a site administrator and I have no background in MS programming so please excuse the newbe question.

    What are the prerequisites for running the tool? It is not finding the Microsoft.Sharepoint.Client.runtime. I have placed a copy of the DLL in the source directory but no luck.

    1. Hi Steve,

      you can download a copy of the client components SharePoint Server 2013 Client Components SDK
      . After you downloaded and installed this you should be able to get this work. If you look for the Assembly please navigate to the “your windows folder\assembly\”. This is the so called global assembly cache where all the global dll are stored. You should then see in the list of assemblies the Microsoft.SharePoint.Client.runtime there. Hope this helps if not I will check it directly in one of my VMs.

      /Stefan

  5. Thanks Stefan. That did the trick. Process worked as advertised. It takes some time for the changes to get sync’d out in the sharepoint.com world. but now that is done the changed data is in place.

    Great to have a good sample as starting point for our process. It looks like the O365 – sharepoint.com sync is seriously limited so having a fallback keeps our project from going off the rails.

    Thanks again

    1. Stefan, I am not a developer but I am trying to accomplish many of the same things folks have listed here. I am trying to use your tool but when I enter my password I get an error that states: “The partner returned a bad sign-in name or password error. For more information, see Federation Error-handling Scenarios.” I am a site collection administrator. I even changed my password and allowed the weekend for everything to sync. We are using ADFS but I changed my passwords with Microsoft to all match. Any suggestions?

      1. I suggest you have tried it with your administration account that comes with the federation. You also have a pure Office 365 tenant administrator. You should try this account. The sign-in method I use to authenticate supports only pure Office 365 authentication but not ADFS user.

        This I think is the cause of this error message.

  6. This is really very helpful.Thanks for the Post.If we want to create or migrate Custom profile properties from SharePoint 2010 to Office365,how we can achieve it?
    Please help on this.

    1. The CSV import supports those custom property import. All you need to do is to specify the name of the property on the first line. Unfortunately I don’t have a script ready that exports it from the on premise installation but you might find one on the web.
      /Stefan

  7. Hi Stefan,

    The tool is really good.

    I have a little issue, some of my users are in office365 but have never log in the sharepoint site, so the User Profile is not created.

    How can I bulk create the user profile first?

    1. Hi Julian,

      thank you for your feedback. Currently I don’t support the bulk creation of the profiles but it can be done with code. You might will find some powershell that does the job.

      /Stefan

  8. Hello Stefan,

    How do we bulk upload employee id or Skills to Manage User Profiles in Sharepoint online in Office 365.

    Please help me on this.

    Regards,
    Srinivas.K

    1. Please make sure that the CSV is Tab separated and not delimited by comma. The skills go directly into the managed meta data. The field name is SPS-Skill and you should check how the various items are delimited. This can be semicolon or a comma. You text file need to have the same delimiter inside.

      /Stefan

  9. Hello Stefan,

    After getting the authentication, I am getting the below error.

    Unhandled Exception: System.Web.Services.Protocols.SoapException: Server was una
    ble to process request. —> Object reference not set to an instance of an objec
    t.
    at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClie
    ntMessage message, WebResponse response, Stream responseStream, Boolean asyncCal
    l)
    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodN
    ame, Object[] parameters)
    at n8d.UserProfileBulkImport.UserProfileWS.UserProfileService.GetUserProperty
    ByAccountName(String accountName, String propertyName)
    at n8d.UserProfileBulkImport.UserProfileUpdater.Update()
    at n8d.UserProfileBulkImport.Program.Main(String[] args)

    Please let me know what mistake I am doing here.

    Regards,
    Srinivas.K

    1. During my testing I got the same error when I tried to access the web service from a site collection URL. Please make sure that you pass in the SharePoint Administration URL from Office 365 and not the one of the portal.

      /Stefan

  10. Hi Stefan,
    thanks for the tutorial!
    I somehow get the error “Identity Client Runtime Library could not look up the realm information for a federated sign-in.”.
    Do you know if this error is related to the code, any dlls or the credentials (which seem to be right)?

    Thanks! Max

      1. Hey Stefan,

        thanks for the instant reply! It worked smoothly with my colleague’s account. Great!
        I saw the PnP solution before and embarrasingly still do not know how to find/generate the .exe file..?

        Thanks again for your work and help!

        1. Hi Max,

          to generate the solution you need to open it in Visual Studio and compile it manually. Glad to hear that it works for you now.

          /Stefan

          1. Thanks Stefan! Do you know if there is a way to include commas in a single value field? It seems to serve as some kind of blocker that cuts the rest of the field to be imported.
            Both ” and ‘ are entered in the field. I try to insert something like “Wien, sterreich” (without “).
            Thanks a bunch!!

          2. Hi Maximilian,

            from my point of view it shouldn’t be a problem with my code because I use tab-stops as delimiters so it shouldn’t split the common. You also don’t need the quotes. I haven’t tested it but I think it should work. Is there a special error you got back?

            /greetings
            Stefan

  11. Every time I’m running the tool, it tells me that n8d.UserProfileBulkImport has stopped working. It is always breaking with a SOAPException was unhandled. Any ideas as to why this is happening. Thanks

    1. Hi Scott,
      sorry haven’t used the code in a while. Maybe Microsoft has changed something in the background.
      Have you tried to pass in the url to the Office 365 admin interface?
      /Greetings
      Stefan

Leave a Reply

Your email address will not be published. Required fields are marked *