How to Export the Users to Excel sheet from RTC Web

u can use repotools -exportUsers command to export the users in csv format. In addition to the user information, repotools command exports the license and group information of the users.

--- Balaji

Hi All,

Could some one explain how to export the users to excel sheet from RTC web.

Below are the problems which i am facing when i do a manual export. Could anyone suggest me better way or fix the problem which i have in manaul process.

1. Logged in to RTC.
2. Click on User Management.
3. Click on Active Users.
4. Copy All the users in the current screen and paste it in the excel sheet.
5. Go to next page and fallow the step 4.

Problem which i am facing is if i use above steps, When i paste this in the excel archiver icon also gets displayed on top of the user. The only way of deleting is select the user and right click and delet the icon. I am finding hard deleting archiver icon for all users one by one.

Can anyone suggest better option.


Cheers,
Jay.

Did you mean there is in built functionality in RTC for exporting to CSV or do you want me to use tool called repotools.

If you want me to use repotool, i am not interested as it is for a single operation. I would like ot have simple fix.

u can use repotools -exportUsers command to export the users in csv format. In addition to the user information, repotools command exports the license and group information of the users.

--- Balaji

Hi All,

Could some one explain how to export the users to excel sheet from RTC web.

Below are the problems which i am facing when i do a manual export. Could anyone suggest me better way or fix the problem which i have in manaul process.

1. Logged in to RTC.
2. Click on User Management.
3. Click on Active Users.
4. Copy All the users in the current screen and paste it in the excel sheet.
5. Go to next page and fallow the step 4.

Problem which i am facing is if i use above steps, When i paste this in the excel archiver icon also gets displayed on top of the user. The only way of deleting is select the user and right click and delet the icon. I am finding hard deleting archiver icon for all users one by one.

Can anyone suggest better option.


Cheers,
Jay.

Hi,

what is the reason behind trying to export the users?

I tried using FireFox the reason behind what you see (the archive user) is because the browser sees the HTML I guess and therefore will get text behind icons.

With respect to your question I guess what was meant was that for exporting the users the repository tools provided with the server (repotools) provide the capability to export to CSV. This is the simplest way how to export the all the users to a CSV file.

Otherwise it is currently possible to export reports or work item queries to CSV file format. I assume you could create a report that shows the users and use that to export too.

If you feel these solutions are not appropriate for your use, you should consider writing a work item.

Thanks,

Ralph

Did you mean there is in built functionality in RTC for exporting to CSV or do you want me to use tool called repotools.

If you want me to use repotool, i am not interested as it is for a single operation. I would like ot have simple fix.

u can use repotools -exportUsers command to export the users in csv format. In addition to the user information, repotools command exports the license and group information of the users.

--- Balaji

Hi All,

Could some one explain how to export the users to excel sheet from RTC web.

Below are the problems which i am facing when i do a manual export. Could anyone suggest me better way or fix the problem which i have in manaul process.

1. Logged in to RTC.
2. Click on User Management.
3. Click on Active Users.
4. Copy All the users in the current screen and paste it in the excel sheet.
5. Go to next page and fallow the step 4.

Problem which i am facing is if i use above steps, When i paste this in the excel archiver icon also gets displayed on top of the user. The only way of deleting is select the user and right click and delet the icon. I am finding hard deleting archiver icon for all users one by one.

Can anyone suggest better option.


Cheers,
Jay.