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

From PathlossWiki
Jump to: navigation, search
(Step 4 - Assign column names)
 
(2 intermediate revisions by one user not shown)
Line 32: Line 32:
  
 
Click on a column to select it, for each column you need to:
 
Click on a column to select it, for each column you need to:
*select the appropriate data category
+
 
*set the location (Site 1 or Site 2)
+
*select the field name from the list
+
*click '''''Assign to column'''''
+
  
 
[[File:Import_link_csv_04.JPG]]
 
[[File:Import_link_csv_04.JPG]]
 +
 +
 +
Select the appropriate data category and then select the column name to assign.
 +
 +
'''''Note:''''' ''It may be useful to leave the "Start import at line" from the second step above at 1. This will make assigning the column headers much easier. One the assignments are complete you can click the '''<Prev''' button to the first window and set the "Start import at line" to 2.''
 +
 +
 +
[[File:Import_link_csv_05.JPG]]
 +
 +
 +
Set the location (Site 1 or Site 2) and click '''''Assign to column'''''
 +
 +
 +
[[File:Import_link_csv_06.JPG]]
 +
 +
 +
Once all columns have been assigned, you can save these import definitions in a file. This file should be included with the text(csv) file when sending to other users.
 +
 +
 +
[[File:Import_link_csv_07.JPG]]
  
 
== Step 5 - Verify coordinate and group settings ==
 
== Step 5 - Verify coordinate and group settings ==
Line 45: Line 62:
 
At this point you can also specify the group you would like the sites to appear in, or you can also create a new group to add the sites to. For more of groups see [[Pathloss 5 - Using groups]]
 
At this point you can also specify the group you would like the sites to appear in, or you can also create a new group to add the sites to. For more of groups see [[Pathloss 5 - Using groups]]
  
[[File:Import_link_csv_05.JPG]]
+
[[File:Import_link_csv_08.JPG]]
  
 
Click '''''Finish''''' to import the sites into your site list.
 
Click '''''Finish''''' to import the sites into your site list.

Latest revision as of 11:46, 30 July 2010

This is a step by step procedure for importing link text files. Usually the link 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 1,Site name 2,Latitude 1,Latitude 2,Longitude 1,Longitude 2,Elevation 1(m),Elevation 2(m),...
Woking,Fairview,55.47972222,55.83722222,-118.74722222,-118.59666667,925.61,574.02,...
Fairview,Brownvale,55.83722222,56.07333333,-118.59666667,-117.87972222,574.02,612.84,...
Beaverlodge,Demmit,55.21391667,55.46194444,-119.26891667,-119.88944444,928.60,834.99,...


Contents

Step 1 - Open text (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 link 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 link csv 02.JPG

Step 3 - Select delimiter

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

Import link csv 03.JPG

Step 4 - Assign column names

Click on a column to select it, for each column you need to:


Import link csv 04.JPG


Select the appropriate data category and then select the column name to assign.

Note: It may be useful to leave the "Start import at line" from the second step above at 1. This will make assigning the column headers much easier. One the assignments are complete you can click the <Prev button to the first window and set the "Start import at line" to 2.


Import link csv 05.JPG


Set the location (Site 1 or Site 2) and click Assign to column


Import link csv 06.JPG


Once all columns have been assigned, you can save these import definitions in a file. This file should be included with the text(csv) file when sending to other users.


Import link csv 07.JPG

Step 5 - Verify coordinate and group settings

For this example we need to set the Longitude to +East. Normally the Eastern hemisphere is positive and the Western is negative. Depending on the source of your coordinates you may need to change the hemisphere you are in to positive. The same applies to Latitudes and whether they are in the North or South hemisphere.

At this point you can also specify the group you would like the sites to appear in, or you can also create a new group to add the sites to. For more of groups see Pathloss 5 - Using groups

Import link csv 08.JPG

Click Finish to import the sites into your site list.