Project Management migration

Migrate from actiTIME to Microsoft Project

Field-level mapping, validation, and rollback between actiTIME and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.

actiTIME logo

actiTIME

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

50%

5 of 10

objects map 1:1 between actiTIME and Microsoft Project.

Complexity

BStandard

Timeline

2-4 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from actiTIME to Microsoft Project is primarily a data-transformation migration because the two platforms model work differently. actiTIME organises its hierarchy as Customers containing Projects containing Tasks — a flat, time-centric structure. Microsoft Project requires a Work Breakdown Structure with Summary Tasks, sub-tasks, start/finish dates, durations, and predecessor links that actiTIME does not natively generate. We reconstruct the WBS from actiTIME task deadlines, estimated hours, and the parent-child hierarchy at migration time. Time-track entries become actual work in Microsoft Project, though Microsoft Project only accepts either % complete or actual hours per task — not both simultaneously, a constraint we document during scoping. actiTIME's leave-time records, types of work taxonomy, custom fields, and workflow statuses have no direct Microsoft Project equivalent; we map what is feasible to custom fields and deliver a written inventory of every object requiring manual rebuild post-migration.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

actiTIME logo

actiTIME

What's pushing teams away

  • The product lacks native integrations with CRM and invoicing platforms, forcing teams into manual CSV exports and re-entry that erodes the value of time tracking.
  • Users report that the mobile app requires manual synchronization — hours entered offline do not push automatically when connectivity returns, leading to lost or forgotten entries.
  • actiTIME's feature set is centred on time tracking and basic project management; teams seeking full project-management capabilities like Gantt charts, resource-leveling, or advanced dependencies outgrow it.
  • Limited API documentation and the absence of OAuth authentication create friction for teams trying to automate data flows or build custom integrations.
  • Some users note that actiTIME's UI, while functional, feels dated compared to newer time-tracking tools, particularly on mobile.

Choosing

Microsoft Project logo

Microsoft Project

What's pulling them in

  • Organizations already running Microsoft 365 and Azure AD adopt Microsoft PPM because it slots into existing identity, Teams, and SharePoint infrastructure without requiring a separate identity provider or SSO vendor.
  • Enterprise PMOs choose it for critical-path scheduling, baseline comparison, cross-project dependencies, and resource utilization reporting that standalone PM tools cannot replicate at this depth.
  • Project Online's integration with Power BI gives portfolio-level dashboards and cost-rollup reporting that satisfies executive governance requirements without third-party BI tooling.
  • Government, financial services, and healthcare organizations select it because FedRAMP, ISO 27001, and SOC 2 compliance certifications meet enterprise procurement requirements out of the box.
  • Large IT departments default to it as the market-leader in project portfolio management software, often driven by corporate licensing agreements that bundle it with other Microsoft 365 seats.

Object mapping

How actiTIME objects map to Microsoft Project

Each row shows how a actiTIME object lands in Microsoft Project, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

actiTIME

Customer

maps to

Microsoft Project

Project

1:1
Fully supported

actiTIME Customers map directly to Microsoft Project plans. In Project for the web, each Customer becomes a Project object with the customer name as the project name. In Project Online, the Customer maps to a Project Site. We preserve the actiTIME Customer description as the project description field. Archived customers are migrated as inactive projects. Note that Microsoft Project does not support a true parent-level above Project (unlike actiTIME's Customer), so organizations using actiTIME Customers to group unrelated business units will need to document the grouping logic in the migration handoff for manual restructuring in Microsoft Project.

actiTIME

Project

maps to

Microsoft Project

Project tasks container

1:1
Fully supported

actiTIME Projects map to the top-level container within a Microsoft Project plan. The actiTIME project name, status (active/archived), deadline, and estimated hours transfer to the Microsoft Project project summary task or project-level fields. If the destination is Project Online, we map to the Project Detail Page fields. Estimated hours become a custom field (Estimated Hours) rather than a native scheduling field since Microsoft Project calculates schedule from start/duration dependencies, not from hour estimates.

actiTIME

Task

maps to

Microsoft Project

WBS Task (Summary Task and sub-task)

1:many
Fully supported

actiTIME Tasks require transformation into a Microsoft Project WBS. The actiTIME parent-child project-task hierarchy maps to Summary Task and sub-task structure, but actiTIME stores no duration, start date, or dependency data natively — these must be inferred or calculated. We derive task duration from actiTIME deadline minus estimated start (defaulting to project start date if no individual start is recorded). Dependencies between tasks are not present in actiTIME and must be inserted manually or inferred from task sequence order; we document the inferred dependency graph in the migration report and the customer's PMO rebuilds critical path dependencies post-migration. Custom workflow statuses from actiTIME map to custom task-level fields since Microsoft Project does not have a native workflow status concept.

actiTIME

Time-Track entry

maps to

Microsoft Project

Task actual work

1:many
Fully supported

actiTIME time-track entries (logged hours per user per task per date) consolidate into Microsoft Project actual work on the corresponding task. Multiple entries for the same task across dates and users merge into a single actual work value. A key constraint: Microsoft Project tracks either % complete OR actual hours, not both simultaneously — if the customer's actiTIME instance uses both, we use actual hours as the primary mapping and document % complete gaps. For completed tasks with logged hours but no completion date, we infer % complete from the time-track total versus the actiTIME task estimate. Time-track comments migrate to task notes as a text block per task.

actiTIME

User

maps to

Microsoft Project

Project resource

1:1
Fully supported

actiTIME Users map to Project resources. We export the full user roster including inactive users (for historical assignment context) and map to Microsoft Project resources with the user's display name and email. Active/inactive status maps to Resource Standard Rate Active flag. actiTIME time-zone group assignments have no Microsoft Project equivalent — we document timezone information as a custom resource field. Note that Microsoft Project for the web uses the Microsoft 365 user directory as its resource pool, so any actiTIME user without a Microsoft 365 license must be provisioned before or during migration.

actiTIME

Custom Field (actiTIME)

maps to

Microsoft Project

Custom field (Microsoft Project)

lossy
Fully supported

actiTIME custom fields per task migrate to Microsoft Project custom fields where the destination field type supports the mapping. Text custom fields map to Text custom fields; numeric fields map to Number custom fields; date fields map to Date custom fields. Multi-select custom fields (checkbox groups) do not have a native Microsoft Project equivalent and are documented as text lists in a Notes-style custom field. Custom fields on Customers and Projects map to project-level custom fields. We pre-create all destination custom fields during the schema design phase before data migration begins.

actiTIME

Type of Work

maps to

Microsoft Project

Custom field (task-level)

lossy
Fully supported

actiTIME Types of Work categorise time-track entries (e.g., Development, Meeting, Research). Microsoft Project has no native type-of-work taxonomy. We map Types of Work to a task-level custom field (Type of Work) with the applicable values as a picklist. Each time-track entry's type-of-work value is aggregated into a comma-separated list on the task's custom field since a single actiTIME task may have multiple Types of Work logged across entries.

actiTIME

Workflow Status (actiTIME)

maps to

Microsoft Project

Custom field (task-level)

lossy
Fully supported

actiTIME custom workflow statuses are feature-gated by the taskWorkflow flag in the instance /info endpoint. Where enabled, workflow stages are exported as a list and mapped to a task-level custom field (Workflow Stage) with the applicable status values as a picklist. Since Microsoft Project does not have a native workflow state machine, task workflow progression must be managed manually post-migration or rebuilt in Power Automate as a separate automation project.

actiTIME

Leave Time

maps to

Microsoft Project

No direct equivalent

1:1
Mapping required

actiTIME leave-time records (where leavetimeRegistration is enabled in the source instance) have no Microsoft Project equivalent. Microsoft Project does not track leave, PTO, or absence. We export the leave-time records as a separate CSV inventory during migration and document this data for the customer's HR system administrator to import into their absence management tool (Microsoft Dynamics 365 HR, BambooHR, or equivalent) separately from the project migration.

actiTIME

Time Zone Group

maps to

Microsoft Project

Custom field (resource-level)

1:1
Fully supported

actiTIME Time Zone Groups group users by timezone for reporting across distributed teams. This concept is not native to Microsoft Project. We export the TZG roster and user assignments, then map the primary timezone to a resource-level custom field (Time Zone) on each Project resource. This preserves the information for reporting and workload analysis even though Microsoft Project does not use timezone data in its scheduling engine.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

actiTIME logo

actiTIME gotchas

High

Basic Authentication only — no OAuth

High

Feature flags gate entire object classes

High

Deleting a project permanently erases all associated time-track data

Medium

Locked timesheets prevent time-track modification

Medium

Batch API maxBatchSize caps concurrent requests

Microsoft Project logo

Microsoft Project gotchas

High

Project for the web is being retired and merged into Microsoft Planner

Medium

Planner-tier portfolio features are incomplete despite Plan 5 labeling

Medium

Web app constraint controls are weaker than the Windows desktop client

High

Project requires a separate license not bundled with standard Microsoft 365

Medium

Project Online API is edition-gated and inconsistently documented

Pair-specific challenges

  • actiTIME stores flat tasks, not WBS hierarchies

    actiTIME Projects contain a flat list of Tasks with no parent-child sub-task structure, no task duration fields, no start date, and no predecessor-successor dependency links. Microsoft Project requires a WBS with Summary Tasks, sub-tasks, task durations, start and finish dates, and dependency relationships to render a Gantt chart or calculate a schedule. We infer durations from actiTIME deadlines and project start dates, and we document an inferred dependency graph based on task ordering, but the Microsoft Project scheduling engine must be configured by the customer's PMO after migration. Migrations that skip this WBS design phase arrive in Microsoft Project with a flat list of tasks that has no schedule.

  • Microsoft Project accepts % complete OR actual hours, not both

    Microsoft Project for the web and Project Online do not simultaneously track both % complete and actual hours on a task — the scheduling model requires the admin to choose one as the primary progress-tracking mode. actiTIME time-track entries represent logged hours that map to actual hours in Microsoft Project, but if the destination task also uses % complete as its progress metric, the two values may conflict. We set actual hours as the default mapping and flag every task where both % complete and actual hours exist in the source so the customer's project manager chooses the correct mode per task before cutover.

  • Microsoft Project for the web has no public REST API

    Unlike actiTIME's REST API (with Basic Authentication), Microsoft Project for the web does not expose a public REST API for direct data import. Integrations with Project for the web rely on Power Automate connectors, the Project PWA API (for Project Online), or the Microsoft Graph beta API (for Project for the web, subject to preview status). This means migration to Project for the web requires using the Microsoft 365 admin centre's CSV import capability or a third-party migration tool with a proprietary connector. We scope the destination API method during discovery and configure the correct ingestion path before migration begins.

  • actiTIME Basic Authentication only — no OAuth 2.0

    actiTIME's API exclusively supports HTTP Basic Authentication. Any migration script must encode username:password as Base64 and embed the Authorization header in every request. There is no OAuth 2.0, no API key UI, and no token refresh mechanism. If the actiTIME instance uses SSO or external directory authentication, we request a dedicated API service account during scoping before attempting authentication. We never log credentials and transmit them only over HTTPS.

  • Workflows, automations, and leave-time approval chains do not migrate

    actiTIME workflows, timesheet approval chains, and automated notifications have no direct Microsoft Project equivalent. Microsoft Project does not have a native workflow engine; automation scenarios are handled by Power Automate, SharePoint workflows (deprecated), or Project Online workflows. We do not migrate workflows as code. We deliver a written inventory of every active actiTIME workflow, its trigger conditions, actions, and assigned users, with a recommended Power Automate equivalent documented per workflow. Timesheet approval workflows are noted as requiring rebuild in the customer's HR or absence management tool if leave-time data is retained.

Migration approach

Six steps for a successful actiTIME to Microsoft Project data migration

  1. Discovery and feature scan

    We query the actiTIME /info endpoint at the start of every migration to retrieve the full feature flag set including departments, taskWorkflow, taskEstimates, leavetimeRegistration, and timeZoneGroups. We count Customers, Projects, Tasks, time-track entries, and Users to size the migration. We also identify the Microsoft Project destination type (Project for the web, Project Online, or Project Desktop) during this phase because the ingestion method differs significantly — Project for the web uses CSV import and Power Automate; Project Online uses the PWA API. The discovery output is a written migration scope and a destination API method recommendation.

  2. Schema design and WBS reconstruction

    We design the Microsoft Project WBS structure before any data is written. This includes mapping actiTIME Projects to Microsoft Project plans, deriving task durations from actiTIME deadlines and estimated start dates, building the Summary Task and sub-task hierarchy, and creating the resource pool from the actiTIME user roster. We pre-create all Microsoft Project custom fields during this phase so the field IDs are available at migration time. For tasks with multiple actiTIME time-track entries across users and dates, we aggregate the data and document the consolidation logic. Dependencies are inferred from task ordering and documented as a separate dependency graph for the customer's PMO to review and insert as predecessor links post-migration.

  3. Pilot migration and WBS validation

    We run a pilot migration of the most complex actiTIME Project first — the one with the deepest task nesting, the most time-track entries, and the highest number of custom fields. We validate task count, WBS hierarchy depth, duration calculations, resource assignments, and time-track aggregation against the actiTIME source. We specifically check that % complete and actual hours do not conflict on any task and flag the resolution for the customer's project manager. The customer approves the pilot mapping before we proceed to full production migration. Any WBS restructuring corrections happen here.

  4. Production migration in dependency order

    We run production migration in record-dependency order: Projects (as Microsoft Project plan containers) first, then WBS tasks with duration and resource assignments, then time-track entries aggregated into actual work per task. Users are mapped to Project resources throughout. Custom fields and types of work are written as part of the task import. Each phase emits a row-count reconciliation report before the next phase begins. We run a final reconciliation comparing the sum of actiTIME time-track hours to the total actual work in the destination Microsoft Project plan and resolve any discrepancies before declaring migration complete.

  5. Cutover, validation, and workflow inventory handoff

    We freeze writes to actiTIME during cutover and run a final delta migration of any time-track entries created during the migration window. We deliver the migration report including record counts, unmapped fields, WBS complexity notes, and a per-project time-track reconciliation summary. We deliver the Workflow and Automation Inventory document listing every actiTIME workflow and its recommended Power Automate equivalent. We support a one-week hypercare window for reconciliation issues raised by the customer's project team. We do not rebuild actiTIME workflows as Power Automate flows inside the migration scope; that work is a separate engagement.

Platform deep dives

Context on both ends of the pair

actiTIME logo

actiTIME

Source

Strengths

  • Long-established platform with over 20 years of market presence and a stable, well-understood data model.
  • Offers both SaaS (Online) and self-hosted deployment options for organizations with data-residency requirements.
  • Hierarchical Customer → Project → Task structure is clean and maps predictably to most destination systems.
  • Rich time-track data including billability flags, type of work, comments, and approval statuses.
  • Integrated leave-time tracking and timesheet approval workflows reduce the need for separate HR tools.

Weaknesses

  • API authentication is limited to Basic Authentication only — no OAuth 2.0, which restricts automated integrations in environments requiring modern auth patterns.
  • Feature gates throughout the instance mean not all objects exist in every deployment, requiring a pre-migration feature scan.
  • Limited native integrations with CRM, invoicing, or ERP platforms, making actiTIME a data silo for many organizations.
  • Mobile app requires manual data synchronization rather than automatic background sync when connectivity is restored.
  • The platform lacks advanced project-management features like Gantt charts, resource-leveling, or dependency tracking.
Microsoft Project logo

Microsoft Project

Destination

Strengths

  • Deep critical-path scheduling with baseline comparison and cross-project dependency tracking unmatched by lighter PM tools.
  • Native Azure AD authentication, Teams integration, and Power BI reporting sit on infrastructure enterprises already license and manage.
  • Enterprise governance controls including demand intake workflows, resource request approval, and portfolio-level capacity analysis.
  • Supports both Waterfall and Agile methodologies within the same project, accommodating hybrid delivery teams.
  • Scalable from Project Plan 1 for small teams to Project Server on-premises for regulated industries with strict data-sovereignty requirements.

Weaknesses

  • Ease-of-use scores trail the category average by a wide margin; onboarding friction frustrates new users consistently across G2 and Capterra reviews.
  • Pricing ranks 42nd of 49 tools in its category — the total cost of ownership including IT administration and training is rarely recovered for small or mid-market teams.
  • No built-in client portal, external stakeholder sharing, or proofing workflow, limiting use cases to internal PMO environments only.
  • The web interface (Project for the web / Planner Premium) has materially weaker constraint controls and resource auto-leveling than the Windows desktop client.
  • Project for the web is being consolidated into Microsoft Planner, creating uncertainty about which product tier will host project portfolio data long-term.

Complexity grading

How hard is this migration?

Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across actiTIME and Microsoft Project.

  • Object compatibility

    B

    1 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    actiTIME: maxQueryLimit and maxBatchSize exposed per-instance via the /info endpoint; not publicly documented in general API guide.

  • Data volume sensitivity

    A

    actiTIME exposes a bulk API — large-volume migrations stream efficiently.

Estimator

Estimate your actiTIME to Microsoft Project migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about actiTIME to Microsoft Project data migrations

Answers to the questions buyers ask most during actiTIME to Microsoft Project migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your actiTIME to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most actiTIME to Microsoft Project migrations land between two and four weeks for accounts with up to 30 actiTIME Projects, 2,000 Tasks, and 50,000 time-track entries. Migrations with deeply nested WBS structures, over 5,000 Tasks, or large time-track histories (over 200,000 entries) extend to four to six weeks because of the WBS reconstruction work and time-track aggregation step. The pilot validation phase adds one to two weeks but reduces the risk of schedule surprises during production cutover.

Adjacent paths

Related migrations to explore

Ready when you are

Move from actiTIME.
Land in Microsoft Project, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day