cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Translate the entire conversation x

How to batch create a large number of users in Windchill

SUZ.Pluto
10-Marble

How to batch create a large number of users in Windchill

How to batch create a large number of users in Windchill

From China
ACCEPTED SOLUTION

Accepted Solutions

Use a load file if your LDAP JNDI Adapter(s) are configured for read-write.

The process will fail if the user account already exists.

 
 
Loader syntax comes from %wt_home%\loadFiles\csvmapfile.txt...
User~create~wt.load.LoadUser.createUser~user~newUser~webServerID~fullName~Last~Locale~Email~Description~Title~Organization~Street1~Street2~City~State~Country~ZipCode~ignore~password~DirectoryService~AllowLdapSync~TelephoneNo~MobileTelephoneNo~FaxNo~UserDomain~CabinetDomain
 
CSV example for loading users (C:\temp\orgUsers.csv)
#User,user,newUser,webServerID,fullName,Locale,Email,Description,Title,Organization,Street1,Street2,City,State,Country,ZipCode,ignore,password
User,,jdoe,jdoe,John Doe,US,jdoe@company.com,Development User Account,,Org1,,,,,,,x,jdoe

 

Convert CSV to XML
windchill wt.load.util.CSV2XML -input orgUsers.csv -root C:\temp\loadFiles

 

Load XML file (Windchill must be running and available)
windchill wt.load.LoadFromFile -d C:\temp\loadFiles\orgUsers.xml -u {site administrator} -p {password} -CONT_PATH "/wt.inf.container.OrgContainer=Org1"

View solution in original post

4 REPLIES 4

We need more information to provide a decent response.

 

What LDAP are you using with Windchill and how is your Windchill configured for defining users?

If your LDAP JNDI Adapter(s) are configured read-only (e.g. Active Directory or other corporate LDAP), then users are created by the IT department. They would use an LDIF file to load user accounts.  They will be visible to Windchill once the accounts exist in LDAP and are visible to Windchill (i.e. under the search base and member of the LDAP "filter" group,

If your LDAP JNDI Adapter(s) are configured read/write (e.g. openDJ or other Windchill dedicated LDAP), then you can use loadFromFile to create users.

Using OpenDJ, there are too many users, and creating them one by one is too slow.

From China

Use a load file if your LDAP JNDI Adapter(s) are configured for read-write.

The process will fail if the user account already exists.

 
 
Loader syntax comes from %wt_home%\loadFiles\csvmapfile.txt...
User~create~wt.load.LoadUser.createUser~user~newUser~webServerID~fullName~Last~Locale~Email~Description~Title~Organization~Street1~Street2~City~State~Country~ZipCode~ignore~password~DirectoryService~AllowLdapSync~TelephoneNo~MobileTelephoneNo~FaxNo~UserDomain~CabinetDomain
 
CSV example for loading users (C:\temp\orgUsers.csv)
#User,user,newUser,webServerID,fullName,Locale,Email,Description,Title,Organization,Street1,Street2,City,State,Country,ZipCode,ignore,password
User,,jdoe,jdoe,John Doe,US,jdoe@company.com,Development User Account,,Org1,,,,,,,x,jdoe

 

Convert CSV to XML
windchill wt.load.util.CSV2XML -input orgUsers.csv -root C:\temp\loadFiles

 

Load XML file (Windchill must be running and available)
windchill wt.load.LoadFromFile -d C:\temp\loadFiles\orgUsers.xml -u {site administrator} -p {password} -CONT_PATH "/wt.inf.container.OrgContainer=Org1"
Announcements

Top Tags