Column Assignments tab
 		Previous Topic  Next Topic 

Step 4 - Required Assignments

 

This tab is the real "work horse" of the import process and the point at which you tell the wizard what each column of the file contains. Based on the type of file you are importing and the selections you have made so far, the color coded labels show which column assignments you need to make. A red label indicates you MUST make that designation, a yellow label indicates that selection is Optional, and a green label indicates it has been made correctly.

 

It is at this point where you can "weed out" columns you don't need, by setting them to "Not_Used".

 

The Column Assignment window as you begin:

 

To designate what each column contains, click in each cell of the top, dark green grid row. A drop down box will appear, and you can scroll to designate what that column contains. Note that the columns default to Not_Used. You need only make the designations indicated by the color coding, and as you make them the required assignments label will turn green

 

Making a column selection:

 

 

 

 

 

 

The column assignment window with all the selections made:

 

 

Insert Custom Info

In some situations you may need to overwrite (or supply) custom information into the text file. This control will allow you to place this information into the grid. The information will be place in all the rows in the grid (i.e. you can't place it in only some points) A good example of this would be to make a Symbol designation for all the points. 

 

To use this control, 

  1. Select the Column the information will be place into
  2. Type the custom information into the text box below
  3. Click Insert Info., and the information will be written into the grid.

 

 

 

Save Column Settings, Get Column Settings

Frequently you will be working with just one type of import file, and the column settings will be the same every time. This control allows you to reuse these settings.

 

Once you make the first Column Assignments, you can save them to a .set file. To use them again, just click the Get Column Settings button and select the file. The column assignments will be made automatically, and all the required text boxes should turn green.