Skip to Content

Step 1: Prepare an excel sheet with all the required columns.



User ID First name Last Name Group or role Email address


Step 2: Click on the option Step By Step Merge Wizard in MS word document


/wp-content/uploads/2015/12/step2_851332.png


Step 3: Select the radio button next to Letters on the right pane and click Next

/wp-content/uploads/2015/12/step3_851429.png

Step 4: Choose radio Button next to the Use Current Document and click on Next

/wp-content/uploads/2015/12/step4_851430.png

Step 5: Click on Browse and chose the excel file created

/wp-content/uploads/2015/12/step5_1_851431.png/wp-content/uploads/2015/12/step5_2_851432.png

click ok

Then copy below in the word document =

User]

uid=

last_name=

first_name=

email_address=

password=

group=

Step 6: Map the columns with the required fields after you copy the format from an existing exported user file


now map this fields with the corresponding  excel fields. To map this put cursor on uid and click on Insert merge field as shown below. Complete this for all fileds

/wp-content/uploads/2015/12/5_2_851433.jpg

/wp-content/uploads/2015/12/6_1_851434.jpg

/wp-content/uploads/2015/12/6_2_851441.jpg/wp-content/uploads/2015/12/6_3_851442.jpg

click ok

Once you click on ok you will get all excel fields & their value mapped. Now just select all from word document and paste into one text file.

7.4.JPG

Step 7: Login to SAP Portal User administration  and go to User administartion – Import


7.3.JPG


7.2.JPG7.3.JPG

All the users in excel got created now.

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply