ichivite-esristaff

Understanding ArcGIS QuickCapture Data Recovery Files

Blog Post created by ichivite-esristaff Employee on Jul 14, 2019

The ArcGIS QuickCapture mobile app features a handy data recovery workflow that will help you get data from devices easily. Whenever data fails to upload to ArcGIS, the app will bring a dialog so the end user can e-mail that data to the owner of the ArcGIS QuickCapture project. All data is encapsulated in a qcr (QuickCapture recovery) file, which gets attached to the e-mail. You can open qcr files within ArcGIS Pro, or manually, to inspect its contents and learn the reasons for the failure.

 

QuickCapture data recovery files: The Basics


ArcGIS QuickCapture data recovery files are created by the ArcGIS QuickCapture

mobile app when records repeatedly fail to upload to ArcGIS. This could be caused for different reasons. For example, when the target feature layer no longer exists, or can no longer be edited by the logged-in user, when the schema of the data captured does not match the schema in the feature layer or when a geometry is not well-formed.

 

When records fail to upload, the end user of the ArcGIS QuickCapture mobile app is presented a dialog that can be used to send all these records via e-mail. The e-mail message will include an ArcGIS QuickCapture data recovery file attached, which then can be open and inspected.

 

The email recipient for the ArcGIS QuickCapture data recovery files is set by the QuickCapture project itself. By default, it is the e-mail associated with the ArcGIS account used to originally create the QuickCapture project, but it can be changed by the owner of the project.

 

Opening ArcGIS QuickCapture data recovery files from ArcGIS Pro

 

You can open qcr files directly with ArcGIS Pro 2.4 (or newer)  using a custom ArcGIS Pro add-in. To install the add-in follow these steps:

 

You need ArcGIS Pro 2.4 for the ArcGIS QuickCapture add-in to work.

 

  1. Close ArcGIS Pro.
  2. Download the add-in files from: https://www.arcgis.com/home/item.html?id=d4ae594515d848baa5c567087ea42b8e
  3. The file above is a ZIP file. Extract the contents of the file in your computer.
  4. Double click the two files (the order does not really matter).
  5. Open ArcGIS Pro.

 

Once the ArcGIS QuickCapture add-in is installed you can preview data recovery files as follows:

 

  • Copy the qcr file in your computer.
  • Open ArcGIS Pro and add a new Folder Connection to the directory where you stored the qcr file.

 

  • You will see your qcr file in the catalog pane. Expand its contents. The file will contain one table for every layer where records failed to upload. Add one or more tables to the map as shown in the screenshot below.

  • The records will be shown in your map. You can inspect all records through the table and popups.

  • The ErrorMessage field contains information about the reason why the record failed to upload.
  • You can use Append tool to add these records into an existing feature layer or feature class.

 

This ArcGIS Pro add-in is provided as-is for your convenience to explore qcr files, but it is not supported by Esri Technical Support.  You can post any issues you find with this add-in here in this GeoNet place.

 

Opening ArcGIS QuickCapture data recovery files manually

 

You can also inspect the data recovery files manually, without ArcGIS Pro. ArcGIS QuickCapture data recovery files are zip files.  If you change the extension from qcr to zip, you will be able to extract their contents and inspect them more closely.

 

When the contents of a qcr file are extracted you will find the following:

 

  • Errors.sqlite  This is a SQLite database containing all records (except the attachments) and error messages.
  • LayerInfos   This directory contains the JSON definition of the layers on which records failed to upload.
  • Attachments  This directory is only present if your data contains attachments. You will find photos in this folder.

 

The Errors.sqllte database can be opened by any tool that can handle SQLite databases. I like to use DB Browser for SQLite.  The most important table within the database is called Features.  This table includes as many rows as records failed to upload. You will find in this table a field called ErrorMessage, which contains the error description returned from the server. This information will help you diagnose the problem.  The field ItemId and LayerURL include information relative to the target layer where the records failed to upload. The Feature field contains the actual data that the QuickCapture mobile app attempted to upload to the ArcGIS feature layer.  The FeatureID column is used to link records with attachments, in case that they exist.

 

 

Configuring the data recovery e-mail in your ArcGIS QuickCapture projects

 

The default e-mail recipient used by the ArcGIS QuickCapture mobile app to send data recovery files is set in the QuickCapture project itself. You can define this e-mail when authoring the QuickCapture project as shown in the screenshot below. By default, the QuickCapture feature layer import process will get the e-mail associated with the logged-in account used to author the project, but you can set any e-mail you want.

 

 

The data recovery email can also be changed at any time by the owner of the QuickCapture project through the JSON editor in QuickCapture designer.

Outcomes