NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Old Version 33

changes.mady.by.user Warzel, Denise (NIH/NCI) [E]

Saved on

compared with

New Version 34

changes.mady.by.user Warzel, Denise (NIH/NCI) [E]

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Import from REDCap Data Dictionary Format

The From Import Template is an xslm filetype ad contains several Excel Macros, so please be sure to select "Enable Macros" when opening the template.

  1. Paste your content into the template starting on Row 3. At a minimum you must run the Macro "Standardize", see instructions below.
  2. If importing a PhenX REDCap Data Dictionary, you must run "Standardize", then "PhenxStandarize".
  3. "CombineZip" is optional, it automates copying your content into the template from one or more REDCap dictionary files. See instructions below. 
  4. Save file as csv.
  5. Run Form Import from Manage>>Manage Data (or your bookmarked Favorites)
Running the Macros

There are 3 macros in the Excel Template. The Macro run key sequence can be viewed by selecting "Tools" from the Excel menu bar, then "Macro". 

Macro NameDescriptionExecute macro
CombineZipThis macro allows the user to import one or more forms in REDCap Data Dictionary format into the Form Template from a desktop folder.  This allows the user to run Form Import on a file containing multiple forms instead of one form import at a time. After choosing the keys as indicated in Execute Macro, select a Folder from your desktop and click on the forms to import them into the spreadsheet. Run Standardize, then PhenXStandardize for PhenX forms.Choose "Option" + "Command" + "w"
StandardizeEach row must have a Section Header and a few other details. This macro transform content from REDCap structure into the structure suitable for caDSR Form Import.Choose "Control" + "Shift" + "x"
PhenxStandardizeFiles sent to us by PhenX team contained a row with Question Text "Record ID", and the Protocol ID was inserted into the Field Note Column. This macro removes the extra row for "Record ID", and clears the "Field Note" columnChoose "Control" + "Shift" + "t"
Filling the template with form dataThe 1st row of headings are the REDCap DD headings. The 2nd row of headings match caDSR headings. Enter a short name in the Variable / Field Name, this can be used for matching to an existing CDE. In future release it will be added as a Question Short Name. Paste content into the template starting in the 3rd row. Please see the template for the mappings between the REDCap Data Dictionary column names and the caDSR form column names.
Form ContextREDCap does not have a column for Context. In Sprint 41 Context for all the forms in the form templates is selected after importing the template into caDSR.

...