Step 1

In Cisco Spaces, click the Menu icon () and choose Setup > Data Export.

Step 2

Click Create New Export.

The Create New Data Export window is displayed with the following configuration options in the chronological order:

• Data Type

• Locations

• Schedule

• File Format

• Connection

• Summary

Step 3

From the Data Type drop-down list, select the data type.

The following data types are available:

Table 1. Data Types

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 (Wi-Fi)	Log Timestamp, Local Date, Local Hour, Local Minute, Associated Users Count, Estimated Probing Count, Estimated Density, 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

Note

When you create or edit a Visits export, use the Include PII toggle to control whether the export contains the User Name and MAC Address fields. The toggle is enabled by default. When enabled, the generated Visits export includes User Name and MAC Address. When disabled, Cisco Spaces omits both fields from the generated file. Other selected Visits fields are not affected.

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

2. Use the INCLUDE PII toggle to choose whether Personally Identifiable Information (PII), such as MAC Address and username, is included in the export.

   Note	This option is available only if you select Data Type as Visits Export in the Create or Edit Export workflow. By default, the toggle is enabled, so the exported file includes the username and MAC Address fields. You can disable the toggle to exclude these fields from the export.

   Cisco Spaces uses standardized values in the Location Type field of export files. Use the these values when processing exported location data:

   Table 2.

   Previous value	Current value	Description
   cmxzone or merakizone	zone	Unified value for all zone types
   meraki	org	Organization associated with a Cisco Meraki network
   MSE	cmx	Location associated with Cisco CMX

   Update downstream parsers, mapping, and validation rules to accept zone, org, and cmx.

3. Click Next to navigate to Locations.

Step 4

Check the Enable this export for all locations check box to select all available locations and click Next to navigate to Schedule.

Step 5

In the Export Schedule area, from the Recurrence drop-down list, select the export recurrence to schedule a data export. The export is scheduled based on the configured timezone.

Step 6

Click Next to navigate to File Format.

Step 7

In the Delimiter area, select the data separator symbol code preference.

The options are:

• Pipe

• Comma

• Tab

• Custom character: In the Custom Character field, enter the character of your preference. You can use any special character except /,\, &, ',".

Note	For the options Pipe, Comma, and Tab you must provide additional inputs.

Step 8

In the Compress export data, select Yes or No if you need a compressed export.

Note	We recommend that you select the compressed format for data export.

Step 9

In the File Name Format field, enter the filename prefix and select the format for date and time.

Step 10

From the Select Date & Time Format drop-down list, select the format.

Step 11

Click Next to navigate to Connection.

Step 12

In the Connection Type area, from the Select Destination drop-down, select the destination type.

1. Enter the following parameters if the connection type is SFTP server:

   • SFTP Host: Enter the hostname or IP address of the server in the following format hostname.server.com.

   • Port: Enter the port number you want to connect to the SFTP server.

   • Username: Enter the username.

   • Use Password: Choose this radio button and enter your password to connect to the SFTP server.

   • Use Private Key: Choose this radio button to use the private key to connect to the SFTP server. You must use the Upload Private Key option to upload the private key and enter the passphrase.

     Note	You can either choose Use Password or Use Private Key based on the SFTP configuration to establish the connection. Password or passphrase selection is based on the SFTP server. We recommend that you use RSA private key because OpenSSH key based authentication is not supported.

   • Upload Path: Enter the upload path for the export data.

2. Enter the following parameters if the connection type is Amazon S3:

   • Access Key: Enter the access key for your Amazon S3 bucket.

   • Secret Key: Enter the secret key for your Amazon S3 bucket.

   • Region: From the Region drop-down list, select the region for your Amazon S3 bucket.

   • Bucket Name: Enter the bucket name depending upon the selected region.

   • Upload Path: Enter the upload path for the export data.

3. Enter the following parameters if the connection type is Microsoft Azure Blob Storage:

   • Account Name: Enter the storage account name for the Microsoft Azure Blob Storage.

   • Account Key: Enter the account key for your Microsoft Azure Blob Storage.

   • Container Name: Enter the container name.

   • Upload Path: Enter the upload path for the export data.

4. Enter the following parameters if the connection type is Google Cloud Storage:

   • Bucket Name: Enter the bucket name.

   • Upload Path: Enter the upload path for the export data.

   Note	You must add a data-out@dna-spaces.iam.gserviceaccount.com service account and provide role as Storage Object Admin in the Identity and Access Management (IAM) Service.

5. For the connection type Box, in the Upload Path field, enter the folder name created in Box for exporting the data and click Authenticate.

   1. Ensure that a box account is available to authenticate Data Export.

   2. Enter the same username and password credentials to authenticate to the box. Single sign-on (SSO) method for authentication is not supported.

   Note	After a successful authentication, provide full access to Cisco Spaces to access files in the box location. Click Grant access to box to grant full permission to Cisco Spaces to export the data. Custom data export is currently not supported for box destinations.

Step 13

Click Connect.

Step 14

Click Next to navigate to Summary.

Step 15

In the Add a name to your data export field, enter the name for the data export.

Step 16

Review the data export details and click Export.