Re: Preferred Date Format When Importing CSV Files

2017-07-29 Thread David Carlson
It does seem odd that the importer does not default to the same choice that the user has chosen for the data file, even though it is important to allow the user to change it if (s)he has a CSV file with a different choice. David C On Sat, Jul 29, 2017 at 7:36 AM, Jean-David Beyer

GnuCash with bad network connection

2017-07-31 Thread David Carlson
My home Wi-Fi has suddenly developed a bad case of dropouts in spite of a very strong signal. Several times a day various devices need to reconnect. With that background, if GnuCash is in the process of saving the data file (over Wi-Fi) when the dropout happens, GnuCash appears to hang and my

Re: gnucash update on debian errors, then stops

2017-08-01 Thread David Carlson
Is that the new package of release 2.6.17 from getdeb that I just tried to download into Ubuntu and have not had time to test yet? David C On Aug 1, 2017 8:25 PM, "John Griessen" wrote: > I have not been able to upgrade gnucash for a while now. > > Will there be a

Re: Scheduled Transaction Help :(

2017-08-03 Thread David Carlson
Another thing to try that once helped me to fix some old and broken SEx's (android did tat and I can't fix it.) is to enter zero's into every empty acccouunt value box so there are two values in each line. Sounds crazy but it actually worked David C On Aug 3, 2017 2:48 AM, "Steve"

Re: advice on software

2017-08-11 Thread David Carlson
Chris, There is a steep hill to climb to export history from a 'Q' program and import it into GnuCash. Many of GnuCash's current users felt that it was worth the effort to switch. Even if you do not import any history, there is a learning curve to get your account tree set up correctly, etc.

Re: When importing transactions, what happens to non-identical data in the description and notes fields?

2017-07-09 Thread David Carlson
Paul In my experience it depends on which method you use. I usually use the OFX import and if I choose update the new text replaces the existing so I often either choose match which keeps the existing text or add to keep.the existing transaction intact so I can manually merge text later. David

Re: Newbie Question

2017-07-07 Thread David Carlson
If your accounts are in different currencies, which they might be, each one should be denominated in the correct currency. The parent accounts (Assets:Current) probably also need to be set up separately for each currency. However, I am not a multi-currency user, so I may be wrong David C

Re: Flash Drive

2017-07-14 Thread David Carlson
Perhaps this is not sensible, but I once experimented with installing Gnucash on a USB key configured as a Tails OS with persistent storage. That is based on Debian Linux. It worked, but it was somewhat clumsy. The nice thing is that all the data is completely encrypted and insulated from

Re: Flash Drive

2017-07-14 Thread David Carlson
Seems like that should be very easy for someone with Fedora to try! David C On Fri, Jul 14, 2017 at 6:04 AM, Colin Law wrote: > On 14 July 2017 at 03:12, ov10fac wrote: > > Does anyone know if gnucash can be run from a flash drive using fedora? > > Do you

Re: Reporting Repository ?

2017-07-03 Thread David Carlson
Did you look at gti90...@gmail.com answers in the clean CSI export thread? David C On Jul 3, 2017 9:42 AM, "John Ralls" wrote: > > > > On Jul 3, 2017, at 6:38 AM, aegross wrote: > > > > On Mon, Jul 3, 2017 at 12:50 AM, John Ralls-2 [via GnuCash] < > >

Re: Repeating transactions crash Gnucash 2.6.16 and 2.2.17

2017-07-05 Thread David Carlson
When you say you use the transaction again, do you mean that it is scheduled and comes up when running the Since Last Run Assistant? Exactly at what point does it crash? David C On Thu, Jul 6, 2017 at 1:14 AM, Frank wrote: > I'm relatively to gnucash and am looking to

Re: "Point of sale debit or credit (Note: Depends on signage of amount)" appended to transactions in 2.6.17

2017-07-06 Thread David Carlson
John, Does that mean that when users download files from their financial institutions and import them offline they will always get that message in the description field? I would prefer "OFX ext. info: |Trans type:Generic debit|Memo:" as before, unless an option is added to even suppress that

Re: "Point of sale debit or credit (Note: Depends on signage of amount)" appended to transactions in 2.6.17

2017-07-06 Thread David Carlson
Sorry, I am confused about field names. Is that new message in the description field instead of the current data or is it actually in the Notes field where the previous message was prepended to the FI note? David C On Thu, Jul 6, 2017 at 1:26 PM, David Carlson <david.carlson@gmail.

Re: Is there a way to set an account's beginning balance AFTER having created it in GnuCash?

2017-07-28 Thread David Carlson
Bob, The Opening Balance shortcut that you see when creating an account is not functional after the account is created, as you have seen. That shortcut just creates a transaction to offset the opening balance with an entry in Equity:Opening Balances. You can open that account and duplicate any

Re: population

2017-08-02 Thread David Carlson
Christine, It seems that you are the first to report your problem. That is why the developers are asking so many questions about details. Please check the about gnucash screen and tell them the exact release number and build date. David C On Wed, Aug 2, 2017 at 7:24 AM, Christine Maloney via

Re: Help on US Tax Form 8825

2017-08-09 Thread David Carlson
It is curious that this form is not in the list. For tax related accounts that cannot be assigned to the proper form you could just mark the account as tax related without the form assignment, and it will be in the report where you will at least be reminded to include it in your filing. David C

Re: Virtual accounts or line items

2017-08-06 Thread David Carlson
What I do is keep two register views open on the 'parent' account, one 'with sub-accounts' which shows the totals as seen by the bank and one normal register view which shows the amount not dedicated to the 'virtual' sub-account(s). As suggested in the thread that you cited, I do not tell the

Re: Suggestion

2017-08-06 Thread David Carlson
For me the time to move, decrypt, and decompress the data file and generate the register views and report views is so much longer than loading the program that I do not even try to measure that part. David C On Sun, Aug 6, 2017 at 5:50 PM, Greg Feneis wrote: > Also FWIW, I

Re: Virtual accounts or line items

2017-08-06 Thread David Carlson
ike would be for some "real" transactions to > reference the parent account and some to reference the virtual account. > Then when importing the QFX the import process would look in the parent > account and the sub-accounts. > > > On Sun, Aug 6, 2017 at 6:15 PM, David Carlson &

Re: Is there a GC function to separate a multi-split transaction into sepa rate, 2-split transactions?

2017-08-18 Thread David Carlson
Paul, I would not recommend doing that, as it would fill your bank account register with many entries that would be a nightmare to reconcile against your bank statement, but one brute force way to do it would be to duplicate the transaction as many times as necessary, then edit each one to delete

Re: How to enter split transactions

2017-08-23 Thread David Carlson
I would also suggest trying the View>Auto Split Ledger>and View>Transaction Journal menu options to see how those affect what you see while you are experimenting. I also happen to like to use the Double Line view. In fact I wish the double line view was the out-of-the-box default. David C On

Re: Not able to make entries in Gnucash

2017-08-18 Thread David Carlson
In Summary - A few of the reasons that GnuCash might report (or suggest opening) a file as read-only are: 1. The last time the file was opened it was not closed properly, leaving a .LCK file in the data file folder. 2. The data file is in a folder that the OS has marked Read-Only. 3. There could

Re: When does GnuCash create .log files?

2017-05-17 Thread David Carlson
I have experimented further after reading your post DaveC49. In my case, I am keeping the data file on a remote server and I see that the .log file grows as I edit my data, but the modified time stays at the time created for some reason. I also set GnuCash to ask me before doing an auto-save and

Re: Trial Balance does not include amount of Return of Capital Investment splits

2017-05-18 Thread David Carlson
Chris, It has been several years since I had a similar situation, but I see that GnuCash still has a stock split assistant (Chapter 11, I think of the tutorial) which helps to mash all of the parts of a split into a single transaction. Did you try that? David C On Thu, May 18, 2017 at 3:18 AM,

Re: Get Quotes doesn't work

2017-05-17 Thread David Carlson
What do you mean by 'nothing happened'? Were you able to see both of the currencies in the price database? Have you entered any daily prices manually? Are you using GnuCah release 2.6.16? Which currency is your default? David C On Wed, May 17, 2017 at 12:45 AM, Oleg Linkin

When does GnuCash create .log files?

2017-05-16 Thread David Carlson
I used to think that GnuCash created .log files periodically when theauto-save interval has passed since the last edit. Now, it seems that GnuCash does a complete file save according to that interval. If that is the case, why have a .log file? David C

Re: List of Equity, Expenses and Liabilities has disappeared

2017-06-12 Thread David Carlson
Are you using View>New Accounts Page to see the list of accounts? David C On Mon, Jun 12, 2017 at 4:37 AM, Jonathan Silvey wrote: > I > ​ ​ > have two problems that may or may not be related. > > First, when I want to go to my main list of assets and liabilities, the

Fwd: Gnucash file is getting long!

2017-06-20 Thread David Carlson
-- Forwarded message -- From: Andrew Shalaurov Date: Tue, Jun 20, 2017 at 12:14 PM Subject: Import Transactions to Gnucash Excised from: Gnucash file is getting long! Can someone explain to me how to import transactions so 2 GL accounts are assigned to each

Re: When does GnuCash create .log files?

2017-05-16 Thread David Carlson
none if I do an early save. David C Sent via the Samsung Galaxy S® 5 ACTIVE™, an AT 4G LTE smartphone Original message From: Buddha Buck <blaisepas...@gmail.com> Date: 5/16/17 2:41 PM (GMT-06:00) To: David Carlson <david.carlson@gmail.com>, gnucash-user

Re: Having problem printing checks on HP

2017-06-03 Thread David Carlson
There are a number of things that could go wrong. To eliminate some of them, can GnuCash print any of the standard reports? Have you followed the procedure outlined in chapter 6 of the help manual? If so, which part does not work? Which operating system do you have? Are you using GnuCash

Re: Reconciling an account

2017-06-06 Thread David Carlson
I really hate to rain on your parade... Check your Edit>Preferences>Accounts>Reverse Balanced Accounts. I believe the default is labelled Credit, but that means Credit Card, Payable, Liability Equity and Income, and that is probably what is checked in your file. If that is so, then the balance

Re: Installment Payment Plans & Bills Due Reminder

2017-06-08 Thread David Carlson
Seems like the Since Last Run assistant could have an optional feature to rerun automatically from time to time if there is something to do and the program has been open overnight. David C On Thu, Jun 8, 2017 at 11:34 AM, Maf. King wrote: > On Thursday, 8 June 2017 17:06:50

Re: Website down?

2017-06-08 Thread David Carlson
Must have been intermittent. I was there a couple of days ago too. David C On Jun 8, 2017 10:00 AM, "Maf. King" wrote: > ISTR that I was on it yesterday (or the day before. Looking at the FAQ to > point Edwin in the right direction). of course, I may have found a cache >

Re: Website down?

2017-06-08 Thread David Carlson
threads got scrambled here. Is this still about the website health? David C On Thu, Jun 8, 2017 at 1:38 PM, Kalin KOZHUHAROV wrote: > On Thu, Jun 8, 2017 at 6:59 PM, Derek Atkins wrote: > > On Thu, June 8, 2017 12:45 pm, Kalin KOZHUHAROV wrote: > >> On

Re: Reconciling an account

2017-06-05 Thread David Carlson
I often have duplicate entries appear in transfer accounts when I import transactions resulting from imperfect matching during the import process. While these are usually easy to find and fix, sometimes I make an error and "fix" the wrong transaction or split. If a previously reconciled

Re: Reconciling an account

2017-06-06 Thread David Carlson
Ok, the next thing to do is to go into your register view and look at the running total next to each of the transactions that you show in your images, to see if the value was correctly added or subtracted by GnuCash. Also set the register view to Transaction Journal to see if there are any

Re: Gnucash file is getting long!

2017-06-17 Thread David Carlson
If the MySql format data file is not on the main hard drive but a) on a USB 2.0 or 3.0 key, b) on another computer accessed by Wi-Fi or Ethernet, c) on a cloud server. Would the MySql database format be faster than the compressed XML in any of the above scenarios, particularly when periodic

Re: Reconciling an account

2017-06-16 Thread David Carlson
When you have the curser in a split line of a transaction, the word 'Tot' disappears. You only see that when the curser is in boxes that are not a part of a split line. David C On Fri, Jun 16, 2017 at 10:53 AM, Maf. King wrote: > On Friday, 16 June 2017 16:04:02 BST

Re: Notes column in SingleLine display

2017-06-18 Thread David Carlson
Well, if you read the manual you will find the answer to all your prayers, or at ieast to all the "faults" that you have found so far with GnuCash. Well, there is no way to replace the description with the notes other than to put the text that you want to see in the Description field. Isn't that

Re: Unrealized losses (or gains)

2017-06-18 Thread David Carlson
Alain Follow this link. http://gnucash.1415818.n4.nabble.com/Unrealized-losses-tc4691319.html#a4691532 David C On Jun 18, 2017 1:41 PM, "Kalin KOZHUHAROV" wrote: Hello, On Sun, Jun 18, 2017 at 6:45 PM, Alain Dormoy wrote: > My problem is I had in the past

Re: Transfer query.

2017-06-13 Thread David Carlson
To elaborate on Derek's explanation, all the 'Charges' in your credit card (Liability) account should appear on the right side in the credit card account, and on the left side in the various expense accounts if you 'jump' to the expense accounts. On Tue, Jun 13, 2017 at 11:44 AM, Derek Atkins

Re: Gnucash file is getting long!

2017-06-14 Thread David Carlson
I think that John Ogden has a valid question which should be covered better somewhere in the manual. The short answer, unfortunately, is that there is no way to split out old data to shrink the data file. Also, it is a fact that eventually your file may grow to the point where it taxes your

Re: Reconciling an account

2017-06-05 Thread David Carlson
Wow, now we are getting some well detailed suggestions! I will add a couple: To quickly see if all previous transactions were really reconciled, select View > Filter by .> Status > uncheck Reconciled. If you don't have too many transactions with dates earlier than the bank cleared them, your

Re: nomenclatural clarification - parts of a transaction

2017-09-14 Thread David Carlson
Good call David R, Another point of possible confusion for even long-time users like me is that the column titles will change as the curser moves around in the transaction display, so the user must carefully note the current position of the curser to correctly interpret the column title. David C

Re: nomenclatural clarification - parts of a transaction

2017-09-14 Thread David Carlson
There is a special case when the first transaction line to be entered has a zero value then GnuCash does not require that there be any additional lines. This does not rigidly follow the double entry concept in my opinion. In that case I am not sure about notes, but I think that they are

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-06 Thread David Carlson
Derek, Did you try replacing the cable? Low hanging fruit... David C On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote: > David Carlson <david.carlson@gmail.com> writes: > > > Derek, > > > > Is it possible to read event logs and deter

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-06 Thread David Carlson
; On Fri, October 6, 2017 10:27 am, David Carlson wrote: > > Derek, > > > > Did you try replacing the cable? Low hanging fruit... > > > > David C > > > > On Fri, Oct 6, 2017 at 8:39 AM, Derek Atkins <warl...@mit.edu> wrote: > > > >> Da

Re: only deposits show

2017-10-06 Thread David Carlson
;https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>* > *Clovis, Ca > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/2/2017 10:11:19 PM, Da

Re: importing

2017-10-07 Thread David Carlson
Frank and David T, I believe that the QIF importer may not work exactly the same way that it did back in the 2.2 series or the 2.4 series or even the 2.6 series before release 2.6.18. If that is the c as e then we really do need someone who is familiar with the way it works now to jump in and

Re: importing

2017-10-07 Thread David Carlson
, 2017 at 6:55 PM, frank raney <frankraney...@gmail.com> wrote: > > > *Frankie Raney* > *If it worked good in 2.2, then maybe I can get that version, try it and > if it works good, then upgrade.* > > On 10/7/2017 4:45:51 PM, David Carlson <david.carlson@gmail.com

Re: only deposits show

2017-10-02 Thread David Carlson
You do not mention important details that are needed to give a definitive answer, but assuming that you followed the a likely path, you exported transactions from your Quicken file in QIF format then imported them into GnuCash in the same format. The QIF format creates a data section for each

Re: simple find transactions report

2017-10-10 Thread David Carlson
ad to translate this to the menu entry > >"edit/find" (not "search") > > > >- elmar > > > >On 10/09/2017 04:16 PM, David Carlson wrote: > >> Geert, > >> > >> Gmail used those ing triple dots to hide yo

Re: command line QIF import

2017-10-15 Thread David Carlson
Not sure about more efficient ways to import via QIF, which, by the way, is reasonably efficient when done in small chunks, but another caveat that has not been raised recently is that as the data file grows it takes longer to do the frequent file saves. In Windows each save for my data file

Re: command line QIF import

2017-10-15 Thread David Carlson
I am not a developer, but I can point out that the QIF importer works in several discrete steps where (roughly) it 1. identifies the 'source' account type and name and tries to associate it to an existing account in the data file. If there is more than one 'source' account in the QIF file it

Re: command line QIF import

2017-10-16 Thread David Carlson
Nelson, It sounds to me like you are unwilling make the effort to "shepherd" your data through the import process. Many of us, including David T are trying to tell you that we have succeeded in completing massive imports from Quicken into GnuCash, but we needed to take several steps to plan our

Re: Account report error for transactions the last 30 days

2017-10-14 Thread David Carlson
I think that what you both are seeing is, in fact, as you have correctly asserted, Garbage In Garbage Out. Normally there are no running totals in search register views because they are an accumulation of transactions over an indeterminate sub set of the entire data set. Then a report derived

Re: Migrate from Moneydance to Gnucash

2017-10-16 Thread David Carlson
I think it is about the same as from Quicken, but perhaps easier because Moneydance is closer to being double entry. If they still have QIF exports ... David C On Oct 16, 2017 8:51 AM, "Roger Miskowicz" wrote: > Is there a recommended procedure for migrating Moneydance

Re: Scheduled transactions

2017-09-25 Thread David Carlson
ate tab. Thanks > > On Sep 25, 2017 2:04 PM, "David Carlson" <david.carlson@gmail.com> > wrote: > >> On the Template tab it is in the upper left as in the register view. >> >> David C >> >> On Mon, Sep 25, 2017 at 12:23 PM, <rmom...@gm

Re: Merging imported transactions

2017-09-25 Thread David Carlson
The OFX import assistant includes a step to match newly imported transactions to existing transactions, as you probably noticed. The problem is that it is error prone and has to be monitored carefully during the import process. I prefer to import a small number of transactions at a time so that

Re: Scheduled transactions

2017-09-25 Thread David Carlson
I use Remind in Advance for that purpose, but it is somewhat clumsy too. I put the word Sched in the Num field to remind me that the transaction has not really happened yet. David C On Mon, Sep 25, 2017 at 10:12 AM, Matthew Pounsett wrote: > On 25 September 2017 at 10:57,

Re: Excel or CSV Import

2017-09-27 Thread David Carlson
They already are On Sep 27, 2017 1:37 PM, "Dan" wrote: > When will Excel or CSV import be available? > > Dan > > ___ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user

Re: What's the best way to model an electronic funds transfer pull with hold

2017-10-01 Thread David Carlson
Nelson, Just one comment from another user; My banks do not show holds online, or if they do, it is a simple summary of book balance vs available balance. They warn that ACH transfers these-days often clear on the same day. To me, it is too much effort to try to track that, and as others have

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-02 Thread David Carlson
That might be difficult, as it may be a loose connector or even corrosion inside a cable or connector or component in a power supply or ??? Good luck. David C On Oct 2, 2017 10:42 AM, "Derek Atkins" wrote: > Hi, > > Just a quick follow-up. > > AT did come, and with their help

Re: What's the best way to model "in-flight" transactions?

2017-09-28 Thread David Carlson
I think the answer is "What works best for you." When most of our bank account transactions were checks (cheques in many countries) we entered each check by date and number in the checkbook register. When the bank statement came we compared it to our register, checking off each one that appeared

Re: [MAINT] Network Work on Code Sunday, Oct 1, 1-4pm EDT

2017-10-03 Thread David Carlson
Derek, Is it possible to read event logs and determine that some pieces of equipment are definitely not causing the problem? David C On Oct 3, 2017 10:04 AM, "Derek Atkins" wrote: > GWB writes: > > > So AT's network equipment works when nothing is connected

Re: How to deal with the cash flow and the credit card.

2017-09-24 Thread David Carlson
What is the Future Scheduled Transactions Summary report supposed to do? It looks like it might work, but it seems to be cluttered with a lot of strange values with too many decimal places and/or fractions with large denominators. David C On Sun, Sep 24, 2017 at 7:31 PM, R. Victor Klassen

Re: Budget Slowing Down Windows 10

2017-08-24 Thread David Carlson
It is well known that GnuCash tends to run slowly when running some reports, and particularly when working on larger data files containing years of data. However, it is very unusual to run so slowly that the OS complains that it is not responding. Some users (myself included) notice that it

Re: Budget Slowing Down Windows 10

2017-08-25 Thread David Carlson
monitor tool of some sort that you can run to see > how much memory is being used. Try running that and then the report > and see if you are running out of RAM > > Colin > > On 24 August 2017 at 22:59, David Carlson <david.carlson@gmail.com> > wrote: > > It i

Re: Budget Slowing Down Windows 10

2017-08-25 Thread David Carlson
I do not use budgets so I cannot comment on that part, but several other reports run very slowly for me, meaning they sometimes take minutes to update. GnuCash pretty much single threads, even on very powerful computers. The developers know about that and they are working feverishly on

Re: Tax Tables - an illustrated primer?

2017-09-03 Thread David Carlson
In the United States "Sales Tax" is a generic term for taxes that are collected at the point-of-sale and usually turned over to a state, city, county or other government agency by retailers. It is even difficult to make a concise and grammatically correct statement to describe the process. I

Re: Re : Could not obtain the lock

2017-09-02 Thread David Carlson
It sounds like you are starting GnuCash more times than you are shutting it down. GnuCash can open more than one instance at a time, which would cause the same message. Take care to return to the open instance rather than starting a new instance when you return, because it is possible to lose

Re: Re : Re : Could not obtain the lock

2017-09-02 Thread David Carlson
hile I save whatever still needs to be saved and I click on the cross in the upper right corner of my screen (am I missing something?) * *Alain* *De :* David Carlson <david.carlson@gmail.com> *Date :* samedi 2 septembre 2017 12:37 *À :* Alain Dormoy <cag...@free.fr> *Cc :* Colin Law &l

Re: simple find transactions report

2017-10-09 Thread David Carlson
Geert, Gmail used those ing triple dots to hide your reply in my mail folder. Lucky for me I suspected as much when there appeared to be no reply . David C On Mon, Oct 9, 2017 at 2:48 PM, Geert Janssens wrote: > Start with a search from the account hierarchy

Re: importing

2017-10-08 Thread David Carlson
(559)%20297-8577> H* *559.304.1751 <(559)%20304-1751> C* On 10/7/2017 7:15:37 PM, David Carlson <david.carlson@gmail.com> wrote: Frank, I did not mean to imply that it worked better then, but it may have worked differently in older releases. In any case, if you went that f

Re: importing

2017-10-08 Thread David Carlson
; > *Frankie Raney* > *12454 Auberry Rd. > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>* > *Clovis, Ca > <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20

Re: importing

2017-10-11 Thread David Carlson
Frank, There is still a problem with Gnucash on your computer because it should not be crashing. It may be somehow related to the account named Trading that GnuCash created. Normally, GnuCash will only create that account for users that know that they want to use a special feature that is there

Re: importing

2017-10-11 Thread David Carlson
I forgot to mention that there is a setting somewhere called "Use Trading Accounts" that turns that feature on or off. I think it is mentioned somewhere in the documentation. David C On Wed, Oct 11, 2017 at 4:07 PM, David Carlson <david.carlson@gmail.com> wrote: > Frank,

Re: importing

2017-10-11 Thread David Carlson
ps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/11/2017 2:14:08 PM, David Carlson <david.carlson@gmail.com> > wrote: > I forgot to mention that there is a se

Re: Customized saved-reports file per gnucash file (i.e. per company)

2017-10-10 Thread David Carlson
There is a section in the GnuCash FAQ about what files are where for the various OS's. IIRC there is a .gnucash directory under ~user or some such which can be copied and pasted into another machine, even under a different OS but that would overwrite whatever is there. Do not try that without

Re: importing

2017-10-12 Thread David Carlson
t; <https://maps.google.com/?q=12454+Auberry+Rd._Clovis,+Ca_=gmail=g>.* > *559.297.8577 <(559)%20297-8577> H* > *559.304.1751 <(559)%20304-1751> C* > > On 10/11/2017 10:00:32 PM, David Carlson <david.carlson@gmail.com> > wrote: > What O S are you installing int

Re: command line QIF import

2017-10-17 Thread David Carlson
John R. Sowden, Could you please elaborate on your assertions that 1. "errors, often based on changing amounts (2 debits, etc.,) are hidden from the user." 2. "A 'preference' switch to allow users who are familiar and comfortable with the 'Intuit Way' to continue, vs. those with accounting

Re: exporting

2017-10-23 Thread David Carlson
Are you having a problem using the Export function or is your problem with reading the output with a spreadsheet program? David C On Mon, Oct 23, 2017 at 3:58 PM, Jonathan Silvey wrote: > Hi, > > I'd like to export a single account to Excel but I can't find Export on

Re: Account report error for transactions the last 30 days

2017-10-23 Thread David Carlson
Tom, A running balance is defined on the premise that amounts are in only one account sorted in chronological order. Your find criteria cross accounts and may not necessarily be in chronological order, so it would be purely coincidental if the numbers matched a transaction report on some

Re: CSV Imports

2017-10-24 Thread David Carlson
Nick, The CSV import assistant in release 2.6 series is not able to import files created by GnuCash. This is a known problem which will be corrected when the 2.8 release comes out. That release will change the data file structure in a way that will not be readable by older releases of GnuCash.

How to install an updated Finance-Quote module in Linux

2017-11-12 Thread David Carlson
I thought I saw instructions somewhere on how to update the Finance-Quote module, but now I cannot find it. The instructions in the GnuCash FAQ are not sufficiently complete for dummies like me. I get an error gnc-fq-update command not found then I do not know what to do next. David C

Re: GNU Cash Transactions - Wiped Out

2017-11-10 Thread David Carlson
Roy, What is the name of your data file and where do you have it stored? If all the accounts are devoid of transactions, are they all present? Did you look for the backups that are mentioned in the online FAQs? David C On Thu, Nov 9, 2017 at 2:39 PM, Roy Molepo wrote:

Re: Slow startup on Windows 10, v2.6.18

2017-11-28 Thread David Carlson
Steve, As far as I know, what you are describing has been the way GnuCash works on Windows for the entire life of the 2.6 series as well as the 2.4 series releases. I am currently using various releases from 2.6.12 on to release 2.6 16 in Windows and Linux and I see the same with files saved in

Re: QIF or QXF file for Quicken to GnuCash migration?

2017-11-25 Thread David Carlson
Is there a way to export data from Quicken in QXF format? On Sat, Nov 25, 2017 at 9:50 AM, Ken Schneider wrote: > On 11/24/2017 05:15 PM, Kenneth Schneider wrote: > >> I did this a few months ago and found it best to do each quicken account >> separately. If the

Re: Could not obtain the lock

2017-11-22 Thread David Carlson
Moira, Do you have similar problems with other files on that computer? Do you check it for malware regularly? It seems a little odd that you were able to place the file there without write permission unless you do have multiple users on that computer. You may need to find an expert that is

Re: Could not obtain the lock

2017-11-22 Thread David Carlson
Moira, You have the attention of several different experienced GnuCash users from various different backgrounds, and we all share your frustration. Your experience does not match that of a typical user. In my opinion there is something unusual about your computer or how you managed to get the

Re: bank entries

2017-11-26 Thread David Carlson
Christine, If you receive income you might deposit it into the bank. If you spend money for groceries, you use cash. If you withdraw money from the bank you transfer from bank to cash. That is what double entry is about. David C, On Sun, Nov 26, 2017 at 6:33 PM, Christine via gnucash-user <

Re: Enhancement Request for GNUcash

2017-12-04 Thread David Carlson
Are you asking for GnuCash to perform magic or just pretend? David C On Dec 5, 2017 12:25 AM, "Jesse Cochran" wrote: > To whom it may concern, > > Given how limited and un-free our monetary system is nowadays, I think > GNUcash would make a great tool for the

Re: A BASH script to help get tax-related data from gnucash

2017-12-16 Thread David Carlson
Could this script be referenced somewhere in the GnuCash WIKI? David C On Sat, Dec 16, 2017 at 3:44 AM, David T. via gnucash-user < gnucash-user@gnucash.org> wrote: > I’m sorry. Your original characterization was vague, and I didn’t > understand what your issue with that report was. I see what

Re: Error in Tip of the Day

2017-12-16 Thread David Carlson
The two bug reports contain different descriptions of the reasoning behind calling it a bug, so I think that it would be appropriate to just leave them cross referenced until the situation is resolved, rather than marking one as a duplicate. David C On Fri, Dec 15, 2017 at 9:25 PM, Daniel

Re: Budget View

2017-12-14 Thread David Carlson
If you think about it, 12 columns of, say, 8 digits each will take about 9 times 12 or 108 characters aacross. That could well not even fit on your screen unless you have a very high res screen. Very few persons could see the whole thing without scrolling. There was another thread where the OP

Re: How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
at 11:20 AM, D <sunfis...@yahoo.com> wrote: > See below. > > On November 13, 2017, at 9:02 PM, David Carlson < > david.carlson@gmail.com> wrote: > > >I have been using GnuCash for many years and there are many securities in > >my file that I no longer own,

How to find out which securities need to be switched from Yahoo to Alphavantage

2017-11-13 Thread David Carlson
I have been using GnuCash for many years and there are many securities in my file that I no longer own, but I may or may not have discontinued downloading their prices. In trying to get my Alphavantage source working, it appears that it does not work if there is a mix of some securities changed

Re: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson
AAK, Yes, that is the way Gnucash behaves when you select the Update + Reconcile option while matching transactions. I rarely use that option for that very reason. I mostly use the Reconcile option. I will get on my soapbox here, since I think that the word Reconcile is not used correctly in

Re: Reconciling Manually Downloaded Transactions

2017-11-20 Thread David Carlson
the file before starting the import. I recommend saving first in every case. David C On Mon, Nov 20, 2017 at 6:57 PM, David Carlson <david.carlson@gmail.com> wrote: > AAK, > > Yes, that is the way Gnucash behaves when you select the Update + > Reconcile option while matchin

Re: Could not obtain the lock

2017-11-21 Thread David Carlson
Moira, The lock file is always in the same folder as the data file and it always has the same name as the data file with the suffix .LCK Unless you are doing something very unusual, the files will be visible in your file explorer as long as you put them somewhere in your user folder on your

  1   2   3   4   >