Search Knowledge Base by Keyword
-
HOW TO START WITH LABCOLLECTOR
- How does LabCollector interface look like?
- How does a module generally look like?
- How to set up storage in LabCollector?
- What are fields in LabCollector?
- What are records in LabCollector & how to create them?
- How to start with Antibodies module?
- How to start with Chemical structures module?
- How to start with Document module?
- How to start with Electronic Lab Notebook (ELN)?
- How to start with Equipment module?
- How to start with Plasmids module?
- How to start with Primers module?
- How to start with Reagent & Supplies module?
- How to start with Sample module?
- How to start with Sequences module?
- How to start with Strains & Cells module?
- How to use Webinars add-on?
- How to mass update memorized records?
- How to use LabCollector for COVID-19 testing?
- Show all articles ( 4 ) Collapse Articles
-
INSTALLATION
- How can I connect to LabCollector from another computer?
- LabCollector Installation Requirements for AWS
- How to install LabCollector using Docker?
-
- How to move a whole installation to a new Windows server?
- How to run LabCollector server on a 64bits Windows machine?
- Install LabCollector with IIS on Windows Server
-
- Clean the apache log manually to improve the speed.
- Switching to the ServerManager v2.5 (old way)
- Windows Installation Using Setup Wizard
- How to enable the soap.dll extension in LSMRemote using php file or LabCollector Server Manager (Windows)?
- How to use the LabCollector Server Manager?
- How to replicate LabCollector in real time with Windows Server Manager?
-
- Apache Server/Web server doesn't run on Windows 10
- Clean the apache log manually to improve the speed.
- Clean the logs manually to improve the speed.
- ERROR in log: AH00052: child pid 3461 exit signal Segmentation fault (11)
- ERROR: Warning: mysql_connect(): Client does not support authentication protocol requested by server (…)
- How to make Java applets work again after upgrading to Java 7U51+?
- How to restore overwritten documents
- I have the message "Failed to connect to mySQL server. No Database found for this lab account". What can I do?
- My LabCollector or Add-on is very slow. Why and how to fix it?
- Unknown column “auto_name_mode” in “field list”: The error is occurring when I want to adjust existing records, make new records or import data. What can I do?
- URL issue
- When I add records or any values I have this message: "incorrect integer value: for column 'count' at row 1"
-
- Give access to LabCollector to collaborators outside your network
- Can the database be separated from the system on which labcollector is installed?
- I have problems installing PHP and/or MySQL. Is there an alternative?
- Mysql Server memory usage optimization
- PHP extensions needed
- Rack scanners installation and connection with ScanServer
- System Requirements - Hosted options (FR/ENG)
- What are PHP and MySQL? Do I need to have PHP & MySQL?
- How to migrate LabCollector to new Linux Server?
-
GENERAL
- What is LabCollector?
- How do I install LabCollector? Where can I find the install.exe file?
- System Requirements - Hosted options (FR/ENG)
- How does the remotely hosted version work?
- Can I use LabCollector on a single computer? Can I install it on a web server?
- If I purchase ONE license, do I need to purchase additional licenses for other computers in my lab network?
- Client Area Tutorial
- LabCollector support
- What are the FDA requirements for software to comply with GxP guidelines?
- Do I need to purchase all modules? Can I use only the primers module?
- Icons meaning (EN/FR) V.6.0
- Icons meaning (EN/FR)
- How do I search in LabCollector?
- Can I see/list all records in a module?
- How do I print records?
- How to add panels to LabColletor v6.0?
- How to create tubes with storage and mark their usage? (v6.0)
- How to create and set alerts for tubes? (v6.0)
- Label network printers and roll types
- Show all articles ( 4 ) Collapse Articles
-
BASIC FEATURES
- Export and print models
- How do I add multiple records without data import
- How do I link records and for what purpose?
- How do you create or edit records? (FR/EN)
- Icons meaning (EN/FR)
- Icons meaning (EN/FR) V.6.0
- Reagents & Supplies Link what is the purpose?
-
- What can I do with the default fields?
- Can I add a custom module to fit my specific needs?
- Custom field types
- How do you create a custom field?
- How do you create a custom field? For version 5.2 onwards
- Custom field: Field category option version 5.2x
- Custom fields: Tab Analysis option
- How do I customize record options?
- How do I use a Read-only field?
- How to customize LabCollector login page colors?
- How to change the language & name of custom fields?
-
- What is a CSV file?
- Import your data (v6.0)
- Import your data (5.3 version and above)
- How to delimit data csv for data import?
- What are the default fields values while importing data? v6.0
- How do I format the date value as yyyy-mm-dd or yy-mm-dd to import?
- Import your samples and associated storage in 3 steps
- Import and manage your Reagent & Supplies V5.3 and above
- Importer ma BDD EndNote dans LabCollector (FR)
- How to solve errors while importing data
- How to mass update memorized records?
-
- What are user level permissions?
- How do you use versioning? v5.31 and below
- How do you use versioning? v5.4 and above
- How to manage users (v5.31 and below)
- How to manage users (v5.4 and above)
- How to use AD or LDAP for login authentication?
- What are group policies and how to use them?
- What are group policies and how to use them? v5.4 and above
- What are group policies and how to use them? v6.0 and above
- How to manage users? (v.6.032+)
- How to configure access permissions?
-
MODULES
-
- Articles coming soon
-
- How to start with Reagent & Supplies module?
- Reagent & supplies preferences (v6.03)
- Reagent & supplies preferences
- How do I create alerts for chemical and equipment?
- How do I create alerts with lots? (v6.0)
- Manage your reagent lots (v6.0)
- Manage your reagent lots
- How to dispose of a lot?
- Risk codes
- How do I manage vendors and sellers?
- How do I print risk and safety data information?
- Import and manage your Reagent & Supplies V5.3 and above
- Manage storage for Reagent & Supplies module
- Manage storage for Reagent & Supplies module (v6.0)
- GHS Hazard Pictograms, Mandatory Safety Signs and the NFPA Hazard Rating System
- How to Use SDS Maker?
- Show all articles ( 1 ) Collapse Articles
-
- Articles coming soon
-
- Articles coming soon
-
- How do I create alerts for chemical and equipment?
- How to activate and set different types of Equipment alerts? (v6.0)
- How to activate and set different types of Equipment alerts? (v5.4 and below)
- How to add a new category and record in equipment module? (v6.0)
- How to add a new category and record in equipment module? (v5.4 and below)
- How to add control chart for calibration maintenance of equipment?
- How to Add/Edit Maintenance for Equipment? (v6.0+)
- How to add/edit maintenance for equipment (v5.4 and below)
- How to export equipment maintenance report?
- What are the options in "display maintenance" section of equipment. (v5.4 and below)
- What are the options in "display maintenance" section of equipment. (v6.0)
-
- Articles coming soon
-
ADD-ONS
- What are Add-ons?
- Fly Stock Manager
- What's Weight Tracker Add-On? How To Use It?
- Custom Field File Upload
- What is e-catalog add-on? And how to use it?
- Lab Cross Search
-
- How to start with LSM?
- LSM Usage Guide – From Job Request to Results Reporting
- Test the LSM API
- Insert the LSMremote application in your website
- How to Perform a Paternity/Relationship Genetic Test using LSM?
- Introduction to HL7 and how to use it in LSM
- LSM Job List Icons - What do they mean?
- LSM: How to Group Test Results by Specialty?
- Lot-Sample Linking in LSM for Quality Control
- LSM: Trending and Job Charts
-
- 1st step: Create users and requesters
- How to send samples from LabCollector to a LSM job
- How to link a custom module to LSM?
- How to manage case records (patients, animals...) in LSM?
- How to re-order/re-arrange job & sample custom fields in LSM?
- How to manage ranges in LSM?
- How to restart a job in LSM?
- I’m able to add a new job with no problems but when I try to start it I can’t do it. The following error appears: Error loading XML document: data/bl/bl-job.php. What’s the problem?
- How to accept jobs in LSM?
- How to create & execute a job in LSM?
- How to create version of test in LSM?
- How to import CSV with samples and tests in LSM?
-
- 5th step: Result and invoice template
- How to generate Reports in LSM?
- How to create a processing report in LSM?
- How to Generate Invoices Report Template in LSM?
- How to create a Chain Of Custody (CoC) report and use it LSM & LSMRemote?
- How to use text editor to create a report template in LSM?
- Report tags in LSM for result/invoice/CoC/batch templates?
- Correction/Amendement actions in LSM report
- How to print and follow multiple reports/CoC's in LSMRemote?
- Error loading big reports in LabCollector
- Error loading big reports in LSM
- How to configure header & footer in LSM report/CoC/invoices? (from v4.057+)
- What's the purpose of the report unique ID barcode?
-
- LSMRemote (v6.0) registration, login and other options
- LSMRemote installation steps & Integration into the website ? (v4.0)
- LSMRemote configurable options (v4.0)
- How to configure new fields, submit a job in LSMRemote & view it in LSM?
- How to search in LSMRemote?
- How to create a token for report access for patient/client using LSMRemote?
- How to generate CoC Manifest with integrated labels?
- How to print and follow multiple reports/CoC's in LSMRemote?
- Patient pre-registration configuration and LSMRemote portal connection
- How to do job pre-registration from the LSMRemote portal?
- How to integrate appointments scheduling in LSMRemote?
- How to enable the soap.dll extension in LSMRemote using php file or LabCollector Server Manager (Windows)?
- How to import jobs using LSMRemote?
- How to configure kit and activate it in LSMRemote?
- How to print in bulk the barcodes using LSMRemote?
- How to enable the soap.dll extension in LSMRemote using php file on Linux?
- Show all articles ( 1 ) Collapse Articles
-
- OW-Server ENET manual
- OW-Server Quick start guide
- OW-Server WiFi manual
- Quick WiFi configuration for OW-Server WiFi
- Conversion method from mA reads to specific Unit for data logger probe?
- How to setup your Data Logger in LabCollector?
- How to Install Sensors on ULT Freezers?
- How to Setup Alerts in Data Logger?
-
-
- How to create a Book, add an Experiment and a Page?
- What is inside a Book?
- What is inside an Experiment?
- Whats inside ELN Page?
- How do I print from ELN?
- ELN Workflows
- ELN templates
- TIFF Image usage
- How to electronically sign the ELN pages?
- How to add a microplate in ELN Page?
- How to add a reagents/solutions recipe in ELN?
-
- ELN - Zoho Spreadsheet Help Guide
- Graph in Flat spreadsheet
- How to change the language of ZOHO excel in ELN?
- How to replicate/import your excel in ELN?
- How to use spreadsheets?
- What is Flat & Zoho Spreadsheet Editor & how to enable it?
- How to use Flat spreadsheet & formulas in it?
- How to make graph in Flat Spreadsheet?
- What can be copy pasted from excel into Flat spreadsheet?
-
- Sample-receiving add-on : Project configuration settings
- How to create & process a package in Sample receiving add-on?
- How to perform pooling in sample receiving add on?
- How to process plates in sample receiving add-on?
- How to view samples created in sample receiving add-on into a module?
- How to add samples created in sample receiving into Workflow add-on?
- How to connect and send samples from 'sample receiving' to do tests in 'LSM'?
-
MOBILE APPS
-
- Articles coming soon
-
INTEGRATION
-
API
- Introduction to LabCollector API
- API for LabCollector (v5.4+)
- API for LSM (v2)
- API for ELN (v1)
- How to test the LabCollector REST API?
- API error messages
- API: How to create boxes or plates?
- Test the Lab Service Manager API
- Webservice/API Apache setup
- How to set up your Web Services API?
- What's Swagger UI? How to access it & test out API endpoints?
-
TOOLS
- How do you install NCBI blast executable to use in LabCollector?
- How to setup and use Recipe Manager (old version)
- How to manage memorized items?
- Purchase order management - A to Z
- Purchase order management – A to Z (v 6.0+)
- Recipe Manager (v6.0)
- Samples batch tool (Rack scanner)
- How to use Mass Record Updater?
-
UTILITIES / MIDDLEWARE
-
- How to download and Install File connector v2.2? (Labcollector v6.0 )
- How to install Fileconnector in Mac OS? (Labcollector v6.0 )
- Editing a file using File Connector
- How to use a specific software to open certain types of files in fileconnector? (Labcollector v6.0 )
- How to use Fileconnector in Mac OS?
-
- How to setup and configure Scan Server with LabCollector?
- Samples batch tool (Rack scanner)
- The rack barcode on top or as third element in lines?
- How to open CSV in UTF8 in Excel?
-
PRINTING
- How to configure printer with LabCollector?
- How to connect USB printer to LabCollector?
- Compatible Label printers
- Label network printers and roll types
- Barcode label generation and printing
- How do I print barcode labels?
- How do I print box maps?
- How do I print records?
- How do I print risk and safety data information?
- How do I print storage records
- How to print labels on HTTPS environment?
- How to best configure your PDA N5000 for LabCollector use
- How can I configure my barcode scanner AGB-SC1 CCD?
- How can I configure my barcode scanner HR200C ?
- How do I configure FluidX to support ScanServer?
- Barcode Printer Connection Time Out
- AGB-W8X Manual for barcode scanning
- How to set up your Printers & Labels?
- How to Increase Label Print Quality in LabCollector?
- Show all articles ( 4 ) Collapse Articles
-
STORAGE
- How to set up storage in LabCollector?
- How to create boxes/drawers/racks in storage equipment?
- How to create box models for storage?
- How to replicate and duplicate boxes in storage?
- How to store and manage straws? (EN/FR)
- How Do I Add Samples to a Specific Freezer, Shelf or Other Part of the Storage System?
- How do I get out samples from a specific freezer?
- Manage storage for Reagent & Supplies module
- How to organize Storage Browser?
- How do I print box maps?
- How do I print storage records
- Storage Check-in/out System
-
COMPLIANCY
- What is in the Compliancy Pack?
- How do I use a Read-only field?
- What are the FDA requirements for software to comply with GxP guidelines?
- FDA CFR21 part 11 product checklist
- ISO 17025 compliancy requirements
- How do you use versioning? v5.31 and below
- How do you use versioning? v5.4 and above
- Should I lock, archive or delete records?
-
SUPPORT
-
SETTINGS
- How to configure Apache to work with Office 2007 and higher?
- How to speed up your LabCollector? (EN/FR)
- PHP extensions needed
- Speed your local network
- TIFF Image usage
- Time stamp in the records showing incorrect time.
- How to configure SMTP to use OAuth 2.0 (Microsoft & Gmail)?
-
- LabCollector General setup
- LabCollector General setup - v5.4
- LabCollector General Setup 5.2
- LabCollector General setup-v6.0
- Login Options & php requirements for LDAP/SSO
- How to set up your LabCollector's general settings, logo & modules' names?
- How to configure your Proxy, Task Scheduler and Email options?
- How to configure your module search & form options?
- How to configure your Homepage external links?
- How to set up your News Feed?
-
- Error loading big reports in LabCollector
- Fields with scroll bar don't work with Safari, what can I do?
- I can't manage to view box scheme in Safari, why?
- I get the error: "The program can't start because MSVCR110.dll is missing from your computer. Try reinstalling the program to fix this problem" when installing or updating LabCollector for Windows
- Issue in upload file: look at your PHP configuration
- Module search fails with 404 error or request too long
- When I want to import large files, nothing happens?
- Why do I have the error “MySQL server has gone away” on file upload?
-
NEW KB OF THE MONTH
-
RECORDED PRESENTATIONS
You are here:
← All Topics
SUMMARY:
LabCollector is a server software developed in PHP scripting language. It is designed to be accessed and shared over a network. Install it once on a central computer (server) and call it from an Internet Browser: Internet Explorer 10 or later, Firefox 20 or later, Chrome, and Opera 9.
We highly recommend you to use the most recent browsers.
Follow the below steps for LINUX installations:-
1. LabCollector LINUX requirements
2. Download the installation pack
3. Unpacking & Uploading the files
4. Loader Installation by PHP.INI modification
5. Loader Installation for Runtime loading
6. Changes in PHP.INI & Installation
7. PHP extensions
8. Mysql requirements
9. Logging in LabCollector
1. LabCollector LINUX requirements
- Linux (any recent distribution)
- Apache 2.4.x
- PHP 7.4 and PHP 8.1 (PHP 5.6 to 7.4 only for legacy versions)
- MYSQL or equivalent (MariaDB, PerconaDB)
- 4cpu cores
- 8Gb RAM
Libraries/packages (names may vary depending on distribution):
- PHP-mysql, PHP-mcrypt, PHP-xml, PHP-zip, PHP-Curl, PHP-OpenSSL, PHP-LDAP…
Additional software:
- Curl
- OpenSSL
- Mono (optional)
- Webmin (optional)
- Perl (CGI and other packages needed for webmin)
AgileBio software
- LabCollector Webmin module (*Contact Us if you wish to install & use this tool)
2. Download the installation pack
- From your client area, download the installation pack that suits your need.
- More information on the client area, here.
Requirements: Have access by FTP to a web server account or work directly on the web server itself.
3. Unpacking & Uploading the files
- Unpack the ZIP package on a computer or on the server.
- Upload or copy files contained in the HTML folder to the correct web-accessible folder (in BINARY FORMAT). NOTE: Be sure the folder has written permissions, at least for install purposes. You can remove this permission once install is finished.
- Do a chmod 777 on the following folders: /backup, /documents, /temp, /maps
*(Setting 777 permissions to a file or directory means that it will be readable, writable, and executable)
4. Loader Installation by PHP.INI modification
- Execute from your Internet browser: launch the Loader Wizard script in your browser. (https://www.ioncube.com/loaders.php)
- For example http://localhost/ioncube/loader-wizard.php and follow loader install instructions.
- Restart your webserver.
5. Loader Installation for Runtime loading
- Nothing has to be done.
- Loaders are located automatically inside the IonCube folder that you must keep in the LabCollector folder.
6. Changes in PHP.INI
- Insure you of these parameters:
- error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED
- display_errors = Off
- short_open_tag = On
- Run from the browser a file install.php (you need first to install loaders. (Read above sections 4 & 5.)
- Fill in the information asked and press the ‘Next’ button (MySQL login by default is root with no password)
Note
You have possibility to modify certain variables (mentioned below), which can be useful if you have specific requirements that are not met by the default values. Simply access the php.ini configuration file and make the necessary changes.
- max_input_vars : This configuration variable specifies the maximum number of input variables that can be accepted by PHP, it can be increased as needed (for example max_input_vars = 100000000).
- pcre.recursion_limit : This variable sets the maximum amount of stack memory that can be used by PHP’s PCRE (Perl Compatible Regular Expression) engine, it can be increased if needed (for example pcre.recursion_limit = 10000000).
- max_execution_time : This variable determines the maximum amount of time (in seconds) that a PHP script can run before being terminated. The default value of this variable is usually set to 30 seconds, but it can be increased as needed (for example max_execution_time = 120).
- max_input_time : This variable determines the maximum amount of time (in seconds) that PHP will spend on input processing before timing out. The default value of this variable is usually set to 60 seconds, but it can be increased as needed (for example max_input_time = 360).
- memory_limit : This variable sets the maximum amount of memory (in bytes) that a PHP script can use. The default value of this variable is usually set to 128MB, but it can be increased as needed (for example memory_limit = 1024M).
.
Be Careful note
It’s important to note that modifying these PHP variables without proper understanding and testing can have adverse effects on the performance and stability of LabCollector. So, it’s recommended that you seek the advice of experienced developers or server administrators before making any changes.
7. PHP extensions
NOTE: Be careful that you NEED to have these PHP extensions installed on your server:
- php-mysql (up to PHP5.6.x)
- php-mysqli (from PHP7.x)
- php-pdo
- php-xml
- php-gd
- php_mbstring
- php-ldap (this one is optional, in case you want to use LDAP as login authentication)
8. Mysql requirements
In my.cnf,
- Insure you have set these parameters:
-
character_set_server = latin1 collation_server = latin1_swedish_ci
-
- Other settings for MYSQL 8+
- The following setup is needed for MYSQL 8+
-
default-authentication-plugin=mysql_native_password
- Once active, please redefined MYSQL user passwords
- Find the sql-mode line definition in my.cnf/my.ini and keep it like indicated below. If the sql-mode line does not exist, please add this way:
-
sql-mode="NO_ENGINE_SUBSTITUTION"
- This variable has to be set as 0
-
SET PERSIST information_schema_stats_expiry = 0
- Other settings for (including AWS server)
- You need to set MYSQL 8 to have: Binary Logging Enabled
-
- The following setup is needed:
SET GLOBAL log_bin_trust_function_creators=1;
-
- You need to set MYSQL 8 to have: Binary Logging Enabled
- Install MySQL/MariaDB tools, such as mysqldump, which is a utility for creating backups of MySQL databases.
More requirements for MySQL Configuration:
*Check out our KB on LabCollector’s AWS requirements & installation
- if you are hosting MySQL on localhost, you will need to apply a configuration to the /etc/my.cnf file. Specifically, you should set the “innodb_strict_mode” parameter to 0. This can be done by adding the following line to the my.cnf file:innodb_strict_mode=0After making this change, you need to restart the MySQL.
9. Logging in LabCollector
-
-
- Access it by calling it from a web browser, usually by writing the network name of the server computer.
- This can be done from any computer connected to the local network.
- After the first installation, by default super-administrator access to LabCollector using:
login: admin and password: admin - You can then change the password and add more user logins. (In LabCollector go to ADMIN -> MANAGE USERS)
-
Related topics:
-
-
- Check our KB on IonCube on CentOS
- Read our KB on How to install Ioncube Loader on CentOS, Debian and Ubuntu?
-