Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Contact Us
  • Home
  • CDMS
  • Castor CDMS Manual
  • Collect data

Bulk import of email addresses in CDMS

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • CDMS
    Castor CDMS Manual Castor CDMS Calculations Manual Frequently Asked Questions Articles for Data Managers Castor CDMS Compliance Release Documents
  • eConsent
    Castor eConsent Manual Castor eConsent Compliance Release Documents
  • SMS
    Castor SMS Manual Castor SMS Compliance Release Documents
  • Castor Connect
    Castor Connect Compliance Release Documents Castor Connect Manual Castor Connect - Participant Quick Start Guide
  • Helpdesk
    News Other Resources Castor products knowledge resources
  • Status page
  • Completing a Study
+ More

Table of Contents

Preparation to import

It is possible to import a number of email addresses into their associated participants record from a csv-file. 

This can be useful if a large number of participants need to be migrated to Castor, if surveys are sent in bulk, or if you want to send survey invitations automatically to a large number of participants using the Automation Engine.

 

The email address is stored encrypted for each participant and can only be accessed by a user with Email rights after providing their password. 

 

PLEASE NOTE: This method allows for a maximum of 600 email addresses to be imported at the same time.

 

 

Preparation to import

Before importing the email address data, please ensure that:

  • You have Import rights in the study. 
    • This is required to be able to import email addresses.
  • The variables must already exist in your study and must have assigned variable names. 
    • It is only possible to import data into fields where variable names are defined. 
    • Data will not be imported into fields which contain only labels and where variable name is not defined.
    • The variables must not be part of a survey
    • More on this can be found in the article: Import study data in CDMS 
       
  • To update ('overwrite') existing email addresses that have been already entered, it is necessary to have Email rights. 
    • Without the Email rights, an error message will appear that it is not possible to update an existing email address for a participant.
  • Make sure that the import file contains at least one datapoint (variable in the header of the file). 
    • It is not possible to import email addresses alone and at least one data point should be provided when importing email addresses. 
    • The data point (variable name) must be from the study forms, not being part of a survey
       

Trying to import only email addresses without any data will result in a warning message: 

For example, in the table below, there is a reference to the variable patient_enrolled, for which it corresponds to the value of 0 (for No) or 1 (for Yes), thus the import will be successful. 

If the column with the variable, or values is missing, you will receive the error message from above.
 

 


There are two possible scenarios when importing email addresses:

  • New participants need to be created with an email address
  • An email address should be added to the existing participant

Creating new participants with an email address

  1. Prepare a CSV file containing columns with participant ID, site abbreviation, and email address:

  2. Click on the Import button under actions in the Participants tab
  3. Select the file you want to import
  4. Select the column of the participant ID as it is in your file. In the example, the participant ID is in column A
  5. Select the option to create participants that do not exist
  6. Select the column of the site abbreviation as it is in your file. In the example, the site abbreviation is in column B
  7. Select the option to import email addresses
  8. Provide the correct password
  9. Indicate the column in the CSV document where the email address is stored
  10. If the study already contains survey invitations, then you can decide if you want to update the email addresses in the existing survey invites with the ones you're importing.


 

Importing an email address to existing participant

In case you would like to import email addresses for the already existing participants, the CSV file should only contain a participant ID and an email address (+the mandatory variable, as mentioned above):

Repeat steps 2-10, but de-select the option 'Create participants that do not exist'


 

edc/cdms email import

Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Entering repeated data in CDMS
  • Doing data entry in CDMS
  • Delete or archive a repeating data instance in CDMS
  • Mark fields and visits/forms as missing in CDMS
ISO 27001
FDA - 21 CFR part 11
ICH GCP compliant
HIPAA compliant
CDISC
ISO 9001
gdpr compliant

Products & Industries

  • Electronic Data Capture (EDC)
  • ePRO
  • eConsent
  • Decentralized Clinical Trials (DCT)
  • Clinical Data Management
  • Medical Device & Diagnostics
  • Biotech & Pharma
  • CROs
  • Academic Research

Resources

  • Thought Leadership
  • Blog
  • Castor Academy
  • Knowledge Base

 

Company

  • About Us
  • Careers
  • News
  • Contact Support
  • Contact Us

Legal & Compliance

  • Terms of Use
  • Privacy & Cookie Statement
  • Responsible Disclosure Policy
  • Good Clinical Practice (GCP)
  • ISO Compliance Certificates
  • GDPR & HIPAA Compliance
  • Security Statement

© 2022, Castor. All Rights Reserved.

Follow us on social media


Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand