Still frustrated

[Art]

I found xl2qif a few years back and it was quite useful for importing my wife's paystub data from Excel into GnuCash, as well as several financial account spreadsheets.I think I just had to tweak some labels in the template and resolve a DOS vs. Unix file format issue with some of the data I was working with. I forgot if I just used Vi or programmatically did the stuff outside of Excel.I don't recall ever exporting anything useful from GnuCash. I've generated reports, but never did any export into external apps, just imports.I too emailed the author, but it didn't matter since I was satisfied with the code and I could tweak it. I can still access the GnuCash database because my back-end is MySQL, though I'm quite careful not to corrupt the database because critical entity are managed with the program vs. the database. - Art
      From: Allan <allanhasmail at gmail.com>
 To: gnucash-user at gnucash.org 
 Sent: Thursday, May 21, 2015 6:21 AM
 Subject: Re: Still frustrated
   
I chose to use GC because I thought it could be knit to other programs 
via it's import/export interfaces, and found this really very difficult, 
both as an accounting/business management problem and just getting 
import/export to work. I'll be working on this for several months no doubt.

On the later, I finally got the Libreoffice calc macro for QIF 
import/export at :
http://xl2qif.chez-alice.fr/calc2qif_en.php
to work. Sort of. No menu but Tools->Macros>(hunt around)->(run the 
ExportQIF).

Basically, turn off all the security when installing.

It seems to need a new maintainer and documentation (published email 
bounces). Not sure how to do that. A small group effort to that end 
would be welcome here. I found it extremely helpful, enough to justify 
using GC. I could use macro programming tips (or pointer to forum for 
this), where to add documentation paragraphs (though the link above 
provides the basics). Some template/example spreadsheets to address 
various very specific linkages would be a suggestion, i.e. I use 
Squareup.com for point of sale, and I might create a process to using 
the macro to import sales data/sales tax by jurisdiction/credit card 
fees into GC.

Allan



On 05/21/2015 07:42 AM, Peter von Kaehne wrote:
> No comment on anything else, but
>
> On 21 May 2015 04:17, Matt Humphreys <mickeymatt at aol.com> wrote:
>> I just wish the help files were more complete about
>> how to import items in various formats.
>

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