Re: Stupid question about SQL Logger
I'd like to add some options to the plugin itself for extracting out comma delimited data, but that isn't in there yet. However, you can use the sqlite3 command line from the Terminal to get the information. Take a look at the example queries on the bottom of the plugin documentation page
You'll likely want to do something like:
- Code: Select all
cd /Library/Application\ Support/Perceptive\ Automation/Indigo\ 5/
sqlite3 -header -column indigo_history.sqlite "SELECT * FROM device_history_692773228;"
You can get the device ID needed by right-clicking on the device in Indigo. If you need comma delimited data, then take a look at this tutorial
which may help.