Latest Contributions by AndrewHargreaves

Hi I'm following the video tutorial to preload data from a CSV exactly, but am unable to get my form to load correctly. See the two attached images to show my XLS setup and the error I'm receiving. Here's my 'info.csv': Here's my XLS Form setup: But it fails to load: ... View more

Hey @Ismael Chivite How do I set a question to only appear if a previous question (of type select_one) is 'NOT BLANK' eg: the user has selected a value. Thanks ... View more

Hi Ismael, Using the "Calculate Location" sample in Survey123 Connect is there a way to autopopulate the continent and city based on the XY gathered from the GeoPoint? eg: my current location auto populates "North America" and  "Pennsylvania". Thanks ... View more

Hi Xander Bakker​, thanks for pointing me to that file location. However, can I not display the 3D content inside Drone2Map? Do i need to bring it into ArcGIS Pro? Thanks ... View more

I've searched around and this is the most closely related thread I can find. I have the same set up as the original poster, namely 1-n inspections. If i set the popups to display the 'created_date' of a related record it simply defaults to "12/31/1969" regardless of the actual dates value... ... View more

Hey everyone, I just stumbled across this thread as I ran into the exact same issue - the need to access related tables within Operations dashboard. Here's how I solved it: I have a hosted feature service with a related table in my map. I can't access this related table as a data source in my map, or even as external data source. But, as @Jeff Shaner explains above there is support for a stand alone table. What i did was take the Service URL of that (hosted) related table, add it as a new item in my ArcGIS Online content, and access that as an external data source. Now, when field crews make a new inspection record in the field using Collector the results show up in my dashboard. Thanks ... View more

Here is an answer from RJ Sunderman​ which indicates, sadly, I can't do what I want unless I hardcode the Filename into my Python script: Hello Andrew – I think there is some confusion in how the ‘Output Date Format’ and ‘Custom Date Format’ properties of a ‘Write to a CSV File’ output are used … and from where the “FieldName” to which you are referring is coming. First, the ‘Write to a CSV File’ output uses the out-of-the-box Text adapter. This adapter’s implementation has some particular characteristics which a lot of folks find useful. The “FieldName” you are referring to, I think, is actually the name of the GeoEvent Definition associated with the GeoEvent delivered to the output. For example, I have a GeoEvent Service which accepts event data sent to a GeoEvent hosted REST endpoint via HTTP/POST. The event data sent looks like this: [ { "TrackID": "AA-1234", "TimeStamp": "3/15/2015 12:34:56", "SensorCode": 11210 } ] The GeoEvent Definition I created for my input to use, named GenericJsonReceiver, looks like this: When I configure a ‘Write to a CSV File’ output I can leave the default ‘Output Date Format’ setting (‘ISO 8601 Format’) and I’ll get output in my named CSV file which looks like this:   GenericJsonReceiver,AA-1234,2015-03-15T12:34:56.000-07:00,11210 There are not field names in the data string. There is only the three data values prefixed with the name of the GeoEvent Definition. You cannot turn off this behavior. One of the features of the Text adapter is that it always prepends the name of the GeoEvent Definition associated with the event data. Precisely because you don’t have field names, seeing the name of the event definition can be very helpful. Also, this is one of the only outbound connectors you can use when you’re unsure which GeoEvent Definition is associated with your data once it is through the filtering and processing of a GeoEvent Service … and you want to find out. If I change my ‘Write to a CSV File’ output configuration to specify a date/time mask, I can control what date/time value look like (e.g. how they are represented as String values) in the data written to the file. If I specify the ‘Output Date Format’ and ‘Custom Date Format’ properties as follows: Then the text logged into the CSV file will appear as:   GenericJsonReceiver,AA-1234,15-Mar-2015 12:34:56,11210 What I’ve done is tell the output that I would like to see the date formatted as days, followed by a three letter abbreviation of the month, and a four digit year, then the time. I’ve also specified that I like dashed used in my date rather than slashes. These settings have absolutely nothing to do with the name of the output file. The name of the output file is static, and configured up above the ‘Advanced’ parameters. You only get to specify a file prefix. Depending on how you elected to have the file rollover (the ‘File Rollover Method’ property) you will either get your specified file prefix with a .csv suffix … or you will get a system generated date/time stamp following your specified prefix with a .csv suffix. You have no control over how the transport (the out-of-the-box File transport in this case) decides to represent the date/time it integrates into the output file’s name. Hope this information helps – RJ ... View more

Dan I'm not using Python to create the CSV - It's a GEE output "Write to CSV file". I need to know if it's possible to configure this output to NOT have a date as part of the name GEE gives it when it creates it upon starting this output. I also need to know how to overwrite it each time the GEE service is triggered... ... View more

Dan Attached is a screenshot of my GEE Service. My input detects a change of "status" on a Sewer overflow, if that status is "Verified" it strips out a bunch of unneeded data and pushes the remainder to a CSV file. I have a python script that uses that CSV file to suck in the info and do some processing. I need that CSV file to always be named the same thing, and to only contain the value not the fieldname & value (in seperated fields) as it does now. Thanks ... View more

Dan Patterson​...thanks for your persistence. I have a confession - the issue wasn't your code. When I followed @Kevin Hibma's advice to bring this in a FS I had forgotten to specify the required field I was trying to push the results into ('Results' in line 38 of your example above). The good news is, it all works great now! The bad news is that my ranking begins at 0 , not 1....is there a sneaky way to achieve that on the fly? Or must I specify a 'start' and 'stop' value like you do in line 30 of your code above? (I'm trying to avoid hard coding 'stop' values in so this would work with different data sets) ... View more