Community | 16 Sep 14:31 2014
Picon

Gnucash 2.6.3: import CSV data: limit number of lines/rows?

Hi,

Is there any limit on how many lines/rows/records of data (csv-formated) I can import into Gnucash at a
given time?

I've just tried to import 2,889 lines of data and only a fraction got imported.

Cheers!

M.
_______________________________________________
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.
Chris Good | 16 Sep 12:40 2014
Picon
Picon

Re: gnucash-user Digest, Vol 138, Issue 22

Hi Andy,

I'm not sure this is the same problem as I wasn't able to see your original pastebin as it said it was deleted
when I tried to view it, but I was able to get over 'Access denied' error message when installing strawberry
perl and finance quote by turning off McAfee antivirus real time scanning. You might like to try turning
off your antivirus - I think It's worth a try anyway...

Regards,

Chris Good
> 
> Message: 11
> Date: Mon, 15 Sep 2014 18:18:35 -0400
> From: Andy Lavarre <alavarre <at> gmail.com>
> To: Geert Janssens <janssens-geert <at> telenet.be>
> Cc: gnucash-user <at> gnucash.org
> Subject: Re: Getting prices and quotes:
> Message-ID: <541765BB.6040709 <at> gmail.com>
> Content-Type: text/plain; charset=UTF-8
> 
> Geert, John hello:
> 
>> On 09/15/14 11:40, Geert Janssens wrote:
>> My test system in Windows XP
> My system is Windows 7
>>  Perhaps there are some permission issues on the system that prevent
>> perl from compiling Bit::Vector ?
> Indeed. Clicking on the file in the Exploder results in the reported
> behaviour.
> 
(Continue reading)

Tom Balazs | 16 Sep 10:25 2014
Picon

GnuCash Unable to Import Mutliple Currencies

From my research and from correspondence with Ngewi Fet
https://github.com/codinguser/gnucash-android/issues/216
it seems to me that anyone who has a GnuCash Desktop with multiple
currencies and later needs to import a QIF file with multiple currencies
will run into problems
This would include ANY QIF exported out of ANY application (Android phone,
IPhone, Macintosh, etc.)

Please read below and tell me if I understand this correctly.

Ngewi  wrote:
> QIF file has no place to record currency. When importing to GnuCash,
GnuCash
> lets you choose what currency they are in, and all transactions and
accounts in
> the QIF file would be treated as they are in that currency. If they don't
match
> the corresponding account currency in GnuCash, there may be a problem.

This is a problem. If I have created all my accounts correctly on GnuCash
Desktop and imported all them correctly to GnuCash Android. I will then
have:

1. GnuCash Desktop
1.A. Checking Account 1 (Currency A)
1.B. Checking Account 2 (Currency B)

2. GnuCash Android
2.A. Checking Account 1 (Currency A)
2.B. Checking Account 2 (Currency B)
(Continue reading)

Don Coleman | 16 Sep 08:12 2014

monthly (but not date based) income/expense report


I'd like to be able to generate a monthly report, but not based on a
strict calendar month (date based), but based on a somewhat arbitrary
scheme -- each transaction manually assigned to a particular month,
loosely related to the date.  This is actually for a couple of people
who have a shared bank account to pay shared bills.

Each transaction in the bank account is either a bill or a payment from
a person  (for their share of a particular month) -- so I assign each
transaction to certain months as appropriate. The bank account starts
with an initial deposit, and I want to make sure that each "month" is in
balance ... so I'd like a scheme for reconciling each "logical" month.

Currently I create a separate gnucash file for each year, and gnucash
accounts for the actual bank account *and* for each month.  When I
import the transactions from the bank, rather then assigning a bill to
"expenses/utilities/gas" for example, I instead assign them to "may", or
"june", etc.   So then when looking at the bank account, I can see that
each is in fact assigned to a month, and looking at each months account,
I can see that it ultimately reaches a 0 balance (or if not, I know to
figure out why)

Is there a way to do this in a standard way in gnucash?  It doesn't seem
to fit gnucash's concepts of a budget, nor  accounts payable nor account
receivable...

Thanks,
Don
_______________________________________________
gnucash-user mailing list
(Continue reading)

Tom Balazs | 16 Sep 08:05 2014
Picon

Unable to Import Transactions into GnuCash Desktop

I exported my accounts out of GnuCash Desktop
I imported those to my GnuCash Android
I created a couple of transactions.
I exported the QIF
I transferred that file to my desktop computer
I was unable to import that QIF (transactions) to my GnuCash Desktop.
And unfortunately GnuCash Desktop only says "an error occurred while
loading the QIF file". There is no additional information which might help
me resolve this problem.

GnuCash 2.6.3
GnuCash Android 1.4.3
Ubuntu 14
_______________________________________________
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.

Andy Lavarre | 16 Sep 00:18 2014
Picon

Re: Getting prices and quotes:

Geert, John hello:

On 09/15/14 11:40, Geert Janssens wrote:
> My test system in Windows XP 
My system is Windows 7
>   Perhaps there are some permission issues on the system that prevent
> perl from compiling Bit::Vector ? 
Indeed. Clicking on the file in the Exploder results in the reported
behaviour.

Similarly, opening a terminal as user and changing directory to ... \bin
and calling the file does likewise.

But /*right click on the terminal in the start menu, select Run as
Administrator  */and /then/ migrating to bin and calling the program
works better, but still not enough. The new pastebin is at

    http://pastebin.com/qKECFE8T

* It ran much better but still failed at line 351 with

    CC1.EXE HAS STOPPED RUNNING

    I clicked OK, and it carried on to line 437 with the same message,
and then failure.

* The admonition to

 1.
    * Run gnc-fq-check
(Continue reading)

Les | 15 Sep 19:04 2014
Picon

Currency Issues

Several days ago, I wrote to this list concerning problems regarding
exchange rates. (copy of email below).

In that email, I used terms such as folders and I should have used
accounts and sub-accounts.  But the facts are still the same. 

Could someone please assist in solving this problem?

Thanks,
Les

I have a bank with multiple currencies.  The primary currency for this
bank is HKD.  Within this account I have a folder "saving" and type is
cash.  Under "saving" is a folder "currency" with type cash and contains
several other folders: CNY, HKD, etc

Everything works fine except CNY does not roll up properly (it does not
maintain an exchange rate for CNY:HKD).  Is there a way to solve this? 
Using LMDE v 1403 and GC 2.4.13.

_______________________________________________
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.

Tom Balazs | 15 Sep 12:44 2014
Picon

GnuCash Android: Choosing Correct "Transfer Account"

I exported my accounts out of GnuCash Desktop and imported them into
GnuCash Android

The problem I had: Choosing the Correct "Transfer Account" for a
transaction.

I go to the supermarket
After paying I go to enter the transaction in GnuCash.
In GnuCash Android I I go to
Liabilities: Tom's Visa
Add transaction:
-  "Bob's Supermarket"
- Charge: $50
- Transfer Account: In here I only can choose
.....Assets: Current Assets:
.....Assests: Fixed Assetss:
.....Liabilities: Credit Card
.....Liabilities: Loans: Mortgage

What I need is "Expenses: Groceries". Why don't I find that?
Is it a problem with just scrolling down the list? I can't scroll down.

If I begin by going to
"Expenses: Groceries"
I still can't choose credit card
Here I see many accounts but not the "Liabilities: Tom's Credit Card" that
I'm looking for.
I see:
- Assets: Current Assets: xxx
- Assests: Fixed Assets: xxx
(Continue reading)

Tom Balazs | 15 Sep 09:20 2014
Picon

Accounts: Exported: Imported to GnuCash Android

I successfully exported my accounts out of GnuCash Desktop, transfered the
file to my phone and imported them to GnuCash Android:
. File / Export / Export Accounts
. Keep the default .XML format (Important Don't Choose .CSV)
. the exported file is a .gnucash file
. That is what you transfer to the phone and then import to GnuCash
_______________________________________________
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.

Colin Law | 14 Sep 14:21 2014
Picon

Re: GnuCash 2.4.10 on Debian wheezy - holding x11 channels

On 14 September 2014 10:21, Phil Reynolds
<phil-gnucash <at> tinsleyviaduct.com> wrote:
> On Sun, 14 Sep 2014 08:53:38 +0100
> Colin Law <clanlaw <at> gmail.com> wrote:
>
>> On 11 September 2014 10:56, Phil Reynolds
>> <phil-gnucash <at> tinsleyviaduct.com> wrote:
>> > I am running GnuCash on my laptop. When I want to use my desktop
>> > machine to access it, I do so via ssh. If I do ssh hostcame
>> > gnucash, it runs just fine, but is still holding 3 channels open
>> > after closing, according to the ssh debug. This means I have to do
>> > Ctrl-C to get the prompt back.
>> >
>> > Is this a known/fixable issue with GnuCash?
>>
>> I can't seem to find the details at the moment but I suspect this is
>> an X issue rather than gnucash.  I can't find the right keywords to
>> search for in launchpad.  See if you get the same symptoms running
>> other apps, gedit, firefox, nautilus, whatever.  Try a few and see if
>> any of them show the problem.
>
> Hmmm... suspect you may be right - gedit exhibits the problem too... I
> tried xterm, that was fine... I'll pursue this elsewhere.

I am sure there is a launchpad bug for it, but I can't find it.

Colin
_______________________________________________
gnucash-user mailing list
gnucash-user <at> gnucash.org
(Continue reading)

Steve | 14 Sep 06:35 2014
Picon

Having experienced all of the benefits...

of GnuCash, as a refugee fleeing from Quicken (and having briefly dabbled
with others in the interim), I'm certainly grateful for the substantive
experience of the current build.  I'm also grateful to those souls who have
spent their time and energies in putting together the package, maintaining
it, and improving it, all the while I sit back and enjoy the efforts of
their labor, without any cost to me, in time or money.

As I just picked up a new smartphone, having probably waited far too long to
do so, I have a real appreciation for the pace of technology and clearly it
will continue to head in that mobile direction.  Although I use, on and off,
the mobile app for GnuCash, and again am grateful to those who put together
the current version, it nonetheless is apparent to me, at least, that
without a robust mobile application of GnuCash, that does more than merely
offer the opportunity to export recorded transactions, the attractiveness of
GnuCash is bound to diminish and brush feathers with the dinosaur.

Perhaps there are those out there that are tinkering, seems to me if a
community exists, we should be marshalling our efforts to support the
venture (for those who have the skills, time and interest to pursue such),
as clearly that is where the wind is blowing... that in my cave like
existence I have not heard or seen of any such effort, is somewhat
concerning... and which prompted these words...

The current mobile application, draws increased heavy breathing, as each day
passes.

--
View this message in context: http://gnucash.1415818.n4.nabble.com/Having-experienced-all-of-the-benefits-tp4672807.html
Sent from the GnuCash - User mailing list archive at Nabble.com.
_______________________________________________
(Continue reading)


Gmane