New Horizon Experience. This article describes the New Horizon Experience. You can follow these steps on a computer or in the Horizon WebRef mobile apps for Android and iOS.
Import locations is the walk-through organization administrators use to bring location names into Locations from a file. Officials who only work games cannot import, and neither can coaches, athletic directors, League Personnel, or location personnel. Your organization may use another word, such as ice rinks, venues, or fields.
Use this article when you have a site list to load, a downloaded list to update, or a batch of fields you would rather confirm once than type one at a time. Create a separate location for each field or playing surface at the same site. To add one location by hand, stay on Locations.
If the page still asks you to Select your file and Import file without Options, File, and Preview steps, you are on the older legacy layout. Skip ahead to If you still see the older legacy desktop or laptop layout at the end of this article.
Who can import, and how to turn it on
Import locations is for organization administrators. Open System Settings if you need to confirm you can change organization settings. The menu uses your organization's word for locations, so you may see Import ice rinks or a similar phrase.
Some demo organizations can preview a file but cannot finish the import. The page says This demo organization can preview a spreadsheet, but it cannot import these records.
Where to open it
On Locations, open Utilities and choose Import locations (or Import plus your organization's word). You can also open Import locations directly.
On a phone, Utilities is the gear without the word. If you do not see the import item, your membership cannot change locations.
Prepare the file
Horizon reads the first 2,500 data rows. Split a larger list. The file can be CSV, tab-separated or plain text, or an Excel workbook (.xlsx). Save older .xls files as CSV or .xlsx first, and keep the file at 8 MB or smaller.
On the first step, choose Download template if you do not already have a file with the column headers Horizon expects. Horizon asks Download a template?Include example rows puts sample locations under the headers so you can see how each column is meant to look. Remove those examples before you import your own records. Blank file only gives you the same headers with no sample rows.
Required column is Name. Optional columns include Abbreviation, Address Line 1, Address Line 2, City, State/Province/Region, Zip, Country, Phone, Used For Games, and Used For Meetings. Keep addresses complete so mapping can work. TBA and TBA (2) cannot be changed from a spreadsheet. Remove those rows from the file.
Column headers do not have to stay in template order. Extra columns that Horizon does not use appear as a warning.
Amend or replace
The first step is titled Import type. The coach line says Amend keeps locations that are not in the file, and Replace turns unused locations off.
Amend existing locations adds new names and updates matches. Locations that are not in the file stay as they are. That is the everyday choice.
Replace the list adds or updates rows in the file, then turns off active locations that are not in the file. Use replace only when the spreadsheet is the complete list you want to keep. Horizon later asks you to type a confirmation phrase such as DELETE 12 LOCATIONS (your organization's word may appear there) before anything is turned off.
Choose Continue after you pick amend or replace.
Add the file
Continue to Spreadsheet file, then drop the file on Drop a file here or choose Choose file. After a file is selected, that control becomes Choose a different file.
If the type is not accepted, Horizon asks you to save as CSV or .xlsx. A file larger than 8 MB must be split. If the headers belong to a different import, Horizon tells you this spreadsheet is missing the column names this import needs.
Review locations before you import
The Preview step shows every importable row. Read it carefully, because it is easier to choose Cancel import and fix the file than to repair locations after they change. The coach line says warnings mean an existing location will be updated.
Four counts sit at the top: All, Needs a fix, Warnings, and Ready. Tap a count to filter the list.
Select a row to open Fix this. That panel has four parts when they apply: Your file, Horizon checked, Closest matches, and Do this next.
Typical Needs a fix items include a missing name, TBA or TBA (2), or the same name twice in the file. A warning such as This location already exists and will be updated still imports. Rows that still need a fix are left out. Choose Cancel import if you would rather fix the file first. Horizon asks Leave this import? Confirm Cancel import or Keep this import.
How we read this file
On Preview, open How we read this file when a location name, address, or column looks wrong. This is not a second import. It shows how Horizon understood the spreadsheet: file type and size, Columns we read, and Filter by problem.
Import and results
When no blocking errors remain, choose Import. Horizon asks Import these rows? Ready rows are added or updated. Rows that still need a fix are left out. Replace also asks you to type the confirmation phrase before unused active locations are turned off.
After the work finishes you see Import finished with counts for Created, Updated, Skipped, and Removed from use when replace turned locations off. Choose Close to return to Locations.
Limits that still apply
Horizon reads the first 2,500 data rows.
Maximum file size is 8 MB. Accepted types are CSV, text, TSV, and .xlsx.
TBA and TBA (2) cannot be changed from a spreadsheet.
Replace turns off active locations that are not in the file. Type the confirmation phrase exactly.
Preview the file before you import. Cancel and fix the file when something looks wrong.
If you still see the older legacy desktop or laptop layout
Some members still import from the top icon menu on Locations, not under Utilities. That older path says Import locations (or Import plus your organization's word), asks you to save a Windows CSV (comma delimited) file, then Select your file and Import file. There is no Options / File / Preview walk-through and no Fix this panel. Use a CSV only, keep the template column order, and read the confirmation before you replace existing data.