Project Management migration
Field-level mapping, validation, and rollback between Edison 365 and Asana. We move data and schema; workflows are rebuilt natively in Asana.
Edison 365
Source
Asana
Destination
Compatibility
7 of 12
objects map 1:1 between Edison 365 and Asana.
Complexity
BStandard
Timeline
3-5 weeks
Overview
Moving from Edison 365 to Asana is a shift from a full-lifecycle portfolio management platform to a task-centric work management platform. Edison 365 covers idea intake, business case approval, project delivery, resource allocation, and portfolio-level KPI rollup in one Microsoft-integrated system. Asana organizes work as Projects and Tasks with optional Portfolios, custom fields, and workload management, but it has no native resource capacity model, no business case entity, and no built-in idea intake pipeline. We extract Edison 365's structured record types (Ideas, Projects, Business Cases, Resources, Benefits) and map them to Asana Projects with Sections, Tasks, and custom fields. Edison 365's SharePoint-stored documents cannot be linked through the export; we migrate them to a destination document store and recreate links in Asana as task attachments or linked references. We do not migrate Power BI reports, stage-gate workflow configurations, or portfolio rollup calculations as code; we deliver a written inventory of these for the customer's admin to rebuild in Asana's reporting and portfolio views.
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 Edison 365 object lands in Asana, including any object-level transformations, lookup resolution, or schema-design dependencies.
Typical mapping — final map is confirmed during the sample migration step.
Edison 365
Idea
Asana
Project (as intake container)
1:1Edison 365 Ideas map to Asana Projects in a dedicated 'Idea Intake' Team. The Idea title becomes the Project name, description migrates as the Project description, category maps to a custom field (Idea Category), submitter maps to an Asana member, and Edison 365 Pipeline stage maps to an Asana custom field (Idea Stage). We preserve the original submission date as a custom date field. Edison 365's workflow-based Idea pipeline (e.g. Submission > Screening > Evaluation > Approval) does not migrate as a workflow; it is stored as the Idea Stage custom field for the admin to model in Asana as a dropdown.
Edison 365
Project
Asana
Project
1:1Edison 365 Project records map directly to Asana Projects. Project name, description, owner, start date, end date, and budget migrate as standard and custom fields. Edison 365's stage value (e.g. Planning, In Progress, On Hold, Completed) maps to an Asana custom field (Project Stage). We resolve the Edison 365 owner by email match to an Asana member. Project-level custom fields migrate to Asana custom fields of matching type (text, number, date, dropdown).
Edison 365
Project Task
Asana
Task
1:1Work breakdown items within Edison 365 Projects map to Asana Tasks. Task name, description, assignee, start date, due date, and status migrate directly. Edison 365 subtasks map to Asana subtasks. Task-level custom fields migrate to Asana task-level custom fields. We resolve assignees by email match and flag any Edison 365 task with multiple assignees (Edison 365 supports multi-assignee) for the customer to decide on Asana's single-assignee approach per task.
Edison 365
Business Case
Asana
Project (custom field container)
1:manyEdison 365 Business Case records merge into the Asana Project that represents the initiative they support. We create a Business Case section in the Asana Project's custom fields capturing cost estimates, benefit values, approval status, and financial notes as custom fields. Edison 365 custom financial fields on Business Cases map to Asana custom number fields. Approval history migrates as a custom text field. If a single Business Case supports multiple Edison 365 Projects, we create one Asana Project per source Business Case and note the cross-link in a custom text field.
Edison 365
Benefit
Asana
Custom Fields on Project
lossyEdison 365 Benefit records are entity-specific (attached to individual Business Cases or Projects) rather than globally reusable. We extract each Benefit record and create corresponding custom number or currency fields on the parent Asana Project (e.g. 'Benefit: Cost Savings', 'Benefit: Revenue Impact', 'Benefit: ROI %'). Benefit types stored as Edison 365 custom fields become Asana dropdown custom fields. Since Edison 365 stores duplicate benefit instances when the same metric is used across multiple Business Cases, we preserve each instance as a separate field on its respective Asana Project rather than attempting a global rollup that does not exist in the source.
Edison 365
Resource
Asana
Task Assignee + Custom Fields
1:1Edison 365 Resource records represent people assigned to Projects or Portfolios with allocation percentages and date ranges. We map each Resource assignment to an Asana Task (or Project membership if the customer uses Asana Business with Portfolio assignments) with the assignee resolved by email match, start date and end date preserved as custom fields, and allocation percentage stored as a custom number field. Edison 365's portfolio-level resource allocations (allocations scoped to the Portfolio rather than a single Project) require the customer to designate a specific Asana Project or Portfolio for each resource rollup since Asana's workload feature does not support cross-project capacity aggregation.
Edison 365
Portfolio
Asana
Portfolio
1:1Edison 365 Portfolios aggregate multiple Projects and display portfolio health, KPIs, and budget rollup. We migrate Portfolios as Asana Portfolios (Business tier required, $24.99/user/mo). Each Edison 365 Portfolio maps to an Asana Portfolio with the same name. The child Projects are added to the Portfolio membership. Edison 365 portfolio-level KPI values (total cost, total benefit, portfolio status) are stored as custom fields on a designated 'Portfolio Summary' Project within the Portfolio so that rollup calculations are visible. Live portfolio rollup calculations do not carry over because Asana calculates Portfolio health from the underlying Project data, not from pre-computed Edison 365 totals.
Edison 365
Custom Fields (Ideas, Projects, Business Cases)
Asana
Custom Fields (Projects, Tasks)
lossyEdison 365 stores custom field definitions per entity type without a consolidated schema export. We enumerate custom fields for each entity type (Ideas, Projects, Business Cases) separately during discovery. The resulting schema is pre-built in Asana before migration using Asana's field library for global fields or project-local fields depending on the customer's reuse requirements. Dropdown options in Edison 365 custom fields become Asana dropdown option sets. Number and currency fields migrate with type preserved.
Edison 365
Pipeline Stage
Asana
Custom Field (dropdown)
lossyEdison 365 Pipelines have configurable stage names and transition rules per workflow. We extract the stage names and order from the Edison 365 workflow configuration and create corresponding Asana custom dropdown fields (one per Edison 365 Pipeline). The customer chooses whether to apply the stages as Project-level or Task-level custom fields. Stage transition rules do not migrate as workflow logic; we document them in the handoff inventory for the admin to model in Asana's task status options or a dedicated stage field.
Edison 365
User / Assignee
Asana
Member
1:1Edison 365 User records (display name, email, role, department) map to Asana workspace members. We match by email. Any Edison 365 User referenced as a Project owner, Resource assignee, or Idea submitter who does not yet have an Asana account is placed in a reconciliation queue for the customer's admin to provision before that phase of migration begins. Inactive Edison 365 users are included as inactive Asana members and flagged for deactivation review.
Edison 365
Document / Attachment
Asana
Attachment (file migration required)
1:1Edison 365 stores documents as SharePoint URLs, not embedded files. We export the full document inventory (file name, URL, associated record) and perform a parallel file-level transfer to a destination store (Asana Direct Attachments, Google Drive, Dropbox, Box, or the customer's destination SharePoint). We recreate links in Asana as file attachments or as URL attachments pointing to the new file location. This is a separate migration track from the record migration and is scoped and priced independently. No Edison 365 SharePoint URL will remain valid after the source tenant is decommissioned.
Edison 365
Stage History (Pipeline progress)
Asana
Custom Fields (date and text)
lossyEdison 365 tracks the timestamp and user who moved a Pipeline stage. We store this as a custom text field on the Asana Project (e.g. 'Stage History: Screening moved to Approved by J.Smith on 2025-09-14'). The full stage history is preserved for audit purposes even though Asana does not have a native stage history audit trail. We capture the most recent stage entry as the current status and document older entries in the handoff notes.
| Edison 365 | Asana | Compatibility | |
|---|---|---|---|
| Idea | Project (as intake container)1:1 | Fully supported | |
| Project | Project1:1 | Fully supported | |
| Project Task | Task1:1 | Fully supported | |
| Business Case | Project (custom field container)1:many | Fully supported | |
| Benefit | Custom Fields on Projectlossy | Fully supported | |
| Resource | Task Assignee + Custom Fields1:1 | Fully supported | |
| Portfolio | Portfolio1:1 | Fully supported | |
| Custom Fields (Ideas, Projects, Business Cases) | Custom Fields (Projects, Tasks)lossy | Fully supported | |
| Pipeline Stage | Custom Field (dropdown)lossy | Fully supported | |
| User / Assignee | Member1:1 | Fully supported | |
| Document / Attachment | Attachment (file migration required)1:1 | Fully supported | |
| Stage History (Pipeline progress) | Custom Fields (date and text)lossy | 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.
Edison 365 gotchas
Power BI is the default reporting engine
Custom fields have no unified schema export
SharePoint document linkage breaks on export
Benefits tracking is entity-specific not global
Asana gotchas
Automation rules have no export representation
API rate limits cap bulk migration throughput
Portfolios are view-only objects that do not hold data
Custom field enum options cannot be updated via API
Subtasks do not appear in project views by default
Pair-specific challenges
Migration approach
Discovery and custom field enumeration
We audit Edison 365 across all entity types: Ideas, Projects, Business Cases, Resources, Portfolios, Pipeline configurations, and custom fields. Because Edison 365 lacks a consolidated custom field export, we query the API separately for each entity type to capture the full field schema. We audit SharePoint document libraries linked to Edison 365 records and enumerate the file inventory. We document every active Pipeline stage and transition rule. We identify the Edison 365 edition tier and any Power BI report dependencies. The discovery output is a written migration scope with record counts per entity, a complete custom field schema, a document inventory, and an initial object mapping for the customer's approval.
Schema design in Asana
We design the Asana destination schema based on the discovered object map. We create Projects for each Edison 365 Idea and Project, apply the relevant custom field definitions, configure Portfolio membership for Edison 365 Portfolios, and set up Teams to reflect Edison 365 organizational groupings. For Edison 365 Business Cases, we designate a parent Project per Business Case and create the financial and benefit custom fields on that Project. We create Asana custom fields for all Edison 365 custom field types (text, number, date, dropdown) before any data import. We pre-build the document destination (direct Asana attachments or a linked file store) and confirm access credentials.
Document file migration
We run the SharePoint document migration in parallel with record preparation. We download files from the source SharePoint libraries, re-upload to the destination file store (Asana direct attachments, Google Drive, Dropbox, Box, or destination SharePoint), and generate the new attachment URLs. We cross-reference the document inventory against Edison 365 record IDs so that each file can be attached to the correct Asana Project or Task after record migration completes. This track is completed before cutover so that every record arrives in Asana with its attachments intact.
Sandbox migration and reconciliation
We run a full migration into an Asana Sandbox workspace (or a dedicated test Project structure) using production data volumes. The customer's project management lead reviews record counts, spot-checks 25-50 records for field-level accuracy, and confirms that custom field mapping matches expectations. We specifically validate that Edison 365 Pipeline stages map to the correct Asana custom field dropdown values, that Business Case financial fields land as number values (not text), and that Resource allocation percentages appear on the correct tasks. Any mapping corrections are made before production migration begins.
Owner and member provisioning
We extract every distinct Edison 365 owner, assignee, and Resource referenced across all entity types and match by email against the Asana destination workspace. Users without an existing Asana account are placed in a reconciliation queue. The customer's admin provisions the missing Asana accounts and confirms their email addresses before record import resumes. Migration cannot proceed past the import phase because assignee and owner references must resolve at insert time.
Production migration in dependency order
We run production migration in record-dependency order: Asana members (provisioned and validated), Portfolio-level Projects (if any standalone Portfolio containers exist), Edison 365 Ideas as Asana Projects, Edison 365 Projects as Asana Projects, Business Cases as Projects with financial custom fields, Tasks with assignees resolved, custom field values on Projects and Tasks, Resource allocation custom fields on tasks, Portfolio membership populated from Edison 365 Portfolios, document attachments linked to the new file store URLs. Each phase emits a row-count reconciliation report before the next phase begins.
Cutover, validation, and handoff inventory delivery
We freeze Edison 365 write access during cutover, run a final delta migration of any records modified during the cutover window, then enable Asana as the system of record. We deliver the workflow inventory (Edison 365 Pipeline stage transitions and approval gates documented with Asana Rules recommendations), the report inventory (Power BI reports listed with Asana native reporting approximations or external BI tool suggestions), and the custom field schema as-built. We support a five-business-day hypercare window for reconciliation issues. We do not rebuild Edison 365 stage-gate workflows as Asana Rules or Power BI reports as Asana dashboards; these are documented for the customer's admin to implement as a separate workstream.
Platform deep dives
Edison 365
Source
Strengths
Weaknesses
Asana
Destination
Strengths
Weaknesses
Complexity grading
Standard Project Management migration. 2 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 Edison 365 and Asana.
Object compatibility
2 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
Edison 365: Governed by Azure API Management policies — not publicly published..
Data volume sensitivity
Edison 365 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 Edison 365 to Asana migration scoping. Not seeing yours? Book a call.
Walk through your Edison 365 to Asana migration with a real engineer — 30 minutes, free, written quote within 24 hours.
Book a free 30 minute consultationAdjacent paths
Other ways to leave Edison 365
Other ways to arrive at Asana
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.