I'm a few pages into a book about xslt so I thought I'd give this a go. I'm sure it's not the best xslt and anyone who knows how to use xslt properly will probably feel unwell after looking at this, but it does seem to work, i.e. produce a summary html table with the customers overview info (and a few extra fields for extra points).
To use it gunzip your gnucash file or save it in uncompressed format (Edit -> Preferences -> General) then you can run it using xsltproc like this (assuming the name of your file is accounts.gnucash): xsltproc customers.xslt accounts.gnucash > customers.html (there's a version for windows called xsltproc.exe if you are using windows and there are other ways of running xslt stylesheets) Then you can view customers.html and copy and paste the info into a spreadsheet or whatever. David On Tue, 30 Jul 2019 at 17:52, Geert Janssens <[email protected]> wrote: > Op maandag 8 juli 2019 21:46:23 CEST schreef Adrien Monteleone: > > David, > > > > The OP was asking about the Customer Overview, not Customer Summary > Report. > > > > The Customer Summary Report doesn’t show the same info as the Customer > > Overview. Notably, customer ID, address, and phone#. The overview is > > essentially a table of *some* of the data for each customer like what > might > > be found if there were a way to export customers. (the same problem > exists > > for vendors) > > > Hmm, I made the same mixup. Please ignore my reply (still catching up on a > backlog of several weeks...). > > Regards, > > Geert > > > GnuCash can import this data, but can’t export it. > > > > Regards, > > Adrien > > > > > From: <[email protected]> > > > Date: Mon, Jul 8, 2019, 11:07 > > > > > > > > > > > > Have you tried highlighting the report contents and pasting into a > > > spreadsheet? In Windows, I can run the Customer Summary report, press > > > CTRL-A, CTRL-C , open a spreadsheet, and press CTRL-V. The results are > > > reasonably sane. I haven't tried on a Mac recently, but ISTR that it > > > worked > > > in a similar fashion there. > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > To update your subscription preferences or to unsubscribe: > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > If you are using Nabble or Gmane, please see > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- > > 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 > [email protected] > To update your subscription preferences or to unsubscribe: > https://lists.gnucash.org/mailman/listinfo/gnucash-user > If you are using Nabble or Gmane, please see > https://wiki.gnucash.org/wiki/Mailing_Lists for more information. > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. > -- David Whiting
customers.xslt
Description: application/xslt
_______________________________________________ gnucash-user mailing list [email protected] To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information. ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.
