ERROR

Initialing Form... Failed to load data from (data source)

Last Published: May 11, 2022

Error Message

Using the pulldata() function to obtain data from a CSV file for a geopoint question loads successfully in ArcGIS Survey123 Connect. However, the following error is returned in the ArcGIS Survey123 web form:

Error:   
Initialing Form... Failed to load data from (data source)

Cause

The latitude and longitude columns in the CSV are not formatted correctly. The pulldata() function can only calculate the location data if the latitude and longitude data are in separate columns.

Solution or Workaround

To resolve this error when using existing data to create the survey, use the correct formatting method as described below.

Note:
Before creating a new survey, it is best practice to determine the correct formatting for the data.
  1. Sign in to ArcGIS Survey123 Connect and create a new survey, or open an existing survey form.
  2. In the survey form, create a calculate question for the latitude. Type lat in the name column and set the label. Use the following pulldata() function for the latitude in the calculation column:
pulldata('Intersections', 'Lat', 'IntersectionID', ${intersection})
Calculate question for latitude
  1. Create another calculate question for the longitude. Type lon in the name column and set the label. Use the following pulldata() function for the latitude in the calculation column:
pulldata('Intersections', 'Long', 'IntersectionID', ${intersection})
Calculate question for longitude
  1. Create a calculate question to concatenate the latitude and longitude. Assign a name and label in the name and label columns, respectively. Use the following pulldata() function:
concat(number(${lat}),' ', number(${lon}))
Concatenation
  1. Create a geopoint question for the location and assign a name and label.
  2. In the calculation column, use the pulldata() function with the name assigned for the concatenation of the calculate question in Step 4. Following this workflow, type location_calc in the pulldata() function.
${name assigned in the calculate question for concatenation}
Geopoint question

Article ID:000020774

Software:
  • ArcGIS Survey123 Connect
  • ArcGIS Survey123 Website

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options