After seeing several questions on how to take a list of users and create a file that can be imported into the portal I decided that I would share, what I have found to be at least, a very easy way of doing this. The first step is to make sure that your list of users are in an Excel spreadsheet and the users are listed by row. 
The next step is to create a Word file that has the attributes that you would like to maintain in the UME. 
The next step is to activate the mail merge features in Word. This can be found under Tools -> Letters And Mailings -> Mail Merge if you have Office 2003. 
Click on the next button two times to bring you to step three. 
From here click on the browse button to select the data source. A Windows explorer box will pop up. Navigate to the spreadsheet with the list of users. 
Select the sheet with your users in it. 
You can modify which elements are used in the mail merge with this screen but for this demo we will be using all of them so choose next. 
Now click on the "Next write your letter" option. 
Position your cursor after the first element in the Word document (UID) and click "More Items". 
Click the insert button to insert this field next to the UID text. 
Continue in this fashion until you have added all the fields. 
Then click the "Next: Preview your letter" option. Now click on the "Next: Complete the merge" option. 
Click on the "edit individual letters" option. 
This will generate a word document with a user per page. Now all you have to do is remove the unnecessary spacing and you can import this file into the UME. 
This same method can be used for other UME operations as well.
The next step is to create a Word file that has the attributes that you would like to maintain in the UME. The next step is to activate the mail merge features in Word. This can be found under Tools -> Letters And Mailings -> Mail Merge if you have Office 2003. Click on the next button two times to bring you to step three. From here click on the browse button to select the data source. A Windows explorer box will pop up. Navigate to the spreadsheet with the list of users. Select the sheet with your users in it. You can modify which elements are used in the mail merge with this screen but for this demo we will be using all of them so choose next. Now click on the "Next write your letter" option. Position your cursor after the first element in the Word document (UID) and click "More Items". Click the insert button to insert this field next to the UID text. Continue in this fashion until you have added all the fields. Then click the "Next: Preview your letter" option. Now click on the "Next: Complete the merge" option. Click on the "edit individual letters" option. This will generate a word document with a user per page. Now all you have to do is remove the unnecessary spacing and you can import this file into the UME. This same method can be used for other UME operations as well.
8 Comments
