Application: gvSIG desktop

/* gvSIG. Geographic Information System of the Valencian Government

 *

 * Copyright (C) 2007-2008 Infrastructures and Transports Department

 * of the Valencian Government (CIT)

 * 

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 * 

 * This program 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 General Public License for more details.

 * 

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, 

 * MA  02110-1301, USA.

 * 

 */

/*

 * AUTHORS (In addition to CIT):

 * 2008 Prodevelop S.L. main development

 */

package org.gvsig.normalization.gui;

import java.awt.Component;

import java.io.File;

import java.io.FileNotFoundException;

import java.io.FileReader;

import java.io.FileWriter;

import java.text.DecimalFormatSymbols;

import java.util.ArrayList;

import java.util.List;

import java.util.Locale;

import javax.swing.DefaultListModel;

import javax.swing.JFileChooser;

import javax.swing.JOptionPane;

import javax.swing.event.ChangeListener;

import org.apache.log4j.Logger;

import org.gvsig.normalization.operations.JoinedTableNormalization;

import org.gvsig.normalization.operations.NormAlgorithm;

import org.gvsig.normalization.operations.Normalization;

import org.gvsig.normalization.operations.NormalizationNewTable;

import org.gvsig.normalization.operations.StringListNormalization;

import org.gvsig.normalization.operations.TableNormalization;

import org.gvsig.patterns.normalization.Element;

import org.gvsig.patterns.normalization.Fieldseparator;

import org.gvsig.patterns.normalization.Fieldtype;

import org.gvsig.patterns.normalization.Infieldseparators;

import org.gvsig.patterns.normalization.Patternnormalization;

import org.gvsig.patterns.normalization.Stringvalue;

import org.gvsig.tools.storage.IStorage;

import org.gvsig.tools.storage.StorageXML;

import sun.text.Normalizer;

import com.hardcode.gdbms.driver.exceptions.ReadDriverException;

import com.hardcode.gdbms.engine.data.DataSource;

import com.hardcode.gdbms.engine.data.DataSourceFactory;

import com.iver.andami.PluginServices;

import com.iver.cit.gvsig.ProjectExtension;

import com.iver.cit.gvsig.fmap.drivers.FieldDescription;

import com.iver.cit.gvsig.fmap.edition.EditableAdapter;

import com.iver.cit.gvsig.fmap.edition.IEditableSource;

import com.iver.cit.gvsig.fmap.edition.IRowEdited;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import com.iver.cit.gvsig.fmap.layers.SelectableDataSource;

import com.iver.cit.gvsig.project.Project;

import com.iver.cit.gvsig.project.ProjectFactory;

import com.iver.cit.gvsig.project.documents.ProjectDocumentFactory;

import com.iver.cit.gvsig.project.documents.table.ProjectTable;

import com.iver.cit.gvsig.project.documents.table.ProjectTableFactory;

import com.iver.cit.gvsig.project.documents.table.gui.Table;

import com.iver.utiles.GenericFileFilter;

import com.iver.utiles.XMLEntity;

import com.iver.utiles.extensionPoints.ExtensionPoints;

import com.iver.utiles.extensionPoints.ExtensionPointsSingleton;

/**

 * Model of the Normalization panel

 * 

 * @author <a href="mailto:jsanz@prodevelop.es"> Jorge Gaspar Sanz Salinas</a>

 * @author <a href="mailto:vsanjaime@prodevelop.es"> Vicente Sanjaime Calvet</a>

 */

public class NormPanelModel implements INormPanelModel {

        /* ATTRIBUTES */

        private static final Logger log = PluginServices.getLogger();

        private static final String ERROR = "ERROR: ";

        private static final String INFO = "INFO: ";

        private static StringBuffer infob = new StringBuffer();

        private String fieldToNormalize;

        private String[] samples;

        private Patternnormalization pattern;

        private Table tab;

        private boolean inNewTable;

        private int selectedFieldInList = 0;

        private int contador = 1;

        private String[] relateNames;

        private ArrayList<String> fileChains;

        private boolean isFile;

        private String nameFile;

        /* SINGLETON DEFINITION */

        private volatile static INormPanelModel uniqueInstance;

        /**

         * Get the instance of panel model

         * 

         * @return panel model

         */

        public static INormPanelModel getInstance() {

                if (uniqueInstance == null) {

                        synchronized (NormPanelModel.class) {

                                if (uniqueInstance == null) {

                                        uniqueInstance = new NormPanelModel();

                                }

                        }

                }

                return uniqueInstance;

        }

        /* BUILDERS */

        private NormPanelModel() {

                initPattern();

        }

        // Constructors prior to the singleton pattern adoption

        // private NormPanelModel(Table tab2) {

        // this();

        // isFile = false;

        // /* Table */

        // this.tab = tab2;

        // }

        //

        // private NormPanelModel(ArrayList<String> arr, String _nameFile) {

        // this();

        // isFile = true;

        // /* all strings from file */

        // fileChains = arr;

        // /* file name */

        // nameFile = _nameFile;

        // /* Samples of strings */

        // getSamplesFromFile();

        // }

        /* METHODS */

        /**

         * This method fills the GUI sample table with the samples

         * 

         * @return Object[][]

         */

        @SuppressWarnings("unchecked")

        public Object[][] normalizeSamples() {

                int numFields = pattern.getElements().size();

                Object[][] results = new Object[NormalizationPanel.SAMPLES][numFields];

                NormAlgorithm na = new NormAlgorithm(this.pattern);

                List<String> chains;

                for (int i = 0; i < NormalizationPanel.SAMPLES; i++) {

                        chains = na.splitChain(samples[i]);

                        numFields = chains.size();

                        for (int j = 0; j < numFields; j++) {

                                results[i][j] = chains.get(j);

                        }

                }

                return results;

        }

        /**

         * This method updates the model of the names FieldList

         * 

         * @return list model

         */

        public DefaultListModel updateListModel() {

                DefaultListModel dlmodel = new DefaultListModel();

                Element[] adr = this.pattern.getArrayElements();

                String name = "";

                for (int i = 0; i < adr.length; i++) {

                        name = adr[i].getFieldname();

                        dlmodel.add(i, name);

                }

                return dlmodel;

        }

        /**

         * Run the process of normalization

         * 

         * @return process ok

         */

        public boolean runModel(ChangeListener listener) {

                Normalization normAction = null;

                // REQUEST FILE TO OUPUT THE DBF

                File thefile = null;

                if (this.isFile || (!this.isFile && this.inNewTable)) {

                        thefile = getDBFFile();

                        if (thefile == null) {

                                addInfo(INFO + PluginServices.getText(null, "endnormalizing")

                                                + " \n");

                                return false;

                        }

                        if (thefile.exists() ) {

                                addInfo(ERROR + PluginServices.getText(null, "fileexists")

                                                + " \n");

                                addInfo(INFO + PluginServices.getText(null, "endnormalizing")

                                                + " \n");

                                return false;

                        }

                }

                // FILE NORMALIZATION

                if (this.isFile) {

                        normAction = new StringListNormalization(pattern, fileChains,

                                        thefile);

                } else {

                        IEditableSource source = tab.getModel().getModelo();

                        int index = tab.getSelectedFieldIndices().nextSetBit(0);

                        if (!this.inNewTable) {

                                // ONE TALBE

                                log.debug("New fields in the original table");

                                normAction = new TableNormalization(source, index, pattern);

                        } else {

                                // JOINED TABLE

                                normAction = new JoinedTableNormalization(source, index,

                                                pattern, relateNames, thefile);

                        }

                }

                normAction.registerListener(listener);

                boolean pre = normAction.preProcess();

                if (pre) {

                        PluginServices.cancelableBackgroundExecution(new NormalizationTask(

                                        normAction, this));

                } else {

                        log.error("Error preprocessing tables");

                        return false;

                }

                if (normAction instanceof NormalizationNewTable) {

                        NormalizationNewTable normTable = (NormalizationNewTable) normAction;

                        this.loadTable(normTable);

                }

                return true;

        }

        /**

         * This method up the selected element one position in the list of

         * Elements

         * 

         * @param pos

         */

        public void fieldUp(int pos) {

                int nu = pattern.getElements().size();

                if (pos > 0 && nu > 1) {

                        int newpos = pos - 1;

                        Element[] ad = pattern.getArrayElements();

                        Element ele21 = ad[pos];

                        Element ele12 = ad[newpos];

                        ad[newpos] = ele21;

                        ad[pos] = ele12;

                        List<Element> elems = new ArrayList<Element>();

                        for (int i = 0; i < ad.length; i++) {

                                elems.add(ad[i]);

                        }

                        pattern.setElements(elems);

                }

        }

        /**

         * This method down the selected element one position in the list of

         * Elements

         * 

         * @param pos

         */

        public void fieldDown(int pos) {

                int nu = pattern.getElements().size();

                if (pos != (nu - 1) && nu > 1) {

                        int newpos = pos + 1;

                        Element[] ad = pattern.getArrayElements();

                        Element ele21 = ad[pos];

                        Element ele12 = ad[newpos];

                        ad[newpos] = ele21;

                        ad[pos] = ele12;

                        List<Element> elems = new ArrayList<Element>();

                        for (int i = 0; i < ad.length; i++) {

                                elems.add(ad[i]);

                        }

                        pattern.setElements(elems);

                }

        }

        /**

         * This method adds a new element to the pattern

         */

        @SuppressWarnings("unchecked")

        public void addField() {

                contador++;

                int tam = pattern.getElements().size();

                Element elem = new Element();

                Fieldseparator fsep = new Fieldseparator();

                fsep.setSemicolonsep(true);

                fsep.setJoinsep(false);

                fsep.setColonsep(false);

                fsep.setSpacesep(false);

                fsep.setTabsep(false);

                String nam = "";

                boolean isOkName = true;

                do {

                        isOkName = true;

                        nam = "NewField" + contador;

                        for (int i = 0; i < tam; i++) {

                                String napat = ((Element) pattern.getElements().get(i))

                                                .getFieldname();

                                if (napat.compareToIgnoreCase(nam) == 0) {

                                        isOkName = false;

                                        break;

                                }

                        }

                        if (!isOkName) {

                                contador++;

                        }

                } while (!isOkName);

                // validate the new field name

                elem.setFieldname(validateFieldName(nam));

                elem.setFieldseparator(fsep);

                elem.setInfieldseparators(getDefaultInfieldseparators());

                elem.setFieldtype(getDefaultNewFieldType());

                elem.setFieldwidth(0);

                elem.setImportfield(true);

                pattern.getElements().add(tam, elem);

        }

        /**

         * This method erases a selected element to the list

         * 

         * @param pos

         *            position

         */

        public void deleteField(int pos) {

                int conta = pattern.getElements().size();

                if (conta > 1) {

                        pattern.getElements().remove(pos);

                }

        }

        /**

         * This method saves a Normalization pattern to XML file *

         */

        public void savePatternXML() {

                JFileChooser jfc = new JFileChooser();

                jfc.setDialogTitle(PluginServices.getText(this, "save_norm_pattern"));

                String[] extensions = { "xml" };

                jfc.setCurrentDirectory(new File(getFolderPattern()));

                jfc.addChoosableFileFilter(new GenericFileFilter(extensions,

                                PluginServices.getText(this, "pattern_norm_file")));

                int returnval = jfc.showSaveDialog((Component) PluginServices

                                .getMainFrame());

                if (returnval == JFileChooser.APPROVE_OPTION) {

                        File thefile = jfc.getSelectedFile();

                        // Check if the file has extension

                        if (!(thefile.getPath().toLowerCase().endsWith(".xml"))) {

                                thefile = new File(thefile.getPath() + ".xml");

                        }

                        if (thefile.exists()) {

                                int n = JOptionPane.showConfirmDialog(null, PluginServices

                                                .getText(null, "file_exists"), PluginServices.getText(

                                                null, "save_norm_pattern"), JOptionPane.YES_NO_OPTION);

                                if (n == JOptionPane.YES_OPTION) {

                                        writeSaveFile(thefile);

                                        log.debug("overwrite file");

                                } else if (n == JOptionPane.NO_OPTION) {

                                        log.debug("Don't save the file");

                                        addInfo(INFO

                                                        + PluginServices.getText(null, "filenotoverwrite")

                                                        + " \n");

                                } else {

                                        log.debug("Don't save the file");

                                        addInfo(INFO + PluginServices.getText(null, "filenotsave")

                                                        + " \n");

                                }

                        } else {

                                writeSaveFile(thefile);

                        }

                } else {

                        addInfo(INFO + PluginServices.getText(null, "nosave") + " \n");

                }

        }

        /**

         * This method loads a Normalization pattern from a XML file and return the

         * pattern and the String info

         * 

         * @return pattern

         */

        public Patternnormalization loadPatternXML() {

                Patternnormalization pat = new Patternnormalization();

                File thefile = null;

                StringBuffer infob = new StringBuffer();

                // Show the FileChooser to select a pattern

                JFileChooser jfc = new JFileChooser();

                jfc.setCurrentDirectory(new File(getFolderPattern()));

                jfc.setDialogTitle(PluginServices.getText(this, "load_norm_pattern"));

                String[] extensions = { "xml" };

                jfc.addChoosableFileFilter(new GenericFileFilter(extensions,

                                PluginServices.getText(this, "pattern_norm_file")));

                int returnval = jfc.showOpenDialog((Component) PluginServices

                                .getMainFrame());

                if (returnval == JFileChooser.APPROVE_OPTION) {

                        thefile = jfc.getSelectedFile();

                        log.debug("file to open: " + thefile);

                } else {

                        addInfo(INFO + PluginServices.getText(null, "noload") + " \n");

                        return null;

                }

                FileReader red;

                IStorage storage;

                try {

                        red = new FileReader(thefile);

                        storage = new StorageXML();

                        storage.load(red);

                        pat.setstate(storage);

                        addInfo(INFO + thefile.getName() + " "

                                        + PluginServices.getText(null, "loadsuccess") + " \n");

                } catch (FileNotFoundException e) {

                        pat = null;

                        addInfo(ERROR + PluginServices.getText(null, "filenotfound")

                                        + " \n");

                        log.error("File not found", e);

                } catch (Exception e) {

                        pat = null;

                        addInfo(ERROR + PluginServices.getText(null, "parsingpatternxml")

                                        + " \n");

                        log.error("ERROR Parsing xml", e);

                }

                addInfo(infob.toString());

                return pat;

        }

        /* GETTERS Y SETTERS */

        /**

         * Return the name of the field to normalize

         * 

         * @return field name

         */

        public String getFieldToNormalize() {

                return fieldToNormalize;

        }

        /**

         * Set the name of the field to normalize

         * 

         * @param fieldToNormalize

         */

        public void setFieldToNormalize(String fieldToNormalize) {

                this.fieldToNormalize = fieldToNormalize;

                /* Get samples to put in the GUI table */

                getSamplesFromTable();

        }

        /**

         * This method returns the names of the fields from the pattern

         * 

         * @return new fields names

         */

        public String[] getNewFieldNames() {

                int numFields = pattern.getElements().size();

                String[] res = new String[numFields];

                for (int i = 0; i < numFields; i++) {

                        res[i] = ((Element) pattern.getElements().get(i)).getFieldname();

                }

                return res;

        }

        /**

         * Get the first or random samples from data source (FILE)

         */

        public void getSamplesFromFile(int numNoRows) {

                int num = NormalizationPanel.SAMPLES;

                String[] res = new String[num];

                for (int i = 0; i < num; i++) {

                        try {

                                res[i] = (String) fileChains.get(i + numNoRows);

                        } catch (Exception e) {

                                res[i] = "";

                        }

                }

                this.samples = res;

        }

        /**

         * Return the samples Table

         * 

         * @return samples from table

         */

        public String[] getSamplesTable() {

                return samples;

        }

        /**

         * Return the samples File

         * 

         * @return samples from file

         */

        public String[] getSamplesFile() {

                return samples;

        }

        /**

         * This method sets the original table to the model

         * 

         * @param _table

         */

        public void setTable(Table _table) {

                tab = _table;

        }

        /**

         * This method says if the process will be in a new table (true) or in the

         * original table (false)

         * 

         * @return

         */

        public boolean isInNewTable() {

                return inNewTable;

        }

        /**

         * Assign value the flag

         * 

         * @param inNewTable

         */

        public void setInNewTable(boolean inNewTable) {

                this.inNewTable = inNewTable;

        }

        /**

         * This method returns a Element of one position

         * 

         * @param index

         * @return

         */

        public Element getElement(int index) {

                Element[] adrs = pattern.getArrayElements();

                return adrs[index];

        }

        /**

         * This method gets the position of the selected element in the List of

         * names

         * 

         * @return position in the list

         */

        public int getSelectedFieldInList() {

                return selectedFieldInList;

        }

        /**

         * This method set the position of the selected element in the List

         * 

         * @param selectedFieldInList

         */

        public void setSelectedFieldInList(int selectedFieldInList) {

                this.selectedFieldInList = selectedFieldInList;

        }

        /**

         * This method returns the fields names of the original table

         * 

         * @return list model

         */

        public DefaultListModel getAllOriginalFields() {

                FieldDescription[] fields = tab.getModel().getModelo()

                                .getFieldsDescription();

                int num = fields.length;

                String names = "";

                DefaultListModel dlm = new DefaultListModel();

                dlm.add(0, PluginServices.getText(this, "none_field"));

                dlm.add(1, PluginServices.getText(this, "all_fields"));

                for (int i = 0; i < num; i++) {

                        names = fields[i].getFieldName();

                        dlm.addElement(names);

                }

                return dlm;

        }

        /**

         * This method generates and returns field separators

         * 

         * @return default separators between fields

         */

        public Fieldseparator getDefaultFieldseparators() {

                Fieldseparator filsep = new Fieldseparator();

                filsep.setSemicolonsep(true);

                filsep.setJoinsep(false);

                filsep.setColonsep(false);

                filsep.setSpacesep(false);

                filsep.setTabsep(false);

                return filsep;

        }

        /**

         * Set the names of the relate Fields

         * 

         * @param list

         *            of the names

         */

        public void setNameRelateFields(String[] names) {

                relateNames = names;

        }

        /**

         * This method returns the fields names of the original table

         * 

         * @return fields names of the main table

         */

        public String[] getFieldNamesMainTable() {

                FieldDescription[] fds = tab.getModel().getModelo()

                                .getFieldsDescription();

                String[] na = new String[fds.length];

                for (int i = 0; i < fds.length; i++) {

                        na[i] = fds[i].getFieldName();

                }

                return na;

        }

        /**

         * This method sets the pattern

         * 

         * @pat pattern

         */

        public void setPattern(Patternnormalization pat) {

                pattern = pat;

        }

        /**

         * This method returns the debug info

         * 

         * @return info about the process

         */

        public String getInfo() {

                return infob.toString();

        }

        /**

         * This method adds info about the process

         * 

         * @param chain

         *            message

         */

        public void addInfo(String chain) {

                infob.append(chain);

        }

        /**

         * This method returns the File name to normalize

         * 

         * @return file name

         */

        public String getFileName() {

                return nameFile;

        }

        /**

         * set the number of first rows that not normalize

         * 

         * @param first

         *            select the first row

         */

        public void setFirstRows(int first) {

                pattern.setNofirstrows(first);

        }

        /**

         * Set the table

         * 

         * @param tab

         *            the tab to set

         */

        public void setTab(Table tab) {

                this.tab = tab;

        }

        /**

         * Set the file strings

         * 

         * @param fileChains

         *            the fileChains to set

         */

        public void setFileChains(ArrayList<String> fileChains) {

                this.fileChains = fileChains;

                this.isFile = true;

                getSamplesFromFile(getFirstRows());

        }

        /**

         * Get the file strings

         * 

         * @return the file strings

         */

        public ArrayList<String> getFileChains() {

                return fileChains;

        }

        /**

         * Get the file name

         * 

         * @return the nameFile

         */

        public String getNameFile() {

                return nameFile;

        }

        /**

         * Get the table

         * 

         * @return the tab

         */

        public Table getTab() {

                return tab;

        }

        /**

         * Set the file name

         * 

         * @param nameFile

         *            the nameFile to set

         */

        public void setNameFile(String nameFile) {

                this.nameFile = nameFile;

        }

        /**

         * get Normalize the first row

         * 

         * @return normalize first row

         */

        public int getFirstRows() {

                return pattern.getNofirstrows();

        }

        /**

         * Set the file type

         * 

         * @param file

         */

        public void isFile(boolean file) {

                this.isFile = file;

        }

        /**

         * This method cleans the information about the process

         */

        public void clearConsole() {

                int con = infob.length() > 0 ? infob.length() - 1 : 0;

                if (con > 0) {

                        infob.delete(0, con);

                }

        }

        /**

         * This method creates the default Normalization pattern

         */

        public void initPattern() {

                Patternnormalization pat = new Patternnormalization();

                pat.setPatternname("defaultPattern");

                pat.setPatternurl("\\");

                pat.setNofirstrows(0);

                /* Create the first Address Element */

                Element elem = new Element();

                elem.setFieldname("NewField");

                elem.setFieldseparator(getDefaultFieldseparators());

                elem.setInfieldseparators(getDefaultInfieldseparators());

                elem.setFieldtype(getDefaultNewFieldType());

                elem.setFieldwidth(0);

                elem.setImportfield(true);

                List<Element> elems = new ArrayList<Element>();

                elems.add(elem);

                pat.setElements(elems);

                this.pattern = pat;

        }

        /* METHODS PRIVATES */

        /**

         * This method loads the new table

         * 

         * @param normTable

         */

        private void loadTable(NormalizationNewTable normTable) {

                String name = normTable.getOuputFile().getName();

                LayerFactory.getDataSourceFactory().addDataSource(

                                normTable.getDriver(), name);

                EditableAdapter editAdapterSecond = null;

                DataSource dtSecond;

                try {

                        dtSecond = LayerFactory.getDataSourceFactory()

                                        .createRandomDataSource(name,

                                                        DataSourceFactory.AUTOMATIC_OPENING);

                        editAdapterSecond = new EditableAdapter();

                        editAdapterSecond.setOriginalDataSource(new SelectableDataSource(

                                        dtSecond));

                        // add to doc factory

                        ProjectTable ptsec = ProjectFactory.createTable(name,

                                        editAdapterSecond);

                        ExtensionPoints extensionPoints = ExtensionPointsSingleton

                                        .getInstance();

                        extensionPoints.get("Documents");

                        ProjectDocumentFactory documentFactory = null;

                        documentFactory = new ProjectTableFactory();

                        ptsec.setProjectDocumentFactory(documentFactory);

                        Table secondTable = new Table();

                        secondTable.setModel(ptsec);

                        PluginServices.getMDIManager().addWindow(secondTable);

                        ProjectExtension pe = (ProjectExtension) PluginServices

                                        .getExtension(ProjectExtension.class);

                        Project theProject = pe.getProject();

                        theProject.addDocument(ptsec);

                        pe.getProjectFrame().refreshControls();

                } catch (Exception e) {

                        log.error("Error loading the new table", e);

                }

        }

        /**

         * This method validates the name of a new field

         * 

         * @param text

         * @return field name formatted

         */

        private String validateFieldName(String text) {

                String temp = Normalizer.normalize(text, Normalizer.DECOMP, 0);

                temp = temp.replaceAll("[^\\p{ASCII}]", "");

                temp = temp.replaceAll("[\\s]+", "_");

                temp = temp.toUpperCase();

                return temp;

        }

        /**

         * Get the first or random samples from data source (TABLE)

         */

        private void getSamplesFromTable() {

                int num = NormalizationPanel.SAMPLES;

                String[] res = new String[num];

                ProjectTable pt = tab.getModel();

                IEditableSource ies = pt.getModelo();

                try {

                        long tamTab = ies.getRowCount();

                        if (tamTab > num)

                                tamTab = num;

                        for (int i = 0; i < (int) tamTab; i++) {

                                IRowEdited rowVals = ies.getRow(i);

                                res[i] = rowVals.getAttribute(

                                                tab.getSelectedFieldIndices().nextSetBit(0)).toString()

                                                .trim();

                        }

                } catch (ReadDriverException e) {

                        log.error("ERROR al obtener el recorset de la tabla");

                        e.printStackTrace();

                }

                this.samples = res;

        }

        /**

         * This method returns the dbf file

         * 

         * @return dbf file

         */

        private File getDBFFile() {

                File thefile = null;

                JFileChooser jfc = new JFileChooser();

                jfc.setAcceptAllFileFilterUsed(false);

                jfc.addChoosableFileFilter(new GenericFileFilter("dbf", PluginServices

                                .getText(this, "gdbms dbf drver")));

                jfc.setDialogTitle(PluginServices.getText(this, "new_table"));

                int returnval = jfc.showSaveDialog((Component) PluginServices

                                .getMainFrame());

                if (returnval == JFileChooser.APPROVE_OPTION) {

                        thefile = jfc.getSelectedFile();

                        if (!(thefile.getPath().toLowerCase().endsWith(".dbf"))) {

                                thefile = new File(thefile.getPath() + ".dbf");

                        }

                }

                return thefile;

        }

        /**

         * This method generates and returns in field separators

         * 

         * @return special characters within one string

         */

        private Infieldseparators getDefaultInfieldseparators() {

                /* create the default in-field separators */

                Locale loc = Locale.getDefault();

                DecimalFormatSymbols dfs = new DecimalFormatSymbols(loc);

                Infieldseparators infilsep = new Infieldseparators();

                infilsep.setThousandseparator(Character.toString(dfs

                                .getGroupingSeparator()));

                infilsep.setDecimalseparator(Character.toString(dfs

                                .getDecimalSeparator()));

                infilsep.setTextseparator("\"");

                return infilsep;

        }

        /**

         * This method generates and returns a new field type of type Stringvalue

         * 

         * @return field type

         */

        private Fieldtype getDefaultNewFieldType() {

                Fieldtype newtype = new Fieldtype();

                Stringvalue strval = new Stringvalue();

                strval.setStringvaluewidth(50);

                newtype.setStringvalue(strval);

                return newtype;

        }

        /**

         * This method write the save xml file

         * 

         * @param file

         */

        private void writeSaveFile(File thefile) {

                StringBuffer infob = new StringBuffer();

                /* insert the name and the path */

                pattern.setPatternname(thefile.getName());

                pattern.setPatternurl(thefile.getAbsolutePath());

                FileWriter writer;

                IStorage storage;

                try {

                        storage = new StorageXML();

                        pattern.getstate(storage);

                        writer = new FileWriter(thefile);

                        // Parser the pattern

                        storage.dump(writer);

                        infob.append(INFO + thefile.getName() + " "

                                        + PluginServices.getText(null, "savesuccess") + " \n");

                        writer.close();

                } catch (Exception e) {

                        log.error("Error al parsear el patron", e);

                        infob.append(ERROR + PluginServices.getText(null, "savingpat")

                                        + " \n");

                }

                addInfo(infob.toString());

        }

        /**

         * This method return the folder where gvSIG stores the patterns

         * @return

         */

        private String getFolderPattern() {

                XMLEntity xml = PluginServices.getPluginServices(this)

                                .getPersistentXML();

                String pathFolder = String.valueOf(xml

                                .getStringProperty("Normalization_pattern_folder"));

                return pathFolder;

        }

}