Latest Contributions by Trippetoe

‎01-23-2018

I have deleted all the related tables that i do not need in the view. I deleted the 3 related tables from the view first. I can make the view available to you if you'd like to look at it. Since it's a view, i can also start all over just to make sure that i followed the correct procedure. Let me know what you'd like me to try, or if there is any additional information you'd like. I can also re-open the support ticket i had opened for this question as well.

‎01-23-2018

It turns out that the 'relationships' element is not removed from the view layer json. I discovered this because our maps which use the hosted feature layer of the view started reporting an error about missing table id=3. And "3" was the id of one of the related tables. When i went back to review the hosted feature services json, this is still there: "layers" : [ { ... "id" : 0, ... "relationships" : [ { "id" : 0, "name" : "", "relatedTableId" : 3, ... }, { "id" : 1, "name" : "", "relatedTableId" : 2, ... }, { "id" : 2, "name" : "", "relatedTableId" : 1, ... } ] } There is also a relationships element in the json of the hosted feature service's layer, i.e. <servicename>/0 How can i remove the relationships element from the service definition? thank you

‎01-22-2018

I think i confused the issues. I apologize for that. Within my view, the 'main' layer, id=0, has a json element named 'relationships' which references the 3 related tables that i want to drop from the view. Do i need to remove that element (relationships) from the view definition as well? { "layers" : [ "id" : 0 ... "relationships" : [ { "id" : 0, "name" : "", "relatedTableId" : 3, }, { "id" : 1, "name" : "", "relatedTableId" : 2, }, { "id" : 2, "name" : "", "relatedTableId" : 1, } ], ... }

‎01-22-2018

In the source\origin layer definition do i need to drop the 'relationships' element?

‎01-19-2018

Hello. We have a private hosted feature layer that has 3 related tables. We want to make some of the 'spatial' data available to the public, but we don't want any of the related data visible to the public. Is there a way to create a hosted feature layer view that excludes the related tables? I tried not including the join field in the list of fields for the view, but related tables and their data are still present in the view. thank you

‎12-13-2017

Screen shots below. I am not sure how to upload the xls form. In the first screen shot, the 'All' checkbox is selected in the 'Set Visibility' dialog.

‎12-12-2017

I followed the wonderful example by Carmel Connolly (Making Other Work Harder in Survey123 Results — Esri UK) to collate 'other responses' into a single field (Section 2), and it worked great..... except when i view the survey results in the Survey123 website. In the Analyze tab, i see a message which reads 'no questions are visible....' I clicked the Set Visibility button and selected the 'All' check box. Still no questions are visible. In the Data tab, when i click on an individual record, in the right hand pane i see the title of my survey and the 'submitted by' and 'submitted time' fields, but that is all. As a test, i changed the hidden field to 'text', republished the survey, and submitted some new responses. Now i can see all the responses in the Analyze and Data tabs. Is the Survey123 site supposed to hide the responses to 'hidden' questions?

‎11-28-2017

I resolved this issue by 'repairing' the install of ArcGIS Pro. Start > Control Panel > Add or remove programs > ArcGIS Pro > Repair. I have no idea what the Repair operation did, but i am able to run python in Pro now.

‎11-13-2017

Hi Shan. Using a database trigger would be my preferred alternative, but I am using a hosted feature service on AGOL. It's my understanding that we don't have the ability to set triggers within the AGOL database. Perhaps my understanding isn't correct? Thanks for your suggestions. Tom

‎11-09-2017

I heard from JTedrick-esristaff‌ that the behavior is intentional starting at 2.4. I offered some user feedback that creating null records is not a preferred way to go, especially since most of our surveys would have 1 repeat. With the current implementation that would fill over half our database will empty records. And you are right, i will have to remove the value from the repeat_count field to prevent creation of the empty repeats.

‎11-03-2017

Hey Shan. Are you able to create the values like 'TABLE_1' automatically, or are they created/entered by a manual process? Do you have a way to guarantee that they are unique?

‎11-02-2017

Thank you for your suggestion. We already have GlobalIds in the table. the problem is that they are not 'human readable'. We need something that an Admin or field user can refer to when talking about the record. Current we use something like 'i am working on case number 17-0567'. We couldn't do that (as easily) if we were using guids.

‎11-02-2017

I am using version 2.4.60 of S123 Connect and version 2.4.74 of S123. A couple weeks ago I updated my existing survey by adding a value (3) to the repeat_count property of one our repeats, "Treatments". When i published the survey, it required a delete of the hosted feature layer and creation of a new one. the one change on the hosted feature layer was addition of the field "Treatments_count". Now, whenever a survey is submitted, 3 new records are created in the Treatments table, regardless of how many the user created in the survey. For example, if the user completed 1 'treatment' in the survey, 3 records end up in the hosted feature layer - one record has a full set of values and two records have null values in all the fields without default values (except for objectid and globalid). This is not the desired behavior (I simply wanted to limit the number of repeats that could be created) and is not what is described in the current documentation (http://doc.arcgis.com/en/survey123/desktop/create-surveys/xlsformrepeats.htm) is the intended behavior to create a 'repeat_count' number of records for the repeat for each survey submission? Thank you.

‎11-02-2017

I have a 'case number' field in our hosted feature layer that serves as a human-readable unique identifier. I need to prevent duplicate values being entered in that field (our current process is to run a query nightly to identify any duplicate entries). Is there a way to set a unique index on that field? Or any other ways to guarantee uniqueness of values as the values are being entered? In a sort of worst case, is there a way to query the hosted feature layer before the new record (or edited record) is submitted? If the value exists, the user could be notified. Thank you.

‎10-25-2017

I have been running Pro 1.4 for a while. I was able to run my python scripts from a command line (using propy) as well as other IDEs like Visual Studio Code. Yesterday I upgraded to Pro 2.0.1 (I used the Upgrade process of the ArcGIS Pro UI). Now i cannot run my python scripts from the command line nor from my IDEs. The error message is 'python.exe' is not recognized as an internal or external command, operable program or batch file. When i open the Python view in ArcGIS Pro, i see the following error message: Failed to Initialize Python Interpreter When i open the Python Package Manager in ArcGIS Pro, it shows that my project is using the arcgispro-py3 environment, i can see many installed packages, etc. My path variable has the following settings at the end of the path string: ...;C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3;C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Scripts;C:\Program Files\ArcGIS\Pro\bin\Python\Scripts;C:\Program Files\ArcGIS\Pro\bin\Python Any thoughts or suggestions on what i can do to get my python scripts running again? Thanks.

Online Status	Offline
Date Last Visited	yesterday

My Ideas

Latest Contributions by Trippetoe

Re: Can a hosted feature layer view exclude related tables

Re: Can a hosted feature layer view exclude related tables

Re: Can a hosted feature layer view exclude related tables

Re: Can a hosted feature layer view exclude related tables

Can a hosted feature layer view exclude related tables

Re: Hidden field responses not appearing in the Analyze and Data tabs

Hidden field responses not appearing in the Analyze and Data tabs

Re: Pro upgrade broke python

Re: Can I set a unique index on a field in a hosted feature layer

Re: repeat_count creating unneeded records

Re: Can I set a unique index on a field in a hosted feature layer

Re: Can I set a unique index on a field in a hosted feature layer

repeat_count creating unneeded records

Can I set a unique index on a field in a hosted feature layer

Pro upgrade broke python

FeatureLayerCollection.replicas.create always retu...

Add more fine grained control of colors in Customi...

Is sending data to repeats supported in Survey Wid...

Re: Category links open results page at the page f...

Re: AGOL hosted feature service just started refus...