1

I imported a csv file and converted it to gdb format, and now I want to export it back to csv.

The file will be the exact same as before I imported it, except I want to keep the ArcMap generated OID.

However, when I export the file to csv, the OID field is lost, and contains null values only.

I understand why this is the case, because the OID is a temporary variable I guess.

Is there anything I can do to keep it though? Perhaps duplicate the field, but I am not sure how to do that in ArcMap.

  • Please be more specific about your problem. You imported a csv file and converted to gdb-format? Can you explain this further? And do you want to export the complete gdb to csv or just a feature in it? – Stefan Dec 23 '15 at 10:36
3

If I understand you correctly, you want to keep the OID field. That should be simple, open attribute table, click on Add Field, name this new field for example OID_1, choose type (short integer or long integer for many features), and then use Field calculator.

enter image description here

The equation will be OID_1 = [OID]. After you click OK, it will copy OID values into OID_1. When the export is done, the field should be accessible.

| improve this answer | |
  • Ah perfect, thank you! The only thing I had to do differently was to choose the long integer option, because I have 100,000 OID's, as the short integer ID created errors. – Kelly Dec 23 '15 at 10:57

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.