Friday, January 31, 2014

Updating MosaicService

For customers with Mosaic installed on your own servers with a current software maintenance contract, you will occasionally receive updates to the MosaicService.  This component is responsible for scheduled Notifications, and other services.  Here are the steps:
  • Stop the Mosaic Service
  • COPY your MosaicService directory as a precaution
  • Extract the new MosaicService.zip contents over your existing MosaicService directory
  • Start the Mosaic Service
Additional notes (before re-starting the service):

Make sure to retain a copy of your original vci.config.xml file which resides in your MosaicService directory.  This file is overwritten when you extract the .zip file.  You will need to re-introduce any local modifications made to this file, usually those settings which start with Vci.Mosaic.Email.* which configure email.  Pro tip:  enter XML comments in your version of vci.config.xml that remind you which settings you have modified for your local install.

You do not need to retain contents of the Vci.Mosaic.MosaicSchedulerService.Clients node because you will re-register the web with the service later.

If your Mosaic sandbox does not reside at D:\MosaicSandbox, you will need to modify:
<add key="Vci.Mosaic.Sandbox" value="D:\MosaicSandbox\Service" />
in your MosaicService.exe.config file.  This file is overwritten with new updates, so you’ll need to inspect your original MosaicService.exe.config for the proper value of Vci.Mosaic.Sandbox on your server.

Finally, re-register your Mosaic web with the service:

  • Login as mosaic
  • Visit Administration | Maintenance -> Mosaic Maintenance
  • "Cache and Miscellaneous"tab
  • Press "Register With Scheduler"
  • Visit Administration | Reports -> Event Log to confirm


Tuesday, January 7, 2014

Uploading Genotypes to Mosaic Vivarium

Background

Genotype results frequently are provided in Excel format. Here we describe how to prepare your data for direct upload to Mosaic Vivarium.

Procedure

An example results download from Transnetyx looks like this:

clip_image001

First, eliminate all information except the animal identifier and genotype calls until the spreadsheet looks like this:

clip_image002

If you have fewer than 100,000 animals in Vivarium, you’ll need to format the numbers to include leading zeros. Drag the following formula down:

clip_image003

To get this:

clip_image004

If your Transnetyx download includes hyperlinks, right-click the column header and choose “Remove Hyperlinks”:

clip_image005

Select your formatted values and click Control-C to copy them:

clip_image006

Right-click in cell A1 and choose Paste Values:

clip_image007

Then right-click the column header of the column you created and choose delete:

clip_image008

You are left with the animal identifier column and one or more genotype call columns. Save this as a CSV file:

clip_image009

If you open the saved file with Notepad, you should see:

clip_image010

Now visit Animals | Genotyping:

clip_image011

Press the “Upload Genotypes” button and follow the prompts. Make sure the order of the columns shown matches the order of columns in your CSV file:

clip_image013

Press the Upload button at the top of the grid, follow the prompts.

If you get errors such as the following:

clip_image015

it means that the nomenclature used by your genotyping service does not match the nomenclature you have used in Mosaic Vivarium. Vivarium uses the long name of the genotype call to perform the match. You can either modify the import file, or modify Mosaic Vivarium. Genotype nomenclature must match for the import to work.

If you wish to modify Mosaic Vivarium, visit Administration | Lists -> Lookup Lists and select the Genotypes list. You can edit the long or short names of any genotype in the system. Note: if modifying the central genotype lookup modifies the genotype label for ALL EXISTING animals in the system that use that genotype. Be sure you understand what you are doing before performing this edit.

Once your genotype data file matches your Vivarium genotype nomenclature, the import will work:

clip_image016

clip_image017

For more details specific to Transnetyx, see also Extracting Results from Transnetyx for Upload to Mosaic