grist-core icon indicating copy to clipboard operation
grist-core copied to clipboard

Download Grist document as SQLite without any meta

Open Vladimir-Va opened this issue 3 years ago • 2 comments

We can download a document containing all the metadata, please consider adding the ability to download in SQLite format only tabular information in accordance with acl, with attachments, similar to xlsx. For transfer and use immediately for reports and use in third-party projects.

Vladimir-Va avatar Apr 26 '22 19:04 Vladimir-Va

Thanks @Vladimir-Va. Just for clarity, what kind of metadata would you like to see omitted? Do you mean the _grist* tables?

paulfitz avatar Apr 29 '22 13:04 paulfitz

I want to get only the data of tables with attachments, the fact is that fields like Attachment have links to _grist_Attachments. Also other service fields (gristHelper_Display). It is necessary to get the data in SQLite exactly in the format as the user sees on the screen without the service _grist* tables. I'm trying to connect SQLite to MS Visio, I also have to write queries for a long time. And a user who is not familiar with SQL will just leave this idea.

Vladimir-Va avatar Apr 30 '22 23:04 Vladimir-Va