Re: [GNC] AQbanking Amex OFX Download Badly Broken
Message: 5 Date: Sun, 24 May 2020 00:19:33 -0400 From: "Alan" To: "'Gnucash Users'" Subject: [GNC] AQbanking Amex OFX Download Badly Broken Message-ID: <0fbc01d63182$87ba6ea0$972f4be0$@bigtowers.net> Content-Type: text/plain; charset="us-ascii" Tried the Aqbanking section on GnuCash 3.10 with my Amex account. It was encouraging to see the latest version of Aqbanking now recognizes the content in the OFX download (last broken version could only read the headers). Was about to congratulate the development team, but then I noticed something very wrong with the few hundred transactions I had just loaded into GnuCash. None of the payees matched anything that could be matched up with any previously entered, downloaded and audited transactions. Closer inspection revealed something very wrong, and repeated on every transaction record downloaded. I compared individual transactions in my Aqbanking debug log to the ones that GnuCash had downloaded. GnuCash apparently concatenated each memo field followed by a space, followed by the transaction payee name. None of the downloaded data ended up in a valid transaction memo field. This is badly broken, and totally unusable. I examined the debug log to see how well Aqbanking has been communicating with the bank. Headers show the session established and completed properly. Transaction records and fields were being presented correctly, amounts were correctly associated with the real payees, and Amex was proving a fully formed payee name followed by a fully formed memo field . The transaction ID number was also transferred consistently in the field, though GnuCash appears to be ignoring it. Someone had to go to a lot of trouble to do this, rather than just place each usable transaction field data into the closest matching ledger fields (even the transaction ID can be useful for simple dupe checking). That's all that we're looking for. Download the data, populate the record fields, and get back to business. So I'm at a total loss how anyone could have deliberately taken clearly defined fields and data (that should easily match the "Description" and "Notes" fields within GnuCash account ledgers), and pretty much destroy them, along with the user data sets that also have to be deleted and recreated. Hi Alan, I import downloaded .ofx files, as my bank doesn't offer direct connection, but I think GnuCash does the same thing with direct connect as importing a downloaded .ofx file. I believe (but this is just my idea) the fields are imported into the transaction Note field (View, Double Line) in order to not override the split Memo fields on existing transactions. The transaction ID number, if this is supposed to be the unique code for a transaction in an account, should be in an 'FITID' tag. The OFX libraries (libofx) were probably not designed for GnuCash, so we have to map as best we can. It may be worthwhile creating an enhancement type bug specifying how you'd like 'REFNUM' handled. Regards, Chris Good ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Data conversion to QuickBooks
First step is to back your datafile(s) up onto another device or a flashdrive or the cloud before you lose access. If you open Gnucash to your file, then select File->SaveAs the file manager normally opens at the location on your hard disk where your file is located. Note the path to the file if you are going to store it in a cloud location or change location to your flashdrive and store the file on it. You can get a free Dropbox account by signing up on their website which is then accessible from any device you connect to it from. Google Drive, OneDrve etc are all similar alternatives and most offer free limited storage to customers and keep a record of the account details. Once your file is safely stored you have the time to find an alternative device. - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Data conversion to QuickBooks
My advice is, replace the laptop. I think any other "fixes" would be painful. Gary -Original Message- From: gnucash-user [mailto:gnucash-user-bounces+diamondhranchqh=earthlink@gnucash.org] On Behalf Of Jane Knichel-Aldea Sent: Saturday, May 23, 2020 11:16 AM To: gnucash-user@gnucash.org Subject: [GNC] Data conversion to QuickBooks Hi: Does anyone know if a gnucash file can be converted to QuickBooks online? Or if not, is there an online version of Gnucash? I am about to lose my laptop so I will need online access to my file. Thank you, Best Regards, Jane Knichel Aldea 201-725-3507 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
And if you want to really get fancy, you have more filtering options with a Find than with a Transaction Report, then running the Account Report on the resulting register tab. The Transaction Report however does provide some nice dimensional sorting the Account Report lacks. Regards, Adrien > On May 24, 2020 w22d145, at 1:13 PM, D. wrote: > > Further: if you want to use the Account Report, first filter the register > for the dates (View->Filter by) and then run the report. If you want to use > the Transaction Report, once it informs you that you haven't selected any > account, open the Options and select the account and date range. > ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
Further: if you want to use the Account Report, first filter the register for the dates (View->Filter by) and then run the report. If you want to use the Transaction Report, once it informs you that you haven't selected any account, open the Options and select the account and date range. Original Message From: Adrien Monteleone Sent: Sun May 24 13:39:03 EDT 2020 To: gnucash-user Subject: Re: [GNC] Transaction report: selected date range The Transaction Report can be for multiple accounts, so it doesn’t matter what register is open at the time. The Account Report is for the currently viewed register. The two reports are quite different in their available options, however. Regards, Adrien > On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard > wrote: > > On Sun, 24 May 2020, Fred Bone wrote: > >> When I run the transaction report it points out that I need to select the >> account in "Options". > > Fred, > > Huh! I saw the link but missed the instruction above it. Mea culpa! > >> Having said which, I'm not on the latest version. What version are you >> running? > > 3.10 > > Thanks, > > Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Data conversion to QuickBooks
If you have an Android phone, it looks like Wine 5.0 can run on Android, and I bet GnuCash can run in Wine 5.0. So, "it's possible", that you could run GnuCash on an Android phone (or tablet?). However, the more time you spend accounting, the more you're going to want a better interface. I have no experience doing this, but if you try it LUK how it works Kind regards, Greg Feneis (Pixel 3) On Sun, May 24, 2020, 07:53 James Cook wrote: > On Sun, 24 May 2020 at 08:33, Jane Knichel-Aldea > wrote: > > Hi: > > Does anyone know if a gnucash file can be converted to QuickBooks online? > > Or if not, is there an online version of Gnucash? I am about to lose my > > laptop so I will need online access to my file. > > If you have an Android phone, you may be able to get some of GnuCash's > functionality from the Android app. However, I have not tried it so I > don't know what you can and can't do with it. Also, according to > https://wiki.gnucash.org/wiki/GnuCash_and_Mobile_Devices it has not > been updated since 2018 (and is a separate project from GnuCash > itself), so I would not rely on it as a long-term solution. > > James > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
As Adrien points out, the Account report is only for the currently selected account. For that report use the account View > Sort and View >Filter options to limit the report to the desired transactions. On Sun, May 24, 2020 at 12:41 PM Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > The Transaction Report can be for multiple accounts, so it doesn’t matter > what register is open at the time. > > The Account Report is for the currently viewed register. > > The two reports are quite different in their available options, however. > > Regards, > Adrien > > > On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard < > rshep...@appl-ecosys.com> wrote: > > > > On Sun, 24 May 2020, Fred Bone wrote: > > > >> When I run the transaction report it points out that I need to select > the > >> account in "Options". > > > > Fred, > > > > Huh! I saw the link but missed the instruction above it. Mea culpa! > > > >> Having said which, I'm not on the latest version. What version are you > >> running? > > > > 3.10 > > > > Thanks, > > > > Rich > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
The Transaction Report can be for multiple accounts, so it doesn’t matter what register is open at the time. The Account Report is for the currently viewed register. The two reports are quite different in their available options, however. Regards, Adrien > On May 24, 2020 w22d145, at 12:08 PM, Rich Shepard > wrote: > > On Sun, 24 May 2020, Fred Bone wrote: > >> When I run the transaction report it points out that I need to select the >> account in "Options". > > Fred, > > Huh! I saw the link but missed the instruction above it. Mea culpa! > >> Having said which, I'm not on the latest version. What version are you >> running? > > 3.10 > > Thanks, > > Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
On Sun, 24 May 2020, Fred Bone wrote: When I run the transaction report it points out that I need to select the account in "Options". Fred, Huh! I saw the link but missed the instruction above it. Mea culpa! Having said which, I'm not on the latest version. What version are you running? 3.10 Thanks, Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
On 24 May 2020 at 8:56, Rich Shepard said: > I'm missing something in my attempts to define a date range for a > transaction report on a single account. > > The account is displayed and has focus. I select Reports -> Account report > -> Options and do find where I can specify starting and ending dates. When > I try Reports -> Transactions GC tells me no account's been selected. When I run the transaction report it points out that I need to select the account in "Options". I don't think there is a mechanism for remembering which account had focus before you focused on selecting a report to run. Having said which, I'm not on the latest version. What version are you running? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Transaction report: selected date range
On Sun, 24 May 2020, Rich Shepard wrote: -> Options and do find where I can specify starting and ending dates. When I ^ NOT ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Transaction report: selected date range
I'm missing something in my attempts to define a date range for a transaction report on a single account. The account is displayed and has focus. I select Reports -> Account report -> Options and do find where I can specify starting and ending dates. When I try Reports -> Transactions GC tells me no account's been selected. What am I missing? Rich ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Data conversion to QuickBooks
On Sun, 24 May 2020 at 08:33, Jane Knichel-Aldea wrote: > Hi: > Does anyone know if a gnucash file can be converted to QuickBooks online? > Or if not, is there an online version of Gnucash? I am about to lose my > laptop so I will need online access to my file. If you have an Android phone, you may be able to get some of GnuCash's functionality from the Android app. However, I have not tried it so I don't know what you can and can't do with it. Also, according to https://wiki.gnucash.org/wiki/GnuCash_and_Mobile_Devices it has not been updated since 2018 (and is a separate project from GnuCash itself), so I would not rely on it as a long-term solution. James ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
Re: [GNC] Data conversion to QuickBooks
There is no way to operate GnuCash completely online but it can be run remotely via SSH on a remote terminal and there are ways to store your data file either in the cloud or on a USB key. You might consider going to a qualified retailer such as MicroCenter or BestBuy and ask about a low cost solution. Other users may also have suggestions. On Sun, May 24, 2020 at 3:33 AM Jane Knichel-Aldea wrote: > Hi: > Does anyone know if a gnucash file can be converted to QuickBooks online? > Or if not, is there an online version of Gnucash? I am about to lose my > laptop so I will need online access to my file. > Thank you, > Best Regards, > Jane Knichel Aldea > 201-725-3507 > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > - > 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 If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
[GNC] Data conversion to QuickBooks
Hi: Does anyone know if a gnucash file can be converted to QuickBooks online? Or if not, is there an online version of Gnucash? I am about to lose my laptop so I will need online access to my file. Thank you, Best Regards, Jane Knichel Aldea 201-725-3507 ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. - Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
