Moving from JCMS

Bring your JCMS animal records

Import a JCMS mouse-query CSV, check its animals, parents and genotypes, and keep shipped animals out of your live count.

Before you start

  • Keep the original JCMS export and work from a copy.
  • Sign in to the ConductColony lab that should receive the records. Use a blank practice lab if you want to try the fictional sample first.
  • This guide covers an animal-list export. Separate records such as litters and breeding pairs need their own import sheets.

A fictional animal list: 3 animal records, 2 cages, 1 line and 3 genotype results. In an empty lab, the preview offers Import 9 records. One animal is transferred, leaving 2 living animals.

JCMS sample preview shows three animals, two cages, three genotype calls and one line, with Import 9 records.
The fictional JCMS sample adds nine records. Check the statuses and cages in the animal preview before saving.

Screenshot

  1. Step 1: Export a mouse-query CSV

    Export the mouse-query results you want to move as a CSV. Include MouseID, Sex, BirthDate, PenID, Strain and LifeStatus. Keep ExitDate, Origin, Sire, Dam1, Genotype and mouseComment when you want those values carried over.

    Keep the original column names so ConductColony can recognize the list. The sample uses the confirmed JCMS column names with invented records.

  2. Step 2: Upload and check the column matches

    Open Import and upload the CSV. Look for JCMS mouse query recognized. Check that MouseID is Animal ID, PenID is Cage number, Origin is Source and ExitDate is Date left the colony.

    Sire and Dam1 link parents when those animals are in the file or already in your lab. Owner and Dam2 are not assigned automatically; check any unmatched columns before continuing.

    JCMS sample is recognized and its source columns are matched to ConductColony fields.
    Recognized columns are matched for you. Check each match and change any field that needs a different meaning.

    Screenshot

  3. Step 3: Preview the dates and life status

    Choose Next: options, review the import choices, then Check and preview. Check the IDs, dates, cages, line and genotype results before saving.

    JCMS A becomes Alive, S becomes Transferred, K and D become Sacrificed, and M becomes Missing. ExitDate remains the day an animal left the colony; it does not become a death date. Check those outcomes against your source records.

    For the sample, expect 9 records. J-103 should be Transferred, with September 18, 2026 as its exit date and no death date.

  4. Step 4: Import and check the saved records

    When the preview is right, choose Import 9 records for the sample, or the count shown for your own file. Wait for Import complete.

    Open Animals and include all statuses when checking the full list. The sample has J-101, J-102 and J-103, but only the first two are alive. Open J-103 to check its parents, source and genotype. Check the two cage records and the line as well.

What carries over

  • MouseID, Sex and BirthDate keep the animal's ID, sex and birth date; PenID and Strain supply its cage and line.
  • LifeStatus supplies status. ExitDate is kept separately from the death date.
  • Origin becomes Source, and mouseComment becomes Notes.
  • Sire and Dam1 supply parent references. Genotype values such as ExampleGene fl + become an ExampleGene result with fl/+ alleles.

Check the result

The fictional sample adds 9 records, including 3 animals with their genotype results. Two animals are alive; the transferred offspring keeps its parent links and exit date.

Undo an import

Choose Undo import on the completion screen, or return to Import and find the batch in the last 24 hours. Undo removes the records that batch added and restores values it changed when those records can still be put back.

Read the Undo result. Records edited or used since the import may be kept. Correct a copy of your source file, check the preview again, and import only when the result is right.

Export instructions