Re: [GNC] Transaction matching on import

[Patrick]

Have you tried this?

In the next-to-last step of the CSV import wizard (the window is labeled
"Match Transactions"), double-click the transaction you want to manually
match and this will bring up a new window that will allow you to manually
match to an existing transaction.

One limitation of this approach seems to be that I am not able to update
the amount field of an existing transaction, as it doesn't give me the
option to match with an existing transaction that has a different amount
value, even if all of the other fields (including Transaction ID) are the
same. I am able to use this approach to update the description field of an
existing transaction, for example.

I am using GnuCash version 3.6.

Regards,
Patrick

> Is it possible to “manually match” a transaction when importing a transaction 
> , method of import does not matter, into an account? I’ve had a problem with 
> the importer making the wrong choice.
>
> Ken Schneider
___
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.

[GNC] gnucash 3.6 -- online price quotes retrieval not working

[Bruno Barros]

A while back my online quotes stopped working. I've gone through several
updates of gnucash and have kept finance::quote updated as well but I get
errors every time I try to update the security prices.
Anyone else still having this issue? Or have they found a solution I
haven't?

Thanks
Bruno

On Mon, Jul 8, 2019 at 5:05 AM  wrote:

> Send gnucash-user mailing list submissions to
> gnucash-user@gnucash.org
>
> To subscribe or unsubscribe via the World Wide Web, visit
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> or, via email, send a message with subject or body 'help' to
> gnucash-user-requ...@gnucash.org
>
> You can reach the person managing the list at
> gnucash-user-ow...@gnucash.org
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of gnucash-user digest..."
> Today's Topics:
>
>1. Re:  gnucash 3.6 -- reports -- "URL cannot be shown"
>   (Geert Janssens)
>2. Re:  gnucash 3.6 -- reports -- "URL cannot be shown"
>   (Harry G McGavran Jr)
>3.  Fwd: RE:  gnucash 3.6 -- reports -- "URL cannot be shown"
>   (Geert Janssens)
>4. Re:  gnucash 3.6 -- reports -- "URL cannot be shown"
>   (Geert Janssens)
>5. Re:  Import Price from CSV Bug? (Robin Chattopadhyay)
>   (David Carlson)
>6. Re:  gnucash 3.6 -- reports -- "URL cannot be shown"
>   (Harry G McGavran Jr)
>7. Re:  Import Price from CSV Bug? (Robin Chattopadhyay) (John Ralls)
>8. Re:  Import Price from CSV Bug? (Robin Chattopadhyay)
>   (David Carlson)
>9. Re:  gnucash 3.6 -- reports -- "URL cannot be shown" - SOLVED
>   (Harry G McGavran Jr)
>   10. Re:  Import Price from CSV Bug? (Robin Chattopadhyay)
>   (Robin Chattopadhyay)
>   11. Re:  gnucash 3.6 -- reports -- "URL cannot be shown" - SOLVED
>   (Harry G McGavran Jr)
>   12. Re:  Transaction matching on import (Patrick)
>
>
>
> -- Forwarded message --
> From: Geert Janssens 
> To: gnucash-user@gnucash.org, w5...@w5pny.com
> Cc:
> Bcc:
> Date: Sun, 07 Jul 2019 23:04:15 +0200
> Subject: Re: [GNC] gnucash 3.6 -- reports -- "URL cannot be shown"
> Unfortunately I don't know the reason of this failure. If the guid does
> exist,
> it may be that the gnc-register protocol failed to register with webkit.
>
> This is a protocol (similar to http or ftp) internal to gnucash and we use
> it
> to tell webkit to open an account register window. There are other similar
> protocols to open the report options windows, invoices/bills, customers/
> vendors,...
>
> If you go to the transaction report and click on the "Edit report options"
> link, does that work ?
>
> Geert
>
> Op zondag 7 juli 2019 21:04:51 CEST schreef Harry G McGavran Jr:
> > Here is the correct search for missing guids:
> >
> >
> > * 13:01:29  WARN  [gnc_load_app_icons()] No icon named
> > 'gnucash-icon' found. Some gui elements may be missing their icons
> > * 13:01:56 ERROR  [webkit_load_failed_cb()] WebKit load of
> > gnc-register:acct-guid=c354c0333b962e8e024562e6557942d6# failed due to
> > URL cannot be shown
> > * 13:01:56 ERROR <> guint
> > webkit_uri_response_get_status_code(WebKitURIResponse*): assertion
> > 'WEBKIT_IS_URI_RESPONSE(response)' failed
> > * 13:01:56 ERROR  [webkit_resource_load_failed_cb()] Load of
> > resource at gnc-register:acct-guid=c354c0333b962e8e024562e6557942d6#
> > failed with error URL cannot be shown and status code 0.
> >
> >
> > 
> >   Dogs
> >   c354c0333b962e8e024562e6557942d6
> >   EXPENSE
> >   
> > CURRENCY
> > USD
> >   
> >   100
> >   df746150c088e990c8ad8bb8d123fad4
> > 
> >
> >
> >
> >
> >
> > ___
> > 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.
>
>
>
>
>
>
>
>
> -- Forwarded message --
> From: Harry G McGavran Jr 
> To: gnucash-user@gnucash.org
> Cc:
> Bcc:
> Date: Sun, 7 Jul 2019 15:22:07 -0600
> Subject: Re: [GNC] gnucash 3.6 -- reports -- "URL cannot be shown"
> Hello Geert --
>
> >Unfortunately I don't know the reason of this failure. If the guid does
> exist,
> >it may be that the gnc-register protocol failed to register with webkit.
> >
> >This is a protocol (similar to http or ftp) internal to gnucash and we
> use it
> >to tell webkit to open an account register window. There are other similar
> >protocols to open the report options windows, invoices/bills, customers/
> >vendors,...
> >
> >If you go to the transaction report and click on the "Edit report options"
> >link, does that work ?
>
>   No -- it generates the same "URL cannot be shown"
>
> >
> >Geert
> >
>
> Thanks for your resp

[GNC] How to update Finance::Quote

[rsbrux via gnucash-user]

If this is the wrong venue for this question, please refer me to the 
correct one.


I am try to update my FInanace::Quote installation (under Ubuntu Studio 
18.04) to the latest version (1.49).


First I performed:

cpan -D Finance::Quote

as recommended in https://wiki.gnucash.org/wiki/CPAN.

It indicated that my CPAN was also out of date, so I first updated CPAN.

I then ran "upgrade Finance::Quote" from the cpan interactive prompt.?? 
This appears to have failed, as the cpan command above still shows F::Q 1.47


The output of the upgrade attempt was quite long and the beginning 
scrolled out of the terminal window.


Unfortunately, I am too ignorant to understand most of it.?? I have 
posted below the tail-end, which appear to reflect the installation of 
F::Q; preceeding parts appear to deal with (equally futile) attempts to 
install or upgrade other modules.


I intentionally ran cpan with normal privileges from my normal user 
account becaue I have read that suprivileges should only be needed to 
install or update CPAN and can otherwise be dangerous.


Must I install as su??? Is there something else I am missing here?

>>

?? You may have to su to root to install the package
?? (Or you may want to run something like
?? o conf make_install_make_command 'sudo make'
?? to raise your permissions.?? ECOCODE/Finance-Quote-1.49.tar.gz
?? Has already been unwrapped into directory 
/home/rbrooks/.cpan/build/Finance-Quote-1.49-0

?? ECOCODE/Finance-Quote-1.49.tar.gz
?? Has already been prepared
Running make for E/EC/ECOCODE/Finance-Quote-1.49.tar.gz
cp lib/Finance/Quote/NZX.pm blib/lib/Finance/Quote/NZX.pm
cp lib/Finance/Quote/MorningstarJP.pm 
blib/lib/Finance/Quote/MorningstarJP.pm
cp lib/Finance/Quote/Cdnfundlibrary.pm 
blib/lib/Finance/Quote/Cdnfundlibrary.pm

cp lib/Finance/Quote/IEXCloud.pm blib/lib/Finance/Quote/IEXCloud.pm
cp lib/Finance/Quote/Currencies.pm blib/lib/Finance/Quote/Currencies.pm
cp lib/Finance/Quote/DWS.pm blib/lib/Finance/Quote/DWS.pm
cp lib/Finance/Quote/Bourso.pm blib/lib/Finance/Quote/Bourso.pm
cp lib/Finance/Quote/IndiaMutual.pm blib/lib/Finance/Quote/IndiaMutual.pm
cp lib/Finance/Quote/FTPortfolios.pm blib/lib/Finance/Quote/FTPortfolios.pm
cp lib/Finance/Quote/ManInvestments.pm 
blib/lib/Finance/Quote/ManInvestments.pm

cp lib/Finance/Quote/Citywire.pm blib/lib/Finance/Quote/Citywire.pm
cp lib/Finance/Quote/Finanzpartner.pm 
blib/lib/Finance/Quote/Finanzpartner.pm

cp lib/Finance/Quote.pm blib/lib/Finance/Quote.pm
cp lib/Finance/Quote/Fidelity.pm blib/lib/Finance/Quote/Fidelity.pm
cp lib/Finance/Quote/BMONesbittBurns.pm 
blib/lib/Finance/Quote/BMONesbittBurns.pm

cp lib/Finance/Quote/LeRevenu.pm blib/lib/Finance/Quote/LeRevenu.pm
cp lib/Finance/Quote/HU.pm blib/lib/Finance/Quote/HU.pm
cp lib/Finance/Quote/AIAHK.pm blib/lib/Finance/Quote/AIAHK.pm
cp lib/Finance/Quote/Deka.pm blib/lib/Finance/Quote/Deka.pm
cp lib/Finance/Quote/Morningstar.pm blib/lib/Finance/Quote/Morningstar.pm
cp lib/Finance/Quote/ASEGR.pm blib/lib/Finance/Quote/ASEGR.pm
cp lib/Finance/Quote/MorningstarAU.pm 
blib/lib/Finance/Quote/MorningstarAU.pm
cp lib/Finance/Quote/FidelityFixed.pm 
blib/lib/Finance/Quote/FidelityFixed.pm

cp lib/Finance/Quote/BSERO.pm blib/lib/Finance/Quote/BSERO.pm
cp lib/Finance/Quote/HEX.pm blib/lib/Finance/Quote/HEX.pm
cp lib/Finance/Quote/Platinum.pm blib/lib/Finance/Quote/Platinum.pm
cp lib/Finance/Quote/CSE.pm blib/lib/Finance/Quote/CSE.pm
cp lib/Finance/Quote/MStaruk.pm blib/lib/Finance/Quote/MStaruk.pm
cp lib/Finance/Quote/GoldMoney.pm blib/lib/Finance/Quote/GoldMoney.pm
cp lib/Finance/Quote/FinanceCanada.pm 
blib/lib/Finance/Quote/FinanceCanada.pm
cp lib/Finance/Quote/MorningstarCH.pm 
blib/lib/Finance/Quote/MorningstarCH.pm

cp lib/Finance/Quote/ASX.pm blib/lib/Finance/Quote/ASX.pm
cp lib/Finance/Quote/AlphaVantage.pm blib/lib/Finance/Quote/AlphaVantage.pm
cp lib/Finance/Quote/FTfunds.pm blib/lib/Finance/Quote/FTfunds.pm
cp lib/Finance/Quote/Fool.pm blib/lib/Finance/Quote/Fool.pm
cp lib/Finance/Quote/AEX.pm blib/lib/Finance/Quote/AEX.pm
cp lib/Finance/Quote/Cominvest.pm blib/lib/Finance/Quote/Cominvest.pm
cp lib/Finance/Quote/VWD.pm blib/lib/Finance/Quote/VWD.pm
cp lib/Finance/Quote/Trustnet.pm blib/lib/Finance/Quote/Trustnet.pm
cp lib/Finance/Quote/SIXshares.pm blib/lib/Finance/Quote/SIXshares.pm
cp lib/Finance/Quote/YahooJSON.pm blib/lib/Finance/Quote/YahooJSON.pm
cp lib/Finance/Quote/StockHouseCanada.pm 
blib/lib/Finance/Quote/StockHouseCanada.pm

cp lib/Finance/Quote/Tdefunds.pm blib/lib/Finance/Quote/Tdefunds.pm
cp lib/Finance/Quote/UserAgent.pm blib/lib/Finance/Quote/UserAgent.pm
cp lib/GRTAGS blib/lib/GRTAGS
cp lib/Finance/Quote/TSP.pm blib/lib/Finance/Quote/TSP.pm
cp lib/Finance/Quote/ZA_UnitTrusts.pm 
blib/lib/Finance/Quote/ZA_UnitTrusts.pm

cp lib/Finance/Quote/USFedBonds.pm blib/lib/Finance/Quote/USFedBonds.pm
cp lib/Finance/Quote/SEB.pm blib/lib/Finance/Quote/SEB.pm
cp lib/Finance/Quote/SIXfunds.pm blib/lib/Finance/Quote/SIXfunds.pm
cp lib/GPATH blib/lib/GPATH
cp li

[GNC] Gnucash bug

[R. Victor Klassen]

Perhaps this has been fixed. I’m using 2.6.21 for production. 

Using SQLite I am expecting every transaction to hit disk immediately. 

Saturday we had a power failure and lost about five days’ worth of transactions 
including at least 10 invoices and three new customers.   

I think I can reconstruct. But I wouldn’t expect this to have happened. 

Sent from my iPhone
___
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.

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

[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?
-- 
"You are what you eat.  Be your Landscape!"

J onathan
Brian Francoeur

Landscape design, consultations, creation and care

Certified Horticultural Landscaper
,
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

___
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&view=article&id=53&Itemid=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.

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.

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

[Greg Feneis]

Seems like the following was meant for the OP.

Kind regards, Greg Feneis
(Pixel 3)


-- Forwarded message -
From: 
Date: Mon, Jul 8, 2019, 11:07
Subject: RE: [GNC] how to copy "Customers Overview" table for spreadsheet.
To: Greg Feneis 


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.

-Original Message-
From: gnucash-user  On
Behalf Of Greg Feneis via gnucash-user
Sent: Monday, July 8, 2019 11:22 PM
To: Gnucash Users 
Subject: Re: [GNC] how to copy "Customers Overview" table for spreadsheet.

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_Ye
> JmeoJALIQ/edit?hl=en_US
> >
> Certified Horticultural Landscaper
> <
> http://www.hcp.bc.ca/index.php?option=com_content&view=article&id=53&I
> temid=60
> >,
> Permaculture designer
>  rse/
> >,
> 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+S
> ooke+Rd
> .,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548
> f056f06cbad49: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.
___
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] Fwd: how to copy "Customers Overview" table for spreadsheet.

[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)

GnuCash can import this data, but can’t export it.

Regards,
Adrien

> 
> From: 
> 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@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] Gnucash bug

[Adrien Monteleone]

Is your data file local or on a network? If a network, there might be something 
that has interfered with the data being written. Also, be certain you’re 
accessing the current file and not a 5 day old backup. (usually the case in 
threads where users find data ‘missing’)

Regards,
Adrien

> On Jul 8, 2019, at 10:55 AM, R. Victor Klassen  wrote:
> 
> Perhaps this has been fixed. I’m using 2.6.21 for production. 
> 
> Using SQLite I am expecting every transaction to hit disk immediately. 
> 
> Saturday we had a power failure and lost about five days’ worth of 
> transactions including at least 10 invoices and three new customers.   
> 
> I think I can reconstruct. But I wouldn’t expect this to have happened. 
> 


___
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] gnucash 3.6 -- reports -- "URL cannot be shown" - SOLVED

[Adrien Monteleone]

Not sure I helped much as you pegged webkit2 from your first post.

However, you noted you had both webkit2gtk-3.0 & webkit2gtk-3.0-dev installed 
but only webkit2gtk-4.0 and not webkit2gtk-4.0-dev. I understand installing 
webkit2gtk-4.0-dev solved the problem, but I wonder if removing the 
webkit2gtk-4.0 non-dev version instead would have accomplished the same thing. 
That is, was webkit looking for a function in webkit2gtk-x.0-dev and defaulting 
to looking at the highest version installed? (I’d suspect it was using 
webkit2gtk-4.0 since it was there, and then not finding what it needed in 
webkit2gtk-4.0-dev because it wasn’t installed) If you only had webkit2gtk-3.0 
and webkit2gtk-3.0-dev installed, would it then work? (meaning the dependency 
list is technically correct)

Regards,
Adrien

> On Jul 7, 2019, at 7:11 PM, Harry G McGavran Jr  wrote:
> 
> FWIW:
> 
> "README.dependencies" for gnucash states:
> 
> webkitwebkitgtk-3.0 (Windows, Mac)
>   webkit2gtk-3.0 (Everything Else)
> 
> For Ubuntu Xenial, this is clearly wrong.
> webkit2gtk-4.0 is what is needed.
> 
> On 7/7/19 4:15 PM, Harry G McGavran Jr wrote:
>> SOLVED!
>> 
>> I had both libwebkit2gtk-3.0 and libwebkit2gkt-4.0 installed,
>> as well as libwebkit2gtk-3.0-dev.
>> 
>> I just noticed that libwebkit2gtk-4.0-dev was NOT installed.
>> 
>> So, I installed libwebkit2gtk-4.0-dev and rebuilt gnucash 3.6 from
>> scratch.  That seems to have fixed it. For some reason in reading the
>> docs, I thought I only needed libwebkit2gtk-3.0-dev version for gnucash.
>> That's obviously wrong.
>> 
>> At least its now fixed.
>> 
>> Loads of thanks to Adrien and Geert for helping me focus
>> on webkit2 as the likely culprit!
>> 
>> 


___
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] Balance Sheet-PNL

[Adrien Monteleone]

I wasn’t aware of that one.

There are two new reports with multi-period/comparison features in the Reports 
> Experimental menu. (one each for Balance Sheet & Income Statement)

Otherwise, you could create a traditional multi-column report with the Balance 
Sheet in one column and a P&L in the other.

Regards,
Adrien


> On Jul 5, 2019, at 7:47 AM, Stephen Camidge  wrote:
> 
> New report "Balance Sheet-PNL" combines a Balance Sheet and an Income 
> Statement in a single report.
> 
> 
> Where is it?

___
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] Moving invoice details to new invoice or job

[Adrien Monteleone]

Not that I’m aware of. I just poked around and couldn’t find anything like that 
either.

Also, be aware that ‘jobs’ are not an additional level of categorization. They 
should more properly be named ‘purchase orders’.

Regards,
Adrien

> On Jul 2, 2019, at 12:18 PM, WB5FDP  wrote:
> 
> In the past I have just deleted an entry on the invoice before it is posted
> and created it on a new invoice. I was thinking there must be a way to
> simply "move" a line-item to an existing invoice, under a different job.
> 
> 
> 
> Is this possible?
> 
> 
> 
> Rick
> 

___
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] gnucash 3.6 -- reports -- "URL cannot be shown" - SOLVED

[Harry G McGavran Jr]

Hi Adrien --

You may be correct -- I can't really test that though as I
have other software that depends on webkit2gtk-4.0 that will
get removed if I remove the runtime library to test a gnucash
build that way.

But it seems you may very well be correct.


>Not sure I helped much as you pegged webkit2 from your first post.
>
>However, you noted you had both webkit2gtk-3.0 & webkit2gtk-3.0-dev installed
>but only webkit2gtk-4.0 and not webkit2gtk-4.0-dev. I understand installing
>webkit2gtk-4.0-dev solved the problem, but I wonder if removing the
>webkit2gtk-4.0 non-dev version instead would have accomplished the same thing.
>That is, was webkit looking for a function in webkit2gtk-x.0-dev and defaulting
>to looking at the highest version installed? (I’d suspect it was using
>webkit2gtk-4.0 since it was there, and then not finding what it needed in
>webkit2gtk-4.0-dev because it wasn’t installed) If you only had webkit2gtk-3.0
>and webkit2gtk-3.0-dev installed, would it then work? (meaning the dependency
>list is technically correct)
>
>Regards,
>Adrien
>
___
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] Gnucash bug

[R. Victor Klassen]

Local file.  Not a backup.  Accessing a backup would be an XML issue.

> On Jul 8, 2019, at 3:48 PM, Adrien Monteleone 
>  wrote:
> 
> Is your data file local or on a network? If a network, there might be 
> something that has interfered with the data being written. Also, be certain 
> you’re accessing the current file and not a 5 day old backup. (usually the 
> case in threads where users find data ‘missing’)
> 
> Regards,
> Adrien
> 
>> On Jul 8, 2019, at 10:55 AM, R. Victor Klassen  wrote:
>> 
>> Perhaps this has been fixed. I’m using 2.6.21 for production. 
>> 
>> Using SQLite I am expecting every transaction to hit disk immediately. 
>> 
>> Saturday we had a power failure and lost about five days’ worth of 
>> transactions including at least 10 invoices and three new customers.   
>> 
>> I think I can reconstruct. But I wouldn’t expect this to have happened. 
>> 
> 
> 
> ___
> 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.

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

[D via gnucash-user]

Sorry. I thought I hit Reply All.

On July 9, 2019, at 1:07 AM, Greg Feneis  wrote:

Seems like the following was meant for the OP.

Kind regards, Greg Feneis
(Pixel 3)


-- Forwarded message -
From: 
Date: Mon, Jul 8, 2019, 11:07
Subject: RE: [GNC] how to copy "Customers Overview" table for spreadsheet.
To: Greg Feneis 


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.

-Original Message-
From: gnucash-user  On
Behalf Of Greg Feneis via gnucash-user
Sent: Monday, July 8, 2019 11:22 PM
To: Gnucash Users 
Subject: Re: [GNC] how to copy "Customers Overview" table for spreadsheet.

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_Ye
> JmeoJALIQ/edit?hl=en_US
> >
> Certified Horticultural Landscaper
> <
> http://www.hcp.bc.ca/index.php?option=com_content&view=article&id=53&I
> temid=60
> >,
> Permaculture designer
>  rse/
> >,
> 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+S
> ooke+Rd
> .,+Sooke,+BC+V9Z+0A8/@48.3819275,-123.708261,13z/data=!4m2!3m1!1s0x548
> f056f06cbad49: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.
___
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.

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

[D via gnucash-user]

Oh. Sorry for the noise. I clearly misunderstood.

David

On July 9, 2019, at 1:17 AM, Adrien Monteleone  
wrote:

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)

GnuCash can import this data, but can’t export it.

Regards,
Adrien

> 
> From: 
> 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@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.

Re: [GNC] Gnucash bug

[John Ralls]

> On 8 juil. 2019, at 08:55, R. Victor Klassen  wrote:
> 
> Perhaps this has been fixed. I’m using 2.6.21 for production. 
> 
> Using SQLite I am expecting every transaction to hit disk immediately. 
> 
> Saturday we had a power failure and lost about five days’ worth of 
> transactions including at least 10 invoices and three new customers.   
> 
> I think I can reconstruct. But I wouldn’t expect this to have happened. 

Were those 5 days worth of transactions all entered together or over the 5 
days? Do the transaction logs reflect the "lost" transactions? If so you can at 
least recover them by playing the transactions back
https://www.sqlite.org/howtocorrupt.html might shed some insight on what 
happened. 

Regards,
John Ralls

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