Full Admins can import locations and surfaces en masse using the steps below:
1. From the navigation, click Settings > Scheduling > Import Locations.
2. Click the ‘Download this file’ link on the page to access the import file spreadsheet template.
3. On your downloaded copy of the import file, begin adding all of your incoming data while maintaining the integrity of all existing column headers. Instructions for accepted data inputs can be found on the 2nd tab on the file titled 'Instructions' and also outlined below. Asterisk ( * ) denotes a required field.
Universal ID*: Enter the universal location ID.
If importing brand new locations with surfaces: For locations that do not yet exist in your domain, leave the Universal ID box blank for the import. The system will run a check against the address of the location and create an ID for the location if one does not already exist.
If importing additional surfaces for existing locations: For existing locations, including the location's universal ID, this can be found by going to the location's page - the Universal Location ID will be displayed below the location name in orange text. Be sure to group the surfaces at the same location by inputting the same universal ID.
Location Name*: Enter the name of the location (characters 0-9 and A-Z only).
Street, city, state, country, and zip code*: Enter the address details for the location. Valid information is required for map generation.
Region Name*: Enter a region name (characters 0-9 and A-Z only) only if regions have been set up specifically for your organization - otherwise, leave blank.
Amenities: Include available amenities at the location. Use the Yes/No menus to indicate if the location has the respective amenity available for teams or spectators.
Lights: Using the drop-down, indicate if the surface/ location has lights available.
Surface Name*: Enter the name of the surface. The name must be unique to the location (characters 0-9 and A-Z only).
Surface Type*: Using the drop-down, indicate the surface type. Options available are artificial turf, court, and grass.
4. Once the file is complete with all your organization’s location/ surface information, save the file as a . CSV (Comma Separated Values) format. Upload your saved file by dragging it into the upload section or clicking to select the file from your computer. Once the file has been selected, click Next.
5. Preview the first 10 rows of your incoming data to verify that the column headers are properly mapped. Use the sort function or filters to review any location or surface information included in the file. If any corrections need to be made, click the Restart button and make the corrections on the file, then re-upload.
6. If the preview of the data is accurate, complete the process by clicking the Import button at the bottom of the page.
7. The import process has begun. You will receive a confirmation email once the process has been completed. Processing times may vary depending on the size of the file or system traffic.
8. If you need to add more locations from a different file, select the Import Again button and repeat the process as necessary.
Note: The import process will not update any existing values for a location or surface. Necessary edits should be done manually for each location or surface.