Skip to content

A Simple Reporting Tool For GlobalSight

Reporting is good. And it is much better when the UI is just simple. Based on this, we wrote a small reporting UI for GlobalSight. Nothing fancy here, plain simple data. You can get a word count report based on job or the user for a given period. The output can be filtered on user, project, activity, localization profile and project manager.

Trying to find out how many words linguist xxxx translated last month? What about the ones she reviewed? And which client was that?

If this sounds familiar, this report may help.

Warning – As mentioned before, this report is simple. Too simple that it should be used with caution. I just wanted to share it in case anyone has the need for such a report. It should not be used on a production server as it has no authentication mechanism.

How does the reporting module look?

Like this:

What do I need in order to use the reporting tool?

Installation requires good level of technical knowledge. It will require a computer where you can run a Ruby on Rails application (does not have to be a server and SHOULD NOT be a production server). This post does not cover preparing a machine for Ruby on Rails.

How do I install it?

  • Download GlobalSight reporting UI
  • Unpack the folder under your Rails application root
  • Create a MySQL user on the GlobalSight database (all we need is Select permission)
  • Using the Create_View.sql script found in the package, create the view in your GlobalSight database. Reporting tool uses this view
  • Edit config/database.yml and insert the host where the GlobalSight database runs and user/password information for the user you created earlier

That’s it. Start the Rails server (Mongrel, Passenger etc.), browse to http://railsserver/report and you should have your data!

Questions, comments, feedback welcome!

You may also be interested in GlobalSight customization

Categories: Localization Tools.

Comment Feed

No Responses (yet)

Some HTML is OK

or, reply to this post via trackback.