[GNC] some oddities when exporting transactions to CSV
Christian Pinedo Zamalloa
chr.pinedo at gmail.com
Thu Aug 22 13:11:18 EDT 2019
Hello,
I would like to export trasactions of several accounts because I think
it would be easier to perform an analysis of transactions with
Libreoffice/Excel instead of developing a custom/new report. For
example, I am considering to export transactions of a mutual fund
account to check the capital gain/loss of every purchuase of
participations according to the FIFO law.
However, I found several oddities when I try to export the
transactions with GnuCash 3.5:
1. "Type/Price" column of a transaction is provided as "210 + 10/39"
and so when I open the CSV file with Libreoffice, it is considered a
text field not a numberic field.
2. This is not so annoying as the previous point but it is a bit
strange. When I export split transactions (not selecting "simple"
export checkbox in the export transaction menu), the fields of the
transaction are only filled for the first split and not filled for the
rest of splits of the same transaction. This is a bit strange because
in a spreedsheet it is better to repeat this transaction fields for
every split (row) so that we can filter the splits of one transaction
more easily.
Regards!
--
Christian Pinedo Zamalloa (zako)
PGP keyID: 0xdb577d4ee6ffbd55
PGP Fgprt: A895 7C11 84F6 30B4 4938 32A4 9306 DFD0 CDE4 B542
More information about the gnucash-user
mailing list