Latest Contributions by KierenTinning2

‎07-23-2020

Xander Bakker‌, thank you. I am much further ahead, the only part the script appears to be failing on now is an "failed edit operation, Required keyword not defined in script". I wonder if it is the 'labeltext' element, which is actually a field that the result needs to be written to var tbl = FeatureSetByName($datastore,"DB.LAND.NonCustomerAddress"); var fc = FeatureSetByName($datastore,"DB.LAND.Premise"); var premiseKey = $feature["GlobalID"]; var nonCustomerSql = "GlobalID = '" + premiseKey + "'"; var nonCustomerAddressResult = Filter(tbl, nonCustomerSql); var txt = null; for (var address in nonCustomerAddressResult){ txt = txt + address.building_number + ','; premiseKey = address.premiseguid; } var premiseSQL = "GlobalID = '" + premiseKey + "'"; var premiseResult = Filter(fc, premiseSQL); return { "result" : txt, "edit" : [{ "className" : "DB.LAND.Premise", "updates" : [{ "labeltext" : txt }] }] }

‎07-23-2020

Xander, Thank you ,I hadn't even noticed the logic error. I've updated the code here - for the popup - would I still use $map in the attribute rule? I wouldn't think so, but I could be wrong. Also, the $feature here is referencing the point I clicked, however in the attribute rule it's actually reversed as it would be from the table to the feature? As for the SQL, I am using it as I need to roll up all of the values from the table and then write them to the the feature in a comma separated list. var tbl = FeatureSetByName($map,"Non Customer Address"); var fc = FeatureSetByName($map,"Premise"); var premiseKey = $feature["GlobalID"]; var nonCustomerSql = "premiseguid = '" + premiseKey + "'"; var premiseSQL = "GlobalID = '" + premiseKey + "'"; var nonCustomerAddressResult = Filter(tbl, nonCustomerSql); var txt = null; var premiseResult = Filter(fc, premiseSQL); for (var address in nonCustomerAddressResult){ txt = txt + Text(address.building_number, ','); } If (count(txt) > 0){ premiseResult = Filter(fc, premiseSQL); premiseKey.labeltext = txt; } return { "result": txt, }

‎07-23-2020

All, I am trying to implement an attribute rule which updates a feature class field when the related 1:M table gets updated. The process right now is, the field in the related table changes, we get the keys, roll up the data into a string and then get the related record in the feature class and write the text value. Issue is, a) the for loop is in error and if I comment it our and put a dummy value in my text variable, it doesn't actually write anything. Any help would be appreciated.- thank you var tbl = FeatureSetByName($datastore,"DB.LAND.CustomerAddress"); var fc = FeatureSetByName($datastore,"DB.LAND.AddressLocation"); var locationeguidKey = $feature["locationeguid"]; var CustomerSql = "locationeguidKey = '" + locationeguidKey + "'"; var premiseSQL = "GlobalID = '" + locationeguidKey + "'"; var CustomerAddressResult = Filter(tbl, CustomerSql); var txt = null; var address; for (var address in nonCustomerAddressResult){ txt = Text(address.building_number, ','); } return { if (Count(txt) > 0){ txt = Left(txt, Count(txt) - 1); premiseResult = Filter(fc, premiseSQL) // premiseKey.labeltext = txt; } "result" : txt, "edit":[{ "className": "premiseResult", "updates" : [{ "labeltext": txt }] }] }

‎07-20-2020

Rich, Thanks, we're inserting into default, it's a table that connects to a feature class through a simply relationship class. I look forward to testing 2.6, it's interesting as Pro's append command will do the same in about 30 minutes (all 1.3 odd million records)

‎07-17-2020

All, Does anyone know if there is a more efficient mechanism to bulk load records into a Branch Versioned Geodatabase Table. This is a console app, so I am using the ApplyEdits Method ArcGIS Pro 2.5 API Reference Guide And reading and writing in blocks of 2000 records. The target is to load approximately 1.5 million records. In regular C# code (data transformation, etc) with SQL Commands this takes about 4 minutes. It's taking about 12 minutes per 2000 records with the ApplyEdits Method in the core API. Reading 2000 record batches from the source and writing same. The table has a relationship class tied to a Utility Network feature class, so it needs to be and remain branch versioned. Any advice would be greatly appreciated.

‎12-16-2019

Absolutely agree, it is actually a problem with the selection of the underlying PostgreSQL technology and how it's implemented for the Datastore which causes the primary / secondary scenario from my understanding.. I used HA in the sense that when setup the system should always "be in sync" and primary will fail to secondary smoothly, it's when you try to recover too quickly that you have the issue with the two not "lining up" as it were. It's also why you can only have two portal machines. It would have been good had Portal followed the same HA strategy as ArcGIS Server, but alas, we have what we have.

‎12-13-2019

We found the same, we scheduled the patch process to shut down the Standby, then shut down the primary and patch it first and then patch and restart the standby system. Unfortunately, this takes you out of HA for a short period of time, but worth it to avoid all the index problems that result. We're hoping that this issue has been addressed in 10.7.

‎10-04-2019

Hi, Did you ever get this to work? No matter what I do it fails. Built the app from Web AppBuilder on ArcGIS Online - downloaded it to host on the internal network and always prompted for the username / password. Even if I supply the Client_ID and Client_Secret with the token service, oath2 or neither used. Interestingly enough, I can log into ArcGIS Online, but when prompted through the web app my login fails. I had to add "httpProxy": { "useProxy": true, "alwaysUseProxy": false, "url": "https://xxx.xxx.xxx.xxx/proxy/proxy.ashx", "rules": [] }, To the bottom of the config file as it wasn't available in the base app when I downloaded it

‎05-16-2019

Anthony, XRay is an Esri add-in that will output a Geodatabase data model into easily usable / reportable Excel files. I'm hoping to get the Excel files for the particular data models.

‎05-16-2019

Are you looking for tools? Or the kinds / types of work activities to conduct a project like this?

‎05-16-2019

All, Just wondering if anyone has the X-Ray output for the Esri utility models (Desktop / Geodatabase), not the newer utility configurations? This would be for Water Utilities GAS Electric Telecommunication Local Government If you have the x-ray output and don't mind posting them it would be greatly appreciated. Thanks,

‎04-23-2019

David, Sorry about the tardy reply on my behalf. We never did determine the best way to do this (well we did which is the use the survey123.arcgis.com report tool, but that had significant problems with the system and the reporting is very limited through the Word templates). We also ended up using a publicly exposed system in order to make this work, the main system was behind a firewall and wouldn't communicate with the external survey123 site. I think the best bet would be to use an FME / Data Interoperability job to bring the data from the Datastore into a "proper" relational database system for reporting purposes. The blackbox that is the Datastore has certain benefits, but this unfortunately isn't one of them. Kieren

‎06-04-2018

Fraser, Our ports are open, but indexes are out of sync. Did you shut down the entire server or just the service? We have shut down the service and it didn't correct the issue. Running portal 10.5.1 Thanks, Kieren

‎05-29-2018

Hi, We have Survey’s hosted on ArcGIS Online. We have republished these survey’s into our in house ArcGIS Portal environment (10.5.1) leveraging the Datastore. We now need to load the data from the ArcGIS Online data to the Portal (exported the ArcGIS Online data to – the obvious tool to do this is the Append tool, however, the Maintain Attachments check box does not in fact maintain the attachments (the feature class loads, but the attachments do not). The Preserve Global ID’s also fails with a -9999 error as it only appears to work with Enterprise Geodatabases. If we could preserve the GlobalID’s then we could simply load the attachment tables. Is there an easy way to do this that I am missing? It would seem there should be, if not, I can add a bunch of fields and attempt to recalculate GlobalID’s after the fact, but this seems a little over the top. Thanks all

‎04-19-2018

Andi, We have a few survey's which use a feature service connected to our enterprise Geodatabase (Oracle in our case), and this works well. Our environment is quite dynamic with different survey's being constructed regularly and the users just publish them to the Datastore. survey123.arcgis.com has a nifty "Report" tool, the issue is that it is in Beta and does not play well with ArcGIS Enterprise though it works quite nicely with ArcGIS Online. It is this type of easy reporting, i.e. click on a record (or select it somehow) and then generate a quick report that we are looking to replicate. We are hoping that come July (the next scheduled release of survey123.arcgis.com) this will come out of beta and will work nicely. Until then, we are looking for solutions 🙂 which if good enough may become permanent. At the moment I am considering a Data Interop type job where the user will submit an ID and the system will extract the data and produce a report. I'll post what I figure out. Kieren

Online Status	Offline
Date Last Visited	‎09-17-2024 01:53 PM

My Ideas

Latest Contributions by KierenTinning2

Re: Arcade - Update Feature Class based on related table

Re: Arcade - Update Feature Class based on related table

Arcade - Update Feature Class based on related table

Re: Bulk Load Geodatabase Table - Pro Core SDK

Bulk Load Geodatabase Table - Pro Core SDK

Re: Portal 10.5 Index Mismatch (search)

Re: Portal 10.5 Index Mismatch (search)

Re: Web AppBuilder with private map ask for login

Re: XRay for Utility Models

Re: Has anyone done a pipeline integrity data management project?

XRay for Utility Models

Re: How to access and/or query ArcGIS DataStore tables/data from third party Reporting Software (CrystalReports, etc.)?

Re: Portal 10.5 Index Mismatch (search)

ArcGIS Datastore Load Data with attachments

Re: How to access and/or query ArcGIS DataStore tables/data from third party Reporting Software (CrystalReports, etc.)?

Re: Arcgis Portal : Analysis widget error 403

Re: Utility Network Trace Arguments

Arcade - Update Feature Class based on related tab...

Re: Survey123 & Integrated Windows Authentication