How to use Area Names File (.ANM) with data export?

Discussions about tools to complement CSPro data processing
Forum rules
New release: CSPro 8.0
Post Reply
k.t.nguyen@cgiar.org
Posts: 3
Joined: July 10th, 2018, 5:57 am

How to use Area Names File (.ANM) with data export?

Post by k.t.nguyen@cgiar.org »

Hi all,
I have a Area Names File (.ANM) which is used for multiple dictionaries. I want to export data then match province and district codes with the Area Names. I am not sure how to use CSPro tools to export this .ANM file to more readable format? What I've done is cleaning up this file in text editor..Is there other efficient ways in CSPro to do this? Please advise.
Best,
Kien
josh
Posts: 2399
Joined: May 5th, 2014, 12:49 pm
Location: Washington DC

Re: How to use Area Names File (.ANM) with data export?

Post by josh »

There isn't a way in CSPro to export the area names file. It is meant for use within CSPro for tabulation. Usually folks are going the other way - creating a an area names file from an Excel spreadsheet that usually comes from a GIS database. If you remove the top part of the area names file (everything up through [Areas]) so that you just have part with the codes and names and you drag and drop that file into Excel it should put each code into a different column which should be fairly easy to work with.

If you can program Java, I recently wrote a parser in Java for area names files for another project. You can find it here: https://github.com/jhandley/CsPro2Sql/b ... eader.java. I have only tested it on one or two files so it may still have some bugs to work out.
k.t.nguyen@cgiar.org
Posts: 3
Joined: July 10th, 2018, 5:57 am

Re: How to use Area Names File (.ANM) with data export?

Post by k.t.nguyen@cgiar.org »

Thanks Josh!
Post Reply