Missing field in csv

TinaGrant · ‎10-13-2015

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?

RebeccaStrauch__GISP · ‎10-13-2015

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

View solution in original post

DanPatterson_Retired · ‎10-13-2015

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

RebeccaStrauch__GISP · ‎10-13-2015

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

DanPatterson_Retired · ‎10-13-2015

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

TinaGrant · ‎10-13-2015

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.

DanPatterson_Retired · ‎10-13-2015

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

RebeccaStrauch__GISP · ‎10-13-2015

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.

RebeccaStrauch__GISP · ‎10-13-2015

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

TinaGrant · ‎10-13-2015

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.

DarrenWiens2 · ‎10-13-2015

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