What's new?

Version 2.6.0a of August 4, 2021

Bugs fixes:

- Identification with a CAS server didn't work correctly (file to change: framework/identification/login.class.php)

Version 2.6.0 of June 24, 2021

What's new :


- it is now possible to indicate the country of origin, in addition to the country of collection (useful information in the context of APA regulations)
- it is now possible to search for samples that have been reserved during a period or by type of event encountered, or by country of origin
- in the sample search module, the country can be searched by typing its name
- In the list of samples, when hovering over a sample, the remaining available samples are displayed. It is possible to search for samples according to the quantity available (sub-sampling)
- in the list of samples, it is now possible to choose the list of columns to display
- the metadata are now displayed in the list of samples
- in the sample list display screen, the total number of records is now displayed at the beginning of the list, not at the bottom
- it is possible to change the status of samples in bulk
- when displaying metadata, the unit is now displayed for numeric types

Mass import:

- it is possible to use the name of parameters instead of their value (e.g., sample_type_name instead of sample_type_id)
- it is now possible to create parents and children in a single import, using the sample_parent_identifier column (the parent sample must exist beforehand or be present higher in the file). Same for creating the input movement, with the container_parent_identifier field


- a web API for creation/update is now available (experimental)
- user identification can be completed by a double identification (TOTP)
- it is possible to assign a referent to a list of containers
- in the movement list, the comment is now displayed, as well as the link to the concerned sample
- documentation is now available online

Bug fixes :

- changes in error messages
- deleting a list of containers no longer causes an error if no container is selected
- restructuring of the regulations display screen: some information was not visible
- correction of the rights for the modification of collections
- the first name of the referent was not displayed everywhere
- added an error message when importing, if the reading of the metadata is not successful
- added an error message if the deletion of a status is not successful
- from the detail of a sample, it was not possible to delete a derived sample from the list
- when importing a list of stations, in case of an error on a column name, an unspecified error was displayed instead of the name of the column in error
- the reset button in the sample search window did not reset the metadata correctly
- the CSV export button, from the table, did not display correctly the name of the columns
- in mass import, the country code was not taken into account
- the import of the sampling locations was in error if the country code was not filled in
- when creating a new instance, the GIN indexes were not created (wrong syntax)
- in the SQL query module, if the query did not return any record, the software did not report it and the user could have doubts about its operation
- Logins are now systematically processed in lower case, to limit problems related to CAS servers that work differently for the same users (case encountered with the Renater federation)
- when modifying a parent sample containing metadata, the child samples disappeared from the list: the "trashed" attribute was no longer correctly positioned

Version 2.5.0 of November 13, 2020

New features:

- the database structure now displays the views
- reorganization of the menu, to have a main entry dedicated to imports/exports
- it is now possible to indicate a collection country for a sample (full table provided). The country can be assigned for a set of samples
- in the rights management module, it is now possible to move a group in the tree structure
- in the labels, it is now possible to insert the referent
- it is now possible to search for containers by referent
- when displaying a sample, if the code of a secondary identifier is not filled in, the name of the secondary identifier is displayed. The code becomes non mandatory, if the identifier is not used in research.
- for collection campaigns, it is possible, for each regulation applied, to indicate the authorization number and the date. Samples can be searched by authorization number.
- added a function to search for the containers contained in them
- when creating a derived sample containing sub-samples, creation of the sub-sampling if the derived sample contains sub-samples itself
- added uniqueness constraints on the labels of a certain number of parameter tables
- modification of the display of a sample: addition of a "quick access" link, which allows to display the search box from IUD or IDENTIFIER
- corrections of some labels
- added the license table to indicate the license to distribute a collection
- added tabulation input in textareas (multi-line input fields). Implemented in xsl transformation input (export datasets and label templates)
- it is now possible to save searches performed on samples, available either for the user or at the collection level
- it is now possible to specify keywords or explicit wording for a collection (used for exports)
- the first name of the referent is now possible, as well as the link to his academic file
- Added consistency checks on sample loan and return dates, as well as for reservations
- in the menu, when there is a submenu, the menu entry is duplicated in the submenu
- added a lexicon to the hover : in the labels, hovering over a question mark icon (when it exists), displays the corresponding lexicon entry
- Administrators can now trigger a manual backup of the database, which is downloaded to the browser (possible limitations depending on the size of the database).
- it is now possible to add a comment to an object
- added functionality to export samples from a collection to third party information systems (customizable content and format)

Bug corrections:

- in the detail of a container, in the list of containers, the number of slots was not displayed
- in the detail of a container, the referent was displayed incorrectly
- in the rights management module, the deletion of a group was not successful if the group was assigned to a collection
- the display of the sample grid, in detail, was wrong if the first column was on the left side of the grid
- in mass import, importing UUIDs did not work
- in the list of containers, the display of the grid of contained objects was badly drawn
- removed the lc_messages function, which should have allowed to change the language of Postgresql error messages: it only worked if the collec account was super-administrator of the database server
- the quick access link, available for samples, has been added for containers
- if the Internet address of the workstation changed during the day, it was no longer possible to re-identify without manually deleting the identification cookie or closing the browser
- bugfix of the menu generation module : in some cases, the symbol >, which allows to know that there are sub-menus, was not displayed
- the export of the database structure did not work properly

Version 2.4.1 of June 15, 2020

Bug fixes:

- the generation of the samples file in CSV format didn't result anymore
- from the sample table, starting the label printout generated an error if no sample was selected
- when searching for samples from the map, the re-launch of the search lost the previous criteria
- changing the password might not be in English
- the message indicating that the password was about to expire was not reset correctly on the day it was changed
- the tab for displaying the sample location map was not selected by default if it was the last tab selected
- redesigning the display of tabs to make them more readable

Version 2.4.0 of February 17, 2020

Bug fixes:

- when modifying a password, the information message about the length of the password was wrong.
- the wording regarding the referent of a container was incorrect
- creating an output transaction from the detail of a sample did not work
- Resetting the sample search form was incomplete.
- multi-value metadata entry was not working. The management mechanism was taken over
- deletion of samples could result in unclear messages or messages that do not reflect the problems encountered
- when searching for samples, in some cases, the list returned could be too large and saturate the browser
- the creation of events by batch of samples was not possible as the list of event types was not available
- in the sample list, the "date-time" fields are now displayed on a single line, without carriage return.
- in the protocols, it was not possible to delete the uploaded document
- correction of installation and database backup scripts

What's new:

Containers :

- it is possible to define a maximum number of available slots. The list of containers allows you to view the number of available locations.
- the display of the content object grid allows to view all content objects, not only the last one.
- the starting point for the number of rows and columns can now be positioned to the right (only to the left in previous versions)
- in the list of containers, hovering over the identifier with the mouse displays the grid of contained objects
- it is now possible to delete a batch of containers


- it is now possible to add a description to a sample type
- The list of sample types can be exported in CSV.
- when the status "destroyed" is set on an object, an exit movement is automatically generated
- the call to the https://collec.local/index.php?module=sampleDetail&uid=928 function allows to retrieve the details of a sample in JSON format, without prior identification, if the collection has been defined as public (prefiguration of web services)
- in the list of samples, hovering with the mouse over the identifier displays a summary of the sample
- in the details of a sample, the list of secondary identifiers is displayed, without having to position oneself in the ad-hoc tab to view them
- when creating a derived sample, the business identifier is duplicated
- in the list of samples, each column can be subject to a dedicated automatic filter
- the different possibilities of searching for a sample are now organized in thematic tabs
- it is possible to carry out a spatial search of the samples, by drawing a rectangle on a map
- on the home page, the number of samples per collection and the date of last modification is displayed. The list is limited to collections for which users have management rights.
- the list of samples is supplemented by a map showing their location
- it is possible to attach a sample to a sampling campaign. This can be associated with one or more regulations, and it is possible to attach additional documents to it
- it is now possible to search for samples by metadata without first selecting the sample type


- an object can be trashed (functionality provided for automatic exchanges)
- the precision of the location of an object can be defined from a table
- objects are now equipped with a Postgis field, facilitating spatial search or visualization with third party tools such as QGIS
- The date of the last change to an object is recorded
- addition of a field of type UUID, to facilitate exchanges
- From the lists of samples or containers, it is now possible to generate the input or output movements for the selected objects

Imports/Exports/Downloads :

- the result of the imports (UIDs generated, number of rows processed) is now stored in the log table
- it is possible to import multi-valued data into the individual metadata fields (md_)
- on an experimental basis, addition of a module to export part of the database in JSON format. Importing such a file in another instance allows to reconstruct the records concerned.
- the mime types of the downloadable files are now modifiable or extensible


- administrators can now directly consult the log table
- a module for writing and executing SQL selection queries is available (required right: param)
- for a collection, it is possible to define whether incoming or outgoing flows are allowed. Similarly, a collection can be defined as public: all samples could be viewed without prior identification. This is a feature prefiguring web services.
- the display windows for containers and samples have been redesigned to make them easier to understand
- it is possible to assign a laboratory number to a borrower
- sorting in tables is now case- and accent-independent
- the database structure can be viewed from the interface
- the software now supports Shibboleth identification (HEADER mode)
- when creating label templates, it is now possible to save changes and stay on the current page, to facilitate fine-tuning (displaying the label in another browser, for example)
- the website https://wwww.collec-science.org has been updated
- the comments in the database have been switched to English
- for users identified from the local database, their account is blocked after three logins without changing the password. The status of their account is now displayed.
Translated with www.DeepL.com/Translator (free version)

Version 2.3.1 of September 6, 2019

Bug fixes:

- in mass import, dates were refused if they were in the format hh:mm (no seconds)
- the search for samples failed if the only search criterion was based on dates
- the deletion of samples from the detail of a container did not work
- after creating a movement, the software could be blocked for several seconds
- the detail of the objects (containers or samples) has been improved: the last visited tab is now displayed by default, and it is possible to activate a function to view the content of the tabs when hovering with the mouse
- in the list of contained objects, the row and column number was not displayed
- the search by referent now takes into account the referent declared globally for the collection in question
- from the detail of a container or sample, opening a new object did not work with the use of the business identifier
- ergonomic corrections: deletion of three-point (ellipsis) in some labels in some Chrome browsers, correction of some others labels

Version 2.3 of August 14, 2019

Bug fixes:

- harmonization of certain labels in the application (Save/validate or Select/Choose for example)
- in the detail of a container, the contents and products used were poorly displayed
- the tables were not working well, especially when displaying pages from the navigation buttons
- correction when searching by date: the current date was not systematically taken into account
- during imports, some incorrect dates passed through the consistency checks
- the search for containers only by status (out of normal state) did not work

Evolution of existing functionalities:

- upgrading the framework to add security controls. The Framework now meets the requirements of ASVS v4 (total level 1, partial level 2).
- ergonomics: the sample and container display screens have been partially redesigned: the data are now organized by tabs. It is also possible to open a new object directly from the detail page, without returning to the list
- it is now possible to attach a sample to a parent
- a function to duplicate a sample with its parent is now available
- in the administration module, it is no longer possible to create a new right (but this can be reactivated with an option in the param.inc.php file)
- when entering metadata models, the "Unit of measurement" field is proposed by default with the value N/A
- metadata models can now be viewed without switching to edit mode
- it is now possible to search for a sample by destocking reason
- in the description of a protocol, it is possible to indicate the number and date of the sampling authorisation
- sample search: it is now possible to scan a label

New features :

- it is possible to generate an export of one or more containers, which include both the containers and the included samples, for import into another database
- sample loan management: it is possible to register the loan of containers or samples to borrowers

Version 2.2.3 of february 22, 2019

Bug fixes:

- the deletion of a group of users was not possible under certain conditions
- it was not possible to print a label since the detail of a sample
- the kinematics of the application was not correct when deleting a sample
- the deletion of a sample failed if secondary identifiers, reservations, ... existed
- when entering sample types, container types were not sorted
- in the table of logins stored in the database, the information "account used for a web service" was not displayed
- the transformation of the sexagesimal GPS coordinates into decimal coordinates failed if they were not completed. Moreover, the algorithm used was wrong
- when creating a derived sample, the referent was not retrieved


- when entering the GPS coordinates of a sample or container, the point is automatically generated on the map, and the map is centered on the point
- it is now possible to add the referent during a mass import
- in tables displayed per page, the number of items displayed is now stored, and becomes the default value for future displays
- the name of the scripts used to create the database is now generic, to facilitate the automatic installation (especially docker components)
- in the label templates, it is now possible to include the identifier of the parent sample

Version 2.2.2 of november 26, 2018

bug fixes:

- identification in CAS mode did not work, due to an evolution of the library used
- the global assignment functions for a sample list did not work since the detail of a container


- it is possible to create an event for a series of samples and no longer individually. This function that can be used to indicate an event that occurred for a container (eg fridge failure)
- in the lists of containers or samples, the checkboxes, which allow to select or deselect objects, have been moved to the first column: they are thus more visible
- adding a "modify" button in the list of metadata types or label templates, to avoid false manipulation (duplication instead of modification)

Version 2.2.1 of october 5, 2018

bugs fixes:

- in mass import, if the sample had to be associated with a container, the creation of the movement failed as well as the import of the whole file
- a database query failed when a subsampling move was displayed
- if the table containing the version numbers was not accessible, the application displayed an incorrect message
- if the parameter table was not accessible, the application crashed with an error message
- exporting, then importing a list of samples (for exchange with other databases) did not take into account the referent
- when consulting a sample, after having clicked a second time in the reference zone, the display was replaced by the label undefined

Version 2.2 of september 6, 2018

Bugs fixes:

- The addition of PDF files to the protocols could fail due to limitations placed in the server as to the size of the files. In this case, no error message was displayed
- the title of the application, which appears next to the icon, disappeared just after the disconnection
- if the title of the application was updated, it was necessary to wait for the reconnection for the new value to be displayed
- the removal of a family of containers could give the impression that it was proceeding correctly, but this was not the case if container types were attached to it
- the application didn't work with PHP 7.2


- new parameter variables are now attached to the database and overwrite the data in the param.xxx files: mapDefaultX, mapDefaultY, mapDefaultZoom
- the error messages are now displayed in red. Database-related anomalies (including failed deletes due to integrity constraints) are now better explained
- it is now possible to describe a URL type metadata field. The link is directly displayed in the browser during the consultation of the sample
- metadata fields can accept now a default value
- multiple deletion of samples: from the list of samples, it is now possible to perform various operations on those that are checked, including their removal. The function requires a "collection" right
- adding the notion of referent in the application. A referent can be attached to a collection as a whole, or to a particular object (sample or container). For samples, the displayed referent is either the one in the collection or the one assigned in particular.
- multiple assignment of a referent: from the list of samples, it is possible to automatically assign a referent to those which are checked
- admins can display the database structure in HTML or LATEX format

Version 2.1 of July 3, 2018

Bug fixes:

- when a container was edited, the container type was not displayed if it contained an apostrophe
- when creating the password recovery mail, the application name was not correctly initialized


- full English support in all software
- a new variable must be entered in Administration> Application Settings: APPLI_title, which must contain the title of the application that is displayed

Version 2.0.1 of May 25, 2018

Bug fixes:

- the choice lists were illegible on small terminals
- when the interface was set to English, creating a new user generated a date management error
- the generation of the file to print labels (export CSV) did not treat correctly the metadata, which were badly positioned in the columns
- The col_alter_1.2-1.2.3.sql script could generate errors in some cases
- if a request to search for samples triggered an error in the database, the screen remained blank without being able to know what was happening


- addition of a restricted display mode of the list of samples, either for specific uses or for small screens (only a few columns are displayed). The flip-flop is operated via a button
- added precision to properly handle rights in col_alter_1.2.3-2.0.sql
- exporting samples to another database creates dedicated columns for each metadata, prefixed by md_

Version 2.0 of May 4, 2018


- update of the framework and the database
- possibility of generating the label of the sample being viewed
- when creating a new sample, the information present in the pre-existing label (Json format) is automatically retrieved after its scanning
- addition of a filter to remove stray characters when reading 1D barcodes type EAN128
- when entering a movement from a small terminal, adding the last status of the scanned object (present / absent) and a timer to limit server queries
- addition of auto-completion in some drop-down boxes
- In search of a sample, it is now possible to search up to 3 metadata criteria, which operate either in "and" mode (different fields) or in "or" mode (identical fields). For performance reasons, the fields that can be used for the search must have been described as such (index creation)
- the term "project" has been renamed "collection", both in the application and in the database
- better definition of the dates associated with the samples: creation in the database, sampling, and adding an expiry date
- it is now possible to search for a sample by date (creation, sampling, expiration)
- it is possible to automatically generate the business identifier from the information entered (code to be defined by type of sample)
- The information related to the picking locations has been supplemented by GPS coordinates and a code. The coordinates are reported in the sample if it does not have one.
- it is possible to define picking locations that are only attached to a collection
- during the external import, the metadata fields can be indicated in separate columns, prefixed by "md_"
- the external import now works in "replace or create" mode, which allows to update manipulated samples in external databases
- during external importation, the parentage of a sample is now preserved (if the parent was created beforehand)
- in the generation of labels, it is now possible to print the dbuid-origin field
- it is possible to directly access a sample from its access link
- new scripts are available to facilitate the installation of a new server or update a database

Bug fixes:

- in search of samples, correction of research on metadata
- when creating labels, a bug prevented the display of metadata fields
- importing external metadata did not correctly retrieve the Json field
- correction of the password reset message
- harmonization of the wording concerning containers
- addition of additional controls during external import, with consistency check of dates
- the output of the samples, since the detail of a sample, did not succeed
- in the creation of mass movements, the external samples were not recognized
- during the external import procedure, the matching was case-sensitive, which was deleted
- in the creation of mass movements, the software did not manage correctly the fact that the same container was scanned several times
- the "back to list" link did not always return to the original list, if the user had switched from consulting a sample to a container and vice versa
- the switchover between French and English posed problems of managing the date

Version 1.2.4 of December 5, 2017

Bugfix :

- creating a login account was no longer working: the password was never registered

Version 1.2.3 of November 22, 2017


mass import now accepts the UID of the parent sample
- the "import" right is created, it allows to authorize a user to import information via csv files (mass import or another instance)
- the mass import screen has been reworked, displaying the dialogs at the top of the screen
- the performances during the search of a sample are optimized by the use of a new type of index

Bug fixes:

- during mass import, the metadata were not correctly recognized (bug introduced in version 1.2)
- the deletion of a login or an account in the management of the rights has been improved, it also removes the crossed dependences (login, declared account, presence in the groups)
- in some cases, the global search for movements did not allow to visualize the movements created during the day (upper bound)

Version 1.2.2 of November 15, 2017

- various bug fixes concerning metadata
- improved performance in sample search

Version 1.2.1 of November 03, 2017

Enhancements and new features:

- the font size is increased for small terminals (smartphones)
- the menu disappears on smartphones and is replaced by the menu selection button
- the module for creating movements on a small terminal now includes optical reading via the camera

Version 1.2 of October 20, 2017

Updated schema of the required database (COL schema, containing the data, by default). Script to use:

- col_alter_1.1-1.2.sql if you are already in version 1.1 or 1.1.0. If it is not, run the version upgrade scripts one after the other
- gacl_create_1.1.sql and col_create_1.2.sql successively to create a new dataset, or init_by_psql.sql from a command line in a Linux server, which will execute both scripts automatically

Bug fixes:

- SQL error occurred when validating multiple scans
- the window allowing multiple scans was poorly drawn
- the search for samples was triggered, even if no criterion was specified
- in display of movements, the storage location was displayed even for the movements of exit
- the labels were inconsistent on the pages of modification of the destocking reasons
- the labels were harmonized in containers, the software displayed either container or container according to the pages
- when creating a user, the password entry was tainted by some bugs that could lead to the absence of the creation of the password
- when entering metadata templates, some field names used to declare them were either in French or had spelling errors
- the installation documentation has been reviewed to better isolate the case of a single-instance server

Enhancements and new features:

- the code of the instance is now storable in the database
- in barcode scan, the program can start the search on secondary identifiers (pre-selection required)
- it is possible to import a list of sampling locations rather than manually entering them
- it is possible to visualize the input-output made by an operator
- a lexicon has been added to the help menu
- it is possible to generate QR-codes containing only a business identifier (QR-codes of very small size)
- Printing labels to a printer attached to the server was working with the linux lpr command. For Raspberry (among others), the program now supports the lp command
- a new scan module has been added. It allows to visualize where is a sample, where it was before being out of stock, and authorizes the creation of a new input movement (at the old location or not) or removal

Version 1.1 of September 01, 2017

Collec becomes Collec-Science.

Updated schemas of the required database (default GACL and COL schemas). Scripts to use:

- col_alter_1.0.8-1.1.sql, if you are already in version 1.0.8. If it does not, check your version and run the version upgrade scripts one after the other
- gacl_create-1.1.sql and col_create_1.1.sql successively, for any new installation.

Bug fixes:

- the col_alter_1.0-1.0.4.sql script contained a hard schema name

Enhancements and new features:

Mass import:

- it is now possible to indicate additional information, such as geographic coordinates or metadata associated with a sample

Storage Management:

- it is now possible to indicate, for a type of container, the number of rows and columns available
- during an input movement, it is possible to indicate the row and column number of storage
- the visualization of a container makes it possible to display the occupation grid

Sample management:

- it is possible to export a list of samples, to be able to re-import it into another database. The interface allows to indicate the values to be applied locally compared to the initial data (project, type of sample, localization ...)

Printing labels:

- it is possible to integrate the localization (sampling location)

Managing the metadata associated with a sample:

- it is possible to describe metadata, and associate them with types of samples
- by modifying a sample, it is possible to enter the metadata
- these can be embedded in a label template, and are included in the exported CSV file for off-collec-science printing
- the metadata descriptions can be exported to be reimported to another database

Consultation of the protocols:

- protocols must now be associated with projects
- only members of the project (and the administrators of the application) can download the PDF file containing its description

Rights and Entitlements Management:

- installing a new version of the application engine
- for the users identified in the local database, it is now possible for them to request a reset of the password (requires in advance that the email address has been filled in, and that the server supports the sending of mails)
- access to administration modules requires re-identification
- in case of repeated failures of connection, an email alert is sent to the administrators (their email must have been declared beforehand, the server must authorize the sending of mails)
- the connection to a CAS server has been corrected. The entire identification procedure has been reviewed

Version 1.0.8 of June 02, 2017

Update of the necessary database

Bugfix :

- when modifying a type of operation, the protocol already entered was not displayed correctly
- in the list of operations, sorting did not work
- once a container or sample deleted, the search box took as arguments the parameters of the deleted object
- in the standard coding of the database (utf-8), in the search boxes of samples or containers, if a drop-down list was used, the search time was very long. The problem has been fixed by deleting the maximum number of objects displayed and requiring to indicate at least one search criterion

New feature:

- when launching the application, the version of the database is now verified
- an automatic database generation script is now available for new installations

Version 1.0.7a of May 12, 2017

Bugfix :

- generated tags were not sorted
- if the sample came from another database, the sort on the UID in the table was no longer numeric, but alphabetical (moving the original UID in the Other identifiers column)

Version 1.0.7 of May 10, 2017

Bug fixes:

- in mass import, the status of containers or samples are mandatory, but it was not specified
- since the detail of a container, the list of the samples did not display the data for all the columns, whose secondary identifiers
- in label generation, if a field was not specified in the QR Code, it was not available for display in the body of the label

New features or Enhancements:

- it is now possible to create a new sample or a new container without launching a preliminary search (this disturbed the users)
- labels: it is possible to display the product used for storage (column storage_product)
- printing labels: it is now possible to use another model than the one associated with the type of container

Version 1.0.6a of April 03, 2017

Fixed a bug:

- when entering a movement from the detail of an object, the list of containers associated with a type was not displayed

Version 1.0.6 of March 03, 2017

Updating the necessary database (script install / col_alter_1.0.5-1.0.6.sql)

Bug fixes:

- the modification of the subsamples did not work
- Several anomalies prevented the user from changing a password. After editing, the screen was blank.
- in mass import, if the container_parent_id field was filled, and no container was specified, the movement was not generated
- the program allowing the reading of the scans removes the spaces potentially added by the hand shower before the wording read
- the storage / range column has been renamed to storage / storage_location

New features and Enhancements:

- in the sample table, the parent sample is now displayed
- the sample table can now be exported in various formats
- It is now possible to indicate the identifier of the original database of a sample. This makes it possible to scan a tag generated by another implementation of the application, to facilitate exchanges. Added field: sample / dbuid_origin, expected format: db: uid
- in the detail of a sample or a container, the user now has simultaneous access to input or output movements (previously, only the opposite operation was possible)
- when entering an input movement from the detail of an object, the name of the container is displayed if its uid is entered manuallyainer est affiché si son uid est saisi manuellement

Version 1.0.5a of February 08, 2017

Fixed a bug preventing the deletion of a container

Version 1.0.5 of February 02, 2017

Updating the necessary database (script install / col_alter_1.0.4-1.0.5.sql)

Bug fixes:

- When assigning management rights to projects, LDAP or inherited groups were not properly processed
- Fast entry of samples, the container was not properly read after the first movement. In case of code error, the uid was not correctly erased
- the label model was not deleted after generation in the temporary folder, which precluded the development phases


- addition of a table of sampling zones: it is now possible to attach a sample to a previously defined geographical area (usable in search of samples)
- it is now possible to scan barcodes that contain business identifiers, and that have not been generated by the application (either 1D barcode with the identifier, QR Code with the identifier or an http address)
- csv export (to generate labels with third party software) now includes xy coordinates


- Adding the installation procedure of PHP7 with Debian 8

Version 1.0.4 of January 18, 2017

Updating the necessary database (script install / col_alter_1.0-1.0.4.sql)

Bug fixes:

- reading a QR Code from a camera did not work if the camera used did not have a rear camera (environment camera)
- the selection of the type of container did not work if there was only one in a family of containers
- the search for containers did not work in capturing a movement
- when entering a sample, the type of container was not explicit enough


- the date of the last movement of the objects is displayed in the lists
- the creation date of the objects was passed in date / time
- it is now possible to integrate the GPS position of an object in a label or in the QR Code
- it is now possible to integrate the creation date of an object in a label or in the QR Code
- by modifying an object, the map is now displayed, and it is possible to position the location of the object by clicking on it
- In modification of an object, it is possible to position the object from the estimated position of the terminal (either by using the GPS coordinates for smartphones or tablets, or the location calculated from the computer network)

Setting :

- 3 new parameters can be defined, which concern the pre-positioning of the map when no coordinates have been entered: $ mapDefaultX and $ mapDefaultY center the map on the indicated point, $mapDefaultZoom is the default zoom factor


- the installation and configuration manual contains a new appendix that explains how to set up the synchronization of two postgresql servers, to avoid losing information
- a new section has been written to explain the operations to be performed during a software update

Version 1.0.3 of December 08, 2016

Bug fixes:

- table generation script: the project_group table was incorrectly named
- file param.inc.php.dist: the schemas for the connection to the main database were incomplete (variable $ BDD_schema)

Version 1.0.2 of December 02, 2016


- correction of the parameters to indicate for a good management of the multi-bases (access to the param.ini file)
- adding configuration for identification in HEADER mode


- the title of the tab is now configured from the title given to the application in the variables (function necessary for multi-databases)
- addition of the possibility of connection in HEADER mode (login transmitted in an HTML header variable by an identification proxy server, such as LemonLdap, for example)

Bug fixes:

- it is now possible to declare the same LDAP group multiple times to give it different rights

Version 1.0.1 of November 24, 2016


- display of the last user connection
- addition of a control on the absolute duration of the session
- addition of logs in syslog for connection and disconnection

Bug fixes:

- addition of the recording of the logs during the reconnection by token
- Fixed a menu viewing bug in production mode
- the link to reservations did not work in the detail of a container or sample


- replacement of Smarty version by 3.1.30

Version 1.0 of October 25, 2016

First production version

Built-in features:

- seizure of objects (containers, samples)
- creation of movements with reason for leaving the stock if necessary
- booking an object
- creation of a sample from another sample (extracted documents, p.
- subsample management: input, output of subsamples of a sample
- adding attachments to an object (photos p.e.), displaying the most recent photo in the list of objects
- mass import
- generation of labels incorporating a QR Code, scan from a handheld shower or a tablet or smartphone type terminal and rapid generation of an input or output movement
- mass generation of input or output movements (delayed mode spray)