Latest Contributions by mattkramer

‎06-17-2021

Hello, I have some survey data that has been collected and am trying to generate some reports from this data. I have made my template and everything seems to be working except for a couple data fields which are not transferring from the table to the report. Here are some screenshots for context. Similar to the second screenshot, the "MeterID" field does not transfer to the report that is generated. That field is a select_one_from_file field if that is important. Thank you!

‎04-29-2021

What you can do is read your excel file into an array, where when appending data into the array, you call the replace command to get rid of the comma. inRow = [str(row[0]),str(row[0]),str(row[2]),str(row[3]),str(row[4]),str(row[5]),str(row[6]),str(row[7]),str(row[8]),str(row[9]),str(row[10])] index = 0 for i in inRow: if "," in i: i = i.replace(",","") inRow[index] = i index += 1 points.append(inRow) And then use that array to create the csv. AllProjects_CSV.truncate() writer = csv.writer(AllProjects_CSV,delimiter=',') writer.writerow(fields) writer.writerows(points) My example is pulling data from a SDE database but I am pretty sure you can use something like openpyxl to read through an excel sheet.

‎04-02-2021

Hello, I am just wondering if it is important to consider the projection of layers when uploading them to collector. Right now, I have been uploading layers that are projected in NAD83 State Plane, to maps that are projected in the WGS84 Web Mercator. Since my map is in the WGS84, and I am pairing with a R1 receiver that is using the SBAS correction, I believe that the default location profile will be fine. Is that the case? I am under the impression that the map projects my layers on the fly to WGS84 and all edits done on collector get re-projected back to the original layers projection after being submitted.

‎02-16-2021

I would be ok with accepting the layer as a text field but the problem is that users can not select the Hosted feature layer as an input. When selecting the Hosted Feature Layer when setting the parameters, the only option is to "Open" the layer instead of hitting "Ok" to set it as an input.

‎02-16-2021

The Feature Dataset option does not have access to the portal, but that does sound like the closest thing to the hosted layer.

‎02-15-2021

Unfortunately the "Any Value" data type acts the same way as the feature layer. I also tried to make the option a "Folder" to maybe select the overall hosted layer as the folder holding the layers and that did not work either, the folder data type does not allow you to access portal data.

‎02-15-2021

Hello, I am trying to put together a tool that users will work with inside ArcPro that accepts a full hosted feature layer as an input. Is there a parameter type that allows for this? The "Layer File" and "Group Layer" and many other types I have tried only allow me to select one layer in the whole hosted feature layer instead of the whole thing. Here is a screenshot of where I am setting this: A work around I have thought of is just having the users put in the id for the feature layer but I am trying to make this more straightforward than that.

‎02-15-2021

Of course, I start with the "Create" button, and select "Feature Layer" Then I select "From Existing Layer", search for my template dataset and select that layer to use. I select this layer, leave all the layers included and check the "Capture GPS receiver information" button. I set the extent and title, tags and what not for the layer and click "Done" Here is a screenshot of the layer that was created in this workflow, it does not have the "PhotoLocation" layer that I have checked in the creation workflow: Let me know if there is any other info I can provide that would be of help. Thank you!

‎02-15-2021

I also only seem to get this problem when I check "Capture GPS receiver information". Could there be an issue around this?

‎02-13-2021

Hello, I have a hosted feature layer that contains 12 layers of data, when I create a feature layer from this existing layer, the created layer does not include all of the layers, even though I specify all of them to be included. Has anyone run into this before? Specifically I have one point layer not copying over. The template hosted feature layer has no data in any of the layers, has attachments enabled on all layers and was uploaded through ArcMap 10.8.1 if that helps.

‎02-02-2021

You could look into uploading them as a vector tile layer instead of a feature layer. That will cut down a lot on the size.

‎01-29-2021

Hello! I have a feature layer that is being updated by a survey123 form that I will have a python script download every hour or 30 minutes. I am running into issues where surveys are submitted and soon after that, my script runs and the entries that are entered in right before the script runs don't appear in the download. I was wondering if there was a way to either sync the layer prior to exporting/downloading it or if there was an amount of time I could wait before downloading to make sure these requests are updated.

‎07-07-2020

HI Doug, thank you for the reply. I really like the idea of adding a PRV default. I think I am going to go with that for now. Thanks!

‎07-07-2020

Hello, I have a survey where field teams have to enter in make and model of some items on a site and am using repeats to easily handle multiple entries. I was wondering if there was a way to have answers carry over to the next instance of a repeat. Many of these features have the same make and model and eliminating the need to reenter this data would be beneficial. Here is a screen shot of my survey in Connect. Basically I was wondering if there was a way to prepopulate my "PRV model" text field in the second third and fourth iterations of this repeat with the last answer given. Thanks!

‎06-30-2020

Is it possible to change an extension from a named extension to a concurrent or vice versa?

Online Status	Offline
Date Last Visited	a week ago

My Ideas

Latest Contributions by mattkramer

Survey Data not showing up in report exports

Re: replace commas from .csv

Layer projection when collecting high accuracy GPS data

Re: Hosted Feature Layer as input for custom script

Re: Hosted Feature Layer as input for custom script

Re: Hosted Feature Layer as input for custom script

Hosted Feature Layer as input for custom script

Re: Create Feature Layer From Existing Layer not copying all layers

Re: Create Feature Layer From Existing Layer not copying all layers

Create Feature Layer From Existing Layer not copying all layers

Re: Large Datasets Viewablilty

Feature layer update lag after edits made

Re: Repeat answers in repeats

Repeat answers in repeats

Re: Accessing concurrent extensions under a named license

Organization Setting to manipulate default publish...

Re: Options for changing default active repeat rec...

Re: Survey123 connection blocked in Chrome after N...

Survey123 connection blocked in Chrome after Nov 2...

Re: Orphaned data and services clean up