Re: [GNC-dev] CSV Import Format

[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
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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:
> One thing I am not clear on is whether or not the single line mode is meant
> to be able to import a two split transaction when the split target
> currencies are in the same currency without relying on the matcher. I am
> presuming it is.

Yes. The matcher should only be needed in the even more restricted case that 
no transfer account is set.

Regards,

Geert


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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 friend 
just after I started on testing the importer.

I made it back to the importer the day before yesterday. I have presumed the
multiline import is working for accounts in the same currency but haven't
actually tested it so far. It would have been logical to do that first.  I
have also ignored trading accounts so far either. I am counting on that
being largely dealt with if the multicurrency transactions work.

The results so far are attached. 
ExportImportCurrencyTransaction.odt

  

I will continue and check out a multiline import to accounts with the same
currency with 2 or more splits.
 
One thing I am not clear on is whether or not the single line mode is meant
to be able to import a two split transaction when the split target
currencies are in the same currency without relying on the matcher. I am
presuming it is.

My secondary aim is to learn enough to be able to put some documentation
together for the importer once I have some idea of what aspects are working. 

Unfortunately I will have another break as I am off to Singapore in 2 weeks.
I will keep appending to the document and send you updates.

Cheers

David



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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.

> In the meantime I'll be on the lookout for the results you get
> with the import testing.

So am I !

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.

Regards,

Geert


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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 import testing.
Cheers



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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 bug
fixing at the moment. 

I havent checked out multiline import for transactions where the splits are
to accounts in the same currency yet. That's my next job.

If your data is all imported to a single account, set the account to be
imported to in the dialog, rather than each CSV record you basically only
need a date , a description, the transfer account, the amount (and set
whether it is a deposit or withdrawal) and the single line mode works OK. I
import my Paypal account data with this sort of setup with minimal problems.
If the account specified in the record is the account to be imported to I
have not yet tested out setting a transfer account in a single line record.
You can always not set it and rely on the matcher to assign accounts but it
will require training. I.e. hint you need to import small batches of data
first.

One trap is the locale setting doesn't necessarily set up the date format
correctly so it pays to select that explicitly in the date format field.  If
the import data has column headers set the skip to 1.

David Cousens 



-
David Cousens
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] CSV Import Format

[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!



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

[GNC-dev] CSV Import Format

[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 rewritten import
code.
I'm writing some scripts/libraries in Python to pull the data from the
sqlite database and write to .csv file(s), ready for import to GnuCash. 

That way I should be able to move the transactions from the phone, which
synchronizes the database to the cloud, to the GnuCash book. 



--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-Dev-f1435356.html
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel