Redmine

I'm waiting for it also.It's much easier to make plan in Gantt for me.

We are developing the Microsoft Project file import/export utility as a plug-in for Redmine. We are having some problems with task relations due to validation on model (\app\models\issue_relation.rb):

def before_save
    if TYPE_PRECEDES == relation_type
      self.delay ||= 0
    else
      self.delay = nil
    end
    set_issue_to_dates
  end
  def set_issue_to_dates
    soonest_start = self.successor_soonest_start
    if soonest_start && (!issue_to.start_date || issue_to.start_date < soonest_start)
      issue_to.start_date, issue_to.due_date = successor_soonest_start, successor_soonest_start + issue_to.duration
      issue_to.save
    end
  end
  def successor_soonest_start
    return nil unless (TYPE_PRECEDES == self.relation_type) && (issue_from.start_date || issue_from.due_date)
    (issue_from.due_date || issue_from.start_date) + 1 + delay
  end

We have seen this methods make that TYPE_PRECEDES relations can’t start the same day. This is where we have the trouble.
For example: at the beginning of a project we have some tasks having a duration less than a day so they have the same start date. This code updates our start dates adding a day to theirs start date. For example:

• MS PROJECT
  • Designar Jefe del Proyecto
    • Duration: 1h
    • Begin date: mar 22/04/08
    • End date: mar 22/04/08
  • Crear infraestructura del proyecto
    • Duration: 4h
    • Begin date: mar 22/04/08
    • End date: mar 22/04/08
  • Tomar requisitos iniciales
    • Duration: 1d
    • Begin date: mar 22/04/08
    • End date: mar 23/04/08

• REDMINE
  • Designar Jefe del Proyecto
    • Begin date: 2008-04-22
    • End date: 2008-04-22
  • Crear infraestructura del proyecto
    • Begin date: 2008-04-23
    • End date: 2008-04-23
  • Tomar requisitos iniciales
    • Begin date: 2008-04-23
    • End date: 2008-04-24

Some help on this matter?

Hi,

anyone has done this of importing / integrating GanttProject with redmine ?

regards
shann

+1

+1 !

+1

Has there been any progress on this?

+1

This shall be a priority!!!

+1

+1

Here is a simple project plan loader as a plugin. First time using ruby and first time using git, but its here if you want to try it:

http://github.com/simonstearn/Redmine-Project-Loader/tree/master

Its about 6 months old now. We have been using with version 8.0 of redmine - I havent tried it on any later versions yet. I know I should put some unit tests together for it - but its a long journey to this modern stuff for an old C hacker. The clever stuff is all lifted out of http://pond.org.uk/ruby/trackrecord/ which Andrew Hodgkinson kindly open sourced. The crummy hacking is all mine - sorry Andrew.

Not clever enough to get it to spit out project plans, cope with resource assignments or merge plans to pre-existing issues yet - so this just creates an issue on the default (configured) tracker for each low level task. The rest is left as an exercise for the reader. :-)

Enjoy.

+1

+1

please implement MS Project support!

+1

+1

I found this plugin: http://github.com/suer/redmine_ms_projects .
Has anyone used it?

Just thought about importing my GanttProject plan into Redmine and came across this ticket. Seems like there's no activity?

After unsuccessfully trying to get the plugin recommended by Sanjay to work, I finally decided to roll my own plugin to import GanttProject files.
I'm a bit rusty with my Rails development, as I've been mainly working with Java for a couple of months, but after about two hours work it is now possible to import tasks from a GanttProject file and display the imported task tree.
The next step would be for the user to check this information and maybe select which tasks should not be synchronized into the issue tracker. As I have a lot of things to do, I'm not sure if I can finish it this week, but I guess that I should have a basic version available by Sunday evening.
Comments and participation (especially translations other than english and german) are welcome, of course.
You may find the source at http://github.com/milgner/redmine_ganttproject_sync

I can provide italian translation if it works with MS Project files too.
Is your plugin able to update tasks or does it perform the initial import only?

What about export? It could be really useful if I can plan my project on MS Project, let my users interact with RedMine and periodically download an export for MS Project for review.

BTW, I'm a Java developer too, may be I can help in some way?

Roberto Lo Giacco wrote:

I can provide italian translation if it works with MS Project files too.

I don't want to promise MS Project support yet, as I could only use exported GanttProject files to test it. For any more functionality, I'd have to rely on any sample files you or someone else could provide. Generally speaking, the XML generated by the GanttProject exporter isn't that different from the GanttProject files, so it wouldn't probably be that hard to simply write another import method after the whole infrastructure is working.

Is your plugin able to update tasks or does it perform the initial import only?

Last evening was mostly spent on looking into and extending the built-in issue model of Redmine, where I added a field to each issue to identify the original task id it was imported from. So updating should work, I still hope there won't be too many problems in case the original project file gets re-arranged too much, as I don't know a thing about how GanttProject (or MS Project for that matter) internally manages the task ids.
Also, I'm still thinking about what options for updating/synchronization are required, like if the importer should preserve (or maybe explicitly delete) the comment history on issues and whatever things one might want.

What about export? It could be really useful if I can plan my project on MS Project, let my users interact with RedMine and periodically download an export for MS Project for review.

Yeah, I thought about exporting, too. But import/update is the top priority now, I'll think about exporting when I get there :)

I have updated my project plan importer to work with Redmine 0.9.2. Also this now includes some improvements submitted by Scott (svvitale) - thanks Scott.

Its available for download here: http://github.com/simonstearn/redmine_loader.

Enjoy.

Ok, great to know that there's already a plugin for MS Project out there. I just pushed some minor improvements to GitHub to make selecting the tasks to synchronize more comfortable.
As basic functionality is working now, I'll try to get the redmine templates to display information about nested tasks (parents & childs) as well as predecessors & dependendent tasks as a next step.

Simon Stearn wrote:

I have updated my project plan importer to work with Redmine 0.9.2.

Great work! I don't suppose you have any screenshots showing the results of importing on a reasonable sized project have you? I'm currently evaluating Redmine, but to compete with the paid solutions I'd need to make substantial use of plugins, and so far each I've tried has failed at some point, yours included I'm afraid -- some nil-related error on adding the selected tasks.

Robert - I have just reproduced this. I am away from a decent development environment for the next week or so, but I'll post back here when I have news. Sorry this wasted your time !

Robert - I think this is resolved now. Let me know if you have problems still.

Simon Stearn wrote:

Robert - I think this is resolved now. Let me know if you have problems still.

Simon, thanks for the update. I'm on another project at the moment (testing and fixing a Java project done by a sequence of stagiaires -- what fun!) but I'll try and fit in testing the plugin on the same MS Project XML file today, and let you know the result.

Robert Smith wrote:

I'll try and fit in testing the plugin on the same MS Project XML file today

Alternatively I'll try it straight away, and ignore Java for a while. Environment: latest redmine0.9stable, sqlite3, webrick, virtual pc with 1.5GB. The XML file loaded OK (95 work packages, 7MB of XML) and took 186 seconds. I changed the duplicate task names and I found the duplicate number by each duplicate task very useful.

On the downside, at the next step it complained about names being blank or more than 30 characters. About 80% of the tasks names were over 30 characters, so after repeatedly pruning and coming back to the same screen, I finally tried to add just a few tasks rather than all 95, but it still came back to the whinge screen. At that point I gave up.

1. Is the 30-character limit necessary? I chose the default Feature option, but don't all trackers allow longer names?
2. It would be helpful to mark the fields accused of being empty or over the length limit.
3. I seem to remember that categories were shown in the first import view, but in the whinge view the category menus were empty (i have no categories predefined). Does it add the categories, or only set them if they have been predefined?

Hope the feedback is useful, and no rush on my behalf. For my own needs the other week I wrote a stand-alone Ruby script that did a simple search of the XML files, and then used the RESTful interface to add them as a task hierarchy under the new subtasking mechanism. I chose that approach as it was just for a demo, and at the time I knew Ruby but not Rails.

Hi Simon and all,

For those who have tried this plugin, let me ask a stupid question.

After selecting XML file (from MS Project), I select some tasks, click Import selected tasks and get this error (on top of the screen)

"Unable to import tasks: Validation failed: Submitted date can't be blank, Module can't be blank, Value is invalid, Priority can't be blank"

Please help to tell me what to do to pass. Should I edit XML file to include tracker and priority ?

Thanks in advance.

Seri
PS. I use this version "simonstearn-redmine_loader-0.0.11-0-g666c84d.zip" and redmine 0.9.4

Hi all,

Forget about my previous error message, which includes custom fields. This is the one

"Unable to import tasks: Validation failed: Priority can't be blank".

Should I modify XML file to pass ?

Seri

Hi all!

Thanks, Simon, for your plugin!

But I've got some problem :(
First, It's impossible to configure issue state, when i assign developer during import (we've changed standart state machine and i've got issue in "postponed" state).
Second, Plugin generates illegal link to Issues page for our server after import (it has local address - http:\\server:port\redmine, and plugin generates address http:\\redmine:port\issues instead of http:\\redmine:port\redmine\issues)

Can anybody help with these bug?

Almost forgot to ask... the tasks that already had some % of progress (but not yet 100%) got imported on "feedback" mode, while the uninitiated ones got the project folder as "new"

Is this the expected behaviour? Would it be difficult to customize for 0% as "new", 1..99% as "In progress" and 100% as "Feedback" or even "Closed"? I believe it makes more sense for most users in most situations, but I am not sure how or where to change it.

And what would the "existing categories" be used for? It did not seem to change anything on the end result.

For the one willing to test it too, I am using it (today) under Redmine 1.0.0.devel.3938 (MySQL), non-destructively working together with serveral other plugins in my system.

Fabio Leitao wrote:

Almost forgot to ask... the tasks that already had some % of progress (but not yet 100%) got imported on "feedback" mode, while the uninitiated ones got the project folder as "new"
Is this the expected behaviour? Would it be difficult to customize for 0% as "new", 1..99% as "In progress" and 100% as "Feedback" or even "Closed"? I believe it makes more sense for most users in most situations, but I am not sure how or where to change it.

I am very novice in ruby, but I think it can be done in loader_controller when you are filling the destintation issue. The problem here is that these issue states can be customized. Now, the issue state is not filled when the issue is imported so the issue is imported with default state (NEW).

And what would the "existing categories" be used for? It did not seem to change anything on the end result.

"Existing Categories" is for import the issue assigning directly a category that exists on the current project. If the list is empty is because you have not issue categories in that project.

Xabier Elkano wrote:

Fabio Leitao wrote:

Almost forgot to ask... the tasks that already had some % of progress (but not yet 100%) got imported on "feedback" mode, while the uninitiated ones got the project folder as "new"
Is this the expected behaviour? Would it be difficult to customize for 0% as "new", 1..99% as "In progress" and 100% as "Feedback" or even "Closed"? I believe it makes more sense for most users in most situations, but I am not sure how or where to change it.

I am very novice in ruby, but I think it can be done in loader_controller when you are filling the destintation issue. The problem here is that these issue states can be customized. Now, the issue state is not filled when the issue is imported so the issue is imported with default state (NEW).

I am still a ruby newbie, but I'm looking forward for the chalenge, I'll try to understand it better, make my changes and experiment for a while... I hope I can figure out where to adjust this behaviour, and post here any discoveries.

And what would the "existing categories" be used for? It did not seem to change anything on the end result.

"Existing Categories" is for import the issue assigning directly a category that exists on the current project. If the list is empty is because you have not issue categories in that project.

Oh, I do have a project (in my production system) with categories... I'll eventually try that as well.

And it won't run with Redmine 1.0.0.devel.3940 - beware of upgrades - I had to roll back.

Fabio,

I've been seeing your patch and is a nice feature, but on my installation, at the moment, I only have three states to simplify the operation (Open, solved and closed), sure on the near future the list grows up, but for now I can only apply part of your patch ("d" case), thanks!

Those were based on the current default status available in a fresh redmine instalation, and if you have customized the names of the issue status in your instalation (I believe you know what you have been doing then) your choice of no longer makes sense with my choices, it is a simple "find-the-correct-status-number-reading-from-your-log-file" and "set-the-supposed-new-value-in-the-correct-position-of-the-code" task now.

The states ids can be found doing a select in "issue_statuses" table.

When I learn, I'll try to post a rewrite of the plugin configuration page that might ask for the "required default state" according to what the user might like to use when importing, based on the interpretation of the status_id from his/her particular system... but then again, I have no idea where to look for it... :D

maybe on this page? http://www.redmine.org/wiki/redmine/Plugin_Tutorial

Hello,

I'm a newbie and I'm not sure if my question is on the right place, but has anyone thought about the mpx-format of MS Project? Is there already a plug-in for import/export?

Daniel Rudolf wrote:

Hello,

I'm a newbie and I'm not sure if my question is on the right place, but has anyone thought about the mpx-format of MS Project? Is there already a plug-in for import/export?

this project does Microsoft Project (MPX) <-> Redmine sync.

oops. forgot to add the link: http://code.google.com/p/redmine-connect/

Alexey Yurganov: That link is not working any more. I get a "Forbidden" message.

I renamed the project and moved it to a new domain: http://www.taskadapter.com
the application is not free anymore, but you can download a trial version from there.

Alexey Skor wrote:

I renamed the project and moved it to a new domain: http://www.taskadapter.com
the application is not free anymore, but you can download a trial version from there.

good software, but it costs too much

Roman aka iTUX wrote:

Alexey Skor wrote:

I renamed the project and moved it to a new domain: http://www.taskadapter.com
the application is not free anymore, but you can download a trial version from there.

good software, but it costs too much

Thanks for trying it. The price includes support for 1 year. Some of the users request additional features and bugfixes,
and this is also included in the price. For example, a version planned for February will include a command-line 2-way sync, which can be run automatically (say, as a cron job).
The price must cover the cost development, testing, documenting, support, plus keeping up-to-date with rapidly evolving Redmine REST API. So the price has to be adequate to ensure the level of quality users expect of commercial software.
Anyway, please contact me (http://www.taskadapter.com/Contact) to discuss your situation

I've installed the loader of Simon on my System. (Downloaded from https://github.com/simonstearn/redmine_loader).

Sometimes i get the error 'Unable to import tasks: translation missing: de, activerecord, errors, messages, record_invalid'. The error only appears when i try to import a whole project at once. When i add the tasks block-wise by 10, the tasks are imported correctly.

Can you help me finding out what's going wrong?

Andreas Schrottenbaum wrote:

I've installed the loader of Simon on my System. (Downloaded from https://github.com/simonstearn/redmine_loader).

Sometimes i get the error 'Unable to import tasks: translation missing: de, activerecord, errors, messages, record_invalid'. The error only appears when i try to import a whole project at once. When i add the tasks block-wise by 10, the tasks are imported correctly.

Can you help me finding out what's going wrong?

I need a plugin to import from a MS Project (XML format) to Redmine.
In order to this, as Andreas, I've installed the loader of Simon too and the same error appears.

I tried to load only 10 task but the error always stop the import (even if the tasks are deleted directly from the XML file)

Can anybody help?! THANKS

I tried to install too the plugin in the next link: http://github.com/simonstearn/redmine_loader
...but I can't restart the Redmine service (as I read It seems to be caused by .yml file)

Fortunately I could solve de problem changing the languaje of the user to English.
Aparently if the user who is going to realise the import from a xml file hasn't the English lengauaje set the plugin doesn't work correctly (because a particularity of Ruby in a puntual function which work with BD object's)

So if somebody has the same error message as me try changing the User Language to English first.

Thx!

Fabián Varietti wrote:

I need a plugin to import from a MS Project (XML format) to Redmine.
In order to this, as Andreas, I've installed the loader of Simon too and the same error appears.
I tried to load only 10 task but the error always stop the import (even if the tasks are deleted directly from the XML file)
Can anybody help?! THANKS

Task Adapter does exactly this: export data from MSP to Redmine (and vice-versa): http://taskadapter.com

Hello,

I am new to redmine and wanted to use this plugin to import an MS Project XML File. I tried to import an XML file from MS Project. the analysis went thro fine, but i have over 200+ tasks and the "Tracker" field is empty. so when i try to import it i get this error message

Unable to import tasks: Validation failed: Tracker can't be blank, Tracker is not included in the list

How do i add "Tracker" field in my MPP project in MS Project? OR should i change the XML file? if so how?

any help in this would be highly appreciated

Hello, i'm trying to use this plugin but i get this message> UNABLE TO IMPORT TASKS:translation missing:es, activerecord, errors, messages, record_invalid.
i'm ussing redmine 1.2.1, rake 0.8.7, rails 2.3.11, i18n 0.4.2 and rack 1.1.1
if someone can help please?

Mobi Develoepr wrote:

How do i add "Tracker" field in my MPP project in MS Project? OR should i change the XML file? if so how?

any help in this would be highly appreciated

Have you configured the tracker in the plugin settings?

Ivana Larramendia wrote:

Hello, i'm trying to use this plugin but i get this message> UNABLE TO IMPORT TASKS:translation missing:es, activerecord, errors, messages, record_invalid.
i'm ussing redmine 1.2.1, rake 0.8.7, rails 2.3.11, i18n 0.4.2 and rack 1.1.1
if someone can help please?

Are you using this http://www.redmine.org/attachments/4296/redmine_importer.tar.gz ??

Ivana Larramendia wrote:

yes, i'm using the same one, i add the lines es: and en: in the top of the en.yml and es.yml but still doesn't work.
this is the screenshot i get wen i try to import selection.

Can you attach the xml test file you are trying to import?

i'm using the one is here. Una_tarea.xml.. that one i'm trying to use and i get that message.

Ivana Larramendia wrote:

i'm using the one is here. Una_tarea.xml.. that one i'm trying to use and i get that message.

Have you correctly configured the tracker name in the plugin settings?

no, i didn't configure anything about that. i just add those lines i told you before, where do i do that?

you have to configure it first in Settings->Plugins and change the tracker name to an existing one.

i leave it default .. now i tried changing it to another name existing and still get the same error message.

did you modify sth in vendor/redmine_loader/config ? 'cuz the error i'm having is for translation..

Ivana Larramendia wrote:

did you modify sth in vendor/redmine_loader/config ? 'cuz the error i'm having is for translation..

No