Skip to content

OpenProject Sync for Exact Online

Book the time your team logs in OpenProject as hours in Exact Online: one draft line per person, work package and day. Work packages become WBS lines, and the approval status of the hours comes back in OpenProject as a comment.

Get started Link a project

Where it lives

OpenProject Sync is an app of the Exact Gateway portal at https://apps.mvdw-software.com/exact/openproject-sync/. Your account, organization, subscription and the connection to Exact Online live in the portal; this app syncs OpenProject with it.

Why

Your team plans and logs its time in OpenProject, because that is where the work is. Your administration and the project's profitability live in Exact Online. Without a link, someone exports the hours every week and re-types them in Exact, and the booked hours drift from what was actually worked: the wrong person, the wrong project, or a week nobody got around to.

OpenProject Sync links an OpenProject project to an Exact project and keeps them in step:

  • every time entry in OpenProject becomes a draft hour line in Exact, one line per person, work package and day, already on the right project and hour type;
  • work packages (with their parent/child structure) become WBS activities, and versions can become WBS deliverables, so the work breakdown follows the OpenProject plan;
  • when someone approves or rejects the hours in Exact, a comment appears on the work package in OpenProject, so the team sees what finance decided without asking;
  • people are matched automatically on their e-mail address, so time logged by Tom lands on Tom's employee record without anyone doing anything.

The team keeps working in OpenProject; administration approves the draft lines in Exact as usual.

A linked project, syncing:

The projects page: the linked Web shop project with its status, last sync and a Sync now button

How it fits together

flowchart TB
    subgraph op ["OpenProject (cloud or self-hosted)"]
        T["time entries"]
        I["work packages and versions"]
        C["comments on work packages"]
    end
    subgraph app ["OpenProject Sync"]
        S["sync engine: every 15 minutes, per linked project"]
        M["people: OpenProject user → Exact employee"]
    end
    subgraph exact ["Exact Online (via the portal's connection)"]
        H["draft hour lines, one per person, work package and day"]
        W["WBS activities and deliverables"]
        P["the linked Exact project"]
    end

    T -- "read" --> S
    I -- "read" --> S
    S -- "create / update draft lines" --> H
    S -- "create WBS lines" --> W
    P -- "existing, or created from OpenProject" --> S
    H -- "status: approved, rejected" --> C
    M -- "match on e-mail" --> S

The organization signs in once in the portal, connects its Exact Online administration there (once per app), and adds an OpenProject API token in OpenProject Sync. From then on the sync runs on a schedule.

What this documentation covers

You want to… Read
subscribe, connect Exact Online and add an OpenProject token Getting started
link an OpenProject project to an Exact project, step by step Link a project
understand what is synced, when, and what happens on conflicts How the sync works
fix a failing token, a failing project or hours that do not appear Troubleshooting