Data Exports

In this article:


 

The Export feature enables you to access bulk data from your organization including information on all the key accesses (bookings) that you have authorized, information about your organization's keys, and all key exchanges performed at your organization's SmartBoxes.

Once you configure and submit your export, Keycafe will begin processing it and you will receive an email from Keycafe when your data is ready. The email will contain a download link you must click on to download the data as a .csv file. Please note that to download the file, you must be logged into the same Keycafe account that was used to request the report, and it may take up to 10 minutes to generate the requested data.

No Data Exports on Mobile

Note that data exports can only be done on the desktop app.

 

Exporting your Accesses Data


You are able to download a .csv file of the accesses (bookings) in your organization. The data will contain information such as the start date of the access, its current status, and the key it relates to.

  1. Log in to Keycafe desktop.
  2. Select Settings.
  3. Select Exports.
  4. Select Accesses.
  5. The timezone will be set to your detected system timezone. If you'd like, choose another timezone.
  6. Select Export Data.
ID Email Mobile Name Key ID Key Name Created Start Date End Date State
432143214 123@keycafe.com +1 555-444-3333 Bob Smith 414423910 Jason's Home Keys 2019-03-26 18:37:40 UTC 2019-03-26 11:00:00 2019-03-27 23:30:00 Cancelled
321032103 345@keycafe.com +1 777-666-3333 Jason Brown 409283789 Gym Keys 2019-01-10 09:40:02 UTC 2019-01-11 15:00:00 2019-01-23 23:30:00 Expired

 

Exporting Your Key Data


You can export a .csv file with data on all the keys ever created in your organization, including retired keys. The data includes the key's name, serial number, creation date, status, description, the date it was last picked up and dropped off, key code, and home location details.

  1. Log in to Keycafe desktop.
  2. Select Settings.
  3. Select Exports.
  4. Select Keys.
  5. The timezone will be set to your detected system timezone. If you'd like, choose another timezone.
  6. Select Export Data
Key ID Key Name Serial # Created Status Subscribed Retired Key Description Last Pickup Last Dropoff Key Code Enabled Code Home Location Address URL
612768390 Red F150 P3MP7T 2023-02-17 22:05:35 UTC Checked Out Yes No AB6 98S 2019-03-26 11:00:00 2019-03-27 23:30:00 No   Garage 1234 Main Street, Vancouver https://www.keycafe.com/desktop/#!/keys/123456789/accesses
519916384 Front Door M5NCXR 2020-03-11 22:24:09 UTC Awaiting Drop Yes No Office front door deadbolt 2019-01-11 15:00:00 2019-01-23 23:30:00 Yes 1234 HQ Office 5678 Water Street, New York https://www.keycafe.com/desktop/#!/keys/987654321/accesses

 

Exporting Your Key Exchanges


You can export a .csv file with data on all the key exchanges performed at SmartBoxes in your organization.

  1. Log in to Keycafe desktop.
  2. Select Settings.
  3. Select Exports.
  4. Select Key Exchanges.
  5. Specify the date rage.
  6. The timezone will be set to your detected system timezone. If you'd like, choose another timezone.
  7. Select Export Data.
Event ID Key ID Key Name Type First Name Last Name Email Mobile Location SmartBox Bin Date
772634583 414423910 Bob Smith's Ford F150 PICKUP Bob Smith bob@keycafe.com 16041234567 Garage 56774-KSTGH A-5 2025-09-12 23:00:57 UTC
Was this article helpful?
0 out of 1 found this helpful