Records and housing

Import colony records

Bring in a spreadsheet or supported program export, check the preview and save the intended records.

Before you start

  • Keep a copy of the source file. Use Excel or CSV with headings that identify the columns. In a core facility, ask facility staff to import the file if you do not have import access.
Import preview shows three animals, two cages, three genotype calls and one line ready to add.
Check the totals and each animal preview before choosing Import. Nothing in this preview has been saved yet.

Screenshot

  1. Step 1: Choose the file and record type

    Open Import, choose Colony records and select the file. The importer recognizes supported JCMS, SoftMouse.NET, mLIMS and Moustra exports as well as ordinary spreadsheets. Check which sheets contain animals, cages, lines, breeding pairs, litters or genotypes.

    When photo and PDF reading is available for your account, you can upload cage-card photos or a PDF colony sheet. Inspect the extracted rows before continuing. If AI is off, use an Excel or CSV file.

  2. Step 2: Check the columns and options

    Compare each source column with its mapped field. Use the sample values to check IDs, dates, sex, line, cage and protocol. Leave irrelevant columns unmapped. Choose Next: options when the mapping is correct.

    Set the date format, duplicate handling and any default line, cage or protocol. Use Use ear tags as IDs for this import when that file's ear tags are the identifiers you want to keep. This choice applies to the current import.

  3. Step 3: Check the preview

    Choose Check and preview. Review the records to be added or updated and resolve the rows the importer cannot match. Check a few source rows against the preview, including any animal that has left the colony.

    If a referenced protocol is missing, use Add protocol when available, save it in the new tab, then return and choose Check again. The current file stays loaded.

  4. Step 4: Import and inspect the saved records

    Choose Import with the displayed record count. Read Import complete for the numbers added and updated. Open View animals or, for a cage-only import, View cages. Check identifiers, housing and a few genotype or protocol details against the source file.

Check the result

The checked rows become colony records, and the import summary tells you exactly how many records were added or updated.

Undo an import entered in error

Within 24 hours, use Undo import on the completion screen, or reopen Import and use Undo beside the file under Recent imports. Confirm, then read what was removed, restored or kept. Records changed after the import stay as they are.