Import Data Migration Order Sequence

How To Verify Your Migration Data Before Importing Into ZenCase

Christine Clark avatar
Written by Christine Clark
Updated over a week ago

Overview

When importing your data from one system to another, it is best to import the data into ZenCase in a specific order sequence to ensure that dependent items exists before importing items associated to them.

Import Order Sequence

Step 1: Firm Defaults

  1. Locations

  2. Divisions

  3. Abbreviations

  4. Relationship Roles

  5. Matter Types

  6. Billing Cycles

  7. Billing Types

  8. Document Types

  9. Member Types

  10. Task Types

  11. Payment Methods

  12. Invoice Terms

  13. Vendors

  14. Tags

  15. Custom Fields/Values

Step 2: Case Information

  1. Import Members

    1. Note: Members that are imported will NOT receive a welcome email. You can send members emails after data migration using a bulk action to "Resend Invitations" from the Firm Settings > Members page.

  2. Import Contacts

  3. Import Matters

  4. Import Tasks

  5. Import Contact Connections

  6. Import Contact Rate Assignments

  7. Import Contact Memos

  8. Import Contact Custom Fields

    1. Custom Fields must be created in Firm Settings before you can import for a contact

  9. Import Matter Connections

  10. Import Matter Rate Assignments

  11. Import Matter Roles

  12. Import Matter Memos

  13. Import Matter Custom Fields

    1. Custom Fields must be created in Firm Settings before you can import for a matter

  14. Import Matter Custom Records

    1. Currently has to be done for each Custom Record table, but multiple matters is supported

    2. Custom Record tables must be created in Firm Settings before you can import for a matter

  15. Import Task Memos

  16. Import Task Custom Fields

    1. Custom Fields must be created in Firm Settings before you can import for a task

Step 3: Billing

  1. Import Legacy Billing

    1. A/R

    2. Fees

    3. Expenses

    4. Invoices

    5. Payments

    6. Credit Memos

    7. Trust Transactions

  2. Import Client Ledger Entries

  3. Import Matter Ledger Entries

  4. Import Invoices (MUST COME BEFORE TIME AND EXPENSES)

  5. Import Unbilled Time Entries

    1. Note: In Firm Settings, set "Round time entries up to next 1 minute increment" to 1 minute. This must be done BEFORE importing time entries.

    2. This will prevent time entries from rounding and be accurate during import

    3. When importing charges, set matters ledes_enabled = true and require_ledes_codes = false during import so there are no failures for Ledes activity code can't be blank, Ledes task code can't be blank

  6. Import Unbilled Fixed Fees

  7. Import Unbilled Expenses

  8. Import Billed Time Entries

  9. Import Billed Fixed Fees

  10. Import Billed Expenses

  11. Import Trust Transactions

  12. Import Payments

  13. Import Payment Allocations

    1. This is a long process, so it should be last step in import process

Let us know if you have any questions!

Did this answer your question?