jakob / jakob/Postico

Export query as raw data

Open
#518 2 comments 0 reactions 0 assignees View on GitHub
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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.