Re: [GNC] Online Banking Upgrade hosed Name and Memo field
I exported to a CSV. It look like the "Import Transactions from CSV" will allow me to pick which column is "Notes" vs "Description". Are there any other gotchas with the process that I should know about? Is there any documentation on this feature? Thanks! On Tue, Oct 30, 2018, at 6:46 PM, David Carlson wrote: > Before you go down that path see if any others on this maillist have > had the same problem with release 3.3. I am still on 2.6.15 or 17, so > I have not seen the revised importers.> > David C > > On Tue, Oct 30, 2018 at 7:31 PM Alan Marsh wrote: >> __ >> The "new and improved" online banking allows me to export to .csv, >> .ofx, .qfx, and .qbo>> >> I am using the File > Import > Import OFX/QFX menu option. >> >> Even in the CSV format, the Description and Memo fields show the same >> as and in both .ofx and .qfx>> >> I'm thinking I'll have to pre-process the file as John mentions. >> >> I'm very out of date on programming stuff and only dabbled with >> Python once... stuck in a corporate Microsoft world.>> >> Any suggestions on what to use and maybe a sample script from someone >> else forced to do this sort of thing. Last time this happened, I >> changed credit unions. Besides this one problem, I'm pretty happy at >> this one.>> >> Thanks! >> >> On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote: >>> What do you mean by online banking.? Are you actually using the OFX >>> import?>>> >>> If so, just do not use the option to update the transaction when >>> matching. Then Gnucash leaves the description unchanged.>>> >>> David C >>> >>> On Mon, Oct 29, 2018, 7:49 PM John Ralls wrote:>>>> >>>> >>>> > On Oct 29, 2018, at 5:38 PM, Alan Marsh wrote: >>>> > >>>> > NAME and MEMO were identical in old xml (either ofx or qfx) >>>> > POS PURCH - KROGER FUEL CTR 554 >>>> > POS PURCH - KROGER FUEL CTR 5542 IL DECATUR>>>> > >>>> > 4615 E. US ROUTE 36US >>>> > After online banking upgrade it now gives me >>>> > >>>> > POS PURCH >>>> > KROGER FUEL CTR 5542 IL DECATUR 4615 >>>> > E. US>>>> > ROUTE 36US >>>> > Which means all transactions in gnucash say just POS PURCH for >>>> > the>>>> > Description and you have to expand each one to see the actual >>>> > memo entry>>>> > to know who was paid. >>>> > Any idea how to fix this? >>>> >>>> Does your bank offer QIF export? Maybe they didn't bork that. >>>> Otherwise you're stuck with pre-processing the file with the >>>> scripting language of your choice.>>>> >>>> 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 >>>> 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] Online Banking Upgrade hosed Name and Memo field
The "new and improved" online banking allows me to export to .csv, .ofx, .qfx, and .qbo I am using the File > Import > Import OFX/QFX menu option. Even in the CSV format, the Description and Memo fields show the same as and in both .ofx and .qfx I'm thinking I'll have to pre-process the file as John mentions. I'm very out of date on programming stuff and only dabbled with Python once... stuck in a corporate Microsoft world. Any suggestions on what to use and maybe a sample script from someone else forced to do this sort of thing. Last time this happened, I changed credit unions. Besides this one problem, I'm pretty happy at this one. Thanks! On Mon, Oct 29, 2018, at 11:41 PM, David Carlson wrote: > What do you mean by online banking.? Are you actually using the > OFX import?> > If so, just do not use the option to update the transaction when > matching. Then Gnucash leaves the description unchanged.> > David C > > On Mon, Oct 29, 2018, 7:49 PM John Ralls wrote: >> >> >> > On Oct 29, 2018, at 5:38 PM, Alan Marsh wrote: >> > >> > NAME and MEMO were identical in old xml (either ofx or qfx) >> > POS PURCH - KROGER FUEL CTR 554 >> > POS PURCH - KROGER FUEL CTR 5542 IL DECATUR >> > 4615 E. US ROUTE 36US >> > After online banking upgrade it now gives me >> > >> > POS PURCH >> > KROGER FUEL CTR 5542 IL DECATUR 4615 >> > E. US>> > ROUTE 36US >> > Which means all transactions in gnucash say just POS PURCH for the>> > >> Description and you have to expand each one to see the actual memo >> > entry>> > to know who was paid. >> > Any idea how to fix this? >> >> Does your bank offer QIF export? Maybe they didn't bork that. >> Otherwise you're stuck with pre-processing the file with the >> scripting language of your choice.>> >> 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 >> 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.
[GNC] Online Banking Upgrade hosed Name and Memo field
NAME and MEMO were identical in old xml (either ofx or qfx) POS PURCH - KROGER FUEL CTR 554 POS PURCH - KROGER FUEL CTR 5542 IL DECATUR 4615 E. US ROUTE 36US After online banking upgrade it now gives me POS PURCH KROGER FUEL CTR 5542 IL DECATUR 4615 E. US ROUTE 36US Which means all transactions in gnucash say just POS PURCH for the Description and you have to expand each one to see the actual memo entry to know who was paid. Any idea how to fix this? ___ 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.