Jmathew07 | 28 Jul 12:23 2014
Picon

coming from Quicken Cashbook

I imported all my data from Quicken about 20 years worth into Gnucash.
The resulting XML file is about 4Mb.

Now Gnucash is slow to open.  If I hit the report button it really is slow.

I read that if the DB is in SQLITE  then you could open it in MS ACCESS. 
perhaps this would let me write reports using ACCESS.

Is there some documentation on a reliable and easy way to get ACCESS to
connect to the GNUCASH DB?

Thanks in advance

--
View this message in context: http://gnucash.1415818.n4.nabble.com/coming-from-Quicken-Cashbook-tp4672074.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Rolf Endres | 28 Jul 08:31 2014
Picon
Picon

re: update release

   Hi John,

   I saw that - only concern is that the gap between the last nightly
   build and the targeted next release is five months, which means that I
   will lack OFX import for two months worth of data, as my bank only
   provides three months of history :-)!

   Rolf

   On Jul 27, 2014, at 7:30 PM, Rolf Endres <rendres <at> gmx.de> wrote:
   >   Hi all,
   >
   >   Are there any plans for a general update release?
   >
   >   I'm having some issues with aqbanking, as described in
   >   https://devel.aqbanking.de/trac/aqbanking/ticket/212 . Apparently,
   they
   >   have been resolved in a new version of Gwenhyfar - however,
   considering
   >   that I'm running with a Windows version, I don't believe there is
   any
   >   way of upgrading that without instlaling a newly compiled exe
   file...
   http://wiki.gnucash.org/wiki/Release_Schedule
   Regards,
   John Ralls
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
(Continue reading)

JOSEPH AIELLO | 28 Jul 02:15 2014
Picon
Picon

using google drive

I am a new user again with  ver2.6.3.
Since now I am starting to use the cloud, is there a way to put Gnucash files in Google Drive?
I would like to access  the file  from computers in different locations.

...thanks     ..... joe
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Rolf Endres | 27 Jul 20:30 2014
Picon
Picon

(unknown)

   Hi all,

   Are there any plans for a general update release?

   I'm having some issues with aqbanking, as described in
   https://devel.aqbanking.de/trac/aqbanking/ticket/212 . Apparently, they
   have been resolved in a new version of Gwenhyfar - however, considering
   that I'm running with a Windows version, I don't believe there is any
   way of upgrading that without instlaling a newly compiled exe file...

   Cheers!
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Jmathew07 | 27 Jul 09:59 2014
Picon

Bank Feeds for Australian Banks?

Anyone from Australia using Gnucash?  

I wonder if anyone has setup bank feeds from the Commonwealth bank using the
Gnucash wizard?

The banks as usual pretend they don't know anything about this here, they
only seem to allow it for Reckon and XERO - both of whom do it badly anyway!

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Bank-Feeds-for-Australian-Banks-tp4672052.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Jmathew07 | 27 Jul 09:57 2014
Picon

Import and auto-Categorise?

I know that transactions get Auto Allocated to Accounts (Income/expense)
based on previous exports.  But they are based on exact matches.
Is there a way to auto allocate based on say    PAYEE begins with or
contains?

Is there a lookup file that one can get in and modify?

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Import-and-auto-Categorise-tp4672051.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

mark | 26 Jul 18:23 2014
Picon

date field in 2.6.3 reports

First, my apologies if this topic had been addressed (and for inadvertantly 
sending it to the wrong address.) I recently upgraded to 
2.6.3 and when setting up my packing slips, invoices, quotes etc I cannot get 
the current days date to appear. I use custom headers and the report generated 
fields appear under them. The missing date field was located right justified just 
under my header. I've fooled around in edit/preferences, and the report and 
style sheet options. I've tried creating style sheets and reports based on 
various templates to no avail. Is this feature still available? Once posted 
the posting date and due date appear above the items list, left justified.

What I'd really like is for the date the invoice was created to appear but I 
never found an easy way to do that The feature would be nice as I often fill 
orders in multiple shipments on different days and the packing slips and 
ultimately the invoice all have different dates on them. I once tried to learn 
the scripting language used for these reports but never felt comfortable 
mucking about with them. If anyone knew how to do that I could probably follow 
direction
--

-- 
Mark Baustian
Spencer, New York
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Larry Moore | 26 Jul 10:37 2014
Picon

reset configuration defaults

I have made an error in configuration and would like to reset the defaults,
but cannot find a way to do this. Please help.

later....
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.

Mark Seeba | 26 Jul 01:11 2014

2.6.3 Barcodes on Reports?

I just upgraded to 2.6.3 and now my aging receivables report has what look like barcodes where the dollar
amounts used to be.
How do I get my report back?

Any help would be greatly appreciated.

Thanks.

Mark Seeba
MCSE: Communication
Streamwrite
Latest News: http://streamwrite.com/blog/
Direct: 510-923-9210
Fax: 510-420-4970
Service Desk: 800.333.8394 (Option 4)
www.streamwrite.com<http://www.streamwrite.com/>

[MCSE_2013(rgb)_1508]

This e-mail (including any attachments) may contain information confidential to ATI and is intended only
for the use of the intended recipient(s). If the reader of this message is not the intended recipient(s),
you are notified that you have received this message in error and that any review, dissemination,
distribution or copying of this message is strictly prohibited. If you have received this message in
error, please delete this message and notify the sender immediately.

_______________________________________________
gnucash-user mailing list
(Continue reading)

m shires | 24 Jul 17:34 2014
Picon

64 bit

I am a new user, sort of.  I installed the program a while back (March of
2014) and tried using it.  I love the double entry accounting concept so I
can run my personal finances like a business.

But, I ended up uninstalling it because of problems.

1.  I had a 32 bit program.  I run a 64 bit Windows but can't find the
GnuCash 64 bit version.  Can someone explain this?

2.  At some point in setting things up it presented a very confusing
request to set up a database bin location.  After fumbling through this
confusion, I set up a database file location approved by GnuCash (or
acknowledege by it, anyway), using my name; but whenever I try to launch
the program I get a "cannot find bin....." error message.

3.  I uninstalled the program and reinstalled it, and upon launch got the
same message!  So I went to my computer directory and deleted the GnuCash
Bin files, then uninstalled it again.

Before I reinstall and start a "do-over", I would like to understand what
is going on, why the databases are not integrated into the program, and why
there is not a 64 bit version, and what all this stuff about bin files is.

Thanks!
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-user
-----
Please remember to CC this list on all your replies.
(Continue reading)

John Ralls | 24 Jul 09:40 2014
Picon

Re: OFX Bayesian import not working for me


On Jul 24, 2014, at 5:02 AM, Eliot Rosenbloom <eliot <at> prosocialleadership.net> wrote:

> Thanks, John.  Not that I'm aware of.  I futzed around a little with MAMP in the last few months, but not in
connection with GC.  And I use Filemaker a lot (installed v 13 in April).  But that's as close as I get to SQL.
> 
> In April, because of a problem with Mac's Calendar app that Apple couldn't fix, they had me create
completely anew my daily (non-admin) account, and then transfer from the old account as little as
possible (so as not to bring the problem with me).  I spent 2 or 3 days recreating settings and the like.  Might
some GC file (perhaps in one of the libraries) not have been copied to the new account and be causing my problem?
> 
> I thumbed thru all the GC Preferences, and nothing jumped out at me (tho I don't understand them all).  (I
didn't see anything re: choosing XML or SQL).
> 
> I'm not sure, or have only a general sense of, what you are referring to re: "account associations or file backend."
> 
> (I'd have responded sooner, but my GnuCash Thunderbird folder got nested, and I didn't check my web
posting and see your response untill just now.)
> 

Please remember to copy the list on all replies by using "reply all" (the double-arrow).

The backend is selected when you save the file the first time, at the top of the save dialog. Since you didn't
know that, you're probably using the XML backend and have been right along.

All of GC itself is in GnuCash.app, but its preferences are in
~/Library/Preferences/org.gnucash.Gnucash.plist, other things it keeps track of are in
~/Library/Application Support/Gnucash, and if you're using online banking that's in ~/.aqbanking. I
don't think that any of that would have any impact on Bayesian matching, which is all kept in the data file,
though I suppose if you had to recreate aqbanking accounts you'd also have to re-associate them with
(Continue reading)


Gmane