Vemcount can export counting data automatically to an FTP server or email as a CSV/Excel file on a scheduled basis. This is used to feed data into ERP systems, BI tools (Power BI, Tableau), and custom analytics pipelines. Configure under ⚙ Settings → Companies → [Company] → Data Management → Sensor Export.
Export type | CSV or Excel |
File name | Custom name with optional dynamic date variable, e.g. |
Custom file extension | Override the default extension if your receiving system requires a specific format |
Export fields | Select which data columns to include (timestamp, count-in, count-out, location ID, etc.) |
Export days | Which days of the week to include in the data |
Export hours | Time period to include, e.g. |
Sensor interval | Data granularity: 5 min, 10 min, 15 min, 30 min, 60 min, daily, or weekly |
Send interval | How often to send: every hour, daily, weekly, or monthly |
Historical data | Number of periods of history to include in each file (useful for backfill) |
Send time | Exact time to send, e.g. |
Host | FTP server hostname or IP |
Port | FTP port (default 21, or 22 for SFTP) |
Directory | Destination folder on the FTP server. Root = |
Username / Password | FTP authentication credentials |
Enter one or more email addresses as recipients. The export file will be attached to a scheduled email at the configured send time.
BI tool integration (Power BI / Tableau) | Export daily at 01:00, CSV format, 60-min intervals, last 7 days of history, FTP to the BI server's data directory |
ERP / POS reconciliation | Export daily at 09:00, Excel format, daily interval, previous day only, email to operations team |
Real-time operations feed | Export every hour, CSV, 15-min intervals, 1 hour history, FTP to operations dashboard server |
Tip: Use the {export_date} variable in your file name to create date-stamped files that don't overwrite each other on the FTP server (e.g. footfall_store42_{export_date}.csv).