FreeWave allows end-users to export data from your Fusion Mini.
Click on Devices and then click on Export Measurement Data.
In the drop-down, select the Fusion Mini you would like to see data for,
You can use the Date picker is select custom date ranges.
Once that has been set, click the Export Data button. Click that to begin the process.
You will receive this message.
And you should receive this email.
Open the email and click on the Download link provided
The file will now be downloaded to your computer The file will be delivered as a CSV.
Inside the file, you will see all available columns for that specific Fusion Mini listed in alphabetical order. Bluetooth devices that have communicated with a Fusion mini during the export period are also included. There is a Bluetooth address column that displays the relevant device's MAC address as a way to know which Bluetooth device it is.
The columns are displayed in alphabetical order.
Exporting multiple devices
You can export data from multiple Fusion Mini's at once.
Select the relevant gateways from your organization and click Export Data.
You will receive one file with both sets of data together in one sheet. The data will be delineated by the DEVICEID column.
Notes on the "timestamp" column
The timestamp column by default gets exported as a "General" column type which converts the date./time to decimal.
Note: If you are planning on using the data set in a third-party BI product, you don't specifically need to convert this column to a readable date/time within Excel.
To convert to readable date/date, highlight the column and click the arrow beside General and select More Number Formats.
In the dialog box, at the bottom of the category window, select Custom.
Scroll down the list in the Type window and select d/mm/yyyy h:mm. This will convert the timestamp to a readable form.
The timestamp column is displayed as UTC/GMT.
To display in a different timezone, find out the hours difference +- from GMT.
If the first GMT sample is A2 and you want to know what the time is in Texas (GMT -5) for when the sample was taken. In a new Excel column, enter the formula: =A2 - TIME(5,0,0). This will display the time in that specific timezone.