Export query as raw data
- Dominant language
- Python
- Stars
- 485
- Forks
- 8
- PR merge metrics
- No merged PRs in 30d
Description
In menu File/Export, it is possible to export data as a CSV file, which is very good.
However, in one of my projects, I am producing html data (returned from my query) , which I want to send to my browser.
Using the File/Export facility, this is not possible as Postico will try to "comma separate" the data being exported.
Example: my query result contains the text "....", which when exported is transformed into " ... (notice that the symbol " has been escaped/doubled)
Equally, the column name is inserted on top of the exported data.
May I suggest 3 changes to the export facility:
1) An option to include or omit the column headers in the exported data
2) In the "Format" drop down, a new option "raw" to save the data as returned from the query
3) A new checkbox to automatically open the exported data file (using Mac Os facility /usr/bin/open) once it has been created
3a) As a nice to have, offer an option to create a new mail with the exported file in attachment
Should be easy to implement, shouldn't it?
Cheers
Remy
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at the File/Export menu flow and review how CSV output adds column headers and escapes returned values. The work is complete when export supports optional headers and raw query data, with an option to open the created file via /usr/bin/open; email attachment creation is described as optional.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- desktop
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100