Latest Contributions by danbecker

‎01-19-2018

featureList = [ { 'geometry': { 'y': 40.81670805699997, 'x': -96.71105736099997 }, 'attributes': { 'already_emailed': 'YES', 'objectid': 1, 'globalid': '{EEF86AC0-5B54-47E0-BFC8-496D457A6249}' } }, { 'geometry': { 'y': 40.816795984000066, 'x': -96.71107804500002 }, 'attributes': { 'already_emailed': 'YES', 'objectid': 2, 'globalid': '{723F5F66-98EE-4FE4-9075-31A476C60363}' } } ] I have the above list of dictionaries. I'm trying to update these 2 features using the REST API, applyEdits. I pasted the exact same list into the /applyEdits GUI on the REST endpoint and it was successful. Here's the error the server is throwing, related to the brackets around globalid val. Expected a ',' or '}' at character 138 of [{'geometry': {u'y': 40.81670805699997, u'x': -96.71105736099997}, 'attributes': {'already_emailed': 'YES', 'objectid': 1, 'globalid': u'{EEF86AC0-5B54-47E0-BFC8-496D457A6249}'}}, {'geometry': {u'y': 40.816795984000066, u'x': -96.71107804500002}, 'attributes': Here's the method I'm using to urlencode payload = {'updates': featureList, 'token': accessToken, 'useGlobalIds': 'true', 'f': 'json'} query_string = urllib.urlencode(payload) req = urllib2.Request(url,query_string) resp = urllib2.urlopen(req) can someone help me urlencode that list of dictionaries? thanks!

‎01-16-2018

Here's the answer: When publishing to Portal, all field names have to be lower, (I'm assuming this is because my db backend is PostGreSQL). When the field name is within a repeat, survey123 misses the field name check. When the field is moved outside the repeat, then you get the friendly reminder from survey123 when you try to publish. UGH, learned something today.

‎01-16-2018

Portal for ArcGIS, publish from Desktop connect to the Portal, hosted feature service. We have a repeat with this: type: select_one species_domain name: species_name type: integer name: cover_pcnt end repeat The species_domain has about 200 rows on the choices tab. It seems like whatever I do, the survey never populates the in the hosted feature service. The records are there, but they're blank. Anyone ever had this before?

‎10-16-2017

thanks James, confirmed. I edited my comment above.

‎10-13-2017

Edited This is a bug. Change calcField from type calculate to integer and everything works. I just added a bogus relavent expression for calcField so its never displayed to the user. Adding column bind::type and setting it to Integer also works. In this case you can leave the calcField to be type calculate.

‎10-13-2017

Here's the general layout of the form. If selField = a, I want to set calcField to 1 for the repeat record. Then, the calculation in sumVal field should tally all the repeat records that have a value of 'a'. Well, the first sumVal is 1 if 'a' is selected, then you add a repeat select 'a' again, now the sumVal is 11. So, the sum() calculation is concatenating the 1's and not adding them. How do you get around this?? I have calcField and sumVal fields set to ESRI type Integer. type field_name calculation integer sumVal sum(${calcField}) begin repeat relatedTable List of Repeats select_one choiceList selField calculate calcField if(selected(${selField},'a',1,0) end repeat

‎10-13-2017

We frequently run into this requirement, client wants to see the "field datasheet" submitted with the project deliverable, usually as an appendix of the report. Some client's accept a feat. class/table dump into a single excel table, some don't. In reality, a compiled single table that's produced by dumping the feat. classes and tables in the service is MUCH more useful, but none-the-less some people still like to see the raw "field datasheet". What's even more problematic is that clients often want the newly collected data to be recorded on their existing field datasheet PDF/Word template...ugh. I usually end up designing a template datasheet "form" in Excel. Alternatively, you can use a pre-existing template word doc that's just as easy to fill. Then, dump all feat. class/table data to a single Excel workbook separated into various worksheets, perhaps one for each related table. Then with a VGA macro, I open the blank template Excel/Word file, SAVE-AS and populate it by looping over the Excel worksheet(s), then export to PDF. The end product looks exactly like, or close to the client's field datasheet, minus the wet paper tears, field mud and illegible scribbles. But...a 'PRINT' button would sure be nice...hint hint ESRI.... To the OP, this probably isnt' what you were looking for, but is just how we've done it in the past. Once you setup the macro once, it's not that difficult to edit it for other projects. You'll find a lot of similarities, main data table, ancillary related tables (repeats), ect... BTW, I'm sure you could do this with Python also, but then you'll likely run into having to hunt for modules that can consume MS files.

‎10-02-2017

ArcGIS Enterprise 10.5, Collector iOS17.0.3. Users get to the field, outside of WiFi coverage and after launching Collector on their iPad Mini are prompted to Login? Before leaving the office, they downloaded the map and NEVER logged out. How do users stay logged into our Portal in Version 17.0.3? thanks.

‎09-14-2017

Sorry I can't help We've since migrated to on-premise Portal for ArcGIS with a federated 10.5 server, datastore, dedicated Linux PostgreSQL db server, all on separate Win/Linux VM's. Its been flawless since 1 June. This solved the variety of syncing issues we were having, as well as little nuances like this thread. It's really nice to fire up Survey123 Connect and publish a survey to Portal that shows up as a hosted feature service, it's super easy and best part is that it doesn't consume credits.

‎08-24-2017

I just rely on the help/tutorial docs ESRI publishes; I find them to be very thorough. Honestly, the system components are so complex it would be difficult to document everything. For example, I couldn't find hardly any documentation on portal REST API exportSite and importSite. Lots of docs on webgisdr utility, but the docs fail to mention that Linux/Win mix of OS's isn't supported (that's for another thread). A month ago we moved all 3 boxes to a single hyper-V core host. I supposed I could spin up another VM but resources are pretty taxed already. It would be expensive create a sandbox of the 3 VMs with MS and ESRI licensing being the biggest hurdle. I guess I could scrap WinServer1 for Ubuntu Linux3, it works just as well, if not better. Ubuntu Linux1- Portal Ubuntu Linux2 - PostgreSQL (SDE GDB backend) and Datastore WinServer1 - Server and 2 web adaptors WinServer2 - Domain Controller Like you said, next time I'll take snapshots of each box before I take the plunge. But, I know what I did wrong and I'm sure when I upgrade next time, it will go smoothly.

‎08-24-2017

Server was federated to Portal. Server was configured as the hosting server, Data store was also configured. Everything was working great at 10.5, but I wanted to upgrade, latest is greatest, right? This ended up being a 2AM nightmare. Rather then keeping these notes to myself, I thought I'd share. Portal 10.5.1 Upgrade, Registered survey123 app Portal (linux) update failed when attempting to create the initial site administrator account. Looking in the portal database logs, there was a problem when attempting to execute data.sql, specifically the INSERT statement dealing with survey123. This is because I already had survey123 configured as a registered App so that we could use the survey123.arcgis.com website against our own portal. I understand this was in Beta with 10.5. As soon as I commented out that line in the data.sql file the initial site admin account could be created, no more errors. CAUTION: If you have survey123 added as a registered application at 10.5, then attempt to 10.5.1 upgrade, you will likely experience the above error. Portal 10.5.1 Upgrade, Webadaptor Re-install After portal was upgraded to 10.5.1, I uninstalled/re-installed it's web adaptor. Same for Server, after it was upgraded to 10.5.1, I uninstalled/re-installed it's web adaptor. I logged into the Portal and tried to open an existing web map and would only get an IdentityManager popup, asking for credentials for the arcgisServer.local.domain machine? Server is federated with Portal, why would I bet directed to Server for a token? After troubleshooting further, all previously published feature services were working correctly, no auth. popup box. It was the offline basemaps (actually webmaps) that I had configured. Why can't ArcGIS Enterprise users simply use ESRI basemaps offline like you can in ArcGIS Online? We have to complete this extra step, outlined last section of this page: Prepare maps for offline use—Collector for ArcGIS | ArcGIS I looked at my offline basemap(s) in Portal, details page, and the Service URL was arcgisServer.local.domain/portal. That's WAY wrong and would never be reachable outside our LAN. Not to mention it's the Server hostname and portal web adaptor name. Changing the URL to FQDNDNSAlias.com/portal worked right away, I was able to get to the rest endpoint of the basemap. Devil is in the details. Look at this page: Configure ArcGIS Web Adaptor—Installation Guides (10.5) | ArcGIS Enterprise, Step #2. "If a DNS Alias will be used with the portal, the Web Adaptor should be configured over the DNS Alias instead". So, after the portal web adaptor is installed, you have to access the web adaptor config. page on the machine it's installed on, but you have to use the same externally accessible DNS Allias, so https://myexternallyfacingFQDN.com/portal. Then you will reach the portal configure page where you enter the arcgisPortal.local.domain:7443 URL. After this step, the Service URL of any item you add to your portal via a URL will correctly display as https://myexternallyfacingFQDN.com/portal/item..... Portal 10.5 Restore via RestAPI/Importsite I cannot restore (or backup) using the portal webgisdr utility since my deployment is a mix of Linux/Win. So, I individually backup Portal using the exportSite REST API and backup Server using the serverbackup.py utility. Initially I didnt' figure out the above portal web adaptor fiasco so I decided to uninstall portal 10.5.1 and go back to 10.5. Uninstall went fine, deleted the /arcgis/portal directory. Re-installed 10.5 and when I got to the initial admin. account setup, I entered the same initial admin username as before, portal_admin. I then went to arcgisPortal.local.domain:7443/arcgis/portaladmin/importSite. I specified the full path to the .portalsite file and waited, fingers crossed. After 10 minutes, Error. I looked in the portal/database logs and found an error related to INSERT "gw_" does not satisfy the unique key requirement, VALUES 'portal_admin'. To my novice SQL eye, this looks like the restore was attempting to INSERT username portal_admin from the backup, when I had already specified portal_admin during the intial admin. account config. So, I uninstalled 10.5 and re-installed again, this time when I got to the initial admin. account config. I entered tmp_admin, then the /importSite operation succeeded!! FYI, since Server/Portal were federated, I was a little unsure of the restore order, here's what I used and it worked great: Uninstall Portal, Server, and both web adaptors re-install Portal, configure a new/unique initial site admin account re-install Portal web adaptor. Remember my DNS Alias point above, this is what got my into my 2AM nightmare. re-install Server re-install Server web adaptor navigate to arcgisPortal.local.domain:7443/arcgis/portaladmin/importSite, specify the full path to the .portalsite file Cross fingers. Our site is pretty small and it took about 30 minutes. To my surprise, the importSite REST operation also restored all Server Services. I'm assuming this is because Server was federated. I did not need to run the restore.py utility on the Server machine.

‎06-28-2017

I've noticed this in almost all version of Collector including the latest. I add a cached map service to a web map and enable pop-ups on it. The cached map service has the option checked to download 10,000 cache tiles. On the web map the popups work as expected. Viewing the map in Collector while online, the pop-ups continue to work as expected. But, as soon as the map is downloaded and taken offline on Collector, pop-ups no longer are displayed in Collector. Is this expected behavior or am I doing something wrong?

‎06-06-2017

Since we are just starting to use our Enterprise implamentation of 10.5 this week, I got to the office this morning to a barage of emails from all field staff saying they're getting a sync error!! After some troubleshooting, I realized that all feature services were published to Portal by user: portal_admin, thus owned by portal_admin.Each field staff user has their own named user account in Portal, "publisher" role, and each downloaded the map to take if offline. The users could not sync, but the portal_admin while testing was not having any issues. My workaround was to create a new Role in Portal that included "editing with full control" permission. This solved the problem. Now that I know this is a reported issue, I will install the patch. Thanks for pointing this out!!

‎06-06-2017

I just figured it out... I was accessing the rest endpoint of the server w/out the web adaptor. Doing so apparently hides the replicas. https://servername.activedirectorydomain:6443/arcgis/rest If you access the rest endpoint through the web adaptor, then you can see the replicas: https://webadaptor.domain.com/arcgis/rest

‎06-06-2017

Yes, we've used Collector for years, just recently switched to ArcGIS Enterprise Standard with a federated on-premis Portal and Server implementation. I just can't figure out why we cannot view replicas at the Server rest endpoint?

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by danbecker

urlencode list of dictionaries for applyEdits REST API

Re: repeat failing to populate feature service

repeat failing to populate feature service

Re: sum() Aggregate function, appends values, doesnt add them

Re: sum() Aggregate function, appends values, doesnt add them

sum() Aggregate function, appends values, doesnt add them

Re: Python Script to mail/export printed versions of surveys?

iOS Collector 17.0.3 Keeps logging out users

Re: Survey123 Error: Global id based relationship requires support for applyEdits with GlobalIds

Re: Upgrade to 10.5.1 and Resotring a 10.5 Site, Cautionary Tales

Upgrade to 10.5.1 and Resotring a 10.5 Site, Cautionary Tales

No Popup Window offline Cached Map Service

Re: I keep getting errors when I try to Sync my Collector map back onto our Server

Re: replicas not listed

Re: replicas not listed

Re: Portal for ArcGIS upgrade from 11.5 to 12.1 no...

Re: Azure Files premium file share - SLOW File Geo...

arcpy layout.export - hosted feature layers not sh...

Re: Survey123 Date Only shows incorrectly on Repor...

PostgreSQL - Important Backup Info