Wikis - Page Details

First published by Carol Wapshere (MVP, Microsoft Partner)
When: 21 Jan 2011 12:47 AM
Last revision by Richard Mueller (cMVP, Microsoft Community Contributo)
When: 13 May 2013 11:46 AM
Revisions: 7
Comments: 4

Options

Can You Improve This Article?

Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.

How to Use Powershell to Import Schema Objects from a CSV File

FIM ScriptBox Item

Summary

This script may be used to create Attributes and Bindings in the FIM Portal Schema based on information in a CSV file.

The script comes in two parts:

Import-SchemaCSV.ps1 is used to generate a changes.xml file, and
CommitChanges.ps1 is used to import the changes into the FIM Portal.

If you are creating new attributes with bindings then you must run the process twice. The first time the attributes will be created, and the second time the bindings will be created, using the GUIDs of the new attributes.

The script does not currently create Resource objects. Any Resource types specified in the CSV file must already exist.

Usage:

Fill in the CSV file. By default the script looks for "import.csv" - a different file name may be specified with the -File parameter. There is a sample import file in the download.
Run Import-SchemaCSV.ps1. This will export the current FIM Schema and generate changes.xml.
Backup your FIMService database.
Run CommitChanges.ps1.
Repeat from step 2 if you need to create bindings for new attributes.

Script Code

Please download using the following link. The package includes template files which must be located in the same folder as Import-SchemaCSV.ps1.

http://code.msdn.microsoft.com/Project/Download/FileDownload.aspx?ProjectName=FIMScriptbox&DownloadId=14871

Note
To provide feedback about this script, create a post on the FIM TechNet Forum. For more FIM related Windows PowerShell scripts, see the FIM ScriptBox.