I have been trying to import csv files to ArcMap, but it always tells me General function failure! I can't preview them in ArcCatalog either. Neither my original csv files, or those from the training packages. Any advice? I have ArcGIS 10 on my computer.
Yes, and it looks fine (just as it is supposed to look according to the training package). I imagine those from training packages are formed correctly, and I should be able to import/preview those, even if I made a mistake in my own files.
copy and paste a few rows here. We will be looking for field names (the first row) being too long, containing spaces etc. There should be no blank rows and each column should contain the same data type. etc
|Cape Town,-34.026,18.465,South Africa|
ok, if you try to import those 5 rows to using the AddXY data tool, does it fail? It is a comma-separated values file with a , as the separator but it would be nicer if there were spaces after the comma. Make sure it isn't being interpreted as space or space and comma-delimited because of Cape Town which contains a space. If you can read those records as Neil suggested, then the problem is further down. Since you have places north and south of the equator, make sure you add the resultant file to an empty/new dataframe, before defining its coordinate system
I tried using the addXY data tool, but I don't even see the the csv file. When I try to Create a feature class From XY Table, it just tells me There was an error trying to process this table. General function failure General function failure [africa_cities.csv. I tried adding it to an empty data frame, still doesn't work.
I must stress again that this is a csv file from the online ESRI training course. I can open it in Notebook and it looks fine, but I can't preview it in ArcCatalog or import it in any way to ArcMap.
If you go to your table of contents, and right-click on a new dataframe's title, and select Data, addXY data. It doesn't work? It is stored on a local drive and not a usb drive or inside a zip file I assume as well.
last try... does the file have a *.csv file extension? try renaming it to *.txt or *.csv. I haven't seen a file that can't be seen unless it doesn't have a file extension or it has the wrong type of extension regardless of file contents.