topic Re: Can you add a field to a table view? in Python Questions

Can you add a field to a table view?

KarlWilson — Tue, 09 Oct 2012 09:27:37 GMT

The documentation for the AddField_management tool implies that it will accept a Table View as an input data type. Whenever I try to add a field to a Table View however I get the message:
"ERROR 000499: table is not editable Failed to execute (AddField)."

Re: Can you add a field to a table view?

ChristopherThompson — Tue, 09 Oct 2012 14:59:50 GMT

What is the source of the table? If its an SDE table maybe the connection string you are using doesn't allow for editing?

Re: Can you add a field to a table view?

KarlWilson — Wed, 10 Oct 2012 06:02:05 GMT

It's an excel spreadsheet.
I guess the table view is just that then, a view of the data. I had conceived it more as an "in-memory" copy, and therefore editable.

Re: Can you add a field to a table view?

MarcinGasior — Wed, 10 Oct 2012 08:04:41 GMT

You can't edit connected Excel spreadsheet, the same as it's not possible to edit XY Event Layer table of attributes.

But you can use Copy Rows to copy the spreadsheet content into in_memory workspace (Output table = in_memory\worksheet_table). Then you can add fields to this temporary table.

Re: Can you add a field to a table view?

ChristopherThompson — Wed, 10 Oct 2012 10:40:16 GMT

ah yeah.. excel... that beast we love to hate..

Re: Can you add a field to a table view?

JamesCrandall — Wed, 10 Oct 2012 10:47:40 GMT

You can edit an Excel spreadsheet, but it will have to be done with another Py lib that is capable of such a thing. A quick search on Stackexchange turns up a lot of solutions, maybe have a look at http://pypi.python.org/pypi/xlrd

Just fyi: I have had a lot of success implementing additional libaries like this. cx_Oracle python lib has been a great tool to integrate non-spatial data that is maintained in our Oracle database(s)!

Good luck!