CSV format for User Assignment to Org Structure

[Former Member]

Hi All,

Doesn anyone has a CSV file format for USer assignments to Org Structure? I want to upload users to different deptts in Org Structure using a file since we have large number of users so one by one manaul assignment using USERS_GEN is not feasible. All answers will be rewarded. My email ID is- <removed by moderator>

If someone has this file, please send to above mail address.

Regards

Kapil

[Former Member]

Kapil-

Transaction "USERS_GEN" offers the functionality to upload users into the org structure from an external file - this is the first option in USERS_GEN. When you use this option you "check" the fields you are including in your file. I would always provide at least the following:

USER ID(required)

LAST NAME(required)

Org Unit(required)

Country

First Name

Role

Thus my record would look like:(assumes I set my seperator in GoTo=>Define Seperator as comma)

BUSER,Jones,50000100,us,Jack,Z_SHOPPER_ROLE

Also here is the help info from the upload program:

Option 1: Upload Users from File (ASCII)

Prerequisite

The data fields for a user are in a row and are separated by a semicolon. You can generate these files in MS Excel, for example, (save the Excel sheet as file type CSV). The order of the fields is critical.

Example

o D030456;Smith;50000105;tom.smith@aaaaaa.com;de

o C00213445;Doe;50000106;jane.doe@bbbbb.com;us

o D23456;Moser;50010203;25534dr@ccccc.com;dk

Note

In the menu under Goto -> Define Separator, you can determine if a semicolon or a comma is to be accepted as a separator.

If all the data in the file is not accessible, default values are used for the missing data. If the file contains an e-mail address, the system generates a password and sends it via e-mail to the user. If the file has not e-mail address, you are prompted to specify an initial password for all users.

You must specify the technical key for the fields Academic title, Form of address, Manager indicator, Role and Country.

o You can find the system keys for the academic title in field TITLE_KEY of table TSAD2.

o You can find the system keys for the address text in field TITLE of table TSAD3T.

o If the user is to be a manager, you check the field Manager indicator.

o If you are assigning a role for a user, the file must contain the technical name of the role. You should check in advance in Transaction PFCG if the role actually exists.

Regards-

b