Spreadsheet PIE version 1.2 (Nov. 2 07)

This PIE is intended for importing a list of scattered points, specified in a spreadsheet-like text file, into Data or Information layers. As of Argus ONE version 4.2.0f the PIE is installed with Argus ONE.

Data Format

Each data point and its information should be specified in a separate line.
The values in each line should be delimited by one or more space or Tab characters.
If a string value contains spaces or tabs, it should be encompassed by double-quote marks (") in order not to consider spaces/Tabs as field separators
Each line should include all the values, in the same order.
- Unformated files:
  - An unformated file consists only of lines of data
  - X is assumed to be in the first column
  - Y is assumed to be in the second column
  - "Z" Values follow in the next columns
  - Argus ONE does not distinguish between Real, Integer and Boolean values - all are considered Real
- Formated files
  - In order for the PIE to identify the order and the type of the information in each line, a header line is required before the first data line.
  - The header line must begin with a pound character (#)
  - For each data field the header should include the name of the field
  - There must be two fields named "x" and "y", giving the coordinates of each data point
  - Optionally, the type of the field can follow the name. The type should be one of:
    - [Real]
    - [Integer]
    - [String]
      (the square brackets are mandatory!)
    - When a field type is not specified, Real is assumed

UnFormated file Example:

10.2 12.1 154.3 1 "First Point"
13.7 11.3 173.8 2 "Last Point"

Formated file Example:

#"Point Number" [Integer] Y X Name [String]
1 12.1 10.2 "First Point"
2 11.3 13.7 "Last Point"

The first field is an integer field named "Point Number", the quotes are required since the name contains a space. The second and third fields list the coordinates for each data point. A Real type is assumed by default. The fourth field is a String field named "Name". String values can be given with or without quotes. Use quotes if the string contains a space or Tab characters.

How to Install the PIE

As of Argus ONE version 4.2.0f the PIE is installed with the application. You can download it if you deleted it and need to restore it.

Download the PIE from the Argus ONE site

To install the Spreadsheet PIE, copy the file "Spreadsheet.dll" into the directory "ArgusPIE" that is inside the Argus directory. If you installed on your C drive using the default installation, this should be at: "C:\Program Files\Argus Interware\ArgusPIE\".

How to run the PIE

Import Into Current Layer:
To import data points into the current layer, use the "Import Points List..." command from the "Import" item of the "File" menu. A dialog box will appear, asking for input file. Choose the file you want to read and click the Open button:

After selecting a file, the PIE will present a dialog box asking for the fields to be read from the file. The window will list all the fields found in the header, except for the X and Y fields (which are always read). When importing into a Data layer, String fields will be omitted as well (since Data layer can't handle string values). Click on the fields you want to read to select them. Click again to deselect:

After marking the required fields, click the OK button to begin import.
Import into a New Layer:
To import data points into a new layer, select the "Read Points List..." item from the "PIEs" menu. The sequence of events is then similar to importing into the current layer, except for an extra dialog box that will show after choosing the file to be read. This dialog box will prompt you to choose where you want to bring the data into:
- Import to the existing data (or information) layer: Will appear when a layer with the same name as the imported file already exists. Choosing this option will import the data points into that layer, then will activate it.
- Import to the current layer: Will appear when the current layer is a Data or an Information layer. Choosing this option will import the data points into the current layer.
- Import to a new data (or information) layer: Choosing this option will create a Data (or Information) layer with the same name as the imported file, then import that data into it, and make it the active layer.