formulahendry
Export to CSV or any other machine readable format, save to file
I would like to be able to use the results with other code. Currently it just outputs a very nice view, but you have to manually select all output (no ctrl+a) and then the results are tab delimited.
For large results with text content tab delimited is useless because the text content might have tabs in it.
A simple csv, comma separated values, maybe with quote delimiters, would be much more useful. I like the current view, but if it could output to a file, that would be optimal.
The current view type seems to create a sqlresult://mysql/data, which then triggers Windows Store to search for an app that will open that file type every time you return a result.
Whatever the easiest simplest export format file type would be preferable to scraping from the current rendered view.
+1 for this. I'd love to use this extension to replace SequelPro, and this workflow would enable me to do so (written out as it works in SequelPro, but anything similar/better would be fine :-) ):
- run query
- cmd-a to select the entire resultset
- cmd-c to copy to clipboard (or right-click > "Copy with column names" is nice)
- paste in a spreadsheet, e.g. Google Sheets, to share with non-technical types, or some data-vis program.
Another +1 for this Wonder if there is an alternative (workaround) at the moment to export to csv
