topic Missing field in csv in ArcGIS Pro Questions

Missing field in csv

TinaGrant — Tue, 13 Oct 2015 23:23:59 GMT

I have a table saved to a .csv in LibreOffice. When I add the table to ArcMap, the last field is missing. The whole column just...gone. Suggestions?

Re: Missing field in csv

DanPatterson_Retired — Tue, 13 Oct 2015 23:46:18 GMT

perhaps you could paste a portion of the file to facilitate an answer, although I think one of the rules for importing csv files has been broke

Table To Table—Conversion toolbox | ArcGIS for Desktop

Re: Missing field in csv

RebeccaStrauch__GISP — Tue, 13 Oct 2015 23:50:33 GMT

As Dan mentioned, a screenshot at least would help, but is the last column by any chance very long text, so it wants to create it as a BLOB? I know I used to have issues with that. But I think that was pre 10.2.2

Re: Missing field in csv

DanPatterson_Retired — Tue, 13 Oct 2015 23:57:38 GMT

true...you might want to look at the field mapping documentation as well Attribute field mapping—ArcGIS Pro | ArcGIS for Desktop

Re: Missing field in csv

TinaGrant — Wed, 14 Oct 2015 00:05:26 GMT

I haven't even gotten as far as converting the csv to a table: the last column isn't there when I just add the table to the map.

I'm not sure that a screenshot would help, since all you'd see is a column that isn't there. It's a very small table: 423 rows and 6 columns. The missing column consists of 6- or 7- digit integers, as is the column immediately to its left, which *does* show up.

Re: Missing field in csv

DanPatterson_Retired — Wed, 14 Oct 2015 00:07:50 GMT

It is the field names ... if it begins with a number put a letter in front of the numbers...if memory serves a field name cannot begin with a number

just copy the field names. Also, make sure there are no blanks in the first X rows

Re: Missing field in csv

DarrenWiens2 — Wed, 14 Oct 2015 00:10:41 GMT

Can you upload, at the very least, the first two rows (header and first row of data) of your CSV file?

Re: Missing field in csv

RebeccaStrauch__GISP — Wed, 14 Oct 2015 00:11:20 GMT

a good way to test this is to rearrange the columns. Also, add another field and ad bogus data and/or duplicate another column.

Recommend making a backup of you file first....just in case.

Re: Missing field in csv

RebeccaStrauch__GISP — Wed, 14 Oct 2015 00:12:38 GMT

oh...and no spaces in the column names either.....put a _ between words if needed.

Re: Missing field in csv

TinaGrant — Wed, 14 Oct 2015 00:13:43 GMT

Yeah, I thought of that...I did change the field names so they all start with letters.

It's not reading the first row in as field names either, though; the names default to Field1,2 and so on. I'm thinking this may have something to do with LibreOffice specifically. Unfortunately I don't have Excel so I can't just convert to .xls.

Re: Missing field in csv

TinaGrant — Wed, 14 Oct 2015 00:19:24 GMT

Nothing fancy here, just integers and text.

Re: Missing field in csv

RebeccaStrauch__GISP — Wed, 14 Oct 2015 00:22:31 GMT

You can't copy it to an xls, but do you have any other options? .dbf or a true .csv ?

Re: Missing field in csv

TinaGrant — Wed, 14 Oct 2015 00:30:22 GMT

And there it is...I opened and saved the file as a .csv with Notepad++. Added it to the map, and the missing column appeared! Thanks for the help

Re: Missing field in csv

NeilCurri1 — Wed, 27 May 2020 21:07:54 GMT

I was having this maddening problem as well and did the same workaround. Exported CSV from MS Access. Excel wouldn't see this column. ArcMap wouldn't see this column. Finally, I opened up the exported CSV in Notepad and saved it as a CSV again from Notepad with another file name and ArcMap saw my missing column.