Project Management migration

Migrate from Edison 365 to Asana

Field-level mapping, validation, and rollback between Edison 365 and Asana. We move data and schema; workflows are rebuilt natively in Asana.

Edison 365 logo

Edison 365

Source

Asana

Destination

Asana logo

Compatibility

58%

7 of 12

objects map 1:1 between Edison 365 and Asana.

Complexity

BStandard

Timeline

3-5 weeks

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

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.

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

Edison 365 logo

Edison 365

What's pushing teams away

  • Reporting setup requires Power BI expertise that many in-house teams lack, leading to delays before the platform delivers its promised visibility gains.
  • The out-of-the-box templates can require significant customization to fit non-standard stage gates, causing frustration during initial configuration.
  • Some customers find that the platform's feature depth creates a steeper learning curve for occasional users compared to lighter-weight task tools.
  • Advanced automation and API-driven workflows are available but not always well-documented, which limits adoption for technically savvy teams wanting programmatic control.

Choosing

Asana logo

Asana

What's pulling them in

  • Organizations with distributed teams cite Asana's multiple project views (List, Board, Calendar, Timeline) as the primary reason for adoption, allowing each team member to work in their preferred interface without changing the underlying data.
  • The platform's 100+ native integrations with tools like Slack, Google Drive, Salesforce, and Microsoft Teams reduce context-switching and keep work synchronized across the stack.
  • Small teams and non-profits value the free plan's generous limits: unlimited projects and tasks for up to 15 team members with basic views, enabling teams to validate fit before committing to a paid tier.
  • Marketing and creative teams specifically praise Asana's visual project organization, reporting dashboards, and timeline views for managing cross-functional campaign workflows.
  • Project managers report that Asana's dependency management and workload views help surface bottlenecks before they derail deadlines.

Object mapping

How Edison 365 objects map to Asana

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

maps to

Asana

Project (as intake container)

1:1
Fully supported

Edison 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

maps to

Asana

Project

1:1
Fully supported

Edison 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

maps to

Asana

Task

1:1
Fully supported

Work 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

maps to

Asana

Project (custom field container)

1:many
Fully supported

Edison 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

maps to

Asana

Custom Fields on Project

lossy
Fully supported

Edison 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

maps to

Asana

Task Assignee + Custom Fields

1:1
Fully supported

Edison 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

maps to

Asana

Portfolio

1:1
Fully supported

Edison 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)

maps to

Asana

Custom Fields (Projects, Tasks)

lossy
Fully supported

Edison 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

maps to

Asana

Custom Field (dropdown)

lossy
Fully supported

Edison 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

maps to

Asana

Member

1:1
Fully supported

Edison 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

maps to

Asana

Attachment (file migration required)

1:1
Fully supported

Edison 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)

maps to

Asana

Custom Fields (date and text)

lossy
Fully supported

Edison 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.

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.

Edison 365 logo

Edison 365 gotchas

Medium

Power BI is the default reporting engine

Medium

Custom fields have no unified schema export

High

SharePoint document linkage breaks on export

Low

Benefits tracking is entity-specific not global

Asana logo

Asana gotchas

High

Automation rules have no export representation

High

API rate limits cap bulk migration throughput

Medium

Portfolios are view-only objects that do not hold data

Medium

Custom field enum options cannot be updated via API

Low

Subtasks do not appear in project views by default

Pair-specific challenges

  • SharePoint document links become orphaned after cutover

    Edison 365 attaches documents by storing a SharePoint URL rather than the file content. When we export Edison 365 records, the document field contains a link pointing to the source Microsoft 365 tenant's SharePoint. Those URLs become inaccessible after the source tenant is decommissioned or after the user's SharePoint permissions are revoked. We export the complete document inventory during scoping, perform a parallel file transfer to a destination store (Asana direct attachments, Google Drive, Dropbox, or the customer's destination SharePoint), and recreate the links in Asana as file attachments or URL attachments pointing to the new location. This file migration track runs alongside the record migration and is scoped separately. Skipping this step leaves every record with an attachment referencing a broken link.

  • Custom field enumeration requires multiple API passes

    Edison 365 does not provide a consolidated schema export for custom fields. Each entity type (Ideas, Projects, Business Cases) stores its own custom field definitions independently. We must query the API separately for each entity type to capture the full field inventory. If a customer has more than 20 custom fields across entities, this multi-pass enumeration extends the discovery phase by two to three days. We surface the complete custom field schema in the scoping document for the customer to approve before schema design begins in Asana.

  • Power BI reports do not migrate to Asana reporting

    Edison 365 uses Power BI as its native reporting layer, including live data connections to Edison 365 data. Asana has its own reporting engine with charts, dashboards, and portfolio views, but Power BI reports are not transferable. Any Edison 365 report built in Power BI must be rebuilt in Asana's reporting interface or connected to an external BI tool. We document every Edison 365 report (report name, dataset, filters, visualization types) in the handoff inventory and note whether each report can be approximated in Asana native reporting or requires a separate Power BI project linked to Asana data exports.

  • Resource allocation is not a first-class object in Asana

    Edison 365 Resource records support both project-level and portfolio-level allocation percentages with date ranges and capacity modeling. Asana's workload feature (available on Business and Enterprise tiers) shows a visual heatmap of task assignments per team member but does not function as a capacity planning engine. Portfolio-level resource allocations from Edison 365 require the customer to decide how to distribute portfolio-scoped allocations across the Asana Projects or Portfolios where those resources will be assigned. We preserve allocation percentages as custom fields on the relevant Asana tasks and document the gap in the handoff inventory.

  • Edison 365 stage-gate workflows do not migrate as automation

    Edison 365 Pipelines include configurable stage transition rules (e.g. 'Only advance to Business Case stage if a Benefit value exceeds $50,000'). These transition rules are platform-specific workflow logic and do not have an equivalent in Asana's task model. We document every Edison 365 Pipeline stage, transition condition, and approval gate in the workflow inventory and note that Asana's task status field can replicate the visible stage names, but conditional automation around stage transitions requires Asana Rules (Business and Enterprise) or a third-party automation tool to rebuild.

Migration approach

Six steps for a successful Edison 365 to Asana data migration

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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

Context on both ends of the pair

Edison 365 logo

Edison 365

Source

Strengths

  • Modern, user-friendly interface that encourages broad adoption across idea submitters and project managers.
  • End-to-end coverage from idea intake through project delivery in a single platform.
  • Native Microsoft 365 integration — Azure AD, Teams, SharePoint, and Power BI work without middleware.
  • Configurable Pipelines and stage-gate workflows adapt to non-standard innovation and project processes.
  • Responsive customer support team with G2 praise for human-centric service.

Weaknesses

  • Reporting relies on Power BI — organizations without Power BI expertise may struggle to build dashboards quickly.
  • Out-of-the-box templates require customization for organizations with non-standard stage gates or approval workflows.
  • Advanced API capabilities exist but are not prominently documented, limiting programmatic automation adoption.
  • The feature depth that attracts enterprise buyers can overwhelm occasional users who only interact with one module.
Asana logo

Asana

Destination

Strengths

  • Unlimited projects and tasks on the free plan for teams up to 15 members.
  • 100+ native integrations including Salesforce, Slack, Google Drive, and Microsoft Teams.
  • Four distinct project views (List, Board, Calendar, Timeline) in a single interface.
  • Dependency management with start/end dates and predecessor links for critical path tracking.
  • Portfolio dashboards for executives to track cross-project status and workload.

Weaknesses

  • Per-seat pricing scales expensively: Advanced tier costs nearly double Starter for a 50-seat team.
  • API does not expose all UI-accessible data; some fields require screen-scraping for full fidelity.
  • Automation rule limits on lower tiers are restrictive, causing power users to upgrade or leave.
  • No native document/wiki capability forces teams to use external tools for knowledge management.
  • Rate limits (150 req/min on free, 1,500 req/min on paid) constrain bulk migration throughput.

Complexity grading

How hard is this migration?

Standard Project Management migration. 2 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 Edison 365 and Asana.

  • Object compatibility

    B

    2 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

    Edison 365: Governed by Azure API Management policies — not publicly published..

  • Data volume sensitivity

    A

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

Estimator

Estimate your Edison 365 to Asana 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 Edison 365 to Asana data migrations

Answers to the questions buyers ask most during Edison 365 to Asana migration scoping. Not seeing yours? Book a call.

Can't find your answer?

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 consultation

Most Edison 365 to Asana migrations land between three and five weeks for organizations with fewer than 15,000 total records (Ideas, Projects, Business Cases combined), a straightforward custom field set, and an active document library under 500 files. Migrations with large resource allocation histories, multi-entity custom field sets, SharePoint libraries exceeding 500 files, or complex Business Case financial row structures move to eight to twelve weeks because of multi-pass custom field enumeration, parallel file migration, and the benefit-rollup recalculation work.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Edison 365.
Land in Asana, 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