How to batch create a large number of users in Windchill

Question

mmeadows-3 · Accepted Answer

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"

mmeadows-3 · Answer

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.

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded