Project

General

Profile

feature request #6524

Distribtion Update for Fauna Europaea

Added by Katja Luther over 1 year ago. Updated over 1 year ago.

Status:
Closed
Priority:
Highest
Category:
cdmadapter
Target version:
Start date:
03/20/2017
Due date:
% Done:

70%

Severity:
normal

Description

Import the adapted distributions from a file formatted like the attached file

Open issues:

  • add sources ce1cdcc93e4d
  • make configurable if Distributions should be created anew if one exists already for the given area 06101dacc8
  • make configurable if Description should be created anew or if the old one(s) should be reused (difficult if multiple descriptions exist already)
  • InputResult handling b64acc4b and d0834e21
  • progress monitoring
  • tests

Kopie von Thysanoptera-orig_update 20-i-2017.xlsx (189 KB) Katja Luther, 03/20/2017 01:27 PM

Thysanoptera-corrected.xlsx (190 KB) Katja Luther, 05/04/2017 09:36 AM


Related issues

Related to Edit - task #6137: Urgent imports In Progress 10/19/2016
Related to Edit - feature request #6619: Integrate Excel distribution import into taxeditor Resolved 05/04/2017
Related to Edit - feature request #6635: Remaining fauna europaea distribution update issues New 05/11/2017

Associated revisions

Revision 660765d1 (diff)
Added by Andreas Müller over 1 year ago

ref #6524 create import class for FauEu distribution import

Revision 2c86f1fe (diff)
Added by Andreas Müller over 1 year ago

ref #6524 create import class for FauEu distribution import

Revision 5fac592f (diff)
Added by Andreas Müller over 1 year ago

ref #6524 first version, but still missing getStatusByStatusStr implementation

Revision d8c39783 (diff)
Added by Andreas Müller over 1 year ago

ref #6524 add FauEu Distr Activator

Revision 13c8fbc6 (diff)
Added by Andreas Müller over 1 year ago

ref #6524 first running version of (FauEu) distribution updater

Revision ce1cdcc9 (diff)
Added by Andreas Müller over 1 year ago

ref #6524 add import source to ExcelDistributionUpdate

Revision 06101dac (diff)
Added by Andreas Müller over 1 year ago

ref #6524 add reuse existing distribution

Revision b64acc4b (diff)
Added by Andreas Müller over 1 year ago

ref #6524 add reporting to distribution updater

Revision d0834e21 (diff)
Added by Andreas Müller over 1 year ago

ref #6524 add reporting to FaunaEuropaea import

Revision 839a2ed3 (diff)
Added by Katja Luther over 1 year ago

ref #6524: smaller changes for better handling in editor

Revision 7854fc26 (diff)
Added by Andreas Müller over 1 year ago

ref #6524, ref #6619 set needsNomenclaturalCode to false for ExcelDistributionUpdateConfigurator

History

#1 Updated by Andreas Müller over 1 year ago

#2 Updated by Andreas Müller over 1 year ago

@Katja: Is there any code available defining the export format?
Also we should add an example Excel file to cdmlib-io resources.

#3 Updated by Andreas Müller over 1 year ago

@Katja: I do not find the area uuids in row 2. I thought to remember that they were to be found there. Do you have an idea?

#4 Updated by Katja Luther over 1 year ago

the sql files for the creation of the excel files you can find in ticket #4328

And we exported only the taxon uuids, but the labels used in the excel file are idInVocabulary

#6 Updated by Andreas Müller over 1 year ago

  • Description updated (diff)
  • Status changed from New to Resolved
  • Assignee changed from Andreas Müller to Katja Luther

Katja, first version is ready and seems to work. Could you please review.

#7 Updated by Andreas Müller over 1 year ago

I tested against FauEu on test server. So the result can be seen there, but it is not the final state as there were still empty descriptions created if no changes took place. I hope this is fixed now.

#8 Updated by Andreas Müller over 1 year ago

  • Description updated (diff)

#9 Updated by Andreas Müller over 1 year ago

  • Description updated (diff)

#10 Updated by Andreas Müller over 1 year ago

  • Description updated (diff)

#11 Updated by Andreas Müller over 1 year ago

  • % Done changed from 0 to 70

#13 Updated by Katja Luther over 1 year ago

Saskia sent a corrected version of the file.

#14 Updated by Katja Luther over 1 year ago

#15 Updated by Andreas Müller over 1 year ago

  • Description updated (diff)

#16 Updated by Katja Luther over 1 year ago

the import works fine, the remaining issues are moved to a follow up ticket.(#6635)

#17 Updated by Katja Luther over 1 year ago

  • Status changed from Resolved to Closed
  • Assignee changed from Katja Luther to Andreas Müller

#18 Updated by Katja Luther over 1 year ago

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)