Re: gnucash update on debian errors, then stops

2017-08-02 Thread Colin Law
On 2 August 2017 at 02:24, John Griessen wrote: > I have not been able to upgrade gnucash for a while now. > > Will there be a usable gnucash in the next debian release? > If not, why not? You would probably have to direct that question to whoever packages it for Debian.

Re: Gnucash connect to remote 1and1 database server

2017-08-03 Thread Colin Law
What sort of database is it (mysql or whatever)? Can you access it by command line utilities on the PC or a simple GUI app? If so which? Colin On 3 August 2017 at 07:14, Bindiya Maharjan wrote: > > > > Hi all , > > > > I am trying to connect to remote database

Re: Duplicate transactions & OFX imports

2017-08-15 Thread Colin Law
On 15 August 2017 at 00:33, David Carlson wrote: > Hi Actinistia, > ... > Fox (how can I turn SSO off?) import assistant tends to be rather error > prone during the matching step so double chEC andtriple check before > accepting. > > This will probably be the last

Re: Ver. 2.4.11 recovery

2017-07-09 Thread Colin Law
.. On 9 July 2017 at 18:16, james wrote: > > GOOD NEWS, stroke of luck. The old lappy must have a bad mobo battery. > The date was set for 2006. So there were a few copyies made under the > 2006 date. I was able to load one of those up and it had all the data > complete

Re: Copying many transactions

2017-07-15 Thread Colin Law
On 15 July 2017 at 08:37, Harry Hall wrote: > Hi > New to forum and looking for help. > Basically I have a new iMac and my old gnucash cash accounts are on my old > windows 10 PC. > I have downloaded gnucash for mac but unable to import the export > transactions

Re: Help

2017-07-09 Thread Colin Law
On 9 July 2017 at 02:48, Joe Farrell via gnucash-user wrote: > I have just downloaded GNUCash and want to open my Quicken to import, but, I > cannot find a Qif file in all of my documents.Any ideas? You have to export a QIF file from within quicken. Colin

Re: For UK users: Will gnucash get ready for Making Tax Digital ?

2017-07-25 Thread Colin Law
On 25 July 2017 at 11:43, Dr. David Kirkby (Kirkby Microwave Ltd) wrote: > On 25 July 2017 at 05:39, John Ralls wrote: > ... > If there's no desire/developer time to support this, then its not worth > giving it any more consideration. But IF

Re: For UK users: Will gnucash get ready for Making Tax Digital ?

2017-07-27 Thread Colin Law
On 27 July 2017 at 16:31, Alain Williams wrote: > On Thu, Jul 27, 2017 at 10:22:40AM -0500, Tommy Trussell wrote: > >> SO (in my opinion, not a UK citizen, other disclaimers applicable, etc.) >> it's not a mathematical problem, it's a political one. > > +1 > > Which comes back

Re: Scheduled transactions for part year

2017-08-09 Thread Colin Law
On 8 August 2017 at 21:21, IanM wrote: > New to gnucash so finding it a bit difficult to get my head round details > Council tax (UK property tax) is paid by 10 regular monthly payments each > year (i.e. 2 months with no payment). Can this be done with scheduled >

Re: GnuCash

2017-08-06 Thread Colin Law
On 6 August 2017 at 18:06, Frank H. Ellenberger wrote: > Hi Jerry, > > Am 06.08.2017 um 04:15 schrieb Jerry Lanese: >> Frank, >> I am a small business owner trying to use GNUCASH and having some problems. >> Is there anyone I can call. > > We have a moderated user

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

2017-08-18 Thread Colin Law
I am not sure exactly what you mean. Can you explain a bit more about the situation you are in, and how you got to that position? Colin On 18 August 2017 at 16:24, Paul W. wrote: > I have multiple bank deposit items showing in a single, multi-split > transaction. > Is

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

2017-08-20 Thread Colin Law
transaction for each deposit item. > > > -- Original Message -- > From: Colin Law <clan...@gmail.com> > To: "Paul W." <pfwoolver...@juno.com> > Cc: "gnucash-user@gnucash.org" <gnucash-user@gnucash.org> > Subject: Re: Is there a GC functio

Re: How to close a financial year

2017-05-16 Thread Colin Law
On 16 May 2017 at 10:53, David T. via gnucash-user wrote: > Anita, > This is discussed pretty much every year on the list. Try googling "close > books gnucash site:lists.gnucash.org". You should find plenty of reading. Also note that there may be no need for you to

Re: Unsplitting vendor account

2017-05-23 Thread Colin Law
On 23 May 2017 at 15:43, Rich Shepard wrote: > On occasion I'll split an expense for a vendor (e.g., a supermarket) into > two or more accounts (e.g., groceries and household goods). The next time I > purchase something from that same vendor the transfer column

Re: Reconciling an account

2017-06-04 Thread Colin Law
Chris If the reconcile window shows the same starting balance as your statement does and you have set the ending balance to that from the statement then after you tick off all the transactions from the statement then you should end up with a reconcile difference of zero. If you don't get zero then

Re: Reconciling an account

2017-06-04 Thread Colin Law
the > end balance; the end balance chages to match the Gnucash opinion of the > balance for that date. If that does not match the statement then more work > is needed. Mike > > > > > Sent from Samsung tablet > > > > -------- Original message > From Co

Re: Reconciling an account

2017-06-04 Thread Colin Law
it reconciled. > Also make sure you enter in the correct statement ending balance. > -derek > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity or typos. > > On June 4, 2017 11:07:01 AM EDT, Colin Law <clan...@gmail.com> wrote: >>So what do you d

Re: Notes column in SingleLine display

2017-06-18 Thread Colin Law
I think he/she wants both description and notes side by side in single line mode. @azalea4va before deciding that the feature does not need to be optional, try it on a 1024 width display with the tabs down the side. Colin On 18 June 2017 at 21:21, David Carlson

Re: Gnucash file is getting long!

2017-06-14 Thread Colin Law
What do you mean by 'quite large'? I have 15 years of (personal) data in mine and would not split it unless force to. It is great to be able to so easily look back to see when and where I bought the dishwasher (or whatever) and how much it cost. Mine is1.9 MBytes (compressed xml). Colin On 14

Re: Gnucash file is getting long!

2017-06-14 Thread Colin Law
On 14 June 2017 at 12:33, David Carlson wrote: > ... > My solution so far has been to buy a more powerful computer and use Ethernet > instead of WiFi to attach to the data file. Yes, a file save through WiFi > takes well over a minute for my data file which is now

Re: Reconciling an account

2017-06-06 Thread Colin Law
Have you tried the earlier suggestion of splitting the statement every few transactions and treating each group of three or four transactions as a separate statement and reconciling each group separately. Then you will tie the problem down to three or four so you should be able to see what is

Re: Reconciling an account

2017-06-05 Thread Colin Law
Have you possibly entered a transaction the wrong way round (debit instead of credit or vise versa)? Then not noticed this when you tick it off? A suggestion earlier may be a good one if you still cannot find where you are going wrong. Draw lines on your statement after every, say, 4 entries.

Re: Backup help

2017-09-20 Thread Colin Law
Just to point out that database replication might not be considered a good form of backup. It copes with something like a disc crash but if, for example, a user or bug were accidentally to delete large sections of the db then that deletion would be copied to the slave database. Unless I

Re: importing

2017-10-10 Thread Colin Law
Are there any of the backups there somename.gnucash.nnn? The number string is the date/time that it was taken. These will be mixed up with the log files so you may not have noticed them. Colin On 10 October 2017 at 14:30, Frankie Raney wrote: > Did a search,

Re: Save to MySQL

2017-10-05 Thread Colin Law
eOn 4 October 2017 at 12:23, Joseph Hesse wrote: > I would like to save my data into a MySQL database. Please inform me how to > do this. I am familiar with MySQL and queries, I would like to end up with a > database with relevant tables. > If you have the right options

Re: MariaDB error 2003: Can't connect to MySQL server on x.x.x.x

2017-10-17 Thread Colin Law
On 16 October 2017 at 23:03, Joe Harrington wrote: > Server and client are each on machines connected to different local > networks. > gnucash version 2.6.18 (3a9fbb8) and MariaDB 10.1.26 (xampp v.7.1.9-0-VC14) > all machines running Windows 10 > > trying to open db

Re: [MAINT] More network maintenance for Saturday

2017-10-13 Thread Colin Law
You have probably already checked, is there a s/w upgrade available for the modem? Colin On 13 Oct 2017 3:36 a.m., "Derek Atkins" wrote: > > On Thu, October 12, 2017 9:58 pm, Fred Smith wrote: > > On Thu, Oct 12, 2017 at 11:21:12AM -0400, Derek Atkins wrote: > >> Alas, not the

Re: gnucash and mysql: Incorrect datetime value for column 'post_date'

2017-10-16 Thread Colin Law
On 16 October 2017 at 10:50, wrote: > Hello, > > I'm trying to convert my existing gnucash account from xml to mysql. I > created a new mysql database, but when I try to save my data into this > database with gnucash I get the following error message: Don't

Re: Account report error for transactions the last 30 days

2017-10-13 Thread Colin Law
Hi Tom Can you provide a screenshot showing what you mean? Colin On 12 October 2017 at 20:00, Tom B wrote: > I have been using GnuCash for the past few months after importing from > Quicken. Great application and very pleased with it as a double-entry > system.

Re: Newbie Question

2017-09-06 Thread Colin Law
All the account data is in a single file, whose name depends on what you called it when you did the first save, something like myaccounts.gnucash. If you have moved that file then when you open GC it will try to reopen the original and will show an error when it can't find it. Just ignore that

Re: GC 2.6.99 built from git rev d96bb3ebd+ corrupts MySQL db

2017-09-06 Thread Colin Law
On 6 September 2017 at 22:04, Art via gnucash-user wrote: > ... > ...So I assumed it should be working, but as soon as I do a file open on my > db, I get a pop-up, The server at URL mysql://root@localhost/gc2017 > experienced an error or encountered bad or corrupt

Re: FW: [reminderfox] [ReminderFox #915] ..

2017-09-28 Thread Colin Law
tried the "back & restore" with no luck at all. I am absolutely devastated. I had irreplaceable data in Reminder Fox. Can I used a restore point to go backing time, maybe??? -----Original Message- From: Colin Law [mailto:clan...@gmail.com] Sent: Tuesday, September 26, 2017 2:52 PM To:

Re: Pointer location not accurate

2017-10-03 Thread Colin Law
On 3 October 2017 at 16:15, Alan Magnus wrote: > Since upgrading to GnuCash 2.6.18 I have noticed that the pointer position is > off. To select anything, I have to position the pointer one row above the > desired item. Han anyone else seen this? Which operating system

Re: FW: [reminderfox] [ReminderFox #915] ..

2017-09-28 Thread Colin Law
> On donderdag 28 september 2017 08:12:32 CEST Colin Law wrote: >> Just saying you had no success does not give us any clues about what you >> did. >> >> Did you look at the link I posted to find your reminders? If so, what did >> you see where the link says to loo

Re: Chart of Accounts cannot be uploaded to Android

2017-08-28 Thread Colin Law
On 28 August 2017 at 10:09, john_mike wrote: > Dear All, > > Firstly I am entering this via nabble. I remain confused as to the > difference between nabble and the mailing list and how to access the mailing > list once subscribed to it. Which I have done. It

Re: Budget Slowing Down Windows 10

2017-08-25 Thread Colin Law
The point about memory is a good one @proberts042 I assume that Windows has a system 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

Re: Version Migration

2017-08-29 Thread Colin Law
On 29 August 2017 at 16:36, james wrote: > Hello all, > > Background > So I've been running on gnucash 2.4.11 for some years. > it's been great, the only problems were my lack of > knowledge of finance. I want to migrate to version 2.6.15 > (using gentoo linux). > > > My only

Re: bad and corrupt data

2017-09-01 Thread Colin Law
On 31 August 2017 at 17:08, Sandro Grech wrote: > Dear All, > I’ve been trying to save data on server. But the below error is cropping up. > I am positive that privileges are correctly set. 1. Are you saving to a mysql database on purpose? 2. If so, have you got a mysql

Re: Could not obtain the lock

2017-09-01 Thread Colin Law
On 1 September 2017 at 11:51, Alain Dormoy wrote: > Hi! > > More often than not, when I launch GnuCash, I get the message: > > Gnucash could not obtain the lock for file:\...\filename.gnucash > > I click "Open anyway" and it works normally. So I can't say I really care but >

Re: bad and corrupt data

2017-09-01 Thread Colin Law
e. Alternatively try giving the db a different name in the Save dialog. Colin > > On Fri, Sep 1, 2017 at 12:22 PM, Colin Law <clan...@gmail.com> wrote: >> >> On 31 August 2017 at 17:08, Sandro Grech <sandro.c.gr...@gmail.com> wrote: >> > Dear All, >> &g

Re: Question on mysql "account" table

2017-10-11 Thread Colin Law
If you use joins on the guid values to the parents then you should be able to get them directly using the appropriate queries. Colin On 11 October 2017 at 14:31, Joseph Hesse wrote: > Here is an example of what I am trying to do. My expenses in gnucash have > items that

Re: bank entries

2017-11-26 Thread Colin Law
Have you read the tutorial and concepts guide? [1] It sounds like you are making a basic mistake in how you are entering it. Colin [1] http://www.gnucash.org/docs/v2.6/C/gnucash-guide/ On 26 November 2017 at 21:52, Christine via gnucash-user wrote: > Whenever I post

Re: Finance-quote

2017-11-22 Thread Colin Law
Look back at posts here over the last week or so to see that a large number of messages relate to this issue. You should find help there. Colin On 22 November 2017 at 13:42, Xavier LAROSE wrote: > How can I see what version of FQ I am running ? > When I download FQ on the

Re: gnucash-user Digest, Vol 176, Issue 55

2017-11-27 Thread Colin Law
an reach the person managing the list at >> gnucash-user-ow...@gnucash.org >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of gnucash-user digest..." >> >> >> Today's Topics: >> &g

Re: Unable to open 2nd set of accounts on one MacBook Pro

2017-11-25 Thread Colin Law
On 25 November 2017 at 04:24, D via gnucash-user wrote: > Actually, I believe the Mac situation *is* unique, in that a user cannot > double click a Gnucash file from the operating system and have Gnucash open > that file. Maybe it is also this way on Windows and Linux,

Re: linux version

2017-12-01 Thread Colin Law
Is gnucash-docs installed? Colin On 30 November 2017 at 15:15, Mrbeezer wrote: > I recently ntly installed GnuCash 2.6.18 on a windows system and a Linux > Mint install on a LT. when I try to use the help function in Linux, I get > an error that the installed link to the

Re: Gnucash + mysql

2017-12-17 Thread Colin Law
On 18 Dec 2017 7:04 a.m., "wp.rauchholz" wrote: Is am trying to setup gnucash and access mysql on my homeserver. Is there a \cookbook' how to do this? I googled and there does not seem to be a lot Assuming you have setup your mysql server then check whether the File,

Re: errir in SQL syntax

2017-12-17 Thread Colin Law
Does that happen when you try to save from within gnucash? Colin On 18 Dec 2017 7:19 a.m., "Wolfgang Paul Rauchholz" wrote: My config: Linux CENTOS 7, mariadb-5.5.56-2.el7.x86_64 Setting up the database on my home server. Will connect fomr laptops in the network onto

Re: Gnucash + mysql

2017-12-18 Thread Colin Law
access from laptop > (CENTOS and WINDOWS) tot he database. > > > On Mon, Dec 18, 2017 at 8:42 AM, Colin Law <clan...@gmail.com> wrote: >> >> >> >> On 18 Dec 2017 7:04 a.m., "wp.rauchholz" <wp.rauchh...@gmail.com> wrote: >> >> Is am

Re: Gnucash + mysql

2017-12-18 Thread Colin Law
form several laptops to the database (not > concurrent) > > > On Mon, Dec 18, 2017 at 1:15 PM, Colin Law <clan...@gmail.com> wrote: >> >> On this list when replying you have to use Reply All (or similar) >> otherwise your reply just goes to the previous poster (as yours d

Re: gnucash coredump gnome

2017-12-20 Thread Colin Law
f Ubuntu, it just makes sure everything is up to date for that version). Obviously report if that shows any errors. . Colin > > > Original Message > Subject: Re: gnucash coredump gnome > From: Colin Law > To: Cliff McDiarmid > CC: gnucash-user@gnucash.org >

Re: GnuCash user list

2017-11-21 Thread Colin Law
On 21 November 2017 at 15:15, snwleopard1 wrote: > Hello, > > How connect to GnuCash user list ? > I would like to know how to continue using GnuCash with high Sierra Register at https://lists.gnucash.org/mailman/listinfo/gnucash-user Colin

Re: GnuCash user list

2017-11-21 Thread Colin Law
LAROSE <snwleopa...@gmail.com> wrote: > I am already registered but can’t find my way when logged in > -- > Xavier > > Le 21 novembre 2017 à 16:51:39, Colin Law (clan...@gmail.com) a écrit: > > On 21 November 2017 at 15:15, snwleopard1 <snwleopa...@gmail.com> w

Re: Outgoing personal loan clarification

2017-11-02 Thread Colin Law
On 2 November 2017 at 08:19, Tony Vanson wrote: > Hi all, > First time here, so please excuse my accounting ignorance. > Whilst I understand some of the GnuCash basics, I have a problem which I’m > hoping I can get some help on. > I’m currently residing overseas and we

Re: Price Editor

2017-11-04 Thread Colin Law
On 4 November 2017 at 21:12, Jim Muchow wrote: > I know that the stock quotes feature is having issues, so I decided > that since I don't have so many and I don't need any more than > Friday's prices, to try to enter stock/fund prices manually. > > This doesn't seem to

Re: Price Editor

2017-11-04 Thread Colin Law
On 4 November 2017 at 22:10, Jim Muchow <jamesdmuc...@gmail.com> wrote: > On Sat, Nov 4, 2017 at 4:39 PM, Colin Law <clan...@gmail.com> wrote: >> On 4 November 2017 at 21:12, Jim Muchow <jamesdmuc...@gmail.com> wrote: >>> I know that the stock quotes fe

Re: linux version

2017-12-03 Thread Colin Law
th the sw? > > > Dick > > -Original Message- > From: Colin Law [mailto:clan...@gmail.com] > Sent: Friday, December 01, 2017 01:44 > To: Mrbeezer > Cc: gnucash-user@gnucash.org > Subject: Re: linux version > > Is gnucash-docs installed? > > Colin

Re: linux version

2017-12-01 Thread Colin Law
ot unless it is installed via aapt-get install gnucash. Perhaps my question was not sufficiently detailed. What I meant was that you should check to see if gnucash-docs is installed and if not then you should consider installing it. Colin > > Dick > > -Original Message----- > From

Re: Transfering Data

2017-10-25 Thread Colin Law
On 25 October 2017 at 18:57, Rick Strupkus wrote: > I have a new laptop and want to transfer the gnucash data from my old one > to the new one. What files do I copy and how do I import them properly to > the new computer? This should help you

Re: GNUCash Android Companion App Balances

2017-10-22 Thread Colin Law
On 22 October 2017 at 08:54, john_mike wrote: > Good Morning All, > ... > I am just slightly concerned that these incorrect balances could in someway > be reflected on my desk top version. I cannot think how this could be as I > will be importing the individual

Re: General Journal - history limit and search

2017-10-31 Thread Colin Law
On 31 October 2017 at 16:39, Roger Oliver wrote: > I notice my general journal only goes back to the beginning of Octuber. Try View > Filter By and on the Date tab click Show All Colin ___ gnucash-user mailing list

Re: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

2018-04-28 Thread Colin Law
On 28 April 2018 at 08:03, vince wrote: > Hello the list, > I've installed the above version of gnucash on lubuntu 16.04,(also a new > install) and cannot get gnucash to open. This is on a older Dell precision > workstation 390. > > The gnucash.trace report in /var says "*

Re: [GNC] gnucash v2.6 new install can't open on lubuntu 16.04?

2018-04-28 Thread Colin Law
On 28 April 2018 at 09:24, vince <hallvinc...@gmail.com> wrote: > On 04/28/2018 09:12 AM, Colin Law wrote: > > On 28 April 2018 at 08:03, vince <hallvinc...@gmail.com> wrote: > >> Hello the list, >> I've installed the above version of gnucash on lubuntu 16.0

Re: [GNC] data file

2018-05-25 Thread Colin Law
The accounts file will be in the same folder as the backups, with the name starting the same as the backups. Colin On 25 May 2018 at 21:58, David Griffin wrote: > Yes, I was opening the back-up and that is what caused the problem. The > list I thought is only

Re: [GNC] inflatevalidate

2018-06-15 Thread Colin Law
On 15 June 2018 at 17:19, tom9...@earthlink.net wrote: >I just re-installed Windows 10 on a Dell Inspiron 560 computer. When I >re-setup GnuCash 3.1 and tried to open the program, I got the following >error message: >The procedure entry point inflateValidate could not be located

Re: [GNC] what do I do after crash

2018-06-15 Thread Colin Law
Tell us which version of gnucash you are using and what operating system you are using. Open gnucash, accept any warnings or errors that appear as it tries to re-load the last accounts file used then use File > Open to browse to where your accounts file is (it will be wherever you last saved it

Re: [GNC] copying files

2018-05-30 Thread Colin Law
On 30 May 2018 at 21:02, Varda Rotenberg via gnucash-user < gnucash-user@gnucash.org> wrote: > > Hi: > I can copy the gnucash data from my desk top and back with no problem. > However, when I place the flush card in my laptop it reads as "read only" I > did edit the account and took the place

Re: [GNC] copying files

2018-05-31 Thread Colin Law
: > It.s read only on both and there is no restrction. In Linux it is 777. > > > > Sent from my Verizon, Samsung Galaxy smartphone > > > Original message ---- > From: Colin Law > Date: 5/30/18 4:09 PM (GMT-05:00) > To: Varda Rotenberg > Cc: gnucash-user

Re: [GNC] copying files

2018-05-31 Thread Colin Law
gt; > Sent from my Verizon, Samsung Galaxy smartphone > > > Original message > From: Colin Law > Date: 5/31/18 2:33 AM (GMT-05:00) > To: varda241 , gnucash-user > Subject: Re: [GNC] copying files > > Please reply to the list, not just to myself, Re

[GNC] Build on 18.04

2018-07-01 Thread Colin Law
Following the instructions for building GC 3.x on the wiki [1] has been accomplished on Ubuntu 18.04 with little difficulty, so many thanks to the contributors to the wiki. Just one small issue so far, the icons to the left of the account names are all showing as a little no entry sign, which I

Re: [GNC] My bad

2018-07-01 Thread Colin Law
The easiest way is to open the backup file and Save As the original file as you have suggested. You could rename it instead but then you would have to use File Open to open it (as GC defaults to opening the last file used as you noticed). Log files are not used by the system after they are

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
Actually I see there are more icons missing, such as the Split button icon in the toolbar. It seems that the missing files are the png files from data/pixmaps/hicolor/?/actions. Are these supposed to be copied somewhere by make install? Colin On 1 July 2018 at 11:21, Colin Law wrote

Re: [GNC] Build on 18.04

2018-07-02 Thread Colin Law
txt. There aren't any conditionals. > > Does your build directory have share/gnucash/icons? > > Regards, > John Ralls > > > > On Jul 1, 2018, at 10:33 AM, Colin Law wrote: > > > > I have just rebuilt (on 18.04) using the exact same commands and my > > manife

Re: [GNC] Build on 18.04

2018-07-02 Thread Colin Law
there is a problem with the above cmake instruction, if it does then for some reason that does not work on my cmake. For reference my cmake is 3.10.2-1ubuntu2 Colin On 2 July 2018 at 08:37, Colin Law wrote: > @John > > I see in src data/pixmaps/CMakeLists.txt the list of icons. I

Re: [GNC] Build on 18.04

2018-07-02 Thread Colin Law
On 2 July 2018 at 14:26, Roger Miskowicz wrote: > I renamed the icon folder and executed sudo make install and the icon > folder was recreated. > With all the icons in it? Colin > > Roger > > > On Mon, Jul 2, 2018 at 9:05 AM Colin Law wrote: > >> Well

Re: [GNC] Upgrading GC under Ubuntu

2018-07-02 Thread Colin Law
the regex. The one to output to /usr/local/share/icons is working correctly. I am using bash too. It doesn't make sense. I am at a loss to know what to try next. Colin On 2 July 2018 at 17:53, Stephen M. Butler wrote: > On 07/02/2018 07:31 AM, Colin Law wrote: > > On 29 June 2018

Re: [GNC] Change Reconcile Starting Balance

2018-06-30 Thread Colin Law
mark your current transactions and any earlier ones that >> were missed before (such as your opening balance transaction, say), and >> they balance out. >> >> David >> >> On June 30, 2018, at 8:23 AM, Roger Miskowicz wrote: >> >> Thanks Colin. >> >&g

Re: [GNC] Upgrading GC under Ubuntu

2018-06-30 Thread Colin Law
Ubuntu 18.04 is currently ahead of getdeb, at version 2.6.19 Colin On 29 June 2018 at 21:33, David Carlson wrote: > Before 'rolling your own' GnuCash, check out Getdeb.net. They may not have > 3 series yet, but they are up to 2.6.17 at least, if not later. > > David C > > On Fri, Jun 29, 2018

Re: [GNC] Change Reconcile Starting Balance

2018-06-30 Thread Colin Law
The starting balance in the reconcile start dialog will be the nett balance of all reconciled transactions so far. Is this the first time you have reconciled it? If not then it should be the same as the ending balance the last time you reconciled, unless you have editted a reconciled transaction.

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
ild > cd build > > cmake -D WITH_AQBANKING=OFF -D WITH_OFX=OFF ../gnucash > cmake .. > > make > > and the install_manifest.txt include the 'icons' directory. > > > Hope this helps, let me know if you would like to try something else. > > Roger > > > On S

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
their icons Colin On 1 July 2018 at 13:39, Colin Law wrote: > Actually I see there are more icons missing, such as the Split button icon > in the toolbar. It seems that the missing files are the png files from > data/pixmaps/hicolor/?/actions. Are these supposed to be copied > somew

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
png file is pixmaps/gnucash_splash.png There is no reference to /usr/local/share/gnucash/icons in the output of sudo make install. Colin Colin > > On Sun, Jul 1, 2018 at 10:55 AM, Colin Law wrote: > >> In the trace file I see around a dozen lines similar to >> >> * 13

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
gtkbuilder migratable-prefs.xml scm ui Colin > Regards, > John Ralls > > > > On Jul 1, 2018, at 10:33 AM, Colin Law wrote: > > > > I have just rebuilt (on 18.04) using the exact same commands and my > > manifest does not include th

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
On 1 July 2018 at 19:14, Colin Law wrote: > On 1 July 2018 at 18:58, John Ralls wrote: > >> data/pixmaps/CMakeLists.txt. There aren't any conditionals. >> >> Does your build directory have share/gnucash/icons? >> > > No > > $ ls share/gnucash/ &g

Re: [GNC] Build on 18.04

2018-07-01 Thread Colin Law
ws: > > $ ls > accounts/ gnucash.1icons/ > migratable-prefs.xml scm/ ui/ > checks/gtkbuilder/ make-prefs-migration-script.xsl > pixmaps/ tip_of_the_day.list > > > On Sun, Jul 1, 2018 at 3:23 PM Colin Law wrote: > >> On 1 July

Re: [GNC] Build on 18.04

2018-07-02 Thread Colin Law
> > Note: I will be away for the rest of the day, > > Roger > > > On Mon, Jul 2, 2018 at 9:28 AM Colin Law wrote: > >> On 2 July 2018 at 14:26, Roger Miskowicz wrote: >> >>> I renamed the icon folder and executed sudo make install and the icon >>> f

Re: [GNC] Upgrading GC under Ubuntu

2018-07-02 Thread Colin Law
On 29 June 2018 at 20:50, Stephen M. Butler wrote: > ... > Having just done a download and compile to my Ubuntu 18.04, let me share > with you what I did. Sometimes reading the web sites leaves one (at > least me) scratching their head vigorously -- in my case not a good idea > with the hair I

Re: Dealing with a large QIF file

2017-12-24 Thread Colin Law
You should be able to export one account at a time from Quicken, I think. Then import them one at a time. Colin On 24 December 2017 at 19:02, Cliff McDiarmid wrote: >Hi > >I'm importing a large QIF file(a current a/c)about 6000 entries. >There are about a

Re: DELETING OLD GNU CASH ACCOUNTS

2018-01-08 Thread Colin Law
On 6 January 2018 at 21:37, LEE HOYER wrote: > Good day faithful persons, Would like to eradicate all old GnuCash accounts > because they went crazy a month ago with unusual descriptions in description > spaces. I had done a restore on system on my Windows 7 OS to cause

Re: closing accounts and unreconciled transactions

2018-01-08 Thread Colin Law
You could just adjust the opening balance accordingly and reconcile that transaction so that the reconciled balance is at what it should be. Colin On 8 January 2018 at 15:10, Jeff Abrahamson wrote: > In moving my accounts to gnucash, I see that I have some unreconciled > accounts

Re: Installing GnuCash using GoDaddy MySQL Server

2018-01-15 Thread Colin Law
On 16 January 2018 at 06:34, Jim_S wrote: > I am trying to install gnuCash using a MySQL database hosted by GoDaddy. We > also use GoDaddy for our WordPress web page, so I already have the hosting > account. GnCash keeps giving me an error "The server at URL >

Re: Manually entering historic records

2018-01-14 Thread Colin Law
On 14 January 2018 at 09:59, Gregory L. Davis wrote: > Trevor: > > It sounds to me like you have to increase the number of days for "Read only" > transactions. Try clicking on the file menu, then preferences. In the > "Accounts" tab, increase "Day Threshold for Read-Only

Re: Read only transactions

2018-01-14 Thread Colin Law
What have you specified for Day Threshold for Read-Only Transactions (red line): in Edit > Preferences > Accounts? Colin On 14 January 2018 at 12:04, Cliff McDiarmid <cliffhan...@gardener.com> wrote: > Sent: Saturday, January 13, 2018 at 5:22 PM > From: "Colin

Re: Messed up file names

2018-01-20 Thread Colin Law
similar, put it in the new PC, open gnucash then use File > Open in the menus, browse to the file on the stick and open it. Then assuming it looks ok use File > Save As to save it where you want on the pc. Colin > > On Fri, Jan 19, 2018 at 11:27 PM, Colin Law <clan...@gmail.com> wr

Re: New File Name ??

2018-01-24 Thread Colin Law
you can see if the track is continuous down the original file, then switches to the new file and stays there, in which case the new file should have everything in it. If the timestamps of the two file tracks are interleaved then you have a bigger problem. Colin > > > On Wed, Jan 24, 2018, at 2:

Re: Read only transactions

2018-01-13 Thread Colin Law
On 13 January 2018 at 17:12, Cliff McDiarmid <cliffhan...@gardener.com> wrote: > > >Sent: Saturday, January 13, 2018 at 4:58 PM > >From: "Colin Law" <clan...@gmail.com> > >To: "Cliff McDiarmid" <cliffhan...@gardener.com> > .Cc: g

Re: Read only transactions

2018-01-13 Thread Colin Law
On 10 January 2018 at 19:21, Cliff McDiarmid wrote: >Hi > >I still haven't sorted my Quicken import, getting the correct balances >without a 'balance adjustment' is difficult. > Add (or adjust) an appropriate opening balance. > >But the question is:

Re: New File Name ??

2018-01-24 Thread Colin Law
On 24 January 2018 at 13:57, Mike Stillingfleet < mikestillingfl...@fastmail.co.uk> wrote: > Dear All, > > I have just noticed (after doing a lot of work on GNU Cash) that the file > name has changed. I now have a file call Bank Expenses.gnucash. > > When I click on file I see my old file name

Re: Reconcile problem

2018-01-31 Thread Colin Law
On 30 January 2018 at 22:22, oldpopsie wrote: > I used to be able to changetheending balance when I set up a reconcile for > a > month. All ofa sudden, i have a new version/build of Gnucash and it won' > t let me change the ending balance i am trying to reconcile to.

Re: Scheduled Transactions

2018-02-06 Thread Colin Law
On 6 February 2018 at 16:52, Dennis West wrote: > When I first started with Gnucash recently, I imported a rather large QIF > file. All the accounts appear to have imported correctly but I can't find > any sign of transactions that were "scheduled" in Quicken. Am I correct

  1   2   3   4   5   6   >