Respun 2.6.18 tarballs

2017-09-27 Thread John Ralls
Bug 788191 reported that the tarballs originally shipped with the release 
worked only with Guile-2.0. This turned out to be due to an error in SWIG 
that's in the version on Fedora 25 which I used to create those tarballs. I've 
re-spun the tarballs and the reporter of the bug has tested that they are now 
correct.

The re-spun tarballs also include src/optional/python-bindings/__init__.py, 
reported as missing by another user.

The sha256 hashes for the re-spun tarballs are:
68730bcfcead7485011eb43d3b2c5df032c714571c81f9a15d33d8494fc4249d  
gnucash-2.6.18-1.tar.bz2
f66e9e05c332182bd7aa23f9717d4bc32bcfaf2a1eb3a94287c88aeaa7e5894e  
gnucash-2.6.18-1.tar.gz

Note the -1 suffix. The links on www.gnucash.org have been updated.

Regards,
John Ralls

___
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 this by using Reply-To-List or Reply-All.


Re: Excel or CSV Import

2017-09-27 Thread Dan
You are saying that I canExport my Sales (Header and Detail) to Excel or 
CSV and then Import into GNUCASH?


Id there help on that?

Dan


On 9/27/2017 4:31 PM, David Carlson wrote:

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

-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.



___
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 this by using Reply-To-List or Reply-All.


Excel or CSV Import

2017-09-27 Thread Dan

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
-
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.


Re: Merging imported transactions

2017-09-27 Thread Warner Losh
The problem I have is that the bank has OFX files. But AmEx and PayPal do
not (well, AmEx does, but I'd have to pay extra and it's for a business
that's not making enough money to pay extra). I've hacked together some
python code so I can import transactions this way via csv lists (which I
wish there was an option to say 'use line 1 for the headings, they match
the strings you are expecting'). I don't want to DELETE one of the
transactions, I want to MERGE them. Why? Because the Bank side of the
transaction has the bank's confirmation number and some other information.
And the other side of the transaction has things like who the seller was
and what I bought. I'd like both bits of information preserved. And trying
to cut and paste between notes has proven to be somewhat difficult due to
GTK "issues"

I was able to do the QucikBooks 2007 -> GnuCash migration based on
https://lwn.net/Articles/729087/ coupled with several bug fixes for stupid
things like commas, two digit years, etc. I've been able to automate my
monthly rent transaction posting by copying old transactions and setting
the date. I haven't found a good python OFX parser yet, or I'd take a stab
at trying to match the transactions as well and create fully-formed entries.

With the OFX importing and python scripts, I was able to catch up with a
year backlog in a couple of hours, despite the difficulties (a chore that
usually takes me days). I'd hoped to find some way to take it a step
further to automate the tedium further (though to do that, I'd need some
kind of spider that downloads the data from three different sources as
well)... Maybe next month i'll try loading the .csv transactions first to
see if that helps...

Warner

On Mon, Sep 25, 2017 at 8:23 PM, David Carlson 
wrote:

> 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 I am less likely to be overwhelmed.
>
> The program is supposed to learn from previous imports and improve it's
> accuracy eventually, but in my experience it still seems to make a lot of
> mis-matches.  I still end up with duplicates when it fails to find the
> correct match or I just get tired of searching and just let the duplicates
> through.  I am less likely to miss a transaction if I use the import
> assistant, so I continue to use it.
>
> David C
>
> On Mon, Sep 25, 2017 at 11:00 AM, Warner Losh  wrote:
>
>> Greetings,
>>
>> I download all my transactions from my back in quickbooks OFX format. I
>> import them into gnu cash. This works well; however, I’ve hit a snag.
>>
>> I have a credit card, a paypal account and a bank account. These all have
>> different formats for downloading the data from, which I can convert to
>> something gnu cash can import. When I do this, though, I have a small
>> problem. The bank account comes in via OFX, so has lots of Imbalance-USD
>> entries. I’ve used this account for the import of some items from the
>> credit card and paypal accounts as well. So I wind up with a transaction in
>> the bank ledger that is a payment to the credit card, but doesn’t credit
>> that account. There’s also a separate transaction in the credit card that’s
>> a payment from the bank, but doesn’t debit the bank account. In a sense,
>> there’s two double entries I’d like to combine to eliminate the
>> Imbalance-USD account entirely since I don’t think that’s a real account
>> and find it sloppy book keeping. Is there anything I can use to merge
>> entries when I’m replying on downloading the bulk of the data rather than
>> entering it myself?
>>
>> Thanks for any help you can give me here.
>>
>> Warner
>>
>> ___
>> 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 this by using Reply-To-List or Reply-All.
>>
>
>
___
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 this by using Reply-To-List or Reply-All.