Skip to main content
Question

.txt to .dbf (output is corrupted, can't be opened in ArcMap)


Forum|alt.badge.img

Established a workflow to convert address points .txt file to .dbf in order to add x,y point in ArcMap. Was able to do an expression fanout that would classify my address points by province (individual folders), but the output is not readable in ArcMap. Any clues? did I miss a step somewhere? Also, if I choose the reader as an .txt, (my file extension is .txt), the reader fails to read my file, I have to choose .csv instead.... also another thing I don't understand...

2 replies

redgeographics
Celebrity
Forum|alt.badge.img+50

If your text file has data in columns you'll need to use the CSV reader as that is set up to turn those columns into attributes. A CSV is ultimately just plain text (which is why the .txt extension is confusing, but not exactly wrong).

If you have columns with x and y values in your text file you can use a VertexCreator to build points (or tell the CSV reader to treat the x and y values as such so it will build points automatically) and then write out to a Shapefile instead of a DBF, this way it'll probably be easier to open in ArcMap.

Other than that, without seeing your data and workspace it's really hard to say why your DBF can't be opened in ArcMap, if you can share them we may be able to tell you what's up.


Forum|alt.badge.img
  • Author
  • January 28, 2019
redgeographics wrote:

If your text file has data in columns you'll need to use the CSV reader as that is set up to turn those columns into attributes. A CSV is ultimately just plain text (which is why the .txt extension is confusing, but not exactly wrong).

If you have columns with x and y values in your text file you can use a VertexCreator to build points (or tell the CSV reader to treat the x and y values as such so it will build points automatically) and then write out to a Shapefile instead of a DBF, this way it'll probably be easier to open in ArcMap.

Other than that, without seeing your data and workspace it's really hard to say why your DBF can't be opened in ArcMap, if you can share them we may be able to tell you what's up.

very helpful! I will try the VertexCreator way and see if it works, otherwise, I will try to share my data and maybe you can help. cheers!


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings