topic Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors in Python Questions

Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Sat, 11 Dec 2021 11:53:00 GMT

I am attempting to create a .dbf or geodatabase table from a csv. At first i attempted to just use the 'Table to Table' tool. I set up the field mappings and everything just right but when i run the tool it completes in mere seconds and says it has done so successfully. However, when i attempt to find the output table there is nothing there. I tried to use the 'Excel to Table' tool, same result. I even went so far as to create the table using arcpy and looping through the csv row by row and inserting those rows into the table with an insertcursor. I even had it print each row right before inserting.

the last portion of the code:

readcsv = csv.reader(opencsv)
for row in readcsv:
    if "API" not in row[0]:
        print row
        icursor.insertRow(row)‍‍‍‍‍

a sample of the output:

['5067088870000', '0.000', '30.670', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067065920000', '0.251', '370.725', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067062590000', '0.390', '1021.573', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067062570000', '0.446', '1100.212', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067050960000', '0.131', '952.399', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067088870000', '0.000', '1524.118', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067052140000', '7.215', '5309.192', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067051470000', '0.000', '1051.158', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067052460000', '0.121', '2409.044', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067055830000', '0.000', '3503.423', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067052190000', '0.000', '972.064', 'IGNACIO-BLANCO', 'MESAVERDE']
['5067063900000', '0.476', '1023.767', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']
['5067062600000', '0.121', '4221.302', 'IGNACIO-BLANCO', 'MESAVERDE']‍‍‍‍‍‍‍‍‍‍‍‍‍

Still nothing, the table exists but it is empty. I'm not sure what else i can do to try and get this data into a .dbf or preferably a geodatabase table.

Any help would be greatly appreciated.

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

JoshuaBixby — Tue, 15 Jan 2019 16:57:54 GMT

Data issues are tough to diagnose in forums without sample data. Can you strip down the data set and post it here?

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Tue, 15 Jan 2019 17:06:41 GMT

It is all proprietary, just that bit I showed that was printing is probably too much. I am just confused as to why no errors are being reported but nothing is happening on the output side for two tools and my script.

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

JoshuaBixby — Tue, 15 Jan 2019 17:16:09 GMT

Can you create some fictitious/sample data that replicates the issue? I have used in the past all of the tools you describe to do similar workflows and they worked fine, so it is either something with the data or workflow.

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

DarrenWiens2 — Tue, 15 Jan 2019 17:50:59 GMT

Can you try casting the numerical data to an appropriate numerical data type?

[int('5067088870000'), float('0.000'), float('30.670'), 'IGNACIO-BLANCO', 'PICTURED CLIFFS']

vs.

['5067088870000', '0.000', '30.670', 'IGNACIO-BLANCO', 'PICTURED CLIFFS']

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Tue, 15 Jan 2019 20:41:03 GMT

here is some sample data that i cannot get to create a table either... just drop into notepad or something and save as csv.

API,Oil_EUR_MBBL,Gas_EUR_MMcf
5652846240000,0.000,30.670
5897751350000,0.251,370.725
5984332480000,0.390,1021.573

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Tue, 15 Jan 2019 20:55:13 GMT

I just wrote out what I had written in the console into a python scripts and ran it separately and it worked. Still, 'table to table' does not work for that sample of data i just pasted in my earlier reply

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

DarrenWiens2 — Tue, 15 Jan 2019 21:34:52 GMT

Can you post your entire script? We can't see important parts like how you create your insert cursor or run table to table (don't just include those parts, post the whole thing).

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

DanPatterson_Retired — Tue, 15 Jan 2019 21:50:30 GMT

Put a header row in to define the columns. could be as simple as that

I used your data, added a header/column name row. I used numpy's genfromtext function rather than the python csv module, and got what is needed to make a table (in my case.. NumPyArrayToTable) which can be used in Pro. There are other ways, but sometimes the obvious helps, because I think your data is being assessed in bulk making the lowest data type prevail (text), when I had headers, each Column is looked at for a 'probable' data type and it retained the integer, float and string columns

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Tue, 15 Jan 2019 22:16:25 GMT

My script is working fine now. I wrote something to clean up the csv (remove commas from numbers, etc) and then included more arguments when adding fields to my created table (precision, etc) and that did the trick. However, the GUI toolbox 'table to table' tool on the same cleaned up csv exporting to the same geodatabase is not creating any output. So, at this point it doesn't really matter to me all that much but people I work with I'm sure would like to be able to use that tool. So if anyone has any insight on that I would be interested to hear it.

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

JoshuaBixby — Sat, 11 Dec 2021 11:53:03 GMT

I took your four lines, header and three rows of data, and put them in a CSV file on the file system. I then ran the following code:

import arcpy

csv =  # path to csv file
out_path = arcpy.env.scratchGDB
out_name = 'sample'

arcpy.TableToTable_conversion(
    csv,
    out_path,
    out_name
)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

It worked fine for me, although it did convert API to a Double, but that could be handled in a field mapping.

What version of ArcGIS Desktop or Pro are you using?

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

BrandonZaitz — Tue, 15 Jan 2019 23:13:56 GMT

Yeah, it runs when I call the function in python essentially in a near identical fashion as you did above. However, using the GUI with the same inputs still yields no new table. Very odd. Im running version 10.6.1.9270.

Re: Table to Table Not Creating Output Table But Also Not Failing or Reporting Any Errors

JoshuaBixby — Tue, 15 Jan 2019 23:29:17 GMT

What does the code snippet generated from the GUI look like? Maybe the GUI is passing an argument incorrectly.