Serach Icon

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

    clock

    7PM

    GMT+2

    clock

    7PM

    GMT+2

    clock

    7PM

    GMT+2

    Company-with-Circle-BG

    Who We Are

    Aliquam Dui Diam, Tincidunt Eget Nulla Eget, Dictum Feugiat Felis. Cras Mattis Eget Tellus Quis Fringilla. Morbi Molestie Enim

    Aliquam dui diam tincidunt eget nulla eget dictum feugiat felis.

    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.

    Banner