ATS & HRMS migration checklist

Migration Checklist: Moving to Crelate

An eight-phase, task-by-task punch list for moving candidates, contacts, companies, jobs, placements, activities, and resume files into Crelate Recruit or Crelate Hire.

116 tasks 4–12 weeks typical Updated May 27, 2026
Crelate
Employees
Compensation
Benefits
Time Off
Org Structure
Performance
0 of 116 tasks complete

Phase 0

Decide & Plan

Lock scope, edition, and constraints before any export job runs.

  • Risk if skipped: Selecting the wrong edition forces a re-platform mid-project because the Job Order, Submission, and Placement objects only exist in Recruit.

  • Risk if skipped: Mid-project scope additions force re-running mapping, sandbox tests, and workflow design from the start.

  • Risk if skipped: Without an explicit cut-off the export expands into a multi-year activity dump that no one budgeted for transforming.

  • Risk if skipped: Legal blocks the import on go-live day when retention or candidate-consent review was not completed earlier.

  • Risk if skipped: A cutover during an active interview week strands in-flight scheduling threads between two systems with no reconciliation path.

Phase 1

Pre-Migration Prep

Source-system cleansing and Crelate tenant configuration before any export.

1a. Source-system audit and cleansing

  • Risk if skipped: Duplicate source rows merge into a single Talent record and historical activity rows attach to the wrong person.

  • Risk if skipped: Two source companies for the same client create two Crelate Companies and split the placement history.

  • Risk if skipped: Rows missing required fields fail silently on Import Data+ and skew the validation row counts at the end.

  • Risk if skipped: Orphaned attachment references trigger thousands of import errors that mask real failures.

  • Risk if skipped: Without a baseline, no one can prove whether the migration lost records.

  • Risk if skipped: Without an External Primary Key, every re-run of an import wizard creates duplicate Crelate records.

1b. Crelate tenant configuration

  • Risk if skipped: Loading activity timestamps before fixing the org timezone shifts every activity by hours and is painful to correct.

  • Risk if skipped: Importing records with owner references to users that do not yet exist forces the owner to fall back to the migration service account.

  • Risk if skipped: Importing a picklist value that does not exist drops the value silently or rejects the row.

  • Risk if skipped: Loading data into a custom field that does not exist drops the values entirely.

  • Risk if skipped: Source pipelines with 25–30 stages collapse unpredictably if the consolidation strategy is decided on import day.

  • Risk if skipped: A test load with sync enabled fires hundreds of real interview invites to candidates.

  • Risk if skipped: Testing in production pollutes the live tenant and forces a bulk-delete cleanup before go-live.

1c. People prep

  • Risk if skipped: Late edits in the source after the export create a silent delta that will never reach Crelate.

Phase 2

Source Export

  • Risk if skipped: A missed custom field surfaces in Phase 6 when a recruiter cannot find the data they relied on.

  • Risk if skipped: Placements rebuilt without the original fee and start-date columns break commission reporting.

  • Risk if skipped: Without stage-transition timestamps the time-to-hire reports in Crelate restart from cutover.

  • Risk if skipped: Pulling binaries without the metadata index makes it impossible to re-attach files to the right Talent record.

  • Risk if skipped: EEOC fields exported into the main candidate CSV bypass access controls and create a compliance incident.

Phase 3

Transform & Map

Map every source field to Crelate, decide ATS-specific transforms, and produce destination-shaped files.

3a. Master mapping spreadsheet

  • Risk if skipped: Without a centralized mapping document, each engineer interprets ambiguous fields differently and the data lands inconsistently.

  • Risk if skipped: Unmapped picklist values silently drop on import or fall back to the destination default.

  • Risk if skipped: Re-running an import without an External Primary Key set duplicates every record.

3b. Data transformation

  • Risk if skipped: Mixed date formats cause silent month/day swaps that are not discovered until reports run.

  • Risk if skipped: Non-UTF-8 encoded names import as garbled characters and require row-level cleanup post-cutover.

  • Risk if skipped: A single mis-quoted row shifts every subsequent column for thousands of rows.

  • Risk if skipped: Formatted cells cause the entire upload to reject with a generic error.

3c. Relationship and audit-trail decisions

  • Risk if skipped: Without a custom date field, every record's true created-on is lost and reports look like all data is brand new.

  • Risk if skipped: Without an Original Owner backup field, recruiters lose visibility into who handled the candidate previously.

  • Risk if skipped: Routing pre-parsed resumes through the parsing wizard re-parses already-clean data and overwrites fields with parser output.

3d. ATS-specific transforms

  • Risk if skipped: Mixing parser-driven and parser-disabled loads on the same Talent batch overwrites mapped fields with re-parsed values and silently corrupts clean source data.

  • Risk if skipped: Skipping the 20-stage planning step forces a last-minute stage collapse that destroys time-in-stage reporting.

  • Risk if skipped: Pushing free-text source values straight into the Source picklist creates dozens of one-off picklist entries that the Past Activity filter cannot meaningfully query.

  • Risk if skipped: Loading EEOC values into open custom fields exposes self-identification data to every Crelate user and creates a compliance incident.

  • Risk if skipped: Dropping unmappable scorecard answers loses the interview-decision audit trail and forces hiring teams to relitigate prior decisions.

  • Risk if skipped: Bulk-loading current stages without replaying transitions strips the Past Activity filter of any candidate history and breaks time-to-hire reporting from day one.

Phase 4

Sandbox Test Migration

Catch every problem in the test tenant before production.

  • Risk if skipped: Skipping the manual spot-check lets a systematic mapping error reach production undetected.

  • Risk if skipped: If lookups resolve by Crelate ID rather than External Primary Key, every production run will mis-link records.

  • Risk if skipped: If the parser flag is wrong, a production run will overwrite clean field data with re-parsed text from the resume.

  • Risk if skipped: Past Activity filter blindness post-cutover destroys nurture and re-engagement workflows.

  • Risk if skipped: Discovering on cutover night that the load will take 18 hours instead of 4 forces an emergency reschedule.

  • Risk if skipped: Proceeding to production without sign-off transfers risk to whoever runs the cutover at 2am.

Phase 5

Production Cutover

The tightly-sequenced execution window.

  • Risk if skipped: Late writes after the export create a silent delta that never reaches Crelate.

  • Risk if skipped: Enabled integrations on import day blast hundreds of duplicate interview invites to candidates.

  • Risk if skipped: Loading Jobs before their parent Companies forces re-parenting cleanup and leaves orphans.

  • Risk if skipped: A re-run without the External Primary Key set creates a second copy of every record.

  • Risk if skipped: Pushing through despite an unexplained delta hides a systematic loss until validation.

  • Risk if skipped: Pushing through with partial data forces a Bulk Operations rollback that may not catch every malformed row.

  • Risk if skipped: Leaving the source writable invites a recruiter to update a record there and forget to repeat the change in Crelate.

Phase 6

Validate

Prove the migration was correct before any user works in production.

6a. Reconciliation

  • Risk if skipped: An unexplained delta on Talent count usually masks a duplicate-merge bug or a silently dropped picklist value.

  • Risk if skipped: Sample-based validation catches systematic mapping errors that aggregate counts miss.

6b. Relationship validation

  • Risk if skipped: Mis-linked candidate-on-job records show up to recruiters as 'where did this candidate go?' on day one.

  • Risk if skipped: Activities attached to the wrong record produce confusing recruiter experiences and false 'last-contacted' dates.

  • Risk if skipped: Placement-mapping errors silently distort commission and revenue reports for months.

6c. Audit and compliance

  • Risk if skipped: If the original timestamps did not land, the Past Activity filter cannot date-range historical engagement.

  • Risk if skipped: EEOC visibility leaks are a regulator-reportable incident in many jurisdictions.

6d. Recruiter and stakeholder acceptance

  • Risk if skipped: Skipping power-user validation lets day-to-day workflow gaps surface post-launch when there is no time to fix them.

6e. Sign-off

Phase 7

Post-Migration Cleanup

  • Risk if skipped: Re-enabling an untested template can fire a malformed email to thousands of candidates.

  • Risk if skipped: Without an archived source dump, a later forensic question (e.g. 'what did this candidate's record look like in 2024?') is unanswerable.

Watch list

Risks to track throughout

These risks live across multiple phases — keep an eye on them from kickoff through cutover.

  • 20-Stage Workflow cap drives irreversible pipeline collapse

    Crelate caps Workflow Stages at 20 per workflow. Source ATS pipelines frequently exceed that, and the collapse decisions affect time-in-stage reporting, candidate-stage history, and recruiter muscle memory. Track stage-mapping decisions from Phase 0 through Phase 5 and confirm the collapse is approved by recruiting leadership before the production stage replay runs.

  • Resume-parser double-processing corrupts already-clean data

    Crelate's bulk Importing Resumes wizard parses every file by default. Routing pre-cleaned source data through the parser overwrites mapped Talent fields with re-parsed text. Track the parser-enabled vs. parser-disabled routing decision from Phase 3 transformations through every sandbox and production load to keep clean data clean.

  • External Primary Key discipline determines re-run safety

    Crelate's Import Data+ supports an External Primary Key for idempotent upsert. Without it, every re-run duplicates records and there is no clean rollback path beyond Bulk Operations. Track the External Primary Key value, column name, and saved field map across every object load from Phase 1 baseline through Phase 5 cutover.

  • Activity Stream and Past Activity filter depend on timestamp fidelity

    Crelate re-stamps Created and Modified on import. The Past Activity filter and every time-based candidate-engagement report query the imported timestamps. If the historical-date custom field strategy from Phase 3c is not implemented uniformly, Advanced Search Past Activity returns blank results and the team loses years of candidate history overnight. Track the original-timestamp field on every object from Phase 3 through Phase 6 validation.

Pair this with the long-form guide

The complete Crelate migration guide

Same research, written as prose: data model, import mechanisms, mapping strategy, pitfalls, and partner landscape.