| 20 | | A manual update is needed to fix `PoolConc` values for existing `*.dil` extracts. More instructions will follow. For now, see #507. |
| | 20 | |
| | 21 | Due to a bug (see #507), all `*.dil` extracts have been registered with an incorrect value for the '''!PoolConc''' annotation. This need to be fixed by a manual export/import procedure. |
| | 22 | |
| | 23 | 1. To find the libraries in question go to the '''Biomaterial LIMS->Extracts''' page and filter on '''name=%.dil'''. |
| | 24 | 2. To avoid rounding errors in the exported data go to '''BASE->Preferences''' and set '''Decimals=all'''. |
| | 25 | 3. Use the '''Table exporter''' plug-in to export a tab-separated file with '''Name''' and '''Original quantity''' columns. |
| | 26 | 4. Download the exported file to your computer and open in a spreadsheet program. |
| | 27 | 5. Add a new column '''!PoolConc''' and use the following formula to calculate the values: `=5 * <quantity> / 1000` |
| | 28 | 6. Save the results as a tab-separated file and upload it to BASE. |
| | 29 | 7. Use the annotation importer to update the '''!PoolConc''' values. |
