Latest Contributions by jaykapalczynski

Thanks...for what its worth...not trying to put a check box in a geodatabase field....rather I have a .net form that has a bunch of check boxes on it...right now its feeding a SQL table with a bit field type.  This is being brought into SDE which does not have a specified BIT field type...but short integer should work.....this is what I was getting at... When submit is done on the form I would simply check for checked or not and then apply a 0 or 1 to that short integer field....just a bit more code handling... ... View more

Yup....syntax just the ' on front and backside.....everything seems to be working.....thank you all for your thoughts and pointers....cheers....stay safe ... View more

I think I might have it....I copied the string and remove the ' on the beginning and end and I think I can now pass it as a parameter... Still testing ... View more

One more thing....I am very confused on I can get this to work from running the python script seen below using the dataInputParameter variable ALTHOUGH I am trying to run this from a ESRI tool that passes in a parameter  If I change the below code to accept the dataInputParameter1 variable which is the STRING being passed to it from the ESRI Tool it blows up textDict = json.loads(dataInputParameter1)‍ So I change to the code above Copy the text from the dataInputParameter variable seen below Launch the tool and paste that into the parameter and submit it blows up. BUT as you can see I have a second parameter that returns results....I am returning all 3 Variables seen below...and the ONLY difference is that when I return the 3rd variable (the one that works when I define it) is it missing the single ' on the beginning and end.... QUESTION:  do I need to strip the variable that I am grabbing from the GetParametersAsText????? Why does it work with a manual variable and not the parameter text?   MESSAGE Variable 1:  is the  dataInputParameter1 variable that is created from the string being passed for the Tool  MESSAGE Variable 2:  is the dataInputParameter2 variable simply set form the getParameterAsText variable MESSAGE Variable 3: is the variable that I create with the text seen below...this is ALSO the text that I copy into the string parameter in the ESRI Tool dataInputParameter1 = arcpy.GetParameterAsText(0) dataInputParameter2 = dataInputParameter1 dataInputParameter = '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50", "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20", "id" : "5" }]}' varaddress = "" vardistance = "" varid = "" textDict = json.loads(dataInputParameter) for employee in textDict['employees']: varaddress = employee["address"] vardistance = employee["distance"] varid = employee["id"] print ("address: " + varaddress) print ("distance: " + vardistance) print ("uniqueid: " + varid) print "" msg1 =("MESSAGE Variable 1: " + dataInputParameter1) msg2 =("MESSAGE Variable 2: " + dataInputParameter2) msg3 =("MESSAGE Variable 3: " + dataInputParameter) msg4 = (msg1 + msg2 + msg3) arcpy.AddMessage(msg4) resultMsg = msg4 arcpy.SetParameterAsText(1, resultMsg)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍ Executing: CreateMultiPolyBatch '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50", "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20", "id" : "5" }]}' Start Time: Mon Mar 30 16:08:57 2020 Running script CreateMultiPolyBatch... MESSAGE Variable 1: '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50", "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20", "id" : "5" }]}' MESSAGE Variable 2: '{"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50", "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20", "id" : "5" }]}' MESSAGE Variable 3: {"employees":[{"address":"1520 Split Oak Ln, Henrico, Virginia, 23229","distance":"10", "id" : "1" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"1341 Research Center Dr Blacksburg, VA 24060","distance":"9", "id" : "2" },{"address":"816 W Main St, Danville, Virginia(VA), 24541","distance":"12", "id" : "3" },{"address":"113 Buffalo Rd, Clarksville, Virginia(VA), 23927","distance":"50", "id" : "4" },{"address":"8817 Sherando Dr, Bristow, Virginia(VA), 20136","distance":"20", "id" : "5" }]} Completed script CreateMultiPolyBatch... Succeeded at Mon Mar 30 16:08:57 2020 (Elapsed Time: 0.11 seconds)‍‍‍‍‍‍‍‍‍‍‍‍‍ ... View more

I can get my string to this in python but need to loop through and set each of the items to variables DATA: '{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]} ' JSON: "{\"employees\":[{\"address\":\"113 Buffalo Rd, Clarksville, VA 23927\",\"distance\":\"50\",\"id\" : \"4\"},{\"address\":\"8817 Sherando Dr, Bristow, VA 20136\",\"distance\":\"20\",\"id\" : \"5\" }]} " ENCODED: "{\"employees\":[{\"address\":\"113 Buffalo Rd, Clarksville, VA 23927\",\"distance\":\"50\",\"id\" : \"4\"},{\"address\":\"8817 Sherando Dr, Bristow, VA 20136\",\"distance\":\"20\",\"id\" : \"5\" }]} " DECODED: {"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]} ‍‍‍‍‍‍‍ ... View more

In the original post the first part was in Python the second was in Javascript....that is what I am trying to pass as a parameter to the service and eventually the python scripts Here is an example of a shortened string '{"employees":[{"address":"113 Buffalo Rd, Clarksville, VA 23927","distance":"50","id" : "4"},{"address":"8817 Sherando Dr, Bristow, VA 20136","distance":"20","id" : "5" }]} ' ‍‍‍‍ ... View more

think I got it with this featureLayer.queryFeatures().then(function (results) { featureLayer.applyEdits({ deleteFeatures: results.features }).then(function (results) { alert("Im done and now building the multipart features"); }); });‍‍‍‍‍ ... View more

hmmmm.. I added a ; at the end of appyEdits but no go... featureLayer.queryFeatures().then(function(results){ featureLayer.applyEdits({deleteFeatures: results.features}).then(results){ //do something here }; });‍‍‍‍‍‍‍‍‍‍ ... View more

so the shift+click and ctrl+click would replace the UI buttons?  But with a bunch more code? ... View more

Is there a way to get an alert when the applyEdits is completed or successful?  Want to verify its done and then write to the same FC. ... View more

Perfect ... View more