Difference between revisions of "Pathloss 5 - Import sites from text file"

From PathlossWiki
Jump to: navigation, search
Line 17: Line 17:
 
A file open dialog box will appear. Select the text file you would like to import and click '''''Open'''''
 
A file open dialog box will appear. Select the text file you would like to import and click '''''Open'''''
  
== Step 2 - Importing ==
+
== Step 2 - Select text file type ==
 
This is a comma delimited file with column headers. Select '''''Delimited''''' and because we do not want to import the column names, set '''''Start import at line''''' to '''''2'''''.
 
This is a comma delimited file with column headers. Select '''''Delimited''''' and because we do not want to import the column names, set '''''Start import at line''''' to '''''2'''''.
  
 
[[File:Import_site_csv_02.JPG]]
 
[[File:Import_site_csv_02.JPG]]
  
 +
== Step 3 - Select delimeter ==
 
Click the '''''Next''''' button. Make sure that the delimeter is set to '''''Comma''''' and click the '''''Next''''' button.
 
Click the '''''Next''''' button. Make sure that the delimeter is set to '''''Comma''''' and click the '''''Next''''' button.
  
 
[[File:Import_site_csv_03.JPG]]
 
[[File:Import_site_csv_03.JPG]]
 +
 +
== Step 4 - Assign column names ==
  
 
Hi-lite each column and while it is hi-lited, select the appropriate column name from the list on the right.  
 
Hi-lite each column and while it is hi-lited, select the appropriate column name from the list on the right.  
 +
 +
[[File:Import_site_csv_04.JPG]]
 +
 +
== Step 5 - Verify coordinate and group settings ==
  
 
[[File:Import_site_csv_04.JPG]]
 
[[File:Import_site_csv_04.JPG]]

Revision as of 14:06, 10 November 2009

This is a step by step procedure for importing site text files. Usually the site text files are delimited with commas or tabs, but they can also be fixed width. Pathloss 5 is flexible enough to read either.

Example link text file in CSV format:

Site name,Call sign,Latitude,Longitude 
Woking,CHW613,55.47972222,-118.74722222
Fairview,CHW614,55.83722222,-118.59666667

Contents

Step 1 - Open CSV file

Click View - Site List to bring up the Site index. You can also click the Site list button on the toolbar.

Site list 01.JPG

Click Import - Site text file

Import site csv 01.JPG

A file open dialog box will appear. Select the text file you would like to import and click Open

Step 2 - Select text file type

This is a comma delimited file with column headers. Select Delimited and because we do not want to import the column names, set Start import at line to 2.

Import site csv 02.JPG

Step 3 - Select delimeter

Click the Next button. Make sure that the delimeter is set to Comma and click the Next button.

Import site csv 03.JPG

Step 4 - Assign column names

Hi-lite each column and while it is hi-lited, select the appropriate column name from the list on the right.

Import site csv 04.JPG

Step 5 - Verify coordinate and group settings

Import site csv 04.JPG