Re: [GNC] OFX setup

2020-07-04 Thread John Ralls
and 6.2.1. Regards, John Ralls > On Jul 4, 2020, at 5:46 AM, Fleur Dragan wrote: > > Ah! My mistake! I had 3.10 and was checking against that. > > I just tried to set up an OFX account with 4.0, which is as you said 6.2.1, > but still am having no luck. > > So whe

Re: [GNC] Keep the Reconciliation Feature (was Re: Gnucash 4.0 Paper Clip and Link glyphs for file/web transaction associations)

2020-07-04 Thread John Ralls
could, of course, keep one's GnuCash book by downloading transactions from the bank. In that case you're not keeping a separate book and there's no point to reconciliation. But why bother with GnuCash if you're going to do that? Regards, John Ralls > On Jul 4, 2020

Re: [GNC] Gnucash-User

2020-07-04 Thread John Ralls
<=== one of these price: <=/ timezone: <=== optional Regards, John Ralls > On Jul 3, 2020, at 11:03 PM, Adrian Holbrook wrote: > > I have been trying to post on the forum but for some reason am no longer > allowed to post. I have

Re: [GNC] GunCash 4.0 Paper Clip and Link glyphs for file/web transaction associations

2020-07-03 Thread John Ralls
hat GtkTreeView. You might remember Register2, Bob Fewell's attempt to rewrite it to use GtkTreeView for GnuCash 2.6. He wasn't able to make it stable enough and set it aside. It's still in the codebase: Run gnucash --extra and the Extra menu has "Open Account with Register2&

Re: [GNC] Accessing online currency rates

2020-07-02 Thread John Ralls
Did you remember to run Install Online Price Retrieval for GnuCash from the GnuCash group in the Start Menu? Regards, John Ralls > On Jul 2, 2020, at 4:29 AM, Samantha Payn > wrote: > > I have had to change computers and have installed my existing Gnucash > set-up (i

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls
he important point for you to understand is what made it an EUR transaction: It was that you created it in an EUR register or if you used the Transfer Dialog it was that of the From Account (the one on the left unless you're have "use formal accounting labels" in which

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls
arge. > > Regards, > Adrien > > > > >> On Jul 2, 2020 w27d184, at 11:34 AM, John Ralls wrote: >> >> >> >>> On Jul 2, 2020, at 9:08 AM, Antonio Roberts >>> wrote: >>> >>> I'm in the UK doing most of my account

Re: [GNC] Split transaction on invoices in foreign currencies

2020-07-02 Thread John Ralls
action currency that's used to balance the transaction. That currency is determined by the account from which the transaction is created, and in this case it's EUR, so GnuCash needs to know the value in EUR of the bank charge. Just use the same exc

Re: [GNC] Custom invoices don't work after upgrade

2020-07-02 Thread John Ralls
release explain the changes and since 3.0 functions that are removed are first deprecated so that they emit warnings, but you have to check the trace file to see the warnings. If you don't want to keep up with GnuCash development you have two choices: Never upgrade or don't use custom

Re: [GNC] Error retrieving price quotes

2020-07-01 Thread John Ralls
sh. The cause may be immediately apparent, like an invalid source. If not, report back with the security and source that fails. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsu

Re: [GNC] Open Files Error with Chinese Path Name in V4.0

2020-06-29 Thread John Ralls
By File Explorer do you mean Windows Explorer or the File Chooser that you use from File>Open? Which ever it is, does the other way work? Regards, John Ralls > On Jun 29, 2020, at 5:25 PM, Chen Thomas wrote: > > Sorry, 3.11 instead of 3.9 mentioned below. > > ---

Re: [GNC] Gnucash 4.0 not available via Flathub

2020-06-29 Thread John Ralls
Thanks, the merge from beta didn't pick up that it needs the swig module. I've fixed that and started a new build. Regards, John Ralls > On Jun 29, 2020, at 12:48 PM, Guillermo Lopez > wrote: > > I am trying to try/use Gnucash 4.0 using Flatpak build. However, the mo

Re: [GNC] 4.0.1 gnucash-cli seg faults on macOS Catalina

2020-06-29 Thread John Ralls
uri) > 0' failed * 15:32:59 INFO [QofDbiBackendProvider::type_check] doesn't exist (errno=14) -> DBI * 15:32:59 ERROR gnc_uri_get_components: assertion 'uri != NULL && strlen (uri) > 0' failed Segmentation fault: 11 Please do file a bug report and attach

Re: [GNC] 4.0.1 attachments symbol

2020-06-29 Thread John Ralls
That change is indeed in 4.0, just checked that it works. Regards, John Ralls > On Jun 29, 2020, at 12:40 PM, Adrien Monteleone > wrote: > > I have a thread on the -devel list about this. > > There is an emoji visibility issue with GTK integration on MacOS. (the > pap

Re: [GNC] 4.0 and Change in Column Widths

2020-06-29 Thread John Ralls
Windows menu) and left the account registers as-is. We hope to sort out the issues with general registers and reintroduce it there in a few months. Unfortunately I didn't get the release notes adjusted correctly. I've since fixed them at www.gnucash.org and GitHub. Regards, John R

Re: [GNC] Gnucash 4.0 doesn't launch on MacOS X 10.15.4

2020-06-29 Thread John Ralls
e and that caused a complete failure for one user last week, though it doesn't seem to affect most users. Regards, John Ralls > On Jun 29, 2020, at 9:56 AM, w...@theprescotts.com wrote: > > Ditto on Mac OS 10.15.5. Opened without issues. > The first time it asked for the standard

Re: [GNC] V4 installation messages/cautions

2020-06-29 Thread John Ralls
Thanks, we know about that. We've briefly discussed setting up code signing on Windows but haven't done anything about it as getting a suitable certificate is more involved than it is with Apple. Regards, John Ralls > On Jun 29, 2020, at 7:36 AM, Barry Dewhurst wrote: > >

[GNC] GnuCash 4.0 Released

2020-06-28 Thread John Ralls
The GnuCash development team announces GnuCash 4.0 Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is now C++17, requires gcc 8.0 or clang 6.0. • Cmake 3.10

Re: [GNC] error message with finance::quote gnc-path-check + problems with retrieving quotes for 2 symbols.

2020-06-22 Thread John Ralls
gnc-fq-helper, and gnc-fq-update. No gnc-path-check. What same answer does gnc-fq-dump give, that the symbol isn't found? What are the two symbols? Have you tried price source tiaacref? Regards, John Ralls ___ gnucash-user mailing list gnucash-us

[GNC] GnuCash 3.906 Released

2020-06-21 Thread John Ralls
The GnuCash development team announces GnuCash 3.906, the fifth testing release for what will soon be GnuCash 4.0. This is the release-candidate: Barring any serious bugs it's what we'll release as 4.0 next weekend. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.0

Re: [GNC] Question marks instead of currency in reports

2020-06-19 Thread John Ralls
Hard to tell for reports, that would be up to webkit and while I found where it's set in the webkit source I don't see any default value there. Gtk's default on MacOS is SystemDefaultFont (San Francisco on El Cap and later) 12pt. Regards, John Ralls > On Jun 19, 2020, at 4:4

Re: [GNC] Price Database

2020-06-17 Thread John Ralls
$ bin/gnc-fq-dump currency HKD USD 1 HKD = 0.12903193 USD Regards, John Ralls > On Jun 17, 2020, at 11:15 AM, Les wrote: > > Thanks for your reply. However, the problem is I have a Hong Kong bank > account that has multiple currencies. The default is HKD, but I need Price &

[GNC] GnuCash 3.905 Released

2020-06-14 Thread John Ralls
The GnuCash development team announces GnuCash 3.905, the fourth testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is

Re: [GNC] Can Finance::Quote look up bond prices by CUSIP?

2020-06-08 Thread John Ralls
sults by maturity, and binary-searching until I found it. They give F4955773 as the symbol, FWIW. Your best option seems to be to write a F::Q scraper module for empirasign.com. Regards, John Ralls > On Jun 8, 2020, at 11:40 AM, peterb wrote: > > Following up on this: I definitely

Re: [GNC] manuel en Français

2020-06-07 Thread John Ralls
Si vous voulez de l'aide en français, il vaut mieux demander sur la liste de diffusion française: https://lists.gnucash.org/mailman/listinfo/gnucash-fr. Cette liste est en anglais. Regards, John Ralls > On Jun 7, 2020, at 9:13 AM, Philippe POUMAILLOUX > wrote: > > Peut-ê

Re: [GNC] Download or change GNU Cash language to Spanish

2020-06-07 Thread John Ralls
You already have, though if you're using a distro that has language packs you might have to find the right one with the GnuCash Spanish message catalog. You might find https://wiki.gnucash.org/wiki/Locale_Settings helpful. Regards, John Ralls __

[GNC] GnuCash 3.904 Released

2020-06-07 Thread John Ralls
The GnuCash development team announces GnuCash 3.904, the third testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is n

Re: [GNC] --add-price-quotes prints nothing and always fails with no info

2020-06-05 Thread John Ralls
mezone: <=== optional > > Is there any way to get more debug information? My system is Debian 10, and > "gnucash -v" outputs: By default GnuCash logs to a file: https://wiki.gnucash.org/wiki/Tracefile. If you want the output to go to the terminal add `-

Re: [GNC] Importing XLM into GNUCash

2020-06-03 Thread John Ralls
ogram. XML is a language for creating data formats, not a format in itself. GnuCash can import invoices but they must be in something resembling a comma-separated-value format with the columns in a specific order. Regards, John Ralls ___ gnucash-user mail

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

2020-06-02 Thread John Ralls
Hah! So it was your own build, not Ubuntu's. You should go close your bug report. Regards, John Ralls > On Jun 2, 2020, at 12:03 PM, Tim Kallmer wrote: > > Actually, I was able to resolve my issue just now. I resolved it by deleting > a previous build still present in

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

2020-06-02 Thread John Ralls
If you're able to build GnuCash from source that will resolve the problem. Regards, John Ralls > On Jun 2, 2020, at 11:53 AM, Tim Kallmer wrote: > > > ubuntu-bug gnucash > > Okay, I filed that bug. Thanks. In the meantime, would building a newer GC > like 3.1

Re: [GNC] ANNOUNCE: GnuCash 3.903 Released

2020-06-01 Thread John Ralls
It's actually the second, but still... Regards, John Ralls > On Jun 1, 2020, at 5:17 PM, Ed Reeder wrote: > > John, > You might want to clarify that this is an experimental/unstable release. > > Thanks for all you do! > > > On Mon, Jun 1, 2020, at 4:38 PM, Jo

Re: [GNC] Libboost error upon upgrade to 20.04 from 19.10

2020-06-01 Thread John Ralls
ost those will be libboost_date_time, libboost_filesystem, libboost_locale, and libboost_regex. The right fix is to get the Ubuntu packager to rebuild the package with the new library versions. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@

Re: [GNC] Unable to set start and end date in Income Statement report

2020-06-01 Thread John Ralls
hey have nice demo code built in; the actual controls used in GnuCash are GtkRadioButton [3] and GtkCheckButton [4]. Regards, John Ralls [1] https://www.w3schools.com/tags/att_input_type_radio.asp [2] https://www.w3schools.com/tags/att_input_type_checkbox.asp [3] https://developer.gnome.or

Re: [GNC] GnuCash 3.903 Released

2020-06-01 Thread John Ralls
/gnucash/gnucash%20%28unstable%29/gnucash-docs-3.903-1.tar.gz";> https://github.com/Gnucash/gnucash/releases/download/3.903/gnucash-docs-3.903.tar.gz Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subs

Re: [GNC] [GNC-dev] GnuCash 3.903 Released

2020-06-01 Thread John Ralls
> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > GnuCash is now available as a flatpak from Flathub.org. Instructions for > installing and running. Are at https://wiki.gnucash.org/wiki/Flatpak Sorry. Regards, John Ralls ___

Re: [GNC] [GNC-dev] GnuCash 3.903 Released

2020-06-01 Thread John Ralls
> On Jun 1, 2020, at 11:51 AM, John Ralls wrote: > > The GnuCash development team announces GnuCash 3.903, the first testing > release for what will soon be GnuCash 4.0. A further note for developers: This release begins Feature Freeze, please commit only bug fix changes unti

[GNC] GnuCash 3.903 Released

2020-06-01 Thread John Ralls
The GnuCash development team announces GnuCash 3.903, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is n

Re: [GNC] Using Quicken direct connect with USAA

2020-05-25 Thread John Ralls
Ah, that would explain why the Next button was disabled: You had no accounts to assign. So the issue would seem to be that the first account download didn't take, though the AQBanking dialog box indicated that it should have. Regards, John Ralls > On May 25, 2020, at 4:41 PM, Jo

Re: [GNC] Using Quicken direct connect with USAA

2020-05-25 Thread John Ralls
When you first set up the User in the AQBanking Wizard did you check the Accounts tab after downloading the accounts the first time? Regards, John Ralls > On May 25, 2020, at 11:47 AM, Jon Schewe wrote: > > It just started working "magically". I tried manually creati

Re: [GNC] Using Quicken direct connect with USAA

2020-05-25 Thread John Ralls
Well, that's progress. The communication with USAA is clearly working. Maybe the flatpak sandbox isn't letting GnuCash see the results from AQBanking. Unfortunately I don't have time to investigate this further today. Regards, John Ralls > On May 25, 2020, at 9:29 AM,

Re: [GNC] Using Quicken direct connect with USAA

2020-05-25 Thread John Ralls
less than ideal. Regards, John Ralls > On May 25, 2020, at 8:59 AM, Jon Schewe wrote: > > Alan, > > Thanks for the suggestion. I tried not setting any special settings and > make sure the SSL v3 is unchecked. Still no change. > > As far as security goes, this method for

Re: [GNC] is there a transaction limit on converting xml to mysql

2020-05-25 Thread John Ralls
t's way beyond our competence. Administering a database server is harder than it looks so we have a simple rule: In order to use one with GnuCash you must be a competent database admin for the server you choose or must have one working for you. Anything short of that puts your data at r

Re: [GNC] What does OFX Direct Connect do?

2020-05-18 Thread John Ralls
go to the bank website, log in, and get the download, then use File>Import>Import OFX/QFX to import it. Regards, John Ralls > On May 18, 2020, at 2:20 PM, Fran_3 wrote: > > Woops! No ill intent. I've seen the same response on other SIG's when someone > started a ne

Re: [GNC] Use of Webkit-GTK in GNC

2020-05-18 Thread John Ralls
> On May 18, 2020, at 11:51 AM, Mark Sutton wrote: > > On Mon, May 18, 2020 at 10:48:12AM -0700, John Ralls wrote: >> Don't hijack threads, it's rude. Start a new one when you have a new >> question. >> >> OFX Direct Connect is just like importing

Re: [GNC] What does OFX Direct Connect do?

2020-05-18 Thread John Ralls
Don't hijack threads, it's rude. Start a new one when you have a new question. OFX Direct Connect is just like importing an OFX or QFX file downloaded from your bank's website except that it will connect to the bank and get the OFX file for you. Regards, John Ralls > On M

Re: [GNC] wells fargo downloads

2020-05-18 Thread John Ralls
en, so that it works only with their products. GnuCash is able to work only with OFX Direct Connect. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucas

Re: [GNC] Reordering splits in a transaction

2020-05-17 Thread John Ralls
the changed value. > > But it sounds like this is just the way the cards have been dealt, so maybe > I'll file an enhancement request on the bug tracker and go on with my > life. Thanks! Change the amount to a variable in the SX template transaction, then the SLR dialog box wil

Re: [GNC] Is there a better way enter multi-currency split transaction?

2020-05-16 Thread John Ralls
Trading splits are ignored; they don't turn on the ---split transaction--- flag in the Transfer Account cell. I think what's causing grief is the no-value Asset:Stock:ABC split. Regards, John Ralls > On May 16, 2020, at 9:39 AM, Derek Atkins wrote: > > Arguably a tra

Re: [GNC] Is there a better way enter multi-currency split transaction?

2020-05-16 Thread John Ralls
he first time)? Does GC create new Trading or Imbalance splits? Does it > alter the existing Trading splits? > It's not autofill, that finished when it filled in the transaction with a copy of the other one that matched. It's because if there's more than two splits GnuCash

Re: [GNC] Stock "split" exchanging shares of different currencies?

2020-05-15 Thread John Ralls
CAD:ETF:DLR 200 10.00 2,000.00 When you commit the transaction GnuCash will add the trading account splits: Trading:FUND:DLR.U 200 10.00 2,000.00 Trading:FUND:DLR-200 10.00

Re: [GNC] Can't open app w MacOS Catalina

2020-05-11 Thread John Ralls
The problem is that GnuCash 2.6.x was built as 32-bit to support running on MacOSX 10.5 and 10.6. Apple removed 32-bit support from Catalina. You need to upgrade GnuCash to a 3.x release. Regards, John Ralls > On May 11, 2020, at 9:30 AM, Sean Perlmutter wrote: > > Thanks so much

Re: [GNC] Can't open app w MacOS Catalina

2020-05-11 Thread John Ralls
sion of GnuCash? What happens? Have you tried running it from Terminal? Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-us

Re: [GNC] Transaction Report Default Account

2020-05-10 Thread John Ralls
e the report configuration. If you decide that you really do need to customize the report you'll want to read https://wiki.gnucash.org/wiki/Custom_Reports. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update

Re: [GNC] Can't find GNC_CONFIG_HOME or USER_DATA_HOME on Linux

2020-05-09 Thread John Ralls
ut such a folder does not exist on Ubuntu 18.04. > Am I expected to create the GNC_CONFIG_HOME folder, and then create the > gtk-3.0.css inside it? No, GNC_CONFIG_HOME isn't a literal, it stands in for an OS-dependent location. See https://wiki.gnucash.org/wiki/Configuration_Location

Re: [GNC] Adding Transactions From Another Program

2020-05-08 Thread John Ralls
proficient Schemer could import its modules directly. Regards, John Ralls > On May 7, 2020, at 10:44 PM, Hal Vaughan wrote: > > > >> Begin forwarded message: >> >> From: Hal Vaughan >> Subject: Re: [GNC] Adding Transactions From Another Program >&g

Re: [GNC] Adding Transactions From Another Program

2020-05-07 Thread John Ralls
#x27;t hard and doesn't require any C/C++ or Scheme programming skill, just some familiarity with build systems like Cmake. Yes, you will have to build a new GnuCash every time you want to upgrade, but once you have everything set up and working it's just running a single build script

Re: [GNC] Gnucash logs

2020-05-06 Thread John Ralls
gt; https://wiki.gnucash.org/wiki/Release_Schedule > > but 4.11 is planned for 2022-12-18. > Feature freeze is the next beta release on 31 May, and you'll need to allow some time for your PR to get reviewed. Regards, John Ralls ___ gnu

Re: [GNC] Online banking breaks after upgrade to Fedora 32 - error on executing job. status: enqueued (1)

2020-05-04 Thread John Ralls
.4 doesn't work with OFX DirectConnect. https://bugzilla.redhat.com/show_bug.cgi?id=1830609 Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.g

Re: [GNC] How do I add stock trades?

2020-05-02 Thread John Ralls
rency of the first parent account with a currency for its commodity is sometime referred to in the documentation as that child account's currency. Regards, John Ralls > On May 2, 2020, at 10:16 AM, Adrien Monteleone > wrote: > > Yes, I misspoke. Thank you. Technically it

Re: [GNC] Working with dates in Postgresql DB

2020-05-01 Thread John Ralls
That's exactly what happened a few years ago to a guy from California who did some updates while visiting New Zealand. Regards, John Ralls > On May 1, 2020, at 3:16 PM, David H wrote: > > Might be a problem if you were in Perth on April 11 entering txns and then > back

Re: [GNC] Working with dates in Postgresql DB

2020-05-01 Thread John Ralls
on the errant dates would put them in the wrong day. Regards, John Ralls > On Apr 30, 2020, at 10:24 PM, D. wrote: > > Thanks for the reply. I do understand the challenges this poses-- both from > the perspective of managing it on a daily basis, and from that of the > difficult

Re: [GNC] Adding Transactions From Another Program

2020-04-30 Thread John Ralls
Maybe one supplied by a drug manufacturer. Google tells me that Clozapine is an antipsychotic. Regards, John Ralls > On Apr 30, 2020, at 9:54 PM, D. via gnucash-user > wrote: > > "clozapine"="compile" > > Not sure what dictionary my machine is usi

Re: [GNC] Superannuation Co-Vid payment

2020-04-30 Thread John Ralls
No, but using the money to buy gold is. Regards, John Ralls > On Apr 30, 2020, at 9:31 PM, outlook_a062af9f159be...@outlook.com > wrote: > > The idea behind the Australian Govt. allowing early access to one’s > superannuation is economic stimulation NOT speculation. >

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
ifferently. Regards, John Ralls > On Apr 30, 2020, at 8:46 PM, D. wrote: > > John, > > I somewhat remember the discussion back in 2011 about the timestamp, but do > not recall all the details. Remind me why it is that GnuCash uses timestamps > in these date fields? All th

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
t that's a major change and so far nobody's had the appetite to take it on. Regards, John Ralls > On Apr 30, 2020, at 1:06 PM, GWB wrote: > > Curious about this. So is the goal to show all times in UTC on > invoices along with local time? I tend to default most things t

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
GnuCash stores all dates as UTC but displays them as local, applying the timezone rules for the date, not for today. So in EEST 2020-02-12 22:00:00 displays as 2020-02-13, 2020-06-12 21:00:00 displays as 2020-06-13, but 2020-02-21 21:00:00 displays as 2020-02-21. Regards, John Ralls > On

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
te::TIME != '10:59:00'; and the second to update the time as before. Regards, John Ralls > On Apr 30, 2020, at 11:07 AM, Finfort wrote: > > If post_date is 2017-12-31 22:00 or 23:00, it means (sometimes?) the real > date is 2018-01-01. At least in cases where I manuall

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
s, you might have to adjust it a bit. You might create a table with a DATETIME column and put a couple of rows in it to test against while you tweak. Make sure that GnuCash isn't connected to the database when you run that. Regards, John Ralls > On Apr 30, 2020, at 10:45 AM, Finfort wrote:

Re: [GNC] Working with dates in Postgresql DB

2020-04-30 Thread John Ralls
Yeah, it's definitely a bug. I easily found the wrong code and I'll fix it for 3.903 and 3.11. The query actually accounts for only 543 of the 547 wrong times, so there's another error somewhere else. Regards, John Ralls > On Apr 30, 2020, at 10:27 AM, Finfort wrote: &g

Re: [GNC] Adding Transactions From Another Program

2020-04-30 Thread John Ralls
tty well automated build systems at https://github.com/Gnucash/gnucash-on-osx and https://github.com/Gnucash/gnucash-on-windows. The budget code is not wrapped for Python or Guile. Regards, John Ralls > On Apr 30, 2020, at 7:18 AM, Stu Perlman wrote: > > David, are the Python binding

Re: [GNC] Working with dates in Postgresql DB

2020-04-29 Thread John Ralls
es as i on i.post_txn = t.guid group by t.post_date::TIME; Regards, John Ralls > On Apr 29, 2020, at 1:41 PM, Finfort wrote: > > But the program use business features like entering invoices or bills. > And we have this mess. > How we can manage that? > > > &

Re: [GNC] Working with dates in Postgresql DB

2020-04-29 Thread John Ralls
2011 so `select distinct time(post_date) from transactions;` returns 10:59:00 07:00:00 If I say instead `select distinct time(post_date) from transactions where post_date > '2011-01-01';` I just get 10:59:00. But I don't use the business features, so if that's the problem

Re: [GNC] Automatic Price Retrieval

2020-04-29 Thread John Ralls
> On Apr 29, 2020, at 9:54 AM, John Ralls wrote: > > > >> On Apr 29, 2020, at 3:08 AM, rsbrux via gnucash-user >> wrote: >> >> I would like GnuCah to retrieve prices automatically each time I open it. >> >> The documentation describe

Re: [GNC] Automatic Price Retrieval

2020-04-29 Thread John Ralls
r to open the Price Editor and click "Get Quotes". > > Is there a way to make price retrieval fully automatic? Use a cron job/scheduled task to run GnuCash with the --add-price-quotes=FILE argument, FILE being the path to your gnucash data file. Regards, John Ralls

Re: [GNC] Working with dates in Postgresql DB

2020-04-29 Thread John Ralls
dnight local, and which one is used *should* be determined by whether DST is in effect for the posted date in your locale. It seems that 40 transactions somehow used UK time instead of Cypress time. Did you enter all of the transactions from the GnuCash UI or did you import some of them? If you im

Re: [GNC] Working with dates in Postgresql DB

2020-04-28 Thread John Ralls
or those midnight dates in 2200 UTC in winter and 2100 in summer. I didn't think that it forced anything to midnight UTC though. Might you have entered data while visiting somewhere with a UTC (aka GMT) timezone? Regards, John Ralls ___ gnucas

[GNC] GnuCash 3.902 released

2020-04-27 Thread John Ralls
The GnuCash development team announces GnuCash 3.902, the first testing release for what will soon be GnuCash 4.0. Changes Baseline requirements Operating Systems: • Linux: Ubuntu 18.04LTS • MacOS: 10.13 • Windows: 8.1 Software Dependencies: • C++ standard is n

Re: [GNC] Net Worth Linechart report error

2020-04-27 Thread John Ralls
error messages and maybe a scheme stack trace with more details about the error. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/list

Re: [GNC] Rule based bank account transaction allocation

2020-04-27 Thread John Ralls
check the matches every time to make sure that it hasn't gone astray. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/g

Re: [GNC] Trying to set up online banking

2020-04-26 Thread John Ralls
nd click next in the Online Banking Setup Assistant. If it doesn't work then no accounts are set up and you have to do so manually, and that's what the Accounts tab in the AQBanking setup dialog is for. Regards, John Ralls > On Apr 26, 2020, at 10:55 AM, jean laroche wrote: >

Re: [GNC] Trying to set up online banking

2020-04-26 Thread John Ralls
Probably because nobody had the same experience. If the automagic account download didn't work then you have to set up the accounts manually in the AQBanking setup window using the Accounts tab. Regards, John Ralls > On Apr 26, 2020, at 10:38 AM, jean laroche wrote: > > Oh a

Re: [GNC] How to install Gnucash 3.8 on Debian 10 "buster"?

2020-04-26 Thread John Ralls
updates breaking your system you should use only Debian stable. The whole point of testing is to try out version upgrades to see what breaks. Regards, John Ralls > On Apr 26, 2020, at 7:33 AM, km22 wrote: > > As a follow up I have been running Gnucash 3.8 from the Debian testing > re

Re: [GNC] Trying to set up online banking

2020-04-25 Thread John Ralls
in that program and select the bank. Regards, John Ralls ___ 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

Re: [GNC] A Milk Run

2020-04-25 Thread John Ralls
ears > that way on a public forum. Except that you did, on https://github.com/Gnucash/gnucash-docs/pull/128. That comment is now deleted, but it wasn't exactly courteous, nor was it enlightening. Perhaps you realized that and deleted it yourself, but don't try to pretend that you di

Re: [GNC] bug or bad feature: entries future-dated

2020-04-20 Thread John Ralls
her than 5/1/20. This creates obvious confusion in the records. I > haven’t had this behavior problem in the past. Is that a bug? > Check the date completion window in Preferences > Date & Time. Regards, John Ralls ___ gnucash-use

Re: [GNC] Balance sheet unusable for LANG="de..."; was: Bad account setup in Guide §12

2020-04-17 Thread John Ralls
mented > over a decade. If you don't want unrealized gains change the price source to Average Cost. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe:

Re: [GNC] Editing SCM quesion

2020-04-16 Thread John Ralls
; (addto! heading-list (_ "Tax Amount"))) >>(if (value-col column-vector) >> (addto! heading-list (_ "Zenbat./Importe"))) >>(reverse heading-list))) > We do have a Basque translation, it just hasn't been updated in 15 years: > msg

Re: [GNC] Would like to use, but ....

2020-04-15 Thread John Ralls
nd if that says you're running Windows it points to the latest gnucash-xxx-setup.exe. There's no reliable way for it to know what version of Windows you have. The same is true of MacOS: Someone connecting with a PPC Mac running 10.5 will get pointed to the latest Mac bundle, which

Re: [GNC] Online price updating

2020-04-14 Thread John Ralls
e price quote source to yahoo-json. Regards, John Ralls. ___ 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

Re: [GNC] Which file contains the account name map for the CSV import tool?

2020-04-12 Thread John Ralls
ored in your book (i.e. .gnucash) file. https://wiki.gnucash.org/wiki/Backup lists all of the files that you'll need to copy to the new machine. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscri

Re: [GNC] cMakeError.log errors - building Gnucash 3.10

2020-04-12 Thread John Ralls
FAILED: cmTC_59318 > : && /usr/bin/cc -Wno-error=deprecated-declarations -std=gnu11 > -Wno-error=parentheses -Werror -Wdeclaration-after-statement > -Wno-pointer-sign -Wall -Wmissing-prototypes -Wmissing-declarations > -Wno-unused -DCHECK_F

Re: [GNC] Gnucash and Windows 10 Aero snap feature

2020-04-11 Thread John Ralls
There's no config for that. AeroSnap isn't fully supported by Gtk. For a somewhat technical discussion of why and whether it will change in Gtk4, see https://gitlab.gnome.org/GNOME/gtk/issues/105. Regards, John Ralls > On Apr 11, 2020, at 2:41 PM, wrote: > > Hi All, &g

[GNC] GnuCash 3.10 Released

2020-04-11 Thread John Ralls
The GnuCash development team announces GnuCash 3.10, the eleventh release of the 3.x stable release series. Changes This is a snap release to reverse the changes to the reconcile window's filtering reconciled transactions with a reconcile date after the current statement date when computing t

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

2020-04-09 Thread John Ralls
Yes, you can use Homebrew, but they just wrap the Gnucash.app that I build and distribute via https://www.gnucash.org so I don't see why you'd want to. Regards, John Ralls > On Apr 9, 2020, at 12:14 PM, jess wrote: > >> Is there an "Update" software functio

Re: [GNC] Help!

2020-04-09 Thread John Ralls
> On Apr 9, 2020, at 5:24 AM, Adrien Monteleone > wrote: > > If I’m not mistaken, 2.6.21 is 64bit. Nope. It's 32-bit. Not a problem of Evelyn, who's only going to 10.13. Regards, John Ralls ___ gnucash-user mailing list gn

Re: [GNC] Canadian Sales Tax Questions and/or "Canadian Version" of GnuCash

2020-04-08 Thread John Ralls
ely on their distro's package manager though most of those tend to lag behind releases. Installing an upgrade in the same major release shouldn't affect your data. Regards, John Ralls ___ gnucash-user mailing list gnucash-user@gnucash.org To up

Re: [GNC] Price of gold

2020-04-08 Thread John Ralls
hange rate; that's what GnuCash will do if you have an account denominated in the XAU currency and your book currency is USD. The gold amount is Troy ounces, about 40 grams. (The "other ounce" is avoirdupois, about 28 grams each.) Regards, John Ralls ___

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls
Excellent that you're back in business. What was wrong with the transaction? Regards, John Ralls > On Apr 7, 2020, at 12:15 PM, wrote: > > Many thanks for that, John. > > I'd already got the same error when I opened the last backup file, which is > why I ass

Re: [GNC] CRIT [gnc_price_unref()] last unref while price in database

2020-04-07 Thread John Ralls
recover some of it by replaying the corresponding log file with File>Import>Replay log file. You should also check the drive with `chkdsk` and `wmic diskdrive get status` to make sure that the corruption was something random like a cosmic ray and not the first sign of needing a new one.

<    3   4   5   6   7   8   9   10   11   12   >