Labware LIMS

BioPharma Process Science LIMS

 2012-2019

Context

My customer, a big globally acting pharma company, has Labware LIMS installations in many departments. The project I was working on was for the Biopharma Department "Process Science".

HTML Reporting

I develped a fully configurable HTML Reporting Framework that makes it easy to develop own reports.

Labware V7 Migration

In 2018, the customer switched from Labware 6 to Labware 7. Huge amounts of code had to be analyzed and adapted to the V7 coding rules. To keep the overview, I developed a LIMS Basic Code Comparision Tool on base of Node.JS. This tool is my intellectual property and can be licensed.
Contact me for further information.

Sophisticated Visual Workflows

The needs that a LIMS has to fulfill nowadays has changed in many ways compared to the LIMS systems we developed in the years around the millennium change. When a LIMS just administrates lab values, it will loose user acceptance on any level. The lab staff will be disappointed about old-fashioned looking user interfaces, and the decision makers want to have a toolset that helps to master "Big Data". To satisfy those needs of better visualisation, there are those ways:
  • offer better visualisations within the LIMS system itself
  • offer context-specific cross - links to other systems like e.g. Spotfire.
For example, I integrated a D3 Chart in a Visual Workflow
  • HTML Reporting Framework

    • Generic CSV Import

    I wrote a fully XML-configurable CSV import interface. This interface addresses different kinds of CSV files that are produced by different kinds of devices like
    • Siemens Rapidlab
    • Sartorius AMBR (different types)
    • department-specific Excel Sheets

    Macro Programming

    I wrote macros (test component calculations) for a couple of biopharma process templates. A subroutine framework helped us to make the macro calls more modular.

    Copy Experiment

    Sophisticated copying of the entity "PROJECT" with full granularity on SAMPLE, TEST and RESULT objects:
    • object fields to keep content when copied
    • object fields to clear content
    • object fields to set new content
    • define circumstances whether to clear/keep or modify content

    ProdSpec 2 Result

    One of the departments uses ProdSpecs excessively. As there are a couple of customer-defined aspects to the affected tables, we wrote an extensions to get full programmatical access how to write Prod Spec values to the result level.

    Autocalc

    Labware can only propagate in-Sample-calls for calculations. As the complexity of a downstream process required
    • to be more flexible with the propagation of calculations
    • there was the need to handle not only in-sample but cross-sample parameters as well
    we decided to set up a Cross-Sample Calculation framework. It was implemented in cooperation with Labware Consultants.