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 |
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.