Re: [GNC] Transaction Imports

2022-04-11 Thread Stu Perlman
Thank for the heads up. On Mon, Apr 11, 2022 at 3:03 PM D wrote: > Not going to go into great detail here, but you definitely DON'T want to > have gnucash calculate shares. Have it calculate price. > On Apr 11, 2022, at 11:21, Stu Perlman wrote: >> >> Hello Everyo

[GNC] Transaction Imports

2022-04-11 Thread Stu Perlman
Hello Everyone, I am looking for some guidance on how to import a few hundred transactions from my 401(k) account. Unfortunately, the plan administrator does not offer a good option for exporting the transaction data but I am able to get what I need with some basic web scraping. I have been exper

Re: [GNC] Exiting gnucash Lock file Vol 226, Issue 57

2022-01-22 Thread Stu Perlman
Hello, It's been quite a while since I have chimed in here. At the risk of going off-topic for a moment, I'd like to start by expressing my gratitude to the entire team that develops and maintains GnuCash. I switched from Quicken on 1/1/2020 and have never looked back. I started with GnuCash 2.8,

Re: [GNC] XML vs SQL data integrity question

2020-05-09 Thread Stu Perlman
xboxes and > selected files to a Windows 10. > > David Cousens > > > > > On Thu, 2020-05-07 at 11:37 -0400, Stu Perlman wrote: > > I'm running MySQL for a GNC backend. I switched about 4 months ago. So > > far, so good and I love the ability to have direct acces

Re: [GNC] XML vs SQL data integrity question

2020-05-07 Thread Stu Perlman
I'm running MySQL for a GNC backend. I switched about 4 months ago. So far, so good and I love the ability to have direct access to mostly normalized data whenever I want. Every so often, if I leave my computer idle for a long time I'll get a failed to save to database error if GNC was left runni

Re: [GNC] Adding Transactions From Another Program

2020-04-30 Thread Stu Perlman
module at this time? On Tue, Apr 28, 2020 at 6:07 PM Stu Perlman wrote: > David, I did look at the Python bindings info a while back but at the time > did not feel like getting started with Python because I just wanted to get > done what I wanted to get done. I'm mostly a .NET &

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread Stu Perlman
he program or return unaccessible values. Please file a bug > report if you find one to help support the development process. > > On Wed, 29 Apr 2020 at 07:44, Stu Perlman wrote: > >> Hal, >> >> I'm sort of doing a liter version of what you are describing. I d

Re: [GNC] Adding Transactions From Another Program

2020-04-28 Thread Stu Perlman
Hal, I'm sort of doing a liter version of what you are describing. I do manipulate some GC data from outside of GC. I have GC setup with the MySQL backend and while I don't create any new transactions from outside of GC I do manipulate them. I have some SQL routines that I created to clean up dat

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-16 Thread Stu Perlman
#x27;: > # You could use this this way: > file1 = r"E:\temp\Dropbox\OurAccount\OFX\80_Patelco_Checking.ofx" > file2 = r"E:\temp\Dropbox\OurAccount\OFX\79_Patelco_Checking.ofx" > file3 = r"E:\temp\Dropbox\OurAccount\OFX\77_Patelco_Visa.ofx" > all

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-15 Thread Stu Perlman
t; I hacked some python code to do that if you're interested. I'm taking > ofx files, reading them and combining them just the way you describe it. > It's not beautiful code but it works. > What would be awesome would be if you could select multiple files in GC, > and then do

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-15 Thread Stu Perlman
s that appear in OFX files that I receive I only > gave selected examples not a complete definition. One would need to get a > copy of the OFX standard for completeness. > > > > > On Tue, Apr 14, 2020, 3:14 PM Stu Perlman wrote: > >> Jean, I always assumed it wa

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-14 Thread Stu Perlman
M, Ove Grunnér wrote: > > Ah, I was talking of QIF, not QFX, sorry about that. > > yes the java code writes QIF. > > Ove. > > > > On Tue, 14 Apr 2020 at 20:45, Stu Perlman wrote: > > > >> Ove, > >> > >> Thanks for the info that you sha

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-14 Thread Stu Perlman
!Type:" + type + "\n"); > > >> info.write("D" + date + "\n"); > > >> info.write("T" + amount + "\n"); > > >> info.write("P" + description +"\n&quo

Re: [GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-04-14 Thread Stu Perlman
+ amount + "\n"); >> info.write("P" + description +"\n"); >> info.write("L" + category + "\n"); >> info.write("^" + "\n"); >> } >> } >&g

[GNC] OFX Import with Multiple Banks/Accounts in a single file

2020-03-13 Thread Stu Perlman
Hello, I am using GNC on Windows 10. I have a fairly recent build, dated March 9 from the maintenance branch. I noticed that I'm still unable to use AqBanking to get OFX data from Citi into GNC. I Did a little exploring and discovered that if I manipulate the file in C:\tmp\ofx.log and break it

Re: [GNC] Transaction Import

2020-03-01 Thread Stu Perlman
Thank You, David. I'll have to look into what Citi allows (or not). I don't recall seeing categories in their OFX feed but then again, I was not looking for them! - Stu On Sun, Mar 1, 2020 at 6:21 PM David Cousens wrote: > Stu, > > You can disable the Bayesian matching with Edit->Preference

[GNC] Transaction Import

2020-03-01 Thread Stu Perlman
I would like to have GnuCash import all of my transactions using a default transfer account without having to look for mismatches in the Import Matcher. It's easier for me to just bring everything in with the transfer account going to a single holding account that I use as a queue to show me trans

Re: [GNC] How to managing budget in gnucash ?

2020-02-25 Thread Stu Perlman
This is probably not the answer that you are looking for, but I'm new to gnucash and have also been trying to make the included budgeting features work for me. I'm a database guy at heart so after a few weeks of working with the included budget tools, I set up a MySql backend. Subsequent to portin

Re: [GNC] Register layout

2020-02-21 Thread Stu Perlman
John, this may be a silly question but GC keeps track of register column widths from session to session after they are changed. Where does that information get saved? I thought it might be in books.gcm but I'm not so sure. On Fri, Feb 21, 2020 at 12:03 AM John Ralls wrote: > > > > On Feb 20, 2