Exporting Tables to DBF and Excel
The application allows tables (whether layer attribute tables or separate alphanumeric tables ) to be exported in two formats:
Follow these steps to export a table:
A. Select the table:
To export a table it must first be opened. The export operations are activated once the table is opened.
To export a subset of the records use the selection tools to select the records to be exported. The records can be selected either from the attribute table or by selecting the corresponding geometries in the View.
B. Select the export option
To do this select the menu option:
For Excel: Table/Export/Excel.
For Dbase: Table/Export/DBF.
C. Enter the file name
Locate the directory where you want to create the file and type a name for the file. If the file already exists the application will ask for confirmation to overwrite it.
In gvSIG, the Add geometric info tool is available when there are visible vector layers in the active View.
Icon | Description |
---|---|
Add geometric info tool enabled if there are visible vector layers in the current view. | |
Add geometric info tool disabled if there are no visible vector layers in the current view. |
With this tool you can select which geometric properties to calculate for a visible vector layer in the current view, and then save these properties in the layer itself. The information can be saved in either new or existing fields in the layer's attribute table.
Once the above condition is met (i.e. a visible vector layer in the active View), the tool is available:
Via the menu: Layer → Add geometric info
Selecting the tool displays a dialog where the attributes to be added can be selected:
1. Drop-down list for selecting vector layers. Lists the layers in the order that they appear in the TOC of the active view. The following information is shown:
2. Layer information writable. Indicates whether changes can be saved to the selected layer:
Icon | Mode |
---|---|
Yes, changes can be saved. In this case the attributes to be added can be selected. | |
No, changes can't be saved. The tool will not list any attributes. |
3. List of geometric attributes. List of attributes of the geometry of the layer. These depend on the type of layer:
The geometric attribute will be associated with one type of geometry, which is identified by the icon on the left:
Icon | Geometry type |
---|---|
The attribute is characteristic of point geometries. | |
The attribute is characteristic of multipoint geometries. | |
The attribute is characteristic of line geometries. | |
The attribute is characteristic of polygon geometries. |
4. Selection buttons. Allow attributes to be added to, or removed from, the list of geometry attributes to be calculated and saved for the vector layer.
Icon | Option |
---|---|
Add all the geometric attributes to the list. | |
Add the selected geometric attributes to the list. | |
Remove the selected geometric attributes from the list. | |
Remove all the geometric attributes from the list. |
5. List of added geometric attributes. List of layer geometry attributes to be calculated and added.
Clicking on any of the attributes in this list enables the controls that allow the field to be renamed.
6. New field. This checkbox indicates whether the attribute is added as a new field, or as an update to an existing field in the vector layer.
By default, every attribute is added as a new field.
7. Field name. New fields can have any name. Otherwise, select a field to update.
The length of the field names is limited.
It is possible that the layer's alphanumeric encoding does not support some characters of the current language.
8. Save field settings. If the checkbox field is changed, or if another field name is specified, the changes can be saved by pressing this button.
9. Reset. Resets the dialog by reloading the current View's visible vector layers, and by removing any selected attributes and their settings.
Once all the attributes have been selected, click the Ok button to start the process and display a progress bar.
Clicking the Cancel button, on the other hand, will terminate the tool.
In the event of a serious problem, the process is terminated and an error message is displayed:
If the process completes successfully, the Accept button is enabled and the tool can be closed.
It is possible to view the steps that were performed by clicking the Show Details button in the dialog:
Do not use the gvSIG interface while the process is in progress as this can produce inconsistent data states, and even errors.
It should be noted that gvSIG currently adds the areas and perimeters of islands to that of the surrounding geometry.
EXAMPLE
Following the steps described in paragraph 5:
Although .dbf files should contain a byte to indicate character encoding, this information is usually not present. gvSIG provides the Shalom tool that sets the encoding and then reads the information in the table using that encoding. If the encoding is not set in this way then gvSIG will read the table data using the default encoding.
It is possible to set the character encoding of a table by selecting Table > Set encoding to .dbf files from the menu bar. Choose the table for which the encoding needs to be set and then select the encoding type (charset). This encoding setting is recorded permanently in the table.
Now the table can be added to the gvSIG project. When gvSIG opens the table the character encoding is read and the characters in the table are correctly displayed.
Note: The correct display of characters depends not only on the encoding setting, but also on the virtual machine that is installed (specifically Java 1.6, which supports more encodings than Java 1.5).
This option can be accessed by opening the Window > Preferences menu and then selecting DBF default encoding.
gvSIG will use the selected encoding as the default when adding a .dbf file to a project, and will also use it when exporting a table that uses a specific encoding.
The export of a table might not be correct if the character encoding is incorrectly configured in the gvSIG preferences.
The tool for joining tables has been improved and now reflects the relationship between the tables once they have been joined. The operation of the tool remains the same in that both tables must contain a common field that will be used to join them together.
It is possible to add a prefix to the source table fields so that they can be easily identified in the joined table, e.g. Table1_FIELD1, Table1_FIELD2, etc. In a similar manner a prefix can also be added to the target table fields: Table2_FIELD1, Table2_FIELD2, etc.
The resulting joined table is given a title made up of the tables participating in the join, e.g. Table1 X Table2 X, or vice versa.
The join between the tables can be removed by selecting 'Remove joins' from the Table menu.
Esta herramienta añade la posibilidad de, una vez se muestran las estadísticas calculadas sobre un campo de la tabla, exportarlas en formato .dbf o .csv. Si sobre la tabla tenemos una selección de registros previamente hecha, las estadísticas se calcularán sólo teniendo en cuenta esos atributos seleccionados.
Para exportar las estadísticas calculadas, presione el botón Exportar. Se abrirá una ventana donde seleccionar la ubicación de la tabla a crear, nombre y formato de salida (.csv o .dbf).
En caso de seleccionar como formato de exportación .csv se mostrará un nuevo panel donde el usuario elegirá el tipo de separador: Punto y coma, Coma, u Otro símbolo, este último determinado por el usuario.
Un mensaje confirma que la exportación se ha realizado con éxito.