OpenSpecimen allows to auto-generate labels based on various tokens. For more details, refer to Label configuration.
When a new center starts using OpenSpecimen, the legacy data might be in other sources like Excel, different DB, etc. Once the legacy data is imported, the sequences of new participants and specimens need to start from the last number of legacy data. To achieve this, the administrator has to reset the sequences based on the tokens used. Currently, this is achieved using SQLs. Below are some examples:
Please take a backup of the database before running any SQLs
| Warning |
|---|
If there are sequence records for they the same key_type and key_value, it needs to be deleted before new entries are created |
...