Re: [GNC] Importing csv transactions
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 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 > > > > 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* > > > *konners...@gmail.com * > > > *781-639-0616* > > > ___ > > > gnucash-user mailing list > > > gnucash-user@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@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@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@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.
Re: [GNC] Importing csv transactions
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 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 > 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* > > *konners...@gmail.com * > > *781-639-0616* > > ___ > > gnucash-user mailing list > > gnucash-user@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@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@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.
Re: [GNC] Importing csv transactions
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 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* > *konners...@gmail.com * > *781-639-0616* > ___ > gnucash-user mailing list > gnucash-user@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@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.
[GNC] Importing csv transactions
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* *konners...@gmail.com * *781-639-0616* ___ gnucash-user mailing list gnucash-user@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.