If you run sqlite3 from a terminal session and put Geoff's query into a file you can say
sqlite3 -csv path/to/file.gnucash < query-file > prices.csv and the results will be in prices.csv ready to open in your spreadsheet program. Regards, John Ralls > On Oct 16, 2022, at 7:36 AM, Elmar <etsc...@gmail.com> wrote: > > Thank you! It worked! I got DB Browser for SQLite running on Linux Mint, > exported the GC file to sqlite3, opened in the program, and ran the code. I > couldn't figure out how to export the resulting table into csv, but simply > highlighted the thing, and copy/pasted it into LibreOffice Calc. Just need > to copy over the column headings and it's what I needed done. Again, thank > you for the expertise and the help! > > - Elmar > > On 10/16/22 03:57, Geoff wrote: >> David - good idea! >> >> Elmar - please see updated SQL here: >> https://wiki.gnucash.org/wiki/PostgreSQL-Requests_For_Direct_Database_Access#Extract_prices_and_associated_descriptions >> >> >> Thanks >> >> Geoff >> ===== >> >> > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
