Harvest Plugin

Added by Jim Mulholland about 8 years ago

I created a plugin to integrate Harvest time entry data into Redmine.

GitHub: http://github.com/mully/redmine_harvest
Blog post / screen cast: http://squeejee.com/blog/apps/2009/11/18/integrate-harvest-time-into-redmine/

In short, the plugin allows you to pull in time entry data from Harvest, tie the entries to individual Redmine tickets, and general time reporting.

I was originally going to extend the existing TimeEntry model to take advantage of all the existing reports, but later decided I would play it safe and created a new HarvestTime model and HarvestReport view and controller. The Harvest reports page and time aggregation on the Issue detail page works exactly the same, though.

Feedback from our clients has been very positive so far which is definitely a good thing!

Replies (7)

RE: Harvest Plugin - Added by Robert Heath almost 8 years ago

Tried installing the plugin but get the following error:

no such file to load -- harvestr

I assume the plugin needs harvestr (http://github.com/squeejee/harvestr) but I'm not sure how to install that so that Redmine sees it. Any help you could provide would be appreciated.

RE: Harvest Plugin - Added by Edward Stone almost 8 years ago

I followed these steps to get remine_harvest working with my redmine installation:

1. cloned redmine_harvest into vendor/plugins directory using

git clone git://github.com/mully/redmine_harvest.git

2. installed the harvestr gem with

sudo gem install harvestr

3. created a harvest.yaml file in the redmine config folder, with this in:

domain: [your harvest domain]
email: [a valid harvest email]
password: [password for that user]

4. did the plugin database migration (yes I know it says not to on the github page for redmine_harvest, but I think you do need it...)

rake db:migrate_plugins RAILS_ENV=production

5. follow the steps for the redmine admin settings that are in the redmine_harvest readme: http://github.com/mully/redmine_harvest/blob/master/README.rdoc

That was it! Plugin looks great so far - hope that helps someone get it installed.

cheers

Ed

RE: Harvest Plugin - Added by Jim Mulholland almost 8 years ago

Hi Ed! Thanks for the detailed how-to.

I'm glad the plugin is working for you!

RE: Harvest Plugin - Added by Edward Stone almost 8 years ago

No worries :) Thanks for making the plugin!

RE: Harvest Plugin - Added by Dave Roberts about 7 years ago

I love the idea of this addon and followed the instructions carefully. It seems to have installed correctly. Everything seems fine. When I click the Harvest Tab in Projects the server throws a 500 error. The logs indicate:

ActiveRecord::StatementInvalid (PGError: ERROR: operator does not exist: text = integer
LINE 1: ...OM "custom_values" WHERE ("custom_values"."value" = 77658 AN...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
: SELECT * FROM "custom_values" WHERE ("custom_values"."value" = 77658 AND "custom_values"."custom_field_id" = E'7') LIMIT 1):

As the error shows, when I run this query against the database converting the ID to a string it works. Is there any advice you can offer as to what I may be doing wrong?

Thanks in advance!

RE: Harvest Plugin - Added by Arnis Juraga almost 5 years ago

Plugin is outdated :(

It seems - no support for Redmine 2.1

May be someone is developing plugin or using it for latest Redmine adn Harvest?
Would be very great!

RE: Harvest Plugin - Added by A H almost 5 years ago

After trying to install in Redmine 2.1 I simply get an Application Error with Redmine...

Would LOVE if this plugin could be updated to work!

(1-7/7)