[GNC] Importing csv transactions

[Geert Janssens]

In addition to the other suggestions, does your csv file contain a line with 
column titles ? If so, you may have to configure the importer to skip that 
line.

Regards,

Geert

Op dinsdag 11 september 2018 02:10:40 CEST schreef David Carlson:
> Paul,
> 
> Actually, during the CSV format you can scroll down the data that you are
> about to import to see if there are any lines that will prevent the
> import.  Just scroll down the date column to see if there are any dates
> that do not match your selected date format.  From experience I can tell
> you that it is very easy to make a mistake in this column, as, at least in
> the release 2.6.xx family of GnuCash releases, the default did not match
> common usage in the US.
> 
> David C
> 
> On Mon, Sep 10, 2018 at 5:32 PM GTI .H <gti9070h at gmail.com> wrote:
> > Probably some date (maybe three) in your CSV file is in the wrong format.
> > Open your CSV file in an editor and check the format of the dates.
> > 
> > Regards
> > GTI
> > 
> > Em seg, 10 de set de 2018 às 18:19, Paul Konnersman <konnersman at gmail.com>
> > 
> > escreveu:
> > > I'm new to Gnucash and trying to get set up. I successfully imported a
> > > couple of years worth of transactions into one account a few months ago
> > > when I was evaluating Gnucash. Now I'm trying to import more
> > > transactions
> > > into that same account without success.
> > > 
> > > My process:
> > > 1) Menu Bar> File> Input> Import Transactions from CSV
> > > 2) Navigate to CSV file to be imported
> > > 3) Set Date format to y-m-d
> > > 4) Set currency format to "period"
> > > 5) Map columns in imported file to columns in Gnucash
> > > 
> > >    1. Date -> Date
> > >    2. Num -> Num
> > >    3. Description -> Action
> > >    4. Account -> Transfer
> > >    5. Notes -> C
> > >    6. Deposit -> Debit Amount
> > >    7. None -> Credit Amount
> > >    8. None -> Balance
> > > 
> > > 6) I get a notice repeated three times that reads, "Date Column could
> > > not
> > > be understood."
> > > 
> > > Any suggestions will be appreciated.
> > > 
> > > Paul
> > > 
> > > --
> > > *Paul M. Konnersman*
> > > *konnersman at gmail.com <konnersman at gmail.com>*
> > > *781-639-0616*
> > > _______________________________________________
> > > gnucash-user mailing list
> > > gnucash-user at gnucash.org
> > > To update your subscription preferences or to unsubscribe:
> > > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > > If you are using Nabble or Gmane, please see
> > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > -----
> > > Please remember to CC this list on all your replies.
> > > You can do this by using Reply-To-List or Reply-All.
> > 
> > --
> > Regards
> > GTI
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > If you are using Nabble or Gmane, please see
> > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information. -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.