MPXJ

This gem allows a Ruby developer to work with a read-only view of project plans saved by a number of popular project planning applications. The work required to read data from these files is actually carried out by a Java library, hence you will need Java installed and available on your path in order to work with this gem. Once the project data has been read from a file, a set of Ruby objects provides access to the structure of the project plan and its attributes.

This gem only came about through the interest and support of Procore, who would love to hear from you if you're excited about working with Ruby and Rails.

Installation

Add this line to your application's Gemfile:

gem 'mpxj'

And then execute:

$ bundle

Or install it yourself as:

$ gem install mpxj

Changelog

You'll find details of what has changed in this version here.

Supported File Types

This gem uses the file name extension to determine what kind of project data it is reading. The list below shows the supported file extensions:

  • MPP - Microsoft Project MPP file
  • MPT - Microsoft Project template file
  • MPX - Microsoft Project MPX file
  • XML - Microsoft Project MSPDI (XML) file
  • MPD - Microsoft Project database (only when the gem is used on Microsoft Windows)
  • PLANNER - Gnome Planner
  • XER - Primavera XER file
  • PMXML - Primavera PMXML file
  • PP - Asta Powerproject file

Example Code

The following is a trivial example showing some basic task and resource details being queried from a project:

project = MPXJ::Reader.read("project1.mpp")

puts "There are #{project.all_tasks.size} tasks in this project"
puts "There are #{project.all_resources.size} resources in this project"

puts "The resources are:"
project.all_resources.each do |resource|
  puts resource.name
end

puts "The tasks are:"
project.all_tasks.each do |task|
  puts "#{task.name}: starts on #{task.start}, finishes on #{task.finish}, it's duration is #{task.duration}"
end

Entities

The gem represents the project plan using the following classes, all of which reside in the MPXJ module.

  • Project
  • Resource
  • Task
  • Assignment
  • Relation

A Project contains Resources and Tasks. Each Resource can be Assigned to one or more Tasks. Tasks can have dependencies between them which are represented as Relations.

Acknowledgements

This gem includes functionality provided by POI http://poi.apache.org

This gem includes functionality provided by RTF Parser Kit https://github.com/joniles/rtfparserkit