search

coolPrat / and-bookworm

Automatically exported from code.google.com/p/and-bookworm
0 stars 0 forks source link

Allow user to export data (for external save/export/import and print view) #28

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
Users have asked for way to export and print out/display the data in other 
apps. 

Until the sync with other online sources is ready, make an export to email, 
and a way to import from a selected DB file (any location on external 
storage, rather than just one path it now uses). That way any user could 
email themselves a backup db, and then use it to import to another phone, 
share, etc. 

Also, make an export to HTML or TEXT format for print/view.

Original issue reported on code.google.com by charlie....@gmail.com on 11 Apr 2010 at 11:09

GoogleCodeExporter commented 8 years ago 
With group_concat, using a specified separator, basically this query (with col 
headers) is what we need for export:

select book.bid as _id, book.tit, book.subtit, book.pub, book.datepub, 
book.format, 
bookuserdata.rstat, bookuserdata.rat, bookuserdata.blurb, 
group_concat(author.name) as 
authors from book join bookuserdata on book.bid = bookuserdata.bid join 
bookauthor on 
bookauthor.bid = book.bid join author on author.aid = bookauthor.aid group by 
book.bid

Original comment by charlie....@gmail.com on 2 May 2010 at 1:50

GoogleCodeExporter commented 8 years ago 
Added menu items for this, but to do it right we need to not just "send" a CSV 
to 
somebody, but also allow import CSV from SD card to replace database (send your 
list 
to your friend, or to your new phone, etc.).

Original comment by charlie....@gmail.com on 2 May 2010 at 11:00

GoogleCodeExporter commented 8 years ago 
Make sure this export works with current list sort, and current list filter 
(maybe as 
a pref?).

Original comment by charlie....@gmail.com on 15 May 2010 at 1:42

GoogleCodeExporter commented 8 years ago 
Simple EXPORT is done. Leaving this open though as should honor filter, and 
should 
have importer based on export.

Original comment by charlie....@gmail.com on 26 May 2010 at 1:41

GoogleCodeExporter commented 8 years ago 
Importer done. Filter priority is very low, and may just be confusing, so won't 
do right now.

Original comment by charlie....@gmail.com on 14 Jun 2010 at 1:42