iOS – Best App for Exporting HomeKit Data to CSV

csviossoftware-recommendation

I have bought an Elgato Eve HomeKit-compliant weather sensor. It works well enough but unfortunately its accompanying app does not support data export.

From what I understand about Apple HomeKit, other apps should be capable of accessing HomeKit data that is stored on the same device (as e.g. from the weather sensor), if I permit them to do so.

So is there a (perhaps generic) iOS app that would allow me to see all HomeKit data stored on my iPhone and to export it (e.g. send CSV file by e-mail, or similar).

UPDATE In terms of Apple's HomeKit framework temperatures seem accessible as HMCharacteristics e.g. of type HMCharacteristicTypeCurrentTemperature inside an HMService of type HMServiceTypeThermostat. I have not found yet whether the HomeKit framework natively supports the notion of historic data (e.g. past temperatures). Apple's HMCatalog sample app indicates that the specific device also maintains a number of private characteristics, some of which could (perhaps) be related to historic data. Alternatively it could also be that all temperatures arrive in Elegato Eve's app as notifications and that hence historic data is only supported on the level of this app.

Best Answer

I've been able to solve this as follows:

  • use iTunes to sync from iOS to Mac to create unencrypted iPhone backup
  • obtain and start iPhone Backup Extractor for OS X
  • select latest backup, then Expert Mode, then Application Domains, then com.elgato.eve, Documents, Elgato Systems##EveWeather##*sql (* stands for what looks like a device serial number) and extract SQL file to ~/Desktop/
  • sqlite3 ~/Desktop/Application\ Domains/com.elgato.eve/Documents/Elgato Systems##EveWeather##*sql reveals that the database contains 3 tables, one for humidity, temperature, and air pressure each
  • export tables e.g. to CSV files, then import e.g. into Excel