Difference between revisions of "Pathloss 5 - Import sites from text file"
| 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 - | + | == 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 13: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.
Click Import - Site text file
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.
Step 3 - Select delimeter
Click the Next button. Make sure that the delimeter is set to Comma and click the Next button.
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.
Step 5 - Verify coordinate and group settings
