Exporting subject data

When exporting subject data, all historical subject response data is exported, including any data entered into questions that have since been removed from an eForm or questions on an eForm that has since been removed from a visit. Once entered into MACRO, response data is permanently stored in the subject audit trail.

Select this option to export subject data in a format suitable for import into a MACRO database. DCRs, SDV marks, notes and freeze/lock messages are always exported with a subject.

To export subject data, you need the 'Export subject data' permission. This feature has a database-wide scope.

Select Tasks > Subject > Export. The Export Subject window is displayed.
You can choose to export all subjects from a study or a site or you can select an individual subject. Click the crosses to expand the study/sites and select the subject/s you wish to export.
Click Export.
Select the location to which you wish to export the file. The default location is the Out Folder of the application folder.
Click Save. The data is exported as a .prd file. The files contain all the internally assigned details of the subject such as ID as well as all of the clinical data that has been collected for that subject.
You can either export another study, or click Close to close the Export box.

The exported files can be imported into a MACRO database of any format, regardless of the type of database from which they have been exported.

MACRO is compatible with the CDISC standard created by the Clinical Data Interchange Standards Consortium (CDISC). MACRO subject data can be exported in xml format but you must first export the study to CDISC.

DCRs, SDV marks, notes and lock/freeze messages are not included in CDISC exports/imports.

To export subject data to CDISC, you need the 'Export subject data' permission. This feature has a database-wide scope.

Select Tasks > Study > Export to CDISC to export the study containing the subjects you wish to export, selecting the Out Folder of the application folder as the location for the file.
Select Tasks > Subject > Export to CDISC. The Export Subject window is displayed.
You can choose to export all subjects from a study or a site or you can select an individual subject. Click the crosses to expand the study/sites and select the subject/s you wish to export.
Click Export.
Select the location to which you wish to export the file. The default location is the Out Folder of the application folder.
Click Save. The data is exported as a .xml file. The files contain all the internally assigned details of the subject such as ID as well as all of the clinical data that has been collected for that subject.
You can either export another study, or click Close to close the Export box.

Example of the xml file for a set of subjects

The ability to export subject data in a format suitable for import into SPSS is available as a standard Data Entry module home page report. The SPSS Export report must be configured in the REP module to display as a link on the home page.

How to run the report...