Hi Sahil,


Is there a way to import the user profile data into site collection users automatically / manually in a batch?

hi Sahil,

Thanks for your post.

I am facing problem while importing profile in profile database using BDC.

1.I added those users on my computer (under user group).


2.I manually added users in Profile database of sharepoint with accountname same as users on the machine (This is workaround since I am virtual machine which can not access AD).


3. Then I have oracle database which is having some additional columns.


4. I am querying data through BDC and also able to see this is web part.


5. But when I try to import this imformation using profile import it is failing.

Any idea why ? Does it have dependency on AD(always)?

Can you give more details as to the difference between the full import and the incremental import? What exactly is the difference between the two?

Hi Anand,

I am also facing the same problem.Your problem got solved?

Please let me know.

Thanks in advance.


Aarthy

I have created a BDC application file just by following your blog procedures.

My metadata as follows :


<LobSystem


Name="CustomersDB"


Version="1.0.0.0"


Type="Database"


xmlns="http://schemas.microsoft.com/office/2006/03/BusinessDataCatalog">;

<Properties>


<Property Name="Wildcardcharacter" Type="System.String">%</Property>


</Properties>

<LobSystemInstances>


<LobSystemInstance Name="CustomersDB">


<Properties>


<Property Name="AuthenticationMode" Type="System.String">PassThrough</Property>


<Property Name="DatabaseAccessProvider" Type="System.String">SqlServer</Property>


<Property Name="RdbConnection Data Source" Type="System.String">XXXXXXX</Property>


<Property Name="RdbConnection Initial Catalog" Type="System.String">AdventureWorks</Property>


<Property Name="RdbConnection Integrated Security" Type="System.String">SSPI</Property>


</Properties>


</LobSystemInstance>


</LobSystemInstances>

<Entities>


<Entity Name="CustomersDB">


<Properties>


<Property Name="LastName" Type="System.String">LastName</Property>


</Properties>

<Identifiers>


<Identifier Name="ContactID" TypeName="System.Int32"></Identifier>


</Identifiers>

<Methods>


<Method Name="GetContactDetails">


<Properties>


<Property Name="RdbCommandType" Type="System.Data.CommandType">Text</Property>


<Property Name="RdbCommandText" Type="System.String">


SELECT ContactID, FirstName, LastName,Phone FROM Person.Contact WHERE ContactID = @ContactID


</Property>


</Properties>

<FilterDescriptors>


<FilterDescriptor Name="ContactID" Type="Comparison" />


</FilterDescriptors>

<Parameters>


<Parameter Direction="In" Name="@ContactID">


<TypeDescriptor Name="ContactID" AssociatedFilter="ContactID" TypeName="System.Int32" IdentifierName="ContactID" />


</Parameter>


<Parameter Direction="Return" Name="GetCustomers">


<TypeDescriptor TypeName="System.Data.IDataReader, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" IsCollection="true" Name="CustomerDataReader">


<TypeDescriptors>


<TypeDescriptor TypeName="System.Data.IDataRecord, System.Data, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" Name="CustomerDataRecord">


<TypeDescriptors>


<TypeDescriptor TypeName="System.Int32" IdentifierName="ContactID" Name="ContactID" />


<TypeDescriptor TypeName="System.String" Name="FirstName" />


<TypeDescriptor TypeName="System.String" Name="LastName" />


<TypeDescriptor TypeName="System.String" Name="Phone" />


</TypeDescriptors>


</TypeDescriptor>


</TypeDescriptors>


</TypeDescriptor>


</Parameter>


</Parameters>

<MethodInstances>


<MethodInstance Name="CustomerFinderInstance" Type="Finder" ReturnParameterName="GetCustomers" />


<MethodInstance Name="CustomerSpecificfinderInstance" Type="SpecificFinder" ReturnParameterName="GetCustomers"/>


</MethodInstances>

</Method>


</Methods>


</Entity>


</Entities>

</LobSystem>

Parameters:


input parameter as ContactID


Return parameter : GetCustomers(contactID,firstName,Lastname,Phone)

Also i have added a property called ContactID in user profile which I have used for mapping the BDC(1:1 mapping).


Then , I have created another profile property called MyLastName and mapped it to the LastName BDC connection field.

I have specified values for contactId to some user profiles.Then , after doing the "Full Import" , the MyLastName property is not getting populated.

Please provide guidence .. Its urgent!!

Awaiting for your reply.. Thanks in advance!!

Hi there


I am having the following problem.


When I check the users profiles for a couple of users in the "Shared Services Administration: SharedServices" I see that the title is correct, meaning it has been correctly updated from Active Directory. Now once I am on the sharepoint site and I do a search on the employee list, the data is outdated.


Any ideas on what could be causing the problem?


Thank you.

Hi,

I'm having the same problem. I read somewhere that SP1 solves the problem but I don't feel like installing it right now... Is there another solution?

Thanks a lot!

Hi Paula;


In my particular case, when I go to the "Employee Lookup" i find people that do not exist anymore, Of course, when I click on the results, I get user not found. I think that there is some type of index keeping these records, but can't find out where.


I hope someone can help us out with this.

Marcelo

Hi Sahil.....I opened my SharedServices and Clicked on "UserProfiles and Properties" it gives an error....that is "An error has occurred while accessing the SQL Server database or the Office SharePoint Server Search service. If this is the first time you have seen this message, try again later. If this problem persists, contact your administrator."

can u plz tell me how can i remove this Error

We have same user in different sources. Different sources has different information and I need to bring them all together in to MOSS profile. Will creating different import connections is the way to go? There are some properties exist on multiple systems such as firstname, email etc. How does import handles them?

I have successfully imported userids from Active Directory, but some of them did not have an email associated with them. I have now updated the email address for these people in Active Directory, done a full import in SharePoint, but the email addresses are not showing up in SharePoint, so these people cannot set alerts or receive workflow emails. What do I need to do to get these email addresses to be imported into SharePoint?

How do you limit the import of users to a specific OU? I want data imported only for actual users and not other accounts.

hello...


can some 1 help me i solving dis problem....?


I ahve to add users from Active Directory in sharepoint groups....(only add thos e emplyess whose designation is PM)

To limit import of users to a specific OU:


Go to Shared Service Administration, then user profiles/properties and configure profile import. Select Custom Source then view import connections. (Create a new AD connect or edit the current one if you already have one setup)


In the search base box, type in OU=OuName,DC=Domain,DC=com


tweak whatever other settings you want, and you should be good to go...

I have imported users from Active Directory into MOSS 2007 but when a user tries to log in this is what we get.

Error: Access Denied. You are currently signed in as:

Any ideas on how to fix this will be greatly appreciated.

hey sahil i just want to let you know "YOU ARE THE BEST".


I read your articles on BDC they are good .


Thanks for the good work.

I have the same problem as Jane. It didnt import the email address, so i added it in the mysite, but it does not show up in the sharepoint site. It says the user has no email address and i cannot edit that field anywhere.

Please help

Hi, if i have configured a automatic import connector like this: search base:OU=Sales,OU=London,CN=contoso,CN=COM and userfiter as default:(&(objectCategory=Person)(objectClass=User)). And there are changes in AD, OU-s will be rearranged. Lets say: OU=Sales,OU=London,CN=contoso,CN=COM will become OU=Sales,OU=South,OU=Bristol,CN=Contoso,CN=COM. How will this affect the users whos profiles are already imported to Sharepoint?


I have to make change in automatic import connector for it to import new users, that goes without saying, but will the already imported profiles work also?

Thank you

Can you import a GROUP from active directory? Can I create a group on the domain like SharepointManagers and then configure an LDAP connection to bring that group into sharepoint such that I can select the group in a people or group drop down?

I imported users from two ADs, AD1 and AD2, AD1 is the AD for farm of MOSS, and import works fine, when i try to login to the other domain AD2 users or add user message: The user does not exist or is not unique. what shall i do to solve this ?? if i use AD1 domain nothing happened

Hi,


i have imported ldap users to user profiles. but am not able to add this users to site.


please tell me solution it will be grate.

thanks in advance


kiran

Regarding the error on the User Profiles and Properties page "An error has occurred while accessing the SQL Server database ..."

May I suggest you check out the entry I just added to my blog: http://www.geekinthepink.info/2009/12/sharepoint-user-profiles-and-properties.html