Latest Contributions by DannyLackey

SUCCESS!  I used the schema.ini example you just posted changing ONLY TabDelimited to CSVDelimited.  Thank you! ... View more

Well, my actual csv file is comma delimited.  The sample I posted here I opened in excel and copied and pasted a table-like structure.  Should it read Format=CommaDelimited? ... View more

Did you run it with column names like: Col1=A Long or Col1=X Double  ?  Wondering what you may have done differently. ... View more

You can get it to run programmatically as well? ... View more

Changed to: [test.csv] ColNameHeader=True DateTimeFormat=dd-MMM-yyyy Format=CSVDelimited Col1=X Long Col2=Y Long Col3=START_DTTM DateTime Col4=END_DTTM DateTime Col5=Value Double Still failed... ... View more

Here is a sample of my data:      X Y START_DTTM END_DTTM Value 1468050 750150 1/7/2016 1/31/2016 0.13237318 1468100 750150 1/7/2016 1/31/2016 -0.60834539 1468150 750150 1/7/2016 1/31/2016 -0.17450202 1468200 750150 1/7/2016 1/31/2016 -0.34773338 1467700 750100 1/7/2016 1/31/2016 -0.19723971 1467750 750100 1/7/2016 1/31/2016 0.16580771 ... View more

Well no, that's something else I grabbed from the example.  It said you should copy that as is....  ay ay ay.  Ok, so A, B, C etc, represents the actual column names...  ?  I'll try that and report back. ... View more

I just grabbed that directly from the example.  I thought about just removing it altogether and let it carry over the date as is, but figured I'd leave it in just in case.  ... View more

Something isn't working... So, after having created the Schema.ini file containing this info: [test.csv] ColNameHeader=True DateTimeFormat=dd-MMM-yyyy Format=CSVDelimited Col1=A Long Col2=B Long Col3=C DateTime Col4=D DateTime Col5=E Double My conversion script is suddenly failing.  As soon as I remove this Schema.ini file, it runs fine.  Guessing there is something wrong with my Schema.ini file.  Is it clear where I went wrong?  It's in the same directory as the csv. ... View more

Ok, I found this example here:  Does this method apply in my situation?  http://stackoverflow.com/questions/12259562/how-can-i-create-schema-ini-file-i-need-to-export-my-csv-file-to-datagridvie… ... View more

Ok.  My schema.ini file was created when I made a connection to my .csv file in Toad.  After looking at this file, I'm thinking it's not what I'm after.  Can you explain how you created your schema.ini file to suit your needs?  ... View more

Ok.  I have a schema.ini file.  Do I need to point the script to that file in some way or does it simply need to be present in the same directory as the script or output? ... View more

This is related to the same effort, but specifically to the output...  If need to start a new post, let me know... In the resulting .dbf file, its creating a decimal with trailing zeroes: 750050 becomes 750050.00000000000 How can I avoid this? ... View more

Thank you.  I got it working.  I had a few things wrong. Here is my new WORKING code: import arcpy from arcpy import env env.workspace = r"C:\test" inTable = r"C:\test\test.csv" outLocation = r"C:\test\output" outTable = "test.dbf" arcpy.TableToTable_conversion(inTable, outLocation, outTable) ... View more