[GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-25 Thread flywire
TLDR: GnuCash Windows version is compiled on linux so, considering the note below, you are unlikely to get python bindings working in Windows. > Important > The Python extensions are an optional feature which creates additional > dependencies. To be > able to use Python scripts, GnuCash must

Re: [GNC] Regularly importing transactions from CSV files

2022-07-25 Thread Mateja Maric via gnucash-user
Hey Phyllis, thanks for the advice! Sadly my bank only offers my transaction history in CSV and HTML format... I'll definitely make backups before I do any work and minimize how often I import transactions. Too bad there isn't an undo button in GnuCash, yet. :) On 7/25/22 00:28, Phyllis Bruce

Re: [GNC] Regularly importing transactions from CSV files

2022-07-25 Thread Mateja Maric via gnucash-user
* The account is your bank account and the transfer account is the other account. Thanks, this helped a lot! * Options, when you mess up importing many transactions, don't save theĀ file or delete them and import again. I don't see how can I bulk delete transactions. On 7/25/22 00:01, flywire

Re: [GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-25 Thread john
> On Jul 25, 2022, at 9:30 AM, Eric Hammond wrote: > > Are there tutorial examples / videos for using Python and/or Sqlite3 to work > with GnuCash. > I have never used Sqlite, and my Python experience is mostly industrial, and > outdated. > (Like, what are bindings?) Google found no

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Thanks for your perspective on this. With my recent experiences with lots, I think I'll keep this simple. On July 25, 2022 7:01:41 PM GMT+03:00, David Carlson wrote: >To me, the former name and the date of the change are important. It is >easy to add a dummy transaction in the register to

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Thanks John. I appreciate it. On July 25, 2022 6:58:12 PM GMT+03:00, john wrote: > > >> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user >> wrote: >> >> Hello, >> >> I'm seeking advice from the group about the best way to handle a ticker/name >> change for a held stock. >> >> For

[GNC] tutorials or examples for connecting/programming for GnuCash data access

2022-07-25 Thread Eric Hammond
Are there tutorial examples / videos for using Python and/or Sqlite3 to work with GnuCash. I have never used Sqlite, and my Python experience is mostly industrial, and outdated. (Like, what are bindings?) Thanks for any and all help Eric *

Re: [GNC] Revisiting the pre-paid invoice (coupon, credit note)

2022-07-25 Thread Eric Hammond
Thank you all for valuable input on this. Version 4.10 appears to have resolved the issue, I can now enter invoices, bills and payments with the needed accounts. Victor, I don't know how my entries were different from yours. Now it works for me too. Thanks Eric Victor: I w Date: Thu, 14 Jul

Re: [GNC] Linked Documents on Import

2022-07-25 Thread john
Piecash isn't supported either, because it also doesn't use the GnuCash API to write to the database. The supported way--that works with either the XML or SQL backend--is to use the Guile or Python bindings to the GnuCash libraries. You can also write your program in any compiled language that

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread David Carlson
To me, the former name and the date of the change are important. It is easy to add a dummy transaction in the register to record those pieces of information plus whatever other details might be important. Then editing the stock names and tickers allow price downloads to resume. However,

Re: [GNC] Stock Name Change Best Practices

2022-07-25 Thread john
> On Jul 25, 2022, at 5:58 AM, David T. via gnucash-user > wrote: > > Hello, > > I'm seeking advice from the group about the best way to handle a ticker/name > change for a held stock. > > For example, Facebook renamed itself Meta a while back, and in June they > changed their ticker

Re: [GNC] need to teak the default invoice script - new user

2022-07-25 Thread john
> On Jul 25, 2022, at 3:42 AM, peter wrote: > > Hello all, > > I am new to GNUcash - spent many hours getting to grips with the new system > (came from Quick Books) and finally got my small business accounts set up and > working reasonably well. > > However, I operate two trading names of

Re: [GNC] Linked Documents on Import

2022-07-25 Thread Robert Simmons
I definitely wouldn't expect this to be supported. I did take a look at PieCash and see how it handles working with the "slots" table. There doesn't appear to be any other housekeeping that is done other than the INSERT commands. As long as the INSERTS are properly formed and I'm not doing this

[GNC] Stock Name Change Best Practices

2022-07-25 Thread David T. via gnucash-user
Hello, I'm seeking advice from the group about the best way to handle a ticker/name change for a held stock. For example, Facebook renamed itself Meta a while back, and in June they changed their ticker from FB to META. Naturally, I wish the Gnucash books to reflect these changes; I also

Re: [GNC] Linked Documents on Import

2022-07-25 Thread Derek Atkins
You are definitely doing something terrible. You are modifying the database from under GnuCash. That is completely not supported and you may destroy your data. -derek Sent using my mobile device. Please excuse any typos. On July 25, 2022 7:42:04 AM Robert Simmons wrote: This seems to do the

Re: [GNC] Linked Documents on Import

2022-07-25 Thread Robert Simmons
I've run this after an import of 19 bills. The "Business Linked Documents" function in the UI is able to successfully run the "Reload and Locate Linked Documents" for all linked documents including the ones created using the kludge. Navigating to each individual bill and clicking on the document

Re: [GNC] Linked Documents on Import

2022-07-25 Thread Robert Simmons
This seems to do the trick. Not sure if I'm doing something terrible here. I don't recommend you do this unless you know what you're doing (I don't lol). https://gist.github.com/utkonos/1dad74716828c591c9839711fdb12f22 import pathlib import sqlite3 bills = [{'id': '01', 'date_opened':

[GNC] need to teak the default invoice script - new user

2022-07-25 Thread peter
Hello all, I am new to GNUcash - spent many hours getting to grips with the new system (came from Quick Books) and finally got my small business accounts set up and working reasonably well. However, I operate two trading names of the same business and need to be able to invoice the two