Latest Contributions by HanliePretorius

‎12-04-2020

Hi Andrew, Thanks for the video. My other colleagues also don't experience my problem - hence the frustration. We are not in the US and I suspect it might have something to do with my computer's regional settings, but I don't know exactly what. My tests so far have failed to identify the culprit. For now I'm using integers and asking the users to insert the factors as 'percentages' - 0.8 should be entered as 80. Then I divide the user entry by 100 and use the result in my calculations. I suspect this will be one of those questions that do not have an answer, only a workaround. Regards Hanlie

‎12-02-2020

Thanks for the reply Andrew. I tried that but it made no difference - the decimal value still disappears when I navigate from record to record. I'm considering making them integers and asking the users to multiply their values by 100 just to get on with the job. Regards Hanlie

‎12-02-2020

Hi, Survey123 Connect 3.11, Windows 10 Enterprise I'm trying to create a repeat that takes a text value and a decimal value My computer's regional settings' decimal character is a full stop. I have set the decimal field's type and binding to decimal. When I enter a decimal, such as 1.2, it looks as though it's accepted, but when I add another record and come back to the first, the value I typed is gone and the field is just empty. Entering an integer as the value doesn't have the same effect - it's retained after navigation to other records. I have not tried to publish the survey, I'm just creating it on my computer for now. Does anyone know why this would happen? My colleagues don't seem to have the same problem. Thanks Hanlie

‎10-26-2020

Hi Dana, Thanks for the reply. In the end I used something similar to what you describe, except I did it straight in SQL. This is the code I used: select vs.PropertyID , vp.PROPERTY_ID as VALUATIONPROPERTY , p.PROPERTY_ID as PROPERTY from new_valuation_fc vs left outer join old_propery_fc vp on vp.PROPERTY_ID = vs.PropertyID left outer join new_property_fc p on vs.PropertyID = p.PROPERTY_ID where p.PROPERTY_ID is null That gave me everything in the new_valuation_fc linked to PropertyIDs that do not exist in the new_property_fc. I had some help from a colleague with this and it seemed to do the trick. Cheers Hanlie 2020-10-26 19:38 GMT+02:00, Dana Nolan <geonet@esri.com>: Dana Nolan replied to the discussion "Re: Finding the records that participate in a relationship" To view the discussion, visit: https://community.esri.com/message/961154-re-finding-the-records-that-participate-in-a-relationship?commentID=961154&et=watches.email.thread#comment-961154 >

‎10-01-2020

Hi, I had to replace one FC with another and at the same time I created another relationship class. I started with old_property_fc and old_valuation_table with 1:M old_property_valuation_relationship. Then I created new_property_fc and new_valuation_fc and 1:M new_property_valuation_relationship. The trouble is that some of the features in new_valuation_fc seem to be related to features in old_property_fc. I think I know how it happened - operator error! - but now I want to find all the features in new_valuation_fc that are related to old_property_fc records. Is there some way of doing this? Both FCs have 40 000+ records, so doing it manually will be an arduous task. I'm comfortable with SQL if that helps. Thanks

‎06-25-2019

Hi, I want to create a custom basemap but don't have data for the all the spaces in between features. I would like the Esri light grey canvas basemap to show in the empty spaces. Can I do that? How? Thanks

‎04-10-2019

Thanks, this worked for me but changes are only visible after creating, saving, updating and saving.

‎12-11-2018

Thanks for the information - looks like a very useful workflow. 2018-12-12 0:15 GMT+02:00, Michael Fletcher <geonet@esri.com>: Michael Fletcher replied to the discussion "Re: Feature service not executing DB triggers" To view the discussion, visit: https://community.esri.com/message/818908-re-feature-service-not-executing-db-triggers?commentID=818908&et=watches.email.thread#comment-818908 >

‎03-01-2018

Thanks for the reply; that might be the issue but I can't check today. Do you know of any documentation beyond the data dictionary for the CapitalPlanning feature dataset? The dictionary is rather sparse in its information. 2018-03-01 14:30 GMT+02:00, Scott Oppmann <geonet@esri.com>: Scott Oppmann replied to the discussion "Re: Manual installation of Capital Improvement Plan solution" To view the discussion, visit: https://community.esri.com/message/754168-re-manual-installation-of-capital-improvement-plan-solution?commentID=754168&et=watches.email.thread#comment-754168 >

‎03-01-2018

Hi, I'm working with ArcGIS Pro 2.1 and our organisation's Portal. I've installed the ArcGIS Solutions Deployment addin but for some reason the Capital Improvement solutions are not in the list of solutions to deploy in step 2 of the sharing process (I'm logged in to our organisation's Portal server). See attached AvailableSolutions screenshot. Now I would like to manually implement the solution but I can't find documentation on how to do this. At Get started overview - Capital Improvement Plan | ArcGIS for Local Government it mentions a manual installation procedure but I don't see any links to it. The links on the left seems to be for the automatic deployment. Can someone please help me to deploy this solution in one way or another? In general I find it difficult to find documentation on the LG data model. Am I missing something? Thanks Hanlie

Online Status	Offline
Date Last Visited	‎12-09-2020 05:33 AM

My Ideas

Latest Contributions by HanliePretorius

Re: Decimal field not accepting decimal character in Survey123

Re: Decimal field not accepting decimal character in Survey123

Decimal field not accepting decimal character in Survey123

Re: Finding the records that participate in a relationship

Finding the records that participate in a relationship

Hybrid of Esri and custom basemap

Re: Feature service not executing DB triggers

Re: Feature service not executing DB triggers

Re: Manual installation of Capital Improvement Plan solution

Manual installation of Capital Improvement Plan solution