Append_management string equivalent for a boolean field

[AllanAxon]

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?

Thanks,

Allan

[DarrenWiens2]

Is the data type of your field truly "Boolean" or perhaps a 1-digit integer or a text field? I don't see Boolean listed as a valid ArcGIS data type.

[AllanAxon]

My data type in SQLServer (destination) is bit, not null. In the Excel sheet (origin) it's either "TRUE" or "FALSE"

[DanPatterson_Retired]

nor here...

http://desktop.arcgis.com/en/desktop/latest/analyze/arcpy-classes/field.htm

[AllanAxon]

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.