Re: [GNC] Importing data from QuickBooks Online

Just to add that the reconcile flag is sort of a moot point right now because it seems like there is a bug with the multi-split import where the flag is ignored and set to cleared for the first account on each transaction. See 796890 – CSV import of multi-split transactions marks reconciliation

Re: [GNC] Importing data from QuickBooks Online

Tom: I tested both files and it seems that it fails on the reconcile column for 2022. When I skip the reconcile column it works. 2022 has Y entries in that column while 2023 doesn't, and when I replace the 2022 Y entries with c it works. So it seems to be related to either the inability to import

Re: [GNC] What is wrong with this custom stylesheet code?

HI Robert: Here are a few things you need to change: That very last statement (gnc:make-html-style-sheet "DWS_Stylesheet" (N_ "DWS Stylesheet")) the first parameter is actually the template name defined just above, so it should be "DWS Stylesheet" without the underscore. The second parameter is

Re: [GNC] Importing data from QuickBooks Online

Vincent, Good suggestions. I’ve attached 2 files, 3 transactions each, for 2022 and 2023. Instructions for importing them are in the documentation of the script, latest version also attached. 2022 still fails, 2023 still works. Create the accounts as needed; there are only a few. -- Tom

Re: [GNC] Where is config-user.scm supposed to be under Linux

At Mon, 3 Jul 2023 16:04:23 -0400 Jean-David Beyer wrote: > > On 7/3/23 15:28, David H wrote: > > Sure is, which is why I phrased my reply as more of a question :-) Sorry I > > should have suggested doing "Help >> About" - the popup shows a lot of > > config file locations and might be a

Re: [GNC] Importing data from QuickBooks Online

Tom: I haven't read every single email in this thread but have this advice for you to further diagnose. When I face a puzzle like this, I like to try creating the simplest possible scenario in which I am still able to reproduce the problem. In this case this would start by figuring out how far

Re: [GNC] Importing data from QuickBooks Online

I would add that I’m more inclined to attribute the problem to GnuCash logic. However, the code will require a lot of study on my part before I can make meaningful sense of it. I just wish I could think of some possible logic that might explain it. -- Tom Money is created out of thin air when

Re: [GNC] Importing data from QuickBooks Online

Ken, That’s a better theory than anything I’ve come up with so far. However, that would seem to get it backwards. Presumably, they might allow export of 2022 but not 2023. In my case, it was 2022 that failed. If they managed to do something like that, how might they do it? The only idea I

Re: [GNC] Finance-Quote 1.57 released!

On 7/2/23 18:27 EDT, Bruce S wrote: I should have taken a closer look at the data before posting. For this release I added a quick way to count F::Q usage. It is just a simple web fetch of a URL containing the method (yahoo_json, fool, alphavantage, etc). Just 48 hours after pushing F::Q

Re: [GNC] Importing data from QuickBooks Online

Tom -- I believe at the beginning of 2022, QuickBooks went from being a desktop and online software package - to being strictly/only online. With that transition, I believe they also gave a one-year period where you could export data. While this may be a stretch, I believe that they may have

Re: [GNC] Where is config-user.scm supposed to be under Linux

Optional file to extend Gnucash, if it's not there you haven't bothered to create one and Gnucash will work fine without one ? Cheers David H. In GNC_CONFIG_HOMEconfig-user.scmthis file is the entry point to extend GnuCash by means of the guile scripting language. It's most often used to load

Re: [GNC] Importing data from QuickBooks Online

Good shot, but no, date formats are consistent. -- Tom The federal government imposes a tax on you so YOU need THEIR money, not because they need yours. > On Jul 3, 2023, at 4:52 PM, Kalpesh Patel wrote: > > I am likely grasping straws here like David but did you verify the format of > the

Re: [GNC] Importing data from QuickBooks Online

I am likely grasping straws here like David but did you verify the format of the date that it is consistent throughout? Like it isn’t switching from two digits to four digits, or replace certain digits with place holders, etc. QuickBooks is (was?) published by the maker of Quicken and I

Re: [GNC] Where is config-user.scm supposed to be under Linux

On 7/3/23 15:28, David H wrote: Sure is, which is why I phrased my reply as more of a question :-) Sorry I should have suggested doing "Help >> About" - the popup shows a lot of config file locations and might be a better guide Cheers David H. On Mon, 3 Jul 2023 at 21:26, Robert Heller

Re: [GNC] Where is config-user.scm supposed to be under Linux

Sure is, which is why I phrased my reply as more of a question :-) Sorry I should have suggested doing "Help >> About" - the popup shows a lot of config file locations and might be a better guide Cheers David H. On Mon, 3 Jul 2023 at 21:26, Robert Heller wrote: > At Mon, 3 Jul 2023

Re: [GNC] Importing data from QuickBooks Online

All records came from the same account tree at the same time. We need more straws!!! :-) -- Tom How many dollars would you own if the federal government had balanced its budget every year since the founding of our country? (Hint: It’s an exact number.) > On Jul 3, 2023, at 2:32 PM, David

Re: [GNC] Importing data from QuickBooks Online

Really grasping at straws now, but invisible characters/extra spaces in the 2022 account names? -- Dave Reiser dbrei...@icloud.com > On Jul 3, 2023, at 12:29 PM, Tom Olin wrote: > > David, > > Both import files were generated from the same 2-year QBO export, so they > have identical

Re: [GNC] Finance-Quote 1.57 released!

On 7/1/23 at 16:09 EDT, Bruce S wrote: For this release I added a quick way to count F::Q usage. It is just a simple web fetch of a URL containing the method (yahoo_json, fool, alphavantage, etc). Just 48 hours after pushing F::Q v1.57 to CPAN, these are the current counts. Assuming with a

Re: [GNC] Importing data from QuickBooks Online

David, Both import files were generated from the same 2-year QBO export, so they have identical structure. The process was: QBO export -> convert to CVS -> my script -> unified import file (CVS) The problem occurred identically whether I imported the unified file or just the 2022 data

Re: [GNC] Importing data from QuickBooks Online

Jean, Thanks for that. I did play with a few similar options but couldn’t get anything to work easily. Some were aimed more at Quicken or QuickBooks desktop instead of QuickBooks Online. As it turns out, my minimal script seems to work very well with this one weird anomaly. The nature of it

Re: [GNC] Importing data from QuickBooks Online

So, the year isn’t the sticking point. If you look at the .xls files — one transaction from 2022 and one from 2023 — do you see a difference? If you move a 2023 transaction to 2022, does it import correctly, or fail? I’m guessing there’s a column missing in the 2022 xls file. -- Dave Reiser

Re: [GNC] Importing data from QuickBooks Online

This may be slightly off topic, or too late to help, but... In github, there is a repository https://github.com/tim-rohrer/move2gnucash That seems pretty well setup to migrate your data from a quicken csv export to GC. I haven't used it, but I looked at it for a friend and it looked

Re: [GNC] Gnucash chat only by invite

Do not email GnuCash core team members directly unless you're expressly invited to. Always use the mailing lists or IRC. GnCash's IRC channel is on irc.gimp.net . The one on irc.gnome. org is a tombstone, see https://wiki.gnucash.org/wiki/IRC#Usage

[GNC] What is wrong with this custom stylesheet code?

I have written a style sheet module and it *seems* to be loading now, but things are wonky any I don't know why. What I am *trying to go: 1) Put my company letterhead across the top of the invoice 2) Put a "button image" (Payments by PayPal) under the invoice table. My custom stylesheet code

Re: [GNC] Default to Plain English instead of Debit and Credit

The responses make it clear Vince's results are as expected. Why are mine different? See https://bugs.gnucash.org/show_bug.cgi?id=798964#c14 On Sat, 1 Jul 2023 at 14:00, flywire wrote: > Is it CR or DB? > Regards ___ gnucash-user mailing list

Re: [GNC] Where is config-user.scm supposed to be under Linux

At Mon, 3 Jul 2023 07:26:39 -0400 (EDT) Robert Heller wrote: > > At Mon, 3 Jul 2023 11:28:18 +1000 David H wrote: > > > > > Hi Robert, > > > > https://wiki.gnucash.org/wiki/Configuration_Locations doesn't help ? > > Nope. At least it doesn't help as far as I can tell. It is a bit

Re: [GNC] Where is config-user.scm supposed to be under Linux

At Mon, 3 Jul 2023 11:28:18 +1000 David H wrote: > > Hi Robert, > > https://wiki.gnucash.org/wiki/Configuration_Locations doesn't help ? Nope. At least it doesn't help as far as I can tell. It is a bit confusing though. It talks about $HOME/.gnucash and $HOME/.local/share/gnucash and I am