Project

General

Profile

Download (4.06 KB) Statistics
| Branch: | Revision:
1
/**
2
 * Copyright (C) 2007 EDIT
3
 * European Distributed Institute of Taxonomy
4
 * http://www.e-taxonomy.eu
5
 *
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.
8
 */
9

    
10
package eu.etaxonomy.cdm.app.proibiosphere;
11

    
12
import java.io.File;
13
import java.net.URI;
14
import java.net.URISyntaxException;
15

    
16
import org.apache.log4j.Logger;
17

    
18
import eu.etaxonomy.cdm.app.common.CdmDestinations;
19
import eu.etaxonomy.cdm.database.DbSchemaValidation;
20
import eu.etaxonomy.cdm.database.ICdmDataSource;
21
import eu.etaxonomy.cdm.io.common.CdmDefaultImport;
22
import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;
23
import eu.etaxonomy.cdm.io.specimen.excel.in.SpecimenSynthesysExcelImportConfigurator;
24
import eu.etaxonomy.cdm.model.agent.Person;
25
import eu.etaxonomy.cdm.model.reference.Reference;
26
import eu.etaxonomy.cdm.model.reference.ReferenceFactory;
27

    
28

    
29
/**
30
 * @author PK
31
 * @created 19.09.2008
32
 */
33
public class SynthesysCacheActivator {
34
    @SuppressWarnings("unused")
35
    private static Logger logger = Logger.getLogger(SynthesysCacheActivator.class);
36

    
37
    //database validation status (create, update, validate ...)
38

    
39
    //    final static String xmlSource = "/home/pkelbert/workspace/proibiosphere/cdmlib-io/target/test-classes/eu/etaxonomy/cdm/io/specimen/excel/in/ExcelImportConfiguratorTest-input.xls";
40
    final static String xmlSource = "/home/pkelbert/Documents/Proibiosphere/ChenopodiumQuentin/dca UK records.xls";
41

    
42

    
43
    static final ICdmDataSource cdmDestination = CdmDestinations.proibiosphere_spiders_local();
44
    static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;
45
    //    static final ICdmDataSource cdmDestination = CdmDestinations.proibiosphere_local();
46
    //    static DbSchemaValidation hbm2dll = DbSchemaValidation.VALIDATE;
47
    static final CHECK check = CHECK.IMPORT_WITHOUT_CHECK;
48

    
49
    /**
50
     * @param args
51
     */
52
    public static void main(String[] args) {
53
        URI source;
54
        try {
55
            URI uri = new File(xmlSource).toURI();
56
            source = new URI(uri.toString());
57
            System.out.println(source.toString());
58
            System.out.println("Start import from  Excel Specimen data("+ source.toString() + ") ...");
59

    
60
            ICdmDataSource destination = cdmDestination;
61
            SpecimenSynthesysExcelImportConfigurator specimenImportConfigurator = SpecimenSynthesysExcelImportConfigurator.NewInstance(source,  destination);
62

    
63
            specimenImportConfigurator.setSourceSecId("specimen");
64
            specimenImportConfigurator.setCheck(check);
65
            specimenImportConfigurator.setDbSchemaValidation(hbm2dll);
66
            specimenImportConfigurator.setDoAutomaticParsing(true);
67
            specimenImportConfigurator.setReUseExistingMetadata(true);
68
            specimenImportConfigurator.setAskForDate(true);
69
            specimenImportConfigurator.setDefaultAuthor("L.");
70
            //  specimenImportConfigurator.setClassificationName("Chenopodium");
71

    
72
            specimenImportConfigurator.setReUseTaxon(true);
73

    
74
            Reference reference = ReferenceFactory.newGeneric();
75
            reference.setTitleCache("Chenopodium vulvaria observations from the Botanical Society of the British Isles", true);
76
            Person p = Person.NewInstance();
77
            p.setFirstname("Quentin");
78
            p.setLastname("Groom");
79
            p.addEmailAddress("qgroom@bsbi.co.uk");
80
            reference.setAuthorship(p);
81
            reference.setOrganization("Botanical Society of the British Isles");
82

    
83
            specimenImportConfigurator.setSourceReference(reference);
84
            specimenImportConfigurator.setTaxonReference(null);
85

    
86
            // invoke import
87
            CdmDefaultImport<SpecimenSynthesysExcelImportConfigurator> specimenImport = new CdmDefaultImport<>();
88
            //new Test().invoke(tcsImportConfigurator);
89
            specimenImport.invoke(specimenImportConfigurator);
90
            System.out.println("End import from SpecimenData ("+ source.toString() + ")...");
91
        } catch (URISyntaxException e) {
92
            e.printStackTrace();
93
        }
94

    
95
    }
96

    
97

    
98
}
(2-2/3)