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. |
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. |
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. |
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).
7PM
GMT+2
7PM
GMT+2
7PM
GMT+2
Who We Are
Aliquam Dui Diam, Tincidunt Eget Nulla Eget, Dictum Feugiat Felis. Cras Mattis Eget Tellus Quis Fringilla. Morbi Molestie Enim
Sed dictum ligula luctus intum Vivamus.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Lorem ipsum dolor
Sed quis massa leo. Quisque tristique tellus sit amet arcu tempor ultrices. Nulla ullamcorper.
Become Our Supplier Or Partner
Mauris tempor libero massa, at vulputate velit aliquet eget. Fusce et tortor ex. Nullam venenatis, quam vel blandit molestie.
