This export type exports feature and observation data of a set of features of the specified feature type. It supports Microsoft Excel 2007/2010 (xlsx) and tabular structured text files as output formats. When using xlsx as output format this export type can also write to template files.
When executing an export of this type the the Application Server will automatically add the file extension .xlsx to the export file if the Output file type setting is set to Excel (2007/2010) and if the expanded file name template does not have the extension .xlsx. If no extension was specified in the File name template setting and Output file type is set to Tabular text the extension .csv , .tsv or .txt (depending on the selected separator) will be automatically added to the file name.
This export type produces simple two dimensional tables, i.e. one row for each exported observation. If the type specific observation data is a hierarchical property structure this export type can optionally flatten the property structure for a selected collection of the type specific data.
Type specific settings (1)
Table 1 explains the settings available under Type specific settings (1) for this export type.
Setting |
Notes |
Feature type |
Mandatory. Defines the feature type for this export. Only data of features of this type will be exported. |
One file per feature |
If set, the Application Server will create a separate export file for each feature. |
Output file type |
Specification of the file format that will be generated. •Tabular text: Output will be a tabular structured text file. •Excel (2007/2010): Output will be in Microsoft Excel (version 2007 / 2010) format. |
Column separator |
Only applicable if output file type Settings for Tabular text format is selected. Specifies Column separator that will be used output files. |
Null value |
The string that will be written to the output file when exporting null values. |
True value |
Only applicable if output file type Settings for Tabular text format is selected. The string that will be written to the output file for logical True. |
False value |
Only applicable if output file type Settings for Tabular text format is selected. The string that will be written to the output file for logical False. |
Classification elements output |
Defines how classification values will be written to the output files: •Name only: Only the name of the classification element will be written in the output file. •Code only: Only the code of the classification element will be written in the output file. •Name and code: Name and code of the classification element will be written to the output file. |
Table 1: General group of the Type specific settings (1) UConfiguration for this export type
The group Feature data in Type specific settings (1) defines what feature data will be exported. Table 2 describes each setting in this group.
Setting |
Notes |
Feature name |
If set the feature name will be written to the output file. |
Approval status |
If set the feature approval status will be written to the output file. |
Export top level properties |
If set the values of the feature-types top level properties will be written to the output file. |
Top level properties |
Only applicable if Export top level properties is set Defines which top level properties of the feature's type specific data shall be exported. |
Export feature attachments |
If set the attachments to the feature will be exported. In this the attachments will be copied and placed to the output location of the export. The file names of the attachments will be written to the tabular export file. |
Attachment filter type |
This setting can be used to filter the attachments to be exported. •No filter: All attachments will be exported •Tag filter: Filter by attachment tag •Name filter: Filter by attachment name |
Tag |
Only applicable if Attachment filter type is set to Tag filter. Sets the tag that is used for filtering attachments. Only attachments with this tag set will be exported. |
File name filter |
Only applicable if Attachment filter type is set to Name filter. This is a regular expression that is used for filtering attachments by their original file name. |
Include features without observations |
If set also features that do not have any observations will be exported. |
Table 2: Feature data group of the Type specific settings (1) UConfiguration for this export type
The group Observation data in Type specific settings (1) defines what observation data will be exported. Table 2 describes each setting in this group.
Setting |
Notes |
Sampling timestamp |
If set the sampling time stamp of observations will be written to the output file. |
Approval status |
If set the approval status of observations will be written to the output file |
Erroneous state |
If set the erroneous status of observations will be written to the output file |
Observation sensor |
If set the name of the sensor used for recording this observation observations will be written to the output file |
Export top-level properties |
If set top level properties selected in the Top level properties setting will be exported. |
Top level properties |
Only applicable if setting Export top-level properties is set. The top level properties to be exported. |
Export collection properties |
Only applicable if setting Export top-level properties is set. If set the properties of a single collection in the feature types type specific observation data will be exported. |
Latest comment |
If set the latest comment stored with the observation will be written to the export file. |
Export observation attachments |
If set the attachments to observations will be exported. In this the attachments will be copied and placed to the output location of the export. The file names of the attachments will be written to the tabular export file. |
Attachment filter type |
This setting can be used to filter the attachments to be exported. •No filter: All attachments will be exported •Tag filter: Filter by attachment tag •Name filter: Filter by attachment name |
Tag |
Only applicable if Attachment filter type is set to Tag filter. Sets the tag that is used for filtering attachments. Only attachments with this tag set will be exported. |
File name filter |
Only applicable if Attachment filter type is set to Name filter. This is a regular expression that is used for filtering attachments by their original file name. |
Table 2: Observation data group of the Type specific settings (1) UConfiguration for this export type
The group Spatial location in Type specific settings (1) defines if spatial data is exported and in which spatial system and reference system the data shall be exported. Redbex will apply the necessary transformations of spatial data on export.
Setting |
Notes |
Spatial sytem |
Defines the spatial system type for the export. •No spatial location: No spatial data will be written to the output •Axis: Spatial data will be transformed to the selected axis reference system and will be written to the output file. •Coordinate system: Spatial data will be transformed to the selected coordinate system and will be written to the output file. |
Type specific settings (2)
Here you can specify the features to be exported and an export file template (only applicable if you selected Excel as the Output file type.
Features to be exported can either be specified directly or indirectly via views or container features. Generally only features that match the feature type defined in Type specific settings (1) will be exported. Container features that are not of the selected feature type will be expanded automatically, i.e. all contained features that match the selected feature type will be exported. When using Views all member features of the view that match the feature type defined in Type specific settings (1) will be exported.
When using Excel as Output file type the export template file can be specified. If no export template file is given the export will write data to a new (blank) excel file on whenever it is run. If a template file is given the export will make a copy of this template and will write to that copy. I.e. you can prepare an excel file with your custom formulas, charts etc. and the export will just write new data to that file every time it is executed.
When a template file is used the export will write data to the first non-protected sheet in the excel file (starting with cell A1).
Observation filter
This export type provides the possibility to use an observation filter in order to limit the number of observations to be exported.
Additional Information about Excel files
Excel has limited support for date time values and for formatting date time values. Date time offset values will therefore be be converted to date time values when writing to excel files. Date time values will be written to Excel files in the format yyyy-MM-dd hh:mm:ss .
Boolean values will be exported as numeric 1 for True and numeric 0 for false.
