Tutorials, Tips & Step-by-Step Guides

Grandstand Learn

All tutorials

Batch Upload List Items

Upload locations, images & list items

The following shows you how to upload location, images & list items and make sure they are all synced and what order they should be done. The most efficient way to upload these is using batch upload tools available in Grandstand.

Tip: We will upload all of the pieces needed to be able to efficiently upload the list of vendors. The order should be:

  1. Batch upload or add Map Locations
  2. Batch upload List Images
  3. Batch upload List of Vendors
  4. Match the images to the Vendors

When uploading a spreadsheet for lists, you should make sure to keep the data in the columns as described here:

Upload the Locations to the Map

Tip: First step should be to upload the list of locations to the map. You can either place the locations individually, for the instructions on placing an individual location, you can find instructions here: https://www.grandstandapps.com/learn/batchupload-lists-columnorder

Instructions for Adding Location to a Lat/Long Map

1. Click "Maps"

2. Click "Batch Upload"

3. Click the fields under "Included in Upload File" and move them to the "Not Included" section if they are not included in your file, and move them to match the same order they are in for your spreadsheet (ie, here we would have Column A = Map Name, Column B = Map Pin Type, etc)

4. Once the order of the columns are complete, Click the file upload field and select the file from your computer.

5. Click "Check Data" when you have your file selected. This will check the data to make sure it is in the correct format.

6. Click "Upload New Data" after you check the data and it is correct.

7. Click "Add/Edit Locations"

8. Click "Update Locations In App" to make the locations live on the map in the app.

Batch Upload the Images to use for the List Items

9. Click "Fonts, Colors & Styles"

10. Click "Image Manager"

11. Click "Batch Upload Images"

12. Click Choose Files and select the photo files you want to upload. You can upload 10 at a time. Repeat for each group of 10.

13. Open the Image Type dropdown.

14. Click "List Thumbnail Image" since we are uploading List images. If we were uploading images to be used on the schedule, you would select Event Images.

15. Open the Batch Resizing dropdown and select "No Resizing (Default)"

16. Click "Save"

Batch Upload List Data

17. Click "Batch Upload" under the Lists heading

18. Click the field labels and put them in the order under the "Included in Upload File" header to match the order of the spreadsheet.

19. Once the labels are in order, click Choose File. Select the spreadsheet from your computer to upload.

20. Click "Check Data"

21. Click "Upload New Data"

22. Click "Manage List Items"

23. Click "Update Lists In App" to make the list live in the app.

24. Click "OK"

Match the Images to the List Items

Tip: Now that the locations, list and the images are all uploaded. You can now match the images to the list items.

25. Click "Fonts, Colors & Styles"

26. Click "SnapMatch"

27. Click "List Thumbnail Assign" because we are matching List Items to List Images. If we were assigning Event Photos, we would select "Event Photo Assign."

28. Select an unassigned image in the Left Column.

29. Select the corresponding List Item in the Right column.

30. Click "Pair Image with Content" to sync the image to the list item.

31. After all of the images have been assigned to the corresponding list item, Click "Lists"

32. Click "Manage List Items"

33. Click "Update Lists In App"

34. Click "OK"

Tip: All of your list items should now be uploaded with the correct location and corresponding image.

Lists, Batch Upload