https://dev.e-taxonomy.eu/redmine/https://dev.e-taxonomy.eu/redmine/redmine/favicon.ico?14691914852019-12-26T11:06:48ZEDIT Project ManagementEDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509622019-12-26T11:06:48ZAndreas Müller
<ul><li><strong>Due date</strong> set to <i>02/10/2010</i></li><li><strong>Start date</strong> changed from <i>12/26/2019</i> to <i>02/10/2010</i></li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509642019-12-26T11:08:15ZAndreas Müller
<ul><li><strong>Due date</strong> deleted (<del><i>02/10/2010</i></del>)</li><li><strong>Target version</strong> changed from <i>PESI 2019</i> to <i>PESI 2022</i></li><li><strong>Start date</strong> deleted (<del><i>02/10/2010</i></del>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509652019-12-26T11:16:13ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50965/diff?detail_id=63872">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509662019-12-26T11:18:08ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50966/diff?detail_id=63873">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509672019-12-26T11:18:36ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50967/diff?detail_id=63874">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509682019-12-26T11:31:32ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50968/diff?detail_id=63875">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509692019-12-26T11:44:15ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50969/diff?detail_id=63876">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509702019-12-26T11:47:26ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50970/diff?detail_id=63877">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509712019-12-26T11:49:41ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50971/diff?detail_id=63878">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509722019-12-26T11:53:48ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50972/diff?detail_id=63879">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509732019-12-26T12:00:03ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50973/diff?detail_id=63880">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509742019-12-26T12:11:28ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50974/diff?detail_id=63881">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509752019-12-26T12:22:33ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50975/diff?detail_id=63882">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509762019-12-26T12:46:21ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50976/diff?detail_id=63883">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509772019-12-26T13:11:35ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50977/diff?detail_id=63884">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509782019-12-26T13:12:32ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50978/diff?detail_id=63885">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509792019-12-26T13:14:02ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50979/diff?detail_id=63886">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509802019-12-26T13:24:46ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50980/diff?detail_id=63887">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509812019-12-26T13:46:30ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50981/diff?detail_id=63888">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509822019-12-26T14:30:09ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50982/diff?detail_id=63889">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509832019-12-26T14:36:13ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50983/diff?detail_id=63890">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509842019-12-26T14:42:53ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50984/diff?detail_id=63891">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509852019-12-26T14:53:11ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50985/diff?detail_id=63892">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509862019-12-26T15:01:02ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50986/diff?detail_id=63893">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509872019-12-26T15:03:12ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50987/diff?detail_id=63894">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509882019-12-26T15:05:32ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50988/diff?detail_id=63895">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509892019-12-26T15:52:46ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50989/diff?detail_id=63896">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509902019-12-26T15:55:39ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50990/diff?detail_id=63897">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509912019-12-26T15:57:50ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50991/diff?detail_id=63898">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509922019-12-26T16:02:45ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50992/diff?detail_id=63899">diff</a>)</li></ul><p>Open issues from comparing SQL scripts (Y:\BDI\PESI\sh\DBs2PESI\vCDM):</p>
<p>!!!! Do check again because maybe I checked against Y:\BDI\PESI\sh\DBs2PESI\v12 instead vCDM !!!</p>
<p>erms130_language.sql:</p>
<ul>
<li>not yet checked (low priority) </li>
</ul>
<p>erms230_Source.sql:</p>
<ul>
<li>Parsing RefYear and AuthorString (low priority)</li>
</ul>
<p>erms300_Match_Relation&Status.sql: MEDIUM</p>
<ul>
<li>test synonym relations</li>
<li>same attribute => to avoid duplicates?</li>
</ul>
<p>erms400_Taxon.sql: HIGH</p>
<ul>
<li>not yet checked</li>
<li>update Taxon set KingdomFk = 6 where GenusOrUninomial = 'Monera'</li>
</ul>
<p>erms420_UpdateTaxon.sql: DONE</p>
<p>erms430_Kingdom.sql: DONE (updates Rank.Kingdom, probably not relevant)</p>
<p>erms450_RelTaxon.sql:</p>
<ul>
<li>Name relations => always to accepted taxon, where tu.tu_status > 1 and q.QualifierId < 100</li>
<li>taxon relations => always to accepted taxon, where et.id != et.tu_accfinal and q.QualifierId > 100</li>
<li>fill RelTaxon via tu=>tu_accfinal != tu=>id ; ! cave: do not duplicate entries via Matching table, only tu_unacceptreason = NULL</li>
<li>by default use 'is synonym of' if unacceptreason does not exist or does not match any >100 RealtionType, where et.id != et.tu_accfinal</li>
<li>'is taxonomically included in', where et.tu_parent is not null and et.tu_status = 1 and et.id <> et.tu_parent</li>
<li>put tu_unacceptreason into notes</li>
</ul>
<p>erms470_NameStatus.sql: DONE</p>
<p>erms500_Vernacular.sql: DONE (source handling is new and differs from SQL)</p>
<p>erms520_Images.sql: see open issues in image export (handling of multiple images)</p>
<p>erms550_Note.sql:</p>
<ul>
<li>update Note set Note_1 = replace(Note_1, char(11), ' ') (low priority)</li>
<li>tests for ecology facts</li>
</ul>
<p>erms560_Link.sql: LOW </p>
<ul>
<li>final tests</li>
<li>"encyclopedia of => Image"</li>
<li>"fishbase ambigous => Discuss with VLIZ</li>
</ul>
<p>erms600_Source_2.sql: DONE (test for sources still missing)</p>
<p>erms900_Occurrence.sql: DONE (see #1523 for comments on status handling)</p>
EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509932019-12-26T16:13:18ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50993/diff?detail_id=63900">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509942019-12-26T16:13:50ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50994/diff?detail_id=63901">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509952019-12-26T16:45:07ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50995/diff?detail_id=63902">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509972019-12-26T17:13:39ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50997/diff?detail_id=63905">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509982019-12-26T17:32:03ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50998/diff?detail_id=63906">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=509992019-12-26T17:39:28ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/50999/diff?detail_id=63907">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510012019-12-26T17:41:49ZAndreas Müller
<ul><li><strong>Due date</strong> set to <i>01/11/2019</i></li><li><strong>Start date</strong> set to <i>01/11/2019</i></li><li><strong>Follows</strong> <i><a class="issue tracker-6 status-5 priority-10 priority-lowest closed" href="/redmine/issues/7976">task #7976</a>: [PESI][ERMS] Erms taxon import</i> added</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510032019-12-26T17:42:05ZAndreas Müller
<ul><li><strong>Due date</strong> deleted (<del><i>01/11/2019</i></del>)</li><li><strong>Start date</strong> deleted (<del><i>01/11/2019</i></del>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510822019-12-26T21:53:16ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/51082/diff?detail_id=64034">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510842019-12-26T22:21:57ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/51084/diff?detail_id=64036">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510892019-12-26T23:18:55ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/51089/diff?detail_id=64041">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510902019-12-26T23:40:53ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/51090/diff?detail_id=64042">diff</a>)</li></ul> EDIT - task #8792: Issues to have in mind for ERMS importhttps://dev.e-taxonomy.eu/redmine/issues/8792?journal_id=510912019-12-26T23:43:20ZAndreas Müller
<ul><li><strong>Description</strong> updated (<a title="View differences" href="/redmine/journals/51091/diff?detail_id=64043">diff</a>)</li></ul>