Thanks Geert. Apologies for top posting and typos. I'm in Taipei on the way
to Manilla and thence to the north end of Luzon Island. I'll file an
enhancement request once I'm back home in a couple of weeks. For those wishing
TMI, please look at www.ihsamission.comSent from my Verizon, Samsung Galaxy
smartphone
-------- Original message --------From: Geert Janssens
<geert.gnuc...@kobaltwit.be> Date: 3/18/19 18:14 (GMT+08:00) To:
gnucash-user@gnucash.org Cc: "Stephen M. Butler" <kg...@arrl.net> Subject: Re:
[GNC] CSV Import Op donderdag 14 maart 2019 17:22:48 CET schreef Stephen M.
Butler:> For some reason my Citi Visa account has lost the ability to export
file> in non-CSV formats. So, running the CSV importer on the file that had>
fields:> > Status, Date, Description, Debit, Credit, MemberName> > I mapped
Date --> Date, Description --> Description, Debit -->> Deposit, Credit -->
Withdrawl> > Noticed that there were three rows with amounts in the Credit
column and> all said values where negative!> > Ran the importer and saw that
those three rows were treated as charges. > What should I have done?
Especially since Citi put negative values in> the Credit column.> > Could I map
both columns as Deposit? Counter-intuitive but so is Citi> Cards right now!> >
--SteveUnfortunately you can't map both columns to Deposit. We may have to
improve this (as well as disambiguating the names). I couldn't find an
enhancement request for this yet in bugzilla. Feel free to add one so this
issue won't get lost.As a workaround you can preprocess your csv files to*
either merge the Debit and Credit columns (so you have one column with both
positive and negative numbers and you map this column to "Deposit")* or make
the numbers in the Credit column positive (so you have two columns with all
positive numbers and then map Debit to Deposit and Credit to Withdrawal)Geert
_______________________________________________
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.
