Project Management migration
Field-level mapping, validation, and rollback between web2Project and Microsoft Project. We move data and schema; workflows are rebuilt natively in Microsoft Project.
web2Project
Source
Microsoft Project
Destination
Compatibility
6 of 11
objects map 1:1 between web2Project and Microsoft Project.
Complexity
BStandard
Timeline
3-5 weeks
Overview
web2Project has no production REST API, so all data extraction happens through direct MySQL database reads. We connect to the source MySQL instance, inspect the schema version (pre- or post-v2.4, since the Custom Field system changed significantly between those releases), and map Projects, Tasks, Task Dependencies, Users, Companies, and Custom Fields to their Microsoft Project equivalents. Task hierarchy and predecessor-successor dependency chains transfer as-is. Budget fields migrate as read-only text because web2Project's budget fields are documentation-only and carry no financial calculation logic. Forum posts, file attachment metadata, and calendar events map to task notes and linked file references where the destination supports them. We do not migrate workflows, custom modules, or user activity logs because Microsoft Project does not have equivalent objects for these. The result is a validated project plan delivered as an MPP file or a SharePoint-connected Project Online workspace, depending on the destination license.
Every standard and custom field arrives verified.
AI proposes the map; you confirm before any record moves.
Parent–child, lookups, and ownership stay linked.
Calls, emails, meetings — with original timestamps.
Documents, uploads, and inline notes move with the record.
Why teams make this switch
Leaving
What's pushing teams away
Choosing
What's pulling them in
Object mapping
Each row shows how a web2Project 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.
web2Project
Project
Microsoft Project
Project
1:1web2Project Projects map directly to Microsoft Project Project files (MPP) or Project Online workspaces. The project name, description, color coding, start and finish dates, priority, and status transfer as-is. Project-level custom fields map to Microsoft Project custom fields via the Field Picker. We detect project count during discovery to determine whether the destination is a single MPP deliverable or a SharePoint-connected Project Online workspace with multiple projects.
web2Project
Task
Microsoft Project
Task
1:1web2Project Tasks map to Microsoft Project Tasks with task name, start and finish dates, duration, priority, percent complete, and task notes preserved. Subtask hierarchy (parent-child relationships) transfers as Outline Level and Summary Task structure in Microsoft Project. Milestones in web2Project (tasks with zero duration) become Microsoft Project milestone tasks. Task-level custom fields map to corresponding Microsoft Project custom fields.
web2Project
Task Dependency
Microsoft Project
Predecessor / Successor Link
1:1web2Project inter-task dependencies map to Microsoft Project predecessor-successor links. We translate Finish-to-Start (the standard web2Project dependency type) to Microsoft Project FS predecessor links. Start-to-Start and Finish-to-Finish dependencies map to SS and FF predecessor types respectively. Lead and Lag time values transfer as the Lag field in Microsoft Project. Circular dependency detection in web2Project is flagged and escalated during discovery so it does not block import.
web2Project
User
Microsoft Project
Resource
1:1web2Project Users map to Microsoft Project Resources. We extract the user display name, email address, and role assignment. Resource type is set to Material or Work depending on whether the user represents a person or a consumable resource. Active/inactive status maps to Resource's active flag. Role names from web2Project transfer as Resource Notes for capacity planning reference. Capacity, calendar, and cost rate fields require manual configuration in Microsoft Project and are flagged in the handoff document.
web2Project
Company
Microsoft Project
Project Summary Task or Custom Field
lossyweb2Project Companies are organizational entities with projects assigned to them. Microsoft Project does not have a native Company or Account object. We map Companies as Project-level custom text fields (e.g., Client) on each project, or as a Summary Task named after the company at the top of the project outline. The customer chooses the preferred representation during scoping. If multiple projects map to the same company, the organization may prefer a SharePoint list or Project Online Enterprise Resource Pool entry for cross-project reference.
web2Project
Department
Microsoft Project
Resource Group or Custom Field
lossyweb2Project Departments are sub-organizational units within Companies. Microsoft Project Resources support a Group field that maps to organizational groupings. We map Departments to the Resource Group field on the corresponding resources, which enables filtering and grouping in Microsoft Project resource views. The alternative is a Project-level custom field if the organization prefers department-level reporting at the project rather than resource level.
web2Project
Custom Field
Microsoft Project
Custom Field (Field Picker)
lossyweb2Project v2.4 custom fields (text, number, date, dropdown, checkbox) map to Microsoft Project custom fields using the Field Picker. Note that Microsoft Project Plan 3 and Project Desktop support up to 10 custom fields per project; Project Plan 1 does not support custom fields at all. We confirm the destination license tier during scoping. If the source has more custom fields than the destination supports, we migrate the highest-priority fields and document the remainder for manual entry. Custom field schema differs between pre-v2.4 and post-v2.4 web2Project instances; we detect the source version during database inspection and adjust extraction logic accordingly.
web2Project
Budget Field
Microsoft Project
Text Custom Field
lossyweb2Project budget fields are explicitly documented as documentation-only with no financial calculation, tracking, or reporting logic. We migrate these values as read-only text custom fields in Microsoft Project. No budget-versus-actual reporting, no cost rollup, and no resource rate integration is implemented because the source values carry no financial calculation context. Any actual budget tracking must be re-implemented in Microsoft Project using cost resources, fixed costs, or a Project Online financial integration.
web2Project
Forum Post
Microsoft Project
Task Note
1:manyweb2Project project-specific forum threads (categories and post content) map to Microsoft Project Task Notes. Each forum post becomes a separate line within the task note, preserving the post author, timestamp, and body text. Forum thread ordering is preserved by sequential numbering within the note. This is an informational mapping only; Microsoft Project does not have a native discussion or collaboration object. The customer should evaluate whether SharePoint task collaboration, Teams channel posts, or Planner comments are more appropriate for ongoing team communication post-migration.
web2Project
File Attachment
Microsoft Project
Hyperlink or SharePoint Reference
1:1web2Project file attachments at the project and task level store file metadata (filename, upload date, uploader) and a reference to the file location. We migrate file metadata as a Microsoft Project Hyperlink on the relevant task, pointing to the original file path or a SharePoint document library URL. Actual file content transfer (moving binary files from web2Project's upload directory to the destination SharePoint site or file server) is a separate file transfer step coordinated alongside the database migration. We flag this step explicitly in the handoff document because it is not covered by database-to-API migration logic.
web2Project
Calendar / Event
Microsoft Project
Task with Date Fields
1:1web2Project calendar events with iCalendar export support map to Microsoft Project Tasks with Start and Finish dates. The event title becomes the task name and the event description becomes the task note. Recurrence patterns in web2Project calendar events do not transfer; recurring events are migrated as individual tasks and flagged for manual recurrence setup in Microsoft Project. Microsoft Project's base calendar (Standard, Night Shift, or custom) can be configured to reflect the organization's working days if the web2Project calendar had non-standard working hours.
| web2Project | Microsoft Project | Compatibility | |
|---|---|---|---|
| Project | Project1:1 | Fully supported | |
| Task | Task1:1 | Fully supported | |
| Task Dependency | Predecessor / Successor Link1:1 | Fully supported | |
| User | Resource1:1 | Fully supported | |
| Company | Project Summary Task or Custom Fieldlossy | Fully supported | |
| Department | Resource Group or Custom Fieldlossy | Fully supported | |
| Custom Field | Custom Field (Field Picker)lossy | Fully supported | |
| Budget Field | Text Custom Fieldlossy | Fully supported | |
| Forum Post | Task Note1:many | Fully supported | |
| File Attachment | Hyperlink or SharePoint Reference1:1 | Fully supported | |
| Calendar / Event | Task with Date Fields1:1 | Fully supported |
Gotchas + challenges
Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.
web2Project gotchas
No production API means direct database access is required for migration
Budget fields are documentation-only with no financial logic
Custom field format changed significantly in v2.4
Project Importer module has limited import scope
Timezone handling in user logs was rebuilt in v2.4
Microsoft Project gotchas
Project for the web is being retired and merged into Microsoft Planner
Planner-tier portfolio features are incomplete despite Plan 5 labeling
Web app constraint controls are weaker than the Windows desktop client
Project requires a separate license not bundled with standard Microsoft 365
Project Online API is edition-gated and inconsistently documented
Pair-specific challenges
Migration approach
Discovery and database connectivity
We connect to the web2Project MySQL database directly to audit the source schema. We detect the web2Project version (pre- or post-v2.4) to determine the custom field extraction logic, enumerate all Projects, Tasks, Task Dependencies, Users, Companies, Departments, Custom Field definitions, Budget values, Forum structures, and File attachment references, and identify any community-added modules extending the standard schema. We also inventory the file attachment repository location. If direct database access is unavailable, we fall back to the built-in Project Importer module with a scoped migration that excludes Users, Companies, Departments, and custom fields. The discovery output is a written scope document with record counts and a database access confirmation.
Schema design and custom field mapping
We design the destination Microsoft Project schema in a Sandbox or test environment. For each web2Project custom field, we define the corresponding Microsoft Project custom field type (Text, Number, Date, Flag, or Outline Code). We confirm the destination license tier because Project Plan 1 does not support custom fields and Plan 3 and Desktop are limited to 10 per project. If the source exceeds this, we prioritize fields used in active projects and document the remainder. We design the resource structure by mapping web2Project Users to Microsoft Project Resources, apply the Department-to-Resource Group mapping, and define any Company-to-Project custom field mappings.
Data extraction and transformation
We extract all identified records from the web2Project MySQL database in dependency order: Users first (for resource resolution), then Companies and Departments, then Projects and Tasks with hierarchy, then Task Dependencies, then Custom Field values, then Budget values, then Forum posts, then File attachment metadata, then Calendar events. All timestamps are normalized to UTC during extraction. For pre-v2.4 instances, we apply the timezone-aware extraction logic to account for server-local timezone storage in activity logs. The extracted data is staged in an intermediate transformation layer where we apply the custom field type mappings, dependency graph validation, circular dependency removal, and outline level computation before generating the target project plan.
Test import and validation
We import the transformed data into a test Microsoft Project file or a Project Online sandbox workspace and validate the resulting schedule. Validation checks include: task hierarchy matches the web2Project WBS outline, all predecessor links resolve to existing tasks, start and finish dates match the web2Project source values within one business day, resource assignments resolve to named resources, custom field values are present and correctly typed, and forum post content appears in task notes in correct order. We generate a row-count reconciliation report and a sample record comparison against the source. The customer's project manager reviews the test import and signs off before production migration begins.
Production migration and cutover
We run the production migration into the confirmed destination environment. If the destination is Microsoft Project Desktop, we deliver a validated MPP file per project. If the destination is Project Online, we publish to the PWA workspace via the SharePoint REST API. The migration runs in record-dependency order: Resources first, then Projects and Tasks, then Dependencies, then Custom Fields, then Budget values, then Forum notes, then File hyperlinks, then Calendar tasks. Each phase emits a reconciliation count. During cutover, we freeze writes to web2Project, run a final delta extraction for any records modified during the migration window, and enable the destination as the system of record.
Handoff and archive planning
We deliver the production project plan(s), a written inventory of migrated objects with record counts, a mapping audit log of every field transformation, a list of any records skipped or truncated with reasons, and a file transfer manifest for the attachment repository. We document the budget field status (read-only text, no financial logic), the custom field limitation if the source exceeded the 10-field destination cap, and the forum-to-notes conversion for the customer's review. We provide a two-week post-migration support window for reconciliation questions. We do not rebuild web2Project custom modules, PHP workflows, or forum structures in Microsoft Project; these are documented for the customer's admin to re-implement using Microsoft-native tools.
Platform deep dives
web2Project
Source
Strengths
Weaknesses
Microsoft Project
Destination
Strengths
Weaknesses
Complexity grading
Standard Project Management migration. 1 of 8 objects need a mapping; the rest are 1:1.
Overall complexity
Standard migration
Derived from compatibility, mapping clarity, API constraints, and data volume across web2Project and Microsoft Project.
Object compatibility
1 of 8 objects need a mapping; the rest are 1:1.
Field mapping clarity
Field mapping is derived from defaults — final spec confirmed during the sample migration.
Timeline complexity
8-object category — typical timelines run 2–7 days end-to-end.
API constraints
web2Project: Not applicable — self-hosted; constrained by the customer's Apache/MySQL/PHP stack..
Data volume sensitivity
web2Project exposes a bulk API — large-volume migrations stream efficiently.
Estimator
Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.
Step 1
Pick a category, then your source and destination platforms.
Category
FAQ
Answers to the questions buyers ask most during web2Project to Microsoft Project migration scoping. Not seeing yours? Book a call.
Walk through your web2Project to Microsoft Project migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave web2Project
Other ways to arrive at Microsoft Project
Same-Project Management migrations
Ready when you are
Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.