Project

General

Profile

Actions
Copy link

feature request #6524

closed

Distribtion Update for Fauna Europaea

Added by Katja Luther about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Highest
Assignee:
Andreas Müller
Category:
cdmadapter
Target version:
Release 4.7
Start date:
Due date:
% Done:

70%

Estimated time:
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

Files

Download all files
Kopie von Thysanoptera-orig_update 20-i-2017.xlsx (189 KB) Kopie von Thysanoptera-orig_update 20-i-2017.xlsx Katja Luther, 03/20/2017 01:27 PM
Thysanoptera-corrected.xlsx (190 KB) Thysanoptera-corrected.xlsx Katja Luther, 05/04/2017 09:36 AM

Related issues

Related to EDIT - task #6137: Urgent importsIn ProgressAndreas Müller

Actions
Related to EDIT - feature request #6619: Integrate Excel distribution import into taxeditorResolvedAndreas Müller

Actions
Related to EDIT - feature request #6635: Remaining fauna europaea distribution update issuesNewAndreas Müller

Actions
Actions
Copy link
 #1

Updated by Andreas Müller about 6 years ago

Actions
Copy link
 #2

Updated by Andreas Müller about 6 years ago

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

Actions
Copy link
 #3

Updated by Andreas Müller about 6 years 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?

Actions
Copy link
 #4

Updated by Katja Luther about 6 years 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

Actions
Copy link
 #6

Updated by Andreas Müller about 6 years 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.

Actions
Copy link
 #7

Updated by Andreas Müller about 6 years 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.

Actions
Copy link
 #8

Updated by Andreas Müller about 6 years ago

  • Description updated (diff)
Actions
Copy link
 #9

Updated by Andreas Müller about 6 years ago

  • Description updated (diff)
Actions
Copy link
 #10

Updated by Andreas Müller about 6 years ago

  • Description updated (diff)
Actions
Copy link
 #11

Updated by Andreas Müller about 6 years ago

  • % Done changed from 0 to 70
Actions
Copy link
 #13

Updated by Katja Luther about 6 years ago

Saskia sent a corrected version of the file.

Actions
Copy link
 #14

Updated by Katja Luther about 6 years ago

Actions
Copy link
 #15

Updated by Andreas Müller about 6 years ago

  • Description updated (diff)
Actions
Copy link
 #16

Updated by Katja Luther about 6 years ago

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

Actions
Copy link
 #17

Updated by Katja Luther about 6 years ago

  • Status changed from Resolved to Closed
  • Assignee changed from Katja Luther to Andreas Müller
Actions
Copy link
 #18

Updated by Katja Luther about 6 years ago

Actions
Copy link

Also available in: Atom PDF