4 package eu
.etaxonomy
.cdm
.io
.excel
.taxa
;
7 import java
.net
.URISyntaxException
;
8 import java
.util
.ArrayList
;
9 import java
.util
.HashMap
;
12 import org
.apache
.log4j
.Logger
;
13 import org
.springframework
.transaction
.TransactionStatus
;
15 import eu
.etaxonomy
.cdm
.api
.application
.CdmApplicationController
;
16 import eu
.etaxonomy
.cdm
.common
.CdmUtils
;
17 import eu
.etaxonomy
.cdm
.common
.ExcelUtils
;
18 import eu
.etaxonomy
.cdm
.database
.ICdmDataSource
;
19 import eu
.etaxonomy
.cdm
.io
.common
.CdmIoBase
;
20 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
;
21 import eu
.etaxonomy
.cdm
.io
.common
.IIoConfigurator
;
22 import eu
.etaxonomy
.cdm
.io
.common
.MapWrapper
;
23 import eu
.etaxonomy
.cdm
.io
.excel
.common
.ExcelImporterBase
;
24 import eu
.etaxonomy
.cdm
.io
.excel
.taxa
.NormalExplicitImporter
;
25 import eu
.etaxonomy
.cdm
.io
.jaxb
.JaxbImportConfigurator
;
26 import eu
.etaxonomy
.cdm
.model
.agent
.Person
;
27 import eu
.etaxonomy
.cdm
.model
.common
.CdmBase
;
28 import eu
.etaxonomy
.cdm
.model
.common
.Language
;
29 import eu
.etaxonomy
.cdm
.model
.description
.TaxonDescription
;
30 import eu
.etaxonomy
.cdm
.model
.name
.NomenclaturalStatus
;
31 import eu
.etaxonomy
.cdm
.model
.name
.Rank
;
32 import eu
.etaxonomy
.cdm
.model
.name
.TaxonNameBase
;
33 import eu
.etaxonomy
.cdm
.model
.reference
.ReferenceBase
;
34 import eu
.etaxonomy
.cdm
.model
.taxon
.Taxon
;
37 * @author a.babadshanjan
41 public abstract class TaxonExcelImporterBase
extends ExcelImporterBase
{
43 private static final Logger logger
= Logger
.getLogger(TaxonExcelImporterBase
.class);
48 * ParentId - create taxon relationship
49 * Rank - create taxon name of this rank
57 protected static final String ID_COLUMN
= "Id";
58 protected static final String PARENT_ID_COLUMN
= "ParentId";
59 protected static final String RANK_COLUMN
= "Rank";
60 protected static final String AUTHOR_COLUMN
= "Author";
61 protected static final String NAME_STATUS_COLUMN
= "NameStatus";
62 protected static final String VERNACULAR_NAME_COLUMN
= "VernacularName";
63 protected static final String LANGUAGE_COLUMN
= "Language";
65 protected enum Columns
{
69 ScientificName("ScientificName"),
71 NameStatus("NameStatus"),
72 VernacularName("VernacularName"),
78 Columns(String head
) {
82 public String
head() {
86 public String
value() {
91 private String rank
= "";
92 private String nameStatus
= "";
93 private String commonName
= "";
94 private String author
= "";
95 private String language
= "";
96 private String reference
= "";
98 private int parentId
= 0;
100 /* Need already processed records? */
102 public String
getRank() {
107 public void setRank(String rank
) {
117 public void setId(int id
) {
122 public int getParentId() {
124 return this.parentId
;
127 public void setParentId(int parentId
) {
129 this.parentId
= parentId
;