Latest Contributions by danbecker

A1) Portal and server are federated, using built-in portal users/roles. Portal and datastore are on seperate VMs, guest OS is Ubuntu Server 16.04. Server and web adaptor are on the same VM, guest OS is Win Server 2012 R2. A2) Problematic log is attached. I deleted most of the domain records, they were lengthy. A3) Advanced template, single question publishes fine, no issue. Following A3: I opened the 2 .xls files side-by-side. I started copying single rows from the problematic .xls (Form1), then pasted values into the advanced template .xls (Form2). I opened the Form2 folder, and deleted the .itemInfo file In portal, I deleted the Survey-Form2 folder I republished Form2. Repeat this sequence for each new row added from Form1 to Form2. I got to the end of the survey, no errors in publishing!!! There must have been an issue with the Form1 .xls file. thanks. ... View more

thanks for the inspiration! I did something very similar, but created a PDF via XML/XSLT. survey123 sets ${already_emailed} = 'NO' by default query hosted feat. service for already_emailed = 'NO', return FeatureSet (bummer how this doesn't contain domains) via REST query domain info for each field via REST: /service_1232/FeatureServer/layerID logged BUG-000111606, queryDomains doesn't work for hosted feat. services set already_emailed = 'YES' via REST: /applyEdits open template XML file, loop over featureSet. Populate fields, use XML attributes to specify field has domain/not. style XML file using XSLT template via Etree module. This exports an .html file Convert .html to .pdf via pdfkit module Email PDF report to project manager via cronjob Best part is that all we have to do is point this .py to a new hosted feat. service (survey123 database) and it will start firing off new reports based on any fields! ... View more

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. ... View more

thanks James, confirmed. I edited my comment above. ... View more

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.  ... View more

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. ... View more

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. ... View more

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. ... View more