Re: [GNC] Importing historical stock prices to GnuCash in Windows
You may want to look at https://github.com/ka-patel/dl_quotes/tree/main/yfinance which is Python based... -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 AM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Further to the point, I've used Google Sheets financial functions to retrieve stock prices pretty quickly. Those functions can pull prices for any given date, so you could set some dates and import them that way. It's not ideal, but it could get things done in a pinch. David T. On May 10, 2024, 11:31 AM, at 11:31 AM, Leung Wing Cheong wrote: >Got it, many thanks! >Wing > >-Original Message- >From: sunfis...@yahoo.com >Sent: Friday, May 10, 2024 2:59 PM >To: Leung Wing Cheong >Cc: gnucash-user@gnucash.org >Subject: Re: [GNC] Importing historical stock prices to GnuCash in >Windows > >Of course there is. The csv importer can handle any price data, >including historical data, as long as you supply the proper dates along >with the other data elements. > >The challenge is gathering that price data in the first place. It used >to be possible to retrieve unlimited price quotes from a number of >online sources, but those days are gone, sadly. > >At one point in the past, I used a perl module to retrieve monthly >prices for all my commodities and put them into the GnuCash price >history, but the module depended on Yahoo!, which no longer allows that >level of data gathering. > >David T. > >On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong > wrote: >>Hi, >>Is there any way to import historical stock prices to GnuCash in >>Windows? >>Thanks, >>Wing >>___ >>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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Got it, many thanks! Wing -Original Message- From: sunfis...@yahoo.com Sent: Friday, May 10, 2024 2:59 PM To: Leung Wing Cheong Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Importing historical stock prices to GnuCash in Windows Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >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.
Re: [GNC] Importing historical stock prices to GnuCash in Windows
Of course there is. The csv importer can handle any price data, including historical data, as long as you supply the proper dates along with the other data elements. The challenge is gathering that price data in the first place. It used to be possible to retrieve unlimited price quotes from a number of online sources, but those days are gone, sadly. At one point in the past, I used a perl module to retrieve monthly prices for all my commodities and put them into the GnuCash price history, but the module depended on Yahoo!, which no longer allows that level of data gathering. David T. On May 10, 2024, 6:17 AM, at 6:17 AM, Leung Wing Cheong wrote: >Hi, >Is there any way to import historical stock prices to GnuCash in >Windows? >Thanks, >Wing >___ >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.
[GNC] Importing historical stock prices to GnuCash in Windows
Hi, Is there any way to import historical stock prices to GnuCash in Windows? Thanks, Wing ___ 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.
Re: [GNC] Trouble importing .qif into Guncash
Yes, use a recent nightly build from https://code.gnucash.org/builds/flatpak/stable. Regards, John Ralls > On May 4, 2024, at 22:04, David Wasserman via gnucash-user > wrote: > > Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub > 5.6-2. > Gnucash Import fails at final screen with error message. Is there a fix? > > David W > ___ > 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.
Re: [GNC] Trouble importing .qif into Guncash
On 5/5/24 3:04 pm, David Wasserman via gnucash-user wrote: Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub 5.6-2. Gnucash Import fails at final screen with error message. Is there a fix? David W ___ 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.
[GNC] Trouble importing .qif into Guncash
Recently upgraded to 24.04 LTS. Gnucash Version: 5.6. Build ID: Flathub 5.6-2. Gnucash Import fails at final screen with error message. Is there a fix? David W ___ 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.
Re: [GNC] importing or pasting reports into spreadsheets
I do this using the "Export" choice in GnuCash, saving the report as an html file on the desktop, then right-click + open with LibreOffice Calc. In addition to what Hop said below about ticking the box for: "Detect special numbers (such as dates)" in the import ... I also need to do this step: - Select the entire column of numbers that aren't numerical values, by clicking on the letter at the column header) - In the "Data" menu dropdown, select "Text to Columns", then click OK. Hope that helps too. Chris (Xubuntu 22.04, Xfce desktop, GnuCash 5.4 flatpak, LibreOffice 7.3.7.2) On 4/14/24 02:01, gnucash-user-requ...@gnucash.org wrote: Date: Sat, 13 Apr 2024 20:53:32 -0500 From: David Carlson To: "gnucash-user@gnucash.org" Subject: [GNC] importing or pasting reports into spreadsheets I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not recognize them. It also looks like dates are in some form of text as they have a format code "@" whatever that means. I am not very proficient with these format issues. Does someone know of an elementary reference that is easier to understand than the spreadsheet help file? Just in case it makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 with a LXQT desktop. -- David Carlson -- Date: Sun, 14 Apr 2024 12:20:35 +1000 From: Alan Hopkins To: David Carlson Cc: GnuCash users group Subject: Re: [GNC] importing or pasting reports into spreadsheets Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers Hop ___ 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.
Re: [GNC] importing or pasting reports into spreadsheets
Hello David, I do the same for my reports but paste it into Excel and whenever I had that issue I either use powerquery for the clean up or more quick and dirty approach of using functions to extract the correct figures, some MID/RIGHT function, within the CLEAN one wrapping the result and if you still have issues maybe using the VALUE formula to convert the final output (I would try this one first as it might work out with the previous ones) In any case I think not all the reports cause the issue of being pasted as text, so maybe if you try to play with formatting options to number first and set those setting by default in the file it might help you. Thanking you. Regards, Inma On Sun, 14 Apr 2024 at 02:54, David Carlson wrote: > I have found that I can select the text of reports directly in GnuCash, > then paste it into a Libre Office Calc spreadsheet. The problem then is > that values are preceded with a dollar sign in the US and it seems that > they are not currency numbers but some form of text, as numeric operators > do not recognize them. It also looks like dates are in some form of text > as they have a format code "@" whatever that means. > > I am not very proficient with these format issues. Does someone know of an > elementary reference that is easier to understand than the spreadsheet help > file? > > Just in case it makes a difference I am using GnuCash release 4.8 in > Lubuntu 22.04 with a LXQT desktop. > > -- > David Carlson > ___ > 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.
Re: [GNC] importing or pasting reports into spreadsheets
Hi David When you paste into Calc (I'll assume you are using Ctrl-v), you should get an Import options screen pop up in which you can tick a box "Detect special numbers (such as dates). I find this works for me (using different versions of Linux on differing hardware) I hope that helps! Cheers Hop On Sun, 14 Apr 2024, 11:54 am David Carlson, wrote: > I have found that I can select the text of reports directly in GnuCash, > then paste it into a Libre Office Calc spreadsheet. The problem then is > that values are preceded with a dollar sign in the US and it seems that > they are not currency numbers but some form of text, as numeric operators > do not recognize them. It also looks like dates are in some form of text > as they have a format code "@" whatever that means. > > I am not very proficient with these format issues. Does someone know of an > elementary reference that is easier to understand than the spreadsheet help > file? > > Just in case it makes a difference I am using GnuCash release 4.8 in > Lubuntu 22.04 with a LXQT desktop. > > -- > David Carlson > ___ > 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.
[GNC] importing or pasting reports into spreadsheets
I have found that I can select the text of reports directly in GnuCash, then paste it into a Libre Office Calc spreadsheet. The problem then is that values are preceded with a dollar sign in the US and it seems that they are not currency numbers but some form of text, as numeric operators do not recognize them. It also looks like dates are in some form of text as they have a format code "@" whatever that means. I am not very proficient with these format issues. Does someone know of an elementary reference that is easier to understand than the spreadsheet help file? Just in case it makes a difference I am using GnuCash release 4.8 in Lubuntu 22.04 with a LXQT desktop. -- David Carlson ___ 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.
Re: [GNC] View Transactions After Importing from CSV
Thank you. I filed the bug at https://bugs.gnucash.org/show_bug.cgi?id=799269 On Thu, Apr 4, 2024 at 9:06 PM Christopher Lam wrote: > Hi, enhancements should be logged in bugs.gnucash.org > > On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >> >I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> I have already set up some Scheduled Transactions. So often when I open >> GnuCash it gives me a "Since Last Run" window. That gives me some >> information about the transactions it is going to create. At the bottom of >> that window is a checkbox which says, "Review Created Transactions". If I >> check that box, then GnuCash will take me to the main app and there is a >> tab named "Created Transactions". There I can see the transactions which >> were just created. >> >> That is what I want to see for Imported Transactions. >> >> >> >> >> On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs >> wrote: >> >> > Yes, I see that. >> > But I mean that GnuCash should take me to a tab that looks like how it >> > displays the results of a Find Transaction. It opens a Register page and >> > shows only the matching transactions. >> > I think it already does that for the Scheduled Transactions. It says >> > something like, oh some time has passed, would you like me to create >> these >> > transactions which you created in the Scheduled Transaction window. >> Okay, >> > here is a register page showing the transactions I just created. >> > >> > >> > >> > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> > wrote: >> > >> >> During the actual importation process, GNC always shows a confirmation >> >> dialogue box to take an action on all transaction it found. This is >> where >> >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> >> clear matched one, 'C' to clear existing matched one, or select >> nothing and >> >> do nothing with that transaction. This is automatic -- ie there is >> nothing >> >> needs to be done, either via setting or manually, to trigger it to >> come up >> >> during every import. Note that if a transaction is matched >> incorrectly, you >> >> can check either 'U+C' or 'C" and then double clicking on it will >> bring up >> >> another dialogue box with a list of transactions it believe matches or >> are >> >> similar from which you can select on that it should match with. >> >> >> >> -Original Message- >> >> From: Tom Balazs >> >> Sent: Friday, December 22, 2023 7:02 AM >> >> To: Post to GnuCash User >> >> Subject: [GNC] View Transactions After Importing from CSV >> >> >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> >> transactions from that, and importing them into GnuCash. Is there an >> option >> >> where I can view the transactions I just imported? So they appear on >> one >> >> page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> >> can't find it again. >> >> >> >> Tom >> >> >> >> >> >> >> ___ >> 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.
Re: [GNC] View Transactions After Importing from CSV
Hi, enhancements should be logged in bugs.gnucash.org On Fri, 5 Apr 2024, 8:56 am Tom Balazs, wrote: > >I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > I have already set up some Scheduled Transactions. So often when I open > GnuCash it gives me a "Since Last Run" window. That gives me some > information about the transactions it is going to create. At the bottom of > that window is a checkbox which says, "Review Created Transactions". If I > check that box, then GnuCash will take me to the main app and there is a > tab named "Created Transactions". There I can see the transactions which > were just created. > > That is what I want to see for Imported Transactions. > > > > > On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs wrote: > > > Yes, I see that. > > But I mean that GnuCash should take me to a tab that looks like how it > > displays the results of a Find Transaction. It opens a Register page and > > shows only the matching transactions. > > I think it already does that for the Scheduled Transactions. It says > > something like, oh some time has passed, would you like me to create > these > > transactions which you created in the Scheduled Transaction window. Okay, > > here is a register page showing the transactions I just created. > > > > > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > > wrote: > > > >> During the actual importation process, GNC always shows a confirmation > >> dialogue box to take an action on all transaction it found. This is > where > >> you get a chance to select 'A' to add transaction, 'U+C' to update and > >> clear matched one, 'C' to clear existing matched one, or select nothing > and > >> do nothing with that transaction. This is automatic -- ie there is > nothing > >> needs to be done, either via setting or manually, to trigger it to come > up > >> during every import. Note that if a transaction is matched incorrectly, > you > >> can check either 'U+C' or 'C" and then double clicking on it will bring > up > >> another dialogue box with a list of transactions it believe matches or > are > >> similar from which you can select on that it should match with. > >> > >> -Original Message- > >> From: Tom Balazs > >> Sent: Friday, December 22, 2023 7:02 AM > >> To: Post to GnuCash User > >> Subject: [GNC] View Transactions After Importing from CSV > >> > >> I'm using Financisto+ on my Android phone. So I am often exporting > >> transactions from that, and importing them into GnuCash. Is there an > option > >> where I can view the transactions I just imported? So they appear on one > >> page, as if I did a Find in GnuCash. I think I came across that once, > but I > >> can't find it again. > >> > >> Tom > >> > >> > >> > ___ > 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.
Re: [GNC] View Transactions After Importing from CSV
>I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. I have already set up some Scheduled Transactions. So often when I open GnuCash it gives me a "Since Last Run" window. That gives me some information about the transactions it is going to create. At the bottom of that window is a checkbox which says, "Review Created Transactions". If I check that box, then GnuCash will take me to the main app and there is a tab named "Created Transactions". There I can see the transactions which were just created. That is what I want to see for Imported Transactions. On Tue, Apr 2, 2024 at 12:45 PM Tom Balazs wrote: > Yes, I see that. > But I mean that GnuCash should take me to a tab that looks like how it > displays the results of a Find Transaction. It opens a Register page and > shows only the matching transactions. > I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > wrote: > >> During the actual importation process, GNC always shows a confirmation >> dialogue box to take an action on all transaction it found. This is where >> you get a chance to select 'A' to add transaction, 'U+C' to update and >> clear matched one, 'C' to clear existing matched one, or select nothing and >> do nothing with that transaction. This is automatic -- ie there is nothing >> needs to be done, either via setting or manually, to trigger it to come up >> during every import. Note that if a transaction is matched incorrectly, you >> can check either 'U+C' or 'C" and then double clicking on it will bring up >> another dialogue box with a list of transactions it believe matches or are >> similar from which you can select on that it should match with. >> >> -Original Message- >> From: Tom Balazs >> Sent: Friday, December 22, 2023 7:02 AM >> To: Post to GnuCash User >> Subject: [GNC] View Transactions After Importing from CSV >> >> I'm using Financisto+ on my Android phone. So I am often exporting >> transactions from that, and importing them into GnuCash. Is there an option >> where I can view the transactions I just imported? So they appear on one >> page, as if I did a Find in GnuCash. I think I came across that once, but I >> can't find it again. >> >> Tom >> >> >> ___ 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.
Re: [GNC] View Transactions After Importing from CSV
It is set to: QIF import: Default Transaction Status: Not Cleared On Tue, Apr 2, 2024 at 6:59 PM David Carlson wrote: > Tom, > > Take a look at your setting for Edit > Preferences > Import > Default > transaction status. In earlier releases (Release 4.x) the explanation > suggested that only came into play for QIF imports but it may apply to CSV > imports as well in the new CSV importer, I am not sure. > > On Tue, Apr 2, 2024 at 11:46 AM Tom Balazs wrote: > >> Yes, I see that. >> But I mean that GnuCash should take me to a tab that looks like how it >> displays the results of a Find Transaction. It opens a Register page and >> shows only the matching transactions. >> I think it already does that for the Scheduled Transactions. It says >> something like, oh some time has passed, would you like me to create these >> transactions which you created in the Scheduled Transaction window. Okay, >> here is a register page showing the transactions I just created. >> >> >> >> On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel >> wrote: >> >> > During the actual importation process, GNC always shows a confirmation >> > dialogue box to take an action on all transaction it found. This is >> where >> > you get a chance to select 'A' to add transaction, 'U+C' to update and >> > clear matched one, 'C' to clear existing matched one, or select nothing >> and >> > do nothing with that transaction. This is automatic -- ie there is >> nothing >> > needs to be done, either via setting or manually, to trigger it to come >> up >> > during every import. Note that if a transaction is matched incorrectly, >> you >> > can check either 'U+C' or 'C" and then double clicking on it will bring >> up >> > another dialogue box with a list of transactions it believe matches or >> are >> > similar from which you can select on that it should match with. >> > >> > -Original Message----- >> > From: Tom Balazs >> > Sent: Friday, December 22, 2023 7:02 AM >> > To: Post to GnuCash User >> > Subject: [GNC] View Transactions After Importing from CSV >> > >> > I'm using Financisto+ on my Android phone. So I am often exporting >> > transactions from that, and importing them into GnuCash. Is there an >> option >> > where I can view the transactions I just imported? So they appear on one >> > page, as if I did a Find in GnuCash. I think I came across that once, >> but I >> > can't find it again. >> > >> > Tom >> > >> > >> > >> ___ >> 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. >> > > > -- > David Carlson > ___ 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.
Re: [GNC] View Transactions After Importing from CSV
Tom, Take a look at your setting for Edit > Preferences > Import > Default transaction status. In earlier releases (Release 4.x) the explanation suggested that only came into play for QIF imports but it may apply to CSV imports as well in the new CSV importer, I am not sure. On Tue, Apr 2, 2024 at 11:46 AM Tom Balazs wrote: > Yes, I see that. > But I mean that GnuCash should take me to a tab that looks like how it > displays the results of a Find Transaction. It opens a Register page and > shows only the matching transactions. > I think it already does that for the Scheduled Transactions. It says > something like, oh some time has passed, would you like me to create these > transactions which you created in the Scheduled Transaction window. Okay, > here is a register page showing the transactions I just created. > > > > On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel > wrote: > > > During the actual importation process, GNC always shows a confirmation > > dialogue box to take an action on all transaction it found. This is where > > you get a chance to select 'A' to add transaction, 'U+C' to update and > > clear matched one, 'C' to clear existing matched one, or select nothing > and > > do nothing with that transaction. This is automatic -- ie there is > nothing > > needs to be done, either via setting or manually, to trigger it to come > up > > during every import. Note that if a transaction is matched incorrectly, > you > > can check either 'U+C' or 'C" and then double clicking on it will bring > up > > another dialogue box with a list of transactions it believe matches or > are > > similar from which you can select on that it should match with. > > > > -Original Message- > > From: Tom Balazs > > Sent: Friday, December 22, 2023 7:02 AM > > To: Post to GnuCash User > > Subject: [GNC] View Transactions After Importing from CSV > > > > I'm using Financisto+ on my Android phone. So I am often exporting > > transactions from that, and importing them into GnuCash. Is there an > option > > where I can view the transactions I just imported? So they appear on one > > page, as if I did a Find in GnuCash. I think I came across that once, > but I > > can't find it again. > > > > Tom > > > > > > > ___ > 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. > -- David Carlson ___ 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.
Re: [GNC] Segmentation fault while importing invoice data
Thanks a lot! I've been able to fix the issue by debugging it. Turns out missing fields like: date, notes, and date_posted make validations crash when they are null and that's the segmentation fault origin. I'll fill the bug report later, but I hope this helps others while validations are fixed at the core. Greetings. P.S. I use Arch BTW On Sat, Mar 30, 2024 at 10:30 AM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > See the wiki about crashes and bug reports. Take a look there as well > about getting a Tracefile, then file a bug with the crash report and > tracefile as attachments. (The Tracefile may or may not contain relevant > info) > > You don't mention your OS by the way. > > Regards, > Adrien > > On 3/30/24 10:56 AM, Emir Herrera wrote: > > Anyway, if I click on "continue" to make the importation, after a couple > > seconds the system crashes and I get a "Segmentation fault" message on > the > > terminal, and no detailed information if runned with the "debug" flag... > > so... I'm stuck and I need help to import this data. > > ___ > 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. > -- Emir Herrera ___ 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.
Re: [GNC] View Transactions After Importing from CSV
Yes, I see that. But I mean that GnuCash should take me to a tab that looks like how it displays the results of a Find Transaction. It opens a Register page and shows only the matching transactions. I think it already does that for the Scheduled Transactions. It says something like, oh some time has passed, would you like me to create these transactions which you created in the Scheduled Transaction window. Okay, here is a register page showing the transactions I just created. On Fri, Dec 22, 2023 at 12:35 PM Kalpesh Patel wrote: > During the actual importation process, GNC always shows a confirmation > dialogue box to take an action on all transaction it found. This is where > you get a chance to select 'A' to add transaction, 'U+C' to update and > clear matched one, 'C' to clear existing matched one, or select nothing and > do nothing with that transaction. This is automatic -- ie there is nothing > needs to be done, either via setting or manually, to trigger it to come up > during every import. Note that if a transaction is matched incorrectly, you > can check either 'U+C' or 'C" and then double clicking on it will bring up > another dialogue box with a list of transactions it believe matches or are > similar from which you can select on that it should match with. > > -Original Message- > From: Tom Balazs > Sent: Friday, December 22, 2023 7:02 AM > To: Post to GnuCash User > Subject: [GNC] View Transactions After Importing from CSV > > I'm using Financisto+ on my Android phone. So I am often exporting > transactions from that, and importing them into GnuCash. Is there an option > where I can view the transactions I just imported? So they appear on one > page, as if I did a Find in GnuCash. I think I came across that once, but I > can't find it again. > > Tom > > > ___ 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.
Re: [GNC] Segmentation fault while importing invoice data
See the wiki about crashes and bug reports. Take a look there as well about getting a Tracefile, then file a bug with the crash report and tracefile as attachments. (The Tracefile may or may not contain relevant info) You don't mention your OS by the way. Regards, Adrien On 3/30/24 10:56 AM, Emir Herrera wrote: Anyway, if I click on "continue" to make the importation, after a couple seconds the system crashes and I get a "Segmentation fault" message on the terminal, and no detailed information if runned with the "debug" flag... so... I'm stuck and I need help to import this data. ___ 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.
[GNC] Segmentation fault while importing invoice data
Hello everyone. So, I'm trying to load some billing data from Google Cloud into GNUCash. I had made a script to get the data and parse it into a CSV. based on the documentation ( https://code.gnucash.org/docs/C/gnucash-guide/import-invoices.html) I have formatted it like this: GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running in Americas,Expenses:Cloud Services:Compute Engine,17.00167,0.048897736 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Ram running with free tier discount,Expenses:Cloud Services:Compute Engine,12.56861,-0.048899277 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running free tier discount,Expenses:Cloud Services:Compute Engine,13,-0.091205385 GCP-202308,2023-08-31,GOOGLE,ea,Network Internet Egress from Americas to Australia,Expenses:Cloud Services:Compute Engine,0.28376,2.960248097 GCP-202308,2023-08-31,GOOGLE,ea,Rounding Error,Expenses:Cloud Services:Invoice,4,0.000258 GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Zone Egress,Expenses:Cloud Services:Compute Engine,0.40337,0.148746808 GCP-202308,2023-08-31,GOOGLE,ea,Network Egress via Carrier Peering Network - Americas Based,Expenses:Cloud Services:Compute Engine,0.60274,0.497727046 GCP-202308,2023-08-31,GOOGLE,ea,E2 Instance Core running in Americas,Expenses:Cloud Services:Compute Engine,4.25056,0.364815371 GCP-202308,2023-08-31,GOOGLE,ea,Network Inter Region Egress from Americas to Jakarta,Expenses:Cloud Services:Compute Engine,0.21752,2.482530342 GCP-202309,2023-09-30,GOOGLE,ea,Rounding Error,Expenses:Cloud Services:Invoice,4,-0.00047925 and I use this REGEX to select the fields: ^(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*),(?[^,]*)$ So I have my CSV, open the import window, load the file, set the regex expression and the sample data is displayed. So far, so good. Anyway, if I click on "continue" to make the importation, after a couple seconds the system crashes and I get a "Segmentation fault" message on the terminal, and no detailed information if runned with the "debug" flag... so... I'm stuck and I need help to import this data. What could be done? Where is the problem? P.S. I upgraded to 5.5 last night, just to be up to date and the problem is there. Thanks in advance -- Emir Herrera ___ 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.
Re: [GNC] Importing Reports into LO Calc
You can certainly set that as a style in Calc. Regards, Adrien On 3/9/24 9:01 PM, Robert Heller wrote: I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good accounting practice", but the Calc is not doing. ___ 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.
Re: [GNC] Importing Reports into LO Calc
Hi Robert, If I copy and paste a Gnucash report directly into LibreOffice Calc (version 7.6.4.1 on Win10) everything is black as expected except for the negative numbers that are red which is what I also expected to happen ? Not sure what's happening with OP's calc. Cheers David H. On Sun, 10 Mar 2024 at 13:02, Robert Heller wrote: > I think the OP's issue is the fact that Calc does not preserve the red > coloring of the negative numbers. The red coloring of the negative > numbers is > something *GnuCash* is doing as a "good accounting practice", but the Calc > is > not doing. > > At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote: > > > > > 1. Export Report > > 2. Open Calc > > 3. Open the report file in Calc. Result is the report imported into > > cells based on the html table. > > > > or > > > > 1. Export Report > > 2. Open Calc > > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the > > exported report file. Answer the dialogs, result is same as above. > > > > or > > > > 1. Run Report in GnuCash > > 2. Select All > > 3. Copy > > 4. Open Calc > > 5. Paste, result is same as above > > > > In none of these cases is a web browser involved. (save for the Webkit > > rendering within GnuCash, if you want to be pedantic about browser > engines) > > > > I just tried all three, and in each case, there is no change in font or > > alignments. > > > > Perhaps your issues involve whatever intermediary (browser) you are > > involving that is unnecessary. > > > > Regards, > > Adrien > > > > On 3/9/24 10:41 AM, Abe Sternberg wrote: > > > I guess I am a bit dense - old age will do that to you. Let me try > and > > > be a bit more specific on my actions and the errors I get. Below is a > > > screenshot of a budget performance report in GnuCash. > > > > > > > > > > > > Next, I export it to the folder I want it in and open it in Calc. The > > > file opens in a browser tab, and I cut and paste the data into Calc. > > > Notice the different colors used. > > > > > > > > > > > > I wonder why the colors are there in the first place instead of the > > > expected black. The negative numbers being in red is good > accounting > > > practice. Look at what happens when I copy them into Calc. > Once again > > > I get a shift in colors and the negative numbers are not in red and > > > cannot be changed using cell format. Is the problem in GnuCash or > in Calc? > > > > ___ > > 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. > > > > > > -- > Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 > Deepwoods Software-- Custom Software Services > http://www.deepsoft.com/ -- Linux Administration Services > hel...@deepsoft.com -- Webhosting Services > > ___ > 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.
Re: [GNC] Importing Reports into LO Calc
I think the OP's issue is the fact that Calc does not preserve the red coloring of the negative numbers. The red coloring of the negative numbers is something *GnuCash* is doing as a "good accounting practice", but the Calc is not doing. At Sat, 9 Mar 2024 18:13:04 -0600 adrien.montele...@lusfiber.net wrote: > > 1. Export Report > 2. Open Calc > 3. Open the report file in Calc. Result is the report imported into > cells based on the html table. > > or > > 1. Export Report > 2. Open Calc > 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the > exported report file. Answer the dialogs, result is same as above. > > or > > 1. Run Report in GnuCash > 2. Select All > 3. Copy > 4. Open Calc > 5. Paste, result is same as above > > In none of these cases is a web browser involved. (save for the Webkit > rendering within GnuCash, if you want to be pedantic about browser engines) > > I just tried all three, and in each case, there is no change in font or > alignments. > > Perhaps your issues involve whatever intermediary (browser) you are > involving that is unnecessary. > > Regards, > Adrien > > On 3/9/24 10:41 AM, Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.ÃÂ Let me try and > > be a bit more specific on my actions and the errors I get. Below is a > > screenshot of a budget performance report in GnuCash. > > > > > > > > Next, I export it to the folder I want it in and open it in Calc. The > > file opens in a browser tab, and I cut and paste the data into Calc. > > Notice the different colors used. > > > > > > > > I wonder why the colors are there in the first place instead of the > > expected black.ÃÂ The negative numbers being in red is good accounting > > practice.ÃÂ Look at what happens when I copy them into Calc.ÃÂ Once > > again > > I get a shift in colors and the negative numbers are not in red and > > cannot be changed using cell format.ÃÂ Is the problem in GnuCash or in > > Calc? > > ___ > 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. > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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.
Re: [GNC] Importing Reports into LO Calc
1. Export Report 2. Open Calc 3. Open the report file in Calc. Result is the report imported into cells based on the html table. or 1. Export Report 2. Open Calc 3. Click 'Sheet' Menu, then 'Insert Sheet from file...' and select the exported report file. Answer the dialogs, result is same as above. or 1. Run Report in GnuCash 2. Select All 3. Copy 4. Open Calc 5. Paste, result is same as above In none of these cases is a web browser involved. (save for the Webkit rendering within GnuCash, if you want to be pedantic about browser engines) I just tried all three, and in each case, there is no change in font or alignments. Perhaps your issues involve whatever intermediary (browser) you are involving that is unnecessary. Regards, Adrien On 3/9/24 10:41 AM, Abe Sternberg wrote: I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? ___ 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.
Re: [GNC] Importing Reports into LO Calc
Thanks. It may be best if I start this thread again. I sincerely appreciate your taking the time to get me knowledgeable. Abe On 3/9/2024 15:35, David H wrote: Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David H. On Sun, 10 Mar 2024 at 02:42, Abe Sternberg wrote: I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? Thanks for your help. Abe On 3/8/2024 21:47, Adrien Monteleone wrote: > Abe, next time, please start a new thread by sending a new message to > the list rather than replying to someone else's. > > As for how to get reports into Calc, I usually copy/paste, but you can > also just 'open' the exported report, or you can 'insert sheet from > file' into an existing workbook. (again, choosing the exported report) > When exporting, it probably wouldn't hurt to use an .html filename > extension. > > I have in a few reports seen some alignment issues, but that was due > to special padding used by that particular report rather than a > cleaner HTML. I think I filed a bug on it. > > Otherwise, I've had no issues bringing them into Calc. > > Regards, > Adrien > > On 3/8/24 1:45 PM, Abe Sternberg wrote: >> After a long hiatus from GnuCash and preparing reports, I find that I >> am back in that business. The good news is that I am good to go on >> getting my reports structured the way I want. The bad news is that >> now I can't figure out how to import the HTML report into Calc. I >> have tried everything I can think of, including cutting and pasting. >> >> The error is that some fields are imported in a different colored >> font, this seems to be limited to numeric fields. I have another >> situation where totals in a table do not cross-foot - they are not >> equal when adding row totals across and column totals going down. >> >> I had this correct, but have forgotten what to do. > > ___ > 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. ___ 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.
Re: [GNC] Importing Reports into LO Calc
Abe, The default colors which come up in Calc are going to depend upon its preference settings and any formatting already set in Calc before importing. GnuCash has no control over that. Cal's cell "currency" setting has the option of negative numbers appearing in red. If you format all cells containing numerical currency data to "Currency" this will work. ALl that is imported into Calc is the data , not any formatting The benefit of importing to Calc is that youthen have complete control over how it is formatted within the constraints of Calc's formatting capabilities but that comes at the cost of having to manually set that formatting. AFAIK it should be possible to create a formatted template in Calc so that you can import the data into the template and have it appear as you desire. On Sat, 2024-03-09 at 11:41 -0500, Abe Sternberg wrote: > I guess I am a bit dense - old age will do that to you. Let me try > and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc. > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once > again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in > Calc? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message > > to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you > > can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported > > report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was > > due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > > > After a long hiatus from GnuCash and preparing reports, I find > > > that I > > > am back in that business. The good news is that I am good to go > > > on > > > getting my reports structured the way I want. The bad news is > > > that > > > now I can't figure out how to import the HTML report into Calc. > > > I > > > have tried everything I can think of, including cutting and > > > pasting. > > > > > > The error is that some fields are imported in a different colored > > > font, this seems to be limited to numeric fields. I have another > > > situation where totals in a table do not cross-foot - they are > > > not > > > equal when adding row totals across and column totals going down. > > > > > > I had this correct, but have forgotten what to do. > > > > ___ > > 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. ___ 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.
Re: [GNC] Importing Reports into LO Calc
Abe, You can't include/paste pictures inline on the Gnucash mailing list so they didn't show up :-( You have to either save each pic as a file and attach them to your email or I've found that you can get away with pasting 1 pic as the very last thing in your email and it makes it. Cheers David H. On Sun, 10 Mar 2024 at 02:42, Abe Sternberg wrote: > I guess I am a bit dense - old age will do that to you. Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc. > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in Calc? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > >> After a long hiatus from GnuCash and preparing reports, I find that I > >> am back in that business. The good news is that I am good to go on > >> getting my reports structured the way I want. The bad news is that > >> now I can't figure out how to import the HTML report into Calc. I > >> have tried everything I can think of, including cutting and pasting. > >> > >> The error is that some fields are imported in a different colored > >> font, this seems to be limited to numeric fields. I have another > >> situation where totals in a table do not cross-foot - they are not > >> equal when adding row totals across and column totals going down. > >> > >> I had this correct, but have forgotten what to do. > > > > ___ > > 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. > ___ 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.
Re: [GNC] Importing Reports into LO Calc
At Sat, 9 Mar 2024 11:41:31 -0500 Abe Sternberg wrote: > > I guess I am a bit dense - old age will do that to you.ÃÂ Let me try and > be a bit more specific on my actions and the errors I get. Below is a > screenshot of a budget performance report in GnuCash. > > > > Next, I export it to the folder I want it in and open it in Calc. The > file opens in a browser tab, and I cut and paste the data into Calc.ÃÂ > Notice the different colors used. > > > > I wonder why the colors are there in the first place instead of the > expected black. The negative numbers being in red is good accounting > practice. Look at what happens when I copy them into Calc. Once again > I get a shift in colors and the negative numbers are not in red and > cannot be changed using cell format. Is the problem in GnuCash or in Calc? It is the spreadsheet program (calc). Spreadsheet programs are not accounting programs and don't know anything about "good accounting practice". GnuCash is an accounting program and does know all about "good accounting practice". *I* don't know how to fix this. What are you trying to do with the spreadsheet program? > > > > Thanks for your help. > > Abe > > > > On 3/8/2024 21:47, Adrien Monteleone wrote: > > Abe, next time, please start a new thread by sending a new message to > > the list rather than replying to someone else's. > > > > As for how to get reports into Calc, I usually copy/paste, but you can > > also just 'open' the exported report, or you can 'insert sheet from > > file' into an existing workbook. (again, choosing the exported report) > > When exporting, it probably wouldn't hurt to use an .html filename > > extension. > > > > I have in a few reports seen some alignment issues, but that was due > > to special padding used by that particular report rather than a > > cleaner HTML. I think I filed a bug on it. > > > > Otherwise, I've had no issues bringing them into Calc. > > > > Regards, > > Adrien > > > > On 3/8/24 1:45 PM, Abe Sternberg wrote: > >> After a long hiatus from GnuCash and preparing reports, I find that I > >> am back in that business.ÃÂ The good news is that I am good to go on > >> getting my reports structured the way I want. The bad news is that > >> now I can't figure out how to import the HTML report into Calc.ÃÂ I > >> have tried everything I can think of, including cutting and pasting. > >> > >> The error is that some fields are imported in a different colored > >> font, this seems to be limited to numeric fields.ÃÂ I have another > >> situation where totals in a table do not cross-foot - they are not > >> equal when adding row totals across and column totals going down. > >> > >> I had this correct, but have forgotten what to do. > > > > ___ > > 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. > > -- Robert Heller -- Cell: 413-658-7953 GV: 978-633-5364 Deepwoods Software-- Custom Software Services http://www.deepsoft.com/ -- Linux Administration Services hel...@deepsoft.com -- Webhosting Services ___ 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.
Re: [GNC] Importing Reports into LO Calc
I guess I am a bit dense - old age will do that to you. Let me try and be a bit more specific on my actions and the errors I get. Below is a screenshot of a budget performance report in GnuCash. Next, I export it to the folder I want it in and open it in Calc. The file opens in a browser tab, and I cut and paste the data into Calc. Notice the different colors used. I wonder why the colors are there in the first place instead of the expected black. The negative numbers being in red is good accounting practice. Look at what happens when I copy them into Calc. Once again I get a shift in colors and the negative numbers are not in red and cannot be changed using cell format. Is the problem in GnuCash or in Calc? Thanks for your help. Abe On 3/8/2024 21:47, Adrien Monteleone wrote: Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook. (again, choosing the exported report) When exporting, it probably wouldn't hurt to use an .html filename extension. I have in a few reports seen some alignment issues, but that was due to special padding used by that particular report rather than a cleaner HTML. I think I filed a bug on it. Otherwise, I've had no issues bringing them into Calc. Regards, Adrien On 3/8/24 1:45 PM, Abe Sternberg wrote: After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. ___ 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.
Re: [GNC] Importing Reports into LO Calc
Abe, next time, please start a new thread by sending a new message to the list rather than replying to someone else's. As for how to get reports into Calc, I usually copy/paste, but you can also just 'open' the exported report, or you can 'insert sheet from file' into an existing workbook. (again, choosing the exported report) When exporting, it probably wouldn't hurt to use an .html filename extension. I have in a few reports seen some alignment issues, but that was due to special padding used by that particular report rather than a cleaner HTML. I think I filed a bug on it. Otherwise, I've had no issues bringing them into Calc. Regards, Adrien On 3/8/24 1:45 PM, Abe Sternberg wrote: After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. ___ 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.
[GNC] Importing Reports into LO Calc
After a long hiatus from GnuCash and preparing reports, I find that I am back in that business. The good news is that I am good to go on getting my reports structured the way I want. The bad news is that now I can't figure out how to import the HTML report into Calc. I have tried everything I can think of, including cutting and pasting. The error is that some fields are imported in a different colored font, this seems to be limited to numeric fields. I have another situation where totals in a table do not cross-foot - they are not equal when adding row totals across and column totals going down. I had this correct, but have forgotten what to do. Thanks for your help. Abe ___ 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.
Re: [GNC] Trouble importing bills via csv
Yes, if your field contains the separator character you should double-quote it, but *only* in that case. Id's, dates, et cetera will not, so no reason to quote them. The OP had quotes on most if not all fields and none of them were necessary. Regards, Adrien On 2/26/24 8:23 AM, Kalpesh Patel wrote: Some financial orgs include commas as thousands, hundreds thousands, etc., separator in CSV to beautify the display. They treat it as a free format string value... A single opening and a single closing double quotes, I believe, are ignored by the importer ... correct me if I am wrong. ___ 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.
Re: [GNC] Trouble importing bills via csv
Some financial orgs include commas as thousands, hundreds thousands, etc., separator in CSV to beautify the display. They treat it as a free format string value... A single opening and a single closing double quotes, I believe, are ignored by the importer ... correct me if I am wrong. -Original Message- From: David H Sent: Saturday, February 24, 2024 7:02 PM To: Alan Johnson Cc: Adrien Monteleone ; gnucash-u...@lists.gnucash.org Subject: Re: [GNC] Trouble importing bills via csv Alan, Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. Hope this helps, Cheers David H. Note on double quotes If you use the field separator character within a field, the field value should be enclosed in double quotes. Only for the fields description (desc) and notes, can you also include a double quote within a quoted field value, by doubling the double quote. E.g. "This field value uses the separator, and a ""quoted"" word", would be imported as This field value uses the separator, and a "quoted" word. Example content for two bills; one of 2 entries, and one of 3 entries. The first is saved and posted, the second only saved. Using comma field separator, decimal point and dd/mm/ date format. 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate Guide;pc;Expenses:Books;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & drinks;pc;Expenses:Dining;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG course;pc;Expenses:Education;1;10.01;;; On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it > > and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoi > ces.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial > >> run and I'm getting the below errors. Vendor "05" does not > >> exist, however that is the vendor ID for Amazon in my file. It > >> says account "Liabilities:Accounts Payable" does not exist (but it > >> does). It says the Expense account also does not exist (but it > >> does) and then it proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on > >> the Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac > >> tion > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t > >> axab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile > >> Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil > >> itie > >> s:Accounts Payable";;"N" > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnucash.org > > To updat
Re: [GNC] Trouble importing bills via csv
So basically you got rid of the quotes around everything as I suggested :-) Cheers David H. On Sun, 25 Feb 2024 at 11:17, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > So, I was working on it and here was that worked as I was playing with > it. I'm using LibreOffice to edit the CSVs. > > Edit the filter on the "save as" dialog, then I set the field delimiter > and deleted the string delimiter and unchecked 'quote all text cells'. > > Then I was able to successfully able to import the bills. > > Alan > > On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote: > > I did read the manual, hence my usage of the quotes. I had done it > > before without. > > > > I'll make a video and send it out shortly. > > > > Alan > > > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > > Alan, > > > > > > Your file imports fine here after I add the vendor, create the > > > Accounts Payable liability, remove the header line and remove the > > > double quotes that you have plastered around every field for some > > > reason which probably causes the other errors. > > > > > > It might pay to read up on Gnucash Bills Importing > > > at > > > > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > and the examples therein :- > > > > > > You'll note a complete absence of double quotes in the following > > > example and no header line. > > > > > > Hope this helps, > > > > > > Cheers David H. > > > > > > > > > Note on double quotes > > > If you use the field separator character within a field, the field > > > value should be enclosed in double quotes. Only for the fields > > > description (desc) and notes, can you also include a double quote > > > within a quoted field value, by doubling the double quote. > > > E.g. "This > > > field value uses the separator, and a ""quoted"" word", would be > > > imported as This field value uses the separator, and a "quoted" > > > word. > > > > > > Example content for two bills; one of 2 entries, and one of 3 > > > entries. The first is saved and posted, the second only saved. > > > Using > > > comma field separator, decimal point and dd/mm/ date format. > > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride > > > and > > > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;L > > > ia > > > bilities:Accounts Payable;;X > > > 1204;15/12/2018;2001;PO 210220;Special > > > delivery;16/12/2018;Electronic > > > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019; > > > Li > > > abilities:Accounts Payable;;X > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > > > Guide;pc;Expenses:Books;1;10.01;;; > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > > > drinks;pc;Expenses:Dining;1;10.01;;; > > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > > > course;pc;Expenses:Education;1;10.01;;; > > > > > > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > > > wrote: > > > > I tried that with the same result. GNC says it ignored that line, > > > > and that's fine. > > > > > > > > I'm concerned with the error messages indicating that the vendor > > > > and accounts don't exist. Have I input that data incorrectly? > > > > > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > > > : > > > > > > > > > Although you should be able to have header row(s), perhaps > > > > > remove > > > > it and try again. > > > > > > > > > > The Documentation for this is worded oddly, but the samples > > > > provided don't show header info at all. > > > > > > > > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > > > > > Regards, > > > > > Adrien > > > > > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > > > > > Hello, > > > > > > I'm having some issues importing a bill via CSV. I set up a > > > > trial run > > > > > > and I'm getting the below errors. Vendor "05" does not > &
Re: [GNC] Trouble importing bills via csv
So, I was working on it and here was that worked as I was playing with it. I'm using LibreOffice to edit the CSVs. Edit the filter on the "save as" dialog, then I set the field delimiter and deleted the string delimiter and unchecked 'quote all text cells'. Then I was able to successfully able to import the bills. Alan On Sat, 2024-02-24 at 19:10 -0500, Alan Johnson via gnucash-user wrote: > I did read the manual, hence my usage of the quotes. I had done it > before without. > > I'll make a video and send it out shortly. > > Alan > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > Alan, > > > > Your file imports fine here after I add the vendor, create the > > Accounts Payable liability, remove the header line and remove the > > double quotes that you have plastered around every field for some > > reason which probably causes the other errors. > > > > It might pay to read up on Gnucash Bills Importing > > at > > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > and the examples therein :- > > > > You'll note a complete absence of double quotes in the following > > example and no header line. > > > > Hope this helps, > > > > Cheers David H. > > > > > > Note on double quotes > > If you use the field separator character within a field, the field > > value should be enclosed in double quotes. Only for the fields > > description (desc) and notes, can you also include a double quote > > within a quoted field value, by doubling the double quote. > > E.g. "This > > field value uses the separator, and a ""quoted"" word", would be > > imported as This field value uses the separator, and a "quoted" > > word. > > > > Example content for two bills; one of 2 entries, and one of 3 > > entries. The first is saved and posted, the second only saved. > > Using > > comma field separator, decimal point and dd/mm/ date format. > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride > > and > > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;L > > ia > > bilities:Accounts Payable;;X > > 1204;15/12/2018;2001;PO 210220;Special > > delivery;16/12/2018;Electronic > > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019; > > Li > > abilities:Accounts Payable;;X > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > > Guide;pc;Expenses:Books;1;10.01;;; > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > > drinks;pc;Expenses:Dining;1;10.01;;; > > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > > course;pc;Expenses:Education;1;10.01;;; > > > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > > wrote: > > > I tried that with the same result. GNC says it ignored that line, > > > and that's fine. > > > > > > I'm concerned with the error messages indicating that the vendor > > > and accounts don't exist. Have I input that data incorrectly? > > > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > > : > > > > > > > Although you should be able to have header row(s), perhaps > > > > remove > > > it and try again. > > > > > > > > The Documentation for this is worded oddly, but the samples > > > provided don't show header info at all. > > > > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > > > Regards, > > > > Adrien > > > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > > > > Hello, > > > > > I'm having some issues importing a bill via CSV. I set up a > > > trial run > > > > > and I'm getting the below errors. Vendor "05" does not > > > exist, > > > > > however that is the vendor ID for Amazon in my file. It says > > > account > > > > > "Liabilities:Accounts Payable" does not exist (but it does). > > > > > It > > > says > > > > > the Expense account also does not exist (but it does) and > > > > > then > > > it > > > > > proceeds to ignore the line. > > > > > How do I correct this for proper import? I've had the same > > > > > issue > > > on the > > > > > Customer invoice import side as well. > > > >
Re: [GNC] Trouble importing bills via csv
Aha I read that as you'd tried it with and without the header line nothing was said about the quotes :-) On Sun, 25 Feb 2024 at 10:11, Alan Johnson wrote: > I did read the manual, hence my usage of the quotes. I had done it before > without. > > I'll make a video and send it out shortly. > > Alan > > On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > > Alan, > > Your file imports fine here after I add the vendor, create the Accounts > Payable liability, remove the header line and remove the double quotes that > you have plastered around every field for some reason which probably causes > the other errors. > > It might pay to read up on Gnucash Bills Importing at > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and > the examples therein :- > > You'll note a complete absence of double quotes in the following example > and no header line. > > Hope this helps, > > Cheers David H. > > > Note on double quotes > > If you use the field separator character within a field, the field value > should be enclosed in double quotes. Only for the fields description (desc) > and notes, can you also include a double quote within a quoted field value, > by doubling the double quote. E.g. "This field value uses the separator, > and a ""quoted"" word", would be imported as This field value uses the > separator, and a "quoted" word. > > Example content for two bills; one of 2 entries, and one of 3 entries. The > first is saved and posted, the second only saved. Using comma field > separator, decimal point and dd/mm/ date format. > > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts > Payable;;X > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts > Payable;;X > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > Guide;pc;Expenses:Books;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > drinks;pc;Expenses:Dining;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > course;pc;Expenses:Education;1;10.01;;; > > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < > gnucash-user@gnucash.org> wrote: > > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial run > >> and I'm getting the below errors. Vendor "05" does not exist, > >> however that is the vendor ID for Amazon in my file. It says account > >> "Liabilities:Accounts Payable" does not exist (but it does). It says > >> the Expense account also does not exist (but it does) and then it > >> proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on the > >> Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie > >> s:Accounts Payable";;"N" > > > > ___ > > gnucash-user mailing list > > gnucash-user@gnu
Re: [GNC] Trouble importing bills via csv
I did read the manual, hence my usage of the quotes. I had done it before without. I'll make a video and send it out shortly. Alan On Sun, 2024-02-25 at 10:02 +1000, David H wrote: > Alan, > > Your file imports fine here after I add the vendor, create the > Accounts Payable liability, remove the header line and remove the > double quotes that you have plastered around every field for some > reason which probably causes the other errors. > > It might pay to read up on Gnucash Bills Importing > at > https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > and the examples therein :- > > You'll note a complete absence of double quotes in the following > example and no header line. > > Hope this helps, > > Cheers David H. > > > Note on double quotes > If you use the field separator character within a field, the field > value should be enclosed in double quotes. Only for the fields > description (desc) and notes, can you also include a double quote > within a quoted field value, by doubling the double quote. E.g. "This > field value uses the separator, and a ""quoted"" word", would be > imported as This field value uses the separator, and a "quoted" word. > > Example content for two bills; one of 2 entries, and one of 3 > entries. The first is saved and posted, the second only saved. Using > comma field separator, decimal point and dd/mm/ date format. > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and > Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Lia > bilities:Accounts Payable;;X > 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic > principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Li > abilities:Accounts Payable;;X > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate > Guide;pc;Expenses:Books;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & > drinks;pc;Expenses:Dining;1;10.01;;; > 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG > course;pc;Expenses:Education;1;10.01;;; > > > On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user > wrote: > > I tried that with the same result. GNC says it ignored that line, > > and that's fine. > > > > I'm concerned with the error messages indicating that the vendor > > and accounts don't exist. Have I input that data incorrectly? > > > > Feb 24, 2024 13:00:20 Adrien Monteleone > > : > > > > > Although you should be able to have header row(s), perhaps remove > > it and try again. > > > > > > The Documentation for this is worded oddly, but the samples > > provided don't show header info at all. > > > > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > > > Regards, > > > Adrien > > > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > > >> Hello, > > >> I'm having some issues importing a bill via CSV. I set up a > > trial run > > >> and I'm getting the below errors. Vendor "05" does not > > exist, > > >> however that is the vendor ID for Amazon in my file. It says > > account > > >> "Liabilities:Accounts Payable" does not exist (but it does). It > > says > > >> the Expense account also does not exist (but it does) and then > > it > > >> proceeds to ignore the line. > > >> How do I correct this for proper import? I've had the same issue > > on the > > >> Customer invoice import side as well. > > >> This is on Ubuntu with Flatpak 5.5 > > >> Here is the raw CSV import: > > >> > > "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"ac > > tion > > >> > > ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"t > > axab > > >> > > le";"taxincluded";"tax_table";"date_posted";"due_date";"account_pos > > ted" > > >> ;"memo_posted";"accu_splits" > > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile > > Fuse > > >> Kit";;"Expenses:Auto:2016 Big > > >> > > Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabil > > itie > > >> s:Accounts Payable";;"N
Re: [GNC] Trouble importing bills via csv
There is the caveat, noted in that link, that if you use the same delimiter for your account tree as the CSV, then (and only then) do you need to enclose account references in double-quotes. (this is generally a CSV thing, not something specific to GnuCash) Regards, Adrien On 2/24/24 6:02 PM, David H wrote: Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. ___ 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.
Re: [GNC] Trouble importing bills via csv
Alan, Your file imports fine here after I add the vendor, create the Accounts Payable liability, remove the header line and remove the double quotes that you have plastered around every field for some reason which probably causes the other errors. It might pay to read up on Gnucash Bills Importing at https://gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html and the examples therein :- You'll note a complete absence of double quotes in the following example and no header line. Hope this helps, Cheers David H. Note on double quotes If you use the field separator character within a field, the field value should be enclosed in double quotes. Only for the fields description (desc) and notes, can you also include a double quote within a quoted field value, by doubling the double quote. E.g. "This field value uses the separator, and a ""quoted"" word", would be imported as This field value uses the separator, and a "quoted" word. Example content for two bills; one of 2 entries, and one of 3 entries. The first is saved and posted, the second only saved. Using comma field separator, decimal point and dd/mm/ date format. 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Pride and Prejudice;pc;Expenses:Books;1;30.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1204;15/12/2018;2001;PO 210220;Special delivery;16/12/2018;Electronic principles;pc;Expenses:Books;1;50.00X;;A1;17/12/2018;17/1/2019;Liabilities:Accounts Payable;;X 1205;15/12/2018;2044;PO 21099;;16/12/2018;Ultimate Guide;pc;Expenses:Books;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;Dinner & drinks;pc;Expenses:Dining;1;10.01;;; 1205;15/12/2018;2044;PO 21099;;16/12/2018;UG course;pc;Expenses:Education;1;10.01;;; On Sun, 25 Feb 2024 at 04:09, Alan Johnson via gnucash-user < gnucash-user@gnucash.org> wrote: > I tried that with the same result. GNC says it ignored that line, and > that's fine. > > I'm concerned with the error messages indicating that the vendor and > accounts don't exist. Have I input that data incorrectly? > > Feb 24, 2024 13:00:20 Adrien Monteleone : > > > Although you should be able to have header row(s), perhaps remove it and > try again. > > > > The Documentation for this is worded oddly, but the samples provided > don't show header info at all. > > > > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > > > Regards, > > Adrien > > > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: > >> Hello, > >> I'm having some issues importing a bill via CSV. I set up a trial run > >> and I'm getting the below errors. Vendor "05" does not exist, > >> however that is the vendor ID for Amazon in my file. It says account > >> "Liabilities:Accounts Payable" does not exist (but it does). It says > >> the Expense account also does not exist (but it does) and then it > >> proceeds to ignore the line. > >> How do I correct this for proper import? I've had the same issue on the > >> Customer invoice import side as well. > >> This is on Ubuntu with Flatpak 5.5 > >> Here is the raw CSV import: > >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action > >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab > >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" > >> ;"memo_posted";"accu_splits" > >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse > >> Kit";;"Expenses:Auto:2016 Big > >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie > >> s:Accounts Payable";;"N" > > > > ___ > > 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. > ___ 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.
Re: [GNC] Trouble importing bills via csv
I tried that with the same result. GNC says it ignored that line, and that's fine. I'm concerned with the error messages indicating that the vendor and accounts don't exist. Have I input that data incorrectly? Feb 24, 2024 13:00:20 Adrien Monteleone : > Although you should be able to have header row(s), perhaps remove it and try > again. > > The Documentation for this is worded oddly, but the samples provided don't > show header info at all. > > https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html > > Regards, > Adrien > > On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: >> Hello, >> I'm having some issues importing a bill via CSV. I set up a trial run >> and I'm getting the below errors. Vendor "05" does not exist, >> however that is the vendor ID for Amazon in my file. It says account >> "Liabilities:Accounts Payable" does not exist (but it does). It says >> the Expense account also does not exist (but it does) and then it >> proceeds to ignore the line. >> How do I correct this for proper import? I've had the same issue on the >> Customer invoice import side as well. >> This is on Ubuntu with Flatpak 5.5 >> Here is the raw CSV import: >> "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action >> ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab >> le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" >> ;"memo_posted";"accu_splits" >> "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse >> Kit";;"Expenses:Auto:2016 Big >> Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie >> s:Accounts Payable";;"N" > > ___ > 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. smime.p7s Description: S/MIME cryptographic signature ___ 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.
Re: [GNC] Trouble importing bills via csv
Although you should be able to have header row(s), perhaps remove it and try again. The Documentation for this is worded oddly, but the samples provided don't show header info at all. https://www.gnucash.org/docs/v5/C/gnucash-guide/busnss-imp-bills-invoices.html Regards, Adrien On 2/24/24 10:15 AM, Alan Johnson via gnucash-user wrote: Hello, I'm having some issues importing a bill via CSV. I set up a trial run and I'm getting the below errors. Vendor "05" does not exist, however that is the vendor ID for Amazon in my file. It says account "Liabilities:Accounts Payable" does not exist (but it does). It says the Expense account also does not exist (but it does) and then it proceeds to ignore the line. How do I correct this for proper import? I've had the same issue on the Customer invoice import side as well. This is on Ubuntu with Flatpak 5.5 Here is the raw CSV import: "id";"date_opened";"owner_id";"billingid";"notes";"date";"desc";"action ";"account";"quantity";"price";"disc_type";"disc_how";"discount";"taxab le";"taxincluded";"tax_table";"date_posted";"due_date";"account_posted" ;"memo_posted";"accu_splits" "111-7425790-5888250";05/11/23;"05"05/11/23;"Low Profile Fuse Kit";;"Expenses:Auto:2016 Big Country:BigCountryMaintenance";1;12;;;05/11/23;05/11/23;"Liabilitie s:Accounts Payable";;"N" ___ 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.
[GNC] Issues importing transactions (not matching)
Hello, I'm attempting to import transactions from a credit card QFX file / Quicken format. I have the pre-entered transaction as 'LEGO' in the amount of 45.14. The imported transaction is "LEGO Enfeild CT" in the amount of 45.14. Gnucash thinks these are not the same - and there are a number of other transactions that are the same way. How can I manually match these? or adjust it so they match? Thanks, Alan smime.p7s Description: S/MIME cryptographic signature ___ 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.
Re: [GNC] Importing from one gnucash file to another
It's part of CSV import. It has been there for a long time but didn't work very well until Geert rewrote the CSV importer for GnuCash 4. Use File>Export>Transactions to CSV to create a CSV file then File>Import>Import Transactions from CSV and click the Multi-Split box under File Format on the Import Preview page. Regards, John Ralls > On Jan 16, 2024, at 10:38 AM, Adrien Monteleone > wrote: > > I've never used it myself, but I recall a discussion when the feature was > added, I think for 4.x but it could have been earlier. > > Regards, > Adrien > > On 1/16/24 5:16 AM, David H wrote: >> James, >> I may be mis-remembering but I seem to recall when importing txns some time >> ago there was a checkbox or option to specify the file to be imported was >> in Gnucash format ? Do you see this? Have you selected it ? > > ___ > 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.
Re: [GNC] Importing from one gnucash file to another
I've never used it myself, but I recall a discussion when the feature was added, I think for 4.x but it could have been earlier. Regards, Adrien On 1/16/24 5:16 AM, David H wrote: James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or option to specify the file to be imported was in Gnucash format ? Do you see this? Have you selected it ? ___ 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.
Re: [GNC] Importing from one gnucash file to another
James, I may be mis-remembering but I seem to recall when importing txns some time ago there was a checkbox or option to specify the file to be imported was in Gnucash format ? Do you see this? Have you selected it ? Regards David H. On Tue, 16 Jan 2024 at 06:33, James Wilde wrote: > I am rationalising my accounting in Gnucash and have previously had one > instance of Gnucash for each year. I now would like to load an eyara > into the current year. I have exported the earlier year as a csv file > (I have used semi-colons instead of commas) but when I go to the current > year to import it does not seem to be a possibility. It appears as > though I must in some way edit the exported file in order to import it. > > Both the earlier year and the current year have the same account list. > I am using Build ID: 4.12+(2022-09-24). > > I'd appreciate a hint on what I might be missing. > > Regards > > James Wilde > ___ > 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.
Re: [GNC] Importing from one gnucash file to another
James: On 2024-01-15 03:59, James Wilde wrote: I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year. I now would like to load an [earlier year's data] into the current year. I have exported the earlier year as a csv file (I have used semi-colons instead of commas) but when I go to the current year to import it does not seem to be a possibility. It appears as though I must in some way edit the exported file in order to import it Interesting. I imagine that some more specifics about what you are observing might help others on the list get you through the next step. You say, "when I go to the current year to import it does not seem to be a possibility." You have run GnuCash and opened the book file for the current year, the file which will receive the earlier file's data, correct? You are selecting the menu item, File -- Import -- Import Transactions from CSV, correct? Does the Transaction Import Assistant appear? Are you able to get past the first page of the Assistant? Does the "Select File for Import" page appear? In the "Select File for Import" page, are you able to locate the CSV file which has the earlier data? Is the name of that CSV file displayed as regular (black) text, or is it greyed-out text? If you click on the name of the CSV, and click the "Next" button? Does the "Import Preview" page appear? Do you encounter any problems on the "Import Preview" page? Are you able to click "Next"? Does the "Match Import and GnuCash accounts" page appear? (and so on…) I am using GnuCash in English. If you are using GnuCash in Swedish, and my English-language names do not translate easily to yours, I apologise for the confusion. Both the earlier year and the current year have the same account list. I am using Build ID: 4.12+(2022-09-24). Thank you for supplying those important facts. What computer OS are you using? Windows 11? Best regards, —Jim DeLaHunt ___ 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.
[GNC] Importing from one gnucash file to another
I am rationalising my accounting in Gnucash and have previously had one instance of Gnucash for each year. I now would like to load an eyara into the current year. I have exported the earlier year as a csv file (I have used semi-colons instead of commas) but when I go to the current year to import it does not seem to be a possibility. It appears as though I must in some way edit the exported file in order to import it. Both the earlier year and the current year have the same account list. I am using Build ID: 4.12+(2022-09-24). I'd appreciate a hint on what I might be missing. Regards James Wilde ___ 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.
Re: [GNC] View Transactions After Importing from CSV
During the actual importation process, GNC always shows a confirmation dialogue box to take an action on all transaction it found. This is where you get a chance to select 'A' to add transaction, 'U+C' to update and clear matched one, 'C' to clear existing matched one, or select nothing and do nothing with that transaction. This is automatic -- ie there is nothing needs to be done, either via setting or manually, to trigger it to come up during every import. Note that if a transaction is matched incorrectly, you can check either 'U+C' or 'C" and then double clicking on it will bring up another dialogue box with a list of transactions it believe matches or are similar from which you can select on that it should match with. -Original Message- From: Tom Balazs Sent: Friday, December 22, 2023 7:02 AM To: Post to GnuCash User Subject: [GNC] View Transactions After Importing from CSV I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't find it again. Tom ___ 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.
[GNC] View Transactions After Importing from CSV
I'm using Financisto+ on my Android phone. So I am often exporting transactions from that, and importing them into GnuCash. Is there an option where I can view the transactions I just imported? So they appear on one page, as if I did a Find in GnuCash. I think I came across that once, but I can't find it again. Tom ___ 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.
Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
Thank you On Sat, Oct 7, 2023 at 3:35 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > If I'm not mistaken, you should only have to do this once per account. > Now, combining this with your other question, there is reason #2 to > break this into smaller import chunks. You don't want to have to > manually assign those in a large quantity in a single pass. > > Regards, > Adrien > > On 10/7/23 12:01 AM, Gio Bacareza wrote: > > I'm experiencing difficulties when importing a CSV file into GnuCash, > > particularly when the file contains both "Account" and "Target Account" > > columns. Despite meticulously encoding the account names in the CSV to > > match the exact account names as they appear in GnuCash (e.g., > > “Asset:Cash”), the software does not seem to automatically recognize and > > match these names during the import process. > > > > Instead, GnuCash prompts me to manually match the account names through > its > > import wizard every time, which is unexpected and inconvenient. For > > instance, even if the CSV file contains the precise name “Asset:Cash”, > > GnuCash still requires manual intervention to match the names correctly. > > > > Is there a specific reason for this issue, or am I possibly making an > error > > during the import process? I would appreciate any insight or advice on > how > > to streamline this process and ensure GnuCash recognizes account names > from > > the CSV file automatically. > > > > ___ > 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. > -- cheers, Gio ___ 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.
Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
Thank you, Adrien. I get it now. On Sat, Oct 7, 2023 at 3:33 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > This is one of the reasons why it is not recommended to import a large > file, especially one containing transactions from more than a single > account on one side of each transaction. > > Read over the Help Manual & the Tutorial & Concepts Guide concerning > imports. > > The usual recommended procedure is to break the import into smaller > chunks depending on how many transactions you have in a month/year, etc. > > So for example, you might import January 2023 of your checking account. > (from whatever other app, or from a bank download) Then reconcile, and > repeat for February, then March, etc. > > As you go, you are training the matcher, so the imports speed up, and > duplicates are detected. > > It is up to you, how big the import chunks are, but bigger is not > necessarily faster, and maybe rarely is. > > Regards, > Adrien > > On 10/6/23 11:57 PM, Gio Bacareza wrote: > > I've been attempting to import a large, consolidated CSV file containing > > multiple accounts into GnuCash. Previously, I used to import transaction > > logs from various accounts individually, which I thought was a cumbersome > > process. To simplify this, I’ve created scripts to compile all > transactions > > into one comprehensive CSV file for what I thought would be a more > > straightforward import process. > > > > However, I've encountered an issue where GnuCash duplicates certain > > transactions during the import. Specifically, this happens when a > > transaction represents a withdrawal from one account and a deposit into > > another, which are naturally recorded as two separate entries in the CSV. > > For instance, when money is withdrawn from a bank account and deposited > > into a cash account, the consolidated CSV file includes one row showing > the > > bank account debit and another showing the cash account credit. > > > > I assumed that GnuCash’s import algorithm would recognize and eliminate > > these duplicate transactions during the import process as it typically > does > > with other duplicates. Unfortunately, my tests indicate that it imports > > both transactions, resulting in duplicated entries. > > > > Is this a mistake on my part, or is this behavior expected from GnuCash > > when importing a large CSV with multiple accounts? Any insights or > > solutions to prevent these duplicates would be greatly appreciated. > > > > ___ > 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. > -- cheers, Gio ___ 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.
Re: [GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
If I'm not mistaken, you should only have to do this once per account. Now, combining this with your other question, there is reason #2 to break this into smaller import chunks. You don't want to have to manually assign those in a large quantity in a single pass. Regards, Adrien On 10/7/23 12:01 AM, Gio Bacareza wrote: I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash (e.g., “Asset:Cash”), the software does not seem to automatically recognize and match these names during the import process. Instead, GnuCash prompts me to manually match the account names through its import wizard every time, which is unexpected and inconvenient. For instance, even if the CSV file contains the precise name “Asset:Cash”, GnuCash still requires manual intervention to match the names correctly. Is there a specific reason for this issue, or am I possibly making an error during the import process? I would appreciate any insight or advice on how to streamline this process and ensure GnuCash recognizes account names from the CSV file automatically. ___ 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.
Re: [GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
This is one of the reasons why it is not recommended to import a large file, especially one containing transactions from more than a single account on one side of each transaction. Read over the Help Manual & the Tutorial & Concepts Guide concerning imports. The usual recommended procedure is to break the import into smaller chunks depending on how many transactions you have in a month/year, etc. So for example, you might import January 2023 of your checking account. (from whatever other app, or from a bank download) Then reconcile, and repeat for February, then March, etc. As you go, you are training the matcher, so the imports speed up, and duplicates are detected. It is up to you, how big the import chunks are, but bigger is not necessarily faster, and maybe rarely is. Regards, Adrien On 10/6/23 11:57 PM, Gio Bacareza wrote: I've been attempting to import a large, consolidated CSV file containing multiple accounts into GnuCash. Previously, I used to import transaction logs from various accounts individually, which I thought was a cumbersome process. To simplify this, I’ve created scripts to compile all transactions into one comprehensive CSV file for what I thought would be a more straightforward import process. However, I've encountered an issue where GnuCash duplicates certain transactions during the import. Specifically, this happens when a transaction represents a withdrawal from one account and a deposit into another, which are naturally recorded as two separate entries in the CSV. For instance, when money is withdrawn from a bank account and deposited into a cash account, the consolidated CSV file includes one row showing the bank account debit and another showing the cash account credit. I assumed that GnuCash’s import algorithm would recognize and eliminate these duplicate transactions during the import process as it typically does with other duplicates. Unfortunately, my tests indicate that it imports both transactions, resulting in duplicated entries. Is this a mistake on my part, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. ___ 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.
[GNC] Issues Recognizing Account Names When Importing CSV into GnuCash
I'm experiencing difficulties when importing a CSV file into GnuCash, particularly when the file contains both "Account" and "Target Account" columns. Despite meticulously encoding the account names in the CSV to match the exact account names as they appear in GnuCash (e.g., “Asset:Cash”), the software does not seem to automatically recognize and match these names during the import process. Instead, GnuCash prompts me to manually match the account names through its import wizard every time, which is unexpected and inconvenient. For instance, even if the CSV file contains the precise name “Asset:Cash”, GnuCash still requires manual intervention to match the names correctly. Is there a specific reason for this issue, or am I possibly making an error during the import process? I would appreciate any insight or advice on how to streamline this process and ensure GnuCash recognizes account names from the CSV file automatically. -- cheers, Gio ___ 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.
[GNC] Issues Importing a Large CSV with Multiple Accounts into GnuCash: Is Duplicated Transactions Normal?
I've been attempting to import a large, consolidated CSV file containing multiple accounts into GnuCash. Previously, I used to import transaction logs from various accounts individually, which I thought was a cumbersome process. To simplify this, I’ve created scripts to compile all transactions into one comprehensive CSV file for what I thought would be a more straightforward import process. However, I've encountered an issue where GnuCash duplicates certain transactions during the import. Specifically, this happens when a transaction represents a withdrawal from one account and a deposit into another, which are naturally recorded as two separate entries in the CSV. For instance, when money is withdrawn from a bank account and deposited into a cash account, the consolidated CSV file includes one row showing the bank account debit and another showing the cash account credit. I assumed that GnuCash’s import algorithm would recognize and eliminate these duplicate transactions during the import process as it typically does with other duplicates. Unfortunately, my tests indicate that it imports both transactions, resulting in duplicated entries. Is this a mistake on my part, or is this behavior expected from GnuCash when importing a large CSV with multiple accounts? Any insights or solutions to prevent these duplicates would be greatly appreciated. -- cheers, Gio ___ 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.
Re: [GNC] Importing stock prices from a CSV file
> On Oct 2, 2023, at 01:46, flywire wrote: > > While importing csv files is only really explained in the manual > (not the guide) in terms of transactions, there is a lot of supporting https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv > > > information for the Price Import Assistant in > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-price.html and > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html > > The term security seems to be used interchangeably (ie it's not a subset) > with commodity and a symbol is a property of a commodity. > > - > > *Commodity: *A commodity is something of value that is easily tradeable > or sellable; for example, currencies, stocks, bonds, grain, copper, and oil > are all commodities. > > https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html > clearly describes Securities types are currency, fund, listing stock > exchange, or a user defined type. It seems some user defined types, for > example grain, would turn this into a commodity. It conflicts with the > second sentence below: > > - > > > *Security: The Security/commodity being priced. The display is sorted by > the Namespace that the individual securities are listed on. * > - > > *Symbol:* Indicates the symbol or abbreviation for the commodity. This > is usually the ticker symbol (for stocks) or other unique abbreviation for > the commodity. If the commodity is traded on any public exchange, it is > important to use the same identifier used on that exchange. For national > currencies the symbol is the ISO-4217 currency code. > - > > *Namespace:* What is a reasonable description of this group [of > commodities ??] ? The only reference to Namespace in the documentation is > quoted above but referring to a group of stock by listing exchange is too > restrictive. Namespace is the better name for security type. The Security Editor manual page is out of date, we've removed the hard-coded namespaces FUND, AMEX, ASX, EUREX, NASDAQ, and NYSE from the program; they seemed to be more confusing than helpful because they obscured that users could create their own. Regards, John Ralls ___ 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.
Re: [GNC] Importing stock prices from a CSV file
While importing csv files is only really explained in the manual https://www.gnucash.org/docs/v5/C/gnucash-manual/trans-import.html#trans-import-csv (not the guide) in terms of transactions, there is a lot of supporting information for the Price Import Assistant in https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-price.html and https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html The term security seems to be used interchangeably (ie it's not a subset) with commodity and a symbol is a property of a commodity. - *Commodity: *A commodity is something of value that is easily tradeable or sellable; for example, currencies, stocks, bonds, grain, copper, and oil are all commodities. https://www.gnucash.org/docs/v5/C/gnucash-manual/tool-security-edit.html clearly describes Securities types are currency, fund, listing stock exchange, or a user defined type. It seems some user defined types, for example grain, would turn this into a commodity. It conflicts with the second sentence below: - *Security: The Security/commodity being priced. The display is sorted by the Namespace that the individual securities are listed on. * - *Symbol:* Indicates the symbol or abbreviation for the commodity. This is usually the ticker symbol (for stocks) or other unique abbreviation for the commodity. If the commodity is traded on any public exchange, it is important to use the same identifier used on that exchange. For national currencies the symbol is the ISO-4217 currency code. - *Namespace:* What is a reasonable description of this group [of commodities ??] ? The only reference to Namespace in the documentation is quoted above but referring to a group of stock by listing exchange is too restrictive. ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Can we focus this back on improving the clarity of the Price Import Assistant? The first page is essentially the full documentation of the process. https://github.com/Gnucash/gnucash/blob/5.4/gnucash/gtkbuilder/assistant-csv-price-import.glade#L55 uses the column labels: Date, Amount, From Namespace, From Symbol and Currency To, irrespective of the labels used elsewhere for this data. A csv file can use any column order, a header is optional, and the Import Assistant doesn't use the header names. Various options exist for specifying the delimiter as well as a fixed width option. Double quotes are not required as shown in other examples. I am confused by seemingly different labels being used within GnuCash for the same data and I highlighted Commodity, Security, Namespace and Symbol. How exactly is "CURRENCY" used in that example? Does it refer to the default for the security or user/file? It also seems From Symbol for https://www.vanguard.com.au/personal/invest-with-us/etf?portId=8205 could be VAS, VAS.ASX, or VAS.AX (ie custom Yahoo exchange code). I understand >From Namespace is any convenient label the user chooses for the group of Securities [??], not necessarily the Stock Exchange which could form part of the From Symbol. ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Attached is a file of what it would look like with same security prices for different day and with multiple of these examples repeated for other securities and/or indexes ... -Original Message- From: Kalpesh Patel Sent: Sunday, October 01, 2023 7:49 PM To: 'flywire' ; 'Ove Grunnér' Cc: 'Gnucash Users' Subject: RE: [GNC] Importing stock prices from a CSV file Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each formatted as denoted above. Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are required. Date format I've utilized and has worked flawlessly has been mm/dd/. NAME_SPACE corresponds to the top level name given in the 'Security' column in the 'Price Database' window and corresponds to 'From Namespace' heading in the 'Import Preview' window. I normally set this to what Yahoo Finance reports as the exchange where the security trades. This also is same thing as 'Namespace" in the 'Securities' window. See code at https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py for details if you are knowledged in Python. https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has additional details... -Original Message- From: flywire Sent: Saturday, September 30, 2023 6:46 PM To: Ove Grunnér Cc: Gnucash Users Subject: Re: [GNC] Importing stock prices from a CSV file Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. gnucash_quotes.csv Description: MS-Excel spreadsheet ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Just to remove any confusion, the CSV format of the importing stock prices as of GNC v4.18 is as follows (which I don’t believe has changed in later and 5.x version)... "NAME_SPACE","TICKER_SYMBOL",date,"PRICE","QUOTE_CURRENCY" One line per record each formatted as denoted above. Double quotes around NAME_SPACE, TICKER_SYMBOL, PRICE and QUOTE_CURRENCY are required. Date format I've utilized and has worked flawlessly has been mm/dd/. NAME_SPACE corresponds to the top level name given in the 'Security' column in the 'Price Database' window and corresponds to 'From Namespace' heading in the 'Import Preview' window. I normally set this to what Yahoo Finance reports as the exchange where the security trades. This also is same thing as 'Namespace" in the 'Securities' window. See code at https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/get_historic_quotes.py for details if you are knowledged in Python. https://github.com/ka-patel/dl_quotes/blob/main/yahoo_finance/README.md has additional details... -Original Message- From: flywire Sent: Saturday, September 30, 2023 6:46 PM To: Ove Grunnér Cc: Gnucash Users Subject: Re: [GNC] Importing stock prices from a CSV file Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Yes Ove, clearly there is more to it as demonstrated by your example. I can see the importer is using Commodity, Price Database uses Security, and Security Editor uses Namespace and Symbol. https://www.gnucash.org/docs/v5/C/gnucash-guide/gnc-gloss.html doesn't help much. ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Hi, if it helps, this is what an import file can look like when importing stock prices. the name space for stocks is the same name space you see in the security editor Menu -> Tools:Security Editor. So if you call the namespace for a stock e.g. NASDAQ when you create the stock, then that will be the name space you need when importing stock prices. file example Account_Name,Rate,Balance Currency,Date,Name Space ALV.DE,207.95,EUR,2023-06-10,Euronext AMZN,123.43,USD,2023-06-10,NASDAQ ASML.AS,666.6,EUR,2023-06-10,Euronext AZN.ST,1598,SEK,2023-06-10,StockholmsBorsen BAS.DE,46.02,EUR,2023-06-10,Euronext CA.PA,26.52,EUR,2023-06-10,Euronext Kind Regards, Ove. On Sat, 30 Sept 2023 at 22:31, flywire wrote: > The process works but the Price Import Assistant Summary description and > poor user interface labels are confusing. I use csv import all the time but > this is so bad I can't understand it. > > [the minimum columns] are Date, Amount, From Namespace, From Symbol and > Currency To. If all entries are for the same Commodity / Currency then you > can select them and then the columns will be Date and Amount... > > Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and > CURRENCY:USD;2016-11-21;1.56;GBP > > Isn't FTSE an index and what is the .L ? So currency can be prefixed with > CURRENCY: ? > > I don't understand the data (except date and amount) which means I can't > understand the column format example. It would be a lot clearer if the > columns were in the same order as the description, and even better with a > header line, so the data didn't have to be understood to understand > the columns. > > I still have no idea what the file would look like when all entries are > the same commodity... > > Surely this process should support the default currency like elsewhere in > GnuCash and the column names are absurd. > > Thanks Ken. That link had a nice clear example but it will not work now > without the From Namespace (coder jargon for Stock Exchange). > > I just tested with the following CSV: > AAPL,23/8/2018,USD,255.37 > ABF.L,23/8/2018,GBP,25 > ___ > 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.
Re: [GNC] Importing stock prices from a CSV file
The process works but the Price Import Assistant Summary description and poor user interface labels are confusing. I use csv import all the time but this is so bad I can't understand it. [the minimum columns] are Date, Amount, From Namespace, From Symbol and Currency To. If all entries are for the same Commodity / Currency then you can select them and then the columns will be Date and Amount... Examples are "FTSE","RR.L","21/11/2016",5.345,"GBP” and CURRENCY:USD;2016-11-21;1.56;GBP Isn't FTSE an index and what is the .L ? So currency can be prefixed with CURRENCY: ? I don't understand the data (except date and amount) which means I can't understand the column format example. It would be a lot clearer if the columns were in the same order as the description, and even better with a header line, so the data didn't have to be understood to understand the columns. I still have no idea what the file would look like when all entries are the same commodity... Surely this process should support the default currency like elsewhere in GnuCash and the column names are absurd. Thanks Ken. That link had a nice clear example but it will not work now without the From Namespace (coder jargon for Stock Exchange). I just tested with the following CSV: AAPL,23/8/2018,USD,255.37 ABF.L,23/8/2018,GBP,25 ___ 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.
Re: [GNC] Importing stock prices from a CSV file
I'll refer you to a process I sent in to the lists a while back. https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079430.html David T. On Sep 30, 2023, 1:38 AM, at 1:38 AM, flywire wrote: >I'll work with the Price Import Assistant druid. Is it actually >documented? >I found >https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices > >> >___ >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.
Re: [GNC] Importing stock prices from a CSV file
I'm not sure about the process. I'm led to believe it's built into GnuCash and relatively simple to use? Here's a past discussion prompted by someone having difficulties and eventually figuring it out: https://lists.gnucash.org/pipermail/gnucash-user/2018-August/079372.html Hopefully this will be helpful, at least it gives some examples of correct format, etc. ___ 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.
Re: [GNC] Importing stock prices from a CSV file
Here's a couple of examples: https://wiki.gnucash.org/wiki/Importing_fund_or_stock_prices_from_an_OFX_file https://wiki.gnucash.org/wiki/Stocks/get_prices On 9/29/23 16:33, flywire wrote: I'll work with the Price Import Assistant druid. Is it actually documented? I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices ___ 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.
Re: [GNC] Importing stock prices from a CSV file
I'll work with the Price Import Assistant druid. Is it actually documented? I found https://wiki.gnucash.org/wiki/CSV_Import/Export#Importing_Prices > ___ 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.
[GNC] Importing stock prices from a CSV file
I have loaded my stock portfolio into GnuCash for tax reporting purposes. I'd like to update stock prices annually by importing the closing value for 30 June from a csv. Can someone give me a rundown on the required input and process? I'd be happy to add it to https://wiki.gnucash.org/wiki/Using_GnuCash#Stocks_and_Commodities ___ 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.
Re: [GNC] Importing data from QuickBooks Online
Thanks, Vincent! -- Tom “There’s nothing to prevent the federal government from creating as much money as it wants and paying it to somebody.” — Alan Greenspan > On Jul 6, 2023, at 5:57 PM, Vincent Dawans wrote: > > Thanks Tom. I added the link to the FAQ FAQ - GnuCash > <https://wiki.gnucash.org/wiki/FAQ#Quickbooks.C2.AE.3F> > --Vincent > > On Wed, Jul 5, 2023 at 9:39 AM Tom Olin <mailto:t...@tomolin.net>> wrote: > I’ve posted my script here: > > https://gist.github.com/trolin522581/cd9b8d684b0f9e0c8aed8876b256e31e > <https://gist.github.com/trolin522581/cd9b8d684b0f9e0c8aed8876b256e31e> > > I’ll leave the wiki link to someone else. > > -- > Tom > > For the government, which came first? (a) first $ taxed; (b) first $ > borrowed; (c) first $ spent. (Hint: state or federal?) > >> On Jul 4, 2023, at 8:31 PM, Vincent Dawans > <mailto:dawa...@gmail.com>> wrote: >> >> May I suggest also posting this in the FAQ section on the wiki, there is a >> section that mentions Quickbooks import. >> See here: >> https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_... >> <https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...> >> >> You could put your file in a github gist for easy sharing. Then link from >> the FAQ. There is already a link there for some other script from Linux >> Weekly News but I haven't checked what that looks like. >> >> On Tue, Jul 4, 2023 at 3:44 PM Tom Olin > <mailto:t...@tomolin.net>> wrote: >> Here’s the final version (for now) of my script. I hope someone else finds >> it useful. >> >> Thanks to all who responded to my query with suggestions. >> >> -- >> Tom >> >> Federal taxes can be paid with dollars, but the dollars have to be created >> (spent) by the government before anyone has dollars with which to pay their >> taxes. >> >>> On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user >>> mailto:gnucash-user@gnucash.org>> wrote: >>> >>> Vincent, >>> >>> Thanks so much for figuring this out! If you don’t mind, I’d like to give >>> you credit in my file. >>> >>> I’m going to rerun the entire dataset as a final test. I will repost the >>> final version of the script here for anyone else looking to do this. >>> >>> Thanks, again! >>> >>> -- >>> Tom >>> >>> Federal spending funds taxes. It is impossible to pay taxes until the >>> government has spent money into the economy. >>> >>>> On Jul 3, 2023, at 10:37 PM, Vincent Dawans >>> <mailto:dawa...@gmail.com>> wrote: >>>> >>>> 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 >>>> reconciled flag or the flag is different, I am not sure. But that's where >>>> the problem is, something to do with the Y reconcile flag. >>>> >>>> Sincerely, >>>> >>>> Vincent Dawans >>>> >>>> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin >>> <mailto:t...@tomolin.net> <mailto:t...@tomolin.net >>>> <mailto:t...@tomolin.net>>> wrote: >>>> 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 >>>> >>>> Money is created when banks loan and when the federal government spends. >>>> The latter increases someone’s net worth. The former does not, but the >>>> interest and fees transfer net worth from the borrower to the lender. >>>> >>>>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans >>>> <mailto:dawa...@gmail.com> <mailto:dawa...@gmail.com >>>>> <mailto:dawa...@gmail.com>>> wrote: >>>>> >>>>> Tom: >>>>> >>>>> I haven't read every single email in this thre
Re: [GNC] Importing data from QuickBooks Online
Thanks Tom. I added the link to the FAQ FAQ - GnuCash <https://wiki.gnucash.org/wiki/FAQ#Quickbooks.C2.AE.3F> --Vincent On Wed, Jul 5, 2023 at 9:39 AM Tom Olin wrote: > I’ve posted my script here: > > https://gist.github.com/trolin522581/cd9b8d684b0f9e0c8aed8876b256e31e > > I’ll leave the wiki link to someone else. > > -- > Tom > > For the government, which came first? (a) first $ taxed; (b) first > $ borrowed; (c) first $ spent. (Hint: state or federal?) > > On Jul 4, 2023, at 8:31 PM, Vincent Dawans wrote: > > May I suggest also posting this in the FAQ section on the wiki, there is a > section that mentions Quickbooks import. > See here: > https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_... > > You could put your file in a github gist for easy sharing. Then link from > the FAQ. There is already a link there for some other script from Linux > Weekly News but I haven't checked what that looks like. > > On Tue, Jul 4, 2023 at 3:44 PM Tom Olin wrote: > >> Here’s the final version (for now) of my script. I hope someone else >> finds it useful. >> >> Thanks to all who responded to my query with suggestions. >> >> -- >> Tom >> >> Federal taxes can be paid with dollars, but the dollars have to >> be created (spent) by the government before anyone has dollars with which >> to pay their taxes. >> >> On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >> Vincent, >> >> Thanks so much for figuring this out! If you don’t mind, I’d like to give >> you credit in my file. >> >> I’m going to rerun the entire dataset as a final test. I will repost the >> final version of the script here for anyone else looking to do this. >> >> Thanks, again! >> >> -- >> Tom >> >> Federal spending funds taxes. It is impossible to pay taxes until the >> government has spent money into the economy. >> >> On Jul 3, 2023, at 10:37 PM, Vincent Dawans wrote: >> >> 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 >> reconciled flag or the flag is different, I am not sure. But that's where >> the problem is, something to do with the Y reconcile flag. >> >> Sincerely, >> >> Vincent Dawans >> >> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin > mailto:t...@tomolin.net >> wrote: >> 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 >> >> Money is created when banks loan and when the federal government spends. >> The latter increases someone’s net worth. The former does not, but the >> interest and fees transfer net worth from the borrower to the lender. >> >> On Jul 3, 2023, at 6:44 PM, Vincent Dawans > mailto:dawa...@gmail.com >> wrote: >> >> 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 you can pare down your 2022 csv file while still having the problem. >> Can you pair it down to just a few transactions, like 5 or 10 max? Can you >> then change some of that data in that pared down file and still have the >> problem? By simplifying you can often more easily find the source of the >> problem and also might be able to share your csv file when it reaches the >> point where the data in it is no longer personal. >> >> Sincerely, >> >> Vincent Dawans >> >> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user < >> gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org >> >> wrote: >> 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. >> >> -- >>
Re: [GNC] Importing data from QuickBooks Online
I’ve posted my script here: https://gist.github.com/trolin522581/cd9b8d684b0f9e0c8aed8876b256e31e I’ll leave the wiki link to someone else. -- Tom For the government, which came first? (a) first $ taxed; (b) first $ borrowed; (c) first $ spent. (Hint: state or federal?) > On Jul 4, 2023, at 8:31 PM, Vincent Dawans wrote: > > May I suggest also posting this in the FAQ section on the wiki, there is a > section that mentions Quickbooks import. > See here: > https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_... > <https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_...> > > You could put your file in a github gist for easy sharing. Then link from the > FAQ. There is already a link there for some other script from Linux Weekly > News but I haven't checked what that looks like. > > On Tue, Jul 4, 2023 at 3:44 PM Tom Olin <mailto:t...@tomolin.net>> wrote: > Here’s the final version (for now) of my script. I hope someone else finds it > useful. > > Thanks to all who responded to my query with suggestions. > > -- > Tom > > Federal taxes can be paid with dollars, but the dollars have to be created > (spent) by the government before anyone has dollars with which to pay their > taxes. > >> On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user >> mailto:gnucash-user@gnucash.org>> wrote: >> >> Vincent, >> >> Thanks so much for figuring this out! If you don’t mind, I’d like to give >> you credit in my file. >> >> I’m going to rerun the entire dataset as a final test. I will repost the >> final version of the script here for anyone else looking to do this. >> >> Thanks, again! >> >> -- >> Tom >> >> Federal spending funds taxes. It is impossible to pay taxes until the >> government has spent money into the economy. >> >>> On Jul 3, 2023, at 10:37 PM, Vincent Dawans >> <mailto:dawa...@gmail.com>> wrote: >>> >>> 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 >>> reconciled flag or the flag is different, I am not sure. But that's where >>> the problem is, something to do with the Y reconcile flag. >>> >>> Sincerely, >>> >>> Vincent Dawans >>> >>> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin >> <mailto:t...@tomolin.net> <mailto:t...@tomolin.net >>> <mailto:t...@tomolin.net>>> wrote: >>> 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 >>> >>> Money is created when banks loan and when the federal government spends. >>> The latter increases someone’s net worth. The former does not, but the >>> interest and fees transfer net worth from the borrower to the lender. >>> >>>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans >>> <mailto:dawa...@gmail.com> <mailto:dawa...@gmail.com >>>> <mailto:dawa...@gmail.com>>> wrote: >>>> >>>> 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 you can pare down your 2022 csv file while still having the problem. >>>> Can you pair it down to just a few transactions, like 5 or 10 max? Can >>>> you then change some of that data in that pared down file and still have >>>> the problem? By simplifying you can often more easily find the source of >>>> the problem and also might be able to share your csv file when it reaches >>>> the point where the data in it is no longer personal. >>>> >>>> Sincerely, >>>> >>>> Vincent Dawans >>>> >>>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via
Re: [GNC] Importing data from QuickBooks Online
May I suggest also posting this in the FAQ section on the wiki, there is a section that mentions Quickbooks import. See here: https://wiki.gnucash.org/wiki/FAQ#Q:_How_do_I_import_my_data_from_... You could put your file in a github gist for easy sharing. Then link from the FAQ. There is already a link there for some other script from Linux Weekly News but I haven't checked what that looks like. On Tue, Jul 4, 2023 at 3:44 PM Tom Olin wrote: > Here’s the final version (for now) of my script. I hope someone else finds > it useful. > > Thanks to all who responded to my query with suggestions. > > -- > Tom > > Federal taxes can be paid with dollars, but the dollars have to be created > (spent) by the government before anyone has dollars with which to pay their > taxes. > > On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user < > gnucash-user@gnucash.org> wrote: > > Vincent, > > Thanks so much for figuring this out! If you don’t mind, I’d like to give > you credit in my file. > > I’m going to rerun the entire dataset as a final test. I will repost the > final version of the script here for anyone else looking to do this. > > Thanks, again! > > -- > Tom > > Federal spending funds taxes. It is impossible to pay taxes until the > government has spent money into the economy. > > On Jul 3, 2023, at 10:37 PM, Vincent Dawans wrote: > > 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 > reconciled flag or the flag is different, I am not sure. But that's where > the problem is, something to do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin mailto:t...@tomolin.net >> wrote: > 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 > > Money is created when banks loan and when the federal government spends. > The latter increases someone’s net worth. The former does not, but the > interest and fees transfer net worth from the borrower to the lender. > > On Jul 3, 2023, at 6:44 PM, Vincent Dawans mailto:dawa...@gmail.com >> wrote: > > 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 you can pare down your 2022 csv file while still having the problem. > Can you pair it down to just a few transactions, like 5 or 10 max? Can you > then change some of that data in that pared down file and still have the > problem? By simplifying you can often more easily find the source of the > problem and also might be able to share your csv file when it reaches the > point where the data in it is no longer personal. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user < > gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org > >> wrote: > 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 banks loan and when the federal > government spends. Money is destroyed into thin air when bank loans are > repaid and when federal taxes are paid. > > On Jul 3, 2023, at 5:41 PM, Ken Pyzik mailto:py...@outlook.com >> wrote: > > 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 > somehow added a change flag or some other thing to the data to prevent you > from exporting it as easy as it used to be. This could be the discrepancy > you are experiencing. In other words, to prevent people from doing what > you are exactly trying to do -- they may have placed a simple data offset > or some other thing into the data to prevent easy ex
Re: [GNC] Importing data from QuickBooks Online
Here’s the final version (for now) of my script. I hope someone else finds it useful. Thanks to all who responded to my query with suggestions. -- Tom Federal taxes can be paid with dollars, but the dollars have to be created (spent) by the government before anyone has dollars with which to pay their taxes. > On Jul 4, 2023, at 8:00 AM, Tom Olin via gnucash-user > wrote: > > Vincent, > > Thanks so much for figuring this out! If you don’t mind, I’d like to give you > credit in my file. > > I’m going to rerun the entire dataset as a final test. I will repost the > final version of the script here for anyone else looking to do this. > > Thanks, again! > > -- > Tom > > Federal spending funds taxes. It is impossible to pay taxes until the > government has spent money into the economy. > >> On Jul 3, 2023, at 10:37 PM, Vincent Dawans wrote: >> >> 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 >> reconciled flag or the flag is different, I am not sure. But that's where >> the problem is, something to do with the Y reconcile flag. >> >> Sincerely, >> >> Vincent Dawans >> >> On Mon, Jul 3, 2023 at 4:41 PM Tom Olin > <mailto:t...@tomolin.net>> wrote: >> 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 >> >> Money is created when banks loan and when the federal government spends. The >> latter increases someone’s net worth. The former does not, but the interest >> and fees transfer net worth from the borrower to the lender. >> >>> On Jul 3, 2023, at 6:44 PM, Vincent Dawans >> <mailto:dawa...@gmail.com>> wrote: >>> >>> 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 you can pare down your 2022 csv file while still having the problem. >>> Can you pair it down to just a few transactions, like 5 or 10 max? Can you >>> then change some of that data in that pared down file and still have the >>> problem? By simplifying you can often more easily find the source of the >>> problem and also might be able to share your csv file when it reaches the >>> point where the data in it is no longer personal. >>> >>> Sincerely, >>> >>> Vincent Dawans >>> >>> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user >>> mailto:gnucash-user@gnucash.org>> wrote: >>> 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 banks loan and when the federal >>> government spends. Money is destroyed into thin air when bank loans are >>> repaid and when federal taxes are paid. >>> >>>> On Jul 3, 2023, at 5:41 PM, Ken Pyzik >>> <mailto:py...@outlook.com>> wrote: >>>> >>>> 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 somehow added a change flag or some other thing to the data to >>>> prevent you from exporting it as easy as it used to be. This could be the >>>> discrepancy you are experiencing. In other words, to prevent people from >>>> doing what you are exactly trying to do -- they may have placed a simple >>>> data offset
Re: [GNC] Importing data from QuickBooks Online
Vincent, Thanks so much for figuring this out! If you don’t mind, I’d like to give you credit in my file. I’m going to rerun the entire dataset as a final test. I will repost the final version of the script here for anyone else looking to do this. Thanks, again! -- Tom Federal spending funds taxes. It is impossible to pay taxes until the government has spent money into the economy. > On Jul 3, 2023, at 10:37 PM, Vincent Dawans wrote: > > 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 reconciled > flag or the flag is different, I am not sure. But that's where the problem > is, something to do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin <mailto:t...@tomolin.net>> wrote: > 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 > > Money is created when banks loan and when the federal government spends. The > latter increases someone’s net worth. The former does not, but the interest > and fees transfer net worth from the borrower to the lender. > >> On Jul 3, 2023, at 6:44 PM, Vincent Dawans > <mailto:dawa...@gmail.com>> wrote: >> >> 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 >> you can pare down your 2022 csv file while still having the problem. Can you >> pair it down to just a few transactions, like 5 or 10 max? Can you then >> change some of that data in that pared down file and still have the problem? >> By simplifying you can often more easily find the source of the problem and >> also might be able to share your csv file when it reaches the point where >> the data in it is no longer personal. >> >> Sincerely, >> >> Vincent Dawans >> >> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user >> mailto:gnucash-user@gnucash.org>> wrote: >> 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 banks loan and when the federal >> government spends. Money is destroyed into thin air when bank loans are >> repaid and when federal taxes are paid. >> >> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik > > <mailto:py...@outlook.com>> wrote: >> > >> > 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 somehow added a change flag or some other thing to the data to >> > prevent you from exporting it as easy as it used to be. This could be the >> > discrepancy you are experiencing. In other words, to prevent people from >> > doing what you are exactly trying to do -- they may have placed a simple >> > data offset or some other thing into the data to prevent easy export. >> > Again, this could be a stretch -- but it would explain why one year comes >> > over correctly and the next does not. Just my two cents -- for what it is >> > worth ( which could be nothing at all!) >> > >> > Ken >> > >> > -Original Message- >> > From: gnucash-user > > <mailto:outlook@gnucash.org>> On Behalf Of Tom Olin via gnucash-user >> > Sent: Monday, July 3, 2023 1:55 PM >> > To: Kalpesh Patel mailto:kalpesh.pa...@usa.net>> >> > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> >> > Subject: Re: [GNC] Importing data from QuickBooks Onl
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 status of first line as cleared (gnucash.org) <https://bugs.gnucash.org/show_bug.cgi?id=796890> On Mon, Jul 3, 2023 at 7:37 PM Vincent Dawans wrote: > 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 > reconciled flag or the flag is different, I am not sure. But that's where > the problem is, something to do with the Y reconcile flag. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 4:41 PM Tom Olin wrote: > >> 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 >> >> Money is created when banks loan and when the federal government spends. >> The latter increases someone’s net worth. The former does not, but the >> interest and fees transfer net worth from the borrower to the lender. >> >> On Jul 3, 2023, at 6:44 PM, Vincent Dawans wrote: >> >> 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 you can pare down your 2022 csv file while still having the problem. >> Can you pair it down to just a few transactions, like 5 or 10 max? Can you >> then change some of that data in that pared down file and still have the >> problem? By simplifying you can often more easily find the source of the >> problem and also might be able to share your csv file when it reaches the >> point where the data in it is no longer personal. >> >> Sincerely, >> >> Vincent Dawans >> >> On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user < >> gnucash-user@gnucash.org> wrote: >> >>> 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 banks loan and when the federal >>> government spends. Money is destroyed into thin air when bank loans are >>> repaid and when federal taxes are paid. >>> >>> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik wrote: >>> > >>> > 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 somehow added a change flag or some other thing to the data to prevent >>> you from exporting it as easy as it used to be. This could be the >>> discrepancy you are experiencing. In other words, to prevent people from >>> doing what you are exactly trying to do -- they may have placed a simple >>> data offset or some other thing into the data to prevent easy export. >>> Again, this could be a stretch -- but it would explain why one year comes >>> over correctly and the next does not. Just my two cents -- for what it is >>> worth ( which could be nothing at all!) >>> > >>> > Ken >>> > >>> > -Original Message- >>> > From: gnucash-user >>> On Behalf Of Tom Olin via gnucash-user >>> > Sent: Monday, July 3, 2023 1:55 PM >>> > To: Kalpesh Patel >>> > Cc: gnucash-user@gnucash.org >>> > Subject: Re: [GNC] Importing data from QuickBooks Online >>> > >>> > Good shot, but no, date formats are consistent. >>> > >>> > -- >>> > Tom >
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 reconciled flag or the flag is different, I am not sure. But that's where the problem is, something to do with the Y reconcile flag. Sincerely, Vincent Dawans On Mon, Jul 3, 2023 at 4:41 PM Tom Olin wrote: > 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 > > Money is created when banks loan and when the federal government spends. > The latter increases someone’s net worth. The former does not, but the > interest and fees transfer net worth from the borrower to the lender. > > On Jul 3, 2023, at 6:44 PM, Vincent Dawans wrote: > > 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 you can pare down your 2022 csv file while still having the problem. > Can you pair it down to just a few transactions, like 5 or 10 max? Can you > then change some of that data in that pared down file and still have the > problem? By simplifying you can often more easily find the source of the > problem and also might be able to share your csv file when it reaches the > point where the data in it is no longer personal. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user < > gnucash-user@gnucash.org> wrote: > >> 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 banks loan and when the federal >> government spends. Money is destroyed into thin air when bank loans are >> repaid and when federal taxes are paid. >> >> > On Jul 3, 2023, at 5:41 PM, Ken Pyzik wrote: >> > >> > 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 >> somehow added a change flag or some other thing to the data to prevent you >> from exporting it as easy as it used to be. This could be the discrepancy >> you are experiencing. In other words, to prevent people from doing what >> you are exactly trying to do -- they may have placed a simple data offset >> or some other thing into the data to prevent easy export. Again, this >> could be a stretch -- but it would explain why one year comes over >> correctly and the next does not. Just my two cents -- for what it is worth >> ( which could be nothing at all!) >> > >> > Ken >> > >> > -Original Message- >> > From: gnucash-user >> On Behalf Of Tom Olin via gnucash-user >> > Sent: Monday, July 3, 2023 1:55 PM >> > To: Kalpesh Patel >> > Cc: gnucash-user@gnucash.org >> > Subject: 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 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 remember their exports when it came to Quicken was all over the map >> for the format of the date and ended up normalizing it with an external >> script when I did a full migration from Quicken to GNC. By far this, the >> date format, was bigg
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 Money is created when banks loan and when the federal government spends. The latter increases someone’s net worth. The former does not, but the interest and fees transfer net worth from the borrower to the lender. > On Jul 3, 2023, at 6:44 PM, Vincent Dawans wrote: > > 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 you can pare > down your 2022 csv file while still having the problem. Can you pair it down > to just a few transactions, like 5 or 10 max? Can you then change some of > that data in that pared down file and still have the problem? By simplifying > you can often more easily find the source of the problem and also might be > able to share your csv file when it reaches the point where the data in it is > no longer personal. > > Sincerely, > > Vincent Dawans > > On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user > mailto:gnucash-user@gnucash.org>> wrote: > 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 banks loan and when the federal > government spends. Money is destroyed into thin air when bank loans are > repaid and when federal taxes are paid. > > > On Jul 3, 2023, at 5:41 PM, Ken Pyzik > <mailto:py...@outlook.com>> wrote: > > > > 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 > > somehow added a change flag or some other thing to the data to prevent you > > from exporting it as easy as it used to be. This could be the discrepancy > > you are experiencing. In other words, to prevent people from doing what > > you are exactly trying to do -- they may have placed a simple data offset > > or some other thing into the data to prevent easy export. Again, this > > could be a stretch -- but it would explain why one year comes over > > correctly and the next does not. Just my two cents -- for what it is worth > > ( which could be nothing at all!) > > > > Ken > > > > -Original Message- > > From: gnucash-user > <mailto:outlook....@gnucash.org>> On Behalf Of Tom Olin via gnucash-user > > Sent: Monday, July 3, 2023 1:55 PM > > To: Kalpesh Patel mailto:kalpesh.pa...@usa.net>> > > Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > > Subject: 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 >> <mailto:kalpesh.pa...@usa.net>> wrote: > >> > >> 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 remember > >> their exports when it came to Quicken was all over the map for the format > >> of the date and ended up normalizing it with an external script when I did > >> a full migration from Quicken to GNC. By far this, the date format, was > >> biggest PITA. > >> > >> -Original Message- > >> From: Tom Olin mailto:t...@tomolin.net>> > >> Sent: Monday, July 03, 2023 12:14 PM > >> To: Jean L mailto:rip...@gmail.com>> > >> Cc: gnucash-user@gnucash.org <mailto:gnucash-user@gnucash.org> > >> Subject: Re: [GNC] Importing data from QuickBooks Online > >> > >>
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 you can pare down your 2022 csv file while still having the problem. Can you pair it down to just a few transactions, like 5 or 10 max? Can you then change some of that data in that pared down file and still have the problem? By simplifying you can often more easily find the source of the problem and also might be able to share your csv file when it reaches the point where the data in it is no longer personal. Sincerely, Vincent Dawans On Mon, Jul 3, 2023 at 3:35 PM Tom Olin via gnucash-user < gnucash-user@gnucash.org> wrote: > 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 banks loan and when the federal > government spends. Money is destroyed into thin air when bank loans are > repaid and when federal taxes are paid. > > > On Jul 3, 2023, at 5:41 PM, Ken Pyzik wrote: > > > > 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 > somehow added a change flag or some other thing to the data to prevent you > from exporting it as easy as it used to be. This could be the discrepancy > you are experiencing. In other words, to prevent people from doing what > you are exactly trying to do -- they may have placed a simple data offset > or some other thing into the data to prevent easy export. Again, this > could be a stretch -- but it would explain why one year comes over > correctly and the next does not. Just my two cents -- for what it is worth > ( which could be nothing at all!) > > > > Ken > > > > -Original Message- > > From: gnucash-user > On Behalf Of Tom Olin via gnucash-user > > Sent: Monday, July 3, 2023 1:55 PM > > To: Kalpesh Patel > > Cc: gnucash-user@gnucash.org > > Subject: 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 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 remember their exports when it came to Quicken was all over the map > for the format of the date and ended up normalizing it with an external > script when I did a full migration from Quicken to GNC. By far this, the > date format, was biggest PITA. > >> > >> -Original Message- > >> From: Tom Olin > >> Sent: Monday, July 03, 2023 12:14 PM > >> To: Jean L > >> Cc: gnucash-user@gnucash.org > >> Subject: 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 suggests something that should be > easily worked around - if I can just figure out what it is. > >> > >> -- > >> Tom > >> > >> Federal tax dollars don’t exist. Federal spending creates dollars out > of thin air. With federal tax payments, the opposite occurs. > >> > >>> On Jul 3, 2023, at 12:04 PM, Jean L wrote: > >>> > >>> 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 i
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 banks loan and when the federal government spends. Money is destroyed into thin air when bank loans are repaid and when federal taxes are paid. > On Jul 3, 2023, at 5:41 PM, Ken Pyzik wrote: > > 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 > somehow added a change flag or some other thing to the data to prevent you > from exporting it as easy as it used to be. This could be the discrepancy > you are experiencing. In other words, to prevent people from doing what you > are exactly trying to do -- they may have placed a simple data offset or some > other thing into the data to prevent easy export. Again, this could be a > stretch -- but it would explain why one year comes over correctly and the > next does not. Just my two cents -- for what it is worth ( which could be > nothing at all!) > > Ken > > -Original Message- > From: gnucash-user On > Behalf Of Tom Olin via gnucash-user > Sent: Monday, July 3, 2023 1:55 PM > To: Kalpesh Patel > Cc: gnucash-user@gnucash.org > Subject: 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 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 remember their >> exports when it came to Quicken was all over the map for the format of the >> date and ended up normalizing it with an external script when I did a full >> migration from Quicken to GNC. By far this, the date format, was biggest >> PITA. >> >> -Original Message- >> From: Tom Olin >> Sent: Monday, July 03, 2023 12:14 PM >> To: Jean L >> Cc: gnucash-user@gnucash.org >> Subject: 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 suggests something that should be easily >> worked around - if I can just figure out what it is. >> >> -- >> Tom >> >> Federal tax dollars don’t exist. Federal spending creates dollars out of >> thin air. With federal tax payments, the opposite occurs. >> >>> On Jul 3, 2023, at 12:04 PM, Jean L wrote: >>> >>> 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 >>> interesting. >>> >>> Jean >>> >>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >>>> [Resending to the list. Original reply went only to Jim.] >>>> >>>> Jim, >>>> >>>> Fair questions. Answers below, and I’ve attached the script itself which >>>> includes documentation which addresses some of the questions. I’ve >>>> reviewed all documentation that I can find. >>>> >>>> From QBO, I export a journal report to XLS (only usable option in QBO). >>>> >>>> GnuCash 5.3 on macOS 11.7.8 >>>> >>>> See the script for the specific steps. >>>> >>>> The import matcher step of the import process is fully satisfied. That is >>>> the step labeled “Match Import and GnuCash accounts”. >>>> >>>> The problem manifests at the “Match Transactions” screen where all >
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 come up with would be some invisible characters in the text. But analysis shows no such characters. Thanks for the suggestion. -- Tom A forest has no "value" to capitalism until it is cut down. > On Jul 3, 2023, at 5:41 PM, Ken Pyzik wrote: > > 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 > somehow added a change flag or some other thing to the data to prevent you > from exporting it as easy as it used to be. This could be the discrepancy > you are experiencing. In other words, to prevent people from doing what you > are exactly trying to do -- they may have placed a simple data offset or some > other thing into the data to prevent easy export. Again, this could be a > stretch -- but it would explain why one year comes over correctly and the > next does not. Just my two cents -- for what it is worth ( which could be > nothing at all!) > > Ken > > -Original Message- > From: gnucash-user On > Behalf Of Tom Olin via gnucash-user > Sent: Monday, July 3, 2023 1:55 PM > To: Kalpesh Patel > Cc: gnucash-user@gnucash.org > Subject: 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 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 remember their >> exports when it came to Quicken was all over the map for the format of the >> date and ended up normalizing it with an external script when I did a full >> migration from Quicken to GNC. By far this, the date format, was biggest >> PITA. >> >> -Original Message- >> From: Tom Olin >> Sent: Monday, July 03, 2023 12:14 PM >> To: Jean L >> Cc: gnucash-user@gnucash.org >> Subject: 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 suggests something that should be easily >> worked around - if I can just figure out what it is. >> >> -- >> Tom >> >> Federal tax dollars don’t exist. Federal spending creates dollars out of >> thin air. With federal tax payments, the opposite occurs. >> >>> On Jul 3, 2023, at 12:04 PM, Jean L wrote: >>> >>> 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 >>> interesting. >>> >>> Jean >>> >>> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >>>> [Resending to the list. Original reply went only to Jim.] >>>> >>>> Jim, >>>> >>>> Fair questions. Answers below, and I’ve attached the script itself which >>>> includes documentation which addresses some of the questions. I’ve >>>> reviewed all documentation that I can find. >>>> >>>> From QBO, I export a journal report to XLS (only usable option in QBO). >>>> >>>> GnuCash 5.3 on macOS 11.7.8 >>>> >>>> See the script for the specific steps. >>>> >>>> The import matcher step of the import process is fully satisfied. That is >>>> the step labeled “Match Import and GnuCash accounts”. >>>> >>>> The problem mani
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 somehow added a change flag or some other thing to the data to prevent you from exporting it as easy as it used to be. This could be the discrepancy you are experiencing. In other words, to prevent people from doing what you are exactly trying to do -- they may have placed a simple data offset or some other thing into the data to prevent easy export. Again, this could be a stretch -- but it would explain why one year comes over correctly and the next does not. Just my two cents -- for what it is worth ( which could be nothing at all!) Ken -Original Message- From: gnucash-user On Behalf Of Tom Olin via gnucash-user Sent: Monday, July 3, 2023 1:55 PM To: Kalpesh Patel Cc: gnucash-user@gnucash.org Subject: 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 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 remember their > exports when it came to Quicken was all over the map for the format of the > date and ended up normalizing it with an external script when I did a full > migration from Quicken to GNC. By far this, the date format, was biggest PITA. > > -Original Message- > From: Tom Olin > Sent: Monday, July 03, 2023 12:14 PM > To: Jean L > Cc: gnucash-user@gnucash.org > Subject: 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 suggests something that should be easily > worked around - if I can just figure out what it is. > > -- > Tom > > Federal tax dollars don’t exist. Federal spending creates dollars out of thin > air. With federal tax payments, the opposite occurs. > >> On Jul 3, 2023, at 12:04 PM, Jean L wrote: >> >> 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 >> interesting. >> >> Jean >> >> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >>> [Resending to the list. Original reply went only to Jim.] >>> >>> Jim, >>> >>> Fair questions. Answers below, and I’ve attached the script itself which >>> includes documentation which addresses some of the questions. I’ve reviewed >>> all documentation that I can find. >>> >>> From QBO, I export a journal report to XLS (only usable option in QBO). >>> >>> GnuCash 5.3 on macOS 11.7.8 >>> >>> See the script for the specific steps. >>> >>> The import matcher step of the import process is fully satisfied. That is >>> the step labeled “Match Import and GnuCash accounts”. >>> >>> The problem manifests at the “Match Transactions” screen where all >>> transactions need to be matched. I’ve attached a screenshot if it is >>> supported here. >>> >>> One more data point: I tried changing one of the transactions in the 2022 >>> import file to 2023. It still failed the same way. >>> >>> — >>> Tom >>> >>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>>> >>>> Tom: >>>> >>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>>> written an awk script which appears to work well except for one major >>>>> issue. >>>> What format is the data which you export from Quickbooks Online? CSV >>>> (Comma Separated Values text files with tabular data)? QFX (Quicken >>>&g
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 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 remember their > exports when it came to Quicken was all over the map for the format of the > date and ended up normalizing it with an external script when I did a full > migration from Quicken to GNC. By far this, the date format, was biggest PITA. > > -Original Message- > From: Tom Olin > Sent: Monday, July 03, 2023 12:14 PM > To: Jean L > Cc: gnucash-user@gnucash.org > Subject: 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 suggests something that should be easily > worked around - if I can just figure out what it is. > > -- > Tom > > Federal tax dollars don’t exist. Federal spending creates dollars out of thin > air. With federal tax payments, the opposite occurs. > >> On Jul 3, 2023, at 12:04 PM, Jean L wrote: >> >> 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 >> interesting. >> >> Jean >> >> On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >>> [Resending to the list. Original reply went only to Jim.] >>> >>> Jim, >>> >>> Fair questions. Answers below, and I’ve attached the script itself which >>> includes documentation which addresses some of the questions. I’ve reviewed >>> all documentation that I can find. >>> >>> From QBO, I export a journal report to XLS (only usable option in QBO). >>> >>> GnuCash 5.3 on macOS 11.7.8 >>> >>> See the script for the specific steps. >>> >>> The import matcher step of the import process is fully satisfied. That is >>> the step labeled “Match Import and GnuCash accounts”. >>> >>> The problem manifests at the “Match Transactions” screen where all >>> transactions need to be matched. I’ve attached a screenshot if it is >>> supported here. >>> >>> One more data point: I tried changing one of the transactions in the 2022 >>> import file to 2023. It still failed the same way. >>> >>> — >>> Tom >>> >>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>>> >>>> Tom: >>>> >>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>>> written an awk script which appears to work well except for one major >>>>> issue. >>>> What format is the data which you export from Quickbooks Online? CSV >>>> (Comma Separated Values text files with tabular data)? QFX (Quicken >>>> Financial Exchange, similar to OFX)? >>>> >>>> What GnuCash version are you using? On what computer OS? >>>> >>>> What GnuCash sequence of actions do you use to import the data? >>>> >>>> >>>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>>> transactions import cleanly, but all 2022 transactions import unbalanced, >>>>> meaning I have to manually match up each of them - doable but tedious. >>>> Let's assume you are exporting data in CSV format, and using the current >>>> version of GnuCash (5.3), and importing using the File… Import… Import >>>> Transactions from CSV menu item. You should be directed through an import >>>> matcher. This is the place where GnuCash should assign accounts to balance >>>> each transaction. Is each transaction assigned to an account in the import >>>> matcher? >>>> >>>> Have you read the section
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 remember their exports when it came to Quicken was all over the map for the format of the date and ended up normalizing it with an external script when I did a full migration from Quicken to GNC. By far this, the date format, was biggest PITA. -Original Message- From: Tom Olin Sent: Monday, July 03, 2023 12:14 PM To: Jean L Cc: gnucash-user@gnucash.org Subject: 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 suggests something that should be easily worked around - if I can just figure out what it is. -- Tom Federal tax dollars don’t exist. Federal spending creates dollars out of thin air. With federal tax payments, the opposite occurs. > On Jul 3, 2023, at 12:04 PM, Jean L wrote: > > 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 > interesting. > > Jean > > On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >> [Resending to the list. Original reply went only to Jim.] >> >> Jim, >> >> Fair questions. Answers below, and I’ve attached the script itself which >> includes documentation which addresses some of the questions. I’ve reviewed >> all documentation that I can find. >> >> From QBO, I export a journal report to XLS (only usable option in QBO). >> >> GnuCash 5.3 on macOS 11.7.8 >> >> See the script for the specific steps. >> >> The import matcher step of the import process is fully satisfied. That is >> the step labeled “Match Import and GnuCash accounts”. >> >> The problem manifests at the “Match Transactions” screen where all >> transactions need to be matched. I’ve attached a screenshot if it is >> supported here. >> >> One more data point: I tried changing one of the transactions in the 2022 >> import file to 2023. It still failed the same way. >> >> — >> Tom >> >>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>> >>> Tom: >>> >>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>> written an awk script which appears to work well except for one major >>>> issue. >>> What format is the data which you export from Quickbooks Online? CSV (Comma >>> Separated Values text files with tabular data)? QFX (Quicken Financial >>> Exchange, similar to OFX)? >>> >>> What GnuCash version are you using? On what computer OS? >>> >>> What GnuCash sequence of actions do you use to import the data? >>> >>> >>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>> transactions import cleanly, but all 2022 transactions import unbalanced, >>>> meaning I have to manually match up each of them - doable but tedious. >>> Let's assume you are exporting data in CSV format, and using the current >>> version of GnuCash (5.3), and importing using the File… Import… Import >>> Transactions from CSV menu item. You should be directed through an import >>> matcher. This is the place where GnuCash should assign accounts to balance >>> each transaction. Is each transaction assigned to an account in the import >>> matcher? >>> >>> Have you read the section of the documentation explaining how to import >>> data? >>> >>>> Can anyone think of anything that would cause this behavior? I’ve ruled >>>> out Accounting Period. I’ve imported each year separately. I’ve exported >>>> each year separately from QBO. The behavior persists. >>>> >>>> I’m stumped. Any ideas? >>> I hope these questions help get enough information on the table to give >>> someone ideas. >>> >>> Best regards, >>>—Jim DeLaHunt >>> >>> >>> _
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 Reiser wrote: > > 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 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 portion. >> >> I tried changing a 2023 transaction to 2022 and it imported correctly. >> >> -- >> Tom >> >> For the government, which came first? (a) first $ taxed; (b) first $ >> borrowed; (c) first $ spent. (Hint: state or federal?) >> >>> On Jul 3, 2023, at 12:11 PM, David Reiser wrote: >>> >>> 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 >>> dbrei...@icloud.com >>> >>> >>> >>> >>>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user >>>> wrote: >>>> >>>> [Resending to the list. Original reply went only to Jim.] >>>> >>>> Jim, >>>> >>>> Fair questions. Answers below, and I’ve attached the script itself which >>>> includes documentation which addresses some of the questions. I’ve >>>> reviewed all documentation that I can find. >>>> >>>> From QBO, I export a journal report to XLS (only usable option in QBO). >>>> >>>> GnuCash 5.3 on macOS 11.7.8 >>>> >>>> See the script for the specific steps. >>>> >>>> The import matcher step of the import process is fully satisfied. That is >>>> the step labeled “Match Import and GnuCash accounts”. >>>> >>>> The problem manifests at the “Match Transactions” screen where all >>>> transactions need to be matched. I’ve attached a screenshot if it is >>>> supported here. >>>> >>>> One more data point: I tried changing one of the transactions in the 2022 >>>> import file to 2023. It still failed the same way. >>>> >>>> — >>>> Tom >>>> >>>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>>>> >>>>> Tom: >>>>> >>>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>>>> written an awk script which appears to work well except for one major >>>>>> issue. >>>>> >>>>> What format is the data which you export from Quickbooks Online? CSV >>>>> (Comma Separated Values text files with tabular data)? QFX (Quicken >>>>> Financial Exchange, similar to OFX)? >>>>> >>>>> What GnuCash version are you using? On what computer OS? >>>>> >>>>> What GnuCash sequence of actions do you use to import the data? >>>>> >>>>> >>>>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>>>> transactions import cleanly, but all 2022 transactions import >>>>>> unbalanced, meaning I have to manually match up each of them - doable >>>>>> but tedious. >>>>> >>>>> Let's assume you are exporting data in CSV format, and using the current >>>>> version of GnuCash (5.3), and importing using the File… Import… Import >>>>> Transactions from CSV menu item. You should be directed through an import >>>>> matcher. This is the place where GnuCash should assign accounts to >>>>> balance each transaction. Is each transaction assigned to an account in >>>>> the import matcher? >>>>> >>>>> Have you read the section of the documentation explaining how to import >>>>> data? >>>>> >>>>>> Can anyone think of anything that would cause this behavior? I’ve ruled >>>>>> out Accounting Period. I’ve imported each year separately. I’ve exported >>>>>> each year separately from QBO. The behavior persists. >>>>>> >>>>>> I’m stumped. Any ideas? >>>>> >>>>> I hope these questions help get enough information on the table to give >>>>> someone ideas. >>>>> >>>>> Best regards, >>>>> —Jim DeLaHunt >>>>> >>> >> > ___ 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.
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 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 portion. > > I tried changing a 2023 transaction to 2022 and it imported correctly. > > -- > Tom > > For the government, which came first? (a) first $ taxed; (b) first $ > borrowed; (c) first $ spent. (Hint: state or federal?) > >> On Jul 3, 2023, at 12:11 PM, David Reiser wrote: >> >> 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 >> dbrei...@icloud.com >> >> >> >> >>> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user >>> wrote: >>> >>> [Resending to the list. Original reply went only to Jim.] >>> >>> Jim, >>> >>> Fair questions. Answers below, and I’ve attached the script itself which >>> includes documentation which addresses some of the questions. I’ve reviewed >>> all documentation that I can find. >>> >>> From QBO, I export a journal report to XLS (only usable option in QBO). >>> >>> GnuCash 5.3 on macOS 11.7.8 >>> >>> See the script for the specific steps. >>> >>> The import matcher step of the import process is fully satisfied. That is >>> the step labeled “Match Import and GnuCash accounts”. >>> >>> The problem manifests at the “Match Transactions” screen where all >>> transactions need to be matched. I’ve attached a screenshot if it is >>> supported here. >>> >>> One more data point: I tried changing one of the transactions in the 2022 >>> import file to 2023. It still failed the same way. >>> >>> — >>> Tom >>> >>>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>>> >>>> Tom: >>>> >>>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>>> written an awk script which appears to work well except for one major >>>>> issue. >>>> >>>> What format is the data which you export from Quickbooks Online? CSV >>>> (Comma Separated Values text files with tabular data)? QFX (Quicken >>>> Financial Exchange, similar to OFX)? >>>> >>>> What GnuCash version are you using? On what computer OS? >>>> >>>> What GnuCash sequence of actions do you use to import the data? >>>> >>>> >>>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>>> transactions import cleanly, but all 2022 transactions import unbalanced, >>>>> meaning I have to manually match up each of them - doable but tedious. >>>> >>>> Let's assume you are exporting data in CSV format, and using the current >>>> version of GnuCash (5.3), and importing using the File… Import… Import >>>> Transactions from CSV menu item. You should be directed through an import >>>> matcher. This is the place where GnuCash should assign accounts to balance >>>> each transaction. Is each transaction assigned to an account in the import >>>> matcher? >>>> >>>> Have you read the section of the documentation explaining how to import >>>> data? >>>> >>>>> Can anyone think of anything that would cause this behavior? I’ve ruled >>>>> out Accounting Period. I’ve imported each year separately. I’ve exported >>>>> each year separately from QBO. The behavior persists. >>>>> >>>>> I’m stumped. Any ideas? >>>> >>>> I hope these questions help get enough information on the table to give >>>> someone ideas. >>>> >>>> Best regards, >>>> —Jim DeLaHunt >>>> >> > ___ 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.
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 portion. I tried changing a 2023 transaction to 2022 and it imported correctly. -- Tom For the government, which came first? (a) first $ taxed; (b) first $ borrowed; (c) first $ spent. (Hint: state or federal?) > On Jul 3, 2023, at 12:11 PM, David Reiser wrote: > > 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 > dbrei...@icloud.com > > > > >> On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user >> wrote: >> >> [Resending to the list. Original reply went only to Jim.] >> >> Jim, >> >> Fair questions. Answers below, and I’ve attached the script itself which >> includes documentation which addresses some of the questions. I’ve reviewed >> all documentation that I can find. >> >> From QBO, I export a journal report to XLS (only usable option in QBO). >> >> GnuCash 5.3 on macOS 11.7.8 >> >> See the script for the specific steps. >> >> The import matcher step of the import process is fully satisfied. That is >> the step labeled “Match Import and GnuCash accounts”. >> >> The problem manifests at the “Match Transactions” screen where all >> transactions need to be matched. I’ve attached a screenshot if it is >> supported here. >> >> One more data point: I tried changing one of the transactions in the 2022 >> import file to 2023. It still failed the same way. >> >> — >> Tom >> >>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>> >>> Tom: >>> >>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>> written an awk script which appears to work well except for one major >>>> issue. >>> >>> What format is the data which you export from Quickbooks Online? CSV (Comma >>> Separated Values text files with tabular data)? QFX (Quicken Financial >>> Exchange, similar to OFX)? >>> >>> What GnuCash version are you using? On what computer OS? >>> >>> What GnuCash sequence of actions do you use to import the data? >>> >>> >>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>> transactions import cleanly, but all 2022 transactions import unbalanced, >>>> meaning I have to manually match up each of them - doable but tedious. >>> >>> Let's assume you are exporting data in CSV format, and using the current >>> version of GnuCash (5.3), and importing using the File… Import… Import >>> Transactions from CSV menu item. You should be directed through an import >>> matcher. This is the place where GnuCash should assign accounts to balance >>> each transaction. Is each transaction assigned to an account in the import >>> matcher? >>> >>> Have you read the section of the documentation explaining how to import >>> data? >>> >>>> Can anyone think of anything that would cause this behavior? I’ve ruled >>>> out Accounting Period. I’ve imported each year separately. I’ve exported >>>> each year separately from QBO. The behavior persists. >>>> >>>> I’m stumped. Any ideas? >>> >>> I hope these questions help get enough information on the table to give >>> someone ideas. >>> >>> Best regards, >>> —Jim DeLaHunt >>> > ___ 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.
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 suggests something that should be easily worked around - if I can just figure out what it is. -- Tom Federal tax dollars don’t exist. Federal spending creates dollars out of thin air. With federal tax payments, the opposite occurs. > On Jul 3, 2023, at 12:04 PM, Jean L wrote: > > 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 > interesting. > > Jean > > On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: >> [Resending to the list. Original reply went only to Jim.] >> >> Jim, >> >> Fair questions. Answers below, and I’ve attached the script itself which >> includes documentation which addresses some of the questions. I’ve reviewed >> all documentation that I can find. >> >> From QBO, I export a journal report to XLS (only usable option in QBO). >> >> GnuCash 5.3 on macOS 11.7.8 >> >> See the script for the specific steps. >> >> The import matcher step of the import process is fully satisfied. That is >> the step labeled “Match Import and GnuCash accounts”. >> >> The problem manifests at the “Match Transactions” screen where all >> transactions need to be matched. I’ve attached a screenshot if it is >> supported here. >> >> One more data point: I tried changing one of the transactions in the 2022 >> import file to 2023. It still failed the same way. >> >> — >> Tom >> >>> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >>> >>> Tom: >>> >>> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>>> written an awk script which appears to work well except for one major >>>> issue. >>> What format is the data which you export from Quickbooks Online? CSV (Comma >>> Separated Values text files with tabular data)? QFX (Quicken Financial >>> Exchange, similar to OFX)? >>> >>> What GnuCash version are you using? On what computer OS? >>> >>> What GnuCash sequence of actions do you use to import the data? >>> >>> >>>> The data I’m importing spans the years 2022 and 2023. All 2023 >>>> transactions import cleanly, but all 2022 transactions import unbalanced, >>>> meaning I have to manually match up each of them - doable but tedious. >>> Let's assume you are exporting data in CSV format, and using the current >>> version of GnuCash (5.3), and importing using the File… Import… Import >>> Transactions from CSV menu item. You should be directed through an import >>> matcher. This is the place where GnuCash should assign accounts to balance >>> each transaction. Is each transaction assigned to an account in the import >>> matcher? >>> >>> Have you read the section of the documentation explaining how to import >>> data? >>> >>>> Can anyone think of anything that would cause this behavior? I’ve ruled >>>> out Accounting Period. I’ve imported each year separately. I’ve exported >>>> each year separately from QBO. The behavior persists. >>>> >>>> I’m stumped. Any ideas? >>> I hope these questions help get enough information on the table to give >>> someone ideas. >>> >>> Best regards, >>>—Jim DeLaHunt >>> >>> >>> ___ >>> 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 y
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 dbrei...@icloud.com > On Jul 3, 2023, at 11:59 AM, Tom Olin via gnucash-user > wrote: > > [Resending to the list. Original reply went only to Jim.] > > Jim, > > Fair questions. Answers below, and I’ve attached the script itself which > includes documentation which addresses some of the questions. I’ve reviewed > all documentation that I can find. > > From QBO, I export a journal report to XLS (only usable option in QBO). > > GnuCash 5.3 on macOS 11.7.8 > > See the script for the specific steps. > > The import matcher step of the import process is fully satisfied. That is the > step labeled “Match Import and GnuCash accounts”. > > The problem manifests at the “Match Transactions” screen where all > transactions need to be matched. I’ve attached a screenshot if it is > supported here. > > One more data point: I tried changing one of the transactions in the 2022 > import file to 2023. It still failed the same way. > > — > Tom > >> On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: >> >> Tom: >> >> On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: >>> I’m attempting to import data from QuickBooks Online to GnuCash. I’ve >>> written an awk script which appears to work well except for one major issue. >> >> What format is the data which you export from Quickbooks Online? CSV (Comma >> Separated Values text files with tabular data)? QFX (Quicken Financial >> Exchange, similar to OFX)? >> >> What GnuCash version are you using? On what computer OS? >> >> What GnuCash sequence of actions do you use to import the data? >> >> >>> The data I’m importing spans the years 2022 and 2023. All 2023 transactions >>> import cleanly, but all 2022 transactions import unbalanced, meaning I have >>> to manually match up each of them - doable but tedious. >> >> Let's assume you are exporting data in CSV format, and using the current >> version of GnuCash (5.3), and importing using the File… Import… Import >> Transactions from CSV menu item. You should be directed through an import >> matcher. This is the place where GnuCash should assign accounts to balance >> each transaction. Is each transaction assigned to an account in the import >> matcher? >> >> Have you read the section of the documentation explaining how to import data? >> >>> Can anyone think of anything that would cause this behavior? I’ve ruled out >>> Accounting Period. I’ve imported each year separately. I’ve exported each >>> year separately from QBO. The behavior persists. >>> >>> I’m stumped. Any ideas? >> >> I hope these questions help get enough information on the table to give >> someone ideas. >> >> Best regards, >> —Jim DeLaHunt >> ___ 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.
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 interesting. Jean On 7/3/2023 8:59 AM, Tom Olin via gnucash-user wrote: [Resending to the list. Original reply went only to Jim.] Jim, Fair questions. Answers below, and I’ve attached the script itself which includes documentation which addresses some of the questions. I’ve reviewed all documentation that I can find. From QBO, I export a journal report to XLS (only usable option in QBO). GnuCash 5.3 on macOS 11.7.8 See the script for the specific steps. The import matcher step of the import process is fully satisfied. That is the step labeled “Match Import and GnuCash accounts”. The problem manifests at the “Match Transactions” screen where all transactions need to be matched. I’ve attached a screenshot if it is supported here. One more data point: I tried changing one of the transactions in the 2022 import file to 2023. It still failed the same way. — Tom On Jul 2, 2023, at 11:55 PM, Jim DeLaHunt wrote: Tom: On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: I’m attempting to import data from QuickBooks Online to GnuCash. I’ve written an awk script which appears to work well except for one major issue. What format is the data which you export from Quickbooks Online? CSV (Comma Separated Values text files with tabular data)? QFX (Quicken Financial Exchange, similar to OFX)? What GnuCash version are you using? On what computer OS? What GnuCash sequence of actions do you use to import the data? The data I’m importing spans the years 2022 and 2023. All 2023 transactions import cleanly, but all 2022 transactions import unbalanced, meaning I have to manually match up each of them - doable but tedious. Let's assume you are exporting data in CSV format, and using the current version of GnuCash (5.3), and importing using the File… Import… Import Transactions from CSV menu item. You should be directed through an import matcher. This is the place where GnuCash should assign accounts to balance each transaction. Is each transaction assigned to an account in the import matcher? Have you read the section of the documentation explaining how to import data? Can anyone think of anything that would cause this behavior? I’ve ruled out Accounting Period. I’ve imported each year separately. I’ve exported each year separately from QBO. The behavior persists. I’m stumped. Any ideas? I hope these questions help get enough information on the table to give someone ideas. Best regards, —Jim DeLaHunt ___ 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. ___ 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.
Re: [GNC] Importing data from QuickBooks Online
Tom: On 2023-07-02 15:10, Tom Olin via gnucash-user wrote: I’m attempting to import data from QuickBooks Online to GnuCash. I’ve written an awk script which appears to work well except for one major issue. What format is the data which you export from Quickbooks Online? CSV (Comma Separated Values text files with tabular data)? QFX (Quicken Financial Exchange, similar to OFX)? What GnuCash version are you using? On what computer OS? What GnuCash sequence of actions do you use to import the data? The data I’m importing spans the years 2022 and 2023. All 2023 transactions import cleanly, but all 2022 transactions import unbalanced, meaning I have to manually match up each of them - doable but tedious. Let's assume you are exporting data in CSV format, and using the current version of GnuCash (5.3), and importing using the File… Import… Import Transactions from CSV menu item. You should be directed through an import matcher. This is the place where GnuCash should assign accounts to balance each transaction. Is each transaction assigned to an account in the import matcher? Have you read the section of the documentation explaining how to import data? Can anyone think of anything that would cause this behavior? I’ve ruled out Accounting Period. I’ve imported each year separately. I’ve exported each year separately from QBO. The behavior persists. I’m stumped. Any ideas? I hope these questions help get enough information on the table to give someone ideas. Best regards, —Jim DeLaHunt ___ 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.
[GNC] Importing data from QuickBooks Online
I’m attempting to import data from QuickBooks Online to GnuCash. I’ve written an awk script which appears to work well except for one major issue. The data I’m importing spans the years 2022 and 2023. All 2023 transactions import cleanly, but all 2022 transactions import unbalanced, meaning I have to manually match up each of them - doable but tedious. Can anyone think of anything that would cause this behavior? I’ve ruled out Accounting Period. I’ve imported each year separately. I’ve exported each year separately from QBO. The behavior persists. I’m stumped. Any ideas? -- Tom Federal spending funds taxes. It is impossible to pay taxes until the government has spent money into the economy. ___ 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.
Re: [GNC] New GnuCash file and importing Chart of Accounts
5. Enter a transaction to make all the starting balances in the new file match the ending balances from the old file, referring to the report you saved in step 1. Yes, you could use a single, massive transaction split on both the debit and credit side. Or you could use two massive transactions, one spit on the debit side and one on the credit side. But there is nothing wrong with taking the easy way and entering one transaction for each account in the balance sheet (each account of type asset or liability). The other side of each of these would be an account under equity (you could give it a name like ":equity at start of year). . When you have entered transactions for every non-zero asset of liability account, the balance of this account should match the equity on the Balance Sheet you were working form. Michael D Novack ___ 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.
Re: [GNC] New GnuCash file and importing Chart of Accounts
On 2023-04-11 15:50, Jay Bouxsein wrote: > I am running version 2.6.7. Wow! That's older even than my version, 2.6.19. > I have worked with my accountant to use GnuCash to assist him in > preparing end of year tax returns and he has suggested that I open > new books at the beginning of each new year. I don't know why your accountant recommended that, as it's extra work. One alternative would be simply to make a copy of the file at year-end and archive that copy. But that's not what you were asking about, so ... > Basically I want to create a new GnuCash file for tax year 2023 and > export into it the Chart of Accounts used by my 2022 GnuCash file. > Not the data, just the Chart of Accounts. 1. In the old file, create a balance sheet report. You'll need it in step 5, so print it or export it to HTML or something. 2. Click File » Export » Export Account Tree to CSV. 3. Click File » New File. You should see all tabs except Accounts disappear, and that one will be empty. 4. Click File » Import » Import Accounts from CSV. 5. Enter a transaction to make all the starting balances in the new file match the ending balances from the old file, referring to the report you saved in step 1. Stan Brown Tehachapi, CA, USA https://BrownMath.com ___ 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.
[GNC] New GnuCash file and importing Chart of Accounts
At the outset, I must confess that I am a senior who increasingly has difficulties using complicated software products, especially accounting products because I do not have detailed accounting knowledge but I do know the basics. I have worked with my accountant to use GnuCash to assist him in preparing end of year tax returns and he has suggested that I open new books at the beginning of each new year. I mostly use the checkbook register which accepts the check and deposit details and organizes them into appropriate sub accounts. I produce a P & L with expanded details and he works his magic. I am running version 2.6.7. I have created new GnuCash files in the past, but this year I am stuck. I just cannot remember how I did it in the past. I found a section in the Help materials which seemed to offer a good solution but when I tried it, I was unsuccessful and now I can't even find the precise section I had been using, not even whether it was in the Tutorial materials or the general manual. (Short term memory problems I guess.) Basically I want to create a new GnuCash file for tax year 2023 and export into it the Chart of Accounts used by my 2022 GnuCash file. Not the data, just the Chart of Accounts. I know I could start from scratch and work my way through the Setup Assistant, but I want to avoid the possibility of introducing errors not found in my 2022 file. I came across a statement in the Help materials stating the an easy way to achieve my goal was to go to the file menu and select "Export " and from the three options drop down select "Export Accounts" and in the window which opens I should be able to not only transfer the Chart of Accounts, but create the new GnuCash file I want to create. My attempts have failed because I believe that I am not pushing the right keys at the right time in the right order. I really need detailed instructions. Can any of you help? Jay B ___ 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.
Re: [GNC] Importing QFX
It's on holiday. :) It will be back. On Sat, Apr 8, 2023 at 10:31 AM Alan Schold via gnucash-user < gnucash-user@gnucash.org> wrote: > I just upgraded to 5.0 and now can no longer find the QFX choice under > Import. Where did it go? > > ___ > 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. > -- _ Richard Losey rlo...@gmail.com Micah 6:8 ___ 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.
Re: [GNC] Importing QFX
There is a bug filed, but the fix is promised for 5.1. I reverted back to 4.13 until then. Thank You, Gyle McCollam Gyle McCollam gmccol...@live.com<mailto:gmccol...@gyleshomes.com> email From: gnucash-user on behalf of Alan Schold via gnucash-user Sent: Saturday, April 8, 2023 11:30 AM To: GNU Cash User Subject: [GNC] Importing QFX I just upgraded to 5.0 and now can no longer find the QFX choice under Import. Where did it go? ___ 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.
[GNC] Importing QFX
I just upgraded to 5.0 and now can no longer find the QFX choice under Import. Where did it go? ___ 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.
Re: [GNC] Exporting from QuickBooks / Importing to GnuCash
According to https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/iif-overview-import-kit-sample-files-headers/L5CZIpJne_US_en_US IIF is a tab-separated-values format. You can import that with the CSV importer by setting the separator to Tab. Regards, John Ralls > On Mar 30, 2023, at 7:47 AM, Richard Lindgren wrote: > > I have been in contact with QuickBooks and they tell me that they only > export IIF formatted files. As I look in GnuCash, I do not find where it > will import the IIF files. Is there something that I am doing wrong or is > there a work around to import my files from QuickBooks? > > I really need your help here. > > Please advise me as to a good plan of attack? > > Thank you very much for help in this matter, and look forward to hearing > from you. > > Richard Lindgren > 12799 Sandridge Rd, Sawyer, MI 49125 > 269-876-9100 > rlindgr...@outlook.com > ___ > 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.
Re: [GNC] Exporting from QuickBooks / Importing to GnuCash
From Intuit: "Intuit Interchange Format (.IIF) files are ASCII text, TSV (Tab-Separated Value) files that QuickBooks Desktop uses to import or export lists or transactions" source: https://quickbooks.intuit.com/learn-support/en-us/manage-lists/iif-overview-import-kit-sample-files-and-headers/00/201577 So this could very well work, but I can't test it: Export from QB as IIF. Open IIF in a spreadsheet Save as a COMMA separated value file- that is, CSV ... ... instead of Intuit's TAB separated IIF file Then in GnuCash: File> Import> Import Txn's from CSV Hope it helps. Chris FWIW ... IMHO ... Intuit seems to have a track record of aggressively, even unethically, hiding technical pathways, or anything, which might help people do something which costs Intuit revenue. As contrasted with building a product which offers real value for money. IMHO. On 3/30/23 12:00, gnucash-user-requ...@gnucash.org wrote: Message: 4 Date: Thu, 30 Mar 2023 10:47:48 -0400 From: Richard Lindgren To: "gnucash-user@gnucash org" Subject: [GNC] Exporting from QuickBooks / Importing to GnuCash Message-ID: Content-Type: text/plain; charset="UTF-8" I have been in contact with QuickBooks and they tell me that they only export IIF formatted files. As I look in GnuCash, I do not find where it will import the IIF files. Is there something that I am doing wrong or is there a work around to import my files from QuickBooks? I really need your help here. Please advise me as to a good plan of attack? Thank you very much for help in this matter, and look forward to hearing from you. Richard Lindgren ___ 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.
