Latest Contributions by JoeBorgione

@Robert_LeClair  You aren't kidding; that's pretty clunky.  Seems like such a simple setting like 'Use Field Alias' should be there somewhere, but I haven't found it.  You can do that with a table... ... View more

@KatieGodding - I don't see anything that jumps out as a problem with your code as posted. (But you knew that already...) Just as test, can you copy your data to a file geodatabase, make the appropriate adjustments to your code and try it there?  I'm not an Oracle guy so I'm just trying the eliminate or identify the database as the root issue. I notice you are using an input() and it's not complete in you posted code, but I suspect that's just a copy and paste error.  But can you comment that out and hard-code the three different options one at a time? Just one other thing that I see is the optional overlap type: what if you give it the actual 'INTERSECT' key word and see if that makes a difference? Admittedly, I'm grasping at straws here, but these are the things I would do to trouble shoot. ... View more

  (fc, ['OBJECTID_1', week_a, hours_a, week_b, hours_b], "week_a LIKE '%Planned%'")   Then it must be the reference to week_a in your selection statement that's bombing it.  (I didn't notice that). If you are using python 3.x I suggest using an f string like this: (fc, ['OBJECTID_1', week_a, hours_a, week_b, hours_b], f'{week_a} LIKE "%Planned%"') of if you are using python 2.x you'll need to use the format() method: (fc, ['OBJECTID_1', week_a, hours_a, week_b, hours_b], '{} LIKE "%Planned%"'.format(week_a) (Of course these are untested, but I think that'll get you going...)   ... View more

def weekly_update(week_a, hours_a, week_b, hours_b): with arcpy.da.UpdateCursor (fc, ['OBJECTID_1', 'week_a','hours_a', 'week_b','hours_b'] Try removing the quotes around your parameter-variable names. When you enclose them like that the cursor is looking for a field of those names instead of the value of the variables. ... View more

Hmm.  I just upgraded from 2.7.1 to 2.7.2 and grabbed a feature layer from my agol account; it all works for me. What I meant was if the feature you are editing is the source data for a published feature layer, like an enterprise gdb feature class that you published to a portal (including agol)     ... View more

@JayantaPoddar brings up a good point: is this feature published anywhere?  You'd need to shut down the service it is associated with if so... ... View more

What if you put an r in front of that statement like this: r"https://blah/blah.blah/blah/blah.png" I get it to work with or without the r which is basically short for 'raw' text so any escaped characters are taken literally: see this article for a more detailed explanation.  ... View more

Just goes to show what I know about using models... ... View more

Can't you just run the model as a scheduled task without python calling it?  I don't do models, just python so I don't know why it would clobber your model output. ... View more

Did you  do the model to python conversion?  Sometimes that will goof on you..  Perhaps you could post your code using the Insert/Edit Code Sample button after expanding the tool bar above. ... View more

I don't have the luxury of having the man behind the curtain so as a rule I don't do live demos, especially in ZoomLand....   ... View more

Well now it’s working now so I’ll have to wait till it stops working to show you. Another colleague was getting the same behavior but yet for another it worked fine.  Naturally it worked great in the session demos today so I was stoked to give it a try.  ... View more

I've been attending the developers summit yesterday and today, and have learned a ton of Arcade tips and tricks... ... View more