topic Re: Append_management string equivalent for a boolean field in Developers Questions

Append_management string equivalent for a boolean field

AllanAxon — Mon, 10 Aug 2015 15:32:30 GMT

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

Re: Append_management string equivalent for a boolean field

DarrenWiens2 — Mon, 10 Aug 2015 16:29:25 GMT

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.

Re: Append_management string equivalent for a boolean field

DanPatterson_Retired — Mon, 10 Aug 2015 16:49:18 GMT

nor here...

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

Re: Append_management string equivalent for a boolean field

AllanAxon — Mon, 10 Aug 2015 16:51:17 GMT

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

Re: Append_management string equivalent for a boolean field

AllanAxon — Mon, 10 Aug 2015 19:08:27 GMT

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.