CSV Import

GT-I9070 H gti9070h at gmail.com
Fri Apr 21 01:09:31 EDT 2017


One more critical info:

In gnucash-2.6.99-2017-04-18-git-b2b32e2+-setup.exe if just opening and
saving you destroy the data file.
When we tried to reopen it, we received the message "There was an error
parsing the file".

Thus, there is no way to finalize the importer's test.

Regards
GTI

2017-04-20 18:28 GMT-04:00 GT-I9070 H <gti9070h at gmail.com>:

> I made an import of a 304KB csv file exported by GnuCash and these are my
> first remarks:
>
> * Sometimes the importer/GnuCash either froze or was long parsing (eg.
> When to change the header), in doubt I killed the process and started
> again. A progress bar would be welcome!
>
> * In the csv reconciled column I have the letters "n", "a" and "p" and
> only "n" was understood, I had to ignore this column in order not to lose
> transactions.
>
> * There are doubts about whether to select the "account" column header for
> csv's  "Account Name" or "Account Full Name".
>
> * After import, some values had decimal changes and a new line with the
> blank comment came up, possibly to balance the transaction.
> I do not think this was generated by the importer.
> When we register a multi-currency transaction with a single rate and with
> splits, GnuCash record rates with small differences for each split and when
> we export a csv these different rates are exported and reflect in the
> values (not in the default currency) when imported.
>
> Suggestion:
> It would be nice if we could edit the csv on the importer to make minor
> corrections!
>
> From my point of view, the importer sometimes showed to be cumbersome
> (possibly parsing), but it works well!
>
> This was my first test, I'll do others.
>
> Regards
> GTI
>
>
> 2017-04-15 5:03 GMT-04:00 Geert Janssens <geert.gnucash at kobaltwit.be>:
>
>> On zaterdag 1 april 2017 17:45:12 CEST GT-I9070 H wrote:
>> > Ok, Alright Geert!
>> >
>> > I think I can live another week without the new importer  : )
>> > Please let us know when this is fixed.
>> >
>> > Thanks
>> > GTI
>> >
>> An update - John was so kind to fix the dependency issues for the windows
>> nightly build yesterday and the most recent nightly build installs and
>> runs
>> fine again:
>> http://code.gnucash.org/builds/win32/master/gnucash-2.6.99-
>> 2017-04-14-git-c7226dd+5-setup.exe
>>
>> Unfortunately in my first test of the new importer I have run into a
>> windows-
>> only bug: the column headers aren't clickable and hence there is no way
>> (yet)
>> to specify the column types. I'll need to get that fixed first.
>>
>> On the other hand the built-in preset to import data that was exported by
>> gnucash does work fine. Which suggests the other parts of the importer
>> are in
>> pretty good shape.
>>
>> A little more patience will be needed... :)
>>
>> Geert
>>
>
>


More information about the gnucash-user mailing list