CSV Import

[GT-I9070 H]

Hi Steve,

Why do not you try to use XLSM2QIF?

Https://wiki.gnucash.org/wiki/Published_tools

You can import your CSV data into XLSM2QIF, work the data as you want with
the power of MS Excel and export to QIF and then do a QIF import into
GnuCash.

XLSM2QIF has a powerful QIF exporter and the QIF importer of GNUCash works
well.

That would solve your problem now.

Good luck!
GTI

2017-04-01 20:50 GMT-04:00 Steve Isenberg via gnucash-user <
gnucash-user at gnucash.org>:

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