Error message even though script finishes with expected results.

[AlexGray]

I am working on a script trying to plot lines from csv point data file..
It all seems to work until the end where I get an error stating that the table is not found..

when I open the FC in the map view, I see that I am getting the result I was expecting..

any help would be greatly appreciated..

here is the error...

Traceback (most recent call last):   File "C:\temp\GIS_projects\Sample_tripData\test.py", line 27, in <module>     "TELATDD","GEODESIC","TRIPSEQNUM")   File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 2913, in XYToLine     raise e ExecuteError: ERROR 999999: Error executing function. The table was not found. [trip_lines] Failed to execute (XYToLine).

here is my code..

# Import system modules import arcpy print "importing modules and set environment...." from arcpy import env env.workspace = "c:/temp/gis_projects/sample_tripdata/test.gdb" fc = "trip_lines" #overwrite pre-existing files arcpy.env.overwriteOutput = True  # Set local variables print "setting data input and output variables..." input_table = "C:/temp/GIS_projects/Sample_tripData/A6_TEMP_ATL_TRIP_HAULx.csv"  # check to see if FC exists, if so, delete. if arcpy.Exists(fc):     print "trip_lines exists..."     print "deleting trip_lines..."     arcpy.Delete_management(fc)     print "trip_lines deleted..."  out_lines = "C:/temp/GIS_projects/Sample_tripData/test.gdb/trip_lines"  #XY To Line print "running XY to Line Geoprocesseing tool..." arcpy.XYToLine_management(input_table,out_lines,                          "TSLONGDD","TSLATDD","TELONGDD",                          "TELATDD","GEODESIC","TRIPSEQNUM") 

[Anonymous User]

Your code looks good to me...I am guessing there is something wrong with your path. When you set your environment, you have the some things capitalized...But then when you have your table path the capitalization does not match...Case matters in Python. Is this supposed to be lowercase?

# Import system modules
import arcpy
print "importing modules and set environment...."
from arcpy import env
env.workspace = "c:/temp/gis_projects/sample_tripdata/test.gdb"
fc = "trip_lines"
#overwrite pre-existing files
arcpy.env.overwriteOutput = True

# Set local variables
print "setting data input and output variables..."
input_table = "C:/temp/GIS_projects/Sample_tripData/A6_TEMP_ATL_TRIP_HAULx.csv"

# check to see if FC exists, if so, delete.
if arcpy.Exists(fc):
    print "trip_lines exists..."
    print "deleting trip_lines..."
    arcpy.Delete_management(fc)
    print "trip_lines deleted..."

out_lines = "C:/temp/GIS_projects/Sample_tripData/test.gdb/trip_lines"

#XY To Line
print "running XY to Line Geoprocesseing tool..."
arcpy.XYToLine_management(input_table,out_lines,
                         "TSLONGDD","TSLATDD","TELONGDD",
                         "TELATDD","GEODESIC","TRIPSEQNUM")

I would double check the paths to make sure you have it capitalized correctly. Also, I find that it is easier to specify your paths this way:

r'G:\PROJECTS\Cedar\GeneralScripts\PyLibrary'

By inserting the "r" in front of single/double quotes, you can cast it as a raw string. When you do this you do not have to worry about escape characters and shortcuts. You can simply copy and paste the path inside the r' ' and you don't have to worry about changing your backslashes to double backslashes or forward slashes.

[RhettZufelt]

Not sure, but could be due to not using "pytonic" paths.

try: 

out_lines = r"C:\temp\GIS_projects\Sample_tripData\test.gdb\trip_lines"

or

out_lines = "C:\\temp\\GIS_projects\\Sample_tripData\\test.gdb\\trip_lines"

R_

[T__WayneWhitley]

You've already set the workspace you intend to write your output to which you named with your variable 'fc'... So 'output_lines' is redundant.
Should be able to get rid of the line where you set the 'output_lines' variable; simply substitute fc...like so:

arcpy.XYToLine_management(input_table, fc, ....etc., etc....)

...and ditto what Rhett said about pathnames.

Enjoy,
Wayne

[AlexGray]

Well, I've made the changes to the script that @Zufelt and @Wayne have mentioned..

Yet, I am still getting an error.. this time says "Cannot create Featureclass TripLines"

Could it be that I'm not specifying the license?

here is the error message...

Traceback (most recent call last):
  File "C:\temp\GIS_projects\Sample_tripData\test.py", line 20, in <module>
    arcpy.XYToLine_management(input_table,fc,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 2913, in XYToLine
    raise e
ExecuteError: ERROR 000206: Cannot create FeatureClass tripLines
Failed to execute (XYToLine).

here is my modified code...

# Import system modules
import arcpy
from arcpy import env

print "importing modules and set environment...."

#overwrite pre-existing files
arcpy.env.overwriteOutput = True

#set workspace
env.workspace = "c:\temp\gis_projects\sample_tripdata\test.gdb"
fc = "tripLines"

# Set local variables
print "setting data input and output variables..."
input_table = r"C:\temp\GIS_projects\Sample_tripData\A6_TEMP_ATL_TRIP_HAULx.csv"

#XY To Line
print "running XY to Line Geoprocessing tool..."
arcpy.XYToLine_management(input_table,fc,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")

# Process to delete identical line features...
# Set the field upon which the identicals are found
fields = "Shape;TRIPSEQNUM;Shape_Length"

# Set the XY tolerance within which to identical records to be deleted
xy_tol = "0.0002 Miles"

# Set the Z tolerance to default
z_tol = "0"

print "Deleteing identical features..."
# Execute Delete Identical 
arcpy.DeleteIdentical_management(fc, fields, xy_tol, z_tol)

print "Dropping leading character..."

cursor = arcpy.UpdateCursor(fc)
field = "TRIPSEQNUM"
row = cursor.next()
while row:
    # set value of field to only those values after the zero value location
    # I want to strip off the first character within the value of the field
    row.setValue(field, row.getValue(field)[0:])
    cursor.updateRow(row)
    row = cursor.next()

del fc, input_table, row, cursor, out_lines, input_table, field

print "Processing Complete!"

[T__WayneWhitley]

Apply the pathname convention to all your pathnames -- your workspace var pathname is wrong because "\t" is interpreted by python as a tab, see the test below, the 'jump' after the colon and again at the gdb name - this is invalid:

>>> testPathname = "c:\temp\gis_projects\sample_tripdata\test.gdb"
>>> print testPathname
c: emp\gis_projects\sample_tripdata est.gdb
>>> 

Almost had it, try again!

The difference with 'r':

>>> testPathname = r"c:\temp\gis_projects\sample_tripdata\test.gdb"
>>> print testPathname
c:\temp\gis_projects\sample_tripdata\test.gdb
>>> 

Enjoy,
Wayne

[AlexGray]

@Wayne, thanks.. I tried it both ways.. this time it ran through the process and executed the xytoline_management tool..

I checked the env and it was correct this time.. thanks for the heads up.. :0)

anyways, the tool ran and the csv was converted to lines.. but then it threw another error.. same as the first..

here is the error message...

Traceback (most recent call last):
  File "C:\temp\GIS_projects\Sample_tripData\test.py", line 22, in <module>
    arcpy.XYToLine_management(input_table,fc,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 2913, in XYToLine
    raise e
ExecuteError: ERROR 999999: Error executing function.
The table was not found. [tripLines]
Failed to execute (XYToLine).

here is my new updated code...

# Import system modules
import arcinfo
import arcpy
import sys
if arcpy.CheckProduct("ArcInfo") == "Available":
    print "ArcInfo available, processing script..."
    print "importing modules and set environment...."

    #overwrite pre-existing files
    arcpy.env.overwriteOutput = True

    #set workspace
    arcpy.env.workspace = "c:\\temp\\gis_projects\\sample_tripdata\\test.gdb"
    fc = "tripLines"

    # Set local variables
    print "setting data input and output variables..."
    input_table = "C:\\temp\\GIS_projects\\Sample_tripData\\A6_TEMP_ATL_TRIP_HAULx.csv"

    #XY To Line
    print "running XY to Line Geoprocessing tool..."
    arcpy.XYToLine_management(input_table,fc,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")

    # Process to delete identical line features...
    # Set the field upon which the identicals are found
    fields = "Shape;TRIPSEQNUM;Shape_Length"

    # Set the XY tolerance within which to identical records to be deleted
    xy_tol = "0.0002 Miles"

    # Set the Z tolerance to default
    z_tol = "0"

    print "Deleteing identical features..."
    # Execute Delete Identical 
    arcpy.DeleteIdentical_management(fc, fields, xy_tol, z_tol)

    print "Dropping leading character..."

    cursor = arcpy.UpdateCursor(fc)
    field = "TRIPSEQNUM"
    row = cursor.next()
    while row:
        # set value of field to only those values after the zero value location
        # I want to strip off the first character within the value of the field
        row.setValue(field, row.getValue(field)[0:])
        cursor.updateRow(row)
        row = cursor.next()

    del fc, input_table, row, cursor, out_lines, input_table, field

    print "Processing Complete!"

else:
    print "ArcInfo license not available"
    sys.exit("ArcInfo license not available")

[T__WayneWhitley]

I am not certain, but did notice your spatial reference parameter is not set... you should try specifying that.  Sorry that's all I can think of that looks suspicious to me - oh, and I'd also avoid writing to the temp directory.  The 'table not found' error can be sort of cryptic...
If you are still having difficulty, you can try attaching a portion of your csv (or all if small enough to attach here) and I'll see what I can do with it later, possibly tomorrow...

Enjoy,
Wayne

EDIT
I was curious for you to test something - see what happens if you can specify shapefile output.  This may not be allowed for this tool.  You can set up a different kind of test to see if you can make an event layer out of the point coordinates, then copy to a shapefile... not sure, but if you can do this to create shapefile output but not file gdb output, chances are the spatial reference is problematic.  Again, just guessing without experimenting.

[RhettZufelt]

@Wayne, thanks.. I tried it both ways.. this time it ran through the process and executed the xytoline_management tool.. 

I checked the env and it was correct this time.. thanks for the heads up.. :0) 

anyways, the tool ran and the csv was converted to lines.. but then it threw another error.. same as the first.. 

here is the error message... 

Traceback (most recent call last):
  File "C:\temp\GIS_projects\Sample_tripData\test.py", line 22, in <module>
    arcpy.XYToLine_management(input_table,fc,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")
  File "C:\Program Files (x86)\ArcGIS\Desktop10.1\arcpy\arcpy\management.py", line 2913, in XYToLine
    raise e
ExecuteError: ERROR 999999: Error executing function.
The table was not found. [tripLines]
Failed to execute (XYToLine).

here is my new updated code... 

# Import system modules
import arcinfo
import arcpy
import sys
if arcpy.CheckProduct("ArcInfo") == "Available":
    print "ArcInfo available, processing script..."
    print "importing modules and set environment...."

    #overwrite pre-existing files
    arcpy.env.overwriteOutput = True

    #set workspace
    arcpy.env.workspace = "c:\\temp\\gis_projects\\sample_tripdata\\test.gdb"
    fc = "tripLines"

    if arcpy.Exists(fc):
      arcpy.Delete_management(fc, "FeatureClass")
    featclass = "c:\\temp\\gis_projects\\sample_tripdata\\test.gdb\\tripLines"    # Set local variables
    print "setting data input and output variables..."
    input_table = "C:\\temp\\GIS_projects\\Sample_tripData\\A6_TEMP_ATL_TRIP_HAULx.csv"

    #XY To Line
    print "running XY to Line Geoprocessing tool..."
    arcpy.XYToLine_management(input_table,featclass,"TSLONGDD","TSLATDD","TELONGDD","TELATDD","GEODESIC","TRIPSEQNUM")

    # Process to delete identical line features...
    # Set the field upon which the identicals are found
    fields = "Shape;TRIPSEQNUM;Shape_Length"

    # Set the XY tolerance within which to identical records to be deleted
    xy_tol = "0.0002 Miles"

    # Set the Z tolerance to default
    z_tol = "0"

    print "Deleteing identical features..."
    # Execute Delete Identical 
    arcpy.DeleteIdentical_management(fc, fields, xy_tol, z_tol)

    print "Dropping leading character..."

    cursor = arcpy.UpdateCursor(fc)
    field = "TRIPSEQNUM"
    row = cursor.next()
    while row:
        # set value of field to only those values after the zero value location
        # I want to strip off the first character within the value of the field
        row.setValue(field, row.getValue(field)[0:])
        cursor.updateRow(row)
        row = cursor.next()

    del fc, input_table, row, cursor, out_lines, input_table, field

    print "Processing Complete!"

else:
    print "ArcInfo license not available"
    sys.exit("ArcInfo license not available")

What happens if you make the above change in blue?

If that doesn't work, what happens if you make the changes above in red?

R_

[AlexGray]

I am not certain, but did notice your spatial reference parameter is not set... you should try specifying that.  Sorry that's all I can think of that looks suspicious to me - oh, and I'd also avoid writing to the temp directory.  The 'table not found' error can be sort of cryptic...
If you are still having difficulty, you can try attaching a portion of your csv (or all if small enough to attach here) and I'll see what I can do with it later, possibly tomorrow...

Enjoy,
Wayne

EDIT
I was curious for you to test something - see what happens if you can specify shapefile output.  This may not be allowed for this tool.  You can set up a different kind of test to see if you can make an event layer out of the point coordinates, then copy to a shapefile... not sure, but if you can do this to create shapefile output but not file gdb output, chances are the spatial reference is problematic.  Again, just guessing without experimenting.

Wayne,

As it turns out, the script runs, although I did add the spatial reference.. I looked into the shapefile output.. but it looks as though the tool only outputs a feature class. I think I found the problem though, and it wasn't the script per sa.. I found that some of the entries in the csv file I was using had some empty cells in the data fields I was using. So, the short of it is that I needed to make sure my data was complete and didn't include Null values.. A little embarrassing.. Thanks for your help on this though.. really appreciate the effort.. now I need to figure out how to get it to check for null values..

here is the updated code...

# Import system modules
import arcinfo
import arcpy
import sys
if arcpy.CheckProduct("ArcInfo") == "Available":
    print "ArcInfo available, processing script..."
    print "importing modules and setting environment...."

    #overwrite pre-existing files
    arcpy.env.overwriteOutput = True

    #delete old feature class
    #if  arcpy.Exists("c:\\temp\\gis_projects\\sample_tripdata\\test.gdb\\haulLines"):
        #arcpy.Delete_management ("c:\\temp\\gis_projects\\sample_tripdata\\test.gdb\\haulLines")

    #set workspace
    arcpy.env.workspace = "c:\\temp\\gis_projects\\sample_tripdata\\test.gdb"
    fc = "c:\\temp\\gis_projects\\sample_tripdata\\test.gdb\\haulLines"
    fieldName = "HaulSeqNum"
    
    # Set local variables
    print "gathering input table data...."
    input_table = "C:\\temp\\GIS_projects\\Sample_tripData\\TEST_HAUL_DATA.csv"

    # tool variables
    print "setting up variables for XY to Line management tool..."
    in_table = input_table
    out_featureclass = fc
    startx_field = "DLONGDD"
    starty_field = "DLATDD"
    endx_field = "RLONGDD"
    endy_field = "RLATDD"
    line_type = "GEODESIC"
    id_field = fieldName
    
    print "setting the spatial reference..."
    spatialRef = arcpy.SpatialReference("C:\\temp\\GIS_projects\\Sample_tripData\\TRIPs_GOA_STAT7.prj")
    
    #XY To Line
    print "running XY to Line Geoprocessing tool..."
    arcpy.XYToLine_management(in_table, out_featureclass, startx_field, starty_field, endx_field, endy_field,line_type,id_field,spatialRef)
    # Process to delete identical line features...
    # Set the field upon which the identicals are found
    fields = '"Shape;' + fieldName + ';Shape_Length"'

    # Set the XY tolerance within which to identical records to be deleted
    xy_tol = "0.0002 Miles"

    # Set the Z tolerance to default
    z_tol = "0"

    print "Deleteing identical features..."
    # Execute Delete Identical 
    arcpy.DeleteIdentical_management(fc, fields, xy_tol, z_tol)

    print "Dropping leading character..."

    cursor = arcpy.UpdateCursor(fc)
    field = fieldName
    row = cursor.next()
    while row:
      # set value of field to only those values after the zero value location
      # I want to strip off the first character within the value of the field
      row.setValue(field, row.getValue(field)[1:])
      cursor.updateRow(row)
      row = cursor.next()

    print "Processing Complete!"

else:
    print "ArcInfo license not available"
    sys.exit("ArcInfo license not available")