EDIT

//            IImageMetadata metadata = Sanselan.getMetadata(file);

            ImageMetadata metadata = Imaging.getMetadata(file);

            List<? extends ImageMetadataItem> items = metadata.getItems();

//                System.out.println(item.getKeyword() +  ":    " + item.getText());

                if (metadataItem instanceof GenericImageMetadataItem){

                    GenericImageMetadataItem item = (GenericImageMetadataItem) metadataItem;

        //System.out.println(documents);

        for (String docId : docs.keySet()){

            for (String treatment:treatments) {

                List<String>tmplist = startPages.get(Integer.valueOf(treatment.split("---")[0]));

                if (tmplist == null) {

                }

                tmplist.add(treatment.split("---")[3]);

                startPages.put(Integer.valueOf(treatment.split("---")[0]),tmplist);

            }

            pages.addAll(startPages.keySet());

            Collections.sort(pages);

            log.info("Document "+docId+" should have "+treatments.size()+" treatments");

                List<URI> uritmp = documentMap.get(docId);

                if (uritmp == null) {

                }

                for (int page:pages) {

                    for (String treatment: startPages.get(page)) {

                documentMap.put(docId, uritmp);

            }

        return documentMap;

    }

			String[] filterList, String urlstr)

					throws MalformedURLException, IOException {

		List<String> docList;

		String inputLine;

		for(String filter : filterList){

		    URL plaziURL = new URL(urlstr);

		    BufferedReader in = new BufferedReader(new InputStreamReader(plaziURL.openStream()));

		    //TODO lastUpdate field

		    //            if(!plaziNotServer){

		    while ((inputLine = in.readLine()) != null) {

		return documents;

	}

    private static boolean doImportDocument(String document, int nbtreatments) {

        if (nbtreatments>400) {

        */

    }

    private static boolean askIfReuseSecundum() {

        //        logger.info("getFullReference for "+ name);

        JTextArea textArea = new JTextArea("Reuse the secundum present in the current classification? " +

        }

    }

    private static Reference askForSecundum() {

        //        logger.info("getFullReference for "+ name);

        JTextArea textArea = new JTextArea("Enter the secundum name");

        ref.setTitle(s);

        return ref;

    }

}

/**

 * @author a.mueller

 * @since 17.10.2008

 */

public class DipteraDistributionParser {

	private static final Logger logger = Logger.getLogger(DipteraDistributionParser.class);

		app.commitTransaction(txStatus);

	}

	static int countNot = 0;

	static int countYes = 0;

	}

	private String adaptWordsToTdwg(String word){

		word = word.replace(",", "").replace(";", "");

		higherAreas.add("NT");

	}

	public static void main(String[] args) {

		CdmApplicationController app = null;

		DbSchemaValidation val = DbSchemaValidation.UPDATE;

						String mimeType = imageinfo.getMimeType();

						String suffix = "jpg";

						// URL for this image

						URL url = null;

						try {

							logger.warn("URL is malformed: "+ url);

						}

						ImageFile imageFile = ImageFile.NewInstance(url.toURI(),null, imageinfo.getHeight(), imageinfo.getWidth());

						MediaRepresentation representation = MediaRepresentation.NewInstance(mimeType, suffix);

						representation.addRepresentationPart(imageFile);

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.algaterra;

import java.sql.ResultSet;

import eu.etaxonomy.cdm.model.taxon.Taxon;

import eu.etaxonomy.cdm.model.taxon.TaxonBase;

/**

 * Import for AlgaTerra images from table

 * @author a.mueller

 */

@Component

public class AlgaTerraPictureImport  extends AlgaTerraImageImportBase {

	private static int modCount = 5000;

	private static final String pluralString = "pictures";

		super(dbTableName, pluralString);

	}

	@Override

	protected String getIdQuery(BerlinModelImportState state) {

		String result = " SELECT p.PictureId "

		return result;

	}

	@Override

	protected String getRecordQuery(BerlinModelImportConfigurator config) {

			String strQuery =

	            " FROM Picture p INNER JOIN Fact f ON p.PictureId = f.ExtensionFk LEFT OUTER JOIN PTaxon pt ON f.PTNameFk = pt.PTNameFk AND f.PTRefFk = pt.PTRefFk "

	            + 	" WHERE f.FactCategoryFk = 205 AND ( p.PictureID IN (" + ID_LIST_TOKEN + ")     )"

	            + " ORDER BY p.PictureId, f.factId, pt.RIdentifier ";

		return strQuery;

	}

	@Override

    public boolean doPartition(ResultSetPartitioner partitioner, BerlinModelImportState bmState) {

		boolean success = true;

		AlgaTerraImportState state = (AlgaTerraImportState)bmState;

		Map<String, TaxonBase> taxonMap = partitioner.getObjectMap(BerlinModelTaxonImport.NAMESPACE);

		Map<String, DerivedUnit> specimenMap = partitioner.getObjectMap(AlgaTerraFactEcologyImport.FACT_ECOLOGY_NAMESPACE);

		ResultSet rs = partitioner.getResultSet();

		try {

			int i = 0;

			//for each reference

            while (rs.next()){

				int pictureId = rs.getInt("PictureID");

				int taxonId = rs.getInt("RIdentifier");

				int factId = rs.getInt("FactId");

				//TODO etc. Created, Notes, Copyright, TermsOfUse etc.

				try {

					TaxonBase<?> taxonBase = taxonMap.get(String.valueOf(taxonId));

						taxaToSave.add(taxon);

					}

				} catch (Exception e) {

					logger.warn("Exception in " + getTableName() + ": PictureId " + pictureId + ". " + e.getMessage());

					e.printStackTrace();

				}

            }

			logger.warn(pluralString + " to save: " + taxaToSave.size());

			getTaxonService().save(taxaToSave);

			return success;

		}

	}

	private void handlePictureSpecificFields(ResultSet rs, Media media, AlgaTerraImportState state, Map<String, DerivedUnit> specimenMap) throws SQLException {

		Integer specimenFactId = nullSafeInt(rs, "FactFk");

		if (specimenFactId != null){

				}

			}

		}

	}

	@Override

	public Map<Object, Map<String, ? extends CdmBase>> getRelatedObjectsForPartition(ResultSet rs, BerlinModelImportState state) {

	    String nameSpace;

		Set<String> idSet;

		try{

			while (rs.next()){

				handleForeignKey(rs, taxonIdSet, "RIdentifier");

		return result;

	}

	@Override

	protected boolean doCheck(BerlinModelImportState state){

		IOValidator<BerlinModelImportState> validator = new AlgaTerraTypeImportValidator();

		AlgaTerraImportConfigurator config = ((AlgaTerraImportState) bmState).getAlgaTerraConfigurator();

		return !  ( config.isDoTypes() && config.isDoImages()) ;

	}

}

import eu.etaxonomy.cdm.model.common.CdmBase;

import eu.etaxonomy.cdm.strategy.cache.agent.INomenclaturalAuthorCacheStrategy;

/**

 * @author a.mueller

 * @since 20.03.2008

		return success;

	}

    private TeamOrPersonBase<?> handleTeam(BerlinModelImportState state, Team team, String authorTeamCache,

            String fullAuthorTeamCache, boolean preliminaryFlag, int authorTeamId) {

        return result;

    }

    protected void checkTeamNomenclaturalTitle(Team team, String authorTeamCache, int authorTeamId) {

        if (team.getCacheStrategy().getNomenclaturalTitle(team).equals(authorTeamCache)){

            team.setProtectedNomenclaturalTitleCache(false);

        }

    }

    protected void checkTeamTitleCache(Team team, String fullAuthorTeamCache, int authorTeamId) {

        INomenclaturalAuthorCacheStrategy<Team> formatter = team.getCacheStrategy();

        if (team.generateTitle().equals(fullAuthorTeamCache)){

    private static final String TEAM_SPLITTER = "(,|&)";

    protected static String[] splitTeam(String teamCache) {

        if (teamCache == null){

            return new String[0];

        return teamCache.split(TEAM_SPLITTER);

    }

    protected static boolean hasTeamSeparator(String teamCache) {

        if (isBlank(teamCache)){

            return false;

        }

    }

    @Override

	public Map<Object, Map<String, ? extends CdmBase>> getRelatedObjectsForPartition(ResultSet rs, BerlinModelImportState state)  {

		return result;

	}

	private Set<String> makeAuthorIdList(ResultSet rs) {

		String authorTeamIdList = "";

		try {

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.berlinModel.in;

import java.sql.ResultSet;

import eu.etaxonomy.cdm.model.term.OrderedTermVocabulary;

import eu.etaxonomy.cdm.strategy.exceptions.UnknownCdmTypeException;

/**

 * @author a.mueller

 * @since 20.03.2008

		try{

		    Map<Object, Map<String, ? extends CdmBase>> result = new HashMap<>();

			while (rs.next()){

				handleForeignKey(rs, taxonIdSet, "taxonId");

			}

    private static final Logger logger = Logger.getLogger(BerlinModelTaxonRelationImport.class);

	public static final String TREE_NAMESPACE = "PTRefFk";

	private static int modCount = 30000;

	private static final String pluralString = "taxon relations";

		return;

	}

	private Set<String> getTreeReferenceIdSet(BerlinModelImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		ResultSet rs = source.getResultSet(getClassificationQuery(state)) ;

		while (rs.next()){

			Object id = rs.getObject("PTRefFk");

		Map<Object, Map<String, ? extends CdmBase>> result = new HashMap<>();

		try{

			while (rs.next()){

				handleForeignKey(rs, nameIdSet, "NameFk");

				handleForeignKey(rs, referenceIdSet, "RefFk");

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.berlinModel.in.validation;

import java.sql.ResultSet;

		if (result == false ){System.out.println("========================================================");}

		return result;

	}

	//******************************** CHECK *************************************************

		private static boolean checkArticlesWithoutJournal(BerlinModelImportConfigurator config){

	                        " (SELECT refId FROM %s ))" , config.getReferenceIdTable()) ;

				}

				ResultSet rs = source.getResultSet(strQuery);

				boolean firstRow = true;

				while (rs.next()){

			}

		}

		private static boolean checkPartOfUnresolved(BerlinModelImportConfigurator config){

			try {

				boolean result = true;

				Source source = config.getSource();

				ResultSet rs = source.getResultSet(strQuery);

				int colCount = rs.getMetaData().getColumnCount();

				for (int c = 0; c < colCount ; c++){

					existingAttributes.add(rs.getMetaData().getColumnLabel(c+1).toLowerCase());

				}

			return result;

		}

		@Override

        @Deprecated  //use validate(state, import) instead

		public boolean validate(BerlinModelImportState state) {

			logger.warn("BerlinModelReferenceImport uses wrong validation method");

			return false;

		}

}

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.caryo;

import java.sql.ResultSet;

import eu.etaxonomy.cdm.model.taxon.TaxonBase;

import eu.etaxonomy.cdm.strategy.exceptions.UnknownCdmTypeException;

/**

 * @author a.mueller

 * @since 20.02.2010

 */

@Component

public class CaryoTaxonImport  extends DbImportBase<CaryoImportState, CaryoImportConfigurator> {

	private final int modCount = 10000;

	private static final String pluralString = "taxa";

	private static final String dbTableName = "CARYOPHYLLALES";

	private Classification classification;

	public CaryoTaxonImport(){

		super(dbTableName, pluralString);

	}

	@Override

	protected String getIdQuery(CaryoImportState state) {

		String strRecordQuery =

		return strRecordQuery;

	}

	@Override

	protected String getRecordQuery(CaryoImportConfigurator config) {

		String strRecordQuery =

		return strRecordQuery;

	}

	@Override

	public boolean doPartition(ResultSetPartitioner partitioner, CaryoImportState state) {

		boolean success = true;

		classification = getClassification(state);

//        	      ,[Basionym]

//        	      ,[OriginalCitation]

				IBotanicalName name = TaxonNameFactory.NewBotanicalInstance(Rank.GENUS());

				name.setGenusOrUninomial(genus);

				makeAuthors(name, autoren, id);

				name.setNomenclaturalMicroReference(pages);

				makeStatus(name, nomStatusStr, id);

				Taxon taxon = Taxon.NewInstance(name, state.getTransactionalSourceReference());

				handleTypes(state, rs, taxon, typeStr, id);

				handleBasionym(state, rs, taxon, basioStr, id);

				taxon.addSource(OriginalSourceType.Import, String.valueOf(taxonId), "NCUGenID", sec, null);

				objectsToSave.add(taxon);

            }

			taxon.addSynonym(syn, SynonymType.HOMOTYPIC_SYNONYM_OF());

			getTaxonService().save(syn);

		}

	}

	private void handleTypes(CaryoImportState state, ResultSet rs, Taxon taxon, String origType, Integer id) {

		NameTypeDesignation desig = NameTypeDesignation.NewInstance();

		String type = origType;

			}

			name.addTypeDesignation(desig, true);

		}

	}

	private String makeTypeNomStatus(IBotanicalName typeName, String type) {

		if (type.endsWith(", nom. illeg.")){

			type = type.replaceAll(", nom. illeg.", "");

		return type;

	}

	private void makeStatus(IBotanicalName name, String nomStatusStr, Integer id) throws SQLException {

		if (StringUtils.isNotBlank(nomStatusStr)){

			NomenclaturalStatusType nomStatusType;

			NomenclaturalStatus status = NomenclaturalStatus.NewInstance(nomStatusType);

			name.addStatus(status);

		}

	}

	private INomenclaturalReference makeNomRef(CaryoImportState state, ResultSet rs, Integer id) throws SQLException {

		INomenclaturalReference result;

		String periodicalTitle = rs.getString("PeriodicalTitle");

		ref.setDatePublished(tp);

	}

	private Integer[] getDay(String pre, Integer id) {

		Integer[] result = new Integer[2];

		if (! StringUtils.isBlank(pre)){

		return result;

	}

	private TeamOrPersonBase<?> getInAuthor(String inAutorStr) {

		if (StringUtils.isBlank(inAutorStr)){

			return null;

		return inAuthor;

	}

	private void makeAuthors(IBotanicalName name, String autoren, Integer id) {

		String[] parsedAuthorTeams = getParsedAuthors(autoren);

		name.setBasionymAuthorship(getTeam(parsedAuthorTeams[0], id));

		name.setExBasionymAuthorship(getTeam(parsedAuthorTeams[1], id));

		name.setCombinationAuthorship(getTeam(parsedAuthorTeams[2], id));

		name.setExCombinationAuthorship(getTeam(parsedAuthorTeams[3], id));

	}

	private TeamOrPersonBase<?> getNomRefAuthor(String authorStr, Integer id) {

		return team;

	}

	private TeamOrPersonBase<?> getTeam(String author, Integer id) {

		if (StringUtils.isBlank(author)){

			return null;

		return result;

	}

	private void doInAuthors(CaryoImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		String sql = "SELECT DISTINCT inAutor FROM " + getTableName() + " WHERE inAutor IS NOT NULL AND inAutor <> '' ";

				getAgentService().save(team);

			}

		}

	}

	private void doAuthors(CaryoImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		String sql = "SELECT DISTINCT Autoren FROM " + getTableName() + " WHERE Autoren IS NOT NULL AND Autoren <> '' ";

		}

	}

	private void doTypeAuthors(CaryoImportState state) {

		doTeam("Dinter & Derenb.");

		doTeam("Marloth");

		doTeam("Maerkl.");

		doTeam("Vierh.");

		doTeam("Exell");

	}

	protected void doTeam(String teamStr) {

		if (StringUtils.isBlank(teamStr)){

			return;

		return result;

	}

	private String[] getParsedAuthors(String autorenStr) {

		String[] result = new String[4];

		String basioFull = null;

		return result;

	}

	private String[] splitExAuthors(String author) {

		String[] result = new String[2];

		if (author != null){

		return result;

	}

	private void doBooks(CaryoImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		String sql = "SELECT DISTINCT BookTitle FROM " + getTableName() + " WHERE BookTitle IS NOT NULL AND BookTitle <> '' ";

		}

	}

	private void doJournals(CaryoImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		String sqlPeriodical = "SELECT DISTINCT PeriodicalTitle FROM " + getTableName() + " WHERE PeriodicalTitle IS NOT NULL AND PeriodicalTitle <> '' ";

		}

	}

	private void doFamilies(CaryoImportState state) throws SQLException {

		Source source = state.getConfig().getSource();

		String sqlFamily = "SELECT DISTINCT Family FROM " + getTableName() + " WHERE Family IS NOT NULL";

				getTaxonService().save(taxon);

			}

		}

	}

	private Classification getClassification(CaryoImportState state) {

		return this.classification;

	}

	@Override

	public Map<Object, Map<String, ? extends CdmBase>> getRelatedObjectsForPartition(ResultSet rs, CaryoImportState state) {

//		String nameSpace;

//		Class cdmClass;

//		Set<String> idSet;

//		try{

//

//			while (rs.next()){

////				handleForeignKey(rs, taxonIdSet, "taxonId");

		return result;

	}

	@Override

	protected boolean doCheck(CaryoImportState state){

		return true;

	}

	@Override

    protected boolean isIgnore(CaryoImportState state){

		return ! state.getConfig().isDoTaxa();

	}

}

 * The contents of this file are subject to the Mozilla Public License Version 1.1

 * See LICENSE.TXT at the top of this package for the full license terms.

 */

package eu.etaxonomy.cdm.io.cyprus;

import java.util.Arrays;

 * @author a.babadshanjan

 * @since 08.01.2009

 */

@Component

public class CyprusExcelImport

        extends ExcelImportBase<CyprusImportState, CyprusImportConfigurator, ExcelRowBase> {

    private static final Logger logger = Logger.getLogger(CyprusExcelImport.class);

	@Override

		return ! state.getConfig().isDoTaxa();

	}

	@Override

	protected boolean doCheck(CyprusImportState state) {

		logger.warn("DoCheck not yet implemented for CyprusExcelImport");

	protected static final String RED_DATA_BOOK_CATEGORY_COLUMN = "red data book category";

	protected static final String SYSTEMATICS_COLUMN = "systematics";

	// TODO: This enum is for future use (perhaps).

	protected enum Columns {

//		Id("Id"),

		}

	}

	@Override

    protected void analyzeRecord(Map<String, String> record, CyprusImportState state) {

    			continue;

    		}

    		if (key.equalsIgnoreCase(SPECIES_COLUMN)) {

//    			int ivalue = floatString2IntValue(value);

    			cyprusRow.setSpecies(value);

				getTermService().save(endemism);

				//status

				UUID indigenousUuid = transformer.getPresenceTermUuid("IN");

				indigenous = this.getPresenceTerm(state, indigenousUuid, "indigenous", "Indigenous", "IN", false);

				getTermService().save(indigenous);

				cultivatedDoubtful = this.getPresenceTerm(state, cultivatedDoubtfulUuid, "cultivated?", "Cultivated?", "CU?", false);

				getTermService().save(cultivatedDoubtful);

				UUID casualUuid = transformer.getPresenceTermUuid("CA");

				casual = this.getPresenceTerm(state, casualUuid, "casual", "Casual", "CA", false);

				getTermService().save(casual);

				casualDoubtful = this.getPresenceTerm(state, casualDoubtfulUuid, "casual?", "Casual?", "CA?", false);

				getTermService().save(casualDoubtful);

				UUID nonInvasiveUuid = transformer.getPresenceTermUuid("NN");

				nonInvasive = this.getPresenceTerm(state, nonInvasiveUuid, "naturalized  non-invasive", "Naturalized  non-invasive", "NN", false);

				getTermService().save(nonInvasive);

		return;

    }

	private void makeHigherTaxa(CyprusImportState state, CyprusRow taxonLight, Taxon speciesTaxon, Reference citation, String microCitation) {

		String divisionStr = taxonLight.getDivision();

		String genusStr = taxonLight.getGenus();

		}

	}

	private void makeStatus(String statusString, Taxon mainTaxon) {

		//status

		if (StringUtils.isNotBlank(statusString)){

		}

	}

	private void makeRedBookCategory(String redBookCategory, Taxon mainTaxon) {

		//red data book category

		if (StringUtils.isNotBlank(redBookCategory)){

		}

	}

	/**

	 *  Stores parent-child, synonym and common name relationships

	 */

		return;

	}

	private TaxonBase<?> createTaxon(CyprusImportState state, Rank rank, String taxonNameStr,

			Class<?> statusClass, NomenclaturalCode nc) {

		TaxonBase<?> taxonBase;

			taxonNameBase = parser.parseFullName(taxonNameStr, nc, rank);

			//taxonNameBase.setNameCache(taxonNameStr);

		}

		//Create the taxon

		}

		return success;

	}

}

/**

* Copyright (C) 2007 EDIT

* http://www.e-taxonomy.eu

* The contents of this file are subject to the Mozilla Public License Version 1.1

* See LICENSE.TXT at the top of this package for the full license terms.

*/

package eu.etaxonomy.cdm.io.globis;

import java.util.HashSet;

import eu.etaxonomy.cdm.io.common.mapping.UndefinedTransformerMethodException;

import eu.etaxonomy.cdm.model.common.ExtensionType;

import eu.etaxonomy.cdm.model.description.Feature;

import eu.etaxonomy.cdm.model.location.Country;

/**

 * @author a.mueller

 * @since 01.03.2010

 */

public final class GlobisTransformer extends InputTransformerBase {

	//marker types

	public static final UUID uuidCheckedMarkerType = UUID.fromString("f2a7926f-def1-49a6-b642-9b81e6b1e35c");

	public static final UUID uuidOldRecordMarkerType = UUID.fromString("8616edc5-00d4-40ca-aca4-d48ec32231e9");

	public static final UUID uuidNotAvailableMarkerType = UUID.fromString("6931e584-6fc2-44ab-9084-e6452f8cd5d1");

	//extension types

	public static final UUID uuidExtTypeNotAvailableReason = UUID.fromString("d7dd5632-8c65-4058-b804-d1291560ac4c");

		if (StringUtils.isBlank(area)){return null;

		}else if (area.equals("Argentina")){return Country.ARGENTINAARGENTINEREPUBLIC();

		}else if (area.equals("Bolivia")){return Country.BOLIVIAREPUBLICOF();

		}else if (area.equals("France")){return Country.FRANCEFRENCHREPUBLIC();

		}else if (area.equals("Poland")){return Country.POLANDPOLISHPEOPLESREPUBLIC();

		}else if (area.equals("Brazil")){return Country.BRAZILFEDERATIVEREPUBLICOF();

		}else if (area.equals("Cuba")){return Country.BRAZILFEDERATIVEREPUBLICOF();

		}else if (area.equals("Guatemala")){return Country.GUATEMALAREPUBLICOF();

		}else if (area.equals("Colombia")){return Country.COLOMBIAREPUBLICOF();

		}else if (area.equals("India")){return Country.INDIAREPUBLICOF();

		}else if (area.equals("Mexico")){return Country.MEXICOUNITEDMEXICANSTATES();

		}else if (area.equals("Peru")){return Country.PERUREPUBLICOF();

		}else if (area.equals("Ecuador")){return Country.ECUADORREPUBLICOF();

		}else if (area.equals("Botswana")){return Country.BOTSWANAREPUBLICOF();

		}else if (area.equals("Burundi")){return Country.BURUNDIREPUBLICOF();

		}else if (area.equals("Cameroon")){return Country.CAMEROONUNITEDREPUBLICOF();

		}else if (area.equals("Congo")){return Country.CONGOPEOPLESREPUBLICOF();

		}else if (area.equals("Zaire")){return Country.CONGODEMOCRATICREPUBLICOF();

		}else if (area.equals("Equatorial Guinea")){return Country.EQUATORIALGUINEAREPUBLICOF();

		}else if (area.equals("Gabon")){return Country.GABONGABONESEREPUBLIC();

		}else if (area.equals("Liberia")){return Country.LIBERIAREPUBLICOF();

		}else if (area.equals("Togo")){return Country.TOGOTOGOLESEREPUBLIC();

		}else if (area.equals("Guinea")){return Country.GUINEAREVOLUTIONARYPEOPLESREPCOF();

		}else if (area.equals("Guinea-Bissau")){return Country.GUINEABISSAUREPUBLICOF();

		}else if (area.equals("Malawi")){return Country.MALAWIREPUBLICOF();

		}else if (area.equals("Mozambique")){return Country.MOZAMBIQUEPEOPLESREPUBLICOF();

		}else if (area.equals("Nigeria")){return Country.NIGERIAFEDERALREPUBLICOF();

		}else if (area.equals("Sudan")){return Country.SUDANDEMOCRATICREPUBLICOFTHE();

		}else if (area.equals("Madagascar")){return Country.MADAGASCARREPUBLICOF();

		}else if (area.equals("Comoros")){return Country.COMOROSUNIONOFTHE();

		}else if (area.equals("Vietnam")){return Country.VIETNAMSOCIALISTREPUBLICOF();

		}else if (area.equals("Thailand")){return Country.THAILANDKINGDOMOF();

		}else if (area.equals("Bhutan")){return Country.BHUTANKINGDOMOF();

		}else if (area.equals("Nepal")){return Country.NEPALKINGDOMOF();

		}else if (area.equals("Pakistan")){return Country.PAKISTANISLAMICREPUBLICOF();

		}else if (area.equals("Singapore")){return Country.SINGAPOREREPUBLICOF();

		}else if (area.equals("Honduras")){return Country.HONDURASREPUBLICOF();

		}else if (area.equals("Nicaragua")){return Country.NICARAGUAREPUBLICOF();

		}else if (area.equals("Trinidad and Tobago")){return Country.TRINIDADANDTOBAGOREPUBLICOF();

		}else if (area.equals("North Korea")){return Country.KOREADEMOCRATICPEOPLESREPUBLICOF();

		}else if (area.equals("South Korea")){return Country.KOREAREPUBLICOF();

		}else if (area.equals("Taiwan")){return Country.TAIWANPROVINCEOFCHINA();

		}else if (area.equals("Somalia")){return Country.SOMALIASOMALIREPUBLIC();

		}else if (area.equals("Albania")){return Country.ALBANIAPEOPLESSOCIALISTREPUBLICOF();

		}else if (area.equals("Algeria")){return Country.ALGERIAPEOPLESDEMOCRATICREPUBLICOF();

		}else if (area.equals("Andorra")){return Country.ANDORRAPRINCIPALITYOF();

		}else if (area.equals("Austria")){return Country.AUSTRIAREPUBLICOF();

		}else if (area.equals("Azerbaijan")){return Country.AZERBAIJANREPUBLICOF();

		}else if (area.equals("Croatia")){return Country.HRVATSKA();

		}else if (area.equals("Greece")){return Country.GREECEHELLENICREPUBLIC();

		}else if (area.equals("Hungary")){return Country.HUNGARYHUNGARIANPEOPLESREPUBLIC();

		}else if (area.equals("Iran")){return Country.IRANISLAMICREPUBLICOF();

		}else if (area.equals("Iraq")){return Country.IRAQREPUBLICOF();

		}else if (area.equals("Israel")){return Country.ISRAELSTATEOF();

		}else if (area.equals("Kazakhstan")){return Country.KAZAKHSTANREPUBLICOF();

		}else if (area.equals("Kyrgyzstan")){return Country.KYRGYZREPUBLIC();

		}else if (area.equals("Lebanon")){return Country.LEBANONLEBANESEREPUBLIC();

		}else if (area.equals("Luxembourg")){return Country.LUXEMBOURGGRANDDUCHYOF();

		}else if (area.equals("Macedonia")){return Country.MACEDONIATHEFORMERYUGOSLAVREPUBLICOF();

		}else if (area.equals("Moldova")){return Country.MOLDOVAREPUBLICOF();

		}else if (area.equals("Serbia")){return Country.SERBIAANDMONTENEGRO();

		}else if (area.equals("Slovakia")){return Country.SLOVAKIA();

		}else if (area.equals("Spain")){return Country.SPAINSPANISHSTATE();

		}else if (area.equals("Switzerland")){return Country.SWITZERLANDSWISSCONFEDERATION();

		}else if (area.equals("Syria")){return Country.SYRIANARABREPUBLIC();

		}else if (area.equals("Turkey")){return Country.TURKEYREPUBLICOF();

		}else if (area.equals("Cambodia")){return Country.CAMBODIAKINGDOMOF();

		}else if (area.equals("Bangladesh")){return Country.BANGLADESHPEOPLESREPUBLICOF();

		}else if (area.equals("Sri Lanka")){return Country.SRILANKADEMOCRATICSOCIALISTREPUBLICOF();

		}else if (area.equals("Bahamas")){return Country.BAHAMASCOMMONWEALTHOFTHE();

		}else if (area.equals("Western Samoa")){return Country.SAMOAINDEPENDENTSTATEOF();

		}else if (area.matches("B(y)?elarus")){return Country.BELARUS();

		}else if (area.equals("Turkey")){return Country.TURKEYREPUBLICOF();

		}else if (area.equals("Turkmenistan")){return Country.TURKMENISTAN();

		}else if (area.matches("United States: Alaska")){ return TdwgAreaProvider.getAreaByTdwgAbbreviation("ASK");

			if (unhandledCountries.contains(area)){

				logger.warn("Unhandled country '" + area + "' replaced by null" );

				return null;

			}

			return null;

		}

	}

	@Override

	public UUID getLanguageUuid(String key)

			throws UndefinedTransformerMethodException {

		return super.getLanguageUuid(key);

	}

	@Override

	public ExtensionType getExtensionTypeByKey(String key) throws UndefinedTransformerMethodException {

		if (key == null){return null;

		return null;

	}

	@Override

	public UUID getExtensionTypeUuid(String key)

			throws UndefinedTransformerMethodException {

		}

		return null;

	}

	@Override

	public UUID getMarkerTypeUuid(String key)

			throws UndefinedTransformerMethodException {

		}else if (key.equalsIgnoreCase("old record")){return uuidOldRecordMarkerType;

		}else if (key.equalsIgnoreCase("checked")){return uuidCheckedMarkerType;

		}else if (key.equalsIgnoreCase("not available")){return uuidNotAvailableMarkerType;

		}

		return null;

	}

	@Override

	public Feature getFeatureByKey(String key) throws UndefinedTransformerMethodException {

		if (StringUtils.isBlank(key)){return null;

			return null;

		}

	}

}

 * The contents of this file are subject to the Mozilla Public License Version 1.1

 * See LICENSE.TXT at the top of this package for the full license terms.

 */

package eu.etaxonomy.cdm.io.redlist.gefaesspflanzen;

import java.sql.ResultSet;

        super.doInvoke(state);

    }

    private void importFamilies(Classification gesamtListe, Classification checkliste, RedListGefaesspflanzenImportState state) {

        for(UUID uuid:state.getFamilyMap().values()){

            Taxon family = HibernateProxyHelper.deproxy(getTaxonService().load(uuid, true, Arrays.asList(new String[]{"*"})), Taxon.class);

        addTaxonToClassification(classificationS, RedListUtil.CLASSIFICATION_NAMESPACE_S, relationS, taxonBase, id, state);

    }

    private void addTaxonToClassification(Classification classification, String classificationNamespace, String relationString, final TaxonBase<?> gesamtListeTaxon, long id, RedListGefaesspflanzenImportState state){

        Taxon taxon = HibernateProxyHelper.deproxy(state.getRelatedObject(classificationNamespace, String.valueOf(id), TaxonBase.class), Taxon.class);

        //add concept relation to gesamtliste/checkliste

            RedListGefaesspflanzenImportState state) {

        Map<Object, Map<String, ? extends CdmBase>> result = new HashMap<>();

        try {

            while (rs.next()){

                idSet.add(String.valueOf(rs.getLong(RedListUtil.NAMNR)));