Latest Contributions by MarcCusumano

Hello, I'm trying to use an UpdateCursor inside of a SearchCursor to populate sequence numbers on an inspection table according to a parcitular UserID. Basically the SearchCursor iterates through a small table with a list of about 29 user ID's (the table changes over time) and uses the values in the where_clause of the updatecursor. The UpdateCursor sorts the order of the input table based on a structure number and populates the sequences from 1 to 0. Here is the code I have tried: techrows = arcpy.SearchCursor(psegGasGDB_InputPrefix + "ASSIGNED_TECHS")  for row in techrows:      if TechID != row.ASSIGNED_USER:          TechID = row.ASSIGNED_USER         where_clause = "ASSIGNED_USER = " + TechID         rows = arcpy.UpdateCursor(CONVERSION_InputPrefix + "CPTestPointInspection", where_clause, "SEQ_NO; GAS_CORR_STRUCT_NO", "GAS_CORR_STRUCT_NO")          for row in rows:              try:                        print row                        stop = 1                        row.SetValue("SEQ_NO", stop)                         stop = stop + 1               except Exception as e:                   print e                   logging.error(": %s" %(e))          del rows     del techrows But this gives an "Error 999999: Index passed was not within the valid range". Can't figure out what I'm doing wrong... ... View more

I'm trying to copy feature from one feature class to another with only certain fields and an SQL query. I can't seem to get the field mappings object to work right. Here is what I have: import arcpy from arcpy import env  arcpy.env.overwriteOutput = True  in_path =r"Database Connections/Sun120 - 5151.sde/CONVERSION." in_feature = "CPTESTPOINTINSPECTION" out_path = r"E:/Rich Anderson/CP_ReChecks/" FileGDBName = "Test.gdb" infc1 = in_path + in_feature  try:       fieldmappings = arcpy.FieldMappings()          fieldmappings.addTable(infc1)      fldmap_READING = arcpy.FieldMap()      fldmap_READING.addInputField(infc1, "READING")     fld_READING = fldmap_READING.outputField     fld_READING.name = "READING"     fldmap_READING.outputField = fld_READING     fieldmappings.addFieldMap(fldmap_READING)                            arcpy.FeatureClassToFeatureClass_conversion(in_path + in_feature, out_path + FileGDBName, "Max_CP_Inspection_Date_Test", " \"READING\" > 85 ", fieldmappings)  except Exception as e:     print e This works but just adds a new field called "READING_1" with all null values to the output feature class along with all of the other fields (including the original "READING" field and its values). How can I get the feature class to feature class tool to only copy the fields I want? I've been at this for over four hours! Thanks... ... View more

I am modifying a model that creates a route for a selection of points, assigns a USER ID from an input box and a sequence number. I need to make a check box that asks if the user would like to solve the route. If the box is not checked, the route is not solved and only the USER ID will be populated, and the sequence number will not be assigned. I have the boolean variable set as a parameter and the model works when it is checked, but when it is unchecked the model will not run. How do I tell the model to skip the solve process and calculation of the sequence number field and move directly to calculating the user ID? [ATTACH=CONFIG]16433[/ATTACH] ... View more

I am trying to get this to work: import smtplib from smtplib import SMTP_SSL as SMTP import datetime HOST = "xxxxxxxx.enterprise.xxxx.com" PORT = 25 FROM = "xxxx.xxxxxxxx@xxxx.com" TO = ["xxxx.xxxxxxxxx@xxxx.com"] SUBJECT = "Test" BODY = "Success" BODY = BODY + "!" smtp = smtplib.SMTP(HOST,PORT) smtp.connect(HOST, PORT) smtp.login("xxxxxx\xxxxx", "xxxxx") smtp.ehlo() smtp.sendmail(FROM,TO,body) smtp.quit() server.set_debuglevel(0) But I keep getting the following error: [Errno 10054] An existing connection was forcibly closed by the remote host Can't see anything obvious I'm doing wrong. Any ideas? Thanks. ... View more