topic Re: import Users in Application Development and Automation Discussions

import Users

Former Member — Wed, 29 Aug 2007 13:55:44 GMT

Hi experts,

I have 40 users in sandbox system and around 20 roles that I have setup in sandbox.

Can anybody tell me step by step how to import them in Dev system? so I don't have to created them again. there is no Transport path setup between sandbox and Dev system.

always appreciate your help.

Thanks

Re: import Users

Former Member — Wed, 29 Aug 2007 14:06:27 GMT

You need to recreate the users in DEV , but for roles you can transport them if you have set up transport ( usually there wont be a transport route from sandbox to Dev ) or download the roles and upload them using pfcg

Thanks

Prince Jose

Re: import Users

Former Member — Wed, 29 Aug 2007 15:00:35 GMT

Thanks dude

Anybody has any other idea?

Re: import Users

Former Member — Wed, 29 Aug 2007 15:20:16 GMT

as long as there is not transport patch between DEV and Prod (WHY NOT) there is no other way than recreate them manually or via a CATT.

Re: import Users

Former Member — Wed, 29 Aug 2007 15:23:01 GMT

sorry misread the previous posting: it is wise NOT to have transport path between sandbox and DEV.

DEV is the place were you always manually recreate everything you sucessfully tested in the sandbox!

Re: import Users

Former Member — Wed, 29 Aug 2007 15:29:45 GMT

Thanks

Can I import them in excel sheet from the sandbox, so I know how many are there, Can anybody tell me step by step how to import them in spreadsheet.

Thank you so much

Re: import Users

Former Member — Wed, 29 Aug 2007 18:48:52 GMT

I am not sure if you can import users in excel spreadsheet, I know you can download/upload roles.

Best is manually create then using CATT script.

Re: import Users

Former Member — Wed, 29 Aug 2007 22:17:24 GMT

For the roles, you can download them from your sandbox via PFCG, entering role name and then selecting "Download" from "Role" on the menu bar. Then download it to a location on your hard drive. Then uploadd to your target system by executing PFCG (in dev) and selecting upload and select the role. The roles need to be re-generated after they've been uploaded (can only be done one at a time).

For the users, creating a SECATT script to re-create them is your best bet. Here's an ok how to --> http://www.sapsecurityonline.com/tutorials/secat_test.htm (you have to record the steps to create a user yourself). You can download the user information from either SUIM or a usr* table.

Re: import Users

Former Member — Thu, 30 Aug 2007 10:27:55 GMT

Hello,

As per as role u have one option of download and upload.

download the roles from the sandbox to your desktop and upload it your target system. after uploading dont forget to generate the profile for that role if u want to generate profile at a time use the Txn SUPC for mass profile generation.

Re: import Users

Former Member — Thu, 30 Aug 2007 11:25:09 GMT

You can transport users too, (in this case) via a transport of copies:

Create a T.O.C in the source system, & include the following tables:

USR02,

USR03,

USR04,

UST04,

USGRP

Now include the required user details as "content" of these tables, in the TR.

Release & import this request.

Remember this will only import the users, their passwords, their roles/profiles "assignment" (But NOT the actual roles/profiles itself)

So please make sure that the roles exist before importing the users.

Finally do a user comparison for these roles.

Re: import Users

Former Member — Thu, 30 Aug 2007 13:06:12 GMT

Hi Kumar

What is TOC (Transport of copies) how to do that ,what is the transaction code for that and how to include table in Transport request?

Re: import Users

Former Member — Fri, 31 Aug 2007 04:39:59 GMT

Yes T.O.C means a Transport of Copies, which can be created in Transaction SE01.

This can be used to move objects between systems which are not directly connected.

Coming to the 2nd part, once you create a T.O.C, go to its object list (in change mode) & include the above tables as follows:

R3TR TABU USR02

R3TR TABU USR03

......etc

& then double click on each one & include the user details as table entries/keys.

PS:

Please award points, if this helps you.