https://pardeewiki.du.edu//index.php?action=history&feed=atom&title=Consolidating_data 2026-04-25T22:30:59Z Revision history for this page on the wiki MediaWiki 1.43.6 https://pardeewiki.du.edu//index.php?title=Consolidating_data&diff=8959&oldid=prev 2018-08-27T21:19:13Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:19, 27 August 2018</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">Line 1:</td> <td colspan="2" class="diff-lineno">Line 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>If the vetted data comes in one single .mdb containing all the data tables and a datadict table with the import/update list, the new "Compare Imported Data" screen <del style="font-weight: bold; text-decoration: none;">described in section 3.2.1 above </del>can be used to merge data to the master IFs database.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>If the vetted data comes in one single .mdb containing all the data tables and a datadict table with the import/update list, the new "Compare Imported Data" screen<ins style="font-weight: bold; text-decoration: none;">&amp;nbsp;</ins>can be used to merge data to the master IFs database.</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The large button on the bottom right of that screen, titled &quot;Merge Imported Data to Master Database&quot; can be used for this. This button adds (or overwrites) imported tables to IFs\Data\IFsHistSeries.Mdb and merges datadict rows to the master copy of datadict (IFs\Data\Datadict.mdb). This button should only be used by the person who is in charge of merging the data to IFs database.</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>The large button on the bottom right of that screen, titled &quot;Merge Imported Data to Master Database&quot; can be used for this. This button adds (or overwrites) imported tables to IFs\Data\IFsHistSeries.Mdb and merges datadict rows to the master copy of datadict (IFs\Data\Datadict.mdb). This button should only be used by the person who is in charge of merging the data to IFs database.</div></td></tr> </table>

Wikiadmin https://pardeewiki.du.edu//index.php?title=Consolidating_data&diff=162&oldid=prev 2016-03-31T22:18:29Z

<p>Created page with &quot;If the vetted data comes in one single .mdb containing all the data tables and a datadict table with the import/update list, the new &quot;Compare Imported Data&quot; screen described i...&quot;</p> <p><b>New page</b></p><div>If the vetted data comes in one single .mdb containing all the data tables and a datadict table with the import/update list, the new &quot;Compare Imported Data&quot; screen described in section 3.2.1 above can be used to merge data to the master IFs database.<br /> <br /> The large button on the bottom right of that screen, titled &quot;Merge Imported Data to Master Database&quot; can be used for this. This button adds (or overwrites) imported tables to IFs\Data\IFsHistSeries.Mdb and merges datadict rows to the master copy of datadict (IFs\Data\Datadict.mdb). This button should only be used by the person who is in charge of merging the data to IFs database.<br /> <br /> At the time of packaging another quick check is done to make sure data is good. If needed table names are changed.<br /> <br /> Most Recent and Earliest columns need to be populated for manual imports done using template spreadsheet.</div>

Wikiadmin