Import control values from test equipment
Control values can be automatically imported from test equipment into the Labordatenbank.
To import control values from the test equipment into the Labordatenbank, a corresponding import interface is created. To do this, click on "Create import interface" under the control card.
Afterwards, you can define the properties for the import interface.
For importing control values, a CSV file in the following format is required:
| Date | Temperature A | Humidity |
|---|---|---|
| 15.10.2016 | 23.45 | 72.4 |
| 16.10.2016 | 23.32 | 70.2 |
| 17.10.2016 | 23.42 | 69.8 |
| 18.10.2016 | 23.39 | 68.5 |
| The import interface then defines which column with control values belongs to which control card. |
Last change: 20.08.2025
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
- Evaluation criteria for suppliers
- Edit evaluation criteria for suppliers
- Test SFTP/FTP Connection
- Restore Deleted Records
- Manage PDF Templates
- Email informations
- Edit employee group
- Employee profiles
- Filter management - Search filter and column filter
- Edit Filters - Search Filters and Column Filters
- Hours per week
- Annual overview
- Hours per day
- Vacation days
- Edit hour
- Manage Weekly Hours
- Manage materials
- Onlineorder detailview
- Manage orders
- Edit orders
- Edit process key figures
- Create process key figures
- Manage 8D-Reports
- Process management view editing
- Edit processes
- Manage Projects
- Edit projects
- Manage qualification matrix
- Managing qualifications detailview
- Edit qualifications
- Manage recipes
- Creating/editing recipe
- Operating the recipe detail view
- Request signature
- Edit reporttables
- Edit reporttablecolumn
- Edit planned order
- Edit planned samples
- Edit signatures
- Edit stations
- Tag management
- AI Extension for Import Interfaces
- Edit Attributes in Import Mapping
Einführungsphase
- Labordatenbank introduction checklist
- Labordatenbank data structure
- Implementing the QM-Database
- Import parameters (Introduction phase)
- Import sample master data (Introduction phase)
- 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
- Link evaluations with import interface
Mitarbeiter
- Add employee
- Labordatenbank Login
- Change employee
- Change password
- Create task
- Access rights
- Employee groups
- Audit Trail: traceable documentation of all work
- Import employees (introduction phase)
- 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
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
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 ( introduction phase)
- 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
- Measurement repetitions value selection
Kundenzone (optional)
- Activating the Customer Zone
- Customerzone
- Create Online Analysis Order
- Sampling with online analysis order
- 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 (Introduction phase)
- 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
- Imort pictures in parameters
- 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 / rules
- 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 (Introduction phase)
- Change the document creator afterwards
- Delete documents
- Documents: Confirm validity check
Fragen und Antworten
- IT requirements
- 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
Prüfmittel
- Test Equipment Management
- Test equipment detailed view
- Add/edit/delete Test Equipment
- Import test equipment (introduction phase)
- 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 phase)
8D-Report
Sonstiges
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
Lieferantenbewertung
Dateiverwaltung
- Add Files (to Samples, Customers, Orders)
- Add Files (Test Equipment, Material, Batches, Specifications)
- File Management
- Search data
Prozesse