16. Data Import

[MintooXavier]

Brief description: This feature is used to test the data import feature in REDCap.

User spec: https://github.com/CCTC-team/redcap_cypress/blob/redcap_val/user_requirement_specification/core/16_data_import.spec

Feature link: https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.100%20-%20Import%20Templates%20-%20Columns%20%26%20Rows.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.200%20-%20Create%20%26%20Modify%20Records.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.300%20-%20REDUNDANT.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.400%20-%20Field%20Validation.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.500%20-%20Choices%20for%20Radios%2C%20Dropdowns%2C%20Checkboxes.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.600%20-%20Survey%20Data%20Import.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.700%20-%20Longitudinal%20Data%20Import.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.800%20-%20Repeat%20Instrument%20Import.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.900%20-%20Import%20Restrictions.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.1000%20-%20Access%20Restrictions.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.1200%20-%20Overwrite%20Existing%20Data.feature https://github.com/CCTC-team/redcap_rsvc/blob/redcap_val/Feature%20Tests/B/Data%20Import_16/B.3.16.1300%20-%20Data%20Import%20-%20DAGs.feature

Pre review:

• [x] Script(s) targets the correct feature sufficiently
• [x] The user requirements are met

Post review:

• [x] Script(s) targets the correct feature sufficiently
• [x] Script(s) appropriately tests the feature
• [x] Scripts are run on CCTC_REDCap_Docker
• [x] Scripts are run on the REDCap version being validated

[MintooXavier]

Scripts Pre-reviewed:

1. B.3.16.100 - Import Templates - Columns & Rows
2. B.3.16.200 - Create & Modify Records.feature
3. B.3.16.300 - REDUNDANT
4. B.3.16.400 - Field Validation.feature
5. B.3.16.500 - Choices for Radios, Dropdowns, Checkboxes
6. B.3.16.600 - Survey Data Import
7. B.3.16.700 - Longitudinal Data Import - verify data before and after import
8. B.3.16.800 - Repeat Instrument Import - verify data before and after import
9. B.3.16.900 - Import Restrictions
10. B.3.16.1000 - Access Restrictions
11. B.3.16.1200 - Overwrite Existing Data.feature
12. B.3.16.1300 - Data Import - DAGs

[MintooXavier]

1. B.3.16.100 - Import Templates - Columns & Rows

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Modified script and pushed to branch MX_v13.8.1

2. B.3.16.200 - Create & Modify Records.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Script Updated to Validate Data Changes Post-Import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

3. B.3.16.1300 - Data Import - DAGs

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Steps added to verify data before and after import
   • Added steps to verify wrong DAG names cannot be imported. New CSV file created for this and pushed to redcap_val in redcap_cypress repo. Link: https://github.com/CCTC-team/redcap_cypress/blob/redcap_val/cypress/fixtures/import_files/B.3.16.1300_DataImport_Dag_Bad.csv
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

4. B.3.16.400 - Field Validation.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Added steps to verify data before and after import
   • Change the value of bdate in csv file (import_files/B.3.16.400_DataImport_Rows Corrected.csv) as DB already contains the value of 07-07-1940. Changed CSV file is pushed to redcap_val branch in redcap_cypress repo. Link: https://github.com/CCTC-team/redcap_cypress/blob/redcap_val/cypress/fixtures/import_files/B.3.16.400_DataImport_Rows%20Corrected.csv
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

5. B.3.16.500 - Choices for Radios, Dropdowns, Checkboxes.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Added steps to verify data before and after import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

6. B.3.16.600 - Survey Data Import.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Added steps to verify data before import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

7. B.3.16.700 - Longitudinal Data Import.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Added steps to verify data before and after import
   • Delete data while moving to Production as it is easier to verify data import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

8. B.3.16.800 - Repeat Instrument Import.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Steps added to verify data before and after import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

9. B.3.16.900 - Import Restrictions.feature

   • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
   • Steps added to verify data before and after import
   • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

10. B.3.16.1000 - Access Restrictions.feature

    • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
    • Steps added to verify data before and after import
    • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37

11. B.3.16.1200 - Overwrite Existing Data

    • Script works for v13.1.37 but needs to be modified for v13.8.1 as the view of the page has been modified.
    • This script was changed from the original script in Theresa's repo (which is correct). I have changed it back else it won't meet URS. Data verification is done from the instrument and not from report as it is easier.
    • Modified script and pushed to branch MX_v13.8.1 and MX_v13.1.37