How to embed your opening hours in the points of your map

Tutorials - June 12, 2017

You need to import a file with hundreds of points of the details of your shops in Click2Map. The import process is really easy to use. But, at some point, you realize that your file contains opening hours and no field exists in the Click2Map editor.


It’s simple, this field doesn’t exist in the editor, you have to create it. Don’t worry. It’s an easy process with just a few clicks.


How to create an ‘Opening Hours’ field and import it in the description of your points? Let us explain to you in 4 steps in this post.


1. Create the personalized data field(s)

The field doesn’t exist, you need to create it before importing your file.

Two possibilities are available:

  • Your opening hours are grouped in one cell for each shop. In this cas, you will have to create only one personalized data field.
  • Or your opening hours are divided in several columns (one column for each day of the week for instance). You will have to create a personalized data field for each concerned column.

Go kindly to the My database menu > Properties.


First, you have to create the data category called here: StoreLocator. Then create the concerned data field. In our case, the data field will be named ‘Hours’ with a Rich Text format or 5 ‘Text’ data fields will be created for each day: ‘Monday’, ‘Tuesday’, ‘Wednesday’, ‘Thursday’ and ‘Friday’.



2. Rename the concerned column(s) in your file

Before the import, in order to save time, rename the column(s) which contains the opening hours in your file.


Put a title with the “#” symbol followed by the name of the data category and the name of the data field. The editor will associate automatically your new personalized data fields with the columns of your file.


In this case, the column will be renamed by:

  • #StoreLocator.Hours if you grouped your opening hours in one column
  • or #StoreLocator.Monday for the ‘Monday’ columm, #StoreLocator.Tuesday for the ‘Tuesday’ columm, etc.



3. Import your file

Start now the import of your file. Go to the New menu > Import.


Follow the different steps and associate the fields which won’t be associate automatically by the editor.


Confirm and import.


4. Use the bulk operations

You have imported the needed information in the editor and your points are geolocated on your map. Perfect. Now it’s time to specify where you want to place the opening hours in your markers.


The bulk operations feature is ideal for these operations in the Click2Map editor. They are useful when you need to make modifications on several markers in one single operation.


In the Tools menu > Bulk operations, select all your markers and choose at the top right ‘Change Description’. In the white box, enter the name of the personalized field defined earlier, here is #StoreLocator.Hours (or embed each data field for each day #StoreLocator.Monday, #StoreLocator.Tuesday, etc.).



It’s finished! Click on your points on the map, the opening hours are all filled in the description.


If your map is ready, you can embed it in your website or share it with your network.

air max 1

Why wait?

Start mapping now!