Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 10:34 AM, Adrien Monteleone > wrote: > > Since .gnucash is not really proprietary or somehow a special format from XML > then I agree, the extension should be .xml. Since the only supported operating system to ever use anything other than file extensions to associate

Re: [GNC] File Format Documentation (Bug 777893)

As a linux user trying to use the repo version, I’ve never had to separately install sqlite to my recollection. Certainly, it’s part of the preps for building if sqlite support is intended. But even then, I don’t recall separate installation. It was already there when I checked. I can certainly

Re: [GNC] File Format Documentation (Bug 777893)

Roger that. Curious though if this issue should be addressed in documentation, or bugzilla. It’s probably a bug if the format can’t make use of them. They likely should not be generated at all. Regards, Adrien > On Aug 15, 2018, at 7:22 PM, David T. wrote: > > > >> On Aug 15, 2018, at 1:35

Re: [GNC] File Format Documentation (Bug 777893)

I apologize. I never meant to imply otherwise. Your statement sounded tentative, and I was seeking definitive confirmation. That’s all. > On Aug 15, 2018, at 5:37 PM, Derek Atkins wrote: > > I am a developer and Linux user. > I have had to manually install the sqlite dbd. > > -derek > Sent

Re: [GNC] File Format Documentation (Bug 777893)

Can a developer or linux user confirm this for me? I am neither. > On Aug 15, 2018, at 5:33 PM, Derek Atkins wrote: > > Depends on the platform. > On Linux the sqlite dbd may not come installed. > > -derek > Sent using my mobile device. Please excuse any typos. > On August 15, 2018 8:20:03 PM

Re: [GNC] File Format Documentation (Bug 777893)

Depends on the platform. On Linux the sqlite dbd may not come installed. -derek Sent using my mobile device. Please excuse any typos. On August 15, 2018 8:20:03 PM "David T." wrote: Derek, I understand the point, but my intention on this is to indicate that a user must separately install

Re: [GNC] Installing F::Q on Ubuntu

Tim, Numerous people have reported troubles using AlphaVantage to retrieve quotes recently, with several noting that the site appears to be unreliable (perhaps purposefully so). You don’t mention your GnuCash version; on GC3.2, there is supposedly a user preference slot for the AlphaVantage

Re: [GNC] File Format Documentation (Bug 777893)

As you note, backups are not a germane topic here. I will note that Section 2.6 of the Guide is titled “Backing Up and Recovering Data.” Perhaps that section could include further discourse on data backups. David > On Aug 15, 2018, at 3:04 PM, David Carlson > wrote: > > While file backups

Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 1:35 PM, Adrien Monteleone > wrote: > > Looks pretty clear. > > Though I’m noticing sqlite does generate log files too. Note, these are > transaction replay logs from what I understand in case of a crash. As I > believe John Ralls noted, any of these past the last

Re: [GNC] File Format Documentation (Bug 777893)

Derek, I understand the point, but my intention on this is to indicate that a user must separately install libdbi libraries in order to use MySQL and PostgreSQL. As I understand it (and from personal experience) I do not have to perform any additional driver installations when I choose either

[GNC] Transaction reports with only debits or credits

Is there a way to configure a transaction report (or any of the available reports) to show only the debits or the credits (but not both) of an account? ___ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to

[GNC] Installing F::Q on Ubuntu

I have switched to a linux laptop since the price quotes stopped working on my windows 10 one. (I had it working at one time.) But I am currently not able to get price quotes in the linux version of gnucash either. I get the error, Unable to retrieve quotes for these items, then a list of all my

Re: [GNC] File Format Documentation (Bug 777893)

While file backups are not germane to the topic, it might be nice to mention them in passing as the users might tailor their procedure to the particular data type they choose. David C On Wed, Aug 15, 2018, 3:46 PM Derek Atkins wrote: > I believe SQLite is included on Windows as well. > -derek

Re: [GNC] gnucash @ Mac OS annoyances

On Wed, Aug 15, 2018 at 06:52:03AM -0700, John Ralls wrote: > > > > On Aug 15, 2018, at 12:21 AM, Thomas Klausner wrote: > > > > Hi! > > > > I'm a long-time gnucash user, and tried out the Mac OS version (3.2) > > for the first time today. I was using the official binary downloaded > > from

Re: [GNC] Column widths again

I have large and small monitors and the sizing of the columns started to work very well for me after I got enough knowledge to deal with them. After you scale all columns to your liking, drag in the header the end divider of the Description column farthest to the left and then drop it and it will

Re: [GNC] File Format Documentation (Bug 777893)

I believe SQLite is included on Windows as well. -derek On Wed, August 15, 2018 4:35 pm, Adrien Monteleone wrote: > Looks pretty clear. > > Though I’m noticing sqlite does generate log files too. Note, these are > transaction replay logs from what I understand in case of a crash. As I > believe

Re: [GNC] File Format Documentation (Bug 777893)

Looks pretty clear. Though I’m noticing sqlite does generate log files too. Note, these are transaction replay logs from what I understand in case of a crash. As I believe John Ralls noted, any of these past the last successful save are useless. I’m not sure if this is what you are referring

Re: [GNC] File Format Documentation (Bug 777893)

On 08/14/2018 10:09 PM, David T. wrote: > Stephen, > > >> On Aug 14, 2018, at 4:50 PM, Stephen M. Butler wrote: >> >> On 08/14/2018 04:24 PM, David T. wrote: >>> Steve, >>> >>> Thanks for your input. I believe we’re in agreement here; I wasn’t trying >>> to suggest that GC become a DBMS, but

Re: [GNC] File Format Documentation (Bug 777893)

SQLite uses libdbi, too. -derek On Wed, August 15, 2018 1:49 pm, David T. via gnucash-user wrote: > Here is a newer version of the table: > > Storage Comparison Table > XML SQLite MySQL PostgreSQL > Installation Default Default libdbi libdbi > File extensiongnucash gnucash

Re: [GNC] File Format Documentation (Bug 777893)

Here is a newer version of the table: Storage Comparison Table XML SQLite MySQL PostgreSQL InstallationDefault Default libdbi libdbi File extension gnucash gnucash N/A N/A Additional software NoneNoneMySQL PostgreSQL Additional expertiseNoneNone

Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 12:11 PM, David T. wrote: > > > >> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone >> wrote: >> >> But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain >> text and trying to view it is going to be met with tag soup they’ve never >> seen

Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 10:08 AM, Adrien Monteleone > wrote: > > >> On Aug 15, 2018, at 10:59 AM, David T. wrote: >> >>> >>> Additionally, the comparison table might serve better with each SQL backend >>> represented, since that’s the next question for someone contemplating that >>>

Re: [GNC] File Format Documentation (Bug 777893)

Additional sections? What you have here is the overview. So perhaps sections which cover those details are in order for further reading. The overview though should allow someone to make a quick decision at least to determine if they want to investigate further or not without bogging them down

Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 10:02 AM, Adrien Monteleone > wrote: > > But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain > text and trying to view it is going to be met with tag soup they’ve never > seen before and might very well not know how to read it. Not to mention

Re: [GNC] File Format Documentation (Bug 777893)

> On Aug 15, 2018, at 10:59 AM, David T. wrote: > >> >> Additionally, the comparison table might serve better with each SQL backend >> represented, since that’s the next question for someone contemplating that >> route. And in that case, sqlite does not necessarily require additional >>

Re: [GNC] File Format Documentation (Bug 777893)

But it’s not a ‘plain file’ as it is XML formatted. Someone expecting plain text and trying to view it is going to be met with tag soup they’ve never seen before and might very well not know how to read it. It also carries an .xml extension. So specifying the format is very specific and

Re: [GNC] GC 3.2 Import Price File CSV

Thanks. I just recreated a new GC datafile with just 1 security definition as shown in your screenshot. I put your CSV price entry in a text file and imported it but gives me the error you have shown. Here’s why - Your security definition is ABF.L, but your CSV file has this set to ABF.

Re: [GNC] File Format Documentation (Bug 777893)

Adrien, As I look at implementing your suggestion of a brief comment paired with the table, I encounter a problem. Specifically, many elements of comparison are entirely unexplained anywhere else (indeed, this was the inspiration to take this on in the first place). It seems to me that some

Re: [GNC] File Format Documentation (Bug 777893)

Christoph, Colin also replied to your note, and I agree with his point regarding the teminology used in GnuCash. Since the program uses “xml,” the documentation should as well. I will also note that “plain file” is inaccurate and misleading; it suggests a simple text file to me. An XML file

Re: [GNC] File Format Documentation (Bug 777893)

On Wed, 15 Aug 2018 at 16:37, Christoph R wrote: > Hi David, > > > The default file storage format is XML > > I would not call this “XML" but "plain file”. From a user perspective it > is not important in which internal format it is stored. But it makes a big > difference if it is a simple file

Re: [GNC] File Format Documentation (Bug 777893)

Adrrien, Thanks for the additional input. > On Aug 14, 2018, at 11:00 PM, Adrien Monteleone > wrote: > > Are the dirty details really necessary? > > I don’t see that they help the user (who may not be well versed in the > issues) to make a decision. I would think simpler in this case would

Re: [GNC] gnucash-user Digest, Vol 185, Issue 45

Hi, First, please remember to CC the list on all replies. Stan Brown writes: > https://www.gnucash.org/news.phtml > > Geert (or maybe somebody else) emailed me to say that they had > corrected the two wrong links, plus one more that they found. However, > one is still wrong. Or, rather, it no

Re: [GNC] gnucash-user Digest, Vol 185, Issue 63

Stan Brown writes: > Thanks for this, David. It seems very helpful and to the point. Only two > comments: > > * After reading this note, I feel I have a good idea of the pros and > cons of the two formats. One thing I'd like see added" is a choice of > XML or SQL irrevocable, or can the

Re: [GNC] Disconnect between balance on client list and account statement

Adrien, A challenge here is that the GnuCash I am using is in Spanish, that is the accounting terms and reports and in Spanish so I’m guessing at what the names are in English. I couldn’t figure out which report was the aging report because of that. The best I can guess is the following:

Re: [GNC] GC 3.2 Import Price File CSV

I will try to show my problem with screenshots - hopefully it will work but never tried this before. This is my entry in the database: This is the single line in my CSV vile: ABF,12/08/2018,25,GBP And this is my import form:

Re: [GNC] gnucash-user Digest, Vol 185, Issue 63

Thanks for this, David. It seems very helpful and to the point. Only two comments: * After reading this note, I feel I have a good idea of the pros and cons of the two formats. One thing I'd like see added" is a choice of XML or SQL irrevocable, or can the database be converted from one format

[GNC] gnucash @ Mac OS annoyances

Hi! I'm a long-time gnucash user, and tried out the Mac OS version (3.2) for the first time today. I was using the official binary downloaded from sourceforge. I have the following issues that I hadn't seen before on other OS: * When I start typing the Description, it auto-completes, but does

Re: [GNC] Tips & CSS rule for navigating the Budget window with the keyboard

Thanks Adrien. On Windows 10, it seems to make no difference whether or not the .GncBudgetPage class is inserted, the command still affects both Account Tree and Budget. Peter On 14 August 2018 at 19:52, Adrien Monteleone < adrien.montele...@lusfiber.net> wrote: > While investigating bug

Re: [GNC] File Format Documentation (Bug 777893)

Are the dirty details really necessary? I don’t see that they help the user (who may not be well versed in the issues) to make a decision. I would think simpler in this case would be better. If it is clear that GnuCash does not yet take full advantage of SQL and that specifically, you can’t