[GNC] Fwd: how to copy "Customers Overview" table for spreadsheet.

[david whiting]

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 <geert.gnucash at kobaltwit.be>
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: <sunfish62 at yahoo.com>
> > > 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
> > gnucash-user at gnucash.org
> > 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
> gnucash-user at gnucash.org
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: customers.xslt
Type: application/xslt+xml
Size: 1402 bytes
Desc: not available
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20190730/ee55ef0e/attachment.xslt>