Data export & FTP integration — automated CSV feeds
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.
File output settings
Export type
CSV or Excel
File name
Custom name with optional dynamic date variable, e.g. footfall_{export_date}.csv
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.)
Data output settings
Export days
Which days of the week to include in the data
Export hours
Time period to include, e.g. 08:00–20:00 (opening hours only)
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. 07:15
FTP delivery
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
Email delivery
Enter one or more email addresses as recipients. The export file will be attached to a scheduled email at the configured send time.
Typical configurations
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).
/global/header/facility-management.svg)
