[GNC] Import csv, ofx

[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
>
> gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
>
> ________________________________
> From: gnucash-user <gnucash-user-bounces+gylemc=gmail.com at gnucash.org> on behalf of davidcousens49 at gmail.com <davidcousens49 at gmail.com>
> Sent: Tuesday, January 4, 2022 8:53 PM
> To: gnucash-user at gnucash.org <gnucash-user at 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 +0000, 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/YYYY.  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
>>
>> gmccollam at live.com<mailto:gmccollam at gyleshomes.com>           email
>> _______________________________________________
>> 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.
> _______________________________________________
> 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.