Data combining from two files and weired issue in FIM 2010

Experts,

Following is the scenrio:-
User File
empid:firstname:lastname:deptnumber
DeptFile
deptnumber:departmentname:companyname:

Finally
Object type 'person' in metaverse and fim service should have all attribute:
Object Type - Person
Attributes - empid,firstname,lastname,deptnumber,depatmentname,companyname

To implement this:-
I created Inbound rule for User File. Relation ship criteria as accountname=empid and selected 'create resource in FIM'

Again created Inbound rule for DeptFile. Relationship criteria as deptnumber=deptnumber and not selected 'create resource in FIM'.

Well the Inbound rule for User File is working fine but Inbound rule for DeptFile is not updating depatmentname and companyname in 'Person' object.

Also intemittently I see following error:-

"
The synchronization rules have changed.

In order to apply this change to all imported objects, you must run full synchronization or full import and full synchronization.

Do you want to continue with the selected run profile?
"

Any Ideas where I am going wrong?

Thanks,
Mann

April 17th, 2014 5:28am

Hello,

depatmentname and companyname on 'Person' object will not be automatically update. You need to do Extended rule to achieve that.

And if I understand, you have two MA: one for Person and the other one for Department? So you will need to use FindMVEntries() to get your department object for the depatmentnumber on your person objects

and the message you see is not an error but a warning: FIM Sync invite you to run a full run profile to apply your new import flow.

Regards,


Free Windows Admin Tool Kit Click here and download it now
April 17th, 2014 9:03am

Thanks Sylvain!

Situation is happening as you mentioned.

When I import data from department file, person object gets updated if it find only one record matching however most of time there is a single department for many users. In this case new department row just remain as disconnector.

Is there any way to resolve this without coding? I am using FIM 2010 R2 SP1.

Thanks,

Mann

April 17th, 2014 9:41am

If you don't want to write code in FIM, perhaps you could combine the files using powershell before importing it to FIM, that way you only need one MA.

#Import user csv file
$userlist = import-csv "C:\temp\users.txt" -Delimiter ":"

#Import department csv file
$departmentlist = import-csv "C:\temp\departments.txt" -Delimiter ":"

#Create a hashtable of departments
$departmenttable = @{}

foreach ($department in $departmentlist){
  $departmenttable.add($department.deptnumber,$department.departmentname)
}

#Create hashtable of companies
$companytable = @{}

foreach ($company in $departmentlist){
  $companytable.add($company.deptnumber,$company.companyname) 
}

#Map userobjects to departmentnames and write to file
$tofile = New-Object System.IO.StreamWriter("C:\temp\result.txt")
$tofile.writeline("empid:firstname:lastname:deptnumber:departmentname:companyname")
foreach ($user in $userlist){
$tofile.writeline($user.empid + ":" + $user.firstname + ":" + $user.lastname + ":" + $user.deptnumber + ":" +  $departmenttable.item($user.deptnumber) + ":" + $companytable.item($user.deptnumber))
}
$tofile.Close()


Free Windows Admin Tool Kit Click here and download it now
April 18th, 2014 4:39am

You cannot do this update directly in the Sync Engine as it will not update cross-object. You could bring all departments into the FIM Service and have some workflows in there update all persons. This would mostly require some custom workflows. I have some workflows on CodePlex that could assist you in doing this - have a look at these - http://fimactivitylibrary.codeplex.com/wikipage?title=Copy%20Values&referringTitle=Documentation

Deeper explanation of this would require a longer time, though.

Another option is of course to replace the File MA's with a PowerShell MA (either mine or Microsoft) and do the combining in the import scripts for this MA. This approach may be simpler if you know Power

May 7th, 2014 5:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics