[GNC] Online Banking Upgrade hosed Name and Memo field

[Alan Marsh]

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 <alan at marsh.ac> 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 <NAME> and <MEMO> 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 <jralls at ceridwen.us> wrote:>>>> 
>>>> 
>>>> > On Oct 29, 2018, at 5:38 PM, Alan Marsh <alan at marsh.ac> wrote:
>>>> > 
>>>> > NAME and MEMO were identical in old xml (either ofx or qfx)
>>>> > <NAME>POS PURCH - KROGER FUEL CTR  554
>>>> > <MEMO>POS PURCH - KROGER FUEL CTR  5542               IL DECATUR>>>> > 4615 E. US ROUTE 36US
>>>> > After online banking upgrade it now gives me
>>>> > 
>>>> > <NAME>POS PURCH
>>>> > <MEMO>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 at 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.
>>