topic Export from ArcGIS Pro to .csv - Need to include the object_id values in ArcGIS Pro Questions

Export from ArcGIS Pro to .csv - Need to include the object_id values

MillieBuckner — Mon, 01 Apr 2024 12:30:22 GMT

Is there a way to include the object_id field when exporting from arcGIS to a .csv file?

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

George_Thompson — Mon, 01 Apr 2024 12:36:46 GMT

Is the data you are exporting part of the geodatabase or just a table in the database?

When you add the table to a map does it ask for you to "assign" an ObjectID (in a pop up window)?

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

MillieBuckner — Mon, 01 Apr 2024 13:09:03 GMT

Is the data you are exporting part of the geodatabase or just a table in the database?

When you add the table to a map does it ask for you to "assign" an ObjectID (in a pop up window)?

Answer: yes, the map asked for the field(s) that would serve as the unique id.

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

MillieBuckner — Mon, 01 Apr 2024 13:58:22 GMT

George,

I am putting a series of screenshots together showing the whole sequence the leads to the loss of the id field. I think I can include a solution. It strikes me as an behavior, so I am wondering if I am creating a problem by making a misstep is how I am working with the product and my data.

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

MillieBuckner — Mon, 01 Apr 2024 14:29:34 GMT

Problem appears when id field is not available for export. why? You have to look at the last image to see it

Table from oracle database being added to map through dbConnection

Data just added to arcgis from an oracle table

Geocoding the addresses

Export geocoding

Picking a folder not in project for saving exported data

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

George_Thompson — Mon, 01 Apr 2024 14:28:07 GMT

Thanks for the info above. I think the issue is that when you add a table not registered with the geodatabase, and you have Pro (ArcGIS) create an ObjectID, it is NOT a field in the table. Pro will create a "virtual" ObjectID field and use that in the client.

Does the source table have an ObjectID field that matches what you see in Pro in Oracle (look using sqlplus)?

If the field does not exist in the Oracle table, then it would not be exported from Pro.

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

George_Thompson — Mon, 01 Apr 2024 14:42:38 GMT

Ok, so it looks like you are exporting the "new" geocoded table. When you geocode a table it creates a new feature class (table).

Not sure why those fields are missing.

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

MillieBuckner — Mon, 01 Apr 2024 17:58:21 GMT

There is a different problem upstream from the export of the geo-coded addresses. arcgis keeps failing when looking at oracle data, because oracle is giving arcgis old data. Here are the steps

1. Make table 001

2. update table 001

3. add table 001 to arcgis pro.

4. The data visible in arcgis is the data that was in the table on step 1, not step 2

To get around this, I have to make table 002 from table 001 after it has been updated, and show arcgis table 002.

Something is wrong with our oracle installation.

Re: Export from ArcGIS Pro to .csv - Need to include the object_id values

DanSadler1 — Wed, 07 Jan 2026 17:57:51 GMT

I found this thread searching on the same issue. For what it's worth, we found a solution not mentioned here. I'll post below in case it's useful to people who surf into this thread:

Under the Fields section of the Export Table window, click the Add Fields dropdown and Add Empty Field
Name the newly added field OBJECTID
Click the pencil icon and define the source of the new OBJECTID field as the OBJECTID virtual field (you can search for the word "object" to find it)

4. As the newly added OBJECTID field is added at the end, click and drag to move it to the top

A CSV exported after following these steps should include a populated OBJECTID field as expected.