topic Re: Using Export Table for csv in ModelBuilder in ArcGIS Pro Questions

Using Export Table for csv in ModelBuilder

ElizabethOswaldDNR — Tue, 26 Nov 2024 13:40:29 GMT

I have created a model using Modelbuilder and everything works except the very first step- the first input is a csv file and for everything else to happen, I need to convert it and save to the gdb.

When I use Export Table, the step is in color, but at the next step, Sort, there is an error with the input and the popup reads:

Input Dataset (Required)

Error 000339 Input U:\LWCF inspections\11_19\11_19.gdb\responses_ExportTable does not have OIDs. The input dataset with the records that will be reordered based on the field values in the sort field or fields.

This is confusing because through the Export Table tool, the output should have OIDs, and the Sort tool should recognize that it will. If I just run the Export Table tool manually, and the table is saved to the gdb, the rest of the model will work fine, but if I want to begin with the csv itself, the whole model turns gray at the second step (Sort). I would really like to include this step in the model, if possible, just not sure what I'm missing.

Re: Using Export Table for csv in ModelBuilder

DanPatterson — Tue, 26 Nov 2024 13:50:24 GMT

according to the error

000339: Input <value> does not have OIDs.—ArcGIS Pro | Documentation

you could try to use this tool

Copy Rows (Data Management)—ArcGIS Pro | Documentation

Re: Using Export Table for csv in ModelBuilder

ElizabethOswaldDNR — Tue, 26 Nov 2024 14:09:28 GMT

I appreciate your advice! I just tried that and the Sort tool still says that the input (now the output of copy rows) has no OIDs. I have also tried using Iterate Table, Copy Features, and register with geodatabase, but the model still doesn't work starting with the csv.

Re: Using Export Table for csv in ModelBuilder

DanPatterson — Tue, 26 Nov 2024 14:31:54 GMT

is the output from the Copy Rows going to a locally stored geodatabase or somewhere else? I can't tell from the model

Tables—ArcGIS Pro | Documentation

this even suggests using Export Table to control the output location. So perhaps the objectid isn't getting created because of the output location of either tool