Saifan Pilot Posted April 15, 2015 Report Share Posted April 15, 2015 Hello, For those of you who use Garmin BaseCamp to store all user waypoints and would like to upload these to iPhone/iPad ForeFlight app, here is how to do it ForeFlight official User Waypoints guide is here: http://www.foreflight.com/support/user-waypoints Here is what you ill need: iPhone and/or iPad ForeFlight App iPhone/iPad USB cable Computer running iTunes (http://www.apple.com/itunes/download/) Garmin BaseCamp (Win: http://www8.garmin.com/support/download_details.jsp?id=4435 Mac: http://www8.garmin.com/support/download_details.jsp?id=4449 ) Microsoft Excel Requirements on user waypoint file to be imported into ForeFlight Must be CSV (Comma Separated Value) file or Google Earth KML file Waypoint Names must be all caps and not contain spaces. Only dash "-" or underscore "_" characters are permitted. Description up to 30-40 characters. Lat then Lon in decimal format. All values separated with Commas. for example: MY_HOUSE,My house,38.1,-79.2 File name must be user_waypoints.csv Here is how to prepare the file for ForeFlight: Export the waypoints in BaseCamp using the File ➜ Export Save As: user_waypoints.csv You can select destination to desktop Make sure you select Format: CSV Text Open the user_waypoints.csv file in the desktop using Microsoft Excel You'll need to delete all the rows before and after the waypoint list, so that all that remains are the waypoints themselves (simply click and drag the row numbers in the column on the left hand side 1,2,3.... so that all the rows that do not contain waypoints are highlighted in blue then right click and select Delete Now that all you'll have left are waypoints, no headers or routes, tracks etc... the file will look something like this (Note data extends up to column AB, that's the 28th column) Next you will want to delete all the columns we don't need, so all we'll have left are columns B, C, H and I (Lat, Lon, Name, Description). Do this by clicking on the column headers (A, D-G, J-AB) of the columns you wish to delete so that excel highlights all those columns in blue, then right click and select delete.Next we need to move the Name and Description columns to the left. Simply click and drag on column headers "C" and "D", so both columns are highlighted in blue, then right click and select cut. Then click on column header "A" right click and select "Insert cut cells" Click on column header "A" to highlight the entire column Click on menu: Edit ➜ Replace... Enter a single space in the "Find what:" text field. Enter a single underscore _ in the "Replace with:" text field. Click the "Replace All" button The result will be underscores replacing spaces in name column A Click on the menu: File ➜ Save If a warning window comes up says "This workbook contains features that will not work...." just click the Continue button. Next we need to upload the file to ForeFlight app using File sharing: Connect iPhone/iPad to computer with USB cable. Launch iTunes Click on the iPhone icon on the top of the window Click on the "A Apps" icon on the left side bar Scroll down in the app list on the right hand side of the window all the way down to the bottom to find File Sharing and click on ForeFlight icon Click on ForeFlight Click on button Browse to the user_waypoints.csv file on the desktop Now launch ForeFlight on your iPhone/iPad, tap the ⚐ User Waypoints menu item. ForeFlight will then ask you if to import the waypoints. Tap import. Hope you find this tutorial useful. 2 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.