2 * Copyright (C) 2007 EDIT
3 * European Distributed Institute of Taxonomy
4 * http://www.e-taxonomy.eu
6 * The contents of this file are subject to the Mozilla Public License Version 1.1
7 * See LICENSE.TXT at the top of this package for the full license terms.
10 package eu
.etaxonomy
.cdm
.app
.synthesysImport
;
12 import java
.net
.URISyntaxException
;
14 import org
.apache
.log4j
.Logger
;
16 import eu
.etaxonomy
.cdm
.app
.common
.CdmDestinations
;
17 import eu
.etaxonomy
.cdm
.database
.DbSchemaValidation
;
18 import eu
.etaxonomy
.cdm
.database
.ICdmDataSource
;
19 import eu
.etaxonomy
.cdm
.io
.common
.CdmDefaultImport
;
20 import eu
.etaxonomy
.cdm
.io
.common
.IImportConfigurator
.CHECK
;
21 import eu
.etaxonomy
.cdm
.io
.specimen
.excel
.in
.SpecimenSynthesysExcelImportConfigurator
;
23 public class SpecimenImport
{
24 private static Logger logger
= Logger
.getLogger(SpecimenImport
.class);
26 //database validation status (create, update, validate ...)
27 static DbSchemaValidation hbm2dll
= DbSchemaValidation
.CREATE
;
28 final static String excelSource
= "/home/patricia/Desktop/CDMtabular6493890c4d_18_11_08.xls";
29 // final static String xmlSource = "C:\\localCopy\\eclipse\\cdmlib\\app-import\\src\\main\\resources\\specimenABCD\\CDMtabular9c04a474e2_23_09_08.xls";
32 static final ICdmDataSource cdmDestination
= CdmDestinations
.cdm_test_patricia();
34 static final CHECK check
= CHECK
.IMPORT_WITHOUT_CHECK
;
39 public static void main(String
[] args
) {
42 source
= new URI(excelSource
);
43 System
.out
.println(source
);
44 System
.out
.println("Start import from Synthesys Specimen data("+ source
.toString() + ") ...");
46 ICdmDataSource destination
= cdmDestination
;
47 SpecimenSynthesysExcelImportConfigurator specimenImportConfigurator
= SpecimenSynthesysExcelImportConfigurator
.NewInstance(source
, destination
);
49 specimenImportConfigurator
.setSourceSecId("specimen");
50 specimenImportConfigurator
.setCheck(check
);
51 specimenImportConfigurator
.setDbSchemaValidation(hbm2dll
);
52 specimenImportConfigurator
.setDoAutomaticParsing(true);
53 specimenImportConfigurator
.setReUseExistingMetadata(true);
54 specimenImportConfigurator
.setReUseTaxon(true);
55 specimenImportConfigurator
.setSourceReference(null);
56 specimenImportConfigurator
.setTaxonReference(null);
59 CdmDefaultImport
<SpecimenSynthesysExcelImportConfigurator
> specimenImport
= new CdmDefaultImport
<SpecimenSynthesysExcelImportConfigurator
>();
60 //new Test().invoke(tcsImportConfigurator);
61 specimenImport
.invoke(specimenImportConfigurator
);
62 System
.out
.println("End import from SpecimenData ("+ source
.toString() + ")...");
63 } catch (URISyntaxException e
) {