updated: 23-Jan-2012

 Copan Lite

Import and Export

Contents
  1. Importing and Exporting Text Files
  2. Importing Copan Coordfiles
  1. Exporting to Total Station Files

From the CoordFile menu, choose Import from Ascii or Export to Ascii.

1. Importing and Exporting Text Files

Tabulated plain text files can be used both as a source of data for, or as a destination from, an open coordfile. The files can be in delimited (CSV) or fixed format.

Text File Format

To be compatible with Copan, such a text (or Ascii) file must have the following:

The rules for Delimited Format files are similar to those for Excel's CSV files:

Example 1: Comma-delimited text file, three columns, no headings.

1,5699.4,695.2
2,5700.6,695.7
3,5700.0,696.3
4,5699.3,696.1

Example 2: Fixed-field text file, four columns, with headings.

 Number  Northing  Easting  Code
      1    5699.4    695.2     0
      2    5700.6    695.7     8
      3    5700.0    696.3     7
      4    5699.3    696.1     

Example 3: Comma-delimited text file, six columns, with headings.

This is a hypothetical GPS data file, whose second and third fields do not correspond to Copan fields.

Point,UTC,Fix,Northing,Easting,Elev
1,155757,3,6306918.388,380793.430,3.07
2,155758,3,6306918.360,380793.445,3.07
3,155759,4,6306918.358,380793.449,3.09
4,155800,4,6306918.355,380793.444,3.08

Example 4: Bar-delimited text file, with strange notes.

This file

Point|Northing|Easting|Note
1|918.3|179.0|wall
2|618.6|180.5|"non |_ corn"
3|594.3|179.9|wall
4|901.8|193.4|"6"" pipe"

would be interpreted as

Number  Northing  Easting   Note
     1     918.3    179.0   wall
     2     618.6    180.5   non |_ corn
     3     594.3    179.9   wall
     4     901.8    193.4   6" pipe

To Import a Text File

  1. CoordFile | Import from Ascii...
  2. Optionally Load... a Configuration file.
  3. Indicate which Ascii file Fields to import to what point record fields. (See Point Record Fields in § Point Records.) The chosen point record fields must include at least Number and Elevation, or Northing and Easting. If an input file has fields that are not desired, choose the blank field for them. (So to import example file 3, above, choose Number, blank, blank, Northing, Easting, and Elevation.)
  4. Choose either Delimited or Fixed format. (See Text File Format above.)
  5. Choose which Points to import: All or Filter.. a subset. (See § Point Filters.) After a potential import record has been converted to Copan point format according to your formatting criteria, it is tested against the import filter before actually being saved to the coordfile.
  6. Optionally Apply Transformation to the points being imported. (The source text file will not be changed.) Clicking Yes... allows you to enter the transformation parameters (see § Coordinate Transformations.)
  7. Choose other options as appropriate, such as whether Headings are on the first line, whether to Renumber new points or replace existing points (see § Point Renumbering or Replacement), or whether to use a Moving Filter (see below).
  8. Optionally Save the Configuration for later reuse.
  9. Optionally Open to edit, or List to preview, the prospective input file.
  10. Import (also labelled OK) and specify the appropriate input file.

To import points from a text file: Choose which Ascii file Fields to import to what point record fields; choose Delimited or Fixed format; choose which Points to import; and click Import.

To Export to a Text File

  1. CoordFile | Export to Ascii...
  2. Optionally Load... a Configuration file.
  3. Choose which Fields to export to the Ascii file. (See Point Record Fields in § Point Records.) You may output Desc, Description, or Extension fields, as well as or instead of Code, but be sure to select a valid Codes Table which should contain a Desc, Description, and Type for each Code. (See § Point Codes.)
  4. Choose either Delimited or Fixed format.
  5. Choose which Points to export: All or Filter.. a subset. (See § Point Filters.)
  6. Optionally Apply Transformation to the points during export. (The coordfile will not be changed.) Clicking Yes... allows you to enter the transformation parameters (see § Coordinate Transformations.)
  7. Choose other options as appropriate, such as whether to Put headings on the first line, Append to file, if it exists (the default is to overwrite), or the number of Decimals to output.
  8. Optionally Save the Configuration for later reuse.
  9. Export (also labelled OK) and specify the output file.
  10. Optionally Open to edit, or List to review, the output file.

To export points to a text file: Choose which Fields to export; choose Delimited or Fixed format; choose which Points to export; and click Export.

Notes

2. Importing Copan Coordfiles

3. Exporting to Total Station Files

If you wish to export points directly to a total-station-compatible file, see § Export to Total Station File.

updated: 23-Jan-2012