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

[Geert Janssens]

Op maandag 8 juli 2019 19:15:43 CEST schreef Jonathan Francoeur via gnucash-
user:
> I'd like to copy and paste the data from the "Customers Overview" table
> into a spreadsheet.  Any ideas how?

Sure:
* Select the table by dragging your mouse cursor over it (I only selected the 
table)
* Hit ctrl-C (or cmd-C on Macos)
* Open your spreadsheet and paste. At this point you may have to enter a few 
conversion parameters such as language, or number format.

I have just tested this with libreoffice on Fedora 29. Works like a charm 
though your mileage may vary with other spreadsheets.

Regards,

Geert


___
gnucash-user mailing list
gnucash-user@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.

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

[Adrien Monteleone]

The print function is disabled on that tab.

Even with it available, at best you’re going to get an ‘image’ pdf that still 
has to be OCRd and that is notoriously difficult with images of tables. (though 
there is some software out there that tries valiantly, it is still a trial and 
error process)

Another option is a screenshot, but still has the OCR problem.

Otherwise, parsing the data file is probably the best bet until an export 
function is written.

Regards,
Adrien

> On Jul 8, 2019, at 12:51 PM, Greg Feneis via gnucash-user 
>  wrote:
> 
> Perhaps you could use the print function to produce a *.PDF of it, then
> view it in a PDF viewer, and copy the table (use mouse cursor to select
> text) from the PDF viewer?
> 
> I've had limited success with copying tables from PDF documents (win 7,
> Adobe Reader to Word 2010 is typical) and pasting into other documents, but
> it could work. Perhaps you could even paste it into a spreadsheet app?
> 
> Kind regards, Greg Feneis
> (Pixel 3)
> 
> 
> On Mon, Jul 8, 2019, 10:19 Jonathan Francoeur via gnucash-user <
> gnucash-user@gnucash.org> wrote:
> 
>> I'd like to copy and paste the data from the "Customers Overview" table
>> into a spreadsheet.  Any ideas how?
>> --


___
gnucash-user mailing list
gnucash-user@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.

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

[Greg Feneis via gnucash-user]

Perhaps you could use the print function to produce a *.PDF of it, then
view it in a PDF viewer, and copy the table (use mouse cursor to select
text) from the PDF viewer?

I've had limited success with copying tables from PDF documents (win 7,
Adobe Reader to Word 2010 is typical) and pasting into other documents, but
it could work. Perhaps you could even paste it into a spreadsheet app?

Kind regards, Greg Feneis
(Pixel 3)


On Mon, Jul 8, 2019, 10:19 Jonathan Francoeur via gnucash-user <
gnucash-user@gnucash.org> wrote:

> I'd like to copy and paste the data from the "Customers Overview" table
> into a spreadsheet.  Any ideas how?
> --
> "You are what you eat.  Be your Landscape!"
> 
> J  >onathan
> Brian Francoeur
> 
> Landscape design, consultations, creation and care
> <
> https://docs.google.com/document/d/1lyjTLI4QVd_z-P6EPfxRqC22f6omfYt_YeJmeoJALIQ/edit?hl=en_US
> >
> Certified Horticultural Landscaper
> <
> http://www.hcp.bc.ca/index.php?option=com_content=article=53=60
> >,
> Permaculture designer
>  >,
> Sustainable gardener
>  and Organic
> Master Gardener
> .
> goedi...@gmail.com  tel:  (250) 642-0267
> eeLandscaping.blogspot.com 
> 6411 Sooke Rd., Sooke, B.C., Canada, V9Z-0A8
> <
> https://www.google.ca/maps/place/Everything+Edible+Landscaping,+6411+Sooke+Rd
> .,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548f056f06cbad49:0xddc41f6f5e57feb>
> ___
> gnucash-user mailing list
> gnucash-user@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@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.