Skip to main content
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. Matter Subtypes

  7. Billing Cycles

  8. Billing Types

  9. Document Types

  10. Document Subtypes

  11. Jurisdictions

  12. Member Types

  13. Soft Costs

  14. Task Types

  15. Payment Methods

  16. Invoice Terms

  17. Vendors

  18. Tags

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

  6. Import Contact Email Addresses

  7. Import Contact Phone Numbers

  8. Import Contact Connections

  9. Import Contact Role/Rate Assignments

  10. Import Contact Memos

  11. Import Contact Custom Fields

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

  12. Import Matter Connections

  13. Import Matter Role/Rate Assignments

  14. Import Matter Memos

  15. Import Matter Custom Fields

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

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

  17. Import Task Memos

  18. Import Task Custom Fields

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

  19. Task Blueprint Libraries

  20. Task Blueprints

  21. Zen KM Subjects

  22. Zen KM Facts

  23. Zen KM Authorities

  24. Zen KM Questions

  25. Zen KM Answers

  26. Zen KM Connections

  27. Zen KM Documents

  28. Zen KM Relationships

Step 3: Billing

  1. Import Legacy Billing Records

    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?