|
POST
|
Hi @SeanKMcGinnis - This just results in another failure, unless I am setting it up incorrectly... I have 2 duplicate "Get Data from feature layer" connectors - the second is set to "configure run after has failed". There are no results to query on many days so no results will be returned. Even when I just change my "Apply to Each" to run after the "Get data from feature layer" has failed, the entire flow fails.
... View more
10-03-2022
06:01 AM
|
0
|
0
|
1444
|
|
POST
|
Hi @SeanKMcGinnis - Apologies for a late question but I am running into an issue and hope you can assist with resolving. The query I am using within the flow is very specific. I felt this was necessary to make it run efficiently because the hosted feature layer it is getting data from has thousands of records. Because of how specific it is, I would expect it to return no results on many dates. When I was testing, I'd created dummy data to work with so I never ran into this problem. Now, on days when no results are returned I get the error - I am not even sure if it is because of no results returned from my query because of the last bit "and offset undefined": I do not want these Flows to be disabled automatically because of this. Do you have suggestions on how to resolve this problem? Thank you,
... View more
10-03-2022
05:29 AM
|
0
|
2
|
6673
|
|
POST
|
Hi - One of my users contacted me because a python script he is running has started giving him some issues after our organization pushed Pro version 3.0.0 to our workstations. His script (below) is exporting a feature layer to a CSV, which is then being pulled into R for further analysis. Previously, the CSV would export and any null values in the attribute table would just be blank/empty. Now, they are all coded to "None" which has thrown off his processes in R. He added logic into the R script to deal with these new "None" values, however I was curious if there was some kind of change at Pro version 3.0.0 which could have caused this. His Py script had been updated to Python 3 awhile ago and was running fine. We are uncertain what the problem could be, but the issues started happening right around when we upgraded ArcGIS Pro. I also notice that if I go to the hosted feature layer in ArcGIS Online and export to a CSV from the Item Details page, null values are empty and not coded as "None". Same if I view the feature layer in AGOL or Pro. Any ideas on what could be causing this would be appreciated. Here is the Python script: #!C:\\Program Files\\ArcGIS\\Pro\\bin\\Python\\envs\\arcgispro-py3 python
# coding: utf-8
# In[60]:
import arcgis
from arcgis.gis import GIS
from arcgis.gis import *
import os
import getpass
portal_url = rhttps://mass-eoeea.maps.arcgis.com/
# ArcGIS user credentials to authenticate against the portal
username = 'USERNAME'
password = 'PASSWORD'
gis = GIS(portal_url, username, password)
# ID of the feature service you want to export
featureServiceID = "0d081b35bbe2466290926f0f09faffe5"
# Get username
username = getpass.getuser()
# Output format Shapefile | CSV | File Geodatabase
out_format = 'CSV'
# Local folder where the data will be downloaded (include slash at the end)
download_folder = "C:\\Users\\" + username + PATH
# Address of your ArcGIS portal
portal_url = rhttps://mass-eoeea.maps.arcgis.com/
download_file = download_folder + 'download.zip'
# ID of Field Data
item_id = featureServiceID
filename = "stage_turbidity" + "." + out_format
outpath = download_folder + filename
# Get content and save to csv
my_item = gis.content.get(item_id)
my_layer = my_item.tables[0].query().sdf
my_layer.to_csv(outpath, index = False)
#Download photos
download_folder_photos = download_folder + "Photos\\"
#Query to get list of object ids in layer
featureLayer = my_item.tables[0]
featureObjectIds = featureLayer.query(where='1=1', return_ids_only=True)
#Loop through features in layer
emptyAttachments = 0
for j in range(len(featureObjectIds['objectIds'])):
currentObjectId = featureObjectIds['objectIds'][j]
currentObjectIdAttachments = featureLayer.attachments.get_list(oid=currentObjectId)
if len(currentObjectIdAttachments) > 0:
#Loop through feature attachments and download to appropriate folder
for k in range(len(currentObjectIdAttachments)):
attachmentId = currentObjectIdAttachments[k]['id']
attachmentName = currentObjectIdAttachments[k]['name']
attachmentParentId = currentObjectIdAttachments[k]['parentGlobalId']
FileName = '{}'.format(attachmentName)
AttachmentPath = '{}\\{}'.format(download_folder_photos, FileName)
FinalFileName = '{}.{}'.format(attachmentParentId,"jpg")
FinalAttachmentPath = '{}\\{}'.format(download_folder_photos, FinalFileName)
if not os.path.isfile(FinalAttachmentPath):
featureLayer.attachments.download(oid=currentObjectId, attachment_id=attachmentId, save_path=download_folder_photos)
os.rename(AttachmentPath, FinalAttachmentPath)
print("Finished downloading csv file.")
# Run batch file to process csv outputs and import into Database
file = "C:\\Users\\" + username + PATH.bat
os.system('"' + file + '"')
print ("Stage/Turbdiity Data Processed with R Script" ) Thank you,
... View more
09-22-2022
11:17 AM
|
0
|
1
|
819
|
|
POST
|
Hi @SeanKMcGinnis - Thank you for the information. I was uncertain if/how these worked together, so this is helpful.
... View more
09-22-2022
05:20 AM
|
0
|
0
|
6709
|
|
POST
|
@DBranson - I had a similar situation for one of my Dashboards. First, you can change the Maximum Categories to >50. Second, I found it helpful to use another Selector to narrow down the data a bit first. So for my example, I have a selector which first filters my feature layer by Watershed. Under the Actions for the "Filter by Watershed" selector, I have set the next selector to only render when a watershed has been selected: Once a Watershed is selected, my File Number list renders. This has helped to keep the Dashboard responsive. I've configured my "Filter by File Number" selector so that the categories are derived from Features. I have also enabled the "show filter" option which allows end users to search for a specific value. See below: I think if you configure your selector to have Maximum Categories of 15,000 and then enable the search option your Dashboard will bog down. Chaining selectors together might be a good option to consider.
... View more
09-19-2022
07:04 AM
|
0
|
1
|
834
|
|
POST
|
Hi @SeanKMcGinnis - We've finally had the ArcGIS Connector added into our Business Connectors and I have begun my testing. I've had the flow successfully run, but my condition is evaluating as False and not triggering my email notification. I am hoping you can advise on this. EDITED! Here is the beginning of my Flow: Initial - config in screen capture below no longer used. Updated to - this removed the configurations within Available fields, Comparison type and Search parameter value and added an additional statement to the Where clause to make it much more specific: After getting the data from a feature layer, I use Apply to each with the following configuration: Within the Convert File Complete Date, my Base Time is set to be: addSeconds('1970-1-1', Div(items('Apply_to_each')?['attributes']?['File_Complete_Date'], 1000), 'MM/dd/yyyy') Within the Compose (Calculate 45 days from File Complete Date), the Input is set to be: addDays(body('Convert_File_Complete_Date'),int(45),'yyyy-MM-dd') My Condition is set to be equal to utcNow: utcNow('yyyy-MM-dd') I have some questions/concerns about why this might not be working as expected: 1. utcNow... to me this means date and time, however my data is really only configured to have a date (all time are defaulted to 12pm). Could this be why the Condition evaluates to False for all? 2. When the Flow runs, I see 1,000 iterations within Apply to each (see below) - could the test record just not be reached? When I bring my feature layer into a map and apply my query, I have 3,172 records which meet my criteria (Application_Status = App Complete AND File_Complete_Date IS NOT NULL) I have addressed this by altering my Where clause to be much more specific - I probably should have known to do this from the beginning! 3. When I look at the raw data from the ArcGIS Connector Outputs, I do not see my test record included; I have searched by it's unique file number using Find and it does not come up. I will continue testing to see if I can solve this. I will attempt to make my Where query in the ArcGIS connector more specific so I return less records than I currently am (#2 above). If you have suggestions in the meantime, I would appreciate anything you have. I think I have solved this... I do have a question however... even after reading the documentation, I am unclear what the Available Fields, Comparison Type and Search Parameter Value is supposed to be doing within the "Get Data" connector. Could you elaborate on what these should be used for? Thank you!
... View more
09-19-2022
06:01 AM
|
0
|
0
|
6719
|
|
POST
|
I understand what you're saying. For myself, the only time I've had issues with missed events was for one of two reasons - 1) I failed to properly configure the webhook settings via the Survey123 website (e.g. if it was supposed to trigger when an existing record was modified as opposed to newly collected) or 2) I forgot to turn the Flow on before testing. Another possibility could be that you are running into the cap for # flow runs for a Flow within your plan's limits. This could impact you if you don't have the proper license to Power Automate. I think this provides information on limits in Power Automate.
... View more
09-14-2022
09:04 AM
|
1
|
1
|
2560
|
|
POST
|
You'd probably just open the Flow, locate the connector, click the ... on the right of the card and select "Add New Connection". I don't see a benefit to doing this with existing Flows. Once you save, users will need to re-download the Survey123 form in order for the webhook to work (if you are using the Survey123 connector).
... View more
09-14-2022
07:19 AM
|
0
|
3
|
2578
|
|
POST
|
Just about. If I create a new webhook within 2 weeks of the last one I worked on, then I probably would use an existing connection. But I rarely do that, so I'd say yes, in general I always create a new connection.
... View more
09-14-2022
06:43 AM
|
0
|
5
|
2583
|
|
POST
|
Hi Jeff, No - I have never had issues in an existing webhook when I was creating a new one. What you will end up with, eventually, is a list that looks like this as you'll need to add a new connection each time a new webhook is built. It's a bit annoying, but now I just know that if I'm building a new webhook I just need to re-establish a connection to my AGOL account (second image).
... View more
09-14-2022
05:40 AM
|
0
|
7
|
2602
|
|
POST
|
@JD1016 - The two-week expiration you're seeing references about (for me at least) has only been an impact when building new webhooks. If I created a webhook today and entered my AGOL credentials to establish the connection with whatever connector I was using, and then if I went back on October 1 to create another new webhook using an Esri connector (e.g. Survey123), I'd have to re-enter my credentials to get a list of my Survey123 forms because the credentials have expired. The two-week expiration should not impact webhooks which are saved and on (running). I have many webhooks and have never had an issue.
... View more
09-14-2022
05:21 AM
|
0
|
9
|
2609
|
|
POST
|
Scott - So simple! I checked my CSV for special characters, but did not notice the 2 records that were blank in my lookup column. Thank you so much!
... View more
09-12-2022
11:06 AM
|
0
|
0
|
1351
|
|
POST
|
Hi - Has there been a change in the way pulldata() with external content (a CSV hosted in AGOL) works? I did a proof of concept test on August 1, 2022 and had this working perfectly. Now I am attempting to implement and I am seeing a strange behavior. My "key" field is a registration number; when that is entered, a person's information is pulled from the CSV into my survey form. Previously when I was testing this in August, the form would be blank until I entered a value and hit "Enter" - then the personal information would appear. Now, when the survey form is opened and before the registration is entered, a value from the CSV is auto-populating all fields where pulldata() is in use. The only change here is the Survey123 version. I am wondering if someone can advise. Currently using Survey123 Connect version 3.15.175 and the Survey123 Field App at version 3.15.156. Here are some examples of my pulldata() functions. Example of what I see when I open a brand new form; notice no registration has been entered, yet information is showing up from the linked CSV: I am baffled... I've reviewed the documentation and think I am doing this properly based on that. Any advice would be appreciative. Previously this survey was using pulldata functions with a CSV stored in the media folder. The goal of using external content hosted in AGOL was to eliminate the requirement to republish the survey form when the CSV content changes. It worked perfectly that way... Thank you,
... View more
09-12-2022
10:45 AM
|
1
|
2
|
1371
|
|
IDEA
|
We are using a sidecar to display a series of images. We'd like to add image captions, however can not determine how to do this. We could add a caption to the text of the sidecar, but this is not ideal. The "Attribution" text shows the 'info' icon, and this could also work but again is not ideal. Below is a description of what we are trying to accomplish: My intention with this story map is to tell a friendly, nontechnical story about the importance of Pollinators and, as is, the narrative reads very simply and nicely, free of scientific lingo. However, while the images show examples of the narrative (pollinators and pollinator gardens, etc), the narrative does not explain what appears in the images. While reviewing the draft, I realized that captioning the photos with common and scientific names of the flora and fauna would greatly enhance the educational value, for those readers interested in knowing more about pollinators (and gardens), without disrupting the flow of the narrative for those who wish to casually just read a nice story about pollinators. It seems, a small strip or corner of the image where I could float an explanatory bit of 'Latin' (names, etc, of less than 8-10 words in total) would be ideal for this purpose. See bolded area above for proposed idea to enhance the ability to add captions to images within a sidecar.
... View more
09-07-2022
12:47 PM
|
16
|
11
|
4151
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 09-06-2022 09:14 AM | |
| 6 | 10-24-2024 12:04 PM | |
| 1 | 04-28-2021 09:14 AM | |
| 3 | 09-06-2022 11:53 AM | |
| 1 | 01-17-2024 05:18 AM |
| Online Status |
Offline
|
| Date Last Visited |
02-14-2025
01:16 PM
|