Keith Best demonstrates how to add a location to the MPP (Magic Page Menu) database. To add a single location, navigate to the “Locations” section and input the desired name and slug, which will be auto-corrected to lowercase and hyphenated. Essential details to include are the latitude, longitude, and zip code, which can be found using a tool like laplong.net. Additional fields such as region, county, and whether it’s a major city can also be added. For bulk additions, export and import the locations using a spreadsheet. Keith emphasizes the importance of accuracy in data entry for proper location management.

Action Items

• [ ] Add a new location called “York West” with the appropriate latitude, longitude, zip code, region, county, and major city status.
• [ ] Export the current locations data into a spreadsheet to prepare for adding multiple new locations.
• [ ] Fill in the new location details in the spreadsheet and import the updated data back into the system.

Outline

Adding a Location to the Database

• Keith Best introduces the purpose of the video, which is to show how to add a location to the locations database.
• He mentions that the quickest way to add a single location is to go to the “Locations” section under the “Magic Page Menu” and enter the desired location.
• Keith demonstrates by adding the location “York” and its corresponding slug, explaining that the slug will automatically be converted to lowercase and hyphenated if necessary.
• He emphasizes the importance of adding the latitude and longitude for the location, suggesting using a tool like “lap long.net” to find these coordinates if they are not known.

Filling in Location Details

• Keith opens the newly added location in a new tab and explains the need to add a description, latitude, and longitude.
• He provides an example using a location in Texas, showing how to copy and paste the latitude and longitude from the tool mentioned earlier.
• Keith also discusses the importance of finding the correct zip code for the location and filling in the region, county, and other relevant fields.
• He mentions additional fields like the abbreviated region and whether the location is a major city, and explains how to save the changes.

Bulk Adding Locations Using a Spreadsheet

• Keith suggests using a spreadsheet if multiple locations need to be added, especially if there are 10 to 20 locations.
• He explains the process of exporting the current locations from the database, filling in the spreadsheet with the necessary data, and then uploading it back to the database.
• Keith demonstrates this process by showing how he has exported and uploaded his own database.
• He concludes the video by hoping it was helpful and signing off, indicating the end of the tutorial.

Enjoy!