Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I get a nightly update of all users' profile properties via csv. I would like to setup the User Profile Service App to sync to that CSV. I assume this shouldn't be terribly difficult and has likely been done before. However my Google-Fu is not up to snuff and I cannot find any good examples. I have found some examples using PowerShell but I thought that using BCS and sync might be a better idea. Could someone please help me find an example of doing this in C#?

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Personally, I would use PowerShell. But, if you really must use BCS, look at the samples for creating a custom BSC Connector to XML, XLS, or CSV. There are several out there. Scot Hillier wrote the book and there are samples in there: http://www.amazon.com/Professional-Business-Connectivity-Services-SharePoint/dp/047061790X

Once you have the BCS connection working you then create a secondary sync connection in the UPA for your BCS import and identify the key, like email or username.

Note, you will still need an LDAP source for initially creating users.

share|improve this answer
    
What are the advantages of PowerShell over BCS? –  James Grizzle Mar 28 '13 at 16:02
1  
Mostly, IMO, simplicity. Adding BCS adds a layer of complexity that may not be required. You can still schedule the job. –  Matthew McDermott Mar 29 '13 at 12:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.