A set of substances can be checked via the File check where a single file can be uploaded and Harmonized (Tariff) Code is generated for the structures.
Click the HS File check icon to open File check page. The Uploaded files panel lists all previous file checks of the logged-in user.
The details of the user's earlier file checks are displayed in the Summary drop-down when clicked on a row.
Even a new report can be generated from that File check from this drop-down.
In order to upload the file to be checked, click on the Browse button or drag&drop a file. A file open window will be displayed or if the service is down or the file is bigger then the size set in the application property an error message is displayed.
A large selection of industrially acknowledged standard chemical file formats is supported e.g. SDF, MRV, SMILES, MOL, and even (IUPAC or traditional) names to name a few. The complete list of supported file formats can be found here.
CSV files containing chemical structures in one-row format (MDL MOL, SMILES, SMARTS, names, CAS Registry Number®, InChI e.t.c.) can be file checked.
The file requires comma-separated values and needs to have CSV extension. dropdown appears in a red box below the filename. The drop-down lists the first line items and the user must select the column that contains the structure. The
Below this drop-down, there is the No header checkbox which needs to be checked if the first row contains a structure to be checked.
Other columns of the CSV file will be available in the Report template together, as Input data fields.
If the selected Report template contains the ID field and the file contains properties of the structures then the user is forced to select a property as the ID field.
The Check button is inactive until the ID field is not selected. If the CSV file - especially the structure column - contains an error then the File check fails with the Error during structure import message.
The file format(s) of the report can be selected here. Currently, only XLSX file format is supported.
The Report template can be selected from the drop-down. (These report templates are pre-defined by the Administrator.)
If the selected Report template contains the ID field and the file contains properties of the structures then the user is forced to select a property as the ID field.
The Check button is inactive until the ID field is not selected.
Clicking on the Check button the file upload popup will be displayed. After the file upload is finished the popup is closed and the started File check will appear in the first row of the Uploaded files table. The check of the uploaded file will be started automatically and can be monitored in that row.
The progress of the ongoing file check can be monitored in the drop-down too : Check execution time , Input count,, Error count show the interim results.
When the check is finished the Check finished at cell will be filled and the Progress cell will change to Done - showing the time that was required for the checking process and the report generation process will be started.
The Check finished at and the Progress cells will show Canceled when the File check was interrupted by the user - clicking the Cancel this job - and will show Error when the File check fails due to e.g. a structure import error.
Clicking on a row of the Uploaded files table displays the Summary drop-down with the detailed results and the Generated reports table.
History of all executed File checks - made by the logged-in User - will be displayed in the Uploaded files table.
The Uploaded files table contains all file checking jobs the user has run. (15 rows per page are displayed.)
| Each row contains the following fields: | Field name | Explanation |
|---|---|---|
| Uploaded file name | name of the uploaded file | |
| Download last reports | download links of the already generated reports | |
| Input | count of input substances | |
| Hit | count of controlled substances | |
| Passed | count of non-controlled substances | |
| Error | count of errors | |
| Upload started at | date and time when the file upload was started | |
| Check finished at | date and time when the file check was finished | |
| Progress | % progress bar of the running job / Done (time of check) / Canceled / Error | |
| Actions | the actually running job can be stopped if Cancel this job is visible here |
Clicking on a row displays the Summary table of the selected File check in a dropdown. (To close the dropdown click on the row again.)
The checking details of an uploaded file are displayed in the Summary dropdown which can be opened by clicking on a row in the Uploaded files table.
| Field name | Explanation |
|---|---|
| File | filename of the uploaded file |
| User | logged in user's ID |
| Countries | |
| Classifications | |
| Categorize as | |
| Max atom count | filters out molecules having more heavy atoms than this |
| Upload started at | date and time when the file upload was started |
| Check finished at | date and time when the checking was finished |
| Check execution time | difference between Upload started and Check finished |
| Error count | count of erroneous substances |
| Input count | count of input substances |
| Against countries/category groups | categories or category groups the check was run against |
| Date of regulations | selected date of regulations for the check |
| Knowledge base version | version of the knowledge base at the check |
| Software version | version of the software at the check |
New reports of an earlier finished File check can be generated from the Summary drop-down by selecting a Report template from the dropdown list.