Re: command line QIF import

2017-10-16 Thread Liz
On Mon, 16 Oct 2017 06:52:17 -0700 (MST) Nelson wrote: > You're getting very defensive here David and your posts are not > contributing to this discussion at all. > > Gnucash is Gnucash. It isn't a Quicken-to-Gnucash project. Yes, we do get many queries about

Re: Vendor Bill - Invoice Entries

2017-10-16 Thread DaveC49
Hi Michael, Point taken. I was really commenting specifically on the in package capability of Gnucash to meet fellow_travellers's needs. It might be useful to have a list of external software that does provide additional capability to extend Gnucash somewhere on the wiki page. One of the

Re: Vendor Bill - Invoice Entries

2017-10-16 Thread fellowtraveler
Thanks CM, I’ll take a look. Given that this is a very small non-profit, I am hoping to avoid a commercial package and so far GC has (mostly) met the needs but now we’re looking at trying to have more data available that is not strictly just dollars and cents so to speak. In any case, are you

Re: Vendor Bill - Invoice Entries

2017-10-16 Thread Nelson Handcock
I think about the only way you could do it using Gnucash would be to add a series of sub-accounts that are specific to each service that you provide, and then post each bill for a service to the appropriate account. Then you could use the existing reporting available in Gnucash to show the

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

2017-10-16 Thread Joe Harrington
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 using external address of server network. server is bound to 0.0.0.0 user has full

Re: Vendor Bill - Invoice Entries

2017-10-16 Thread fellowtraveler
Michael: Thanks for the reply. I have to say, I was thinking this would be a natural function of business accounting software but I see your point about the bulk. This is a function I am currently looking into for a non-profit. Basically, we receive invoices for services which I’ve been

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: gnucash and mysql: Incorrect datetime value for column 'post_date'

2017-10-16 Thread Joerg Diederich
Hi Maf, thank you very much for this hint. I guess it points into the right direction. I've just checked my xml file and indeed, there is an entry with such a strange date. I will try to fix it as suggested and look, if I can save the data into my mysql database. Joerg On Mon, 16 Oct 2017

Importing Data

2017-10-16 Thread Rick Strupkus
I have just purchased a new laptop with Windows 10 and am trying to import the data from my old laptop onto it. Which files do I look for and how can I put them on my new machine? Rick ___ gnucash-user mailing list gnucash-user@gnucash.org

Re: Ordering Transactions on same date

2017-10-16 Thread Maf. King
On Monday, 16 October 2017 16:18:49 BST baneeishaque wrote: > Solved the problem in aneasier way... > OK. I'll bite. What is the easier way?Others in the future might benefit from your method? BTW, happy to hear that you found a solution. Cheers, Maf.

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

2017-10-16 Thread Maf. King
On Monday, 16 October 2017 17:27:13 BST Fred Bone wrote: > > A date in 1898 (as reported) looks more like a data error. I know the OP mentioned Linux - but isn't that date something to with a (fixed/ resolved) windows bug creating transactions from "before time existed" Just rings a distant

RE: Ordering Transactions on same date

2017-10-16 Thread baneeishaque
Solved the problem in aneasier way... -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to

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

2017-10-16 Thread Joerg Diederich
Hi Colin, thank you very much for the quick response to my post. I dropped the database and let gnucash create it. But I get the same error message again. Joerg On Mon, 16 Oct 2017 14:46:31 +0100 Colin Law wrote: > On 16 October 2017 at 10:50,

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

2017-10-16 Thread John Ralls
> On Oct 16, 2017, at 2:50 AM, joerg_dieder...@freenet.de 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: > > <---

Re: command line QIF import

2017-10-16 Thread Aaron Laws
On Mon, Oct 16, 2017 at 8:55 AM, Nelson wrote: > > That's why I am saying that having some flags to tuneup the import process > and detailed logging would help a lot. > It sounds like you've identified some areas for improvement. This is a volunteer project, so the

Re: command line QIF import

2017-10-16 Thread Nelson
You're getting very defensive here David and your posts are not contributing to this discussion at all. -- Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html ___ gnucash-user mailing list gnucash-user@gnucash.org

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

Migrate from Moneydance to Gnucash

2017-10-16 Thread Roger Miskowicz
Is there a recommended procedure for migrating Moneydance to GnuCash? ___ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user - Please remember to CC this list on all your replies. You can do

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: Vendor Bill - Invoice Entries

2017-10-16 Thread Mike or Penny Novack
On 10/15/2017 10:08 PM, DaveC49 wrote: Hi, The facilities you are requesting are likely to require an inventory management system. At present Gnucash is an accounting package and currently does not incorporate any features for inventory management. As far as i know there are no plans to

Re: command line QIF import

2017-10-16 Thread Nelson
There are multiple classes of failures and most of them seems to be transfers related. There are the ones a which show up more often: - missing transactions - duplicate transactions - voided transactions (transaction exist but flagged as "void" and has zero amount) - transactions in wrong account

Re: command line QIF import

2017-10-16 Thread David T. via gnucash-user
What do you mean "failed"? They aren't in the gnucash file at all? Or, they import incorrectly?  If the latter, take a look at some of the transactions that failed; is there something in common?  In my Quicken data, it was transactions that had no categories that caused the most problems. Fill