The article has been updated successfully.Exporting table data to other programs
Occasionally, you need to send the data from the tables in Cartographica to another program. In the 1.1 versions of Cartographica, this can be achieved by using a sequence of procedures depending upon what program you are trying to export to.
All exporting in Cartogaphica is currently done using shape and dbf files. Therefore, to send the data from a layer to another program, you will need to export the data from Cartographica, and then possibly transcode that data into another form before reading it in to your eventual recipient program.
Although this sounds like a roundabout process, it is fairly easy to send data from Cartographica to Excel, Numbers, or any program that is expecting CSV. It is also easy to do and only requires a copy of the free OpenOffice software. This software, available from OpenOffice.org is a free,open source office package that includes spreadsheet, word processor, database and other functionalities. In particular, we will be using the DBF reading capabilities of OpenOffice to translate the data from Cartographica.
- Start by exporting your data from Cartographica using the Export Layer... command, saving the data someplace you will remember.
Cartographica will place in that location a .shp, .dbf, .shx, and .prj file. The key file here is the dbf (or database) file that contains the data. - Next go to OpenOffice and open the dbf file that you just saved. OpenOffice should open this in spreadsheet form, showing all the data in the file
- Now, use the Save As... command to save the file and select the desired output format (usually one of the Excel or comma-separated formats)
And that's it! You now have a new copy of your tabular data that you can import into another program.
