...
| Expand |
|---|
| title | Click here to view the steps... |
|---|
|
Go to the home page and click on 'Collection Protocols' card card. Click on 'View Details' icon of the specific protocol where auto-barcoding needs to be enabled. Click on 'Settings' tab on the left and select 'Label Format and Print' option. Click on 'Edit' and specify then 'Show advanced settings' Enable specimen barcoding under miscellaneous settings Specify the format in 'Specimen Barcode Format' field
 Image Removed Image Added
|
Configure format at the system level
...
How to reset barcode sequences?
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 specimen barcodes need to start from the last number of legacy data. This is achieved using SQLs.
| Expand |
|---|
| title | Click here to view SQLs... |
|---|
|
| Token | SQL to reset sequence |
|
|---|
SYS_UID(n) | insert into key_seq_generator
(key_value, key_sequence_id, key_type)
values
('SYS_UID', <max_number>,'SPMN_BARCODE');
Note: If in the table, a record already exists for 'SYS_ID' and 'SPMN_BARCODE' then update the row with key_sequence_id using below sql.
update
key_seq_generator
set
key_sequence_id = <new_value>
where
key_type = 'SPMN_BARCODE' and
key_value = ‘SYS_UID’;
|
| CP_UID(n) | insert into key_seq_generator
(key_value, key_sequence_id, key_type)
values
('CP_UID_<CP_ID>', <max_number>,'SPMN_BARCODE');
Note: If in the table, a record already exists for 'SYS_ID' and 'SPMN_BARCODE' then update the row with key_sequence_id using below sql.
update
key_seq_generator
set
key_sequence_id = <new_value>
where
key_type = 'SPMN_BARCODE' and
key_value = 'CP_UID_<CP_ID>'; |
|
|
...