MartEditor.java

/*
	Copyright (C) 2003 EBI, GRL

	This library is free software; you can redistribute it and/or
	modify it under the terms of the GNU Lesser General Public
	License as published by the Free Software Foundation; either
	version 2.1 of the License, or (at your option) any later version.

	This library is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
	Lesser General Public License for more details.

	You should have received a copy of the GNU Lesser General Public
	License along with this library; if not, write to the Free Software
	Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
*/

package org.ensembl.mart.editor;

import java.awt.BorderLayout;
import java.awt.Cursor;
import java.awt.Dimension;
import java.awt.Toolkit;
import java.awt.datatransfer.Clipboard;
import java.awt.datatransfer.ClipboardOwner;
import java.awt.datatransfer.Transferable;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.io.File;
import java.net.URL;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Collection;
import java.util.Hashtable;
import java.util.SortedSet;
import java.util.TreeSet;
import java.util.prefs.Preferences;

import javax.swing.AbstractAction;
import javax.swing.ImageIcon;
import javax.swing.JButton;
import javax.swing.JComponent;
import javax.swing.JDesktopPane;
import javax.swing.JFileChooser;
import javax.swing.JFrame;
import javax.swing.JMenu;
import javax.swing.JMenuBar;
import javax.swing.JMenuItem;
import javax.swing.JOptionPane;
import javax.swing.JToolBar;
import javax.swing.KeyStroke;
import javax.swing.UIManager;

import org.ensembl.mart.explorer.Feedback;
import org.ensembl.mart.guiutils.DatabaseSettingsDialog;
import org.ensembl.mart.lib.DetailedDataSource;
import org.ensembl.mart.lib.config.ConfigurationException;
import org.ensembl.mart.lib.config.DSConfigAdaptor;
import org.ensembl.mart.lib.config.DatabaseDSConfigAdaptor;
import org.ensembl.mart.lib.config.DatabaseDatasetConfigUtils;
import org.ensembl.mart.lib.config.DatasetConfig;
import org.ensembl.mart.lib.config.DatasetConfigIterator;
import org.ensembl.mart.lib.config.DatasetConfigXMLUtils;
import org.ensembl.mart.lib.config.URLDSConfigAdaptor;



/**
 * Class MartEditor extends JFrame..
 *
 * <p>This class contains the main function, it draws the external frame, toolsbar, menus.
 * </p>
 *
 * @author <a href="mailto:katerina@ebi.ac.uk">Katerina Tzouvara</a>
 * //@see org.ensembl.mart.config.DatasetConfig
 */

public class MartEditor extends JFrame implements ClipboardOwner {

  static public boolean HAS_GUI = true;    

  private JDesktopPane desktop;
  static private final String newline = "\n";
  private JFileChooser fc;
  final static File IMAGE_DIR = new File(new File("data"),"image");
  static final private String NEW = "New";
  static final private String OPEN = "Open";
  static final private String SAVE = "Save";
  static final private String COPY = "Copy";
  static final private String CUT = "Cut";
  static final private String PASTE = "Paste";
  static final private String DELETE = "Delete ";
  static final private String UNDO = "Undo";
  static final private String REDO = "Redo";
  static final private String HELP = "Copy";
  private File file = null;

  static private DetailedDataSource ds;
  private static DatasetConfigXMLUtils dscutils = new DatasetConfigXMLUtils(true);
  //may want to turn validation on?
  private static DatabaseDatasetConfigUtils dbutils;
  private static Hashtable dbutilsHash = new Hashtable();
  

  static private String user;
  static private String martUser;
  private String database;
  private String schema;
  private static String connection;
  

  /** Persistent preferences object used to hold user history. */
  private Preferences prefs = Preferences.userNodeForPackage(this.getClass());
  private DatabaseSettingsDialog databaseDialog = new DatabaseSettingsDialog(prefs);

  protected Clipboard clipboardEditor;

  public MartEditor() {
	
//	autoconnect on startup
	super("MartEditor");

	if(!HAS_GUI)
	    return;
	HAS_GUI = false;

		 String defaultSourceName = databaseDialog.getConnectionName();

// prevents MEditor from moaning on the first start without prefs set
String driver = null;
if (databaseDialog.getDriver().equals("")) driver ="com.mysql.jdbc.Driver";
else driver=databaseDialog.getDriver();



System.out.println ("getting driver "+ driver);

				 if (defaultSourceName == null || defaultSourceName.length() < 1)
				   defaultSourceName =
					 defaultSourceName =
					   DetailedDataSource.defaultName(
						 databaseDialog.getHost(),
						 databaseDialog.getPort(),
						 databaseDialog.getDatabase(),
						 databaseDialog.getSchema(),
						 databaseDialog.getUser());


				 ds =
				   new DetailedDataSource(
					 databaseDialog.getDatabaseType(),
					 databaseDialog.getHost(),
					 databaseDialog.getPort(),
					 databaseDialog.getDatabase(),
					 databaseDialog.getSchema(),
					 databaseDialog.getUser(),
					 databaseDialog.getPassword(),
					 10,
					 driver,
					 defaultSourceName);
			
				 user = databaseDialog.getUser();
				 martUser = databaseDialog.getMartUser();
				 database = databaseDialog.getDatabase();
				 //schema = databaseDialog.getSchema();	
				 Connection conn = null;
				 try {
				   conn = ds.getConnection();
				   dbutils = new DatabaseDatasetConfigUtils(dscutils, ds, true);
					connection = "MartEditor (CONNECTED TO " + databaseDialog.getDatabase() + "/"+databaseDialog.getSchema()+" AS "+databaseDialog.getUser()+")";
				   //valid = true;
				   String[] schemas = databaseDialog.getSchema().split(";");
				   for (int i = 0; i < schemas.length; i++){
				   		DetailedDataSource ds1 = 
										new DetailedDataSource(
										 databaseDialog.getDatabaseType(),
										 databaseDialog.getHost(),
										 databaseDialog.getPort(),
										 schemas[i],
										 databaseDialog.getSchema(),
										 databaseDialog.getUser(),
										 databaseDialog.getPassword(),
										 10,
										 driver,
										 defaultSourceName);
					    DatabaseDatasetConfigUtils dbutils1 = new DatabaseDatasetConfigUtils(new DatasetConfigXMLUtils(true), ds1, true);
				   		dbutilsHash.put(schemas[i],dbutils1);
				   }
				   
				   
				   
				 } catch (SQLException e) {
				 	ds = null;
					connection = "MartEditor (NO DATABASE CONNECTION)";	
				   //System.out.println(e.toString()); 	
				   //warning dialog then retry
				   //Feedback f = new Feedback(this);
				   //f.warning("Could not connect to Database\nwith the given Connection Settings.\nPlease try again!");
				   //valid = false;
				 } finally {
				   DetailedDataSource.close(conn);
				 }
    JFrame.setDefaultLookAndFeelDecorated(true);
    fc = new JFileChooser();

    //Create the toolbar.
    //JToolBar toolBar = new JToolBar("Still draggable");
    //addButtons(toolBar);// buttons don't work at the moment

    //Make the big window be indented 50 pixels from each edge
    //of the screen.
    int inset = 100;
    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
    setBounds(inset, inset, screenSize.width - inset * 2, screenSize.height - inset * 2);

    //Set up the GUI.
    this.getContentPane().setLayout(new BorderLayout());
    //this.getContentPane().add(toolBar, BorderLayout.NORTH);

    desktop = new JDesktopPane();
    
    this.getContentPane().add(desktop, BorderLayout.CENTER);
    setJMenuBar(createMenuBar());
	
	//desktop.registerKeyboardAction(new MenuActionListener(),"Naive using Template",KeyStroke.getKeyStroke(KeyEvent.VK_N,8),JComponent.WHEN_FOCUSED);
	
	
	
    //Make dragging a little faster but perhaps uglier.
    desktop.setDragMode(JDesktopPane.OUTLINE_DRAG_MODE);

    clipboardEditor = new Clipboard("editor_clipboard");

	


  }

  protected void addButtons(JToolBar toolBar) {
    JButton button = null;

    //first button
    button = makeNavigationButton("new", NEW, "Create a new dataset config", "new");
    toolBar.add(button);

    //second button
    button = makeNavigationButton("open", OPEN, "Open a dataset config", "open");
    toolBar.add(button);

    //third button
    button = makeNavigationButton("save", SAVE, "Save dataset config", "save");
    toolBar.add(button);

    button = makeNavigationButton("copy", COPY, "Copy a tree node", "copy");
    toolBar.add(button);

    button = makeNavigationButton("cut", CUT, "Cut a tree node", "cut");
    toolBar.add(button);

    button = makeNavigationButton("paste", PASTE, "Paste tree node", "paste");
    toolBar.add(button);

    button = makeNavigationButton("undo", UNDO, "Undo", "undo");
    toolBar.add(button);

    button = makeNavigationButton("redo", REDO, "Redo", "redo");
    toolBar.add(button);

  }

  protected JButton makeNavigationButton(String imageName, String actionCommand, String toolTipText, String altText) {
    //Look for the image.
    String imgLocation = (new File(IMAGE_DIR,imageName+".gif")).getPath();
    URL imageURL = DatasetConfigTree.class.getClassLoader().getResource(imgLocation);

    //Create and initialize the button.
    JButton button = new JButton();
    button.setBorderPainted(false);
    button.setActionCommand(actionCommand);
    button.setToolTipText(toolTipText);
    button.addActionListener(new MenuActionListener());

    if (imageURL != null) { //image found
      button.setIcon(new ImageIcon(imageURL, altText));
    } else { //no image found
      button.setText(altText);
      System.err.println("Resource not found: " + imgLocation);
    }

    return button;
  }

  protected JMenuBar createMenuBar() {
    JMenuBar menuBar;
    JMenu menu;
    JMenuItem menuItem;

    //Create the menu bar.
    menuBar = new JMenuBar();

    //Build the first menu.
    menu = new JMenu("File");
    //menu.setMnemonic(KeyEvent.VK_F);
    menu.getAccessibleContext().setAccessibleDescription("the file related menu");
    menuBar.add(menu);

    //a group of JMenuItems
    ImageIcon icon = createImageIcon((new File(IMAGE_DIR,"new.gif")).getPath());

    menuItem = new JMenuItem("Database Connection");
    MartEditor.MenuActionListener menuActionListener = new MartEditor.MenuActionListener();
    menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_D);
    menu.add(menuItem);

    menu.addSeparator();

    menuItem = new JMenuItem("Naive");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

    //menuItem = new JMenuItem("Naive using Template");
    //menuItem.addActionListener(menuActionListener);
    //menu.add(menuItem); now done with short-cut keys only:
    desktop.getInputMap(JComponent.WHEN_IN_FOCUSED_WINDOW).put(KeyStroke.getKeyStroke(KeyEvent.VK_N,8), "Naive using Template");
    desktop.getActionMap().put("Naive using Template", new AbstractAction("Naive using Template")
    {
        public void actionPerformed(final ActionEvent e) {
        	naiveTemplateDatasetConfig();
        	}	
    });
	//menu.registerKeyboardAction(menuActionListener,"Naive using Template",
	//	KeyStroke.getKeyStroke(KeyEvent.VK_N,8),JComponent.WHEN_FOCUSED);
	
    menuItem = new JMenuItem("Import");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

    menuItem = new JMenuItem("Export");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

    
	menuItem = new JMenuItem("Validate");
	menuItem.addActionListener(menuActionListener);
	menu.add(menuItem);


    menuItem = new JMenuItem("Delete");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

    menu.addSeparator();

    
    //menuItem = new JMenuItem("View Dataset Configuration");
	//menuItem.addActionListener(menuActionListener);
	//menu.add(menuItem); now done with short-cut keys only
	//menu.registerKeyboardAction(menuActionListener,"View Dataset Configuration",
	//		KeyStroke.getKeyStroke(KeyEvent.VK_V,8),JComponent.WHEN_FOCUSED);
    desktop.getInputMap(JComponent.WHEN_IN_FOCUSED_WINDOW).put(KeyStroke.getKeyStroke(KeyEvent.VK_V,8), "View Dataset Configuration");
    desktop.getActionMap().put("View Dataset Configuration", new AbstractAction("View Dataset Configuration")
    {
        public void actionPerformed(final ActionEvent e) {
        	importDatasetConfig();
        	}	
    });
    
    //menuItem = new JMenuItem("Delete Dataset Configuration");
    //menuItem.addActionListener(menuActionListener);
    //menu.add(menuItem); now done with short-cut keys only
	//menu.registerKeyboardAction(menuActionListener,"Delete Dataset Configuration",
	//		KeyStroke.getKeyStroke(KeyEvent.VK_D,8),JComponent.WHEN_FOCUSED);
    desktop.getInputMap(JComponent.WHEN_IN_FOCUSED_WINDOW).put(KeyStroke.getKeyStroke(KeyEvent.VK_D,8), "Delete Dataset Configuration");
    desktop.getActionMap().put("Delete Dataset Configuration", new AbstractAction("Delete Dataset Configuration")
    {
        public void actionPerformed(final ActionEvent e) {
        	deleteDatasetConfig();
        	}	
    });
    //menu.addSeparator();

//	menuItem = new JMenuItem("Import Config");
//	menuItem.addActionListener(menuActionListener);
//	menu.add(menuItem);

	//menuItem = new JMenuItem("Import Template");
	//menuItem.addActionListener(menuActionListener);
	//menuItem.setMnemonic(KeyEvent.VK_I);
	//menu.add(menuItem);

//	menuItem = new JMenuItem("Export Template");
//	menuItem.addActionListener(menuActionListener);
	//menuItem.setMnemonic(KeyEvent.VK_I);
//	menu.add(menuItem);

//    menu.addSeparator();
//	menuItem = new JMenuItem("Update All");
//	menuItem.addActionListener(menuActionListener);
//	menu.add(menuItem);
//	menuItem = new JMenuItem("Validate All");
//	menuItem.addActionListener(menuActionListener);
//	menu.add(menuItem);	

    
    

    //menu.addSeparator();
    
	menuItem = new JMenuItem("Update All");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

   // menu.addSeparator();
    
    
	menuItem = new JMenuItem("Save All");
	menuItem.addActionListener(menuActionListener);
	menu.add(menuItem);	
	
	menuItem = new JMenuItem("Upload All");
	menuItem.addActionListener(menuActionListener);
	menu.add(menuItem);	

	menuItem = new JMenuItem("Move All");
	menuItem.addActionListener(menuActionListener);
	menu.add(menuItem);		

	menu.addSeparator();
    
    //menuItem = new JMenuItem("New", icon);

    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    // menuItem.setAccelerator(KeyStroke.getKeyStroke(
    // KeyEvent.VK_1, ActionEvent.ALT_MASK));
    //menuItem.getAccessibleContext().setAccessibleDescription("Creates a new file");
    //menu.add(menuItem);

    //icon = createImageIcon(IMAGE_DIR + "open.gif");
    //menuItem = new JMenuItem("Open", icon);
    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_O);
    //menu.add(menuItem);

    //icon = createImageIcon(IMAGE_DIR + "save.gif");
    //menuItem = new JMenuItem("Save", icon);
    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_S);
    //menu.add(menuItem);

    //menuItem = new JMenuItem("Save as");
    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_A);
    //menu.add(menuItem);

    //a group of radio button menu items
    //menu.addSeparator();
    //menuItem = new JMenuItem("Print");
    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_P);
    //menu.add(menuItem);

    //a group of check box menu items
    
	menuItem = new JMenuItem("Exit");
    menuItem.addActionListener(menuActionListener);
    menu.add(menuItem);

    //Build edit menu in the menu bar.
    menu = new JMenu("Edit");
    //menu.setMnemonic(KeyEvent.VK_E);
    menu.getAccessibleContext().setAccessibleDescription("this is the edit menu");
    menuBar.add(menu);
    icon = createImageIcon((new File(IMAGE_DIR,"undo.gif")).getPath());
    menuItem = new JMenuItem("Undo", icon);
    menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_U); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("undo");
    //menu.add(menuItem);
    icon = createImageIcon((new File(IMAGE_DIR,"redo.gif")).getPath());
    menuItem = new JMenuItem("Redo", icon);
    menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("redo");
    //menu.add(menuItem);
    menu.addSeparator();
    icon = createImageIcon((new File(IMAGE_DIR,"cut.gif")).getPath());
    menuItem = new JMenuItem("Cut", icon);
    menuItem.addActionListener(menuActionListener);
    menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("cuts to clipboard");
    menu.add(menuItem);
    icon = createImageIcon((new File(IMAGE_DIR,"copy.gif")).getPath());
    menuItem = new JMenuItem("Copy", icon);
    menuItem.addActionListener(menuActionListener);
    menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("copies to clipboard");
    menu.add(menuItem);
    icon = createImageIcon((new File(IMAGE_DIR,"paste.gif")).getPath());
    menuItem = new JMenuItem("Paste", icon);
    menuItem.addActionListener(menuActionListener);
    menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("pastes from clipboard");
    menu.add(menuItem);

    menu.addSeparator();
    icon = createImageIcon((new File(IMAGE_DIR,"remove.gif")).getPath());
    menuItem = new JMenuItem("Delete", icon);
    menuItem.addActionListener(menuActionListener);
    menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("deletes");
    menu.add(menuItem);
    // insert does nothing at moment
    //icon = createImageIcon(IMAGE_DIR + "add.gif");
    //menuItem = new JMenuItem("Insert", icon);
    //menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    //menuItem.getAccessibleContext().setAccessibleDescription("inserts");
    //menu.add(menuItem);

    /**
    menu = new JMenu("Settings");
    JMenuItem clear = new JMenuItem("Clear Cache");
    clear.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {



      }
    });
    menu.add(clear);
    menuBar.add(menu);
*/
    /*
    //Build help menu in the menu bar.
    icon = createImageIcon(IMAGE_DIR + "help.gif");
    menu = new JMenu("Help");
    //menu.setMnemonic(KeyEvent.VK_H);
    menu.getAccessibleContext().setAccessibleDescription("this is the help menu");
    menuBar.add(menu);
    menuItem = new JMenuItem("Documentation", icon);
    menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_M); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("documentation");
    menu.add(menuItem);
    menuItem = new JMenuItem("About...");
    menuItem.addActionListener(menuActionListener);
    //menuItem.setMnemonic(KeyEvent.VK_N); //used constructor instead
    menuItem.getAccessibleContext().setAccessibleDescription("inserts");
    menu.add(menuItem);
    */

    return menuBar;
  }

  //Create a new internal frame.
  protected void createFrame(File file) {

    DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(file, this, null, null, null, null, null,null,null);
    frame.setVisible(true);
    desktop.add(frame);
    try {
      frame.setSelected(true);
    } catch (java.beans.PropertyVetoException e) {
    }

  }

  //Quit the application.
  protected void quit() {
    System.exit(0);
  }

  /**
   * Create the GUI and show it.  For thread safety,
   * this method should be invoked from the
   * event-dispatching thread.
   */
  private static void createAndShowGUI() {
    //Make sure we have nice window decorations.
    JFrame.setDefaultLookAndFeelDecorated(true);

    //Create and set up the window.
    MartEditor frame = new MartEditor();
          
    frame.setTitle(connection);
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    //ImageIcon icon = createImageIcon(IMAGE_DIR+"MartConfig_cube.gif");
    //frame.setIconImage(icon.getImage());
    //Display the window.
    frame.setVisible(true);
  }

  /** Returns an ImageIcon, or null if the path was invalid. */
  protected static ImageIcon createImageIcon(String path) {
    java.net.URL imgURL = DatasetConfigTreeWidget.class.getClassLoader().getResource(path);
    if (imgURL != null) {
      return new ImageIcon(imgURL);
    } else {
      System.err.println("Couldn't find file: " + path);
      return null;
    }
  }

  public static void main(String[] args) {
    //Schedule a job for the event-dispatching thread:
    //creating and showing this application's GUI.
    javax.swing.SwingUtilities.invokeLater(new Runnable() {
      public void run() {
        try {
          UIManager.setLookAndFeel(UIManager.getCrossPlatformLookAndFeelClassName());
        } catch (Exception e) {
        }
        createAndShowGUI();
      }
    });
  }

  // Inner class that handles Menu Action Events
  protected class MenuActionListener implements ActionListener {
    public void actionPerformed(ActionEvent e) {
      if (e.getActionCommand().equals("Cut"))
        cut();
      else if (e.getActionCommand().equals("Copy"))
        copy();
      else if (e.getActionCommand().equals("Paste"))
        paste();
      else if (e.getActionCommand().equals("Insert"))
        insert();
      else if (e.getActionCommand().equals("Delete "))
        delete();
      else if (e.getActionCommand().equals("Undo"))
          undo();
        else if (e.getActionCommand().equals("Redo"))
          redo();
      //else if (e.getActionCommand().startsWith("New"))
      //  newDatasetConfig();
      //else if (e.getActionCommand().startsWith("Open"))
      //  openDatasetConfig();
      else if (e.getActionCommand().equals("Exit"))
        exit();
      //else if (e.getActionCommand().equals("Save"))
      //  save();
      //else if (e.getActionCommand().equals("Save as"))
      //  save_as();
      
      
      else if (e.getActionCommand().equals("Database Connection"))
        databaseConnection("");
	  //else if (e.getActionCommand().startsWith("Import Template")){
		//importTemplate(); DISABLED
	  else if (e.getActionCommand().equals("Import"))
	  	importTemplateConfig();	 
      //else if (e.getActionCommand().equals("View Dataset Configuration"))
      //  importDatasetConfig(); 
	  else if (e.getActionCommand().equals("Export"))
		exportTemplate();  
      //else if (e.getActionCommand().startsWith("Export"))
      //  exportDatasetConfig();
      //else if (e.getActionCommand().equals("Naive using Template"))
      //    naiveTemplateDatasetConfig();
      else if (e.getActionCommand().equals("Naive"))
    	  naiveDatasetConfig();
	  else if (e.getActionCommand().equals("Update All"))
		updateAllTemplates();
	  else if (e.getActionCommand().equals("Validate"))
		  validateTemplate();		
	  else if (e.getActionCommand().equals("Move All"))
		  moveAll();		
	  else if (e.getActionCommand().equals("Save All"))
		  saveAll();	
	  else if (e.getActionCommand().equals("Upload All"))
			uploadAll();			  	
//      else if (e.getActionCommand().startsWith("Update"))
//        updateDatasetConfig();
//	  else if (e.getActionCommand().startsWith("Validate"))
//		  validateDatasetConfig();  
      else if (e.getActionCommand().equals("Delete"))
        deleteTemplateConfig();
      //else if (e.getActionCommand().equals("Delete Dataset Configuration"))
      //    deleteDatasetConfig();
      //else if (e.getActionCommand().startsWith("hide"))
      //  makeHidden();
    }
  }

  public void cut() {
	    DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
	    if (widget!=null) widget.cut();
  }

  public void copy() {
	    DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
	    if (widget!=null) widget.copy();
  }

  public void paste() {
	    DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
	    if (widget!=null) widget.paste();
  }
/*
  public void makeHidden() {
	    DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
	    if (widget!=null) widget.makeHidden();
  }
*/
  
  public void insert() {
    //((DatasetConfigTreeWidget)desktop.getSelectedFrame()).insert();
  }

  public void delete() {
    DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
    if (widget!=null) widget.delete();
  }

  public void newDatasetConfig() {
    createFrame(null);
  }

  public void setFileChooserPath(File file) {
    this.file = file;
  }

  public File getFileChooserPath() {
    return file;
  }

  public void lostOwnership(Clipboard c, Transferable t) {

  }

  public static DetailedDataSource getDetailedDataSource() {
    return ds;
  }

  public static String getUser() {
    return user;
  }
  
  public static String getMartUser() {
	return martUser;
  }

  public static DatasetConfigXMLUtils getDatasetConfigXMLUtils() {
    return dscutils;
  }

  public static DatabaseDatasetConfigUtils getDatabaseDatasetConfigUtils() {
    return dbutils;
  }
  
  public static DatabaseDatasetConfigUtils getDatabaseDatasetConfigUtilsBySchema(String schema) {
	return (DatabaseDatasetConfigUtils) dbutilsHash.get(schema);
  }

  public void databaseConnection(String title) {

    boolean valid = false;

    //try {
      disableCursor();
      while (!valid) {
        if (!databaseDialog.showDialog(this,title))
          break;

        String defaultSourceName = databaseDialog.getConnectionName();

        if (defaultSourceName == null || defaultSourceName.length() < 1)
          defaultSourceName =
            defaultSourceName =
              DetailedDataSource.defaultName(
                databaseDialog.getHost(),
                databaseDialog.getPort(),
                databaseDialog.getDatabase(),
				databaseDialog.getSchema(),
                databaseDialog.getUser());

        ds =
          new DetailedDataSource(
            databaseDialog.getDatabaseType(),
            databaseDialog.getHost(),
            databaseDialog.getPort(),
            databaseDialog.getDatabase(),
			databaseDialog.getSchema(),
            databaseDialog.getUser(),
            databaseDialog.getPassword(),
            10,
            databaseDialog.getDriver(),
            defaultSourceName);
        user = databaseDialog.getUser();
		martUser = databaseDialog.getMartUser();
        database = databaseDialog.getDatabase();
        
        Connection conn = null;
        try {
          conn = ds.getConnection();
          dbutils = new DatabaseDatasetConfigUtils(dscutils, ds, true);
          valid = true;
          connection = "MartEditor (CONNECTED TO " + databaseDialog.getDatabase() + "/"+databaseDialog.getSchema()+" AS "+databaseDialog.getUser()+")";		  
        
		  String[] schemas = databaseDialog.getSchema().split(";");
		  for (int i = 0; i < schemas.length; i++){
				DetailedDataSource ds1 = new DetailedDataSource(
												   databaseDialog.getDatabaseType(),
												   databaseDialog.getHost(),
												   databaseDialog.getPort(),
												   schemas[i],
												   databaseDialog.getSchema(),
												   databaseDialog.getUser(),
												   databaseDialog.getPassword(),
												   10,
												   databaseDialog.getDriver(),
												   defaultSourceName);
				DatabaseDatasetConfigUtils dbutils1 = new DatabaseDatasetConfigUtils(new DatasetConfigXMLUtils(true), ds1, true);
				dbutilsHash.put(schemas[i],dbutils1);
		  }
        
        
        } 
        catch (SQLException e) {
          ds = null;	
          connection = "MartEditor (NO DATABASE CONNECTION)";	
          //warning dialog then retry
          Feedback f = new Feedback(this);
          f.warning("Could not connect to Database\nwith the given Connection Settings.\nPlease try again!");
          valid = false;
        } 
        finally {
          DetailedDataSource.close(conn);
		  setTitle(connection);
		  enableCursor();
        }
      }
    //} 
    //finally {
      //setTitle(connection);
      //enableCursor();
    //}
  }


/*
  public void openDatasetConfig() {

    XMLFileFilter filter = new XMLFileFilter();
    fc.addChoosableFileFilter(filter);
    int returnVal = fc.showOpenDialog(this.getContentPane());

    if (returnVal == JFileChooser.APPROVE_OPTION) {
      file = fc.getSelectedFile();
      createFrame(file);
      //This is where a real application would open the file.
      System.out.println("Opening: " + file.getName() + "." + newline);
    } else {
      System.out.println("Open command cancelled by user." + newline);
    }

  }
*/

/*
  public void importTemplate() {
	try {
	  if (ds == null) {
		JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		return;
	  }

	  disableCursor();

	  String[] templates = dbutils.getAllTemplateNames();
	  List testedTemplates = new ArrayList();
	  for (int i = 0; i < templates.length; i++){
	  		if (dbutils.templateCount(templates[i]) > 1) testedTemplates.add((String) templates[i]);
	  }
	  templates = new String[testedTemplates.size()];
	  testedTemplates.toArray(templates);
	  
	  if (templates.length == 0){
		JOptionPane.showMessageDialog(this, "No templates (referring to > 1 dataset) in this database", "ERROR", 0);
				return;
	  }
		 String template =
		(String) JOptionPane.showInputDialog(
		  null,
		  "Choose one",
		  "Dataset config",
		  JOptionPane.INFORMATION_MESSAGE,
		  null,
		  templates,
		  templates[0]);

	  if (template == null)
		return;

	

	  DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, user, null, null, databaseDialog.getSchema(), template);
	  frame.setVisible(true);
	  desktop.add(frame);
	  try {
		frame.setSelected(true);
	  } catch (java.beans.PropertyVetoException e) {
	  }
	} catch (ConfigurationException e) {
	  JOptionPane.showMessageDialog(this, "No datasets available for import - is this a BioMart compatible schema? Missing  meta_configuration tables?" +
			" Empty meta_configuration tables?", "ERROR", 0);
	} finally {
	  enableCursor();
	}
  }
*/

  public void importTemplateConfig() {
	try {
	  if (ds == null) {
		JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		return;
	  }

	  disableCursor();
		if (!dbutils.baseDSConfigTableExists()) {
			  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
			  return;
			}

	  Collection importOptions = dbutils.getImportOptions();
	  SortedSet names = new TreeSet(importOptions);
	  String[] options = new String[names.size()];
	  names.toArray(options);
	  
	  if (options.length == 0){
		JOptionPane.showMessageDialog(this, "No template configurations in this database", "ERROR", 0);
				return;
	  }
	  String option =
		(String) JOptionPane.showInputDialog(
		  null,
		  "Choose one",
		  "Template config",
		  JOptionPane.INFORMATION_MESSAGE,
		  null,
		  options,
		  options[0]);

	  if (option == null)
		return;

	  DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, user, null, null, databaseDialog.getSchema(), option,null);
	
	      
	  frame.setVisible(true);
	  desktop.add(frame);
	  try {
		frame.setSelected(true);
	  }
	  catch (java.beans.PropertyVetoException e) {
	  }
	} catch (ConfigurationException e) {
	  JOptionPane.showMessageDialog(this, "No templates available for import - is this a BioMart compatible schema? Missing  meta_configuration tables?" +
			" Empty meta_configuration tables or lack of write access?", "ERROR", 0);
	} finally {
	  enableCursor();
	}
  }


  public void importDatasetConfig() {
    try {
      if (ds == null) {
        JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
        return;
      }

      disableCursor();

      String[] datasets = dbutils.getAllDatasetNames(user,martUser);
      if (datasets.length == 0){
		JOptionPane.showMessageDialog(this, "No datasets in this database", "ERROR", 0);
				return;
      }
         String dataset =
        (String) JOptionPane.showInputDialog(
          null,
          "Choose one",
          "Dataset config",
          JOptionPane.INFORMATION_MESSAGE,
          null,
          datasets,
          datasets[0]);

      if (dataset == null)
        return;

	  String[] datasetIDs = dbutils.getAllDatasetIDsForDataset(user,dataset);
	  String datasetID;
	  if (datasetIDs.length == 1)
		datasetID = datasetIDs[0];
	  else {
		datasetID =
		  (String) JOptionPane.showInputDialog(
			null,
			"Choose one",
			"Dataset ID",
			JOptionPane.INFORMATION_MESSAGE,
			null,
			datasetIDs,
			datasetIDs[0]);
	  }

	  if (datasetID == null)
		return;
	

      DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, user, dataset, datasetID, 
      	databaseDialog.getSchema(),null,null);
      frame.setVisible(true);
      desktop.add(frame);
      try {
        frame.setSelected(true);
      } catch (java.beans.PropertyVetoException e) {
      }
    } catch (ConfigurationException e) {
      JOptionPane.showMessageDialog(this, "No datasets available for import - is this a BioMart compatible schema? Missing  meta_configuration tables?" +
      		" Empty meta_configuration tables?", "ERROR", 0);
    } finally {
      enableCursor();
    }
  }

  /*
  public void assignTemplate() {
	    
	try {
	  if (ds == null) {
		JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		return;
	  }

	  disableCursor();
	  
		if (!dbutils.baseDSConfigTableExists()) {
			  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
			  return;
			}

	  String[] datasets = dbutils.getAllDatasetNames(user,martUser);
	  if (datasets.length == 0){
		JOptionPane.showMessageDialog(this, "No datasets in this database", "ERROR", 0);
				return;
	  }
		 String dataset =
		(String) JOptionPane.showInputDialog(
		  null,
		  "Choose one",
		  "Dataset config",
		  JOptionPane.INFORMATION_MESSAGE,
		  null,
		  datasets,
		  datasets[0]);

	  if (dataset == null)
		return;

	  String[] datasetIDs = dbutils.getAllDatasetIDsForDataset(user,dataset);
	  String datasetID;
	  if (datasetIDs.length == 1)
		datasetID = datasetIDs[0];
	  else {
		datasetID =
		  (String) JOptionPane.showInputDialog(
			null,
			"Choose one",
			"Dataset ID",
			JOptionPane.INFORMATION_MESSAGE,
			null,
			datasetIDs,
			datasetIDs[0]);
	  }

	  if (datasetID == null)
		return;

	  //DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, user, dataset, datasetID, 
	  //	databaseDialog.getSchema(),null,"true");
	  
	  DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, user, dataset, datasetID, 
						databaseDialog.getSchema(),null,"0");	
		
	  frame.setVisible(true);
	  desktop.add(frame);
	  try {
		frame.setSelected(true);
	  } catch (java.beans.PropertyVetoException e) {
	  }
	} catch (ConfigurationException e) {
	  JOptionPane.showMessageDialog(this, "No datasets available for import - is this a BioMart compatible schema? Missing  meta_configuration tables?" +
			" Empty meta_configuration tables?", "ERROR", 0);
	} finally {
	  enableCursor();
	}
  }
*/
  
  public void exportTemplate() {
	if (ds == null) {
	  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
	  return;
	}

	try {
	  disableCursor();
	  DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
      if (widget==null) return;
      dbutils.setReadonly(false);
	  //DatasetConfig dsConfig = ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).getDatasetConfig();	
	  widget.exportTemplate();
	} catch (ConfigurationException e) {
	  JOptionPane.showMessageDialog(this, "Problems with exporting requested dataset. " +
			"Check that dataset id is unique, you have write permissions " +
			"and the meta_configuration tables are in required format", "ERROR", 0);
	  e.printStackTrace();
	} finally {
	  enableCursor();
      dbutils.setReadonly(true);
	}
  }
  
  public void validateTemplate() {
	if (ds == null) {
	  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
	  return;
	}

	try {
	  disableCursor();
	  DatasetConfigTreeWidget widget = (DatasetConfigTreeWidget) desktop.getSelectedFrame();
      if (widget==null) return;
	  //DatasetConfig dsConfig = ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).getDatasetConfig();	
	  widget.validateTemplate();
	} catch (ConfigurationException e) {
	  JOptionPane.showMessageDialog(this, "Problems with validating requested dataset.", "ERROR", 0);
	  e.printStackTrace();
	} finally {
	  enableCursor();
	}
  }


/*
  public void exportDatasetConfig() {
    if (ds == null) {
      JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
      return;
    }

    try {
      disableCursor();
      DatasetConfig dsConfig = ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).getDatasetConfig();
      
      
      // these were added for upgrading xml without those settings
      // the datasetID needs to be made incremental for multiple datasets
      //if(dsConfig.getDatasetID() == null) dsConfig.setDatasetID("0");
      if(dsConfig.getMartUsers() == null) dsConfig.setMartUsers("default");
      if(dsConfig.getInterfaces() == null)dsConfig.setInterfaces("default");
	  
	  // don't need this check anymore - should not be possible to get to this position
	  //if (dbutils.checkDatasetID(dsConfig.getDatasetID(),dsConfig.getDataset()) >= 1){
		//int choice = JOptionPane.showConfirmDialog(null, "Dataset ID already exists for a different dataset", "Export anyway?", JOptionPane.YES_NO_OPTION);							  
		//if (choice != 0){
		//	return;
		//}
	  //}
	  
      if (dsConfig.getAdaptor() != null && dsConfig.getAdaptor().getDataSource() != null && !dsConfig.getAdaptor().getDataSource().getSchema().equals(databaseDialog.getSchema())){
      	// NM the widget still has its adaptor - could switch connection
		int choice = JOptionPane.showConfirmDialog(this,"You are exporting this XML to a new schema: " + databaseDialog.getSchema() +"\nChange connection?", "", JOptionPane.YES_NO_OPTION);
      	if (choice == 0){databaseConnection("");}
      }
	
      ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).export();
    } catch (ConfigurationException e) {
      JOptionPane.showMessageDialog(this, "Problems with exporting requested dataset. " +
      		"Check that dataset id is unique, you have write permissions " +
      		"and the meta_configuration tables are in required format", "ERROR", 0);
      e.printStackTrace();
    } finally {
      enableCursor();
    }
  }
*/

  public void naiveTemplateDatasetConfig(){
    if (ds == null) {
      JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
      return;
    }

    
    String dbtype = databaseDialog.getDatabaseType();
    String schema = null;
    
    if(dbtype.equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
    else schema = databaseDialog.getSchema();
     
    
    try {
      disableCursor();
      String[] datasets = dbutils.getNaiveDatasetNamesFor(schema);
      if(datasets.length==0){
        JOptionPane.showMessageDialog(this, "No datasets available - Is this a BioMart comptatible schema?", "ERROR", 0);
        return;
      }
      
      String dataset =
        (String) JOptionPane.showInputDialog(
          null,
          "Choose one",
          "Dataset",
          JOptionPane.INFORMATION_MESSAGE,
          null,
          datasets,
          datasets[0]);
      if (dataset == null)
        return;

      disableCursor();
/*     
      String template = dataset;
      
      String[] templates = new String[dbutils.getAllTemplateNames().length + 1];
      templates[0] = dataset;	
	  String[] tNames = dbutils.getAllTemplateNames();
	  for (int i = 0; i < tNames.length; i++){
	  	templates[i+1] = tNames[i];
	  }
	  if(templates.length!=0){
		//JOptionPane.showMessageDialog(this, "No datasets available - Is this a BioMart comptatible schema?", "ERROR", 0);
		//return;
      
	   template =
		(String) JOptionPane.showInputDialog(
		  null,
		  "Choose one",
		  "Template",
		  JOptionPane.INFORMATION_MESSAGE,
		  null,
		  templates,
		  templates[0]);
	  if (template == null)
		return;
	  }
*/
	  String template;	
	  int choice = JOptionPane.showConfirmDialog(null,"Create new template rather than use existing one?");
		  if (choice == 0){// YES
			  template = (String) JOptionPane.showInputDialog(null,"New template name",dataset);		
		  }
		  else if (choice == 1){// NO
			  String[] templates = MartEditor.getDatabaseDatasetConfigUtils().getAllTemplateNames();							
			  if(templates.length!=0){
					  template =
						(String) JOptionPane.showInputDialog(
							  null,
							  "Choose one",
							  "Template",
							  JOptionPane.INFORMATION_MESSAGE,
							  null,
							  templates,null);
					  if (template == null)
							return;
			  }
			  else{
				  JOptionPane.showMessageDialog(null,"No existing templates available. Create a new one");
				  return;								
			  }
		  }
		  else{// CANCEL
			  return;
		  }


      	
      DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, null, dataset, null, schema,template,null);
      frame.setVisible(true);
      desktop.add(frame);
      try {
        frame.setSelected(true);
      } catch (java.beans.PropertyVetoException e) {
      }
    } catch (SQLException e) {
    } catch (ConfigurationException e) {
    } finally {
      enableCursor();
    }
  }
  
  public void naiveDatasetConfig(){
    if (ds == null) {
      JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
      return;
    }

    
    String dbtype = databaseDialog.getDatabaseType();
    String schema = null;
    
    if(dbtype.equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
    else schema = databaseDialog.getSchema();
     
    
    try {
      disableCursor();
      String[] datasets = dbutils.getNaiveDatasetNamesFor(schema);
      if(datasets.length==0){
        JOptionPane.showMessageDialog(this, "No datasets available - Is this a BioMart comptatible schema?", "ERROR", 0);
        return;
      }
      
      String dataset =
        (String) JOptionPane.showInputDialog(
          null,
          "Choose one",
          "Dataset",
          JOptionPane.INFORMATION_MESSAGE,
          null,
          datasets,
          datasets[0]);
      if (dataset == null)
        return;

      disableCursor();
/*     
      String template = dataset;
      
      String[] templates = new String[dbutils.getAllTemplateNames().length + 1];
      templates[0] = dataset;	
	  String[] tNames = dbutils.getAllTemplateNames();
	  for (int i = 0; i < tNames.length; i++){
	  	templates[i+1] = tNames[i];
	  }
	  if(templates.length!=0){
		//JOptionPane.showMessageDialog(this, "No datasets available - Is this a BioMart comptatible schema?", "ERROR", 0);
		//return;
      
	   template =
		(String) JOptionPane.showInputDialog(
		  null,
		  "Choose one",
		  "Template",
		  JOptionPane.INFORMATION_MESSAGE,
		  null,
		  templates,
		  templates[0]);
	  if (template == null)
		return;
	  }
*/
	  String template = dataset;
      	
      DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, null, null, dataset, null, schema,template,null);
      frame.setVisible(true);
      desktop.add(frame);
      try {
        frame.setSelected(true);
      } catch (java.beans.PropertyVetoException e) {
      }
    } catch (SQLException e) {
    } finally {
      enableCursor();
    }
  }

  public void saveAll() {
  	
  	
	try {
			if (ds == null) {
			  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
			  return;
			}

			try {
				if (!dbutils.baseDSConfigTableExists()) {
					  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
					  return;
					}
				
			  disableCursor();
		  	  // choose folder
			  JFileChooser fc = new JFileChooser(getFileChooserPath());
			  
			  fc.setSelectedFile(getFileChooserPath());
			  fc.setDialogTitle("Choose folder to save all XMLs");
			  fc.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY);
			  if (fc.showSaveDialog(getContentPane())!=fc.APPROVE_OPTION) return;
		  
			  // cycle through all datasets for the database
			  String[] datasets = dbutils.getAllDatasetNames(user,martUser);
			  for (int i = 0; i < datasets.length; i++){
				String dataset = datasets[i];
				String[] internalNames = dbutils.getAllDatasetIDsForDataset(user, dataset);
				for (int j = 0; j < internalNames.length; j++){
					String internalName = internalNames[j];
				
					DatasetConfig odsv = null;
					DSConfigAdaptor adaptor = new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true, true);
					DatasetConfigIterator configs = adaptor.getDatasetConfigs();
					while (configs.hasNext()){
						DatasetConfig lconfig = (DatasetConfig) configs.next();
						if (lconfig.getDataset().equals(dataset) && lconfig.getDatasetID().equals(internalName)){
								odsv = lconfig;
								break;
						}
					}
					adaptor.lazyLoad(odsv);// makes sure nothing is lost such as optional_parameterrs
					// save osdv each one to a separate file <internalname>.xml
					try {
						File newFile = new File(fc.getSelectedFile(), odsv.getDataset() + ".xml");
						URLDSConfigAdaptor.StoreDatasetConfig(odsv, newFile);
							setFileChooserPath(fc.getSelectedFile());
					} catch (Exception e) {
							e.printStackTrace();
					}
				  				
				}	
			  }
			  
			  // cycle through all templates for the database
			  String[] templates = dbutils.getAllTemplateNames();
			  for (int i = 0; i < templates.length; i++){
				String template = templates[i];
				DatasetConfig odsv = new DatasetConfig("template","",template+"_template","","","","","","","","","","","",template,"","","","");
				dscutils.loadDatasetConfigWithDocument(odsv,dbutils.getTemplateDocument(template));
				try {
						File newFile = new File(fc.getSelectedFile(), odsv.getDataset() + ".template.xml");
						URLDSConfigAdaptor.StoreDatasetConfig(odsv, newFile);
							setFileChooserPath(fc.getSelectedFile());
				} catch (Exception e) {
							e.printStackTrace();
				}	
			  }
			} catch (Exception e) {
			  e.printStackTrace();
			}
		  } finally {
			enableCursor();
		  }

  }


  public void uploadAll() {
  	
  	
	try {
			if (ds == null) {
			  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
			  return;
			}

			try {
			  disableCursor();
			  // choose folder
			  JFileChooser fc = new JFileChooser(getFileChooserPath());
			  fc.setSelectedFile(getFileChooserPath());	


		        dbutils.setReadonly(false);
			  // changed to JOptionPane as not readable on the file chooser
			  if (JOptionPane.showConfirmDialog(null,"WARNING - THIS WILL REMOVE ALL EXISTING CONFIGURATION IN THE DATABASE YOU ARE UPLOADING YOUR CONFIGURATION TO.\nAre you sure you want to do this?")!=JOptionPane.YES_OPTION) return;
			  //fc.setDialogTitle("Choose file(s) to upload: WARNING: THIS WILL REMOVE ALL EXISTING XMLS IN THE DATABASE");
		  	  
			  fc.setMultiSelectionEnabled(true);			  
			  XMLFileFilter filter = new XMLFileFilter();
			  fc.addChoosableFileFilter(filter);
			  int returnVal = fc.showOpenDialog(getContentPane());
			  if (returnVal == JFileChooser.APPROVE_OPTION) {
			     
				 //file = fc.getSelectedFile();// works
				 	
			     // cycle through all dataset files	
			     File[] files = fc.getSelectedFiles();
				 dbutils.dropMetaTables(); 
				
				 // have to upload templates first
				 for (int i = 0; i < files.length; i++){
					file = files[i];
				  			  
	   			    URL url = file.toURL();
					//System.out.println(file.getName());
				  
	  			    if (file.getName().endsWith(".template.xml")){
						System.out.println("!!!UPLOAD TEMPLATE XML "+file.getName());
						DSConfigAdaptor adaptor = new URLDSConfigAdaptor(url,true, true);
						DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
						//DatasetConfig odsv = new DatasetConfig("template","",template+"_template","","","","","","","","","","","",template,"","");
						//dscutils.loadDatasetConfigWithDocument(odsv,dbutils.getTemplateDocument(template));
						odsv.setSoftwareVersion(dbutils.getSoftwareVersion());
						dbutils.storeTemplateXML(odsv,odsv.getTemplate());
						
						//DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
				  	
					}
				 }
				 
			     for (int i = 0; i < files.length; i++){
				  file = files[i];
				  			  
				  URL url = file.toURL();
				  //System.out.println(file.getName());
				  
				  if (file.getName().endsWith(".template.xml")){
				  	  continue;
				  }
				  else{
				  	//ignoreCache, includeHiddenMembers
				  	DSConfigAdaptor adaptor = new URLDSConfigAdaptor(url,true, true);
				  	DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
				  	odsv.setDatasetID("");
				  	// export osdv
				  
				  	String martUsers = odsv.getMartUsers();
				  	String interfaces = odsv.getInterfaces();
				  	if (martUsers == null)
					martUsers = "default";
	  
				  	if (interfaces == null)
						interfaces = "default";
				  
				  	// convert config to latest version using xslt
				  	odsv = MartEditor.getDatabaseDatasetConfigUtils().getXSLTransformedConfig(odsv);
				  
				  	try {
				  	    dbutils.storeDatasetConfiguration(
									MartEditor.getUser(),
									odsv.getInternalName(),
									odsv.getDisplayName(),
									odsv.getDataset(),
									odsv.getDescription(),
									MartEditor.getDatasetConfigXMLUtils().getDocumentForDatasetConfig(odsv),
									true,
									odsv.getType(),
									odsv.getVisible(),
									odsv.getVersion(),
									odsv.getDatasetID(),
									martUsers,
									interfaces,
									odsv);
				   	} catch (Exception e) {
							e.printStackTrace();
				   	}
				   }
			     } 				
			  } 
			} catch (ConfigurationException e) {
			  JOptionPane.showMessageDialog(this, "File does not contain valid configuration", "ERROR", 0);
			} catch (Exception e) {
			  e.printStackTrace();
			}
		  } finally {
			enableCursor();
	        dbutils.setReadonly(true);
		  }
  }


  public void moveAll() {  	
	  
	  if (JOptionPane.showConfirmDialog(null,"WARNING - THIS WILL REMOVE ALL EXISTING CONFIGURATION IN THE DATABASE YOU ARE MOVING YOUR CONFIGURATION TO.\nAre you sure you want to do this?")!=JOptionPane.YES_OPTION) return;
	  
  	  // choose folder
	  File tempFolder;
	  try {
	  File tempFile = File.createTempFile("marteditor", "tmp");
	  tempFile.deleteOnExit();
	  tempFolder = new File(tempFile.getCanonicalPath()+"dir");
	  tempFolder.deleteOnExit();
	  tempFolder.mkdir();
	  } catch (Exception e) {
		  JOptionPane.showMessageDialog(this, "Could not create temp directory", "ERROR", 0);
		  return;
	  }

	  // Write all configs to file.
	  	
		try {
				if (ds == null) {
				  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
				  return;
				}

				try {
					if (!dbutils.baseDSConfigTableExists()) {
						  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
						  return;
						}
					
				  disableCursor();
			  
				  // cycle through all datasets for the database
				  String[] datasets = dbutils.getAllDatasetNames(user,martUser);
				  for (int i = 0; i < datasets.length; i++){
					String dataset = datasets[i];
					String[] internalNames = dbutils.getAllDatasetIDsForDataset(user, dataset);
					for (int j = 0; j < internalNames.length; j++){
						String internalName = internalNames[j];
					
						DatasetConfig odsv = null;
						DSConfigAdaptor adaptor = new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true, true);
						DatasetConfigIterator configs = adaptor.getDatasetConfigs();
						while (configs.hasNext()){
							DatasetConfig lconfig = (DatasetConfig) configs.next();
							if (lconfig.getDataset().equals(dataset) && lconfig.getDatasetID().equals(internalName)){
									odsv = lconfig;
									break;
							}
						}
						adaptor.lazyLoad(odsv);// makes sure nothing is lost such as optional_parameterrs
						// save osdv each one to a separate file <internalname>.xml
						try {
							File newFile = new File(tempFolder, odsv.getDataset() + ".xml");
							newFile.deleteOnExit();
							URLDSConfigAdaptor.StoreDatasetConfig(odsv, newFile);
						} catch (Exception e) {
								e.printStackTrace();
						}
					  				
					}	
				  }
				  
				  // cycle through all templates for the database
				  String[] templates = dbutils.getAllTemplateNames();
				  for (int i = 0; i < templates.length; i++){
					String template = templates[i];
					DatasetConfig odsv = new DatasetConfig("template","",template+"_template","","","","","","","","","","","",template,"","","","");
					dscutils.loadDatasetConfigWithDocument(odsv,dbutils.getTemplateDocument(template));
					odsv.setSoftwareVersion(dbutils.getSoftwareVersion());
					try {
							File newFile = new File(tempFolder, odsv.getDataset() + ".template.xml");
							newFile.deleteOnExit();
							URLDSConfigAdaptor.StoreDatasetConfig(odsv, newFile);
					} catch (Exception e) {
								e.printStackTrace();
					}	
				  }
				} catch (Exception e) {
				  e.printStackTrace();
				}
			  } finally {
				enableCursor();
			  }
			  
			  
	  // Find out where we're going.

			// connect to database to export to
	    	databaseConnection("Move to this database:");
	    	

	   // Load configs back from file.
	      	
	    	try {
	    			if (ds == null) {
	    			  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
	    			  return;
	    			}

	    			try {
	    			  disableCursor();

	    		        dbutils.setReadonly(false);
    		  	  
	    			     
	    				 //file = fc.getSelectedFile();// works
	    				 	
	    			     // cycle through all dataset files	
	    			     File[] files = tempFolder.listFiles();
	    				 dbutils.dropMetaTables(); 
	    				
	    				 // have to upload templates first
	    				 for (int i = 0; i < files.length; i++){
	    					file = files[i];
	    				  			  
	    	   			    URL url = file.toURL();
	    					//System.out.println(file.getName());
	    				  
	    	  			    if (file.getName().endsWith(".template.xml")){
	    						System.out.println("!!!UPLOAD TEMPLATE XML "+file.getName());
	    						DSConfigAdaptor adaptor = new URLDSConfigAdaptor(url,true, true);
	    						DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
	    						//DatasetConfig odsv = new DatasetConfig("template","",template+"_template","","","","","","","","","","","",template,"","");
	    						//dscutils.loadDatasetConfigWithDocument(odsv,dbutils.getTemplateDocument(template));
	    						dbutils.storeTemplateXML(odsv,odsv.getTemplate());
	    						
	    						//DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
	    				  	
	    					}
	    				 }
	    				 
	    			     for (int i = 0; i < files.length; i++){
	    				  file = files[i];
	    				  			  
	    				  URL url = file.toURL();
	    				  //System.out.println(file.getName());
	    				  
	    				  if (file.getName().endsWith(".template.xml")){
	    				  	  continue;
	    				  }
	    				  else{
	    				  	//ignoreCache, includeHiddenMembers
	    				  	DSConfigAdaptor adaptor = new URLDSConfigAdaptor(url,true, true);
	    				  	DatasetConfig odsv  = (DatasetConfig) adaptor.getDatasetConfigs().next();
	    				  	odsv.setDatasetID("");
	    				  	// export osdv
	    				  
	    				  	String martUsers = odsv.getMartUsers();
	    				  	String interfaces = odsv.getInterfaces();
	    				  	if (martUsers == null)
	    					martUsers = "default";
	    	  
	    				  	if (interfaces == null)
	    						interfaces = "default";
	    				  
	    				  	// convert config to latest version using xslt
	    				  	odsv = MartEditor.getDatabaseDatasetConfigUtils().getXSLTransformedConfig(odsv);
	    				  
	    				  	try {
	    				  	    dbutils.storeDatasetConfiguration(
	    									MartEditor.getUser(),
	    									odsv.getInternalName(),
	    									odsv.getDisplayName(),
	    									odsv.getDataset(),
	    									odsv.getDescription(),
	    									MartEditor.getDatasetConfigXMLUtils().getDocumentForDatasetConfig(odsv),
	    									true,
	    									odsv.getType(),
	    									odsv.getVisible(),
	    									odsv.getVersion(),
	    									odsv.getDatasetID(),
	    									martUsers,
	    									interfaces,
	    									odsv);
	    				   	} catch (Exception e) {
	    							e.printStackTrace();
	    				   	}
	    				   }		
	    			  } 
	    			} catch (ConfigurationException e) {
	    			  JOptionPane.showMessageDialog(this, "File does not contain valid configuration", "ERROR", 0);
	    			} catch (Exception e) {
	    			  e.printStackTrace();
	    			}
	    		  } finally {
	    			enableCursor();
	    	        dbutils.setReadonly(true);
	    		  }
  }

  public void updateAllTemplates() {
	  try {
		if (ds == null) {
		  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		  return;
		}

		try {
		  disableCursor();
			if (!dbutils.baseDSConfigTableExists()) {
				  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
				  return;
				}

	        dbutils.setReadonly(false);
		  // cycle through all datasets for the database
		  String[] datasets = dbutils.getAllDatasetNames(user,martUser);
		  for (int i = 0; i < datasets.length; i++){
		  	String dataset = datasets[i];
			String[] internalNames = dbutils.getAllDatasetIDsForDataset(user, dataset);
			for (int j = 0; j < internalNames.length; j++){
				String internalName = internalNames[j];
				
				DatasetConfig odsv = null;
				DSConfigAdaptor adaptor = new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true, true);
				DatasetConfigIterator configs = adaptor.getDatasetConfigs();
				while (configs.hasNext()){
					DatasetConfig lconfig = (DatasetConfig) configs.next();
					if (lconfig.getDataset().equals(dataset) && lconfig.getDatasetID().equals(internalName)){
							odsv = lconfig;
							break;
					}
				}
				System.out.println("!!! UPDATING "+dataset);
				//DatasetConfig odsv = dbutils.getDatasetConfigByDatasetInternalName(user, dataset, internalName);
				// update it
				odsv = MartEditor.getDatabaseDatasetConfigUtils().getXSLTransformedConfig(odsv);//needed to maintain template for some reason
				//String existingTemplate = odsv.getTemplate();
				//System.out.println("!!! TEMPLATE IS "+existingTemplate);
				DatasetConfig dsv = dbutils.getValidatedDatasetConfig(odsv);
				// test if version need updating and newVersion++ if so
				String datasetVersion = dsv.getVersion();
				String newDatasetVersion = dbutils.getNewVersion(dsv.getDataset());
				if (datasetVersion != null && datasetVersion != "" && !datasetVersion.equals(newDatasetVersion)){
					dsv.setVersion(newDatasetVersion);
					if (dsv.getDisplayName()!=null && dsv.getDisplayName().indexOf("(") > 0){
						String newDisplayName = dsv.getDisplayName().split("\\(")[0]+"("+newDatasetVersion+")";
						dsv.setDisplayName(newDisplayName);
					}
				}
				dsv.setOptionalParameter(odsv.getOptionalParameter());// so don't lose
				dsv.setEntryLabel(odsv.getEntryLabel());
				// repeat logic for linkVersions updating any not null or '' or equal to newLinkVersion
				dbutils.updateLinkVersions(dsv);					
				
				
				String schema = null;
				if(databaseDialog.getDatabaseType().equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
				else schema = databaseDialog.getSchema();
				DatasetConfig templateConfig = dbutils.getNewFiltsAtts(schema, dsv, true);// NB this actually stores the templateConfig for dsv as well
				// export it
				// convert config to latest version using xslt
				dsv = MartEditor.getDatabaseDatasetConfigUtils().getXSLTransformedConfig(dsv);
				
				//String currentTemplate = dsv.getTemplate();
				//System.out.println("UPDATED CONFIG "+dsv.getDataset()+ " HAS TEMPLATE "+currentTemplate+", SETTING TO "+existingTemplate);
				//dsv.setTemplate(existingTemplate);
				
				dbutils.storeDatasetConfiguration(
							MartEditor.getUser(),
							dsv.getInternalName(),
							dsv.getDisplayName(),
							dsv.getDataset(),
							dsv.getDescription(),
							MartEditor.getDatasetConfigXMLUtils().getDocumentForDatasetConfig(dsv),
							true,
							dsv.getType(),
							dsv.getVisible(),
							dsv.getVersion(),
							dsv.getDatasetID(),
							dsv.getMartUsers(),
							dsv.getInterfaces(),
							dsv);
					
				// display it if new atts or filts for further editing	
				/*
				if ((dsv.getAttributePageByInternalName("new_attributes") != null) ||
				    (dsv.getFilterPageByName("new_filters") != null)){
					DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, dsv, null, null, null, 
						database,null);
					frame.setVisible(true);
					desktop.add(frame);
					try {
						frame.setSelected(true);
					} catch (java.beans.PropertyVetoException e) {
					}
				}	
				*/		
			}	
		  } 
		} catch (Exception e) {
		  e.printStackTrace();
		}
	  } finally {
		enableCursor();
        dbutils.setReadonly(true);
	  }
  }
  /*
  public void validateAll() {
	  try {
		if (ds == null) {
		  JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		  return;
		}

		try {
		  disableCursor();
		  String duplicationString = "";
		  String filterDuplicationString = "";
		  String brokenString = "";
		  String spaceErrors = "";
		  String brokenFields = "";
		  
		  Set brokenDatasets = new HashSet();
		  Hashtable attributeDuplicationMap = new Hashtable();
		  Hashtable filterDuplicationMap = new Hashtable();
		  
		  int newVersion;
		  // cycle through all datasets for the database
		  String[] datasets = dbutils.getAllDatasetNames(user,martUser);
		  DSConfigAdaptor adaptor;
		  DatasetConfig dsv, odsv, adsv;
		  for (int i = 0; i < datasets.length; i++){
			String dataset = datasets[i];
			System.out.println("VALIDATING " + dataset);
			String[] internalNames = dbutils.getAllDatasetIDsForDataset(user, dataset);
			for (int j = 0; j < internalNames.length; j++){
				String internalName = internalNames[j];
				
				dsv = null;
				adaptor = new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true);
				DatasetConfigIterator configs = adaptor.getDatasetConfigs();
				while (configs.hasNext()){
					DatasetConfig lconfig = (DatasetConfig) configs.next();
					if (lconfig.getDataset().equals(dataset) && lconfig.getDatasetID().equals(internalName)){
							dsv = lconfig;
							break;
					}
				}
				
				
				// GOT DATASET CONFIG DSV
				
				
				newVersion = 0;
				// test if version need updating and newVersion++ if so
				String datasetVersion = dsv.getVersion();
				String newDatasetVersion = dbutils.getNewVersion(dsv.getDataset());
				if (newDatasetVersion != null && datasetVersion != null && datasetVersion != "" && !datasetVersion.equals(newDatasetVersion)){
					dsv.setVersion(newDatasetVersion);
					if (dsv.getDisplayName().indexOf("(") > 0){
						String newDisplayName = dsv.getDisplayName().split("\\(")[0]+"("+newDatasetVersion+")";
						dsv.setDisplayName(newDisplayName);
					}
					newVersion++;
				}
				// repeat logic for linkVersions updating any not null or '' or equal to newLinkVersion
				if (dbutils.updateLinkVersions(dsv))					
					newVersion++;
				
				if (dbutils.getBrokenElements(dsv) != "") 
					brokenString = brokenString + dbutils.getBrokenElements(dsv);
		
				String schema = null;
				if(databaseDialog.getDatabaseType().equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
				else schema = databaseDialog.getSchema();
				dsv = dbutils.getNewFiltsAtts(schema, dsv);		
				
				// check uniqueness of internal names per page	  
				AttributePage[] apages = dsv.getAttributePages();
				AttributePage apage;
				String testInternalName;
				
	  
				for (int k = 0; k < apages.length; k++){
				 apage = apages[k];
				 Hashtable descriptionsMap = new Hashtable();
				 if ((apage.getHidden() != null) && (apage.getHidden().equals("true"))){
					continue;
				 }
		    
				
                 List testGroups = new ArrayList();				
				 testGroups = apage.getAttributeGroups();
				 for (Iterator groupIter = testGroups.iterator(); groupIter.hasNext();) {
				   AttributeGroup testGroup = (AttributeGroup) groupIter.next();
				   //List testColls = new ArrayList();				
				   AttributeCollection[] testColls = testGroup.getAttributeCollections();
				   for (int col = 0; col < testColls.length; col++) {
				     AttributeCollection testColl = testColls[col];
				     
					 if (testColl.getInternalName().matches("\\w+\\s+\\w+")){
					   spaceErrors = spaceErrors + "AttributeCollection " + testColl.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
					 }					  			
				 	 List testAtts = new ArrayList();
					 testAtts = testColl.getAttributeDescriptions();
					  
				 	 for (Iterator iter = testAtts.iterator(); iter.hasNext();) {
						  Object testAtt = iter.next();
						  AttributeDescription testAD = (AttributeDescription) testAtt;
						  if ((testAD.getHidden() != null) && (testAD.getHidden().equals("true"))){
							  continue;
						  }
						  if (testAD.getInternalName().matches("\\w+\\.\\w+") ||
						      testAD.getInternalName().matches("\\w+\\.\\w+\\.\\w+")){
							  continue;//placeholder atts can be duplicated	
						  }
						  
						  if (testAD.getInternalName().matches("\\w+\\s+\\w+")){
							 spaceErrors = spaceErrors + "AttributeDescription " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
						  }					
						  if (descriptionsMap.containsKey(testAD.getInternalName())){
							  //duplicationString = duplicationString + "Attribute " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
							  //" and page " + apage.getInternalName() + "\n";
							  attributeDuplicationMap.put(testAD.getInternalName(),dsv.getDataset());   
							  brokenDatasets.add(dsv.getDataset());							  
						  }
						  descriptionsMap.put(testAD.getInternalName(),"1");
						  
						  if (dsv.getType().equals("GenomicSequence"))
						  	continue;//no point in checking fields
						  
						  
						// test has all its fields defined - if not add a message to brokenString
						if (testAD.getInternalName() == null || testAD.getInternalName().equals("") ||
									testAD.getField() == null || testAD.getField().equals("") ||
									testAD.getTableConstraint() == null || testAD.getTableConstraint().equals("") ||
									(dsv.getVisible() != null && dsv.getVisible().equals("1") && (testAD.getKey() == null || testAD.getKey().equals("")))				  
									){	
										brokenFields = brokenFields + "Attribute " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
												", page "+apage.getInternalName()+", group "+testGroup.getInternalName()+", collection "+testColl.getInternalName() + "\n";
						}
						  
					 }
				   }
				 }
				}
				// repeat for filter pages
				FilterPage[] fpages = dsv.getFilterPages();
				FilterPage fpage;
				for (int k = 0; k < fpages.length; k++){
							fpage = fpages[k];
							Hashtable descriptionsMap = new Hashtable();
							if ((fpage.getHidden() != null) && (fpage.getHidden().equals("true"))){
								continue;
							}
					       
					       
					List testGroups = new ArrayList();				
					testGroups = fpage.getFilterGroups();
					for (Iterator groupIter = testGroups.iterator(); groupIter.hasNext();) {
					  FilterGroup testGroup = (FilterGroup) groupIter.next();
					  //List testColls = new ArrayList();				
					  FilterCollection[] testColls = testGroup.getFilterCollections();
					  for (int col = 0; col < testColls.length; col++) {
						FilterCollection testColl = testColls[col];
				     
						if (testColl.getInternalName().matches("\\w+\\s+\\w+")){
						  spaceErrors = spaceErrors + "FilterCollection " + testColl.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
						}					 
							List testAtts = new ArrayList();
							testAtts = testColl.getFilterDescriptions();// ? OPTIONS
				  
							for (Iterator iter = testAtts.iterator(); iter.hasNext();) {
								Object testAtt = iter.next();
								FilterDescription testAD = (FilterDescription) testAtt;
								if ((testAD.getHidden() != null) && (testAD.getHidden().equals("true"))){
									  continue;
								}
								if (testAD.getInternalName().matches("\\w+\\.\\w+") ||
									testAD.getInternalName().matches("\\w+\\.\\w+\\.\\w+")){
									continue;		
								}
								
								if (testAD.getInternalName().matches("\\w+\\s+\\w+")){
									 spaceErrors = spaceErrors + "FilterDescription " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
								}	
								if (descriptionsMap.containsKey(testAD.getInternalName())){
									//duplicationString = duplicationString + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
									//filterDuplicationString = filterDuplicationString + "Filter " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
									//							  " and page " + fpage.getInternalName() + "\n";
									filterDuplicationMap.put(testAD.getInternalName(),dsv.getDataset()); 
									brokenDatasets.add(dsv.getDataset());							  
									continue;//to stop options also being assessed
								}
								
								descriptionsMap.put(testAD.getInternalName(),"1");
								
								if (dsv.getType().equals("GenomicSequence"))
								  continue;//no point in checking fields
								
								// test has all its fields defined - if not add a message to brokenString
								// only do for non-filter option filters
								if ((testAD.getFilterList() == null || testAD.getFilterList().equals("")) && (testAD.getOptions().length == 0 || testAD.getOptions()[0].getField() == null) && (testAD.getInternalName() == null || testAD.getInternalName().equals("") ||
									testAD.getField() == null || testAD.getField().equals("") ||
									testAD.getTableConstraint() == null || testAD.getTableConstraint().equals("") ||
									//testAD.getKey() == null || testAD.getKey().equals("") ||	
								    (dsv.getVisible() != null && dsv.getVisible().equals("1") && (testAD.getKey() == null || testAD.getKey().equals(""))) ||  
									testAD.getQualifier() == null || testAD.getQualifier().equals("")				  			  
									)){
										brokenFields = brokenFields + "Filter " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
												", page "+fpage.getInternalName()+", group "+testGroup.getInternalName()+", collection "+testColl.getInternalName() + "\n";		  
								}	
								
					  
								// do options as well
								Option[] ops = testAD.getOptions();
								if (ops.length > 0 && ops[0].getType()!= null && !ops[0].getType().equals("")){
								  for (int l = 0; l < ops.length; l++){
									  Option op = ops[l];
									  if ((op.getHidden() != null) && (op.getHidden().equals("true"))){
											  continue;
									  }
									  if (descriptionsMap.containsKey(op.getInternalName())){
										  //filterDuplicationString = filterDuplicationString + op.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
										filterDuplicationMap.put(testAD.getInternalName(),dsv.getDataset()); 
										brokenDatasets.add(dsv.getDataset());	
									  }
									  descriptionsMap.put(op.getInternalName(),"1");
								  }
								}
							}
					  }
					}
				}
	  
				
				// display it if new atts or filts for further editing	
				if (newVersion != 0 || (dsv.getAttributePageByInternalName("new_attributes") != null && (dsv.getAttributePageByInternalName("new_attributes").getHidden() == null || dsv.getAttributePageByInternalName("new_attributes").getHidden().equals("false"))) ||
					(dsv.getFilterPageByName("new_filters") != null && (dsv.getFilterPageByName("new_filters").getHidden() == null || dsv.getFilterPageByName("new_filters").getHidden().equals("false")))){
				
					DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, dsv, null, null, null, 
						database,null);
					frame.setVisible(true);
					desktop.add(frame);
					try {
						frame.setSelected(true);
					} catch (java.beans.PropertyVetoException e) {
					}
				}
				
				//System.out.println("!!" + dsv.getDataset()+"\nSPACE:"+spaceErrors+"\nBROKEN FIELDS:"+brokenFields+"\nBROKEN STRING"+brokenString);
				
			}
		  }// end of dataset loop
		  
		    if (spaceErrors != "")
			 	JOptionPane.showMessageDialog(null, "The following internal names contain spaces:\n"
									  + spaceErrors, "ERROR", 0);
			
			if (brokenFields != "")
				  JOptionPane.showMessageDialog(null, "The following may not contain the required fields:\n"
											+ brokenFields, "ERROR", 0);

			if (brokenString != "")
					JOptionPane.showMessageDialog(this, "The following are no longer defined in the database\n"
											  + brokenString, "ERROR", 0);

			if (spaceErrors != "" || brokenFields != "" || brokenString != "")
				return;//no export performed


			if (attributeDuplicationMap.size() > 0){
				duplicationString = "The following attribute internal names are duplicated and will cause client problems:\n";
				Enumeration enum = attributeDuplicationMap.keys();
				while (enum.hasMoreElements()){
					String intName = (String) enum.nextElement();
					duplicationString = duplicationString+"Attribute "+intName+" in dataset "+attributeDuplicationMap.get(intName)+"\n";	
				}
			}
			else if (filterDuplicationMap.size() > 0){
				duplicationString = duplicationString + "The following filter/option internal names are duplicated and will cause client problems:\n";
				Enumeration enum = filterDuplicationMap.keys();
				while (enum.hasMoreElements()){
					String intName = (String) enum.nextElement();
					duplicationString = duplicationString+"Filter "+intName+" in dataset "+filterDuplicationMap.get(intName)+"\n";	
				}
			} 	

			if (duplicationString != ""){	
			  int choice = JOptionPane.showConfirmDialog(null, duplicationString, "Make Unique?", JOptionPane.YES_NO_OPTION);							  

			  // make unique code
			  if (choice == 0){
				System.out.println("MAKING UNIQUE");	
				String testName, datasetName;
				int i;
				adaptor= new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true);
				
				String[] dsList = new String[brokenDatasets.size()];
				brokenDatasets.toArray(dsList);
										
				for (i = 0; i < dsList.length; i++){
						dsv = adaptor.getDatasetConfigByDatasetInternalName(dsList[i],"default");
						// convert config to latest version using xslt
						dsv = MartEditor.getDatabaseDatasetConfigUtils().getUpdatedConfig(dsv);
						dbutils.storeDatasetConfiguration(
															user,
															dsv.getInternalName(),
															dsv.getDisplayName(),
															dsv.getDataset(),
															dsv.getDescription(),
															MartEditor.getDatasetConfigXMLUtils().getDocumentForDatasetConfig(dsv),
															true,
															dsv.getType(),
															dsv.getVisible(),
															dsv.getVersion(),
															dsv.getDatasetID(),
															dsv.getMartUsers(),
															dsv.getInterfaces(),
															dsv);	
			    }
			  }
			  else{
				JOptionPane.showMessageDialog(null, "No Export performed",
											  "ERROR", 0);					  
				return;//no export performed
			  }
			}			
				  
		} catch (Exception e) {
		  e.printStackTrace();
		}
	  } finally {
		enableCursor();
	  }
  }  
  */
  /*
  public void updateDatasetConfig() {
    try {
      if (ds == null) {
        JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
        return;
      }

      try {
        disableCursor();
        // check whether existing filters and atts are still in database
        Object selectedFrame = desktop.getSelectedFrame();

        if (selectedFrame == null) {
          JOptionPane.showMessageDialog(this, "Nothing to Update, please Import a DatasetConfig", "ERROR", 0);
          return;
        }

        DatasetConfig odsv = ((DatasetConfigTreeWidget) selectedFrame).getDatasetConfig();

        if (odsv == null) {
          JOptionPane.showMessageDialog(this, "Nothing to Update, please Import a DatasetConfig", "ERROR", 0);
          return;
        }
		
        DatasetConfig dsv = dbutils.getValidatedDatasetConfig(odsv);
		
        // check for new tables and cols
		String schema = null;
		if(databaseDialog.getDatabaseType().equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
		else schema = databaseDialog.getSchema();
		dsv = dbutils.getNewFiltsAtts(schema, dsv);       
        //dsv = dbutils.getNewFiltsAtts(database, dsv);
		// test if version need updating
		String datasetVersion = dsv.getVersion();
		String newDatasetVersion = dbutils.getNewVersion(dsv.getDataset());
		if (datasetVersion != null && datasetVersion != "" && !datasetVersion.equals(newDatasetVersion)){
			dsv.setVersion(newDatasetVersion);
			if (dsv.getDisplayName().indexOf("(") > 0){
				String newDisplayName = dsv.getDisplayName().split("\\(")[0]+"("+newDatasetVersion+")";
				dsv.setDisplayName(newDisplayName);
			}
		}
		dbutils.updateLinkVersions(dsv);
		if (dbutils.templateCount(dsv.getTemplate()) > 1){
			dsv = dbutils.updateConfigToTemplate(dsv,0);
		}
		
//		convert config to latest version using xslt
		dsv = MartEditor.getDatabaseDatasetConfigUtils().getUpdatedConfig(dsv);
				
        DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, dsv, null, null, null, schema,null);
        frame.setVisible(true);
        desktop.add(frame);
        try {
          frame.setSelected(true);
        } catch (java.beans.PropertyVetoException e) {
        }
      } catch (Exception e) {
        e.printStackTrace();
      }
    } finally {
      enableCursor();
    }
  }


  public void validateDatasetConfig() {
	try {
	  if (ds == null) {
		JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
		return;
	  }

	  try {
		disableCursor();
		// check whether existing filters and atts are still in database
		Object selectedFrame = desktop.getSelectedFrame();

		if (selectedFrame == null) {
		  JOptionPane.showMessageDialog(this, "Nothing to Update, please Import a DatasetConfig", "ERROR", 0);
		  return;
		}

		DatasetConfig dsv = ((DatasetConfigTreeWidget) selectedFrame).getDatasetConfig();

		if (dsv == null) {
		  JOptionPane.showMessageDialog(this, "Nothing to Update, please Import a DatasetConfig", "ERROR", 0);
		  return;
		}

		
		// DO VALIDATION HERE
		
		String duplicationString = "";
		String filterDuplicationString = "";
		String brokenString = "";
		String spaceErrors = "";
		String brokenFields = "";
		  
		Set brokenDatasets = new HashSet();
		Hashtable attributeDuplicationMap = new Hashtable();
		Hashtable filterDuplicationMap = new Hashtable();
		int newVersion = 0;
		DSConfigAdaptor adaptor;
		
		// test if version need updating and newVersion++ if so
		String datasetVersion = dsv.getVersion();
		String newDatasetVersion = dbutils.getNewVersion(dsv.getDataset());
		if (newDatasetVersion != null && datasetVersion != null && datasetVersion != "" && !datasetVersion.equals(newDatasetVersion)){
			dsv.setVersion(newDatasetVersion);
			if (dsv.getDisplayName().indexOf("(") > 0){
				String newDisplayName = dsv.getDisplayName().split("\\(")[0]+"("+newDatasetVersion+")";
				dsv.setDisplayName(newDisplayName);
			}
			newVersion++;
		}
		// repeat logic for linkVersions updating any not null or '' or equal to newLinkVersion
		if (dbutils.updateLinkVersions(dsv))					
			newVersion++;
				
		if (dbutils.getBrokenElements(dsv) != "") 
			brokenString = brokenString + dbutils.getBrokenElements(dsv);
		
		String schema = null;
		if(databaseDialog.getDatabaseType().equals("oracle")) schema = databaseDialog.getSchema().toUpperCase();
		else schema = databaseDialog.getSchema();
		dsv = dbutils.getNewFiltsAtts(schema, dsv);		
				
		// check uniqueness of internal names per page	  
		AttributePage[] apages = dsv.getAttributePages();
		AttributePage apage;
		String testInternalName;
				
	  
		for (int k = 0; k < apages.length; k++){
		 apage = apages[k];
		 Hashtable descriptionsMap = new Hashtable();
		 if ((apage.getHidden() != null) && (apage.getHidden().equals("true"))){
			continue;
		 }
		    
				
		 List testGroups = new ArrayList();				
		 testGroups = apage.getAttributeGroups();
		 for (Iterator groupIter = testGroups.iterator(); groupIter.hasNext();) {
		   AttributeGroup testGroup = (AttributeGroup) groupIter.next();
		   //List testColls = new ArrayList();				
		   AttributeCollection[] testColls = testGroup.getAttributeCollections();
		   for (int col = 0; col < testColls.length; col++) {
			 AttributeCollection testColl = testColls[col];
				     
			 if (testColl.getInternalName().matches("\\w+\\s+\\w+")){
			   spaceErrors = spaceErrors + "AttributeCollection " + testColl.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
			 }					  			
			 List testAtts = new ArrayList();
			 testAtts = testColl.getAttributeDescriptions();
					  
			 for (Iterator iter = testAtts.iterator(); iter.hasNext();) {
				  Object testAtt = iter.next();
				  AttributeDescription testAD = (AttributeDescription) testAtt;
				  if ((testAD.getHidden() != null) && (testAD.getHidden().equals("true"))){
					  continue;
				  }
				  if (testAD.getInternalName().matches("\\w+\\.\\w+") ||
					  testAD.getInternalName().matches("\\w+\\.\\w+\\.\\w+")){
					  continue;//placeholder atts can be duplicated	
				  }
						  
				  if (testAD.getInternalName().matches("\\w+\\s+\\w+")){
					 spaceErrors = spaceErrors + "AttributeDescription " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
				  }					
				  if (descriptionsMap.containsKey(testAD.getInternalName())){
					  //duplicationString = duplicationString + "Attribute " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
					  //" and page " + apage.getInternalName() + "\n";
					  attributeDuplicationMap.put(testAD.getInternalName(),dsv.getDataset());   
					  brokenDatasets.add(dsv.getDataset());							  
				  }
				  descriptionsMap.put(testAD.getInternalName(),"1");
						  
				  if (dsv.getType().equals("GenomicSequence"))
					continue;//no point in checking fields
						  
						  
				// test has all its fields defined - if not add a message to brokenString
				if (testAD.getInternalName() == null || testAD.getInternalName().equals("") ||
							testAD.getField() == null || testAD.getField().equals("") ||
							testAD.getTableConstraint() == null || testAD.getTableConstraint().equals("") ||
							(dsv.getVisible() != null && dsv.getVisible().equals("1") && (testAD.getKey() == null || testAD.getKey().equals("")))				  
							){	
							  brokenFields = brokenFields + "Attribute " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
							  	", page "+apage.getInternalName()+", group "+testGroup.getInternalName()+", collection "+testColl.getInternalName() + "\n";
																				//" and page " + apage.getInternalName() + "\n";	
				}
						  
			 }
		   }
		 }
		}
		// repeat for filter pages
		FilterPage[] fpages = dsv.getFilterPages();
		FilterPage fpage;
		for (int k = 0; k < fpages.length; k++){
					fpage = fpages[k];
					Hashtable descriptionsMap = new Hashtable();
					if ((fpage.getHidden() != null) && (fpage.getHidden().equals("true"))){
						continue;
					}
					       
					       
			List testGroups = new ArrayList();				
			testGroups = fpage.getFilterGroups();
			for (Iterator groupIter = testGroups.iterator(); groupIter.hasNext();) {
			  FilterGroup testGroup = (FilterGroup) groupIter.next();
			  //List testColls = new ArrayList();				
			  FilterCollection[] testColls = testGroup.getFilterCollections();
			  for (int col = 0; col < testColls.length; col++) {
				FilterCollection testColl = testColls[col];
				     
				if (testColl.getInternalName().matches("\\w+\\s+\\w+")){
				  spaceErrors = spaceErrors + "FilterCollection " + testColl.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
				}					 
					List testAtts = new ArrayList();
					testAtts = testColl.getFilterDescriptions();// ? OPTIONS
				  
					for (Iterator iter = testAtts.iterator(); iter.hasNext();) {
						Object testAtt = iter.next();
						FilterDescription testAD = (FilterDescription) testAtt;
						if ((testAD.getHidden() != null) && (testAD.getHidden().equals("true"))){
							  continue;
						}
						if (testAD.getInternalName().matches("\\w+\\.\\w+") ||
							testAD.getInternalName().matches("\\w+\\.\\w+\\.\\w+")){
							continue;		
						}
								
						if (testAD.getInternalName().matches("\\w+\\s+\\w+")){
							 spaceErrors = spaceErrors + "FilterDescription " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
						}	
						if (descriptionsMap.containsKey(testAD.getInternalName())){
							//duplicationString = duplicationString + testAD.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
							//filterDuplicationString = filterDuplicationString + "Filter " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
							//							  " and page " + fpage.getInternalName() + "\n";
							filterDuplicationMap.put(testAD.getInternalName(),dsv.getDataset()); 
							brokenDatasets.add(dsv.getDataset());							  
							continue;//to stop options also being assessed
						}
								
						descriptionsMap.put(testAD.getInternalName(),"1");
								
						if (dsv.getType().equals("GenomicSequence"))
						  continue;//no point in checking fields
								
						// test has all its fields defined - if not add a message to brokenString
						// only do for non-filter option filters
						if ((testAD.getFilterList() == null || testAD.getFilterList().equals("")) && (testAD.getOptions().length == 0 || testAD.getOptions()[0].getField() == null) && (testAD.getInternalName() == null || testAD.getInternalName().equals("") ||
							testAD.getField() == null || testAD.getField().equals("") ||
							testAD.getTableConstraint() == null || testAD.getTableConstraint().equals("") ||
							//testAD.getKey() == null || testAD.getKey().equals("") ||	
							(dsv.getVisible() != null && dsv.getVisible().equals("1") && (testAD.getKey() == null || testAD.getKey().equals(""))) ||  
							testAD.getQualifier() == null || testAD.getQualifier().equals("")				  			  
							)){
							  //brokenFields = brokenFields + "Filter " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
								//												" and page " + fpage.getInternalName() + "\n";
							  brokenFields = brokenFields + "Filter " + testAD.getInternalName() + " in dataset " + dsv.getDataset() + 
																", page "+fpage.getInternalName()+", group "+testGroup.getInternalName()+", collection "+testColl.getInternalName() + "\n";														
						}	
								
					  
						// do options as well
						Option[] ops = testAD.getOptions();
						if (ops.length > 0 && ops[0].getType()!= null && !ops[0].getType().equals("")){
						  for (int l = 0; l < ops.length; l++){
							  Option op = ops[l];
							  if ((op.getHidden() != null) && (op.getHidden().equals("true"))){
									  continue;
							  }
							  if (descriptionsMap.containsKey(op.getInternalName())){
								  //filterDuplicationString = filterDuplicationString + op.getInternalName() + " in dataset " + dsv.getDataset() + "\n";
								filterDuplicationMap.put(testAD.getInternalName(),dsv.getDataset()); 
								brokenDatasets.add(dsv.getDataset());	
							  }
							  descriptionsMap.put(op.getInternalName(),"1");
						  }
						}
					}
			  }
			}
		}
	  
				
		// display it if new atts or filts for further editing	
		if (newVersion != 0 || (dsv.getAttributePageByInternalName("new_attributes") != null && (dsv.getAttributePageByInternalName("new_attributes").getHidden() == null || dsv.getAttributePageByInternalName("new_attributes").getHidden().equals("false"))) ||
			(dsv.getFilterPageByName("new_filters") != null && (dsv.getFilterPageByName("new_filters").getHidden() == null || dsv.getFilterPageByName("new_filters").getHidden().equals("false")))){
				
			DatasetConfigTreeWidget frame = new DatasetConfigTreeWidget(null, this, dsv, null, null, null, database,null);
			frame.setVisible(true);
			desktop.add(frame);
			try {
				frame.setSelected(true);
			} catch (java.beans.PropertyVetoException e) {
			}
		}
				
	// end of previous dataset loop
		  
	if (spaceErrors != "")
		JOptionPane.showMessageDialog(null, "The following internal names contain spaces:\n"
							  + spaceErrors, "ERROR", 0);
			
	if (brokenFields != "")
		  JOptionPane.showMessageDialog(null, "The following may not contain the required fields:\n"
									+ brokenFields, "ERROR", 0);

	if (brokenString != "")
			JOptionPane.showMessageDialog(this, "The following are no longer defined in the database\n"
									  + brokenString, "ERROR", 0);

	if (spaceErrors != "" || brokenFields != "" || brokenString != "")
		return;//no export performed


	if (attributeDuplicationMap.size() > 0){
		duplicationString = "The following attribute internal names are duplicated and will cause client problems:\n";
		Enumeration enum = attributeDuplicationMap.keys();
		while (enum.hasMoreElements()){
			String intName = (String) enum.nextElement();
			duplicationString = duplicationString+"Attribute "+intName+" in dataset "+attributeDuplicationMap.get(intName)+"\n";	
		}
	}
	else if (filterDuplicationMap.size() > 0){
		duplicationString = duplicationString + "The following filter/option internal names are duplicated and will cause client problems:\n";
		Enumeration enum = filterDuplicationMap.keys();
		while (enum.hasMoreElements()){
			String intName = (String) enum.nextElement();
			duplicationString = duplicationString+"Filter "+intName+" in dataset "+filterDuplicationMap.get(intName)+"\n";	
		}
	} 	

	if (duplicationString != ""){	
	  int choice = JOptionPane.showConfirmDialog(null, duplicationString, "Make Unique?", JOptionPane.YES_NO_OPTION);							  

	  // make unique code
	  if (choice == 0){
		System.out.println("MAKING UNIQUE");	
		String testName, datasetName;
		int i;
		adaptor= new DatabaseDSConfigAdaptor(MartEditor.getDetailedDataSource(),user, martUser, true, false, true);
				
		String[] dsList = new String[brokenDatasets.size()];
		brokenDatasets.toArray(dsList);
										
		for (i = 0; i < dsList.length; i++){
				dsv = adaptor.getDatasetConfigByDatasetInternalName(dsList[i],"default");
				dbutils.storeDatasetConfiguration(
													user,
													dsv.getInternalName(),
													dsv.getDisplayName(),
													dsv.getDataset(),
													dsv.getDescription(),
													MartEditor.getDatasetConfigXMLUtils().getDocumentForDatasetConfig(dsv),
													true,
													dsv.getType(),
													dsv.getVisible(),
													dsv.getVersion(),
													dsv.getDatasetID(),
													dsv.getMartUsers(),
													dsv.getInterfaces(),
													dsv);	
		}
	  }
	  else{
		JOptionPane.showMessageDialog(null, "No Export performed",
									  "ERROR", 0);					  
		return;//no export performed
	  }
	}			
		
	  } catch (Exception e) {
		e.printStackTrace();
	  }
	} finally {
	  enableCursor();
	}
  }






*/


  public void deleteDatasetConfig() {

    try {
      if (ds == null) {
        JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
        return;
      }

      try {
        disableCursor();
		if (!dbutils.baseDSConfigTableExists()) {
			  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
			  return;
			}
        dbutils.setReadonly(false);
        String[] datasets = dbutils.getAllDatasetNames(user,martUser);
		if (datasets==null || datasets.length==0) {
			  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
			  return;
			}
        String dataset =
          (String) JOptionPane.showInputDialog(
            null,
            "Choose one",
            "Dataset Config",
            JOptionPane.INFORMATION_MESSAGE,
            null,
            datasets,
            datasets[0]);
        if (dataset == null)
          return;
        String[] internalNames = dbutils.getAllDatasetIDsForDataset(user, dataset);
        String intName;
        if (internalNames.length == 1)
          intName = internalNames[0];
        else {
          intName =
            (String) JOptionPane.showInputDialog(
              null,
              "Choose one",
              "Dataset ID",
              JOptionPane.INFORMATION_MESSAGE,
              null,
              internalNames,
              internalNames[0]);
        }
        if (intName == null)
          return;
        
        // Find the template name.
        DatasetConfig dsconf = dbutils.getDatasetConfigByDatasetID(user, dataset, intName, schema);
        String template = dsconf.getTemplate();
        
        // Will the template be an orphan after this? No? Make it null.
        String[] refs = dbutils.getDatasetNamesForTemplate(template);
        if (refs!=null && refs.length>1)
        	template = null;
        else if (refs!=null && refs.length==1) {
        	// Check with user if they want to remove the template too.
        	if (JOptionPane.showConfirmDialog(null, 
        			"The template for this dataset will be orphaned if this dataset is deleted.\n" +
        			"Do you want to delete the template too?")
        			!=JOptionPane.YES_OPTION) 
        		template = null;
        }
        
        dbutils.deleteDatasetConfigsForDatasetID(dataset, intName, user, template);

      } catch (ConfigurationException e) {
      }
    } finally {
      enableCursor();
      dbutils.setReadonly(true);
    }
  }
  
  public void deleteTemplateConfig() {

	    try {
	      if (ds == null) {
	        JOptionPane.showMessageDialog(this, "Connect to database first", "ERROR", 0);
	        return;
	      }

	      try {
	        disableCursor();
			if (!dbutils.baseDSConfigTableExists()) {
				  JOptionPane.showMessageDialog(this, "Database contains no datasets", "ERROR", 0);
				  return;
				}
	        dbutils.setReadonly(false);
	        String[] templates = dbutils.getAllTemplateNames();
			if (templates==null || templates.length==0) {
				  JOptionPane.showMessageDialog(this, "Database contains no templates", "ERROR", 0);
				  return;
				}
	        String template =
	          (String) JOptionPane.showInputDialog(
	            null,
	            "Choose one",
	            "Template Config",
	            JOptionPane.INFORMATION_MESSAGE,
	            null,
	            templates,
	            templates[0]);
	        if (template == null)
	          return;
	        	        	        
	        dbutils.deleteTemplateConfigs(template);

	      } catch (ConfigurationException e) {
	      }
	    } finally {
	      enableCursor();
	      dbutils.setReadonly(true);
	    }
	  }
/*
  public void save() {
    ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).save();
  }

  public void save_as() {
    ((DatasetConfigTreeWidget) desktop.getSelectedFrame()).save_as();
  }
*/
  public void exit() {
    System.exit(0);
  }

  public void undo() {

  }

  public void redo() {

  }

  private void enableCursor() {
    setCursor(Cursor.getDefaultCursor());
    getGlassPane().setVisible(false);
  }

  private void disableCursor() {
    getGlassPane().setVisible(true);
    setCursor(Cursor.getPredefinedCursor(Cursor.WAIT_CURSOR));
  }
  
  public static void setDatabaseDatasetConfigUtils(DatabaseDatasetConfigUtils dbutils) {
    MartEditor.dbutils = dbutils;
  }

  public static void setDetailedDataSource(DetailedDataSource ds) {
    MartEditor.ds = ds;
  }

  public static void setUser(String user) {
    MartEditor.user = user;
  }

  public static void setMartUser(String martUser) {
    MartEditor.martUser = martUser;
  }

  public static void putDatabaseDatasetConfigUtilsBySchema(DatabaseDatasetConfigUtils dbutils, String schema) {
    dbutilsHash.put(schema, dbutils);
  }
  public static void setDatasetConfigXMLUtils(DatasetConfigXMLUtils dscutils) {
    MartEditor.dscutils = dscutils;
  }
}