This article refers to the options to exporting data using the exporter. When exporting data from the download button in the web app's record viewer, you can use the map's extent, filtering options, and column setup options to limit what is contained in the record viewers' exported data files.
There are several additional settings you can control to select exactly what to export from your Fulcrum account when running an export. You can configure the filter options to limit the data that gets included when exporting, including filtering by geographic area or the date the record was created or updated. You may also choose to export multiple apps and/or projects’ data at once.
Configuring Data Exports
This can be done by selecting the file format, adding date ranges, area filters, and checking the boxes to next to the additional information you want to include, as well as the Apps that should be considered and the projects.
Let's review the Exporting options in detail.
File Format. There are 9 different formats from which to choose:
.csv
.xlsx
.shp
.kml
.geojson
.json
.db
.gpkg
.sql
Data Range. It offers 4 options for date ranges.
Mobile Device Created Time
Mobile Device Updated Time
Server / Sync Created Time
Server / Sync Updated Time
Date Time Zone: This will convert the timestamp information in your export to the specified timezone.
Area Filter: This will allow you to filter records by selecting area of the records you wish to export.
Include Photos: This will export all photos that are contained in any of the records that are being exported. You will also notice an additional file that will contain the photo’s EXIF data.
Include PDF Reports: This will create individual PDF Reports for every record that is going to be included in the export.
This is only available on select plans, please check out our plans page. Only the first 10,000 records will have PDF reports produced. You will need to use the timestamp filters to limit the number of records export PDF reports for all your data.
Include GPS Data: This option will include GPS data captured from the mobile device when the record was created. Additional
gps_columns will be added to the end of the export file.Include Full History: This will include the full record history for every record included in the export file, the version column is used to distinguish between the different records versions.
This is only available on select plans, please check out our plans page to see which plans offer this ability.
Include Changesets Data: This will include a file that contains information on the changesets that took place during the date range, if set. This is only available on select plans, please check out our plans page.
Apps: The export will include the records of all the apps that are checked, you can select multiple apps. The 'toggle all' option at the top will enable all the checkboxes for all the Apps available to include them all.
Projects: You can decide to include or exclude projects. The 'toggle all' option at the top will enable all the checkboxes for the Project to include them all.
Once you have configured your export, you can verify the total of records that are going to be included at top of the Export page.
Click the 'Next' button to proceed once you are done with the export configuration. This will take you to the Export Summary page, where you can check all the configuration details of your export. If you would like to make some changes before exporting, click the 'Back' button. If your export configuration is ok and you want to proceed, click the 'Confirm' button.
As soon as you click the 'Confirm' button, you will be redirected to the Exports History page. At the top of the page there will be a message that says that 'The export has been started and it will be ready soon'. You can confirm this by taking a look at the progress circle. It will continue to spin until the file is ready to be download. When that happens it will display the download icon. Click on it and the download will begin. In your computer's download folder, you will find the file in the format you selected.
This page includes additional information about your export file, in case you need to re-download it, or start a new export if you missed something in the configuration, like selecting a date range or including the photos.
Note: You do not need to stay on the export page while your export finishes. The export is available for download for a period of 7 days after completion.