subject:"Re\: \[GNC\] Import csv, ofx"

Re: [GNC] Import csv, ofx

2022-01-05 Thread Clint Chaplin

I would be careful with Urban Dictionary. It's unfiltered, which means both
that it's uncensored, and it gets a lot of deliberate fake entries.

On Wed, Jan 5, 2022 at 5:17 AM Dustin Henning  wrote:

> AFAIK ~ as far as I know
>
> While that is a common acronym online, FWIW, I've found I can often
> untangle less common ones using urbandictionary.com...
>
> https://www.urbandictionary.com/define.php?term=FWIW
>
> On 1/5/22 2:40 AM, Gyle McCollam wrote:
> > Thank you for the prompt response.  A clarification please, what does
> "AFAIK" stand for and I also use Libre Office these days, after using Open
> Office and Quattro Pro for years, never did use Excel.
> >
> >
> > Thank You,
> > Gyle McCollam
> >
> > Gyle McCollam
> >
> > 609.680.2326 Mobile
> >
> > gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> >
> > 
> > From: gnucash-user 
> on behalf of davidcousen...@gmail.com 
> > Sent: Tuesday, January 4, 2022 8:53 PM
> > To: gnucash-user@gnucash.org 
> > Subject: Re: [GNC] Import csv, ofx
> >
> > Gyle,
> > Export it as Excel, load it up in Excel and export it from there as CSV.
> GnuCash
> > has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days
> and it
> > certainly works with LO).
> >
> > You should also be able to set the date format in the CSV import dialog.
> It will
> > likely default to the format specified for your locale but you can
> override that
> > and store the format settings for future use.
> >
> > David Cousens
> >
> > On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:
> >> I have been having a great experience importing ofx files for my bank
> accounts
> >> and credit cards.  However, when I tried to export from Discover Card,
> the
> >> only options were Excel or csv.  I didn't see that Gnucash imported
> Excel so I
> >> used csv.  I had absolutely no luck importing the csv file into
> Gnucash.  I
> >> kept getting an error message that the date was out of range (1-31).
> The date
> >> format used by Discover is MM/DD/.  Is the date range the import
> function
> >> uses in a different format, therefore causing my issue?
> >>
> >>
> >> Thank You,
> >> Gyle McCollam
> >>
> >> Gyle McCollam
> >>
> >> 609.680.2326 Mobile
> >>
> >> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> >> ___
> >> 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.
> ___
> 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.
>


-- 
Clint (JOATMON) Chaplin
___
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] Import csv, ofx

2022-01-05 Thread Dustin Henning


AFAIK ~ as far as I know

While that is a common acronym online, FWIW, I've found I can often 
untangle less common ones using urbandictionary.com...


https://www.urbandictionary.com/define.php?term=FWIW

On 1/5/22 2:40 AM, Gyle McCollam wrote:

Thank you for the prompt response.  A clarification please, what does "AFAIK" 
stand for and I also use Libre Office these days, after using Open Office and Quattro Pro 
for years, never did use Excel.


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: gnucash-user  on behalf of 
davidcousen...@gmail.com 
Sent: Tuesday, January 4, 2022 8:53 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Import csv, ofx

Gyle,
Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash
has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it
certainly works with LO).

You should also be able to set the date format in the CSV import dialog. It will
likely default to the format specified for your locale but you can override that
and store the format settings for future use.

David Cousens

On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:

I have been having a great experience importing ofx files for my bank accounts
and credit cards.  However, when I tried to export from Discover Card, the
only options were Excel or csv.  I didn't see that Gnucash imported Excel so I
used csv.  I had absolutely no luck importing the csv file into Gnucash.  I
kept getting an error message that the date was out of range (1-31).  The date
format used by Discover is MM/DD/.  Is the date range the import function
uses in a different format, therefore causing my issue?


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
___
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.

___
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] Import csv, ofx

2022-01-05 Thread Gyle McCollam

Open my eyes and I will see.  Missed that setting in Miscellaneous.  Imported 
no problem now!


Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email


From: david whiting 
Sent: Wednesday, January 5, 2022 3:09 AM
To: Gyle McCollam 
Subject: Re: [GNC] Import csv, ofx

Hi Gyle,

If I have understood correctly, you just need to select the
appropriate date format in the Miscellaneous settings during the
import. So, after selecting your csv file to import (there should be
no need to go via libreoffice) the next page is "Import Preview" which
is where you select which columns map to date, description, etc. and
at the top, on the right, you will see "Miscellaneous settings", one
of which is "Date Format".

David

On Wed, 5 Jan 2022 at 01:01, Gyle McCollam  wrote:
>
> I have been having a great experience importing ofx files for my bank 
> accounts and credit cards.  However, when I tried to export from Discover 
> Card, the only options were Excel or csv.  I didn't see that Gnucash imported 
> Excel so I used csv.  I had absolutely no luck importing the csv file into 
> Gnucash.  I kept getting an error message that the date was out of range 
> (1-31).  The date format used by Discover is MM/DD/.  Is the date range 
> the import function uses in a different format, therefore causing my issue?
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> ___
> 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.



--
David Whiting
___
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] Import csv, ofx

2022-01-04 Thread Gyle McCollam

Thank you for the prompt response.  A clarification please, what does "AFAIK" 
stand for and I also use Libre Office these days, after using Open Office and 
Quattro Pro for years, never did use Excel.

Thank You,
Gyle McCollam

Gyle McCollam

609.680.2326 Mobile

gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email

From: gnucash-user  on 
behalf of davidcousen...@gmail.com 
Sent: Tuesday, January 4, 2022 8:53 PM
To: gnucash-user@gnucash.org 
Subject: Re: [GNC] Import csv, ofx

Gyle,
Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash
has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it
certainly works with LO).

You should also be able to set the date format in the CSV import dialog. It will
likely default to the format specified for your locale but you can override that
and store the format settings for future use.

David Cousens

On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:
> I have been having a great experience importing ofx files for my bank accounts
> and credit cards.  However, when I tried to export from Discover Card, the
> only options were Excel or csv.  I didn't see that Gnucash imported Excel so I
> used csv.  I had absolutely no luck importing the csv file into Gnucash.  I
> kept getting an error message that the date was out of range (1-31).  The date
> format used by Discover is MM/DD/.  Is the date range the import function
> uses in a different format, therefore causing my issue?
>
>
> Thank You,
> Gyle McCollam
>
> Gyle McCollam
>
> 609.680.2326 Mobile
>
> gmccol...@live.com<mailto:gmccol...@gyleshomes.com>   email
> ___
> 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] Import csv, ofx

2022-01-04 Thread davidcousens49

Gyle,
Export it as Excel, load it up in Excel and export it from there as CSV. GnuCash
has always read Excel's CSV exports AFAIK (I use Libre Ofiice these days and it
certainly works with LO).

You should also be able to set the date format in the CSV import dialog. It will
likely default to the format specified for your locale but you can override that
and store the format settings for future use.

David Cousens

On Wed, 2022-01-05 at 01:01 +, Gyle McCollam wrote:
> I have been having a great experience importing ofx files for my bank accounts
> and credit cards.  However, when I tried to export from Discover Card, the
> only options were Excel or csv.  I didn't see that Gnucash imported Excel so I
> used csv.  I had absolutely no luck importing the csv file into Gnucash.  I
> kept getting an error message that the date was out of range (1-31).  The date
> format used by Discover is MM/DD/.  Is the date range the import function
> uses in a different format, therefore causing my issue?
> 
> 
> Thank You,
> Gyle McCollam
> 
> Gyle McCollam
> 
> 609.680.2326 Mobile
> 
> gmccol...@live.com   email
> ___
> 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] Import csv, ofx

Re: [GNC] Import csv, ofx

Re: [GNC] Import csv, ofx

Re: [GNC] Import csv, ofx

Re: [GNC] Import csv, ofx

5 matches

Site Navigation

Mail list logo

Footer information