Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Login to OpenSpecimen application and create a query with filter 'Registration ID'→ Exists and select the specific collection protocol.
  2. Click on 'View records' and select the columns 'Registration ID', 'CP short title' and 'PPID'
  3. Click 'Export', which will download a file with the results.
  4. Update the PPID to append the CP code as a prefix. For example 0012 0013 is the PPID which changes to 'BC_00120013'
  5. 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
  6. Once uploaded, check the past import jobs for the status of the import.
  7. When the job is successful, all the PPID will be updated

...