Page History

...

• Templates contain Data Validation for several columns that are found on several of the templates end users avoid errors and streamline completing the spreadsheets. 
  • All templates - Context
    • • Drop down of all valid Contexts
  • Templates with Macros
    • CDE Match: "Opt"+"CMD"+"t" to transform content into the correct format for CDE Match. After filling in your column headings and permissible values, the macro will take each column heading and permissible values and create a new "Transform" sheet containing one row per heading/unique permissible value combination. For example, if the column has 5 permissible values, there will be 5 rows in the transformed sheet. Please remember to save as cvs before running CDE Match.

    • Form Import: "Shift" + "CMD" + "t" to transform content into the correct format for importing. If you are using a REDCap data dictionary csv file, cut and paste your content into the template starting on Row 3, Column E "Variable / Field Name".

      • The macro will:
        • Add 4 columns to the worksheet. (Leave "DO NOT USE" empty, enter your "Batch User Name", a "Batch Name" on each Row. The combination of "Batch User Name" AND "Batch Name" must be unique for each imported template.)
        • Generate a unique "Seq ID" for each row
        • Copy "Form Name" into Column G, Section Header for each row since this is a required field in caDSR.  

• • Import DEC and Import VD
    • • Drop Down of the Standard Conceptual Domain Names, the CD ID will automatically populate
  • Import Value Domain
    • Drop Downs for Context, Format, UoM, Datatype, and Type (Enumerated/NonEnumerated)
  • Import Designations - this is used to import the "USED_BY" designation as well as all AI types for Data Elements, Data Element Concepts, Value Meanings and Value Domains
    • Drop Downs for AI type, Alternate Name, Alternate Name Type, Alternate Name Context
    • For Alternate Name, when the Alternate Name Type is "USED_BY" the Alternate Name will automatically populate the selected must be the same as the Alternate Name Context
  • Import PV/VM 
    • Drop Down for VM String Type
    • Drop Down for optional VM Alternate Name Type
  • VM Match
    • No drop downs, the import process will try to match the terms in the file to an exiting VM if one exists that exactly matches the VM label, if no VM is found, it will try to match to an NCI Thesaurus concept.

The Batch Owner and Batch User columns can be any text that you provide. The system does not validate these columns. 

...