I am using a python script we already have to import data from Excel to a geodatabase table. The field is now a boolean in the table and I'm using: listed \"listed\" true true false 50 Text 0 0 ,First,#,c:\\temp\\agol.csv,listed,-1,-1;
The error I get is: "ExecuteError: ERROR 001156: Failed on input OID -1, could not write value 'False' to output field listed
I think I need to change my field mapping to: listed \"listed\" true true false 50 Boolean 0 0 ,First,#,c:\\temp\\agol.csv,listed,-1,-1; but that still gives the same error. What are the valid field types that go in this position of a field mapping string?
The field type in SQLServer is a bit field. I got by this problem by converting all the False values in the spreadsheet to 0 and the Trues to 1 and reading them as text. Will have to look at the design of the table for a long term fix.