Skip to main content

How to Upload Your Custom Data to Cityguide?

Shaqran Bhat
Updated

Welcome to CityGuide! 

Cityguide is a one-stop App for your Interactive Kiosk Users to access the most relevant and curated places of interest.

Custom data allows you to upload unique information to be displayed on the CityGuide app, separate from the standard data typically shown by services like Google. This data might include specific locations, businesses, or other points of interest that are not already available on Google or the ones you want to promote or highlight.

If you're ready to upload your custom data to our platform, you’re in the right place. This guide will help you format your CSV file correctly to ensure a seamless upload experience.

 

We’ll go through each column in the CSV format, explain the requirements, and provide examples to make the process as easy as possible.

 

CSV Format Overview

Your CSV file should follow this format for a successful data upload:

 

*Sample Image of Correct CSV Columns

 

You can download the template .csv file from the following link to get you started :
Template File

Required Fields

All columns are required except for address2, city, state, country, and zip code. If you prefer, you can include the full address in the address1 column and leave the other address-related columns empty.

 

Column Breakdown

Let’s break down each column and its requirements:

1. Name

  1. Description: The name of the location or establishment.
  2. Example: "Aloft South Bend"

2. Address1

  1. Description: The primary address of the location. You can include the entire address here if you prefer.
  2. Example: "111 N Main St South Bend IN 46601"
  3. Note: If you choose to use this column for the entire address, you can skip address2, city, state, and zip code.

3. Address2

  1. Description: An optional secondary address field.
  2. Example: "" (leave empty if not used)

4. City

  1. Description: The city where the location is situated.
  2. Example: "South Bend"
  3. Note: This column can be skipped if you have included the entire address in address1.

5. State

  1. Description: The state where the location is situated.
  2. Example: "IN"
  3. Note: This column can also be skipped if the full address is in address1.

6. Country

  1. Description: The country of the location.
  2. Example: "United States"

7. Zipcode

  1. Description: The postal code for the location.
  2. Example: "46601"
  3. Note: This column can be skipped if the full address is in address1.

8. Categories

  • Description: This column should include one or more categories that describe the location.
  • Requirements: Categories must be selected from the following list and enclosed in double quotes:
  • Arts & Entertainment
  • College & University
  • Event
  • Food
  • Nightlife Spot
  • Outdoors & Recreation
  • Professional & Other Places
  • Residence
  • Shop & Service
  • Travel & Transport
  • Example: "Meeting Facilities, Places to Stay"
  • Important Note: If you are adding multiple categories, ensure that the entire value is enclosed in double-quotes. For example, "Event, Food" is correct, while Event, Food is incorrect.

9. Phone Number

  1. Description: The contact number for the location.
  2. Example: "574-344-5408"

10. Website

  1. Description: The URL of the location's website.
  2. Example: "https://www.marriott.com/hotels/travel/sbnal-aloft-south-bend/"

11. Location

  1. Description: This should contain the latitude and longitude of the location.
  2. Format: Latitude first, followed by longitude, and enclosed in double quotes.
  3. Example: "-97.4013813,37.0500834"

12. Rating

  1. Description: The rating of the location (if applicable).
  2. Example: "" (leave empty if not applicable)

13. Images

  1. Description: This column should contain a collection of image URLs separated by commas and enclosed in double quotes.
  2. Example: "https://example.com/image1.jpg, https://example.com/image2.jpg"

14. Thumbnail Image

  1. Description: A single URL for a thumbnail image representing the location.
  2. Example: "https://example.com/thumbnail.jpg"

 

Important Formatting Guidelines

 

  1. Location Format: 

Ensure that the location string in the Location column is formatted as latitude,longitude, enclosed in double quotes. 

Example: "40.7128,-74.0060".

  1. Categories: 

Always enclose the entire categories string in double quotes. 

Example: "Event, Food" is correct, while Event, Food is not.

  1. Address Formatting: 

If your address contains commas, enclose the entire address in double-quotes. 

Example: "New York, NY, 10001". If you prefer not to use commas, you can separate items with spaces, such as New York NY 10001.

  1. Image URLs: 

Ensure that the images column contains URLs separated by commas and enclosed in double quotes. 

Example: "https://example.com/image1.jpg, https://example.com/image2.jpg".

Conclusion

By following these guidelines and examples, you’ll be able to upload your custom data to CityGuide without any issues. Remember to double-check your CSV file for any formatting errors before uploading to ensure a smooth process. 

If you have any questions or need further assistance, our support team is here to help. 

Happy uploading!

Related articles

Comments

0 comments

Article is closed for comments.

Powered by Zendesk