LIMS.eu

Allgemeines

• Main menu
• Dashboard
• Backup / Data protection
• Version number of the Labordatenbank
• Supported browsers
• Activation of SSO in the Labordatenbank
• Print labels
• Automatic Labordatenbank validations
• Create/Edit/Delete Categories
• Status management
• SMTP Configuration
• Konfiguration SMTP via OAuth 2.0
• IT requirements for the use of the Labordatenbank
• Add Dashboard Widgets

Einführungsphase

• Labordatenbank introduction checklist
• Labordatenbank data structure
• Implementing the QM-Database
• Import parameters
• Import sample master data
• Benefits of the Labordatenbank Cloud
• configurable master data fields in the Labordatenbank

Auswertungen

• Create evaluations using a template
• SQL Basic Course
• SQL JOINs
• SQL Basics
• Create SQL reports
• Parameter columns
• Variables in SQL reports
• Export SQL Reports
• Link Evaluations
• SQL report tables (SQL table and SQL bar chart)
• Save and Display MySQL Labordatenbank Backup Locally

Mitarbeiter

• Add employee
• Labordatenbank Login
• Change employee
• Change password
• Create task
• Access rights
• Employee groups
• Audit Trail: traceable documentation of all work
• Import employees
• Archive employees
• Tracking working hours
• activate Multi-Factor-Authentification (MFA) with TOTP
• activate a Security Key for the MFA
• Activation of Passkey
• Install TOTP App
• Edit Accessright

Aufträge

• Create Order
• Add an order using a template
• Equipment GPS location
• Add samples with an order template
• Add on-site inspection
• Delete order
• Scanning and sending documents to the Labordatenbank with QR
• Typical configurations
• Create order templates
• Create orders using templates
• Defining order access rights
• Order schedule

Proben

• Add samples
• Add multiple identical samples
• Enter values
• Enter identical values for multiple samples
• Edit samples as a group
• Sample search
• Sample sorting rules
• Statistical evaluations
• Save sample search as filter
• Show results table
• Column filter for results table
• Create filters specific to employee groups
• Automatic creation of analysis orders for external contracting
• Create analysis plan for samples
• Automatic Sample Notifications
• Delete samples
• Map pooled samples in LIMS
• Sample Tracking with QR Code (Scanning at Stations)

Probenvorlage

• Create sample template
• Create Probe with Probe templates
• Sample template for multiple samples

Berichte

• Create report
• Sign reports
• Send reports by e-mail or post
• Reissue of signed reports
• Inserting Images and File Attachments into a Report
• Create checklist with report table editor
• Protect emails from spam filters
• Certificate
• Manage signatures
• Deposit signature certificate

Kunden

• E-mail templates for reports and invoices
• Create customer
• Add contact persons at customers
• Merging duplicate customers
• Search customers
• Forward emails to the Labordatenbank
• Import customers
• Delete Customer

Berichtstabellen Editor

• Create report table with Report Table Editor
• Add column to report table
• Creating a parameter table with target values
• Create sample table
• Create table with open structure
• Report templates
• Order of the report tables
• Fonts and character set for PDF reports
• Report tables overview

Kundenzone (optional)

• Activating the Customer Zone
• Customerzone
• Create Online Analysis Order
• Sampling with online analysis order
• Integrate customer portal into existing website
• Hide parameter columns in customer portal
• Provide files in the customer zone

Anlagen

• Add new Assets
• Add asset parts to asset
• Add order templates to equipment
• Add tests to order templates
• Copy assets, order templates, and asset components

Angebote

• Create offer
• Add prices and price items
• Appendix with Terms and Conditions and Service Catalog
• Send Offer

Rechnungen

• Create Invoice
• Sending Invoices
• The English translation for "Teilzahlungen bei einer Rechnung erfassen
• Manage price list
• Exporting invoices
• Import billing items
• Create revenue centers for prices
• Activate X-invoice / E-invoice for Germany
• Create Collective Invoices
• Cancel invoice
• QR code for online banking on invoices

Parameter

• Basics of parameter management
• Add Parameter
• Parameter grouping and order
• Daily Task List: What has to be done in the laboratory
• Create table with parameter limit values
• Parameter Usage Annual Overview
• Delete test group, parameter group, or parameter
• Automatically display due parameters
• Legends & markings for subcontracting & accreditation
• Parameter data types
• portray proficiency tests
• examination packages

Rechnen mit Parametern

• Deposit formulas with parameters
• Calculating with number sequences
• Example: Weighing in and weighing out
• Calculation of dry matter and annealing loss
• Example: Calculation of annealing loss with validity check
• Example: Determination of Chemical Oxygen Demand
• Example: Determination of TVC - aerobic mesophilic total viable count
• Calculating with Date/Time Information
• Bsp.: Drinkingwater-Legionella since March 2023 (German Regulation)

Schnittstellen

• Import Interfaces Overview
• Import results from measuring instruments
• Create CSV measurement data import interface
• Import measurement data
• Import of samples
• Mode for measured value import
• Automatic FTP/SFTP Import
• Testing the HTTPS Import Interface
• Transformation code for importing other data formats
• Practical example: Import GC/MS measurement values to your LIMS system
• Practical example: Import Biomerieux Vitek antibiogram into LIMS
• Connect Thermo Fisher Chromeleon to LIMS
• Connect PCR to LIMS with plate assignment
• LIMS connection to DEMIS reporting for pathogen detection
• Tips for import interfaces
• Connection of Essentim data loggers

Webservice

• Labordatenbank Webservices
• Provide data as web services for external systems
• Send data to an external web service
• Send data to the Labordatenbank
• Example: Send eTermin to the Labordatenbank
• Example: JSON file for creating samples

Transformationscode

• General structure of a transformation code
• Transformation code for evaluations
• Export transformation code
• Webservice Response Handler
• Import transformation code

Prüfpläne / Grenzwerte / Spezifikationen

• Create test plan / limit values / specification
• Add setpoints
• Add target values - Special cases
• Targetvalue violations
• Parameter-specific text modules according to limit tables

Dokumentenlenkung

• Create a New Document
• Create new version
• Validate document
• Release Document
• Request read confirmation
• Import documents
• Change the document creator afterwards
• Delete documents
• Documents: Confirm validity check

Prüfmittel

• Test Equipment Management
• Test equipment detailed view
• Add/edit/delete Test Equipment
• Import test equipment
• Create control charts
• Import control values from test equipment
• Print labels for test equipment
• Forward emails to test equipment
• Booking Test Equipment
• Test Equipment Calendar

Material

• Functions of Material Management
• Create/edit/delete material
• Linking materials with parameters
• Reorder Materials Online
• Management of chemicals
• Manage/Create/Edit/Delete Batches

Mitarbeiterschulungen

• TrainingSchedule: Document Training Sessions, Demonstrate Competencies
• Add/edit/delete training
• Import Trainings (Introduction)

8D-Report

• Create 8D Report: Generate Quality Deviation Reports

Sonstiges

• Barcode / QR-Code Scanner
• On-Site Sampling with Input Form (Online and Offline)

PDF-Vorlagen

• Create/edit PDF templates
• Design elements Setting options
• Create design elements
• Integrate report tables into design template
• Design element for the reason for reissuing test reports

Fragen und Antworten

• Where can I find the current version number of the _LABORDATENBANK__?
• How can I calculate the average from five measured values?
• Where do you enter titles like Dr/Prof/Dipl. etc.?
• How can I change the order of parameters in the packages?
• Querious: Delete archived reports
• Download files in the Edge browser instead of opening them directly
• Transfer the status of the production system to the test system

Lieferantenbewertung

• Evaluate Suppliers
• Assign evaluation criteria
• Evaluate supplier assessment
• Delete supplier evaluation

Dateiverwaltung

• Add Files (to Samples, Customers, Orders)
• Add Files (Test Equipment, Material, Batches, Specifications)
• File Management
• Search data

Prozesse

• Process management