skip to content

IT Help and Support

University Information Services
 

In the first instance, the basic information required to create a new Lab in the Tissue Tracking system is:

  • A Lab name
  • A lab short name – commonly the initials of the head of the Lab.
  • An owning Lookup Institution. Eg Pathology (PATH).
  • A list of Raven/crsids of the people who should be able to manage data in the system.

Plan the references

Next you need to plan the references you will use in the system. They are critical to good quality data and distinguishing between different samples and patients.

When considering Tissue Items, the three relevant references available by default are:

  • Patient reference - yours or system generated eg P01234567
  • Item reference – yours or system generated eg T12345678
  • Project reference [optional] – your choice

You might choose an item reference that uniquely identifies your samples with your Lab, or even wider such as your Institution, the University or World.

A common pattern is to use short references that are sequential eg A001, A002. If your reference scheme overlaps with another, you should ensure it is unique when combined with other data such as Patient reference, or Project reference.

Additionally your Tissue Items must have a Location, for which you must specify a reference.

Each of the datatypes a Tissue Item refers to - Patient, Location and Project – have a short code reference and a long name. The list views and list-edit screens show the short name to save screen space. They are also used when looking up reference in the find-as-you-type boxes. An easy to type reference will increase the usability significantly.

Capture12 ref lookup

Getting started with an Import

The software does not yet have a self-service bulk import feature, you will need to ask the UIS to import it for you.

If you have data as a starting point it must be supplied ready to import in a single spreadsheet with a single tab. The overall data format is one Tissue Item per row, with data and references in columns, including Patient, Location, Project and any custom field data. Wait for a sample spreadsheet before starting this process.

Clean your data for import

Spreadsheets are so flexible you can enter any data you like, and to the human eye it is consistent. However, computers are far more picky. It is important that your references are completely consistent or you will end up with duplicate data after import.

The top issues you need to correct:

  • Check use of upper/lowercase. Room A4 and Room a4 would create two different Locations.
  • Check for whitespace differences. The import process will remove leading and trailing whitespace but not in the middle. Multiple spaces between words can cause duplicates.
  • Eliminate or separate out notes. Eg Patient ref P01234567 (2nd visit)
  • Watch for mixed character encodings. If your data creators have mixed Windows and Mac environments, some characters look similar but are different.

Your spreadsheet's Data Auto Filter function can assist with identifying and correcting data issues.

UIS Service Desk

UIS Service Status

Phone padded  Service status line: (01223 7)67999
Website  Sign up for SMS/email status alerts
Website  Read major IT incident reports

UIS bITe-size bulletin

A regular newsletter aimed at the University's IT community, highlighting service and project news from UIS.

Sign up >

Latest news

University Wireless Service maintenance: Tuesday 21 September, 08:00–09:00

16 September 2021

The University Wireless Service will be undergoing essential maintenance between 08:00 and 09.00 on Tuesday 21 September while we apply a security software patch. This is a security update to ClearPass, which provides Wireless Service network access control. We're not expecting any disruption to service, but it should be...

Mailing list migrations from Mailman to Sympa

31 August 2021

We intend to migrate all remaining lists associated with colleges from Mailman to Sympa during the week commencing 13 September 2020. The current total is 1,567. How this will affect users of the mailing list management service Most mailing list subscribers shouldn't notice any difference. During the switchover, there will...

Managed Zone Service closedown and migration to Mythic Beasts

24 August 2021

The Managed Zone Service (MZS) is being shut down, and its data content migrated to a commercial provider, Mythic Beasts. There will be no interruption to the service, but MZS users in institutions will need to make arrangements to retain management access to their zones. What is changing? UIS set up the MZS many years ago...