How to manually import the data

1. Prepare your data in a CSV file. The header line can be excluded.

A Perfect Example

The table is clean, the time format is neat, count in and out has its own column.

Time In Out
2023-01-02 10:59:21 5 3
2023-01-02 11:20:49 3 0
2023-01-03 12:32:12 2 1

A Good Example

 Has the date column, In and Out. Without time, add some extra info

01/02/2023 In 5 Out 3
01/02/2023 In 3 Out 0
01/03/2023 In 2 Out 1

The Vemcount will insert the data to the 12:00:00 each day

A Bad Example
Some cells missing, and no pure numbers in the cell. 

01/02, Mon 15 In: 5 82 Out 3
  61 In: 3 10 Out 0
01/03, Wed 47 2 85  

2. Go to Manage -> Footfall Data

1. Click on Import CSV and upload your CSV file.

2. Select your location

3. Skip the data template if you don't have

4. Choose the correct CSV format in the advanced options

3. Mapping the column

  • On the Date/Time column, we are using PHP time format to map. You can practice here if you have an interest.

 

  • For those who don't have a coding background, here are some common data mapping examples
2023-01-03 12:32:12 Y-m-d H:i:s
28/5/23 d/n/y
2023-01-03T12:32:12Z Y-m-d\TH:i:s\Z
The column mapping is following an A-Z sequence like in Excel, if you have a table that looks like this
Date Time ID In Out Notes Extra

It is recommended that you need to merge the Date and Time first, then map like this

Date/Time ID In Out Notes Extra
Created at Ignore In Out Ignore Ignore
  • Once all mapping is confirmed correct, click Import Data and Vemcount will open a new page for you to watch the import status. You can refresh the page to see the process, the import speed is about 5 rows per sec.