[caDSR] All Content FeedConfluence Syndication Feedhttps://wiki.nci.nih.govTemplates and Instructions for Bulk Imports and MatchingWarzel, Denise (NIH/NCI) [E]tag:wiki.nci.nih.gov,2009:page-477497179-442024-03-26T22:23:26Z2022-01-11T18:15:07Z<div class="feed"> <p>
Page
<b>edited</b> by
<a href=" https://wiki.nci.nih.gov/display/~warzeld
">Warzel, Denise (NIH/NCI) [E]</a>
</p>
<div style="border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 10px;">
<p>Some of the features in caDSR II allow you to process content from a CSV file for bulk/batch importing to create new content. To view or use these features, log in as described in <a href="https://wiki.nci.nih.gov/display/caDSR/Logging+In">Logging In</a>. These features need specially formatted templates. </p><div class="panel" style="border-color: silver;border-style: solid;border-width: 1px;"><div class="panelHeader" style="border-bottom-width: 1px;border-bottom-style: solid;border-bottom-color: silver;"><b>Contents of This Page</b></div><div class="panelContent">
<p><style type='text/css'>/*<![CDATA[*/
div.rbtoc1711705107411 {padding: 0px;}
div.rbtoc1711705107411 ul {margin-left: 0px;}
div.rbtoc1711705107411 li {margin-left: 0px;padding-left: 0px;}
/*]]>*/</style><div class='toc-macro rbtoc1711705107411'>
<ul class='toc-indentation'>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-Conventions'>Conventions</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-Templates'>Templates</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-Tips'>Tips</a>
<ul class='toc-indentation'>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforAllImports'>Tips for All Imports</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforCDEImports'>Tips for CDE Imports</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforCDEMatch'>Tips for CDE Match</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforDECImportandUpdate'>Tips for DEC Import and Update</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforDECMatch'>Tips for DEC Match</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforVDImports'>Tips for VD Imports</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforPVVMImports'>Tips for PV VM Imports</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforVMandConceptMatch'>Tips for VM and Concept Match</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforFormImports'>Tips for Form Imports</a></li>
<li><a href='#TemplatesandInstructionsforBulkImportsandMatching-TipsforDesignationImports'>Tips for Designation Imports</a></li>
</ul>
</li>
</ul>
</div></p>
</div></div><h1 id="TemplatesandInstructionsforBulkImportsandMatching-Conventions">Conventions</h1><p>Common usage details for the templates are that due to inclusion of the following Data Validations please follow these conventions: </p><p><br/></p><ul><li>Basics<ul><li><strong>When the provided Template has .xls or .xlsx file extension, always start with a fresh Template for each import</strong><ul><li><strong>This insures that the <em>Data Validation and Formulas</em> that are embedded in the template for drop-downs and auto-populate are correct for each Import and rows/valid choices have not been inadvertently deleted.</strong></li></ul></li><li><strong>Save-As the completed Template as .cvs before importing</strong><ul><li>NOTE: This is a common step to forget and if you try to import a .xsl or .xslx file it will cause an immediate exception "error" when clicking "Import", so check the file extension if you have a problem</li></ul></li><li>While editing the Template do not delete entire Rows or Columns<br/><ul><li>This is due to the Data Validation, if you delete rows some of the valid choices will be deleted</li><li>If you delete an entry in a cell that was auto-populated, you may lose the formula. These formulas are not essential for importing, but are helpful to avoid typos or other errors</li><li>You can use the Delete Key to clear the contents of individuals cell or cells but do not delete entire rows or columns</li></ul></li></ul></li></ul><ul><li>Templates contain Data Validation for several columns that are found on several of the templates end users avoid errors and streamline completing the spreadsheets. <ul><li>All templates - Context<ul><li style="list-style-type: none;"><ul><li>Drop down of all valid Contexts</li></ul></li></ul></li><li>Templates with Macros<ul><li><strong>CDE Match</strong>: "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.</li><li><p><strong>Form Import</strong>: "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".</p><ul><li>The macro will:<ul><li>Add 4 columns to the worksheet. <em>(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.)</em></li><li>Generate a unique "Seq ID" for each row</li><li>Copy "Form Name" into Column G, Section Header for each row since this is a required field in caDSR. </li></ul></li></ul></li></ul></li></ul></li></ul><div class="table-wrap"><table class="relative-table wrapped confluenceTable" style="width: 43.2411%;"><colgroup><col style="width: 20.1353%;"/> <col style="width: 25.2783%;"/><col style="width: 28.2091%;"/><col style="width: 26.3773%;"/></colgroup><tbody><tr><td class="confluenceTd">DO NOT USE</td><td class="confluenceTd">Batch User</td><td class="confluenceTd">Batch Name</td><td class="confluenceTd">Seq ID</td></tr></tbody></table></div><p><br/></p><ul><li style="list-style-type: none;"><ul><li>Import DEC and Import VD<ul><li style="list-style-type: none;"><ul><li>Drop Down of the Standard Conceptual Domain Names, the CD ID will automatically populate</li></ul></li></ul></li><li>Import Value Domain<ul><li>Drop Downs for Context, Format, UoM, Datatype, and Type (Enumerated/NonEnumerated)</li></ul></li><li>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<ul><li>Drop Downs for AI type, Alternate Name, Alternate Name Type, Alternate Name Context</li><li>For Alternate Name, <strong>when the Alternate Name Type is "USED_BY" the Alternate Name must be the same as the Alternate Name Context</strong></li></ul></li><li>Import PV/VM <ul><li>Drop Down for VM String Type</li><li>Drop Down for optional VM Alternate Name Type</li></ul></li><li>VM Match<ul><li>No drop downs.</li></ul></li></ul></li></ul><p><br/></p><p>The Batch Owner and Batch User columns can be any text that you provide. The system does not validate these columns. </p><h1 id="TemplatesandInstructionsforBulkImportsandMatching-Templates">Templates</h1><p>The following table lists the latest templates.</p><p>
<div class="plugin_attachments_container">
<div class="plugin_attachments_table_container">
<fieldset class="hidden">
<input type="hidden" class="plugin_attachments_macro_render_param" name="pageId" value="477497179">
<input type="hidden" name="deleteConfirmMessage" value="Are you sure you want to send the attached file "{0}" to the trash? Only a space administrator can undo this action."/>
<input type="hidden" class="plugin_attachments_macro_render_param" name="upload" value="false">
<input type="hidden" class="plugin_attachments_macro_render_param" name="old" value="false">
<input type="hidden" name="outputType" value="feed">
</fieldset>
<table class="attachments aui">
<thead>
<tr>
<th class="expand-column attachment-summary-toggle"> </th>
<th class="filename-column"> <a href="/display/caDSR/Templates+and+Instructions+for+Bulk+Imports+and+Matching?sortBy=name&sortOrder=ascending">File</a>
</th>
<th class="modified-column"> <span class="propersortedby $sortOrder"><a href="/display/caDSR/Templates+and+Instructions+for+Bulk+Imports+and+Matching?sortBy=date&sortOrder=descending">Modified</a></span>
</th>
</tr>
</thead>
<tbody>
<tr id="attachment-520357929"
class="attachment-row"
data-attachment-id="520357929"
data-attachment-idx="1">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel97" title="Microsoft Excel Sheet">Microsoft Excel Sheet</span> <a class="filename" href="/download/attachments/477497179/CDE%20Match%20Data%20Standardization%20Template%20Sprint%2041v1-01272023%20FINAL.xlsm?api=v2"
title="Download"
data-filename="CDE Match Data Standardization Template Sprint 41v1-01272023 FINAL.xlsm"
data-type="application/vnd.ms-excel.sheet.macroenabled.12"
data-linked-resource-container-id="477497179">
CDE Match Data Standardization Template Sprint 41v1-01272023 FINAL.xlsm
</a>
<span class="attachment-comment">CDE Match Template Sprint 41 with Macros</span>
</td>
<td class="attachment-created modified-column">
<span>Feb 16, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-520357929 hidden"
data-attachment-id="520357929"
data-attachment-filename="CDE Match Data Standardization Template Sprint 41v1-01272023 FINAL.xlsm">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="520357929" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="CDE Match Data Standardization Template Sprint 41v1-01272023 FINAL.xlsm"
data-file-src="/download/attachments/477497179/CDE%20Match%20Data%20Standardization%20Template%20Sprint%2041v1-01272023%20FINAL.xlsm?api=v2"
data-linked-resource-default-alias="CDE Match Data Standardization Template Sprint 41v1-01272023 FINAL.xlsm"
data-mime-type="application/vnd.ms-excel.sheet.macroenabled.12"
data-linked-resource-container-id="477497179"
data-linked-resource-id="520357929">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-526189846"
class="attachment-row"
data-attachment-id="526189846"
data-attachment-idx="2">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-powerpoint" title="Microsoft Powerpoint Presentation">Microsoft Powerpoint Presentation</span> <a class="filename" href="/download/attachments/477497179/Jira-2236-CDEMatchLogicv4.pptx?api=v2"
title="Download"
data-filename="Jira-2236-CDEMatchLogicv4.pptx"
data-type="application/vnd.openxmlformats-officedocument.presentationml.presentation"
data-linked-resource-container-id="477497179">
Jira-2236-CDEMatchLogicv4.pptx
</a>
<span class="attachment-comment">Current CDE Match Logic as of Nov. 2022</span>
</td>
<td class="attachment-created modified-column">
<span>Apr 06, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-526189846 hidden"
data-attachment-id="526189846"
data-attachment-filename="Jira-2236-CDEMatchLogicv4.pptx">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<div class="attachment-image-preview"></div>
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="526189846" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Jira-2236-CDEMatchLogicv4.pptx"
data-file-src="/download/attachments/477497179/Jira-2236-CDEMatchLogicv4.pptx?api=v2"
data-linked-resource-default-alias="Jira-2236-CDEMatchLogicv4.pptx"
data-mime-type="application/vnd.openxmlformats-officedocument.presentationml.presentation"
data-linked-resource-container-id="477497179"
data-linked-resource-id="526189846">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=Jira-2236-CDEMatchLogicv4.pptx&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-526189847"
class="attachment-row"
data-attachment-id="526189847"
data-attachment-idx="3">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-word" title="Microsoft Word Document">Microsoft Word Document</span> <a class="filename" href="/download/attachments/477497179/Jira-2236-CDEMatchInstructionsSprint42.docx?api=v2"
title="Download"
data-filename="Jira-2236-CDEMatchInstructionsSprint42.docx"
data-type="application/vnd.openxmlformats-officedocument.wordprocessingml.document"
data-linked-resource-container-id="477497179">
Jira-2236-CDEMatchInstructionsSprint42.docx
</a>
<span class="attachment-comment">CDE Match Instructions, Notes and Tips</span>
</td>
<td class="attachment-created modified-column">
<span>Apr 06, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-526189847 hidden"
data-attachment-id="526189847"
data-attachment-filename="Jira-2236-CDEMatchInstructionsSprint42.docx">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="526189847" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Jira-2236-CDEMatchInstructionsSprint42.docx"
data-file-src="/download/attachments/477497179/Jira-2236-CDEMatchInstructionsSprint42.docx?api=v2"
data-linked-resource-default-alias="Jira-2236-CDEMatchInstructionsSprint42.docx"
data-mime-type="application/vnd.openxmlformats-officedocument.wordprocessingml.document"
data-linked-resource-container-id="477497179"
data-linked-resource-id="526189847">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=Jira-2236-CDEMatchInstructionsSprint42.docx&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-546649622"
class="attachment-row"
data-attachment-id="546649622"
data-attachment-idx="4">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel97" title="Microsoft Excel Sheet">Microsoft Excel Sheet</span> <a class="filename" href="/download/attachments/477497179/S47%20Form%20Template%20With%20Macro%20v2-20231002-Clean.xlsm?api=v2"
title="Download"
data-filename="S47 Form Template With Macro v2-20231002-Clean.xlsm"
data-type="application/vnd.ms-excel.sheet.macroenabled.12"
data-linked-resource-container-id="477497179">
S47 Form Template With Macro v2-20231002-Clean.xlsm
</a>
<span class="attachment-comment">S47 Form Import with Macros-V2 20231002</span>
</td>
<td class="attachment-created modified-column">
<span>Oct 04, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-546649622 hidden"
data-attachment-id="546649622"
data-attachment-filename="S47 Form Template With Macro v2-20231002-Clean.xlsm">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="546649622" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="S47 Form Template With Macro v2-20231002-Clean.xlsm"
data-file-src="/download/attachments/477497179/S47%20Form%20Template%20With%20Macro%20v2-20231002-Clean.xlsm?api=v2"
data-linked-resource-default-alias="S47 Form Template With Macro v2-20231002-Clean.xlsm"
data-mime-type="application/vnd.ms-excel.sheet.macroenabled.12"
data-linked-resource-container-id="477497179"
data-linked-resource-id="546649622">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-552960014"
class="attachment-row"
data-attachment-id="552960014"
data-attachment-idx="5">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel97" title="Microsoft Excel Sheet">Microsoft Excel Sheet</span> <a class="filename" href="/download/attachments/477497179/S50%20VD%20Import%20Template-with%20Data%20Validation-20231113.xls?api=v2"
title="Download"
data-filename="S50 VD Import Template-with Data Validation-20231113.xls"
data-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179">
S50 VD Import Template-with Data Validation-20231113.xls
</a>
<span class="attachment-comment">VD Import Sprint 50-with Validation</span>
</td>
<td class="attachment-created modified-column">
<span>Nov 16, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-552960014 hidden"
data-attachment-id="552960014"
data-attachment-filename="S50 VD Import Template-with Data Validation-20231113.xls">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="552960014" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="S50 VD Import Template-with Data Validation-20231113.xls"
data-file-src="/download/attachments/477497179/S50%20VD%20Import%20Template-with%20Data%20Validation-20231113.xls?api=v2"
data-linked-resource-default-alias="S50 VD Import Template-with Data Validation-20231113.xls"
data-mime-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179"
data-linked-resource-id="552960014">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=S50+VD+Import+Template-with+Data+Validation-20231113.xls&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-552960018"
class="attachment-row"
data-attachment-id="552960018"
data-attachment-idx="6">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel97" title="Microsoft Excel Sheet">Microsoft Excel Sheet</span> <a class="filename" href="/download/attachments/477497179/S50%20PV%20VM%20Import%20Template-with%20Data%20Validation-20231113.xls?api=v2"
title="Download"
data-filename="S50 PV VM Import Template-with Data Validation-20231113.xls"
data-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179">
S50 PV VM Import Template-with Data Validation-20231113.xls
</a>
<span class="attachment-comment">S50 PV VM Import with Validation</span>
</td>
<td class="attachment-created modified-column">
<span>Nov 16, 2023</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-552960018 hidden"
data-attachment-id="552960018"
data-attachment-filename="S50 PV VM Import Template-with Data Validation-20231113.xls">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="552960018" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="S50 PV VM Import Template-with Data Validation-20231113.xls"
data-file-src="/download/attachments/477497179/S50%20PV%20VM%20Import%20Template-with%20Data%20Validation-20231113.xls?api=v2"
data-linked-resource-default-alias="S50 PV VM Import Template-with Data Validation-20231113.xls"
data-mime-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179"
data-linked-resource-id="552960018">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=S50+PV+VM+Import+Template-with+Data+Validation-20231113.xls&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-570949634"
class="attachment-row"
data-attachment-id="570949634"
data-attachment-idx="7">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel" title="Microsoft Excel Spreadsheet">Microsoft Excel Spreadsheet</span> <a class="filename" href="/download/attachments/477497179/Jira-3047%20S51%20CDE%20Import-DataValidation-20231206.xlsx?api=v2"
title="Download"
data-filename="Jira-3047 S51 CDE Import-DataValidation-20231206.xlsx"
data-type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
data-linked-resource-container-id="477497179">
Jira-3047 S51 CDE Import-DataValidation-20231206.xlsx
</a>
<span class="attachment-comment">S51 CDE Import - Fix Trailing Space in DEC Public ID</span>
</td>
<td class="attachment-created modified-column">
<span>Feb 23, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-570949634 hidden"
data-attachment-id="570949634"
data-attachment-filename="Jira-3047 S51 CDE Import-DataValidation-20231206.xlsx">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="570949634" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Jira-3047 S51 CDE Import-DataValidation-20231206.xlsx"
data-file-src="/download/attachments/477497179/Jira-3047%20S51%20CDE%20Import-DataValidation-20231206.xlsx?api=v2"
data-linked-resource-default-alias="Jira-3047 S51 CDE Import-DataValidation-20231206.xlsx"
data-mime-type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
data-linked-resource-container-id="477497179"
data-linked-resource-id="570949634">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=Jira-3047+S51+CDE+Import-DataValidation-20231206.xlsx&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-570949633"
class="attachment-row"
data-attachment-id="570949633"
data-attachment-idx="8">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel97" title="Microsoft Excel Sheet">Microsoft Excel Sheet</span> <a class="filename" href="/download/attachments/477497179/Jira-3004%20S51%20Designation%20Import%20Template-with%20Data%20Validation-20231208.xls?api=v2"
title="Download"
data-filename="Jira-3004 S51 Designation Import Template-with Data Validation-20231208.xls"
data-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179">
Jira-3004 S51 Designation Import Template-with Data Validation-20231208.xls
</a>
<span class="attachment-comment">S51 Designation Import - Fix Column Heading</span>
</td>
<td class="attachment-created modified-column">
<span>Feb 23, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-570949633 hidden"
data-attachment-id="570949633"
data-attachment-filename="Jira-3004 S51 Designation Import Template-with Data Validation-20231208.xls">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="570949633" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Jira-3004 S51 Designation Import Template-with Data Validation-20231208.xls"
data-file-src="/download/attachments/477497179/Jira-3004%20S51%20Designation%20Import%20Template-with%20Data%20Validation-20231208.xls?api=v2"
data-linked-resource-default-alias="Jira-3004 S51 Designation Import Template-with Data Validation-20231208.xls"
data-mime-type="application/vnd.ms-excel"
data-linked-resource-container-id="477497179"
data-linked-resource-id="570949633">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=Jira-3004+S51+Designation+Import+Template-with+Data+Validation-20231208.xls&pageId=477497179" >View</a>
</div>
</td>
</tr>
<tr id="attachment-575013333"
class="attachment-row"
data-attachment-id="575013333"
data-attachment-idx="9">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-unknown" title="File">File</span> <a class="filename" href="/download/attachments/477497179/VM%20Match%20Template_20240209%20S52.csv?api=v2"
title="Download"
data-filename="VM Match Template_20240209 S52.csv"
data-type="text/csv"
data-linked-resource-container-id="477497179">
VM Match Template_20240209 S52.csv
</a>
<span class="attachment-comment">VM Match Template Updated Headings to remove spaces S52</span>
</td>
<td class="attachment-created modified-column">
<span>Mar 12, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-575013333 hidden"
data-attachment-id="575013333"
data-attachment-filename="VM Match Template_20240209 S52.csv">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="575013333" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="VM Match Template_20240209 S52.csv"
data-file-src="/download/attachments/477497179/VM%20Match%20Template_20240209%20S52.csv?api=v2"
data-linked-resource-default-alias="VM Match Template_20240209 S52.csv"
data-mime-type="text/csv"
data-linked-resource-container-id="477497179"
data-linked-resource-id="575013333">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-575013332"
class="attachment-row"
data-attachment-id="575013332"
data-attachment-idx="10">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-unknown" title="File">File</span> <a class="filename" href="/download/attachments/477497179/Concepts%20Load%20Template%20S50.csv?api=v2"
title="Download"
data-filename="Concepts Load Template S50.csv"
data-type="text/csv"
data-linked-resource-container-id="477497179">
Concepts Load Template S50.csv
</a>
<span class="attachment-comment">Concept Bulk Load Template last updated S50</span>
</td>
<td class="attachment-created modified-column">
<span>Mar 12, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-575013332 hidden"
data-attachment-id="575013332"
data-attachment-filename="Concepts Load Template S50.csv">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="575013332" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Concepts Load Template S50.csv"
data-file-src="/download/attachments/477497179/Concepts%20Load%20Template%20S50.csv?api=v2"
data-linked-resource-default-alias="Concepts Load Template S50.csv"
data-mime-type="text/csv"
data-linked-resource-container-id="477497179"
data-linked-resource-id="575013332">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-575013334"
class="attachment-row"
data-attachment-id="575013334"
data-attachment-idx="11">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-unknown" title="File">File</span> <a class="filename" href="/download/attachments/477497179/Model%20Import%20S52.csv?api=v2"
title="Download"
data-filename="Model Import S52.csv"
data-type="text/csv"
data-linked-resource-container-id="477497179">
Model Import S52.csv
</a>
<span class="attachment-comment">Model Update Template for use with Model Import - Update S52</span>
</td>
<td class="attachment-created modified-column">
<span>Mar 12, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-575013334 hidden"
data-attachment-id="575013334"
data-attachment-filename="Model Import S52.csv">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="575013334" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="Model Import S52.csv"
data-file-src="/download/attachments/477497179/Model%20Import%20S52.csv?api=v2"
data-linked-resource-default-alias="Model Import S52.csv"
data-mime-type="text/csv"
data-linked-resource-container-id="477497179"
data-linked-resource-id="575013334">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-575013335"
class="attachment-row"
data-attachment-id="575013335"
data-attachment-idx="12">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-unknown" title="File">File</span> <a class="filename" href="/download/attachments/477497179/DEC%20Match%20Template%20S47.csv?api=v2"
title="Download"
data-filename="DEC Match Template S47.csv"
data-type="text/csv"
data-linked-resource-container-id="477497179">
DEC Match Template S47.csv
</a>
<span class="attachment-comment">DEC Match Template S47</span>
</td>
<td class="attachment-created modified-column">
<span>Mar 12, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-575013335 hidden"
data-attachment-id="575013335"
data-attachment-filename="DEC Match Template S47.csv">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="575013335" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="DEC Match Template S47.csv"
data-file-src="/download/attachments/477497179/DEC%20Match%20Template%20S47.csv?api=v2"
data-linked-resource-default-alias="DEC Match Template S47.csv"
data-mime-type="text/csv"
data-linked-resource-container-id="477497179"
data-linked-resource-id="575013335">Preview</a>
</div>
</td>
</tr>
<tr id="attachment-581009418"
class="attachment-row"
data-attachment-id="581009418"
data-attachment-idx="13">
<td class="attachment-summary-toggle">
<span class="icon icon-section-closed" title="Show more info"></span>
</td>
<td class="filename-column">
<span class="aui-icon content-type-attachment-excel" title="Microsoft Excel Spreadsheet">Microsoft Excel Spreadsheet</span> <a class="filename" href="/download/attachments/477497179/DEC%20Import%20Update%20Template-with%20Data%20Validation-20240206-S53.xlsx?api=v2"
title="Download"
data-filename="DEC Import Update Template-with Data Validation-20240206-S53.xlsx"
data-type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
data-linked-resource-container-id="477497179">
DEC Import Update Template-with Data Validation-20240206-S53.xlsx
</a>
<span class="attachment-comment">DEC Import - Update Template S53</span>
</td>
<td class="attachment-created modified-column">
<span>Mar 25, 2024</span>
<span>by</span>
<a href=" /display/~warzeld
"
class="url fn"
>Warzel, Denise (NIH/NCI) [E]</a> </td>
</tr>
<tr class="attachment-summary attachment-summary-581009418 hidden"
data-attachment-id="581009418"
data-attachment-filename="DEC Import Update Template-with Data Validation-20240206-S53.xlsx">
<td class="attachment-summary-toggle"></td>
<td class="attachment-details-wrapper" colspan="2">
<p class="attachment-labels">Labels</p>
<div class="labels-section-content content-column" entityid="581009418" entitytype="attachment">
<div class="labels-content">
<ul class="label-list ">
<li class="no-labels-message">
No labels
</li>
</ul>
</div>
</div>
<div class="attachment-buttons">
<a class="aui-button previewAttachmentLink"
data-filename="DEC Import Update Template-with Data Validation-20240206-S53.xlsx"
data-file-src="/download/attachments/477497179/DEC%20Import%20Update%20Template-with%20Data%20Validation-20240206-S53.xlsx?api=v2"
data-linked-resource-default-alias="DEC Import Update Template-with Data Validation-20240206-S53.xlsx"
data-mime-type="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
data-linked-resource-container-id="477497179"
data-linked-resource-id="581009418">Preview</a>
<a class="aui-button preview-attachment-link" href="/pages/worddav/preview.action?fileName=DEC+Import+Update+Template-with+Data+Validation-20240206-S53.xlsx&pageId=477497179" >View</a>
</div>
</td>
</tr>
</tbody>
</table>
</div>
<div class="plugin_attachments_upload_container">
</div>
<div>
<a class="download-all-link" href="/pages/downloadallattachments.action?pageId=477497179" title="Download all the latest versions of attachments on this page as single zip file.">Download All</a>
</div>
</div>
</p><h1 id="TemplatesandInstructionsforBulkImportsandMatching-Tips">Tips</h1><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforAllImports">Tips for All Imports</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Use Data Validation</th><td class="confluenceTd">Always start with a fresh Template with Data Validation to help avoid uncaught errors due to invalid manually entered data. We have added a lot more error handling in this release, but it's not perfect yet, in particular when invalid or retired concepts are used.</td></tr><tr><th class="confluenceTh">Required Columns</th><td class="confluenceTd"><p>All templates require a BATCH USER, BATCH NAME, and SEQ ID on each row.</p></td></tr><tr><th class="confluenceTh">Delete/Purge</th><td class="confluenceTd"><p>When reimporting, it is safest to select all the rows and "Delete", then select "Purge", then select all rows and “Purge Records".</p><p>For Forms, select "Delete Hierarchies", then select "Purge", then select the rows and "Purge Hierarchies".</p></td></tr><tr><th class="confluenceTh">Unique Column Names</th><td class="confluenceTd">You may add additional columns to the template for taking/keeping notes after the last template column, but the column names must be unique.</td></tr><tr><th class="confluenceTh">Invalid or Retired Concepts</th><td class="confluenceTd">Invalid VM Concepts on import are not saved in the system and can create a GAP in the concept drop down. If the invalid or missing concepts are found, the system will display and error. Curators should fix all Concept Errors reported on Import BEFORE Validating.</td></tr><tr><th class="confluenceTh">Concept Formatting</th><td class="confluenceTd">Concept String should not contain commas, tabs, or or other hidden characters. Always "Paste Values" in order to avoid issues.</td></tr><tr><th class="confluenceTh">CSV Files!!</th><td class="confluenceTd">Template must be saved as CSV for importing. Other file types will cause an error.</td></tr><tr><th class="confluenceTh">Seq ID Rules</th><td class="confluenceTd">Seq ID must be a unique integer.</td></tr><tr><th class="confluenceTh">Import Exceptions</th><td class="confluenceTd">Missing Batch User, Batch Name, or Seq ID will cause Exception.</td></tr><tr><th class="confluenceTh">Selecting the "Import" Command</th><td class="confluenceTd"><p>For imports and matching, select the type of import/match item from the "Favorites" list, then select the "Import" command. For most imports there will be a dropdown with either one or two of the following choices: "Conceptual Object Import" and "Data Object Import". For most imports choose the first choice in the list.</p><p>For VM Match both choices are presented, choose the second one, "Data Object Import".</p></td></tr><tr><th class="confluenceTh">Exception on SEQ/Row Number</th><td class="confluenceTd">Multiple missing required fields may not report the correct row number in the Exception Message. Inspect the template for empty cells.</td></tr><tr><th class="confluenceTh">Save / Revalidate</th><td class="confluenceTd">If making changes through front-end, Save and Revalidate. This will refresh the messages.</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforCDEImports">Tips for CDE Imports</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Duplicates in File</th><td class="confluenceTd">Duplicate rows within the imported file are not caught on Import, but duplicate CDEs will not be created.</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforCDEMatch">Tips for CDE Match</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Run Transform</th><td class="confluenceTd"><p>CDE Match transforms the Source input into one row per column and permissible value. The command to transform the Source input details is "opt"+"cmd"+"t".</p></td></tr><tr><th class="confluenceTh">See Instructions</th><td class="confluenceTd">Please see the CDE Match Instructions document attached to this page. </td></tr><tr><th class="confluenceTh">Special Features</th><td class="confluenceTd">CDE Match has a command "Run DEC Match". This will run the match algorithm on the imported files using just the CDE names, ignoring the permissible values. Click the "Matched DEC" node to see results.</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforDECImportandUpdate">Tips for DEC Import and Update</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Validating Lots of Rows</th><td class="confluenceTd">Sometimes, the system throws an error when attempting to validate more than 4 rows at a time. If that happens, try validating a few rows at a time.</td></tr><tr><th class="confluenceTh">DEC Import Required Fields</th><td class="confluenceTd">DEC Context, OC Concepts, Property Concepts and DEC CD Name/ID are required.</td></tr><tr><th class="confluenceTh">DEC Update Required Fields</th><td class="confluenceTd">The DEC Context, DEC Public ID and Version are required for an Update. Any other columns that are populated will be treated as a change to the existing DEC, such as DEC CD, OC Concepts, Property Concepts. Retired DECs cannot be updated. DEC WFS will be set to "DRAFT NEW". </td></tr><tr><th class="confluenceTh">Known Issue</th><td class="confluenceTd">In release 1.53.4, if a duplicate DEC exists in another Context, you cannot bulk update the DEC. This will be fixed in future release.</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforDECMatch">Tips for DEC Match</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody class=""><tr class=""><th class="confluenceTh">Description</th><td class="confluenceTd">DEC match will run matching algorithms on the names in the template and display results in the "Matched DEC" node. You can select one of the DECs as "Preferred" and then download the results using the Delivery Options feature. </td></tr><tr><th class="confluenceTh">Context Column</th><td class="confluenceTd"><p>In the Context column, you can enter one or more contexts to search for matching DECs. Separate each DEC with a comma. Do not use spaces between DECs. For example:</p><p>XXX,CTEP,CCR</p></td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforVDImports">Tips for VD Imports</h2><p>None at this time.</p><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforPVVMImports">Tips for PV VM Imports</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Import into Existing VD</th><td class="confluenceTd">The PV VM import is designed to import an enumeration into an existing Value Domain. PV/VMs can be created using existing VMs, or you can specify a new VM either with or without concept codes.</td></tr><tr><th class="confluenceTh">Specified VM Definition</th><td class="confluenceTd">Optional Specified VM Definition is only used if the VM Type is "TEXT". The system will not throw an error but it won't be added to the VM.</td></tr><tr><th class="confluenceTh">Possible Timeout</th><td class="confluenceTd">Validate/Create will timeout if more than 5 minutes. Try batches of 100 until we can redesign the code. Watch.</td></tr><tr><th class="confluenceTh">VM Reuse</th><td class="confluenceTd">In a Text VM is specified and an existing VM with the exact name is found, it will be reused, even if it has concepts. The Validation message will indicate that existing VM is being used (need to fix spacing).</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforVMandConceptMatch">Tips for VM and Concept Match</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">After Importing</th><td class="confluenceTd"><p>The results after importing are displayed one row per Value Meaning. All VM Match user results are kept in one database table, and without filtering results, they are all displayed in the same grid. So, after selecting "Go to Data Manager" enter your batch name and click "Apply Filter" to see just your results.</p></td></tr><tr><th class="confluenceTh">Use Cases</th><td class="confluenceTd"><p>This feature can be used to match any terms to Concepts by selecting the "Concepts Only" command, including finding concepts for a new DEC.</p></td></tr><tr><th class="confluenceTh">"User Tips" Column</th><td class="confluenceTd"><p>The User Tips column is used by the system instead of the VM Name. Sometimes the VM Name from your form or data is not very representative of the its meaning, or consists of too many terms. If a "User Tip" is entered it is used instead of the VM Name. User Tips can be entered through the front end, or starting in Sprint 47, can be entered into the Template for each row and imported. </p></td></tr><tr><th class="confluenceTh">Algorithm</th><td class="confluenceTd"><p>Punctuation and spaces are removed. The "Rule Description" explains why each match was selected. The algorithm does not currently account for spelling errors.</p></td></tr><tr><th class="confluenceTh">"Run Match" VM Header Command</th><td class="confluenceTd"><p>Select the rows to run the match algorithm against and select the "RUN MATCH" Command. Punctuation and spaces are removed. This command will try to find Exact or Like Matches using the VM preferred name for existing VMs, Concept Preferred name and Synonyms.</p><p>Click "VM Matched Results" to review recommended matches. If you do not find a desired match, select "Run VM Match Unrestricted".</p></td></tr><tr><th class="confluenceTh"><p><strong>"Run Match - VM Only" VM Header Command</strong></p></th><td class="confluenceTd"><p>This match searches only for VM names that match.</p></td></tr><tr><th class="confluenceTh"><p><strong>"Run VM - Match Unrestricted" </strong></p><p><strong>VM Header Command</strong></p></th><td class="confluenceTd"><p>This match searches VM Names on the longest term in addition to more extensive matches. </p></td></tr><tr><th class="confluenceTh"><p><strong>"Run Match - Concepts Only" VM Header Command</strong></p></th><td class="confluenceTd"><p>This match searches only for Concepts by name and synonyms.</p></td></tr><tr><th class="confluenceTh"><p><strong>"Run Match Concepts Only - Unrestricted" VM Header Command</strong></p></th><td class="confluenceTd"><p>This match searches only for Concepts by name and synonyms the longest term in addition to more extensive matches. </p></td></tr><tr><th class="confluenceTh"><p><strong>"Run Match - Terminology"</strong></p></th><td class="confluenceTd"><p>This matches allows the user to select a specific terminology to search for Concepts by name, synonyms or Concept Code.</p></td></tr><tr><th class="confluenceTh">"VM Matched Results"</th><td class="confluenceTd"><p>If there is only one exact match, the system will automatically associate the matched result with the imported VM Name.</p><p>If there are multiple matches the user can select a row from "VM Matched Results" and select the "Set Preferred" command.</p><p>Multiple Concepts can be selected one at a time to post coordinate concepts. The system will a<span style="color: rgb(0,0,0);">ppended the concept to the preferred concept string and generate the resulting name in the order the concepts are selected. This can be viewed by selecting the Node with the Concept Name to view the selected items. The concepts and be reordered manually, but be sure to reorder the concept names, or clear the results, "Save" and then select concepts again from the matched results. </span></p></td></tr><tr><th class="confluenceTh">Advancing through the imported VMs</th><td class="confluenceTd"><div class="content-wrapper"><p>When on the "VM Match Header" you can advance to the next VM in your imported file by using the "Rows x of xxx" arrows.</p><p><span class="confluence-embedded-file-wrapper"><img class="confluence-embedded-image confluence-content-image-border" draggable="false" alt="VM Match Header." src="/plugins/servlet/confluence/placeholder/unknown-attachment?locale=en_GB&version=2" title="Screenshot 2023-08-24 at 7.41.59 PM.png"></span></p></div></td></tr><tr><th class="confluenceTh">Column Order</th><td class="confluenceTd"><p>The main column in VM Match is the VM Name. The processing is designed to find matching concepts based on the name and insert the Concept Name and Concept Code into the table next to the VM NAME unless "User Tips" are entered. This order of the columns makes it easier to populate the PV/VM Template using cut and paste. </p></td></tr><tr><th class="confluenceTh">Exporting results</th><td class="confluenceTd"><p>Use the "Delivery Options" command to export the VM Match results into and Excel file. This simplifies creating the list of PV/VMs for PV/VM Import to populate and existing Value Domain.</p></td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforFormImports">Tips for Form Imports</h2><div class="table-wrap"><table class="wrapped confluenceTable"><colgroup><col/><col/></colgroup><tbody><tr><td class="highlight-grey confluenceTd" title="Background color :" data-highlight-colour="grey"><strong>Import from REDCap Data Dictionary Format</strong></td><td class="confluenceTd"><p>The Form Import Template is an xslm filetype and contains several Excel Macros, so please be sure to select "Enable Macros" when opening the template. This has been tested for use only on a Windows PC platform, not Mac laptops.</p><ol><li>Paste your form content into the template starting on Row 3, column E. At a minimum you must run the Macro "Standardize", see instructions below.</li><li>If importing a PhenX REDCap Data Dictionary, you must run "Standardize", then "PhenxStandarize".</li><li>"CombineZip" is optional, it automates copying form content into the template from one or more REDCap dictionary csv files. See instructions below. </li><li>Enter a Batch User, Batch Name and ensure that each row has a unique "Seq Id"</li><li>Save the Form Template file as csv.</li><li>Run Form Import from Manage>>Manage Data (or your bookmarked Favorites)</li><li>Select "Import" from the toolbar, then "Conceptual Data Object" from the drop-down</li><li>Select the checkbox next to "<span style="color: rgb(51,51,51);">Form Import RedCAP v1" and select "Import" option from the toolbar (Between "Add New Mapping" and "Go To Data Manager")</span></li><li><span style="color: rgb(51,51,51);">Select the "Choose File" and select the Form Import Template from our desktop that you have prepared for loading</span></li><li><span style="color: rgb(51,51,51);">Change the last row in the table "Start at Row" from 2 → 3</span></li><li><span style="color: rgb(51,51,51);">Select "Import" at the bottom of the Table</span></li><li><span style="color: rgb(51,51,51);">After "Success" message, Select "Go to Data Manager" or Manage>>Manage Data>> Form Import (or from your bookmarked Favorites)</span></li><li><span style="color: rgb(51,51,51);">Use the filter to search for your form, Click "Apply Filter"</span></li><li><span style="color: rgb(51,51,51);">Select "Edit" for your form</span></li><li><span style="color: rgb(51,51,51);">Select a "Context" from the dropdown</span></li><li><span style="color: rgb(51,51,51);">Save</span></li><li><span style="color: rgb(51,51,51);">Select "Parse Form"</span></li><li><span style="color: rgb(51,51,51);">If successful, select "Validate Form"</span></li><li><span style="color: rgb(51,51,51);">Review the results</span></li><li><span style="color: rgb(51,51,51);">After successful Validate, Select "Create Form"</span></li><li><span style="color: rgb(51,51,51);">Copy the Public Id and choose "Forms" from Manage>>Manage Data (or your bookmarked Favorites) to view the newly created form in caDSR</span></li></ol></td></tr><tr><td class="highlight-grey confluenceTd" title="Background color :" data-highlight-colour="grey"><strong>Running the Macros</strong></td><td class="confluenceTd"><p>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". </p><div class="table-wrap"><table class="wrapped confluenceTable" data-mce-resize="false"><colgroup><col/><col/><col/></colgroup><tbody><tr><th scope="col" class="confluenceTh">Macro Name</th><th scope="col" class="confluenceTh">Description</th><th scope="col" class="confluenceTh">Execute macro</th></tr><tr><td class="confluenceTd">CombineZip</td><td class="confluenceTd">This 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 select the forms that you want to combine and import into the spreadsheet. Then run the "Standardize" macro, instructions below.</td><td class="confluenceTd">Choose "Option" + "Command" + "w"</td></tr><tr><td class="confluenceTd">Standardize</td><td class="confluenceTd">Each row must have a Section Header and a few other details. This macro transforms content from REDCap structure into the structure suitable for caDSR Form Import.</td><td class="confluenceTd">Choose "Control" + "Shift" + "x"</td></tr><tr><td class="confluenceTd">PhenxStandardize</td><td class="confluenceTd">Files 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" column</td><td class="confluenceTd">Choose "Control" + "Shift" + "t"</td></tr></tbody></table></div></td></tr><tr><td class="highlight-grey confluenceTd" title="Background color :" data-highlight-colour="grey"><strong title="">Filling the template with form data</strong></td><td class="confluenceTd">The 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. 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.</td></tr><tr><td class="highlight-grey confluenceTd" title="Background color :" data-highlight-colour="grey"><strong title="">Form Context</strong></td><td class="confluenceTd">REDCap does not have a column for Context. Context for all the forms in the templates is selected after importing the template into caDSR.</td></tr></tbody></table></div><h2 id="TemplatesandInstructionsforBulkImportsandMatching-TipsforDesignationImports">Tips for Designation Imports</h2><div class="table-wrap"><table class="wrapped confluenceTable"><tbody><tr><th class="confluenceTh">Consistency Checking</th><td class="confluenceTd">If AI Long Name does not match the specified AI Public ID Long Name, the system will show an error. We are requesting AI Long Name and AI Type to ensure Alt names are not inadvertently added to the wrong AI. Public IDs are very similar, typos are easy to make. If this becomes onerous, we could add a Validate Step to display the AI Long Name and AI Type for curator to see and visually verify before selecting Create.</td></tr></tbody></table></div><p><!-- style macro -->
<style type="text/css" rel="preload">
#title-text a { color: #006940; font-weight: bold } .wiki-content p { margin: 15px 0px;} input[type][value] { background-image: none !important; background: none !important; }
</style>
<script>
const header = $("#header");
const fixedHeader = "fixed-header";
$(window).on("scroll", () => {
if(window.pageYOffset > header.outerHeight()){
if(!header.hasClass(fixedHeader)){
header.addClass(fixedHeader);
}
} else {
header.removeClass(fixedHeader);
}
});
</script>
<!-- style macro --></p>
</div>
<div style="padding: 10px 0;">
<a href="https://wiki.nci.nih.gov/display/caDSR/Templates+and+Instructions+for+Bulk+Imports+and+Matching">View Online</a>
·
<a href="https://wiki.nci.nih.gov/pages/diffpagesbyversion.action?pageId=477497179&revisedVersion=44&originalVersion=43">View Changes Online</a>
</div>
</div>Warzel, Denise (NIH/NCI) [E]2022-01-11T18:15:07ZTemplates and Instructions for Bulk Imports and Matching > DEC Import Update Template-with Data Validation-20240206-S53.xlsxWarzel, Denise (NIH/NCI) [E]tag:wiki.nci.nih.gov,2009:attachment-581009418-12024-03-25T17:56:08Z2024-03-25T17:56:08Z<div class="feed"> <p>File
<b>attached</b> by
<a href=" https://wiki.nci.nih.gov/display/~warzeld
">Warzel, Denise (NIH/NCI) [E]</a>
</p>
<div style="border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 10px;">
<p>
<span class="aui-icon content-type-attachment-excel" title="Microsoft Excel Spreadsheet">Microsoft Excel Spreadsheet</span> <a href="https://wiki.nci.nih.gov/download/attachments/477497179/DEC%20Import%20Update%20Template-with%20Data%20Validation-20240206-S53.xlsx?version=1&modificationDate=1711389368745&api=v2">DEC Import Update Template-with Data Validation-20240206-S53.xlsx</a> <span class="smalltext">(20 kB)</span>
- DEC Import - Update Template S53
<br/>
</p>
</div>
<div style="padding: 10px 0;">
<a href="https://wiki.nci.nih.gov/pages/viewpageattachments.action?pageId=477497179">View Attachments</a>
</div>
</div>Warzel, Denise (NIH/NCI) [E]2024-03-25T17:56:08ZcaDSR II Sprint 1.53.4.0 Release NotesWarzel, Denise (NIH/NCI) [E]tag:wiki.nci.nih.gov,2009:page-579895304-112024-03-22T15:25:35Z2024-03-21T17:11:40Z<div class="feed"> <p>
Page
<b>edited</b> by
<a href=" https://wiki.nci.nih.gov/display/~warzeld
">Warzel, Denise (NIH/NCI) [E]</a>
</p>
<div style="border-top: 1px solid #ddd; border-bottom: 1px solid #ddd; padding: 10px;">
<div class="panel" style="border-width: 1px;"><div class="panelHeader" style="border-bottom-width: 1px;"><b>Contents of this Page</b></div><div class="panelContent">
<style type='text/css'>/*<![CDATA[*/
div.rbtoc1711705107447 {padding: 0px;}
div.rbtoc1711705107447 ul {margin-left: 0px;}
div.rbtoc1711705107447 li {margin-left: 0px;padding-left: 0px;}
/*]]>*/</style><div class='toc-macro rbtoc1711705107447'>
<ul class='toc-indentation'>
<li><a href='#caDSRIISprint1.53.4.0ReleaseNotes-Improvements'>Improvements</a></li>
<li><a href='#caDSRIISprint1.53.4.0ReleaseNotes-BugFixes'>Bug Fixes</a></li>
<li><a href='#caDSRIISprint1.53.4.0ReleaseNotes-IssuesNotFixedinThisSprint'>Issues Not Fixed in This Sprint</a></li>
<li><a href='#caDSRIISprint1.53.4.0ReleaseNotes-KnownIssuesFoundinSprint1.53.4.0Testing-PlannedforNextSprint'>Known Issues Found in Sprint 1.53.4.0 Testing - Planned for Next Sprint</a></li>
<li><a href='#caDSRIISprint1.53.4.0ReleaseNotes-ReleaseHistory'>Release History</a></li>
</ul>
</div>
</div></div><div class="panel" style="border-width: 1px;"><div class="panelContent">
<p><strong>National Cancer Institute Center for Biomedical Informatics and Information Technology </strong> <br/><strong>caDSR Sprint 1.53.4.0 Release Notes</strong></p>21-Mar-2024
</div></div><h2 id="caDSRIISprint1.53.4.0ReleaseNotes-Improvements">Improvements</h2><p>The following are tracker numbers and descriptions of improvements.<div class="table-wrap"><table id="TBL1711189139302" class="wrapped confluenceTable" ><thead><tr><th class="confluenceTh">Feature</th><th class="confluenceTh">Description</th><th class="confluenceTh">Jira Tracker Number</th></tr></thead><tbody><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-307" class="external-link" rel="nofollow">API</a></td><td class="confluenceTd">API: Address null lists in API services</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3207?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3207</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: Give Super Curator role privilege to Delete and Purge imported sequences</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3221?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3221</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: Designation Import failed when CDE Long Name is longer than 128 characters</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3217?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3217</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Loading: Create the ability to bulk import Rep Term Updates - TEMPLATE CHANGE</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3215?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3215</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: VM Match: Run Match - Terminology Validation popup should sort by EVS Description</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3195?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3195</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: DEC Import: add ability to Update - MANUAL STEP</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3149?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3149</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-314" class="external-link" rel="nofollow">CHANGE MANAGEMENT</a></td><td class="confluenceTd">Change Management : use "sysgen" to update CDE/VD Long Name and Definition</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3232?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3232</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-314" class="external-link" rel="nofollow">CHANGE MANAGEMENT</a></td><td class="confluenceTd">Change Management: Value Domains: Add new VD type "Enumerated by Reference" - Design</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3063?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3063</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Model Map Maint and Import: UI changes to 5.2 and 8 and Import template - TEMPLATE UPDATE</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3210?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3210</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Model Mapping Maint: Super Curator should have privilege to Insert</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3202?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3202</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Model Import - Update: Remove hook command "Compare Model" and "Create Element Relationship"</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3196?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3196</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Model Mapping Maint: Remove unused hook commands</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3194?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3194</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Model Mapping Maint: Review Generated Name</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3161?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3161</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map Services: Develop a process for posting the Monthly EVS Cross-Walk Mapping file (Cross-Walks)</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3118?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3118</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Model Mapping: Change Source and Target Function Names to UPPER CASE - PUSH UP THE TIERS</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3093?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3093</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map: Create a User view of the Characteristics Mapping</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3006?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3006</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Modeling Reviews: Review Curators’s assigned OCs to PCORNet and OMOP tables</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2951?src=confmacro" class="external-link" rel="nofollow">DSRMWS-2951</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: Rename Browse Forms by Classification to Forms - Classification View</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3248?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3248</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: Data Elements View/Browse: add “Subset Level” into result grid</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3226?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3226</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: Ped Cancer: Make node grid has same column order as Data Elements - View/Browse</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3225?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3225</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: Data Elements View Only COs: Make tree node name consistent For DE View/Browse, CRDC and Pediatric Core CDEs</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3224?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3224</a></td></tr></tbody></table></div>
<script type='text/javascript'>
$("table[id='TBL1711189139302']").data("appfire-table","table-plus");
(new org_swift_TableSorter()).customTable('TBL1711189139302',[],'',
1,false,'lightgoldenrodyellow',true,
'Click to sort','1',false,
false,false,true,
0,false,'',true,
'',false,'Comma',false,'','','','',
true,'',
'','',false,false,false,'vertical',
);
</script>
<br/></p><h2 id="caDSRIISprint1.53.4.0ReleaseNotes-BugFixes">Bug Fixes</h2><p>The following are tracker numbers and descriptions of bug fixes.<div class="table-wrap"><table id="TBL1711189139303" class="wrapped confluenceTable" ><thead><tr><th class="confluenceTh">Feature</th><th class="confluenceTh">Description</th><th class="confluenceTh">Jira Tracker Number</th></tr></thead><tbody><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: DEC Import - update: Remove Duplicate Command Names - MANUAL STEP</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3246?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3246</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Loading: VM Match not working on Prod - Column Header errors - TEMPLATE CHANGED IN S52</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3237?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3237</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-1941" class="external-link" rel="nofollow">BULK LOADER TASKS</a></td><td class="confluenceTd">Bulk Load: DEC Import: Throwing an error when trying to Create a large number of Validated DECs at the same time</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3123?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3123</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-294" class="external-link" rel="nofollow">ROLES</a></td><td class="confluenceTd">Roles: Forms - Classifications View: Make available for Super Curator, Admin, and Form Curators</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3250?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3250</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: AI Tool_DEMaint: Rename "Parent Subset CDE ID/Version" to "Parent CDE ID/Version"</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3214?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3214</a></td></tr></tbody></table></div>
<script type='text/javascript'>
$("table[id='TBL1711189139303']").data("appfire-table","table-plus");
(new org_swift_TableSorter()).customTable('TBL1711189139303',[],'',
1,false,'lightgoldenrodyellow',true,
'Click to sort','1',false,
false,false,true,
0,false,'',true,
'',false,'Comma',false,'','','','',
true,'',
'','',false,false,false,'vertical',
);
</script>
<br/></p><h2 id="caDSRIISprint1.53.4.0ReleaseNotes-IssuesNotFixedinThisSprint">Issues Not Fixed in This Sprint</h2><p>The following are tracker numbers and descriptions of unresolved issues.<div class="table-wrap"><table id="TBL1711189139304" class="wrapped confluenceTable" ><thead><tr><th class="confluenceTh">Feature</th><th class="confluenceTh">Description</th><th class="confluenceTh">Workaround</th><th class="confluenceTh">Jira Tracker Number</th></tr></thead><tbody><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd">Code Map Services: Review Model attributes Element Type and Characteristic Type</td><td class="confluenceTd">No workaround.</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3203?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3203</a></td></tr><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-300" class="external-link" rel="nofollow">UI CHANGES</a></td><td class="confluenceTd">UI Changes: Browse Forms by classification: allow public access (Forms - Classifications View)</td><td class="confluenceTd">No workaround.</td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3247?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3247</a></td></tr></tbody></table></div>
<script type='text/javascript'>
$("table[id='TBL1711189139304']").data("appfire-table","table-plus");
(new org_swift_TableSorter()).customTable('TBL1711189139304',[],'',
1,false,'lightgoldenrodyellow',true,
'Click to sort','1',false,
false,false,true,
0,false,'',true,
'',false,'Comma',false,'','','','',
true,'',
'','',false,false,false,'vertical',
);
</script>
<br/></p><h2 id="caDSRIISprint1.53.4.0ReleaseNotes-KnownIssuesFoundinSprint1.53.4.0Testing-PlannedforNextSprint">Known Issues Found in Sprint 1.53.4.0 Testing - Planned for Next Sprint</h2><p>The team created or reopened the following issues during Sprint 1.53.4.0 testing.<div class="table-wrap"><table id="TBL1711189139305" class="wrapped confluenceTable" ><thead><tr><th class="confluenceTh">Feature</th><th class="confluenceTh">Description</th><th class="confluenceTh">Jira Tracker Number</th></tr></thead><tbody><tr><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-2742" class="external-link" rel="nofollow">CODE MAP SERVICES</a></td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3244?src=confmacro" class="external-link" rel="nofollow">Code Map: Model Import - Update: Remove extraneous Warning</a></td><td class="confluenceTd"><a href="https://tracker.nci.nih.gov/browse/DSRMWS-3244?src=confmacro" class="external-link" rel="nofollow">DSRMWS-3244</a></td></tr></tbody></table></div>
<script type='text/javascript'>
$("table[id='TBL1711189139305']").data("appfire-table","table-plus");
(new org_swift_TableSorter()).customTable('TBL1711189139305',[],'',
1,false,'lightgoldenrodyellow',true,
'Click to sort','1',false,
false,false,true,
0,false,'',true,
'',false,'Comma',false,'','','','',
true,'',
'','',false,false,false,'vertical',
);
</script>
<br/></p><h2 id="caDSRIISprint1.53.4.0ReleaseNotes-ReleaseHistory">Release History</h2><div class="table-wrap"><table class="wrapped confluenceTable"><colgroup> <col/> <col/> </colgroup><tbody><tr><th class="confluenceTh">Release</th><th class="confluenceTh">Date</th></tr><tr><td class="confluenceTd">Sprint 1.53.4.0</td><td class="confluenceTd">21-Mar-2024</td></tr><tr><td class="confluenceTd">Sprint 1.52.3.0 </td><td class="confluenceTd">22-Feb-2024</td></tr><tr><td class="confluenceTd">Sprint 1.51.5.1</td><td class="confluenceTd">18-Jan-2024</td></tr><tr><td class="confluenceTd">Sprint 1.51.5.0</td><td class="confluenceTd">21-Dec-2023</td></tr><tr><td class="confluenceTd">Sprint 1.50.3.0</td><td class="confluenceTd">16-Nov-2023</td></tr><tr><td class="confluenceTd">Sprint 1.49.1.0</td><td class="confluenceTd">24-Oct-2023</td></tr><tr><td class="confluenceTd">Sprint 1.48.4.0</td><td class="confluenceTd">25-Sep-2023</td></tr><tr><td class="confluenceTd">Sprint 1.47.3.0</td><td class="confluenceTd">30-Aug-2023</td></tr><tr><td class="confluenceTd">Sprint 1.46.4.0: Emergency Patch</td><td class="confluenceTd">2-Aug-2023</td></tr><tr><td class="confluenceTd">Sprint 1.46.3.0</td><td class="confluenceTd">27-Jul-2023</td></tr><tr><td class="confluenceTd">Sprint 1.45.2.0</td><td class="confluenceTd">29-Jun-2023</td></tr><tr><td class="confluenceTd">Sprint 1.44.3.0</td><td class="confluenceTd">1-Jun-2023</td></tr><tr><td class="confluenceTd">Sprint 1.43.5.0</td><td class="confluenceTd">4-May-2023</td></tr><tr><td class="confluenceTd">Sprint 1.42.5.0</td><td class="confluenceTd">4-Apr-2023</td></tr><tr><td class="confluenceTd">Sprint 1.42.4.0</td><td class="confluenceTd">30-Mar-2023</td></tr><tr><td class="confluenceTd">Sprint 1.41.5.0</td><td class="confluenceTd">16-Mar-2023</td></tr><tr><td class="confluenceTd">Sprint 1.41.4.0</td><td class="confluenceTd">14-Mar-2023</td></tr><tr><td class="confluenceTd">Sprint 1.41.3.0</td><td class="confluenceTd">16-Feb-2023</td></tr><tr><td class="confluenceTd">Sprint 1.40.2.0</td><td class="confluenceTd">12-Jan-2023</td></tr><tr><td class="confluenceTd">Sprint 1.39.2.0</td><td class="confluenceTd">5-Dec-2022</td></tr><tr><td class="confluenceTd">Sprint 1.38.2.0</td><td class="confluenceTd">10-Nov-22</td></tr><tr><td class="confluenceTd">Sprint 1.38.1.0</td><td class="confluenceTd">7-Nov-22</td></tr><tr><td class="confluenceTd">Sprint 1.37.2.0</td><td class="confluenceTd">20-Oct-22</td></tr><tr><td class="confluenceTd">Sprint 1.37.1.0</td><td class="confluenceTd">(Not deployed.)</td></tr><tr><td class="confluenceTd">Sprint 1.37.0.0</td><td class="confluenceTd">(Not deployed.)</td></tr><tr><td class="confluenceTd">Sprint 1.36.4.0</td><td class="confluenceTd">4-Oct-22</td></tr><tr><td class="confluenceTd">Sprint 1.36.3.0</td><td class="confluenceTd">26-Sep-22</td></tr><tr><td class="confluenceTd">Sprint 1.35.3.0</td><td class="confluenceTd">7-Sep-22</td></tr><tr><td class="confluenceTd">Sprint 1.35.2.0</td><td class="confluenceTd">(Not deployed.)</td></tr><tr><td class="confluenceTd">Sprint 1.35.1.0</td><td class="confluenceTd">25-Aug-22</td></tr><tr><td class="confluenceTd">Sprint 1.34.1.1 </td><td class="confluenceTd">9-Aug-22</td></tr><tr><td class="confluenceTd">Sprint 1.34.0.0</td><td class="confluenceTd">28-Jul-22</td></tr><tr><td class="confluenceTd">Sprint 1.33.1.0</td><td class="confluenceTd">7-Jul-22</td></tr><tr><td class="confluenceTd">Sprint 1.33.0.0</td><td class="confluenceTd">(Not deployed.)</td></tr><tr><td class="confluenceTd">Sprint 1.32.2.0</td><td class="confluenceTd">22-Jun-22</td></tr><tr><td class="confluenceTd">Sprint 1.32.1.0</td><td class="confluenceTd">16-Jun-22</td></tr><tr><td class="confluenceTd">Sprint 1.32.0.0</td><td class="confluenceTd">19-May-22</td></tr><tr><td class="confluenceTd">Sprint 1.31.0.0</td><td class="confluenceTd">11-May-22</td></tr><tr><td class="confluenceTd">Sprint 1.30.0.0</td><td class="confluenceTd">25-Apr-22</td></tr><tr><td class="confluenceTd">Sprint 1.29.0.0</td><td class="confluenceTd">(Not deployed.)</td></tr><tr><td class="confluenceTd">Sprint 1.28.0.0</td><td class="confluenceTd">15-Apr-22</td></tr><tr><td class="confluenceTd">Sprint 1.27.0.0</td><td class="confluenceTd">29-Mar-22</td></tr><tr><td class="confluenceTd">Sprint 1.26.0.0</td><td class="confluenceTd">9-Mar-22</td></tr><tr><td class="confluenceTd">Sprint 1.25.0.0</td><td class="confluenceTd">17-Feb-22</td></tr><tr><td class="confluenceTd">Sprint 1.24.0.0</td><td class="confluenceTd">3-Feb-22</td></tr><tr><td class="confluenceTd">Sprint 1.23.0.0</td><td class="confluenceTd">11-Jan-22</td></tr><tr><td class="confluenceTd">Sprint 1.22.0.0</td><td class="confluenceTd">14-Dec-21</td></tr><tr><td class="confluenceTd">Sprint 1.21.0.0</td><td class="confluenceTd">15-Nov-21</td></tr><tr><td class="confluenceTd">Sprint 1.20.0.0</td><td class="confluenceTd">1-Nov-21</td></tr></tbody></table></div><p><br/></p><p><!-- style macro -->
<style type="text/css" rel="preload">
#title-text a { color: #006940; font-weight: bold } .wiki-content p { margin: 15px 0px;} input[type][value] { background-image: none !important; background: none !important; }
</style>
<script>
const header = $("#header");
const fixedHeader = "fixed-header";
$(window).on("scroll", () => {
if(window.pageYOffset > header.outerHeight()){
if(!header.hasClass(fixedHeader)){
header.addClass(fixedHeader);
}
} else {
header.removeClass(fixedHeader);
}
});
</script>
<!-- style macro --></p><p><br/></p>
</div>
<div style="padding: 10px 0;">
<a href="https://wiki.nci.nih.gov/display/caDSR/caDSR+II+Sprint+1.53.4.0+Release+Notes">View Online</a>
·
<a href="https://wiki.nci.nih.gov/pages/diffpagesbyversion.action?pageId=579895304&revisedVersion=11&originalVersion=10">View Changes Online</a>
</div>
</div>Warzel, Denise (NIH/NCI) [E]2024-03-21T17:11:40Z