Data export​

The Data Export feature in Cisco Spaces helps you to set up automatic export of data as CSV files via SFTP, Amazon S3, Microsoft Azure, Google Cloud & Box.

Cisco Spaces captures a variety of data including user acquisition data, user visit data, proximity rule match data, etc. You can easily export this data and use it to make data driven decisions for your business.

Exports are provided as flat files (CSV) that are uploaded directly into customer data centers or cloud over SFTP, Amazon S3, Microsoft Azure, Google Cloud & Box. Optionally, this can be transferred over a VPN connection if the destination server is not accessible over public internet. The frequency of the upload can be customized to suit customer requirements and volume of data. This supports fully automated ingestion into customer systems.​

Use Cases & Value

The data exports can be used for advanced data manipulation, improved over what is available out of the box within the Cisco Spaces applications. By exporting the data, users can create their own graphs & charts at a variety of time intervals that are most relevant to their business goals. Data can be received via SFTP, Amazon S3, Microsoft Azure, Google Cloud & Box.

Value Delivered: Granular analysis, data driven decision making, information sharing across teams

Useful to: IT Managers, Sustainability teams, Facilities Managers, Real Estate Planners, Operations Managers, Executive Stakeholders

Please complete the following prerequisites before using the Data-export feature.

Ensure that location data is set in location hierarchy, check video (time zones, area, capacity).​

Make sure that your applications of interest are active, and collect data. Certain applications may require additional configuration, or time to collect data.

Head to “how to use the feature?” section on the next tab for a step by step video.

The configuration can be done manually on the respective controllers OR the configuration provided in the Cisco Spaces Setup Page can be used.​

  1. Go to OpenRoaming app within Cisco Spaces Dashboard.​
  2. Click on the Hamburger menu and go to Setup.​
  3. Select the required Wireless LAN Controller.​
  4. Select the required OpenRoaming Hotspot profile and click Continue.​
  5. Provide the WLAN-Id based on the controller chosen.​
  6. Configuration is generated based on the input.​
  7. Copy the configuration and paste it in the CLI.​

Please take a moment to check if you’re able to successfully setup the app. Click on ‘yes’ to indicate it’s working. And on ‘Not yet’ if you need any assistance.

After you select the Data Type drop-down list for exporting data, the following data types are available:

Data Types Description
Visits Log Timestamp, Timezone, Local Date, Local Hour, Local Minute, Device ID, User ID, User Name, MAC Address, Visit Start Timestamp,Visit End Timestamp,Visit Duration, Location Information
Right Now – People Count (Wifi) Log Timestamp, Local Date, Local Hour, Local Minute, Associated Users Count, Estimated Probing Count, Estimated Density, Location Information
Right Now – People Count (Camera) Log Timestamp, Local Date, Local Hour, Local Minute, People Presence Count, Location Information
Captive Portal – Customer Acquisition Log Timestamp, Timezone, Local Date, Local Hour, Local Minute, Acquisition Type, Device ID, User ID, MAC Address, Acquisition Handle, Opt In, Phone Number, Email, First Name, Last Name, Gender,Age, Business Tag Name, Business Tag Value, Social Network, Social Network Profile URL, Social Network Picture, CPF Number, Location Information
Engagement – Rule Activity Log Timestamp, Timezone, Local Date, Local Hour, Local Minute, Device ID, User ID, MAC Address, Profile Tag Name, Rule Name, Location Information
Location Personas – Rule Activity Log Timestamp, Timezone, Local Date, Local Hour, Local Minute, Device ID, User ID, MAC Address, Engagement Type, Engagement Destination, Message, Rule Name, Location Information
Open Roaming – User Data Log Timestamp, Timezone, Local Date, Local Hour, MAC Address, User Name,Status Type, Account Session ID, Acct Input Octets, Acct Input Packets, Acct Output Octets, Acct Output Packets, Profile Name, Device Class Tag, CUI User Name, App Reference ID, Location Information

Note

  • In the Location Information area, the following fields are displayed depending on the selected configuration. All these fields are optional and you can choose to select them to include in the data export.
    • Location Name
    • Location Type
    • Hierarchy Path
    • City
    • State
    • Country
    • Capacity
    • Area
  • The recent hour data for the selected data type is displayed in the sample export.
  • For each data type, you must select the levels in Location Hierarchy and location information to include in the export.
  • The location selection is based on the location type selected in the Data Type field.
  • The location selection option is not available for the data types Engagement, Captive Portal and Location Personas.
  • Cisco Spaces captures various user data at location including user acquisition data, user visit data, engagement rule match data, and so on.
  • For custom data export, please contact Cisco Spaces support