...
- Login to OpenSpecimen application and create a query with filter 'Registration ID'→ Exists and select the specific collection protocol.
- Click on 'View records' and select the columns 'Registration ID', 'CP short title' and 'PPID'
- Click 'Export', which will download a file with the results.
- Update the PPID to append the CP code as a prefix. For example 0012 0013 is the PPID which changes to 'BC_00120013'
- From the participant list page of the CP, go to 'Import', select record type - 'Participants', and download template. From the query export file, copy the values under relevant columns in template file - 'Participant_Registration ID' from 'Identifier', 'Collection Protocol_Short Title' from 'CP Short Title' and 'Participant_PPID' from 'PPID'. Select import type as 'Update', upload the updated CSV file and click on 'Validate and Import'. Note: Disable the PPID format at the CP level if exists before importing the file
- Once uploaded, check the past import jobs for the status of the import.
- When the job is successful, all the PPID will be updated
...