Latest Contributions by brianvan_druten

‎08-12-2020

Thanks for the reply. We are downloading from the Survey 123 website via Export to Excel option. That is the way we need to do it since I need the ability of non-Pro users to download the data. The data looks fine on the 123 website. The column has no data in it and that is fine. The column header is there. I can provide whatever you need, just let me know where to send it! The text field contains nothing, no commas or other characters.

‎08-11-2020

I have a survey with a series of cascading questions that is giving me a bit of a fit when we download the results of a survey. It is a series of three questions relating to predation. Question one is a select_ one yes_no if there was predation present. If yes, then question two is a select_multiple about what type(s) of predators caused the predation which also includes an other as a selection. If you select other, a third 'question' text box appears so the user can type in the other predator not listed in the initial list. This third question's data is giving us a bit of a fit when we export the data into an Excel spreadsheet. My users will collect data in the field and many times they do not have an other thus the third question never appears to the crew in the field. At the end of a week, I download the data and copy and paste the new rows of data to a master Excel sheet stored in a secure cloud location. When I paste, it is as if this column does not exist and all the data shifts one column to the left and all the data does not appear under the correct heading. I have a two question cascading series of questions before this in the survey and it doesn't seem to have the same affect on the data. I have tried to put a default of NA for this question to at least get a placeholder but that doesn't seem to help or even show up unless other is selected. Any help would be appreciated!

‎07-02-2019

I am running into this same issue in Pro 2.3.3. We have a database created in Survey 123 for field data collection of banded birds. Since its original publication earlier in the season, we have added new band combinations in Survey 123 and republished. Those do not show up in the domains that Pro 'sees' (another issue in itself). So for any of these new band sightings that were collected in the field, it will not let me edit any of the other data associated with that record, even if I am trying to change something from the original picklist in another column. I am able to edit the data if what was in the original publication of the database from Survey 123 is what the field user selected.

‎06-12-2018

I followed the blog post instructions because we updated our Survey123 pick lists to reflect new nesting bird pairs. Without updating, I cannot select the proper bird pairs when QC'ing in ArcGIS Pro. I used JSONLint to validate what I was doing. It showed a valid JSON. When I copy it back into the Update Service Definition box I get this error "Invalid definition for 'SourceSchemaChangesAllowed'. Invalid definition for System.Boolean" For those that are having issues updating your pick list items in Survey123 and it wiping out your data, what I have found is if the new items you try to add expands the width of the column, it will cause your data to be lost. For instance if the maximum width item in your pick list is "Frog" and you try to add "Opossum", it will cause an issue. If you entered "Opos", it should take it with no data loss. What I have learned as a workaround is if you feel you need to add items later, make sure you at least have one item in there that will account for the maximum width you will need out of that column. In my example, putting in "Rhinoceros" would allow you to put in any 10 character item later.

Online Status	Offline
Date Last Visited	‎09-19-2022 07:59 PM

My Ideas

Latest Contributions by brianvan_druten

Re: Cascading Questions and Exported Data Shift

Cascading Questions and Exported Data Shift

Re: ArcGIS Pro 2.3 Bug

Re: How to update coded values of HFS published with Survey123 without overwriting service?

Wildfire Response GIS