Re: [GNC-dev] CSV Import Format

2019-03-11 Thread Wm via gnucash-devel
On 01/03/2019 22:42, Geert Janssens wrote: Yes. The matcher should only be needed in the even more restricted case that no transfer account is set. In my experience the matcher is OK if you ignore it and understand the tx. You should just import it and fix it by hand, presuming the

Re: [GNC-dev] CSV Import Format

2019-03-11 Thread Wm via gnucash-devel
On 01/03/2019 22:26, David Cousens wrote: Geert, I can feed you what I've done so far with the multiline, double currency transaction. My apologies for taking so long. My wife is a poet and I'm the publishing company these days. She handed me the latest book of poetry to edit and typeset for

Re: [GNC-dev] CSV Import Format

2019-03-11 Thread Wm via gnucash-devel
On 01/03/2019 11:39, Geert Janssens wrote: I am aware multi-currency import is currently flawed. Having a detailed overview of what fails/what extra is needed will help a lot in setting this straight. Meneer, the import and multi currency are like the boy with his thumb in a dyke being asked

Re: [GNC-dev] CSV Import Format

2019-03-03 Thread cicko
Thanks, David. I can confirm that a multi-currency transfer uses the same amount on both sides. I did not check the Trading Accounts but assume that works just fine. Reading your document gave me a few ideas, however. I might try sending both Deposit and Withdrawal columns together. Or

Re: [GNC-dev] CSV Import Format

2019-03-03 Thread cicko
A brief update from my side, as well. I've spent a few hours adding code to my export library and CSV generator. At first, I've exported the tranfers and that seemed to have gone well. However, as in my test file I had at least four different currencies, I switched back to simple transactions.

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread David Cousens
No problem Geert. I'm the one pressuring myself David - David Cousens -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html ___ gnucash-devel mailing list gnucash-devel@gnucash.org

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread Geert Janssens
David, It was not intention to pressure you... Especially as I don't have much time for development lately (like you plenty things to do in that other part of my life). So take your time . I'm thankful you're doing the analysis :) Op vrijdag 1 maart 2019 23:26:50 CET schreef David Cousens: >

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread David Cousens
Geert, I can feed you what I've done so far with the multiline, double currency transaction. My apologies for taking so long. My wife is a poet and I'm the publishing company these days. She handed me the latest book of poetry to edit and typeset for printing along with a manuscript from another

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread Geert Janssens
Op vrijdag 1 maart 2019 12:26:20 CET schreef cicko: > Thanks a lot for this useful info, David. I'll keep in mind the possible > issues with transfers, multiple accounts, and currencies during this > exercise. Once I am happy with the code, I'll probably add my findings to > the wiki. Please do.

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread cicko
Thanks a lot for this useful info, David. I'll keep in mind the possible issues with transfers, multiple accounts, and currencies during this exercise. Once I am happy with the code, I'll probably add my findings to the wiki. In the meantime I'll be on the lookout for the results you get with the

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread David Cousens
Alen, The new version of the CSV importer is not documented very well yet. The multiline capability is problematical, definitely where transactions with accounts in two or more currencies are involved. It basically doesn't work at the moment. I'm exploring that and mid writing a report to guide

Re: [GNC-dev] CSV Import Format

2019-03-01 Thread cicko
Oh, I wrote too soon. Only now, that I have some .csv output, do I see the new screen for mapping the CSV fields. Wow, this should be enough to create any type of custom mapping so the CSV field order doesn't really matter as long as all the useful values are there. Cheers for that rewrite!

[GNC-dev] CSV Import Format

2019-03-01 Thread cicko
Hi, everyone, Could you recommend a place that contains the current description of the optimal CSV format for smooth import into GnuCash? Or perhaps just a few tips? So far I've been importing .qif files from the Android app and I was wondering if importing .csv files would be easier with the