It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,788

question asked: May 24 '10, 6:02 a.m.
question was seen: 13,638 times
last updated: May 24 '10, 6:02 a.m.

Related questions

FAQ - How this Forum works

Export RTC users into excel

0
Kaushambi Singh (371●3●103●79) | asked May 24 '10, 6:02 a.m.
Is there any way to export 'RTC users' into Excel sheet? After logging into RTC Web UI->Active users, We have list of RTC LDAP users displayed. Is there any way to export all the users into excel sheet?

9 answers

Most liked answers ↑|Newest answers|Oldest answers

1
permanent link
Ralph Schoon (63.1k●3●36●46) | answered May 25 '10, 8:37 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
You can either use the repotools. Run it from a commandline in the server directory e.g. JazzTeamServer/server

If you start it without parameters it will show the help.
There is a parameter to export the users.

repotools -exportUsers tofile=users.csv repositoryURL=https://rtc.example.com:19443/jazz/

Will generate a CSV file which you could open with Excel.
0
permanent link
Kaushambi Singh (371●3●103●79) | answered May 25 '10, 5:15 a.m.
Any answers on this?
0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered May 25 '10, 6:47 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

please seehttp://jazz.net/forums/viewtopic.php?t=10744&highlight=export
Any answers on this?
0
permanent link
Kaushambi Singh (371●3●103●79) | answered May 25 '10, 8:26 a.m.
Well,thanks for the reply but this is not exactly I am looking for.My question is not related to any Project or team Area. If you login as admin into the RTC Web UI,go to User Management. We will have list of users displayed. I was looking for some way where we can export these users in to Excel.
0
permanent link
Kaushambi Singh (371●3●103●79) | answered May 25 '10, 8:49 a.m.
Thank yo uso much.I'll try this out and let you know the reply.
0
permanent link
Kaushambi Singh (371●3●103●79) | answered May 26 '10, 5:40 a.m.
I tried the command with our repository connection. It displays that you are not logged in as ADMIN. Our repository is LDAP authenticated and we have disabled ADMIN.I have the admin rights.Do we have some syntax to pass on the User name and password also so that connection to repository can be done? We are using Linux server, just wanted to confirm if the command you sent is common for both LINUX and Windows.
0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered May 26 '10, 5:53 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

as far as I know repotools come with all supported operating systems.

I'd suggest to look the syntax up in the help http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp.

In addition if you run repotools -help it comes up with all parameters. You can pipe it in a text file. Then you get this: 




   -exportUsers --Export the user information.      

         [toFile=users.csv] --Path to the users comma delimited file.

         [overwrite=<yes>] --Whether to overwrite an existing CSV file.

         [repositoryURL=https://localhost:9443/jazz] --The connection URL for the server.

         [adminUserId=ADMIN] --Admin user id to login to the Jazz repository.

         [adminPassword=ADMIN] --Admin password to login to the Jazz repository. 

         [credentialsFile=credentials.properties] --The file containing the admin user's login credentials.

         [logFile=repotools_exportUsers.log] --Path to the log file.




I tried the command with our repository connection. It displays that you are not logged in as ADMIN. Our repository is LDAP authenticated and we have disabled ADMIN.I have the admin rights.Do we have some syntax to pass on the User name and password also so that connection to repository can be done? We are using Linux server, just wanted to confirm if the command you sent is common for both LINUX and Windows.
0
permanent link
Kevin Ramer (4.5k●8●183●200) | answered Jun 25 '10, 5:09 p.m.
Anyone out there know what is in the credentials file ? I haven't stumbled upon it described anywhere yet.



Hi,

as far as I know repotools come with all supported operating systems.

I'd suggest to look the syntax up in the help http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp.

In addition if you run repotools -help it comes up with all parameters. You can pipe it in a text file. Then you get this: 




   -exportUsers --Export the user information.      

         [toFile=users.csv] --Path to the users comma delimited file.

         [overwrite=<yes>] --Whether to overwrite an existing CSV file.

         [repositoryURL=https://localhost:9443/jazz] --The connection URL for the server.

         [adminUserId=ADMIN] --Admin user id to login to the Jazz repository.

         [adminPassword=ADMIN] --Admin password to login to the Jazz repository. 

         [credentialsFile=credentials.properties] --The file containing the admin user's login credentials.

         [logFile=repotools_exportUsers.log] --Path to the log file.




I tried the command with our repository connection. It displays that you are not logged in as ADMIN. Our repository is LDAP authenticated and we have disabled ADMIN.I have the admin rights.Do we have some syntax to pass on the User name and password also so that connection to repository can be done? We are using Linux server, just wanted to confirm if the command you sent is common for both LINUX and Windows.
0
permanent link
Ralph Schoon (63.1k●3●36●46) | answered Jul 12 '10, 8:42 a.m.
FORUM ADMINISTRATOR / FORUM MODERATOR / JAZZ DEVELOPER
Hi,

I was curious and tried it out.

Create a file e.g. credentials.txt with content 

adminUserId=your_userid

adminPassword=your_password


then you can use it with repotools. The password is not enchrypted.

Ralph


Anyone out there know what is in the credentials file ? I haven't stumbled upon it described anywhere yet.



Hi,

as far as I know repotools come with all supported operating systems.

I'd suggest to look the syntax up in the help http://publib.boulder.ibm.com/infocenter/rtc/v2r0m0/index.jsp.

In addition if you run repotools -help it comes up with all parameters. You can pipe it in a text file. Then you get this: 




   -exportUsers --Export the user information.      

         [toFile=users.csv] --Path to the users comma delimited file.

         [overwrite=<yes>] --Whether to overwrite an existing CSV file.

         [repositoryURL=https://localhost:9443/jazz] --The connection URL for the server.

         [adminUserId=ADMIN] --Admin user id to login to the Jazz repository.

         [adminPassword=ADMIN] --Admin password to login to the Jazz repository. 

         [credentialsFile=credentials.properties] --The file containing the admin user's login credentials.

         [logFile=repotools_exportUsers.log] --Path to the log file.




I tried the command with our repository connection. It displays that you are not logged in as ADMIN. Our repository is LDAP authenticated and we have disabled ADMIN.I have the admin rights.Do we have some syntax to pass on the User name and password also so that connection to repository can be done? We are using Linux server, just wanted to confirm if the command you sent is common for both LINUX and Windows.

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.