Top Menu

Jump to content
Home
    • Projects
    • Work packages
    • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Professional support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?
      Create a new account

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
  • Roadmap
  • Work packages
  • Calendars
  • Team planners
  • Boards
  • Forums
  • Wiki
    • Table of contents
      • Expanded. Click to collapseCollapsed. Click to showDeveloper
        • Hierarchy leafAccessibility Checklist
        • Hierarchy leafCode Review Guidelines
        • Expanded. Click to collapseCollapsed. Click to showContribution
          • Hierarchy leafGit Workflow
          • Hierarchy leafTranslations
        • Expanded. Click to collapseCollapsed. Click to showDeveloping Plugins
          • Hierarchy leafDeveloping an OmniAuth Authentication Plugin
        • Hierarchy leafRelease Process
        • Hierarchy leafReport a bug
        • Hierarchy leafSecurity
        • Hierarchy leafSetting up an OpenLDAP server for testing
        • Hierarchy leafTheme Features
      • Hierarchy leafDownload
      • Expanded. Click to collapseCollapsed. Click to showFeature tour
        • Hierarchy leafRelease Notes OpenProject 30
        • Expanded. Click to collapseCollapsed. Click to showRelease Notes OpenProject 30 - Overview
          • Hierarchy leafGlossary
          • Hierarchy leafRelease Notes - Accessibility
          • Hierarchy leafRelease Notes - Accessibility changes
          • Hierarchy leafRelease Notes - Add work package queries as menu items to sidebar
          • Hierarchy leafRelease Notes - Copy projects based on Templates
          • Hierarchy leafRelease Notes - Design changes
          • Hierarchy leafRelease Notes - Fixed Bugs
          • Hierarchy leafRelease Notes - Keyboard Shortcuts
          • Hierarchy leafRelease Notes - Project settings
          • Hierarchy leafRelease Notes - Ruby&Rails Update
          • Hierarchy leafRelease Notes - Security
          • Hierarchy leafRelease Notes - Timelines
          • Hierarchy leafRelease Notes - Work packages
      • Hierarchy leafHowto create animated gifs
      • Hierarchy leafMigration Squashing
      • Hierarchy leafMod security
      • Hierarchy leafNew work package page
      • Hierarchy leafOP3 to OP4 Debian upgrade
      • Hierarchy leafOP4 Ubuntu1404 Stable with MySQL in production
      • Hierarchy leafOpenProject 40 Development Setup
      • Expanded. Click to collapseCollapsed. Click to showOpenProject Foundation
        • Hierarchy leafBoards
        • Hierarchy leafMembers
        • Hierarchy leafOPF-Meetings
        • Hierarchy leafStatutes
      • Expanded. Click to collapseCollapsed. Click to showRelease Notes
        • Hierarchy leafOpenProject released on Bitnami
      • Expanded. Click to collapseCollapsed. Click to showRelease Notes OpenProject 40 - Overview
        • Hierarchy leafRelease Notes OpenProject 40 - Accessibility improvements
        • Hierarchy leafRelease Notes OpenProject 40 - Column header functions in work package table
        • Hierarchy leafRelease Notes OpenProject 40 - Improved Design
        • Hierarchy leafRelease Notes OpenProject 40 - Integrated query title on work package page
        • Hierarchy leafRelease Notes OpenProject 40 - Integrated toolbar on work package page
        • Hierarchy leafRelease Notes OpenProject 40 - OmniAuth integration for OpenProject
        • Hierarchy leafRelease Notes OpenProject 40 - Work package details pane
      • Expanded. Click to collapseCollapsed. Click to showSecurity and privacy
        • Hierarchy leafFAQ
      • Expanded. Click to collapseCollapsed. Click to showSupport
        • Expanded. Click to collapseCollapsed. Click to showDownload and Installation
          • Hierarchy leafInstallation MacOS
          • Expanded. Click to collapseCollapsed. Click to showInstallation OpenProject 3 0
            • Hierarchy leafDebian Stable with MySQL in production
            • Hierarchy leafInstallation Ubuntu
            • Hierarchy leafInstallation Windows
            • Hierarchy leafInstallation on Centos 65 x64 with Apache and PostgreSQL 93
          • Expanded. Click to collapseCollapsed. Click to showInstallation OpenProject 40
            • Hierarchy leafOP4 Debian Stable with MySQL in production
          • Expanded. Click to collapseCollapsed. Click to showMigration paths
            • Hierarchy leafFrom Chilliproject to OpenProject
            • Hierarchy leafMigration 15 to 30
            • Hierarchy leafMigration 24 to 30
            • Hierarchy leafMigration Redmine 2x › OpenProject 30
            • Hierarchy leafOpenProject 3 Migration
          • Hierarchy leafOpenProject 40
        • Expanded. Click to collapseCollapsed. Click to showNews
          • Hierarchy leafNew OpenProject Translations Plugin
          • Hierarchy leafNew Plugin on OpenProjectorg Local Avatars
          • Hierarchy leafNew design for OpenProject
          • Hierarchy leafNews Accessibility workshop for OpenProject
          • Hierarchy leafNews Glossary for OpenProject
          • Hierarchy leafNews Heartbleed fixed
          • Hierarchy leafNews Icon Fonts
          • Hierarchy leafNews OpenProject 30 Release
          • Hierarchy leafNews Release GitHub Integration Plugin
          • Hierarchy leafNews Success Story Deutsche Telekom
          • Hierarchy leafNews Timelines
          • Hierarchy leafOpenProject 3013 released
          • Hierarchy leafOpenProject 3017 released
          • Hierarchy leafOpenProject 40 released
          • Hierarchy leafOpenProject 40 will be coming soon
          • Hierarchy leafOpenProject 405 released
          • Hierarchy leafOpenProject and pkgrio
          • Hierarchy leafOpenProject news moved to a new blog
          • Hierarchy leafOpenProjectBitnami
          • Hierarchy leafPackager version with plugins released ("Community edition")
          • Hierarchy leafRegistration OpenProject-Foundation
          • Hierarchy leafRelease OpenProject AuthPlugins
          • Hierarchy leafUpdates on OpenProject
          • Hierarchy leafWe need your feedback for the the new fullscreen view for work packages
        • Hierarchy leafOpenProject Plug-Ins
      • Hierarchy leafWiki
You are here:
  • Forums
  • General discussion

Content

[Solved] MSProject Synchronisation

Added by M. Drobisch about 9 years ago

Hello Dear Openproject Team,
in your Feature Tour you mentioned the posibility to synchronize the timelines and working-packages with MSProject. Is the Feature still planned or maybe allready useable?
Thank you,

With best regards

M. Drobisch


Replies (28)

RE: MSProject Synchronisation - Added by Niels Lindenthal about 9 years ago

Hi M.,

Yes, we already use it here internally. The development is sponsored by members of the OPF. I guess it is in a beta phase. So I heard it does not support the sync of custom fields yet. However if you are interested you can take part in a betatest?

Regards
Niels

RE: MSProject Synchronisation - Added by M. Drobisch about 9 years ago

Hello Niels,
we are a small Meassurement-Equipment-Team in Dresden, Germany and we are looking to change from Chiliproject to Openproject, only waiting for the first stable 3.0 to move.
If we could contribute by beta-testing, we would enjoy doing it. What we have to do, to take part in the beta test, especially for the MSProject feature?

Best Regards
Marcus

RE: MSProject Synchronisation - Added by Niels Lindenthal about 9 years ago

Hi Marcus,

It is a prerequisite that you migrate to OpenProject 3.0 first. Even though it is still not tagged as “stable” you can already use it (openproject.org is already running OpenProject 3.0). We will then create a subproject for this betatest where we provide the download for the MSI.

Regards
Niels

RE: MSProject Synchronisation - Added by M. Drobisch about 9 years ago

Thank you very much.
I will notify you, after we succesfully moved to chiliproject 3.0.

Regards
Marcus

RE: MSProject Synchronisation - Added by Lesley Campbell about 9 years ago

I have a sandbox here on Open Project.org and was hoping to test the MS Project sync. I can’t find anywhere that explains what to do or how to use it.

RE: MSProject Synchronisation - Added by Timothy Overly almost 9 years ago

Yes, I would need this feature to be able to use OpenProject. Is there any documentation on the feature?

RE: MSProject Synchronisation - Added by Paul Onwude over 8 years ago

Hi,

Hiw can i get the plugin to sync with ms project??

Regards Paul

RE: MSProject Synchronisation - Added by Eugene Tan over 8 years ago

Hi

I’ve been trialing the use of openproject in my organisation and have had request to be able to print the timeline somehow (currently can only screenshot the timeline).

So i’m interested in synchronising with ms project to be able to achieve this.

eugene

RE: MSProject Synchronisation - Added by Andre Schoonbee over 8 years ago

Is this plugin already available and if so how will I be able to get it?

RE: MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Hello,

Excellent project, by far the best I’ve tried so far.

Anyone got a hand on the ms project sync plugin?

Is scheduling of tasks be available in 4.0? It seems not. For me it’s the only missing important feature.

Thanks

RE: MSProject Synchronisation - Added by Robin Wagner over 8 years ago

Hello everyone,

due to the many requests for the MS project AddIn we included the current version of the installer in the public TaskConnector project.
You can download either a 32 bit or 64 bit version.

Best,
Robin

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Great! Many thanks.

I can now continue my evaluation

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Hello,

I just tried it, and it does not install with ms project 2013 :(

I you want me to do some tests, please let me know!

Thanks

RE: [Solved] MSProject Synchronisation - Added by Robin Wagner over 8 years ago

Hello Ben,

unfortunately only MS Project 2010 (with Windows 7 or newer) is supported at the moment.
There is no installer for Project 2013 yet - and there is no exact date yet when this will change.
(But once it is available, it will be included for download.)

If you want to use the Project AddIn you currently have to rely on Project 2010, I’m afraid.

Best,
Robin

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

I’m out of luck :(

Any way i can help you on this addin?

RE: [Solved] MSProject Synchronisation - Added by Niels Lindenthal over 8 years ago

Hi Guys,

we discussed this today. We will very likely prioritize the support of MS Project 2013. So I guess October/November is realistic.

Regards
Niels

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Hello,

I have a good news for you : The connector works fine with project 2013 (after forcing the installation, I just have a popup saying this plugin is not support by project 2013, but when I clic ok on the popup, everything works fine!)

I continue to test it and I will let you know.

By the way : how is the link between resources in MS project and users in open project done?
What will happen if the user does not exist in openproject but specified in ms project?

Thanks

RE: [Solved] MSProject Synchronisation - Added by Jan Sandbrink over 8 years ago

Hi,

currently there is no link at all between Resources and OpenProject.
We are only synchronizing a subset of the properties of a Task / Work Package.

RE: [Solved] MSProject Synchronisation - Added by Deleted user over 8 years ago

Hi,

this time I have good news for you: We are planning on supporting Project 2013 by the end of this Sprint (24.10.).

Did you find any issues while testing your setup with Project 2013?

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Hi,

This is good news.

Only issues I’ve faced are in the other thread (about sync date)
Other points are missing features (assignee, duration) ;), but I’ve “workarounded” this using some VBA scripts

I will be glad to test the new version as soon as you release it

RE: [Solved] MSProject Synchronisation - Added by Alexander Bach over 8 years ago

Hello there,

Just wanted to quickly announce that the promised new Project AddIn version is now available.

Feel free to send any feedback to taskconnector[at]finn.de. Most importantly you should now be able to install the AddIn for Project 2013 and 2010 both with the same installer.

Have a nice weekend!
Alex

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

Hello,

I finally had time to test the new task connector.
Unfortunately, I have bad news.

Installation went fine, I subscribed the new tasks, and then a “New Tasks” appears (instead of the real task name), with no synchronization information.
When I tried to synchronize, it is complaining about missing unsubscribed tasks…

Do you know what is happening?

Thanks

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben over 8 years ago

After some tests, it seems not to be a regression.

Creating a sub-task in openproject cannot be imported in ms project!
I’ve removed the parent in openproject, and the task was subscribed properly.

Hope this will help

RE: [Solved] MSProject Synchronisation - Added by Alexander Bach over 8 years ago

Hey,

I tried to reproduce your problem on my machine, but couldn’t do so. Could you please provide something like step-by-step instructions to reproduce your problem?

Here is what I tried:

  • Subscribing to a Child workpackage with a parent in the same project.
  • Trying to subscribe to a child workpackage with a parent in a different project. In this case only the child will be displayed in project.
  • Subscribing to a regular workpackage and then making it a child via OpenProject, after that sync MS project
  • Trying to only subscribe to a child workpackage. The Add-In doesn’t let me do that.

Please note that the Add-In should at least warn you when you are trying to subscribe only to a child workpackage. You should then have the choice to either subscribe to the parent as well, or to none of the two.

Regards,
Alex

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben about 8 years ago

Hello,

It is not always.
Today I reproduced this bug with an already existing task.

I was editing my ms project, moved one task (drag/drop) from task1 to another task2. (I did many editing of other tasks, but this particular task was only moved (amongs other tasks))

I tried then to synchronize, and it complained that some task was not subscribed.
Surprised, I checked the Subsribe menu and I found one task not synchronized, the one I’ve moved.
I tried to subscribe again, and it removed the already present task in ms project and tried to add a empty task instead at some random location.

The only solution I’ve found was to go to open project, edit the task, remove the parent, and subscribe again. This had the effect to delete the ms project task and added a new one at the bottom of ms project…

I don’t know yet what is triggering this bug.

Thanks

RE: [Solved] MSProject Synchronisation - Added by Alexander Bach about 8 years ago

Hello again,

I tried to follow your replication steps, but was not able to reproduce the error.

After subscribing to two different parent workpackages and their respective children I moved one workpackage from one parent to the other. Hitting synchronize right after that did not show any errors or warnings, just the changes I would expect from the operation preformed.

Have any of your changes been made on the parent tasks 1 and 2?

Regards,
Alex

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben about 8 years ago

I’m not really surprise, as this bug does not appear very often

I’ve seen that a new version is available , 2.14
I used 2.13 before. I see that the icons have changed, looks nice.

I will try with this new version and let you know

RE: [Solved] MSProject Synchronisation - Added by fariouche Ben about 8 years ago

Hello,

I still can reproduce this bug with the latest taskconnector plugin…

It seems to be related to task editing from msproject (moving task from one parent to a new one, deleting tasks from msproject or renaming tasks…)

When the bug arises, the plugin seems to be confused about one task (open project task id is wrong and it is requesting for a subscription of the task, which is then described in one of my previous post)
I can still synchronize to openproject all the other tasks, if I ignore the buggy one.

One time the id of the task was one of an other task in open project! (if “mstask A” was pointing to “openproject task id 1”, it suddenly changed “mstask A” to point to “openproject task id 4” for example, and the plugin was completly lost.)
To fix this, we had to go to openproject, rmove the parent, delete the task in msproject, subscribbe it again, and move again the task back to the good parent before synchronizing)

It seems to only happen after a long usage time in msproject.

One other time, one task was again “unsubscribed”, and could not subscribe it anymore (it only create an empty mstask with no information) and the task was already in msproject…. Closing and reopening msproject solved the issue.

I don’t know how I can help you with this bug :(… It’s the only one I have with this great plugin.

Thanks

  • (1 - 28/28)
Loading...