CSV Import

[Nigel Stapley]

This may be asking the blindingly obvious but did you set the column
headings correctly? You don't mention them in your list of actions. This
might answer your query about the column formats?

Nigel

ps hope this is the correct way to post reply!

On 2 Apr 2017 01:55, "Steve Isenberg via gnucash-user" <
gnucash-user at gnucash.org> wrote:

No way, there is no way the CSV import works!

To start I removed the header row as it wasn't really needed.

The original date format was the typical US, m/d/yyyy. I changed it to
d-m-yyyy, replacing the forward slash with a hyphen. It failed.

I changed the date to yyyy-m-d, and it failed.

This is the test data that I tried to import:

    2017-2-1,Pamela H,18
    2017-2-1,John L,18

Preview Settings (screen)
Start import on row 1 and stop on row 2
Encoding: Unicode (UTF-8)
Data type: separated
Separators: comma
Date Format: y-m-d
Currency Format: locale
Step over Account Page if Setup: checked

Click the Forward button

Account Selection (screen)

ERROR:
There are problems with the import settings!
The date format could be wrong or there are not enough columns set...

Every time, it fails at the same place and with the same message,
every-single-time.

I am running Windows 7.

I don't want to do data entry as I have data from multiple sources that I
want to import.

What columns are supposed to be in the CSV file?
What are the formats of each column?
I need a work around or a fix to move forward.
Thanks
      From: Geert Janssens <geert.gnucash at kobaltwit.be>
 To: Steve Isenberg <brrg58 at yahoo.com>
Cc: "gnucash-user at gnucash.org" <gnucash-user at gnucash.org>
 Sent: Saturday, April 1, 2017 4:55 AM
 Subject: Re: CSV Import

On vrijdag 31 maart 2017 22:24:20 CEST Steve Isenberg wrote:
> If the current CSV import has a simple use case then why does it always
> error and never import? The error screen is no help whatsoever in
> determining the error.
> I created a CSV with columns as displayed on the transaction input screen.
> Does not work. I stripped the CSV down to the columns described below.
Does
> not work. What columns are supposed to be in the CSV file?
> What are the formats of each column?
> This is an example of the data based on the columns mentioned below:
> Date,Description,Income
> 1/1/2017,Garri Ann Hearn,18
> 1/1/2017,Garri Ann Hearn,11
> 1/1/2017,Pamela Healy,18
> 1/3/2017,Robert Marten,100
> 1/4/2017,john landi,7
> The CSV import fails consistently without any real clue as to the problem.
> How is this data supposed to be formatted? Searching the archives is not
> helpful. There are too many unrelated results in the archive. This is a
> straight-forward problem and if the CSV is simple then it should not be
> difficult to figure this out. Appreciate the help.Steve
>

Hi Steve,

I have just tried your sample data and got to the last page of the importer
with no issues (the page where you can assign accounts to each of the
transactions). My first attempt failed because I didn't select the proper
date
format. Setting it to "d-m-y" got me through with no problems.

At which point does it fail for you and how ?

Regards,

Geert



_______________________________________________
gnucash-user mailing list
gnucash-user at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.