Skip to main content

View external lab data details

In the EDC application, instead of entering subject lab results in respective lab test forms of the DATA ENTRY tab and then configuring labs, normal ranges, and other details manually in the system, you can import the lab data from an external file in the XLSX or CSV format.

Once the file is added and its values are mapped to respective forms and visits in the system, you can synchronize the configurations to the respective EDC form(s). Then you can view the data that is synced to the EDC forms collected in one comprehensive table.

To view the external lab data details

  1. In the EDC application header, select the STUDY INFO tab.

  2. From the left pane, select Lab > External Lab Data.

  3. On the page that opens, select the External Lab Data Details tab.

  4. In the table that opens, view all the variables and data imported to the EDC forms from the external lab data file.

    Viewing external lab data
    Figure 1. Viewing external lab data

You have viewed the external lab data imported to EDC forms. You can also export the details of this table to use the data offline.

Export external lab data details

In the EDC application, instead of entering subject lab results in respective lab test forms of the DATA ENTRY tab and then configuring labs, normal ranges, and other details manually in the system, you can import the lab data from an external file in the XLSX or CSV format.

Once the file is added and its values are mapped to respective forms and visits in the system and then synchronized to the respective EDC form(s), you can view the data that is synced to all the forms collected in one comprehensive table. You can also export this data as an XLSX file to work with it offline.

To export the external lab data details

  1. In the EDC application header, select the STUDY INFO tab.

  2. From the left pane, select Lab > External Lab Data.

  3. On the page that opens, select the External Lab Data Details tab.

  4. From the workspace toolbar, select Export export_icon.png.

    Exporting external lab data
    Figure 1. Exporting external lab data

  5. The dialog appears notifying you that the process of export is in progress and once the file is ready, you can download it. Select ok_button_white_red.png to close the dialog.

    Receiving export confirmation notification
    Figure 2. Receiving export confirmation notification

  6. From the workspace toolbar, select History history_icon.png.

    Accessing export history
    Figure 3. Accessing export history

  7. In the Export History dialog that opens, next to the needed file, select Download download_icon.png.

    Downloading exported external lab data file
    Figure 4. Downloading exported external lab data file

Once downloaded, the XLSX file becomes available on your computer.

In this section: