topic Convert Network Dataset Evaluators from VBA to Python in ArcGIS Network Analyst Questions

Convert Network Dataset Evaluators from VBA to Python

RachelAlbritton — Sat, 11 Dec 2021 08:19:44 GMT

I am working on converting all of the VBA script evaporators from VBA to Python, and for the life of me I can not get it to work. I understand python, but there is an element to using the script elevator this that I am missing/not understanding.

This is an example of the current VBA that works

Dim val

val = 0

if(Edge.AttributeValueByName("network_participating)=0) then

val = -1

Based on this, and this, I came up with the code examples below (along with several others not listed) and nothing is working. What am I overlooking?

def NetworkParticipating(value):
  value = 0
  if Edge.AttributeValueByName(value)== 0:
    value = -1
  return value

Value = NetworkParticipating('!network_participating!')

##Also tried:

def NetworkParticipating(value):
  restricted = False
  if value = 0:
    restricted = True
  return restricted


‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Convert Network Dataset Evaluators from VBA to Python

MelindaMorang — Sat, 11 Dec 2021 08:19:47 GMT

Try something like this.

def NetworkParticipating(network_participating):
  if Edge.AttributeValueByName(network_participating)== 0:
    return -1
  return 0

Value = NetworkParticipating('!network_participating!')‍‍‍‍‍‍‍‍‍‍‍‍

The problem with your attempt was that you were passing '!network_participating!' to the function but then immediately reassigning the variable to something else.

Re: Convert Network Dataset Evaluators from VBA to Python

RachelAlbritton — Sat, 11 Dec 2021 08:19:50 GMT

Thank you for the suggestion Melinda, but it didn't work. I also tried:

def NetworkParticipating(value):
  if Edge.AttributeValueByName(value)== 0:
    restricted = True 
  else:
    restricted = False
  return restricted

Value = NetworkParticipating('!network_participating!')
‍‍‍‍‍‍‍‍
##And I tried

def NetworkParticipating(value):
  if value == 0:
    restricted = True 
  else:
    restricted = False
  return restricted

Value = NetworkParticipating('!network_participating!')‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Re: Convert Network Dataset Evaluators from VBA to Python

MelindaMorang — Thu, 17 Aug 2017 22:15:34 GMT

Let's back up. Can you describe in words what you're trying to do?

Re: Convert Network Dataset Evaluators from VBA to Python

JaySandhu — Thu, 17 Aug 2017 23:14:07 GMT

Going by your original VBA, and what Melinda suggested, try this modification:

def NetworkParticipating(value):
   if Edge.AttributeValueByName( value) == 0:
      return -1
   return 0

Value = NetworkParticipating("network_participating")

Re: Convert Network Dataset Evaluators from VBA to Python

RachelAlbritton — Fri, 18 Aug 2017 14:57:01 GMT

Thanks Jay - That worked. Although I'm a bit perplexed since typically python field names begin and end with '!' and the example of python script evaporators does as well. Any thoughts on this?

Re: Convert Network Dataset Evaluators from VBA to Python

RachelAlbritton — Fri, 18 Aug 2017 14:58:09 GMT

Melinda - You were on the right track - Jay's slight modification to the Value field did the trick. Thank you for your time & input.