Project Management migration

Migrate from GUIDEcx to Microsoft Project

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

GUIDEcx logo

GUIDEcx

Source

Microsoft Project

Destination

Microsoft Project logo

Compatibility

83%

10 of 12

objects map 1:1 between GUIDEcx and Microsoft Project.

Complexity

CModerate

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Moving from GUIDEcx to Microsoft Project is a structural migration away from a purpose-built onboarding platform toward a generalist scheduling tool. GUIDEcx organizes work across a five-level hierarchy (Project, Phase, Milestone, Task Group, Task) with an external-facing client portal, customer role assignments, and template-driven project launches tied to CRM events. Microsoft Project has no equivalent client-facing portal, no native customer role concept, and no template launcher tied to external systems. We collapse GUIDEcx's hierarchy into Microsoft Project summary tasks, map milestones to the MS Project milestone task type, preserve task dependencies as predecessor-successor links, and carry tags as text fields or custom columns. GUIDE 1.0 templates must be cloned to GUIDE 2.0 via the self-serve migration tool before any export—the original 1.0 template remains intact after cloning. We do not migrate Recipe Builder automations, Welcome Message content, the Compass client portal, or GUIDEcx-specific role-based permission scopes; these have no equivalent in Microsoft Project and require manual rebuild or process change 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

GUIDEcx logo

GUIDEcx

What's pushing teams away

  • GUIDEcx is purpose-built for onboarding and becomes awkward for managing post-launch or ongoing client follow-ups, pushing teams to use a secondary tool.
  • Early integration complexity with Salesforce and automations frustrated teams during initial implementation, even though Recipe Builder has improved this.
  • Profile impersonation and bulk date editing features have known stability issues, forcing users to work around the platform rather than through it.
  • Enterprise pricing with a minimum of 4 licenses and non-public volume tiers makes budget forecasting difficult without a sales call.

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 GUIDEcx objects map to Microsoft Project

Each row shows how a GUIDEcx 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.

GUIDEcx

Project

maps to

Microsoft Project

Project (MPP or Project for the Web)

1:1
Fully supported

Each GUIDEcx project maps to a single Microsoft Project file (MPP) or a Project for the Web project. Project name, planned start and end dates, status, and any project-level custom fields migrate as file-level or project-level columns. GUIDEcx project tags migrate as a custom text column in MS Project. Active GUIDEcx projects migrate as active MS Project plans; completed or archived projects migrate as inactive projects or are excluded based on scope during discovery.

GUIDEcx

Phase / Template

maps to

Microsoft Project

Summary Task or Phase Group

lossy
Fully supported

GUIDEcx phases are a reusable project structure with embedded tasks, milestones, assignees, and durations. In MS Project, phases map to top-level summary tasks that contain their child tasks. If the customer uses GUIDEcx Project Templates (as opposed to Phase Templates), the template structure maps to an MS Project template file (.mpt) for reuse. GUIDE 1.0 templates must be cloned to 2.0 via GUIDEcx's self-serve Template Migration tool before we export them—1.0 templates do not appear in the 2.0 environment and will not export from the API in a 2.0-compatible format.

GUIDEcx

Milestone

maps to

Microsoft Project

Milestone Task

1:1
Fully supported

GUIDEcx milestones map directly to MS Project milestone tasks (tasks with zero duration and a milestone diamond indicator). Milestone name, planned date, and any milestone-level status migrate as the task name, start date, and a custom status column. Milestone dependencies (milestone-to-task or task-to-milestone finish-to-start links) migrate as predecessor-successor relationships in MS Project.

GUIDEcx

Task Group

maps to

Microsoft Project

Summary Task

1:1
Fully supported

GUIDEcx Task Groups are a grouping layer above individual tasks with their own assignees and sort order. They map to MS Project summary tasks with the task group name as the summary task name and child tasks indented below. Task Groups carry no separate duration in GUIDEcx—duration is set at the individual task level—and this structure is preserved in MS Project's outline hierarchy. The task group's assignee and custom fields are added as columns to the summary task row.

GUIDEcx

Task

maps to

Microsoft Project

Task

1:1
Fully supported

GUIDEcx tasks are the core work unit. Each task maps to an MS Project task with task name, duration (calculated from planned start and due date), start and finish dates, assignees (GUIDEcx allows multiple assignees; MS Project assigns one resource per assignment row), status, and any task-level custom fields. Task instructions from GUIDEcx migrate as a custom Notes field or as a column in MS Project. GUIDEcx tags on tasks migrate as a comma-separated text column or as a custom picklist field.

GUIDEcx

Task Dependency

maps to

Microsoft Project

Predecessor Link

1:1
Fully supported

GUIDEcx finish-to-start task dependencies map to MS Project predecessor links. The GUIDEcx dependency graph is exported and reconstructed as predecessor-successor task ID pairs during import. We flag known GUIDEcx 2.0 dependency bugs: subtask-child shared dependencies and tasks marked N/A that break dependency chains, as documented in GUIDEcx's 2026 release notes. These are logged in the migration reconciliation report for manual review.

GUIDEcx

Custom Fields (Project Level)

maps to

Microsoft Project

Project Custom Fields / Text Columns

1:1
Fully supported

GUIDEcx project-level custom fields (Text, Date, Email, Number, Dropdown, etc.) map to named custom fields in MS Project Desktop or to custom columns in Project for the Web. Field type mapping follows GUIDEcx's Custom Fields V2 schema: dropdown fields map to drop-down menus with the same option values; date fields map to date columns; number fields map to number columns. We pull the field type definitions from GUIDEcx's Data Dictionary during scoping because the standard task export does not include field schema.

GUIDEcx

Custom Fields (Task Level)

maps to

Microsoft Project

Task Custom Fields / Text Columns

1:1
Fully supported

GUIDEcx task-level custom fields map to task-level custom columns in MS Project. The same field-type mapping logic from project-level fields applies. Custom fields on template-level tasks that failed to propagate to project-level tasks (a documented GUIDEcx 2.0 bug) are flagged during reconciliation and included as blank values with a note in the migration report.

GUIDEcx

Customer Roles and Customer Team Contacts

maps to

Microsoft Project

Resources (no equivalent role concept)

lossy
Mapping required

GUIDEcx distinguishes internal team members from external customer contacts via Customer Roles assigned in Resource Management and added to a project's Customer Team. Microsoft Project has no equivalent role-based external stakeholder concept. We map external customer contacts to MS Project Resources (with a resource type flag distinguishing internal from external) and flag that the customer's admin should manually assess whether external contacts need a separate SharePoint or Teams collaboration channel for communication, since MS Project has no portal equivalent.

GUIDEcx

Attachments

maps to

Microsoft Project

Hyperlinks or SharePoint Document Library

1:1
Mapping required

GUIDEcx attachments at the project and phase levels map to hyperlinks in the MS Project task Notes field or to a linked SharePoint document library. A documented GUIDEcx 2.0 bug causes attachments on API-created or template-derived phases to drop during export—we extract attachment metadata separately via the GUIDEcx API and re-attach by URL reference in the destination. File content migration is limited to URL references unless the customer specifies a file share or SharePoint destination.

GUIDEcx

Comments

maps to

Microsoft Project

Task Notes

1:1
Mapping required

GUIDEcx task comments are not included in the standard task export. We retrieve comment threads via the GUIDEcx API and represent them as structured entries in the MS Project task Notes field, formatted with the comment author's name, timestamp, and text. Embedded images in comments migrate as URL references only; the original image files are not imported unless the customer specifies a file destination.

GUIDEcx

Time Records

maps to

Microsoft Project

Task Usage / Assignment Owner

1:1
Mapping required

GUIDEcx time tracking records migrate to MS Project's Task Usage view or as a separate time-record export, depending on the destination version. The GUIDEcx 2026 release notes document missing values in the Time Records dataset—we cross-reference API data against the export to fill gaps where possible. MS Project does not have a native time-entry submission system; time records are informational unless the customer uses Project Online with a timesheet integration.

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.

GUIDEcx logo

GUIDEcx gotchas

High

GUIDE 1.0 and 2.0 templates do not coexist automatically

High

Phase attachments and project role assignments drop during API-created phases

Medium

Custom field definitions are not included in standard task exports

Medium

Checklist items and completed_date are unreliable in exported datasets

Low

Status labels versus status_category cause confusion in reporting

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

  • GUIDE 1.0 templates require manual cloning before export

    GUIDEcx runs GUIDE 1.0 and GUIDE 2.0 as separate product architectures. Legacy 1.0 templates do not appear in the GUIDE 2.0 environment and cannot be exported via the 2.0 API in a structure-compatible format. The customer must use GUIDEcx's self-serve Template Migration tool to clone each 1.0 template into 2.0 before we can export it. We identify which templates are 1.0 versus 2.0 during scoping and provide a list with the cloning instructions from GUIDEcx's knowledge base. If we attempt to export a 1.0 template without the clone step, the import into MS Project will produce an incomplete or malformed structure.

  • GUIDEcx's five-level hierarchy has no direct MS Project equivalent

    GUIDEcx structures work across five levels (Project, Phase, Milestone, Task Group, Task) with a client portal and external stakeholder visibility built into each level. Microsoft Project natively supports two levels—summary tasks and tasks—with milestones as a task type rather than a separate object. We collapse Phase and Task Group levels into MS Project summary tasks, but the customer's admin should review the resulting outline depth and decide whether to consolidate further (Phase + Task Group into one summary level) or preserve more hierarchy by flattening the Task Group level only. The Compass client portal has no MS Project equivalent and must be replaced by a SharePoint site or Teams channel if external visibility is required.

  • Phase attachments and role assignments drop on API-created phases

    When phases are created from templates via the API or in some UI scenarios, GUIDEcx's 2026 release notes document that attachments and project role assignments do not carry over. We extract attachment metadata separately and cross-check phase role assignments against the template's role list during migration. Any missing attachments or role assignments are flagged in the reconciliation report for the customer's admin to re-attach manually post-migration. This is a GUIDEcx product limitation, not a migration tooling issue.

  • Checklist items and completed_date are unreliable in exported data

    The GUIDEcx 2.0 Tasks dataset has a documented bug where completed_date is not populating correctly, and checklist items on task templates do not reliably show up on project-level tasks. We cross-reference task export data against direct API calls to fill gaps. Checklist items are treated as a structured list field and represented as a JSON array in an MS Project custom text field. If completed_date is absent, we compute it from the task's status_category (mapping 'completed' to the MS Project 100% complete flag) and flag any records where the computation is ambiguous.

  • Status labels versus status_category cause mapping mismatches

    GUIDEcx separates user-facing status labels (customizable text shown in the UI) from system-defined status_category values (non-editable, used for filtering and KPIs). Some teams rename status labels without updating their workflow triggers, leading to exports where the label says 'In Progress' but the underlying status_category is 'blocked'. We map both fields during migration and validate that status_category values align with the intended workflow state in MS Project. Status labels that have been customized beyond the standard set are mapped to MS Project's custom task status field or to a text column, and the customer receives a status mapping table as part of the migration documentation.

Migration approach

Six steps for a successful GUIDEcx to Microsoft Project data migration

  1. Discovery and template audit

    We audit the source GUIDEcx environment: project count, active versus archived projects, task count, custom field definitions (pulled from the GUIDE 2.0 Data Dictionary), GUIDE 1.0 template identification, Milestone and Task Group usage, dependency graph depth, tag taxonomy, and customer role structure. We also identify any projects with phase attachments or checklist-heavy tasks that are subject to known export bugs. The discovery output is a written scope document with a project inventory, GUIDE 1.0 template list (with cloning instructions), and a custom field schema map. We confirm the destination MS Project version (Desktop, Project for the Web, or Project Online) and any SharePoint or Teams integration requirements during this step.

  2. GUIDE 1.0 template pre-migration (if applicable)

    If GUIDE 1.0 templates are in scope, the customer executes GUIDEcx's self-serve Template Migration tool per the knowledge base article: navigate to Templates, click the 2.0 experience banner, use the Migrate Templates button, select the relevant templates, and start the migration. GUIDEcx states this takes a few minutes depending on template size. We confirm that migrated templates appear in the GUIDE 2.0 Template Library before proceeding to export. We do not execute the GUIDEcx-side clone step—only the customer can perform this action in their GUIDEcx environment.

  3. Dependency graph extraction and validation

    We extract the full task dependency graph from GUIDEcx via the API, including finish-to-start links, any subtask-child shared dependencies, and N/A-marked tasks flagged in GUIDEcx's 2.0 release notes as breaking dependency chains. We validate the graph for circular references (which GUIDEcx does not prevent) and generate a circular-reference report for the customer's admin to resolve before import. Once validated, the dependency graph is structured as a predecessor-successor table ready for MS Project import.

  4. Schema reconciliation and hierarchy mapping decision

    We review the GUIDEcx five-level hierarchy against MS Project's two-level model and make a recommendation: collapse Phase and Task Group into a single summary-task level, or preserve Phase as a top-level summary and Task Group as a second-level summary, accepting that the deepest outlines may reach four to five indent levels. We also confirm custom field type mapping for all project-level and task-level GUIDEcx custom fields, identify which status_category values map to MS Project task percent-complete states, and decide on the tag representation (custom text column or flat label field). The customer reviews and approves the hierarchy mapping before we proceed to data extraction.

  5. Data extraction, transformation, and MS Project import

    We extract all projects, phases, milestones, task groups, tasks, dependencies, custom field values, tags, time records (where available), and comments via the GUIDEcx API and export datasets. We transform the data: GUIDEcx's Phase and Task Group rows become MS Project summary tasks with outline indent applied; milestones become zero-duration tasks with the milestone flag set; multi-assignee tasks become multiple resource assignment rows in MS Project. We import the data into the customer's MS Project environment using MPP file construction (for desktop) or the Microsoft Project Data API (for Project for the Web and Project Online). Each project file is validated for dependency integrity, duration accuracy, and outline structure before the next project begins.

  6. Cutover, validation, and client portal replacement plan

    We deliver a validation report per project: task count in versus task count out, milestone count, dependency count, and a spot-check sample of 10-15 tasks comparing source and destination values. We flag the client portal replacement: a written plan recommending a SharePoint site or Teams channel structure to replicate the Compass portal's external visibility for stakeholders who previously accessed GUIDEcx without a login. We do not build the SharePoint site or Teams channel inside the migration scope. We provide a Recipe Builder automation inventory (triggers, conditions, and actions) in written form for the customer's admin to rebuild in Power Automate if needed. Post-migration support is available as a separate engagement.

Platform deep dives

Context on both ends of the pair

GUIDEcx logo

GUIDEcx

Source

Strengths

  • Template-based project structure with a five-level hierarchy gives clear visual and logical organization for complex onboarding workflows.
  • White-labeled client portal (Compass) lets external stakeholders view progress and complete tasks without needing their own GUIDEcx login.
  • Built-in role-based views for internal teams and external customers with separate permission scopes.
  • Task dependency engine supports finish-to-start chains that automatically cascade dates when upstream tasks complete.
  • Bulk Actions for subtasks (released October 2025) significantly reduces manual overhead when updating participant and event tasks in large projects.

Weaknesses

  • Post-onboarding workflow management is a documented gap—teams managing ongoing client work after go-live must use a separate platform.
  • GUIDE 1.0 and 2.0 operate as separate product lines, requiring manual template cloning for teams moving to the new architecture.
  • Customer roles and contact assignments require manual setup in Resource Management before they appear in a project's Customer Team—easy to misconfigure.
  • No built-in bulk due-date editing forces users to edit task dates individually, which is time-consuming on large projects.
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?

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

C

Overall complexity

Moderate migration

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

  • Object compatibility

    C

    4 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

    GUIDEcx: Not publicly published in the OpenAPI doc — confirm with the GUIDEcx account manager when API access is enabled for the workspace..

  • Data volume sensitivity

    B

    GUIDEcx doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your GUIDEcx 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 GUIDEcx to Microsoft Project data migrations

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

Can't find your answer?

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

Book a free 30 minute consultation

Most migrations land between three and five weeks for accounts under 20 projects and 2,000 tasks. Migrations with GUIDE 1.0 templates (requiring pre-migration cloning), high task counts (over 10,000 tasks), or extensive custom field usage move to six to ten weeks because of schema reconciliation, dependency graph validation, and the hierarchy collapse work. The GUIDE 1.0 template cloning step is customer-executed and runs outside our timeline; we include it in our schedule but cannot control how quickly the customer completes it.

Adjacent paths

Related migrations to explore

Ready when you are

Move from GUIDEcx.
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