Application: gvSIG desktop

<project name="extTableSummarize" default="generate-without-source" basedir=".">

    <description>

        Instala el plugin de DBF Table Summarize en Andami.

    </description>

  <!-- set global properties for this build -->

  <property name="src" location="src"/>

  <property name="without_src"  location="without_src"/>

  <property name="src-test" location="src-test"/>

  <property name="build" location="bin"/>

  <property name="build-test" location="bin-test"/>

  <property name="dist"  location="dist"/>

  <property name="lib"  location="lib"/>

  <property name="plugin" value="org.gvsig.tableSummarize"/>

  <property name="extension-dir" location="../_fwAndami/gvSIG/extensiones"/>

  <property name="gvSIGlib-dir" value="${extension-dir}/com.iver.cit.gvsig/lib"/>

  <property name="andami-dir" location="../_fwAndami"/>

	<import file="../binaries/ant/utilities.xml"/>

  <target name="init">

    <!-- Create the time stamp -->

    <tstamp/>

  	<echo>

  			Compiling ${ant.project.name}...</echo>

    <!-- Create the build directory structure used by compile -->

    <mkdir dir="${build}"/>

    <mkdir dir="${dist}"/>

  </target>

	<target name="buildNumber">  

	  <propertyfile     file="build.number"

	      comment="Build Number for ANT. Do not edit!">

	    <entry key="build.number" default="0" type="int" operation="+" />

	  </propertyfile>

	  <property file="build.number" />

	</target>

  <target name="distribution" depends="buildNumber, copy-data-files, generate-without-source">

  </target>

  <target name="compile"

          description="compile the source" >

      <!-- Compile the Java code from ${src} to ${bin} -->

		<antcall target="gvSIG-import-build-number"/>

		<loadEclipseClasspath project="${basedir}"/>

		<gvSIG-javac

			classpath="${eclipseClasspath}"

		/>

      <!--<javac      srcdir="${src}"

                  destdir="${build}"

                  source="${JavaSourceVersion}"

                  target="${JavaTargetVersion}"

                  debug="${debug}"

                  debuglevel="${debuglevel}"

                  encoding="${encoding}"

	   			  classpath="${extension-dir}/com.iver.cit.gvsig/lib/fmap.jar:${extension-dir}/com.iver.cit.gvsig/lib/com.iver.cit.gvsig.jar:../FMap/lib/cms.jar:../Andami/lib/iver-utiles.jar:../FMap/lib/gdbms-0.8-SNAPSHOT.jar:../Andami/andami.jar"/>

	  -->

    </target>

  <target name="generate-without-source" description="generate the distribution without the source file" >

    <!-- Create the distribution directory -->

    <mkdir dir="${dist}"/>

  	<loadproperties srcFile="build.number"/>

  	<!-- Put everything in ${build} into the MyProject-${DSTAMP}.jar file -->

    <jar jarfile="${dist}/${plugin}.jar" basedir="${build}"/>

  	<copy file="config/config.xml" todir="${dist}"/>

  	<copy file="build.number" todir="${dist}"/>

  	<copy todir="${dist}/images">

  	  	    	<fileset dir="images/" includes="*"/>

  	  	</copy>

  	<copy todir="${dist}">

    	<fileset dir="config" includes="text*.properties"/>

    </copy>  	

    <move todir="${extension-dir}/${plugin}/">

    	<fileset dir="${dist}" includes="**/**"/>

    </move>

  	<!--mkdir dir="${extension-dir}/${plugin}/data"/>

  	<copy todir="${extension-dir}/${plugin}/data">

  	    	<fileset dir="data" includes="**/**"/>

  	</copy-->

	<copy todir="${extension-dir}/${plugin}/">

		<fileset dir="${lib}" includes="**/*.jar"/>

	</copy>

  </target>

	<target name="copy-data-files">

			<copy file="config/config.xml" todir="${without_src}"/>

			<copy file="build.number" todir="${without_src}"/>

			<copy file="config/about.htm" todir="${without_src}"/>

			<loadproperties srcFile="build.number"/>

			<replace casesensitive="true"

	  		file="${without_src}/about.htm"

	  	  	token="#build.number#"

	  		value="${build.number}"/>

			<copy todir="${without_src}">

				<fileset dir="config" includes="text*.properties"/>

			</copy>

			<copy todir="${without_src}/images">

				<fileset dir="images/" includes="*"/>

			</copy>

	</target>

	<target name="batch-build"

			description="compile the sources, create the jar file"

			depends="init,compile,generate-without-source">

	</target>

	<target name="clean"

		    description="cleans the build directories">

		<delete dir="${build}"/>

		<delete dir="${dist}"/>

	</target>

	<!--target name="run-tests" depends="batch-build,compile-tests">

		<antcall target="generic-run-tests">

			<param name="TestSuite.Name" value="org.gvsig.crs.AllTests"/>

		</antcall>

	</target-->

</project>

<?xml version="1.0" encoding="UTF-8"?>

<classpath>

	<classpathentry kind="con" path="org.eclipse.jdt.launching.JRE_CONTAINER"/>

	<classpathentry kind="src" path="src"/>

	<classpathentry excluding="org/gvsig/crs/test/" kind="src" path="src-test"/>

	<classpathentry combineaccessrules="false" kind="src" path="/libJCRS"/>

	<classpathentry kind="src" path="/_fwAndami"/>

	<classpathentry combineaccessrules="false" kind="src" path="/appgvSIG"/>

	<classpathentry combineaccessrules="false" kind="src" path="/libFMap"/>

	<classpathentry combineaccessrules="false" kind="src" path="/libUIComponent"/>

	<classpathentry kind="lib" path="/libFMap/lib/gdbms-0.8-SNAPSHOT.jar" sourcepath="/libGDBMS"/>

	<classpathentry kind="lib" path="/_fwAndami/lib/org.gvsig.exceptions.jar"/>

	<classpathentry kind="lib" path="/libFMap/lib/driver-manager-1.1.jar" sourcepath="/libDriverManager"/>

	<classpathentry kind="lib" path="lib/swing-layout-1.0.jar"/>

	<classpathentry kind="lib" path="lib/swingx-2007_07_22.jar"/>

	<classpathentry kind="lib" path="/_fwAndami/lib/iver-utiles.jar" sourcepath="/libIverUtiles"/>

	<classpathentry kind="lib" path="/_fwAndami/lib/log4j-1.2.8.jar"/>

	<classpathentry kind="output" path="bin"/>

</classpath>

This extension is copyright of:

  IVER.T.I.

  C/ LERIDA, 20

  46009 VALENCIA (SPAIN)

  http://www.iver.es

It can be used under the terms of the GPL license, version 2

(or any later version):

http://www.gnu.org/licenses/old-licenses/gpl-2.0.html

Source code can be obtained from gvSIG public SVN:

http://subversion.gvsig.org/gvSIG/

The following third-party libraries are used by this gvSIG extension:

swingx: https://swingx.dev.java.net/

License: LGPL

swing-layout: https://swing-layout.dev.java.net/

License: LGPL

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>extTableSummarize</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

			<name>org.eclipse.jdt.core.javabuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jdt.core.javanature</nature>

	</natures>

</projectDescription>

#Translations for language [en]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=OK

btn_SummarizeForm_cancelar=Cancel

Choose_target_file_DBF=Choose target file (.DBF)

COUNT=COUNT

Data_source_not_initialized=Data source not initialized

DBF_files=DBF files

Error_creating_new_table=Error creating the new table

Error_summarizing_table=Error_summarizing_table

File_exists_Do_you_want_to_overwrite_it=File already exists. Do you want to overwrite it?

File_exists_Do_you_want_to_overwrite_it?=

GROUP=GROUP

GroupByField_not_initialized=GroupByField not initialized

Herramientas=Tools

lbl_SummarizeForm_descripcion1=<html>Summarize Table\: creates a new table which contains a register for each unique value from the groupBy field, plus the selected statistics from the rest of the fields.</html>

lbl_SummarizeForm_punto1=1. Choose the groupBy field\:

lbl_SummarizeForm_punto2=2. Choose one or more statistics to be included in the result table\:

lbl_SummarizeForm_punto3=3. Choose the target file\:

MAX=MAX

MEAN=MEAN

MIN=MIN

Not_possible_generate_unique_field_name=It is not possible to generate a unique field name

Operation_not_initialized=Operation not initialized

STDEV=STDEV

SUM=SUM

Summarize_Error_accessing_the_table=Summarize\: Error accessing the table

Summarize_Error_calculating_the_groups=Summarize\: Error calculating the groups

Summarize_Error_saving_the_output_DBF_file=Summarize\: Error saving the output DBF

Summarize_Field_does_not_exist=Summarize\: Field does not exist

Summarize_Group_by_field_does_not_exist=Summarize\: Group by field does not exist

Summarize_Table_has_no_fields=Summarize Error\: Selected table has no fields

SummarizeForm_columna_average=Mean

SummarizeForm_columna_id=Field

SummarizeForm_columna_maximum=Maximum

SummarizeForm_columna_minimum=Minimum

SummarizeForm_columna_sd=Std. Deviation

SummarizeForm_columna_sum=Sum

SummarizeForm_columna_variance=Variance

SummarizeForm_fichero_destino=Please, choose the target file

SummarizeForm_seleccionar_operaciones=Please, choose some operations to calculate

table_summarize=Table Summarize

title_summarize=Table Summarize

Unknown_summarize_error=Unknown summarize error

VAR=VAR

Warning_Output_File=Warning\: Output File

#Translations for language [gl]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Ferramentas

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

	<depends plugin-name="com.iver.cit.gvsig"/>

	<libraries library-dir="."/>

	<resourceBundle name="text"/>

	<extensions>

		<extension class-name="org.gvsig.app.documents.table.summarize.TableSummarizeExtension"

			description="M?dulo para el c?lculo de estadisticas sobre tablas DBF." 

			active="true" 

			priority="1">

			<tool-bar name="Herramientas" position="12">

				<action-tool icon="tableSummarize-statistics" tooltip="table_summarize" position="9"/>

			</tool-bar>

		</extension>

	</extensions>		

</plugin-config>

#Translations for language [cs]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=N\u00e1stroje

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [pt_br]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=Aceitar

btn_SummarizeForm_cancelar=Cancelar

Choose_target_file_DBF=Escolher arquivo de destino (no formato .DBF)

COUNT=QUANTIDADE

DBF_files=Arquivo DBF

Error_creating_new_table=Erro na cria\u00e7\u00e3o da nova tabela.

Error_summarizing_table=Erro no resumo da tabela

File_exists_Do_you_want_to_overwrite_it?=

GROUP=GRUPO

Herramientas=Ferramentas

lbl_SummarizeForm_descripcion1=<html> S\u00edntese\: Cria uma nova tabela que cont\u00e9m um registro para cada valor do campo selecionado, bem como das estat\u00edsticas de outros campos. </ html>

lbl_SummarizeForm_punto1=1. Seleciona o campo pelo qual se agrupar\u00e1\:

lbl_SummarizeForm_punto2=2. Selecione uma ou mais estatisticas para ser incluidas na tabela de resultados\:

lbl_SummarizeForm_punto3=3. Especif\u00edque o arquivo de destino\:

MAX=MAX

MEAN=M\u00c9DIA

MIN=MIN

Not_possible_generate_unique_field_name=N\u00e3o \u00e9 poss\u00edvel gerar um nome de campo \u00fanico

STDEV=DT

SUM=Soma

Summarize_Error_accessing_the_table=Resumo da tabela\: Erro acessando a tabela

Summarize_Error_calculating_the_groups=Resumo de tabela\: Erro calculando os grupos

Summarize_Error_saving_the_output_DBF_file=Resumo de tabela\: Erro salvando o DBF de sa\u00edda.

Summarize_Field_does_not_exist=Resumo de tabela\: O campo n\u00e3o existe

Summarize_Group_by_field_does_not_exist=Resumo da tebale\: O campo para agrupar n\u00e3o existe

Summarize_Table_has_no_fields=Erro\: A tabela a resumir n\u00e3o cont\u00e9m campos

SummarizeForm_columna_average=M\u00e9dia

SummarizeForm_columna_id=Coluna

SummarizeForm_columna_maximum=M\u00e1ximo

SummarizeForm_columna_minimum=M\u00ednimo

SummarizeForm_columna_sd=Desvio t\u00edpico

SummarizeForm_columna_sum=Soma

SummarizeForm_columna_variance=Vari\u00e2ncia

SummarizeForm_fichero_destino=Defina um arquivo destino antes de realizar as opera\u00e7\u00f5es.

SummarizeForm_seleccionar_operaciones=Deve escolher as opera\u00e7\u00f5es a realizar antes de tentar executa-las.

table_summarize=Resumo das tabelas

title_summarize=Resumo de tabelas

Unknown_summarize_error=Resumo da tabela\: Erro desconhecido

VAR=VAR

Warning_Output_File=Aviso\: Arquivo de sa\u00edda

#Translations for language [fr]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Outils

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [en_us]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=OK

btn_SummarizeForm_cancelar=Cancel

Choose_target_file_DBF=Choose target file (.DBF)

COUNT=COUNT

DBF_files=DBF files

Error_creating_new_table=Error creating the new table

Error_summarizing_table=Error_summarizing_table

File_exists_Do_you_want_to_overwrite_it?=

GROUP=GROUP

Herramientas=Tools

lbl_SummarizeForm_descripcion1=<html>Summarize Table\: creates a new table which contains a register for each unique value from the groupBy field, plus the selected statistics from the rest of the fields.</html>

lbl_SummarizeForm_punto1=1. Choose the groupBy field\:

lbl_SummarizeForm_punto2=2. Choose one or more statistics to be included in the result table\:

lbl_SummarizeForm_punto3=3. Choose the target file\:

MAX=MAX

MEAN=MEAN

MIN=MIN

Not_possible_generate_unique_field_name=It is not possible to generate a unique field name

STDEV=STDEV

SUM=SUM

Summarize_Error_accessing_the_table=Summarize\: Error accessing the table

Summarize_Error_calculating_the_groups=Summarize\: Error calculating the groups

Summarize_Error_saving_the_output_DBF_file=Summarize\: Error saving the output DBF

Summarize_Field_does_not_exist=Summarize\: Field does not exist

Summarize_Group_by_field_does_not_exist=Summarize\: Group by field does not exist

Summarize_Table_has_no_fields=Summarize Error\: Selected table has no fields

SummarizeForm_columna_average=Mean

SummarizeForm_columna_id=Field

SummarizeForm_columna_maximum=Maximum

SummarizeForm_columna_minimum=Minimum

SummarizeForm_columna_sd=Std. Deviation

SummarizeForm_columna_sum=Sum

SummarizeForm_columna_variance=Variance

SummarizeForm_fichero_destino=Please, choose the target file

SummarizeForm_seleccionar_operaciones=Please, choose some operations to calculate

table_summarize=Table Summarize

title_summarize=Table Summarize

Unknown_summarize_error=Unknown summarize error

VAR=VAR

Warning_Output_File=Warning\: Output File

#Translations for language [eu]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Tresnak

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [nl]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [pl]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [it]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Strumenti

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [ro]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [es]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=Aceptar

btn_SummarizeForm_cancelar=Cancelar

Choose_target_file_DBF=Escoja fichero destino (en formato .DBF)

COUNT=CANTIDAD

Data_source_not_initialized=Fuente de datos no inicializada

DBF_files=Ficheros DBF

Error_creating_new_table=Error creando la nueva tabla

Error_summarizing_table=Error en el resumen de tabla

File_exists_Do_you_want_to_overwrite_it=El fichero ya existe. \u00bfDesea sobreescribirlo?

File_exists_Do_you_want_to_overwrite_it?=

GROUP=GRUPO

GroupByField_not_initialized=Campo de agrupaci\u00f3n no inicializado

Herramientas=Herramientas

lbl_SummarizeForm_descripcion1=<html>Resumen de Tabla\: Crea una nueva tabla que contiene un registro\n por cada valor \u00fanico del campo seleccionado, adem\u00e1s de las estad\u00edsticas del resto de campos.</html>

lbl_SummarizeForm_punto1=1. Selecciona el campo por el que se agrupar\u00e1\:

lbl_SummarizeForm_punto2=2. Selecciona una o m\u00e1s estad\u00edsticas\n para ser incluidas en la tabla de resultados\:

lbl_SummarizeForm_punto3=3. Especificar fichero de destino\:

MAX=MAX

MEAN=MED

MIN=MIN

Not_possible_generate_unique_field_name=No es posible generar un nombre de campo \u00fanico

Operation_not_initialized=Operaci\u00f3n no inicializada

STDEV=DT

SUM=SUM

Summarize_Error_accessing_the_table=Resumen de tabla\: Error accediendo a la tabla

Summarize_Error_calculating_the_groups=Resumen de tabla\: Error calculando los grupos

Summarize_Error_saving_the_output_DBF_file=Resumen de tabla\: Error guardando el DBF de salida

Summarize_Field_does_not_exist=Resumen de tabla\: El campo no existe

Summarize_Group_by_field_does_not_exist=Resumen de tabla\: El campo para agrupar no existe

Summarize_Table_has_no_fields=Error\: La tabla a resumir no contiene campos

SummarizeForm_columna_average=Media

SummarizeForm_columna_id=Columna

SummarizeForm_columna_maximum=M\u00e1ximo

SummarizeForm_columna_minimum=M\u00ednimo

SummarizeForm_columna_sd=Desv. T\u00edpica

SummarizeForm_columna_sum=Suma

SummarizeForm_columna_variance=Varianza

SummarizeForm_fichero_destino=Por favor, debes escoger un fichero destino antes de realizar las operaciones.

SummarizeForm_seleccionar_operaciones=Por favor, debes escoger las operaciones a realizar antes de intentar ejecutarlas.

table_summarize=Resumen de tablas

title_summarize=Resumen de tablas

Unknown_summarize_error=Resumen de tabla\: Error desconocido

VAR=VAR

Warning_Output_File=Aviso\: Fichero de Salida

#Translations for language [zh]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [ca]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Ferramentes

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [pt]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Ferramentas

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [sr]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Translations for language [de]

#Fri Jul 10 12:48:51 CEST 2009

btn_SummarizeForm_aceptar=Akzeptieren

btn_SummarizeForm_cancelar=Abbrechen

Choose_target_file_DBF=Zieldatei w\u00e4hlen (.DBF)

COUNT=MENGE

DBF_files=DBF- Dateien

Error_creating_new_table=Fehler beim Erzeugen der neuen Tabelle

Error_summarizing_table=Fehler bei "Summarize Table"

File_exists_Do_you_want_to_overwrite_it?=

GROUP=GROUP

Herramientas=Werkzeuge

lbl_SummarizeForm_descripcion1=<html>Summarize Tabelle\: erzeugt eine neue Tabelle, die je einen Eintrag eines eindeutigen Wertes des Feldes "group by" enth\u00e4lt. Ausserdem erh\u00e4lt Sie die Statistiken der anderen gew\u00e4hlten Felder. </html>

lbl_SummarizeForm_punto1=1. W\u00e4hlen Sie das Feld f\u00fcr die Gruppierung aus\:

lbl_SummarizeForm_punto2=2. W\u00e4hlen Sie eine oder mehrere Statistiken aus, die in der \nErgebnis-Tabelle ausgegeben werden sollen\:

lbl_SummarizeForm_punto3=3. W\u00e4hlen Sie die Ziel-Datei aus\: 

MAX=MAX

MEAN=MEAN

MIN=MIN

Not_possible_generate_unique_field_name=Nicht m\u00f6glich, einen eindeutigen Feldnamen zu vergeben

STDEV=STABW

SUM=SUM

Summarize_Error_accessing_the_table=Summarize\: Fehler beim Verbinden mit der Tabelle

Summarize_Error_calculating_the_groups=Summarize\: Fehler bei der Gruppierung

Summarize_Error_saving_the_output_DBF_file=Summarize\: Fehler beim Speichern der Ausgabe-Datei im Format DBF

Summarize_Field_does_not_exist=Summarize\: Feld existiert nicht

Summarize_Group_by_field_does_not_exist=Summarize\: Gruppierung durch Feld existiert nicht

Summarize_Table_has_no_fields=Fehler in Summarize\: Gew\u00e4hlte Tabelle hat keine Felder

SummarizeForm_columna_average=Mean

SummarizeForm_columna_id=Feld

SummarizeForm_columna_maximum=Maximum

SummarizeForm_columna_minimum=Minimum

SummarizeForm_columna_sd=Standard- Abweichung

SummarizeForm_columna_sum=Summe

SummarizeForm_columna_variance=Varianz

SummarizeForm_fichero_destino=Bitte w\u00e4hlen Sie die Ziel-Datei

SummarizeForm_seleccionar_operaciones=Bitten w\u00e4hlen Sie Optionen f\u00fcr die Berechnung

table_summarize=Summarize Tabelle

title_summarize=Summarize

Unknown_summarize_error=Unbekannter Fehler in Summarize

VAR=VAR

Warning_Output_File=Warnung\: Ausgabe- Datei

#Translations for language [sw]

#Fri Jul 10 12:48:52 CEST 2009

btn_SummarizeForm_aceptar=

btn_SummarizeForm_cancelar=

Choose_target_file_DBF=

COUNT=

DBF_files=

Error_creating_new_table=

Error_summarizing_table=

File_exists_Do_you_want_to_overwrite_it?=

GROUP=

Herramientas=Zana

lbl_SummarizeForm_descripcion1=

lbl_SummarizeForm_punto1=

lbl_SummarizeForm_punto2=

lbl_SummarizeForm_punto3=

MAX=

MEAN=

MIN=

Not_possible_generate_unique_field_name=

STDEV=

SUM=

Summarize_Error_accessing_the_table=

Summarize_Error_calculating_the_groups=

Summarize_Error_saving_the_output_DBF_file=

Summarize_Field_does_not_exist=

Summarize_Group_by_field_does_not_exist=

Summarize_Table_has_no_fields=

SummarizeForm_columna_average=

SummarizeForm_columna_id=

SummarizeForm_columna_maximum=

SummarizeForm_columna_minimum=

SummarizeForm_columna_sd=

SummarizeForm_columna_sum=

SummarizeForm_columna_variance=

SummarizeForm_fichero_destino=

SummarizeForm_seleccionar_operaciones=

table_summarize=

title_summarize=

Unknown_summarize_error=

VAR=

Warning_Output_File=

#Build Number for ANT. Do not edit!

#Wed Jul 22 11:57:01 GMT+01:00 2009

build.number=1241

/* gvSIG. Sistema de Informacion Geografica de la Generalitat Valenciana

 *

 * Copyright (C) 2009 IVER T.I.

 *

 * 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., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *  IVER T.I.

 *   C/ Lerida, 20

 *   46009 Valencia

 *   SPAIN

 *   http://www.iver.es

 *   dac@iver.es

 *   +34 963163400

 *   

 *  or

 *  

 *  Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Iba?ez, 50

 *   46010 VALENCIA

 *   SPAIN

 */

package org.gvsig.app.documents.table.summarize;

import java.io.File;

import java.io.IOException;

import java.math.BigDecimal;

import java.sql.Types;

import java.util.ArrayList;

import org.apache.log4j.Logger;

import org.gvsig.app.documents.table.summarize.exceptions.DBFExportException;

import org.gvsig.app.documents.table.summarize.exceptions.GroupByFieldNotExistsException;

import org.gvsig.app.documents.table.summarize.exceptions.GroupingErrorException;

import org.gvsig.app.documents.table.summarize.exceptions.InitializationException;

import org.gvsig.app.documents.table.summarize.exceptions.SummarizeException;

import org.gvsig.app.documents.table.summarize.utils.IntList;

import org.gvsig.app.documents.table.summarize.utils.SelectedStatistics;

import com.hardcode.driverManager.DriverLoadException;

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

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

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

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

import com.hardcode.gdbms.engine.data.driver.FileDriver;

import com.hardcode.gdbms.engine.instruction.EvaluationException;

import com.hardcode.gdbms.engine.instruction.SemanticException;

import com.hardcode.gdbms.engine.values.Value;

import com.hardcode.gdbms.engine.values.ValueFactory;

import com.hardcode.gdbms.parser.ParseException;

import com.iver.andami.PluginServices;

import com.iver.cit.gvsig.exceptions.visitors.StartWriterVisitorException;

import com.iver.cit.gvsig.exceptions.visitors.StopWriterVisitorException;

import com.iver.cit.gvsig.exceptions.visitors.VisitorException;

import com.iver.cit.gvsig.fmap.core.DefaultFeature;

import com.iver.cit.gvsig.fmap.core.IFeature;

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

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

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

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

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

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

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

import com.iver.cit.gvsig.fmap.selection.SelectionFieldIterator;

import com.iver.cit.gvsig.project.documents.table.Statistics.NonNumericFieldException;

/**

 * Summarizes a table. 

 * 

 * @author IVER T.I. <http://www.iver.es> 01/02/2009

 */

public class Summarize {

	private SelectableDataSource sds;

	private static Logger logger = Logger.getLogger(Summarize.class.getName());

	private ArrayList<SelectedStatistics> operations;

	private String groupByField;

	public Summarize() {

	}

	public Summarize(SelectableDataSource ds) {

		this.sds = ds;

	}

	public void summarizeToWriter(IWriter writer)

	throws InitializationException, GroupByFieldNotExistsException, SummarizeException, DBFExportException, GroupingErrorException {

		if (operations==null) {

			throw new InitializationException("Operation not initialized");

		}

		if (sds==null) {

			throw new InitializationException("Data source not initialized");

		}

		if (groupByField==null) {

			throw new InitializationException("GroupByField not initialized");

		}

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

		IntList outputTypeList = new IntList();

		try {

			createFieldsAndTypes(operations, outputFieldNames, outputTypeList);

			summarizeToWriter(writer, outputFieldNames.toArray(new String[0]), outputTypeList.toArray());

		} catch (ReadDriverException e) {

			throw new SummarizeException(e);

		}

	}

	public void summarizeToDbf(File dbfFile) 

		throws InitializationException, GroupByFieldNotExistsException, SummarizeException, DBFExportException, GroupingErrorException {

		if (operations==null) {

			throw new InitializationException("Operation not initialized");

		}

		if (sds==null) {

			throw new InitializationException("Data source not initialized");

		}

		if (groupByField==null) {

			throw new InitializationException("GroupByField not initialized");

		}

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

		IntList outputTypeList = new IntList();

		try {

			createFieldsAndTypes(operations, outputFieldNames, outputTypeList);

			IWriter writer = createDbfFile(dbfFile, outputFieldNames.toArray(new String[0]), outputTypeList.toArray());

			summarizeToWriter(writer, outputFieldNames.toArray(new String[0]), outputTypeList.toArray());

		} catch (ReadDriverException e) {

			throw new SummarizeException(e);

		}

	}

	protected void summarizeToWriter(IWriter writer, String[] outputFieldNames, int[] fieldTypes)

	throws SummarizeException, DBFExportException, 

	GroupingErrorException{

		try {

			initWriter(writer);

			calculateStats(getOperations(), groupByField, outputFieldNames, writer);

			finishWriter(writer);

		} catch (NonNumericFieldException e) {

			SummarizeException ex = new SummarizeException(e);

			throw ex;

		}

	}

	protected void createFieldsAndTypes(ArrayList<SelectedStatistics> operations,

			ArrayList<String> outputFieldNames,

			IntList fieldTypes) throws ReadDriverException, GroupByFieldNotExistsException, SummarizeException {

		//fixed columns

		int groupByFieldIdx;

		groupByFieldIdx = sds.getFieldIndexByName(groupByField);

		if (groupByFieldIdx==-1) {

			throw new GroupByFieldNotExistsException();

		}

		int maxlength = 10;

		String groupByName = createUniqueFieldName(outputFieldNames, "", PluginServices.getText(this, "GROUP"), maxlength);

		outputFieldNames.add(groupByName);

		fieldTypes.add(sds.getFieldType(groupByFieldIdx));

		String countName = createUniqueFieldName(outputFieldNames, "", PluginServices.getText(this, "COUNT"), maxlength);

		outputFieldNames.add(countName);

		fieldTypes.add(Types.INTEGER);

		for(int i=0; i<operations.size(); i++){				

			String currentFieldName = operations.get(i).getColumnName();

			int currFieldType = operations.get(i).getColumnType();

			if(operations.get(i).isMin()){

				String newField = createUniqueFieldName(outputFieldNames, currentFieldName, "_"+PluginServices.getText(this, "MIN"), maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(currFieldType);

			}

			if(operations.get(i).isMax()){

				String newField = createUniqueFieldName(outputFieldNames, currentFieldName, "_"+PluginServices.getText(this, "MAX"), maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(currFieldType);

			}

			if(operations.get(i).isMean()){

				String newField = createUniqueFieldName(outputFieldNames, currentFieldName, "_"+PluginServices.getText(this, "MEAN"), maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(Types.DOUBLE);

			}

			if(operations.get(i).isSum()){

				String newField = createUniqueFieldName(outputFieldNames, currentFieldName, "_"+PluginServices.getText(this, "SUM"), maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(currFieldType);

			}

			if(operations.get(i).isSd()){

				String newField = createUniqueFieldName(outputFieldNames,

						currentFieldName,

						"_"+PluginServices.getText(this, "STDEV"),

						maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(Types.DOUBLE);

			}

			if(operations.get(i).isVar()){

				String newField = createUniqueFieldName(outputFieldNames,

						currentFieldName,

						"_"+PluginServices.getText(this, "VAR"),

						maxlength);

				outputFieldNames.add(newField);

				fieldTypes.add(Types.DOUBLE);

			}

		}

	}

	/**

	 * <p>Creates a new field name (not contained in the existingFields list),

	 * based in the provided baseName and suffix and with the provided maximum

	 * length.

	 * The following pattern is used to create the new names:<p>

	 * <pre>(baseName)(index)*(suffix)</pre>

	 * <p>Examples of created names:</p>

	 * <pre>baseName: "TERRAIN", suffix: "_MAX", maxLength: 11

	 * existingFields: {"TERRAIN_MAX"}

	 * created fields: "TERRAI0_MAX", "TERRAI1_MAX", "TERRAI2_MAX", ..., "TERRA00_MAX", "TERRA01_MAX", etc.

	 * </pre>

	 * 

	 * @param existingFields

	 * @param baseName

	 * @param sufix

	 * @return

	 * @throws SummarizeException 

	 */

	public String createUniqueFieldName(ArrayList<String> existingFields,

			String baseName,

			String suffix,

			int maxLength) throws SummarizeException{

		// ensure we don't try to take a substring longer than baseName.length

		int auxLength = Math.min(maxLength-suffix.length(),

						baseName.length());

		String result = baseName.substring(0, auxLength) + suffix;

		if (!existingFields.contains(result)) {

			return result;

		}

		//ensure the index length is not longer than the maximum allowed field length

		long maxIndex = (long) Math.pow(10, maxLength-suffix.length());

		int index = 0;