Importing subject data

1. Before attempting to import subject data, ensure that the correct study definition and site code(s) exist in the current database.

2. Select Tasks > Subject > Import. The Import Subjects window is displayed.

2. Select the .prd file that you wish to import. By default, subject data files exported from MACRO are stored in the Out Folder of the application folder.

3. Select the file and click 'Open'. If you are importing subject data that already exists in the database and the study status is set to 'In Preparation', you will be asked if you wish to overwrite it. If the study status is not 'In Preparation' you cannot overwrite subject data.
   
   Warning: If you choose to overwrite, all existing data for the subject will be lost. This is final and cannot be reversed.

   • Click 'Overwrite this subject' to overwrite the existing data for the subject identified in the message or click 'Overwrite for all' to overwrite all existing data.

   • Click 'Ignore this subject' to retain the existing data in the current message or click 'Ignore for all' to retain all existing data.

   • Click 'Show Details' to view the details of the subject identified in the message.

4. If you wish to check that the data has been successfully imported, open the list of subjects in the DE/DR module. The imported subjects should be included in the list of subjects and the new data will be included in the corresponding eForms.

If you wish to import notes, DCRs, SDV marks and freeze/lock messages, ensure that these have been included in the export file.

MACRO is compatible with the CDISC standard created by the Clinical Data Interchange Standards Consortium (CDISC). Subject data can be imported into MACRO in xml format.

 

1. Before attempting to import subject data, ensure that the correct study definition and site code(s) exist in the current database.

2. Select Tasks > Subject > Import from CDISC. The Import Subjects window is displayed.

2. Select the file that you wish to import. By default, subject data files exported from MACRO are stored in the Out Folder of the application folder.

3. Select the file and click Open. If you are importing subject data that already exists in the database and the study status is set to 'In Preparation', you will be asked if you wish to overwrite it. If the study status is not 'In Preparation' you cannot overwrite subject data.
   
   Warning: If you choose to overwrite, all existing data for the subject will be lost. This is final and cannot be reversed.
    

   • Click Yes to overwrite the existing data in the current message and Yes to All to overwrite all existing data.

   • Click No to retain the existing data in the current message and No to All to retain all existing data.

   • Click Show Details to view the details of the data.

4. If you wish to check that the data has been successfully imported, open the list of subjects in the DE/DR module. The imported subjects should be included in the list of subjects and the new data will be included in the corresponding eForms.

On import, the CDISC data file is converted into xml and imported into MACRO using functionality from the Batch Data Loading module. Example of the xml file for a set of subjects