EDIT

/**

* 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.

*/

		ICdmDataSource destination;

		if (dbType.equals(DatabaseTypeEnum.MySQL)) {

			destination = CdmDataSource.NewMySqlInstance(cdmServer, cdmDB,

		} else if (dbType.equals(DatabaseTypeEnum.PostgreSQL)) {

			destination = CdmDataSource.NewPostgreSQLInstance(cdmServer, cdmDB,

		} else {

			// TODO others

			throw new RuntimeException("Unsupported DatabaseType");

	public boolean importFromExcelSS(String xlsPath) throws InvalidFormatException {

		boolean success = true;

		CdmApplicationController applicationController = CdmApplicationController.NewInstance(dataSource());

		ConversationHolder conversation = applicationController.NewConversation();

		conversation.startTransaction();

		ITaxonService service = applicationController.getTaxonService();

		ITermService termService = applicationController.getTermService();

		IDescriptionService descService = applicationController.getDescriptionService();

		IReferenceService referenceService = applicationController.getReferenceService();

		InputStream inputStream = null;

		try {

			inputStream = new FileInputStream(xlsPath);

		}

//		POIFSFileSystem fileSystem = null;

		try {

//			fileSystem = new POIFSFileSystem(inputStream);

//

//			HSSFWorkbook workBook = new HSSFWorkbook(fileSystem);

			Workbook workBook = WorkbookFactory.create(inputStream);

			Sheet sheet = workBook.getSheetAt(0);

			Iterator<Row> rows = sheet.rowIterator();

			// Iterator rows = sheet.rowIterator();

			ArrayList<ArrayList<String>> lstUpdates = new ArrayList<ArrayList<String>>();

			Set<Integer> lstTaxonIDs = new HashSet<Integer>();

			//Set<Integer> lstTaxonIDs;

			while (rows.hasNext()) {

			e.printStackTrace();

		}

		try {

//			POIFSFileSystem fileSystem = new POIFSFileSystem(inputStream);

//			HSSFWorkbook workBook = new HSSFWorkbook(fileSystem);

			Workbook workBook = WorkbookFactory.create(inputStream);

			Sheet sheet = workBook.getSheetAt(0);

			Iterator<Row> rows = sheet.rowIterator();

			ArrayList<ArrayList<String>> lstUpdates = new ArrayList<ArrayList<String>>();

			while (rows.hasNext()) {

				Row row = rows.next();

					vocabularyService.saveOrUpdate(stateVocabulary);

					conversation.commit(true);

					break;

				//case 1: = HumanGroup

				case 1:

					Pager<DefinedTerm> humanGroupPager = termService.findByRepresentationText(lstUpdate.get(1), DefinedTerm.class, null, null);

					DefinedTerm humanGroup = null;

					DefinedTerm ethnicGroup = null;

					if(humanGroupPager.getCount()>0) {

						humanGroup = humanGroupPager.getRecords().get(0);

					}

					if(humanGroup == null) {

						humanGroup = DefinedTerm.NewModifierInstance(lstUpdate.get(1), lstUpdate.get(1), null);

					}

					if(lstUpdate.size() >2) {

						ethnicGroup = DefinedTerm.NewModifierInstance(lstUpdate.get(2), lstUpdate.get(2), null);

						humanGroup.addIncludes(ethnicGroup);

					vocabularyService.saveOrUpdate(humanGroupVocabulary);

					conversation.commit(true);

					break;

				//case 2: = Country

				case 2:

					Pager<DefinedTerm> countryPager = termService.findByRepresentationText(lstUpdate.get(1), DefinedTerm.class, null, null);

					DefinedTermBase country = null;

					if(countryPager.getCount()>0) {

						country = countryPager.getRecords().get(0);

					}

					if(country == null) {

						country = NamedArea.NewInstance(lstUpdate.get(1), lstUpdate.get(1), null);

						countryVocabulary.addTerm(country);

					}

					conversation.commit(true);

					break;

				//case 3: //plantPart

				case 3:

					Pager<DefinedTerm> plantPartPager = termService.findByRepresentationText(lstUpdate.get(1), DefinedTerm.class, null, null);

					DefinedTerm plantPart = null;

					if(plantPartPager.getCount()>0) {

						plantPart = plantPartPager.getRecords().get(0);

					}

					if(plantPart == null) {

						plantPart = DefinedTerm.NewModifierInstance(lstUpdate.get(1), lstUpdate.get(1), null);

						plantPartVocabulary.addTerm(plantPart);

			System.out.println("File not found in the specified path.");

			e.printStackTrace();

		}

		try {

//			POIFSFileSystem fileSystem = new POIFSFileSystem(inputStream);

//			HSSFWorkbook workBook = new HSSFWorkbook(fileSystem);

			Workbook workBook = WorkbookFactory.create(inputStream);

			Sheet sheet = workBook.getSheetAt(0);

			Iterator<Row> rows = sheet.rowIterator();

			// Iterator rows = sheet.rowIterator();

			//Set<Integer> lstTaxonIDs;

			while (rows.hasNext()) {

			}

			countryVocabulary = TermVocabulary.NewInstance(TermType.NamedArea, "Country", "Country", null, termSourceUri);

			countryVocabulary.setUuid(UUID.fromString("116c51f1-e63a-46f7-a258-e1149a42868b"));

			vocabularyService.saveOrUpdate(countryVocabulary);

			conversation.commit(true);

		}

				FeatureNode useSumFeatureNode = FeatureNode.NewInstance(featureUseSummary);

				palmWebFeatureTree.getRoot().addChild(useSumFeatureNode);

			}

			vocabularyService.saveOrUpdate(featureVocabulary);

			featureTreeService.saveOrUpdate(palmWebFeatureTree);

			conversation.commit(true);

		}

		if(notAvailModPager.getCount() == 0) {

			DefinedTerm notAvailMod = DefinedTerm.NewInstance(TermType.Modifier, "N/A", "N/A", null);

			termService.saveOrUpdate(notAvailMod);

			conversation.commit(true);

		}

		if(notAvailStatePager.getCount() == 0) {

			State notAvailState = State.NewInstance("N/A", "N/A", null);

			termService.saveOrUpdate(notAvailState);

			vocabularyService.saveOrUpdate(featureVocabulary);

			featureTreeService.saveOrUpdate(palmWebFeatureTree);

			conversation.commit(true);

		}

		if(featureUseSummary == null) {

			featureUseSummary = Feature.NewInstance("Use Summary", "Use Summary", null);

			featureTreeService.saveOrUpdate(palmWebFeatureTree);

			conversation.commit(true);

		}*/

		conversation.close();

		applicationController.close();

		return success;

	}

		UseImport uiImport = new UseImport();

		// String xlsPath = ".//toload.xlsx";

		//String xlsPath = "C://workspace//CDM Trunk//UseImport//src//main//java//eu//etaxonomy//cdm//toLoad2.xls";

		uiImport.setupNecessaryItems();

		try {

			uiImport.loadTerms();