[GNC] Solved - Re: Price database

[John Ralls]

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 <etschme at 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 at 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.