Project

General

Profile

Actions

bug #9061

open

Create analyze framework for CDM Excel imports

Added by Andreas Müller over 3 years ago. Updated over 2 years ago.

Status:
New
Priority:
New
Category:
cdmadapter
Target version:
Start date:
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Found in Version:
Tags:

Description

This framework should allow to analyze import data before running the import.

This should include

  • analyzeWorkbook(): ananlyzes the overall Workbook structure (obligatory worksheets with correct names, tables which are not required, ...)
  • analyzeWorksheetStructure(): which analyzes the existing columns (obligatory columns, facultative columns, columns not in use, ...)
  • analyzeData: which analyzes the data in the worksheet(s) on correctness, this includes
    • test new data: is the new data correctly formatted so it can be imported
    • test persistent data: e.g. do taxon UUIDs match with existing accepted taxa
    • ...

The framework in general should only work for csv data.

The result should be generic so it can be used for any table based imports (or even for non-table based imports).
The result should distinguish data which is generally impossible to import (e.g. a required column could not be found), data which looses certain records during import and data which has slightly incorrect import result (e.g. 1 not required field in a record can not be imported).


Related issues

Related to EDIT - task #9041: Import Flora of Uzbekistan taxa altitudesClosedAndreas Müller

Actions
Related to EDIT - bug #9049: Import Flora of Uzbekistan taxa habitatsClosedAndreas Müller

Actions
Actions #1

Updated by Andreas Müller over 3 years ago

  • Description updated (diff)
Actions #2

Updated by Andreas Müller over 3 years ago

  • Related to task #9041: Import Flora of Uzbekistan taxa altitudes added
Actions #3

Updated by Andreas Müller over 3 years ago

  • Related to bug #9049: Import Flora of Uzbekistan taxa habitats added
Actions #4

Updated by Andreas Müller about 3 years ago

  • Target version changed from Release 5.18 to Release 5.19
Actions #5

Updated by Andreas Müller almost 3 years ago

  • Target version changed from Release 5.19 to Release 5.21
Actions #6

Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 5.21 to Release 5.22
Actions #7

Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 5.22 to Release 5.45
Actions

Also available in: Atom PDF