Trados Studio
Trados Enterprise
Trados Team
Trados GroupShare
Trados Business Manager
Passolo
MultiTerm
RWS AppStore
Connectors
Beta Groups
Managed Translation
MultiTrans
TMS
WorldServer
Language Weaver
Language Weaver Connectors
Language Weaver Edge
Tridion Docs
Tridion Sites
LiveContent S1000D
XPP
Language Developers
Tridion Docs Developers
Community Help
RWS User Experience
Internal Trados Ideas Community
Mercury
RWS Community Internal Group
RWS Professional Services
RWS Training & Certification
Style Guides
RWS Campus
RWS Enterprise Technology Partners
Trados Approved Trainers
XyUser Group
ETUG (European Trados User Group) Public Information
Nordic Tridion Docs User Group
Tridion UK Meetup
Tridion West Coast User Group
Trados Studio Ideas
Trados GroupShare Ideas
Trados Live Team Ideas
Trados Live Terminology Ideas
Trados Enterprise Ideas
Trados Business Manager Ideas
MultiTerm Ideas
Passolo Ideas
RWS Appstore Ideas
Tridion Docs Ideas
Tridion Sites Ideas
Language Weaver Ideas
Language Weaver Edge Ideas
Managed Translation - Enterprise Ideas
TMS Ideas
WorldServer Ideas
LiveContent S1000D Ideas
Contenta S1000D
XPP Ideas
Events & Webinars
To RWS Support
Detecting language please wait for.......
The Excel for GroupShare application is a small plugin for Microsoft Excel that supports the ability to connect to a GroupShare instance and download raw data that can be used to create your own reports. The data is downloaded in a very raw form to try and ensure that you can maximise the range of reports it's possible to create. You are only limited by your imagination and your ability to work with Excel. A couple of important notes on this:
When you visit the SDL AppStore to download the application it will be downloaded as a zip file. You should unzip the file to somewhere on your computer before running the installer as running it within the zip can cause problems for some users.
NOTE: If you have a previous version of the application installed you should uninstall it through Add/Remove Programs in Windows before attempting to install a new version.
Once you have unzipped the file you will find a folder with three entries:
To install you simply run the "setup.exe" file which will deliver a dialogue like this:
Click on Install and the application installation process will be completed in a few seconds:
Click on close and now you should be able to find the GroupShare toolbar in Excel like this:
The first thing to do is click on Login so you have access to your GroupShare instance:
Once you are successfully logged in you'll have access to the other menu items. If you click on the other items before logging in you'll simply be taken to the same login screen first.
Once you're logged in you have three options in the Excel ribbon:
This feature will pull data held on your GroupShare projects and offers similar filtering to that available in GroupShare to narrow down the data being pulled. This is important because the volume of data available is significantly higher than that available through the conventional reporting in GroupShare itself and te more you attempt to download the longer it will take. So the more options you select, the more data you will get, the more cups of coffee you're going to need!
However, once you do have the data downloaded you'll see the amount of data available to you is significant. To initiate the download select your options and click on Get Data. You'l see something like this:
You can cancel the download at any time and the operation will stop, leaving you with only the data that was downloaded by the time you clicked cancel. With all the options checked you can expect to see data in columns relating to the following:
This option offers various types of resource related data:
This download will provide the following columns of data:
Custom Fields
This option will pull user data from the server:
Data retrieval box is a little different:
Once downloaded you will have access to the following columns of data: