https://redmine.auroville.org.in/https://redmine.auroville.org.in/favicon.ico2020-09-30T10:43:51ZRedmineGisaf - Support #11071: Reconciliation: cannot find some pointshttps://redmine.auroville.org.in/issues/11071?journal_id=733352020-09-30T10:43:51ZPhilippe May
<ul></ul><p>As i thought initially: these points are in the <code>RAW_V_*</code> tables, but not in the <code>gisaf_survey.raw_survey</code> table.</p>
<p>We could manually make the changes manually in the database. But, since we don't know the reason why the points are missing, this case might reappear.</p>
<p>So, a more global solution is to add a new function in the admin: giving an <code>original_id</code> in a given <code>RAW_V_*</code> table, make sure that the corresponding point exists in the <code>gisaf_survey.raw_survey</code> table, and eventually re-create it.</p> Gisaf - Support #11071: Reconciliation: cannot find some pointshttps://redmine.auroville.org.in/issues/11071?journal_id=733702020-10-01T07:33:20ZPhilippe May
<ul></ul><p>After deeper analysis, it might be related to <a class="issue tracker-2 status-1 priority-4 priority-default" title="Feature: Survey data basket: handle the case when more than one file in the basket per day (New)" href="https://redmine.auroville.org.in/issues/8721">#8721</a> (multiple survey point files imported with the same project, surveyor, equipment and date).</p>
<p>For example, for the VEGE_BNYN (V5) original id 23510 which was surveyed the 2018-02-09, there are 2 files: MM-2018-02-09.csv and MM-2018-02-09-Floor_Levels.csv.</p>
<p>Going on the analysis later.</p>