DOC
|
Thank you for the quick response! This widget is incredible. Our office users will greatly appreciate the hover and maybe I can get them from using arcreader.
... View more
05-10-2019
01:23 PM
|
0
|
0
|
7128
|
DOC
|
I have been able to get this work work in Web App Developer locally however when i deploy the widget and try to add as a custom widget into Portal it doesn't respond. Any suggestions? I have added the wabVersion to the manifest.json. Thanks
... View more
05-10-2019
01:00 PM
|
0
|
0
|
7128
|
POST
|
Mine works with a map service. I brought in the map service individual item layer. then enable popup as a custom attribute. it is pretty awesome.
... View more
05-10-2019
09:32 AM
|
0
|
0
|
1099
|
BLOG
|
Hi I know this is an old post. but i was wondering the code above for n in range (1,len(sourceFieldsList)):
updateRow[n] = valueDict[keyValue][n-1]
updateRows.updateRow(updateRow) shows the update.Rows.updateRow(updateRow) as dedented region. but the code in the previous shows it indented. Does this matter in the for loop? will it commit each update. Thanks!
... View more
02-06-2019
09:33 AM
|
0
|
0
|
20545
|
POST
|
Hi Derek, The widget is a close to perfect fit for what I am looking for. I am very new at writing code with the API classes. Can you point me in a direction to find a code snippet that will pull in data from my current map instead of passing thru predetermined data? Thanks!
... View more
10-19-2018
06:23 AM
|
0
|
1
|
1455
|
POST
|
Also i was able to query outside of my application. Directly in the Rest Service fine. It seems to happen in the application itself.
... View more
03-06-2018
05:20 AM
|
0
|
0
|
1235
|
POST
|
Yes i think it is. I have seen this before in sql when converting data in a view. To get past it there I would use a a cast or convert function in the view. i think something simliar would work here. I am asking our programmer if he can add it into our application. Another option that may help you get by would be to add another field and add a letter in the front like S7E054546110. That may help too.
... View more
03-06-2018
05:19 AM
|
0
|
0
|
1235
|
POST
|
I have this issue as well on a SQL Express Database with a text field. did you find a solution or work around?
... View more
03-05-2018
01:24 PM
|
0
|
0
|
1235
|
BLOG
|
No, i run it in python within a edit session. The if check is working great for me and eliminated the crashing. Are you setting your edit session as edit = arcpy.da.Editor(arcpy.env.workspace) edit.startEditing(False, True) edit.startOperation() I had True, True at first and it wasn't working right. The False, True worked better on my versioned database. The one thing i had to do was export the schema i was wanting to update into a temp database then load the data i wanted to compare into it. so the fields i was comparing were exactly the same type, size, etc.
... View more
02-26-2018
10:50 AM
|
1
|
0
|
20545
|
IDEA
|
This seems like it should work but i don't get any results. Is there any other way to see if the replica is invalid? Would i look in the database for just sends or a specific statement? Thanks
... View more
02-12-2018
05:53 AM
|
1
|
1
|
2136
|
BLOG
|
Thank you so much. I didn't realize the field types would matter. that is probably the issue. I did run the code as it was and it didn't fail so i think the edits are still less than before. I will try the single field at a time. Thank you so much for your help on this. I refer to this blog a ton and really appreciate the work you put into it and also the quick response with help on this. Thanks again!!
... View more
12-26-2017
10:53 AM
|
0
|
0
|
20545
|
BLOG
|
Thanks the script will work but it still runs through each record and makes a change. I feel so close. i see the keyvalue (updated feature) is being compared in the valueDict (source feature). I feel it is around this section i'm stuck if list(valueDict[keyValue]) <> updateRow[1:22]: # A change has been made to the mailing address, owner names or both changeCnt += 1 Thank you again. Here is what i have. import arceditor import arcpy from time import strftime workspace ="E:\\arcgisserver\\Resources\\Connections\\GIS_SCRIPTINGVS.sde" serviceFC = arcpy.MakeFeatureLayer_management("E:\\arcgisserver\\Resources\\Connections\\GIS_SCRIPTINGVS.sde\\.DBO.ELECTRIC\\.DBO.ServicePoint", "test","LINE_SECTION = 'PRIUG6819'","","OBJECTID OBJECTID VISIBLE NONE;AncillaryRole AncillaryRole VISIBLE NONE;Enabled Enabled VISIBLE NONE;SubtypeCD SubtypeCD VISIBLE NONE;Account_Number Account_Number VISIBLE NONE;SERVICE_MAP_LOCATION SERVICE_MAP_LOCATION VISIBLE NONE;MeterNumber MeterNumber VISIBLE NONE;TRANSFORMER_ID TRANSFORMER_ID VISIBLE NONE;MAP_NO MAP_NO VISIBLE NONE;LINE_SECTION LINE_SECTION VISIBLE NONE;SUBSTATION SUBSTATION VISIBLE NONE;FEEDER_NUMBER FEEDER_NUMBER VISIBLE NONE;SERVICE_STATUS SERVICE_STATUS VISIBLE NONE;Service_Number Service_Number VISIBLE NONE;CC_Number CC_Number VISIBLE NONE;NAME NAME VISIBLE NONE;SERVICE_ADDRESS SERVICE_ADDRESS VISIBLE NONE;SERVICE_ADDRESS2 SERVICE_ADDRESS2 VISIBLE NONE;CITY CITY VISIBLE NONE;STATE STATE VISIBLE NONE;DESCRIPTION DESCRIPTION VISIBLE NONE;DateModified DateModified VISIBLE NONE;InstallationDate InstallationDate VISIBLE NONE;Comments Comments VISIBLE NONE;ServiceCurrentRating ServiceCurrentRating VISIBLE NONE;LoadManagement LoadManagement VISIBLE NONE;MISC_CHAR_1 MISC_CHAR_1 VISIBLE NONE;MISC_CHAR_2 MISC_CHAR_2 VISIBLE NONE;OutagePriority OutagePriority VISIBLE NONE;Zip Zip VISIBLE NONE;Detail Detail VISIBLE NONE;KeyAccount KeyAccount VISIBLE NONE;Longitude Longitude VISIBLE NONE;Latitude Latitude VISIBLE NONE;Township Township VISIBLE NONE;Section_ Section_ VISIBLE NONE;T_S T_S VISIBLE NONE;created_user created_user VISIBLE NONE;created_date created_date VISIBLE NONE;last_edited_user last_edited_user VISIBLE NONE;last_edited_date last_edited_date VISIBLE NONE;GlobalID GlobalID VISIBLE NONE;CustomerID CustomerID VISIBLE NONE;StationGuid StationGuid VISIBLE NONE;phaseCode phaseCode VISIBLE NONE;ADD3 ADD3 VISIBLE NONE;ACCTBASE ACCTBASE VISIBLE NONE;PrimaryPhone PrimaryPhone VISIBLE NONE;BusinessPhone BusinessPhone VISIBLE NONE;MobilePhone MobilePhone VISIBLE NONE;CustID CustID VISIBLE NONE;CoopNumb CoopNumb VISIBLE NONE;CISPhase CISPhase VISIBLE NONE;MEDALERT MEDALERT VISIBLE NONE;SHAPE SHAPE VISIBLE NONE") sourceFC="E:\\arcgisserver\\Resources\\ScriptingDB.gdb\\BISRV_BIPERCON" print "Start script: " + strftime("%Y-%m-%d %H:%M:%S") sourceFieldsList = ["BI_SRV_MAP_LOC","SRVADDR1","SRVADDR2","SRVST","SRVCITY","SRVZIP","BUSINESS","HOME","BICUST","MOBILE","BI_FORMAT_NAME","BI_FORMAT_ADDL_NAME","BI_KEY_CUST_CD","BI_ROUTE_CD","BI_OUT_PRI_CD","BI_MED_NEC_CD","BI_SRV_LOC","BI_AR_STAT","BI_ACCT", "BI_MTR_PHS", "BI_TRF_NBR", "BI_MTR_NBR"] edit = arcpy.da.Editor(workspace) edit.startEditing(False, True) edit.startOperation() valueDict = {r[0]:(r[1:])for r in arcpy.da.SearchCursor(sourceFC, sourceFieldsList)} updateFC = "E:\\arcgisserver\\Resources\\Connections\\GIS_SCRIPTINGVS.sde\\GISDBO.ELECTRIC\\.DBO.ServicePoint" updateFieldsList = ["SERVICE_MAP_LOCATION","SERVICE_ADDRESS","SERVICE_ADDRESS2","STATE","CITY","Zip","BusinessPhone","PrimaryPhone","CustID","MobilePhone","NAME","MISC_CHAR_1","KeyAccount","MISC_CHAR_2","OutagePriority","MEDALERT","Service_Number","SERVICE_STATUS","Account_Number", "CISPhase","TRANSFORMER_ID","MeterNumber"] changeCnt = 0 with arcpy.da.UpdateCursor(updateFC, updateFieldsList) as updateRows: for updateRow in updateRows: keyValue = updateRow[0] # verify that the keyValue is in the Dictionary if keyValue in valueDict: # compare record in the dictionary to the existing update table record if list(valueDict[keyValue]) <> updateRow[1:22]: # A change has been made to the mailing address, owner names or both changeCnt += 1 for n in range (1,len(sourceFieldsList)): updateRow = valueDict[keyValue][n-1] updateRows.updateRow(updateRow) print changeCnt # Stop the edit session and save the changes ## edit.stopEditing(True) ## edit.startEditing(False, True) ## edit.startOperation() del valueDict #arcpy.DeleteManagement("test") edit.stopOperation() print "edits complete" # Stop the edit session and save the changes edit.stopEditing(True) arcpy.ClearWorkspaceCache_management() print "Finished script: " + strftime("%Y-%m-%d %H:%M:%S") print "Finished script: " + strftime("%Y-%m-%d %H:%M:%S")
... View more
12-26-2017
08:02 AM
|
0
|
0
|
20545
|
Title | Kudos | Posted |
---|---|---|
2 | 12-05-2022 07:02 AM | |
2 | 03-30-2021 05:40 AM | |
1 | 05-10-2019 01:40 PM | |
1 | 08-04-2020 06:00 AM | |
1 | 04-22-2015 06:10 AM |
Online Status |
Offline
|
Date Last Visited |
Wednesday
|