ImportCSV()

Summary

Imports features from a Caliper text geography file into a geographic file.

Syntax

ImportCSV(string filename, string new_db_name, string layer_type, array options)

Argument	Contents
filename	The path and file name of the file to import
new_db_name	The path and file name of the new geographic file
layer_type	The type of features to import: Point, Line, or Area

Option	Type	Contents
Direction	Integer	The field position of the link direction (only when importing a line layer); defaults to no direction information present
Geography	Integer	The field position for the start of the geographic information; i.e., (lon, lat) for point layers and (np, lon1, lat1, _) for line and area layers (defaults to 1 for point and line layers and 3 for area layers, or immediately past the last defined ID field)
ID	Integer	The field position of the item ID(s) (defaults to 1 for area or line layers and no ID present for other layers)
Label	String	A descriptive label for the geographic file
Layer Name	String	The name of the layer in the geographic file
Median Split	Boolean	If "True" special handling insures that entities which cross the 180 degree longitude line are imported properly; if "False" (the default), no special handling is invoked
NAD Conversion	3 strings	Input datum, output datum, and conversion file (if needed); the input and output datums should be different
Node ID	Integer	The field position of the start node ID; the end node ID must immediately follow (only when importing a line layer) (defaults to no node IDs present)
Node Layer Name	String	The desired name for the endpoint layer (only when importing a line layer)
Optimize	Boolean	Whether to optimize the geographic file automatically after the import (defaults to "True")
Projection	String, array	The projection name and the array of options
Transform	Array	Array indicating the transformation to apply to coordinates in the file. This can have three forms:1. An array of two or more four-element arrays containing local and world coordinates for control points, for example, {{real localX1, real localY1, real longitude1, real latitude1}, ...}2. An array of four elements - {real X_multiplier, real Y_multiplier, real X_offset, real Y_offset}3. Center and Extent transform {c1_x, c1_y, width_1, c2_x, c2_y, width_2}where center is shifted from (c1_x,c1_y) to (c2_x,c2_y), and vector of length width_1 out of c_1 becomes a vector of length width_2 out of c_2.

Notes

For more details on the NAD Conversion option, see Datum Conversions.
For more details on the Projection option, see Using Projections and Coordinate Systems.
If no transformation is applied, longitude and latitude coordinates can be integers with six implied decimal places (millionths of a degree). For more details, see Transformations.
ImportCSV() displays a progress bar. To add a Cancel button to the progress bar, precede the function call with an "on escape" clause. For more information, see Error Handling.

Example

ImportCSV("c:\\geofiles\\sample.GEO", "streets.dbd", "Line", {

{"Direction", 4},

{"Geography", 5},

{"ID", 1},

{"Node ID", 2},

{"Label", "Street Centerline File"},

{"Layer Name", "Centerline"},

{"Optimize", "True"},

{"Projection", "utm", {"zone=12", "units=m"}},

{"NAD Conversion", "NAD27", "NAD83",}

})

Error Codes

Error Type	Meaning
NotFound	There is no file by this name
Error	The file is not a valid Caliper text geography file
Escape	The user clicked Cancel