• This is very good and helpful resource. Thank you !

  • Ramu

    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.

    • Stefan Bauer

      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.

  • Vinay

    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)

    • Stefan Bauer

      Hi Vinay,
      have you used the SharePoint admin url or the portal url?

      Kind regards
      Stefan

  • Vinay

    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.

  • is there away to get this to work in VS 2013?

    • Stefan Bauer

      You just need to upgrade the solution to VS 2013 but it should work.

  • Steve Lloyd

    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.

    • Stefan Bauer

      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

  • Steve Lloyd

    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

    • Stefan Bauer

      Glad I could help. If you need further assistance please feel free to ask again 😉

      /Stefan

    • 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?

      • Stefan Bauer

        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.

  • Srikanth

    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.

    • Stefan Bauer

      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

  • Julian

    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?

    • Stefan Bauer

      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

  • srinivas0781

    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

    • Stefan Bauer

      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

  • srinivas0781

    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

    • Stefan Bauer

      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

  • Maximilian Kohl

    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

    • Stefan Bauer

      Hi Maximilian, I always tried this code with an real Office 365 Admin not a federated one. You can also check out a similar sample in the Office 365 Pattern and Practices

      Maybe you get this running.

      /Stefan

      • Maximilian Kohl

        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!

        • Stefan Bauer

          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

          • Maximilian Kohl

            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!!

          • Stefan Bauer

            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

  • Scott McKenzie

    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

    • Stefan Bauer

      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

      • Scott McKenzie

        Stefan,

        Got it working. My Text File was saved as UTF-8 Encoded. Once change to ANSI it worked like a charm.

        • Stefan Bauer

          Great. Thanks for the update!

          /Stefan

        • Stefan Bauer

          Great. Thanks for the update!

          /Stefan