BLOG
|
嗨Uri !伟大的工具,谢谢你有办法export selected records or records based on a particular attribute from a hosted feature layer?
... View more
a month ago
|
0
|
0
|
160
|
POST
|
Had the same issue, just confirming that removing the join layers works as well. Thanks mate
... View more
10-17-202201:52 PM
|
0
|
0
|
76
|
POST
|
The "magic flag" is the same as above -- I added this and it works now. Just always add this I guess. , allow_members_to_edit=True
... View more
01-04-202209:36 AM
|
0
|
0
|
1229
|
POST
|
Hi all Did you ever get this figured out? I seem to be experiencing a similar issue. I have a link in a label for one question in Survey123 Connect - works fine when published. I have another link in another question's label - nothing happens when clicked. I have tried moving it to the hint, same result. I have verified the html. The problematic question is of the "file" type. Thanks!
... View more
11-04-202104:10 PM
|
0
|
0
|
253
|
POST
|
嗨,保罗,但我不确定如果你解决你的问题have a script that does exactly what you are trying to accomplish Let me know if you have any questions (in my case I had to filtered for start and end dates but you can remove that) def main(): import arcpy from arcpy import da import os inTable = "Database Connections\\DATABASENAME@DIRECTCONNECT.sde\\coa_working.COA_GIS.Parcels_point_edit_assessor__ATTACH" ##inTable=arcpy.GetParameterAsText(0) fc = "Database Connections\\DATABASENAME@DIRECTCONNECT.sde\\coa_working.COA_GIS.Parcels_point_edit_assessor" ##fc = arcpy.GetParameterAsText(1) fldRelatedInfo = 'PARCELID' # should be valid column in FC ##fldRelatedInfo = arcpy.GetParameterAsText(2) fileLocation = "d:\\temp\\assessor\\Attch_input" ##fileLocation = arcpy.GetParameterAsText(3) ##print fileLocation #dStartDate = arcpy.GetParameterAsText(4) dStartDate = '10/01/2019' #dEndDate = arcpy.GetParameterAsText(5) dEndDate = '03/15/2020' expresDate = "[last_edited_date]>='" + dStartDate + "' and [last_edited_date]<'" +dEndDate + "'" print expresDate ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ## ##Sterp 1: ## ##Query records that are between the selected dates ## print "Entering FC search records between dates" ## ##expresDate = "[PicTaken] = 'Yes' and [last_edited_date]>='" + dStartDate + "' and [last_edited_date]<'" +dEndDate + "'" ## print expresDate with da.SearchCursor(fc, ['GlobalID', 'PARCELID'],where_clause=expresDate) as cursor: NewRec = [] multipleVals = {} rowcountNewRec = 0 for item in cursor: ##Initial counter ##print item[0] tmf = {item[0]:item[1]} multipleVals.update(tmf) NewRec.append(item[0]) rowcountNewRec = rowcountNewRec+1 print len(NewRec) ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ##Sterp 2: ##Query records from the attached table that matches the previous selection print "Entering Attachment Searchcursor" ##Search from the attachment table for itemAttch in multipleVals: ##print "--------------- " + itemAttch + " ---- " + multipleVals[itemAttch] attExpression = arcpy.AddFieldDelimiters(inTable, 'REL_GLOBALID') + " = '{0}'".format(itemAttch) print attExpression with da.SearchCursor(inTable, ['DATA', 'ATT_NAME', 'ATTACHMENTID', 'REL_GLOBALID'], where_clause=attExpression) as cursor: filesNew = [] rowcount = 1 for item in cursor: ##Initial counter relOID = item[3] print relOID ##Check to see if the selected records in the List created from the date range if relOID in NewRec: print "We found a new picture -- " + relOID else: print "-- Not relevent" ##print rowcount ##Check to see if the record already has a picture, if it does find the # and assigned the if relOID in filesNew: filesNew.append(relOID) iCount = filesNew.count(relOID) rowcount = iCount else: rowcount = 1 filesNew.append(relOID) # access related information... Choose Geocode or parcelid???? print "looking for related info" ##myRelatedInfo = QueryRelatedData(fc, fldRelatedInfo, relOID) myRelatedInfo = multipleVals[itemAttch] print "****** " +myRelatedInfo attachment = item[0] filename = myRelatedInfo + "-0" + str(rowcount) + ".jpg" ##filenum + str(item[1]) print filename ##Save JPG in a folder open(fileLocation + os.sep + filename, 'wb').write(attachment.tobytes()) print "File has been created" del filename del attachment if __name__ == '__main__': main() ##~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ should return something like this (PARCELID-XX.jpg) XX=number of attachments)
... View more
10-14-202102:42 PM
|
0
|
0
|
152
|
POST
|
Thanks, Uri The problem I'm still having is how do I use multiple domains? If Field one has one domain ex: "EV_SRM_COVER_TYPE" and field two has a separate domain listed ex: "EV_SAF_COVER_TYPE" in GDB. Field 1 = !SRM_COVER_TYPE! Field 2 = !SAF_COVER_TYPE! the result is still 000-111 after I concatenate but I need the descriptions instead of the code
... View more
10-01-202110:19 AM
|
0
|
0
|
291
|
POST
|
Hi Uri I published the survey again, but it didn't solve the problem. The user can see the data, but the Analyze option still returns an error. The survey was created from an existing feature service with a related table. I checked another survey that was created in the same way and the user encountered the same problem with analyzing the data. I then shared a survey created from a feature service w/o a related table, and the user could open the Analyze tab and see the data. I noticed that data from related tables don't behave the same way as data from feature services on the Survey123 website. For example, I can't include photos in reports from related tables.
... View more
10-01-202110:09 AM
|
0
|
0
|
395
|
POST
|
Hi Uri, Many thanks for your thoughtful, detailed reply. Your question: 'Can you see both old and new survey folders in your My Survey Design folder' is illuminating. Indeed I see what I believe are both. The old survey form, however, has a different name (Form 1) than the survey listed in survey123.arcgis.com. "Form 1" does appear fine in Connect. Foolishly, it seems I was just looking for the wrong thing! Best, David
... View more
09-29-202107:35 AM
|
0
|
0
|
292
|
POST
|
Hi @BenWan, Use the substring function: substr(${ Site_Name },0,10). If it doesn't work in the instance_name create a new question in the main form and feed it to the instance_name. Hope this helps, Uri If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.
... View more
08-01-202105:31 PM
|
1
|
0
|
380
|
POST
|
Hi @PrachiPatel, If you know your reviewers' usernames you can apply the solutions above, where you 'lock/read only' the survey to the public, but keep it editable to those on your permitted csv list. If all your reviewers have something in common, e.g. the same email suffix or an xxx_yourcompany format at the end of their Esri username, you can set a read only calculation that limits editing based on that. For example, if email field has @yourcompany.com then readonly = 'no', otherwise readonly='yes'. Public can then still open submitted surveys but won't be able to edit (use the trick with the dateCreated field as shown above). Note that this will only work on the mobile app, not the web version. Another solution which I think will be easier to manage is to just create a new, duplicate survey (submitting to the same layer or a view layer), where you can define completely different Inbox/Sent, submission, and viewing rules. If this answer solved your question or if you found it helpful please mark it accordingly to help others who have the same question.
... View more
08-01-202105:04 PM
|
1
|
0
|
1556
|
Title | Kudos | Posted |
---|---|---|
1 | 08-01-202105:04 PM | |
1 | 09-30-202106:22 PM | |
1 | 09-29-202110:46 PM | |
1 | 09-28-202104:46 PM | |
2 | 04-12-202109:56 PM |
Online Status |
Offline
|
Date Last Visited |
06-05-202205:38 PM
|