Re: [GNC] Finance::Quote morningstar uk (and europe?) have changed stuff

[Wm via gnucash-user]

On 24/11/2019 23:07, Richard Ullger wrote:

On Sunday, 24 November 2019 04:05:23 GMT Wm via gnucash-user wrote:


Which OS and perl version are you on?  At the moment it is looking like
gnc might need a more recent version of strawberry perl on Win but I
can't quite work out why.  If you (or anyone else) let me know your
version stuff I'll try and work it out and take it up in the dev list or
with the FQ people as appropriate.


I'm running gnucash on Arch Linux, perl version 5.30.1 https://www.perl.org/


Getting a more up to date perl on Win sorted it out.  I'll put this on 
the bug-list as it seems gnc on Win has no way of working out when it 
needs a new perl.


Thanks for your help, R

--
Wm

___
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] Gnucash doesn't load American Express QFX files

[MichaelK]

This has still not been fixed as of Gnucash v. 3.7 and American Express
download of QFX on 11/30/2019.  However the workaround is still basically
the same as described here:
https://bugs.gnucash.org/show_bug.cgi?id=797125


>From American Express website, download your credit card Activity and choose
the Quicken option, which will generate a .qfx file.  Open that text file in
an editor (Notepad or Wordpad work fine on Windows) and remove the namespace
declaration (xmlns:ns2="http://ofx.net/types/2003/04;) as follows:

Here's the file prior to changes:



http://ofx.net/types/2003/04;>
...


And here's after:




...



Save the .qfx file and import into Gnucash as normal.





--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
___
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] MySQL

[Colin Law]

Have you checked you can access the server using the same credentials,
with a different mysql client?

Colin

On Fri, 29 Nov 2019 at 18:51,  wrote:
>
> Hi
>
>
>
> I used to be able to save my Gnucash file as MySQL but recently got a new
> laptop and I now get a message "the server at URL nysql://etc/etc
> experienced an error or encountered bad or corrupt data". The data can be
> stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and I've
> reinstalled MySQL so that is now 8.0. Anyone else experienced this?
>
>
>
> Cheers
>
> Mark
>
>   _
>
> : 07786 624704 |:   m...@mgillis.uk |
> 
>
>
>
>
>
> ___
> 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] MySQL

[mark]

Thanks Geert. I tried upgrading to 3.7 and I'm sure that will add some new
features but, unfortunately, the MySQL error persists so it looks like I
can't store data in this format any more

Cheers
Mark 

: 07786 624704 |: m...@mgillis.uk | 




-Original Message-
From: Geert Janssens  
Sent: 29 November 2019 19:55
To: gnucash-user@gnucash.org
Cc: m...@mgillis.uk
Subject: Re: [GNC] MySQL

Hi,

There was a change in the format for storing dates in MySQL. I don't know
the exact details but it may well be the source of your problem.

I'm pretty sure gnucash 2.6.19 doesn't have (all of) the patches required to
work with this new format. You could try to upgrade to gnucash 2.6.21, the
last release in the 2.6 series, or if that fails, go with gnucash 3.7, the
current stable release.

Regards,

Geert

Op vrijdag 29 november 2019 19:48:57 CET schreef m...@mgillis.uk:
> Hi
> 
> 
> 
> I used to be able to save my Gnucash file as MySQL but recently got a 
> new laptop and I now get a message "the server at URL nysql://etc/etc 
> experienced an error or encountered bad or corrupt data". The data can 
> be stored as XML OK. This is GnuCash 2.6.19 running on Windows 10 and 
> I've reinstalled MySQL so that is now 8.0. Anyone else experienced this?
> 
> 
> 
> Cheers
> 
> Mark
> 
>   _
> 
> : 07786 624704 |:   m...@mgillis.uk |
> 
> 





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