This page describes the commun particularities for the Synthesis Reaction tests
Summary
ELN Data
The following tables, extracted from the ELN spreadsheets, are used for the enrichment of the raw data.
These files are available on :
| Environment | Path |
|---|---|
| DEV | D:\ETL\DATA\DEV\RnI\Silica\XML SILICA\XML Synthesis\PARSED_XML_SYNTHESIS\Useful information |
filtration_raw_data_link
This table lists the links for the raw data files that need to be extracted from the Lab servers for each sample_id. It is used by the Python scripts download_filtration_*.py (* stands for the scale: i.e. 170L, 2500, etc.) and by Talend jobs responsible for getting files from Google Drive. It contains the following fields:
- unique_id
- study_id
- sample_id
- filtration_file_link
- filtration_scale_L
- filtration_plate_equipment_name
filtration_eln_data
In the beginning of the Python script for computing, we extract the following values from the file filtration_eln_data. This table contains the fields extracted from ELN that will be used in the computation of new columns and values. It is used by the Python scripts compute_synthesis_*.py (* stands for the scale: 25L, 170L, 2500L). It contains the following fields:
- unique_id
- study_id
- sample_id
- filtration_scale_L
- filtration_number_of_chamber
- filtration_cake_tickness_mm
- filtration_reactional_slurry_prct_SiO2_prct_w
- filtration_cake_mass_kg
- filtration_cake_sul_content_5_prct_SiO2_prct_w_wSiO2
- filtration_plate_filtering_area_m2
- filtration_cake_dry_content_prct
- filtration_cake_pH_prct
- filtration_start_hour
- filtration_end_hour