idea Survey123 - Improve performance on querying external sources in ArcGIS Survey123 Ideas https://community.esri.com/t5/arcgis-survey123-ideas/survey123-improve-performance-on-querying-external/idi-p/936825 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 15px;">To select a choice referencing a csv file, you are&nbsp;have&nbsp;to copy some fields in your survey datasheet (choices or external_choices). </SPAN></P><P></P><P><SPAN style="font-size: 15px;">Would it be&nbsp;possible to use an external reference file (e.g.: sqlite, other) to populate a select list and make it fast ? (ref.&nbsp;<A _jive_internal="true" href="https://community.esri.com/ideas/16568-use-pulldata-feature-to-populate-selectone-choices">https://community.esri.com/ideas/16568-use-pulldata-feature-to-populate-selectone-choices</A>&nbsp;- only with a better perfoming technical solution than CSV files)</SPAN></P><P><SPAN style="font-size: 15px;">Today I don't see how to use a huge reference list (e.g. 100k + lines floristic or faunistic data) in a Survey123 form. Our tests using choices/external choices result in ~8 to10&nbsp;second survey&nbsp; loading time for 4000 lines only(!).</SPAN></P><P><SPAN style="font-size: 15px;">Many thanks!</SPAN></P></BODY></HTML> Wed, 21 Aug 2019 09:35:55 GMT ClémentLaskar 2019-08-21T09:35:55Z Survey123 - Improve performance on querying external sources https://community.esri.com/t5/arcgis-survey123-ideas/survey123-improve-performance-on-querying-external/idi-p/936825 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 15px;">To select a choice referencing a csv file, you are&nbsp;have&nbsp;to copy some fields in your survey datasheet (choices or external_choices). </SPAN></P><P></P><P><SPAN style="font-size: 15px;">Would it be&nbsp;possible to use an external reference file (e.g.: sqlite, other) to populate a select list and make it fast ? (ref.&nbsp;<A _jive_internal="true" href="https://community.esri.com/ideas/16568-use-pulldata-feature-to-populate-selectone-choices">https://community.esri.com/ideas/16568-use-pulldata-feature-to-populate-selectone-choices</A>&nbsp;- only with a better perfoming technical solution than CSV files)</SPAN></P><P><SPAN style="font-size: 15px;">Today I don't see how to use a huge reference list (e.g. 100k + lines floristic or faunistic data) in a Survey123 form. Our tests using choices/external choices result in ~8 to10&nbsp;second survey&nbsp; loading time for 4000 lines only(!).</SPAN></P><P><SPAN style="font-size: 15px;">Many thanks!</SPAN></P></BODY></HTML> Wed, 21 Aug 2019 09:35:55 GMT https://community.esri.com/t5/arcgis-survey123-ideas/survey123-improve-performance-on-querying-external/idi-p/936825 ClémentLaskar 2019-08-21T09:35:55Z